示例#1
0
 public ClaimsFullDetailModel GetAllClaimsWithServiceLines(int organizationId, int pageNumber, int pageSize, int?claimId, string patientIds, string fromDate, string toDate, string payerName, string sortColumn, string sortOrder, Nullable <int> claimStatusId)
 {
     SqlParameter[] parameters = { new SqlParameter("@OrganizationId", organizationId),
                                   new SqlParameter("@PageNumber",     pageNumber),
                                   new SqlParameter("@PageSize",       pageSize),
                                   new SqlParameter("@ClaimId",        claimId),
                                   new SqlParameter("@PatientIds",     patientIds),
                                   new SqlParameter("@FromDate",       fromDate),
                                   new SqlParameter("@ToDate",         toDate),
                                   new SqlParameter("@PayerName",      payerName),
                                   new SqlParameter("@SortColumn",     sortColumn),
                                   new SqlParameter("@SortOrder",      sortOrder),
                                   new SqlParameter("@ClaimStatusId",  claimStatusId) };
     return(_context.ExecStoredProcedureForAllClaimDetailsWithServiceLine(SQLObjects.CLM_GetAllClaimsWithServiceLines.ToString(), parameters.Length, parameters));
 }