/// <summary> /// Gets the string row values. /// </summary> /// <param name="claimData">The claim data.</param> /// <returns></returns> private static IEnumerable <string> GetStringRowValues(ModelComparisonReportDetails claimData) { return(new[] { claimData.ClaimData.NodeText, claimData.Count }); }
/// <summary> /// Generates the model compassion report. /// </summary> /// <param name="modelComparisonForPost">The model comparison for post.</param> /// <returns></returns> public ModelComparisonReport Generate(ModelComparisonReport modelComparisonForPost) { ModelComparisonReport modelComparisonReportData = new ModelComparisonReport(); // Initialize the Stored Procedure _databaseCommandObj = _databaseObj.GetStoredProcCommand("GetModelComparisonReport"); // Pass parameters to Stored Procedure(i.e., @ParamName), add values for _databaseObj.AddInParameter(_databaseCommandObj, "@SelectedModels ", DbType.String, modelComparisonForPost.SelectedModelList); _databaseObj.AddInParameter(_databaseCommandObj, "@IsDetailedView ", DbType.Int32, modelComparisonForPost.IsCheckedDetailLevel); _databaseObj.AddInParameter(_databaseCommandObj, "@DetailedViewAt ", DbType.Int32, modelComparisonForPost.DetailSelectValue); _databaseObj.AddInParameter(_databaseCommandObj, "@FacilityId ", DbType.Int32, modelComparisonForPost.FacilityId); _databaseObj.AddInParameter(_databaseCommandObj, "@DateType", DbType.Int32, modelComparisonForPost.DateType); _databaseObj.AddInParameter(_databaseCommandObj, "@DateFrom", DbType.DateTime, modelComparisonForPost.StartDate); _databaseObj.AddInParameter(_databaseCommandObj, "@DateTo", DbType.DateTime, modelComparisonForPost.EndDate); _databaseObj.AddInParameter(_databaseCommandObj, "@SelectCriteria", DbType.String, modelComparisonForPost.ClaimSearchCriteria); _databaseObj.AddInParameter(_databaseCommandObj, "@RequestedUserID", DbType.String, modelComparisonForPost.RequestedUserId); _databaseObj.AddInParameter(_databaseCommandObj, "@RequestedUserName", DbType.String, modelComparisonForPost.RequestedUserName); // Retrieve the results of the Stored Procedure in Data table _databaseCommandObj.CommandTimeout = 1000; DataSet modelComparisonDataSet = _databaseObj.ExecuteDataSet(_databaseCommandObj); if (modelComparisonDataSet.IsTableDataPopulated()) { List <ModelComparisonReportDetails> modelComparisonReportList = new List <ModelComparisonReportDetails>(); DataRowCollection modelComparisonRowCollection = modelComparisonDataSet.Tables[0].Rows; for (int indexCount = 0; indexCount < modelComparisonRowCollection.Count; indexCount++) { ModelComparisonReportDetails modelComparisonReportDetails = new ModelComparisonReportDetails(); DataRow modelComparisonRow = modelComparisonRowCollection[indexCount]; EvaluateableClaim claimData = new EvaluateableClaim { NodeText = DBNull.Value == modelComparisonRow["ModelName"] ? string.Empty : modelComparisonRow["ModelName"].ToString(), ModelId = DBNull.Value == modelComparisonRow["ModelId"] ? (int?)null : Convert.ToInt32(modelComparisonRow["ModelId"]), ClaimTotal = DBNull.Value == modelComparisonRow["ClaimTotalCharges"] ? (double?)null : Convert.ToDouble(modelComparisonRow["ClaimTotalCharges"]), AdjudicatedValue = DBNull.Value == modelComparisonRow["AdjudicatedValue"] ? (double?)null : Convert.ToDouble(modelComparisonRow["AdjudicatedValue"]), CalculatedAdjustment = DBNull.Value == modelComparisonRow["CalculatedAdjudtment"] ? (double?)null : Convert.ToDouble(modelComparisonRow["CalculatedAdjudtment"]), ActualPayment = DBNull.Value == modelComparisonRow["ActualPayment"] ? (double?)null : Convert.ToDouble(modelComparisonRow["ActualPayment"]), ActualAdjustment = DBNull.Value == modelComparisonRow["ActualAdjustment"] ? (double?)null : Convert.ToDouble(modelComparisonRow["ActualAdjustment"]), PatientResponsibility = DBNull.Value == modelComparisonRow["PatientResponsibility"] ? (double?)null : Convert.ToDouble(modelComparisonRow["PatientResponsibility"]), RemitAllowedAmt = DBNull.Value == modelComparisonRow["RemitAllowed"] ? (double?)null : Convert.ToDouble(modelComparisonRow["RemitAllowed"]), RemitNonCovered = DBNull.Value == modelComparisonRow["RemitNonCovered"] ? (double?)null : Convert.ToDouble(modelComparisonRow["RemitNonCovered"]), RemitContrAdj = DBNull.Value == modelComparisonRow["RemitNonCovered"] ? (double?)null : Convert.ToDouble(modelComparisonRow["RemitNonCovered"]), ContractualVariance = DBNull.Value == modelComparisonRow["ContractualVariance"] ? (double?)null : Convert.ToDouble(modelComparisonRow["ContractualVariance"]), PaymentVariance = DBNull.Value == modelComparisonRow["PaymentVariance"] ? (double?)null : Convert.ToDouble(modelComparisonRow["PaymentVariance"]), DetailedSelection = DBNull.Value == modelComparisonRow["DetailedSelection"] ? string.Empty : modelComparisonRow["DetailedSelection"].ToString() }; modelComparisonReportDetails.ClaimData = claimData; modelComparisonReportDetails.Count = DBNull.Value == modelComparisonRow["ClaimCount"] ? string.Empty : modelComparisonRow["ClaimCount"].ToString(); modelComparisonReportList.Add(modelComparisonReportDetails); } modelComparisonReportData.ModelComparisonData = modelComparisonReportList; } return(modelComparisonReportData); }
/// <summary> /// Gets the amount row values. /// </summary> /// <param name="claimData">The claim data.</param> /// <returns></returns> private static IList <double?> GetAmountRowValues(ModelComparisonReportDetails claimData) { return(new[] { claimData.ClaimData.ClaimTotal, claimData.ClaimData.AdjudicatedValue, claimData.ClaimData.ActualPayment, claimData.ClaimData.PatientResponsibility, claimData.ClaimData.RemitAllowedAmt, claimData.ClaimData.RemitNonCovered, claimData.ClaimData.CalculatedAdjustment, claimData.ClaimData.ActualAdjustment, claimData.ClaimData.ContractualVariance, claimData.ClaimData.PaymentVariance }); }