Database

List<StaffMemberPOCO> pocos =
    context.ExecuteStoreQuery<StaffMemberPOCO>("exec StaffSearch_sel @OverrideSecurity, @UserId, @SchoolYearId, @Name, @ContractorId, @SubcontractorId, @SiteId, @OrganizationRelationshipIds, @RoleTypeIds, @StaffMemberNeedsAllRoles",
            new SqlParameter("@OverrideSecurity", overrideSecurity),
            new SqlParameter("@UserId", userId),
            new SqlParameter("@SchoolYearId", schoolYearId),
            new SqlParameter("@Name", name ?? (object)DBNull.Value),
            new SqlParameter("@ContractorId", contractorId ?? (object)DBNull.Value),
            new SqlParameter("@SubcontractorId", subcontractor ?? (object)DBNull.Value),
            new SqlParameter("@SiteId", siteId ?? (object)DBNull.Value),
            new SqlParameter("@OrganizationRelationshipIds", organizationRelationshipIds == null || organizationRelationshipIds.Count() == 0 ? (object)DBNull.Value : string.Join(",", organizationRelationshipIds)),
            new SqlParameter("@RoleTypeIds", roleTypeIds == null ? (object)DBNull.Value : string.Join(",", roleTypeIds)),
            new SqlParameter("@StaffMemberNeedsAllRoles", staffMemberNeedsAllRoles),
            new SqlParameter("@Page", pageNumber),
            new SqlParameter("@RowsPerPage", rowsPerPage),
            //outputParm,
            new SqlParameter("@TotalRows", SqlDbType.Int) { Direction = ParameterDirection.Output },
            new SqlParameter("@SortExpression", sortExpression ?? (object)DBNull.Value),
            new SqlParameter("@SortDirection", sortDirection ?? (object)DBNull.Value)
            ).ToList();

totalRows = ((outputParm != null) && !DBNull.Value.Equals(outputParm)) ? int.Parse(outputParm.Value.ToString()) : 0;

Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied.

"exec StaffSearch_sel @OverrideSecurity,
@UserId, @SchoolYearId, @Name, @ContractorId, @SubcontractorId,
@SiteId, @OrganizationRelationshipIds, @RoleTypeIds,
@StaffMemberNeedsAllRoles, @TotalRows out"
                            ^^^^^^^^^^

FROM
    COMPLETEDORDERS co
    LEFT JOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = ba.BA_ID    -- I'm guessing the ID column for ba and sa;
    LEFT JOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = sa.SA_ID   -- change them to the correct column names.

SELECT 
    @CA_ID = CA_ID,
    @BA_ID = BA_ID,
    @SA_ID = SA_ID,
    @CIP_ID = CIP_ID,
    @CC_ID = CC_ID 
FROM 
    COMPLETEDORDERS 
WHERE 
    CompletedOrderID = @CompletedOrderID
;

vinay dahiya wrote:

i will interface fingerprint scanner with the server.

vinay dahiya wrote:

if u don't have knowledge about this..then don't reply..

vinay dahiya wrote:

lol....kid..

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]