/// <summary>
/// Get claims by request name from procedure GetClaimsByRequestName
/// </summary>
/// <param name="claimAdjudicationReport"></param>
/// <param name="maxRecordLimitForExcelReport"></param>
/// <returns></returns>
private DataSet GetClaimsByRequestName(ClaimAdjudicationReport claimAdjudicationReport,
int maxRecordLimitForExcelReport)
{
string filterSetting = string.Empty;
//Checks for Payers, if payers exists stores it in DB
if (claimAdjudicationReport.PageSetting != null &&
claimAdjudicationReport.PageSetting.SearchCriteriaList != null &&
claimAdjudicationReport.PageSetting.SearchCriteriaList.Any())
{
filterSetting = claimAdjudicationReport.XmlSerialize();
}
// Initialize the Stored Procedure
_databaseCommandObj = _databaseObj.GetStoredProcCommand("GetClaimsByRequestName");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_databaseObj.AddInParameter(_databaseCommandObj, "@SelectCriteria ", DbType.String,
claimAdjudicationReport.ClaimSearchCriteria);
_databaseObj.AddInParameter(_databaseCommandObj, "@ModelId", DbType.Int64,
claimAdjudicationReport.ModelId);
_databaseObj.AddInParameter(_databaseCommandObj, "@DateType", DbType.Int32,
claimAdjudicationReport.DateType);
_databaseObj.AddInParameter(_databaseCommandObj, "@StartDate", DbType.DateTime,
claimAdjudicationReport.StartDate);
_databaseObj.AddInParameter(_databaseCommandObj, "@EndDate", DbType.DateTime,
claimAdjudicationReport.EndDate);
_databaseObj.AddInParameter(_databaseCommandObj, "@MaxRecordLimit", DbType.Int32,
maxRecordLimitForExcelReport);
_databaseObj.AddInParameter(_databaseCommandObj, "@IsSelectClaims", DbType.Boolean,
claimAdjudicationReport.IsSelectClaims);
//Added RequestedUserID and RequestedUserName with reference to HIPAA logging feature
_databaseObj.AddInParameter(_databaseCommandObj, "@RequestedUserID", DbType.String,
claimAdjudicationReport.RequestedUserId);
_databaseObj.AddInParameter(_databaseCommandObj, "@RequestedUserName", DbType.String,
claimAdjudicationReport.RequestedUserName);
_databaseObj.AddInParameter(_databaseCommandObj, "@UserId", DbType.Int32, claimAdjudicationReport.UserId);
_databaseObj.AddInParameter(_databaseCommandObj, "@Take", DbType.Int32,
claimAdjudicationReport.PageSetting != null
? claimAdjudicationReport.PageSetting.Take
: 50);
_databaseObj.AddInParameter(_databaseCommandObj, "@Skip", DbType.Int32,
claimAdjudicationReport.PageSetting != null
? claimAdjudicationReport.PageSetting.Skip
: 0);
_databaseObj.AddInParameter(_databaseCommandObj, "@SortField", DbType.String,
claimAdjudicationReport.PageSetting != null
? claimAdjudicationReport.PageSetting.SortField
: string.Empty);
_databaseObj.AddInParameter(_databaseCommandObj, "@SortDirection", DbType.String,
claimAdjudicationReport.PageSetting != null
? claimAdjudicationReport.PageSetting.SortDirection
: string.Empty);
_databaseObj.AddInParameter(_databaseCommandObj, "@FilterSearchCriteria", DbType.Xml, filterSetting);
// Retrieve the results of the Stored Procedure in Datatable
_databaseCommandObj.CommandTimeout = claimAdjudicationReport.CommandTimeoutForClaimAdjudication;
DataSet claimAdjudicationReportDataSet = _databaseObj.ExecuteDataSet(_databaseCommandObj);
return(claimAdjudicationReportDataSet);
}
