public IEnumerable<ComplianceViewResult> GetComplianceReportRecordsExport(string AgencyId, string reportType) { DBFactory db; SqlDataReader rdr; List<ComplianceViewResult> data = null; string reportName = ""; try { db = new DBFactory(); switch (reportType) { case "NCRA": reportName = "MSI_spGetComplianceNCRAReportDataExport"; break; case "ORP": reportName = "MSI_spGetComplianceORPReportDataExport"; break; case "RC": reportName = "MSI_spGetComplianceRCReportDataExport"; break; case "SOA": reportName = "MSI_spGetComplianceSOAReportDataExport"; break; case "AAI": reportName = "MSI_spGetComplianceAAIReportDataExport"; break; case "NCP": reportName = "MSI_spGetComplianceNCPReportDataExport"; break; } //rdr = db.ExecuteReader("MSI_spGetComplianceNCRAReportDataExport", new SqlParameter("@AgencyId", AgencyId)); rdr = db.ExecuteReader(reportName, new SqlParameter("@AgencyId", AgencyId)); data = new List<ComplianceViewResult>(); ComplianceViewResult record; while (rdr.Read()) { record = new ComplianceViewResult(); record.AgencyId = rdr["AgencyId"].ToString(); record.AgencyName = rdr["AgencyName"].ToString(); record.LastName = rdr["LastName"].ToString(); record.FirstName = rdr["FirstName"].ToString(); record.Account = rdr["PIMSAccount"].ToString(); record.ComplaintID = rdr["ComPlaintId"].ToString(); record.HomePhone = rdr["HomePhone"].ToString(); record.WorkPhone = rdr["WorkPhone"].ToString(); record.LastFourSSN = rdr["LastFourSSN"].ToString(); record.MobilePhone = rdr["MobilePhone"].ToString(); record.Address = rdr["Address"].ToString(); record.City = rdr["City"].ToString(); record.State = rdr["State"].ToString(); record.Zip = rdr["Zip"].ToString(); record.CreditorName = rdr["CreditorName"].ToString(); record.DebtorIdentityVerified = rdr["DebtorIdentityVerifiedText"].ToString(); record.ContactMethod = rdr["ContactMethod"].ToString(); record.ContactTime = rdr["ContactTime"].ToString(); record.DebtProduct = rdr["DebtProduct"].ToString(); if (rdr["DebtPurchaseBalance"].ToString() != "") record.DebtPurchaseBalance = rdr["DebtPurchaseBalance"] == DBNull.Value ? Convert.ToDecimal(0.0) : Convert.ToDecimal(rdr["DebtPurchaseBalance"]); if (rdr["DebtCurrentBalance"].ToString() != "") record.DebtCurrentBalance = rdr["DebtCurrentBalance"] == DBNull.Value ? Convert.ToDecimal(0.0) : Convert.ToDecimal(rdr["DebtCurrentBalance"]); record.DisputeDebt = rdr["DisputeDebtText"].ToString(); record.DisputeDebtAmount = rdr["DisputeDebtAmountText"].ToString(); record.DisputeDebtDueDate = rdr["DisputeDebtDueDateText"].ToString(); record.ComplaintID = rdr["ComplaintId"].ToString(); if (rdr["ComplaintDate"] != DBNull.Value) record.ComplaintDate = Convert.ToDateTime(rdr["ComplaintDate"]); record.ComplaintReceivedByMethod = rdr["ComplaintReceivedByMethod"].ToString(); record.ComplaintIssue = rdr["ComplaintIssue"].ToString(); record.ComplaintNotes = rdr["ComplaintNotes"].ToString(); record.ComplaintSubmitedToAgency = rdr["ComplaintSubmitedToAgencyText"].ToString(); if (rdr["ComplaintSubmitedToAgencyDate"] != DBNull.Value) record.ComplaintSubmitedToAgencyDate = Convert.ToDateTime(rdr["ComplaintSubmitedToAgencyDate"]); record.MoreInfoReqdFromDebtor = rdr["MoreInfoReqdFromDebtorText"].ToString(); if (rdr["MoreInfoRequestedDate"] != DBNull.Value) record.MoreInfoRequestedDate = Convert.ToDateTime(rdr["MoreInfoRequestedDate"]); record.MoreInfoRequested = rdr["MoreInfoRequested"].ToString(); record.MoreInfoReceivedFromDebtor = rdr["MoreInfoReceivedFromDebtorText"].ToString(); if (rdr["MoreInfoReceivedDate"] != DBNull.Value) record.MoreInfoReceivedDate = Convert.ToDateTime(rdr["MoreInfoReceivedDate"]); record.MoreInfoReceived = rdr["MoreInfoReceived"].ToString(); record.ComplaintSubmittedToOwner = rdr["ComplaintSubmittedToOwnerText"].ToString(); if (rdr["ComplaintSubmittedDate"] != DBNull.Value) record.ComplaintSubmittedDate = Convert.ToDateTime(rdr["ComplaintSubmittedDate"]); record.TimeToSubmitDays = rdr["TimeToSubmitDays"].ToString(); record.MoreInfoFromAgency = rdr["MoreInfoFromAgencyText"].ToString(); if (rdr["MoreInfoFromAgencyRequestedDate"] != DBNull.Value) record.MoreInfoFromAgencyRequestedDate = Convert.ToDateTime(rdr["MoreInfoFromAgencyRequestedDate"]); record.MoreInfoFromAgencyRequested = rdr["MoreInfoFromAgencyRequested"].ToString(); record.MoreInfoFromAgencyReceived = rdr["MoreInfoFromAgencyReceived"].ToString(); if (rdr["MoreInfoFromAgencyReceivedDate"] != DBNull.Value) record.MoreInfoFromAgencyReceivedDate = Convert.ToDateTime(rdr["MoreInfoFromAgencyReceivedDate"]); record.OwnerResponse = rdr["OwnerResponse"].ToString(); if (rdr["OwnerResponseDate"] != DBNull.Value) record.OwnerResponseDate = Convert.ToDateTime(rdr["OwnerResponseDate"]); record.OwnerResponseDays = rdr["OwnerResponseDays"].ToString(); if (rdr["AgencyResponseToDebtorDate"] != DBNull.Value) record.AgencyResponseToDebtorDate = Convert.ToDateTime(rdr["AgencyResponseToDebtorDate"]); record.TotalResponseTimeDays = rdr["TotalResponseTimeDays"].ToString(); record.DebtorAgree = rdr["DebtorAgreeText"].ToString(); record.NeedFurtherAction = rdr["NeedFurtherActionText"].ToString(); record.FinalActionStep = rdr["FinalActionStep"].ToString(); record.IsViewedByOwner = rdr["IsViewedByOwnerText"].ToString(); record.IsViewedByAgency = rdr["IsViewedByAgencyText"].ToString(); record.CreatedBy = rdr["CreatedBy"].ToString(); if (record.DebtPurchaseBalance == Convert.ToDecimal(0.0)) { record.DebtPurchaseBalance = null; } if (record.DebtCurrentBalance == Convert.ToDecimal(0.0)) { record.DebtCurrentBalance = null; } if (record.ComplaintDate.ToString() == "1/1/1900 12:00:00 AM") { record.ComplaintDate = null; } if (record.ComplaintSubmitedToAgencyDate.ToString() == "1/1/1900 12:00:00 AM") { record.ComplaintSubmitedToAgencyDate = null; } if (record.MoreInfoRequestedDate.ToString() == "1/1/1900 12:00:00 AM") { record.MoreInfoRequestedDate = null; } if (record.MoreInfoReceivedDate.ToString() == "1/1/1900 12:00:00 AM") { record.MoreInfoReceivedDate = null; } if (record.ComplaintSubmittedDate.ToString() == "1/1/1900 12:00:00 AM") { record.ComplaintSubmittedDate = null; } if (record.MoreInfoFromAgencyRequestedDate.ToString() == "1/1/1900 12:00:00 AM") { record.MoreInfoFromAgencyRequestedDate = null; } if (record.MoreInfoFromAgencyReceivedDate.ToString() == "1/1/1900 12:00:00 AM") { record.MoreInfoFromAgencyReceivedDate = null; } if (record.OwnerResponseDate.ToString() == "1/1/1900 12:00:00 AM") { record.OwnerResponseDate = null; } if (record.AgencyResponseToDebtorDate.ToString() == "1/1/1900 12:00:00 AM") { record.AgencyResponseToDebtorDate = null; } data.Add(record); } //Close the datareader rdr.Close(); } catch (Exception ex) { throw new Exception("Exception in DataQueries.GetComplianceNCRAReportRecords:" + ex.Message); } return data.AsEnumerable<ComplianceViewResult>(); }
public IEnumerable<ComplianceViewResult> GetComplianceReportRecords(string AgencyId, string reportType) { DBFactory db; SqlDataReader rdr = null; string reportName = ""; List<ComplianceViewResult> data = null; try { db = new DBFactory(); switch (reportType) { case "NCRA": reportName = "MSI_spGetComplianceNCRAReportData"; break; case "ORP": reportName = "MSI_spGetComplianceORPReportData"; break; case "RC": reportName = "MSI_spGetComplianceRCReportData"; break; case "SOA": reportName = "MSI_spGetComplianceSOAReportData"; break; case "AAI": reportName = "MSI_spGetComplianceAAIReportData"; break; case "NCP": reportName = "MSI_spGetComplianceNCPReportData"; break; } rdr = db.ExecuteReader(reportName, new SqlParameter("@AgencyId", AgencyId)); data = new List<ComplianceViewResult>(); ComplianceViewResult record; while (rdr.Read()) { record = new ComplianceViewResult(); record.AgencyId = rdr["AgencyId"].ToString(); record.ComplaintID = rdr["ComPlaintId"].ToString(); record.Account = rdr["PIMSAccount"].ToString(); record.LastName = rdr["LastName"].ToString(); record.FirstName = rdr["FirstName"].ToString(); record.LastFourSSN = rdr["LastFourSSN"].ToString(); if (rdr["ComplaintDate"] != DBNull.Value) record.ComplaintDate = Convert.ToDateTime(rdr["ComplaintDate"]); if (rdr["MoreInfoRequestedDate"] != DBNull.Value) record.MoreInfoRequestedDate = Convert.ToDateTime(rdr["MoreInfoRequestedDate"]); if (rdr["ComplaintSubmittedDate"] != DBNull.Value) record.ComplaintSubmittedDate = Convert.ToDateTime(rdr["ComplaintSubmittedDate"]); if (rdr["AgencyResponseToDebtorDate"] != DBNull.Value) record.AgencyResponseToDebtorDate = Convert.ToDateTime(rdr["AgencyResponseToDebtorDate"]); if (rdr["TotalResponseTimeDays"] != DBNull.Value) record.TotalResponseTimeDays = rdr["TotalResponseTimeDays"].ToString(); if (record.ComplaintDate.ToString() == "1/1/1900 12:00:00 AM") { record.ComplaintDate = null; } if (record.MoreInfoRequestedDate.ToString() == "1/1/1900 12:00:00 AM") { record.MoreInfoRequestedDate = null; } if (record.ComplaintSubmittedDate.ToString() == "1/1/1900 12:00:00 AM") { record.ComplaintSubmittedDate = null; } if (record.AgencyResponseToDebtorDate.ToString() == "1/1/1900 12:00:00 AM") { record.AgencyResponseToDebtorDate = null; } data.Add(record); } //Close the datareader rdr.Close(); } catch (Exception ex) { throw new Exception("Exception in DataQueries.ReportType:" + reportType + "GetComplianceReportRecords:" + ex.Message); } return data.AsEnumerable<ComplianceViewResult>(); }