protected void Page_Load(object sender, EventArgs e) { if (Int32.Parse(Session["mid"].ToString()) == 0 || Session["mid"] == null) { Response.Redirect("~/Home.aspx"); } if (!Page.IsPostBack) { string uname = HttpContext.Current.User.Identity.Name.ToString(); AdminBLL.InRole(uname, "M100", "M102"); bindDFAging(); bindDFRFAging(); bindDFRFmismatchAging(); ClaimsRecon yObj = new ClaimsRecon(); string _yrmo = yObj.latestReconYrmo(); if (!_yrmo.Equals("-1")) { lblH1.Text = " for YRMO - " + _yrmo; lblH2.Text = " for YRMO - " + _yrmo; lnkAdjCF1.Text = "Generate DFnoRF Carry Forward Report with Aging for YRMO - " + _yrmo; lnkAdjCF2.Text = "Generate DFRF Carry Forward Report with Aging for YRMO - " + _yrmo; lnkAdjCF3.Text = "Generate DFRF Amount mismatch Carry Forward Report with Aging for YRMO - " + _yrmo; lnkAdjMatched.Text = "Generate Detail Report of matched and mismatched records for YRMO - " + _yrmo; } } }
protected void btn_reconcile_Click(object sender, EventArgs e) { checkPastRecon(); string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; if (Page.IsValid) { ClaimsRecon cObj = new ClaimsRecon(); try { string _monthList = AnthRecon.CheckReconOrder(yrmo, "Non-CA"); if (_monthList.Equals("")) { if (RptsImported()) { //AnthRecon.matchDFCl(yrmo); cObj.rfdfFirstVerification(yrmo); cObj.CompareFRD_DFClaims(yrmo); ShowResult(); auditRecon(yrmo); } } else { lbl_error.Text = "Reconciliation for " + _monthList + " not completed!"; } } catch (Exception ex) { cObj.DeleteNCAReconData(yrmo); lbl_error.Text = "Error in reconciling<br />" + ex.Message; } } }
protected void btn_reconAgn_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; ClaimsRecon cObj1 = new ClaimsRecon(); try { cObj1.DeleteNCAReconData(yrmo); if (RptsImported()) { //AnthRecon.matchDFCl(yrmo); cObj1.rfdfFirstVerification(yrmo); cObj1.CompareFRD_DFClaims(yrmo); cObj1.retainForcedAdjNCA(yrmo); ShowResult(); auditRecon(yrmo); } } catch (Exception ex) { cObj1.DeleteNCAReconData(yrmo); lbl_error.Text = "Error in re-reconciliation.<br />" + ex.Message; } }
protected void bindDfRfAdjMM(string prymo, string _dcn) { lblDupDetmismatchDFRF.Visible = false; grdvDupDetailsmismatchDFRF.Visible = false; lblNote3.Visible = false; ClaimsRecon detObj2 = new ClaimsRecon(); string _yrmo = detObj2.latestReconYrmo(); DataSet ds2DFRF = new DataSet(); ds2DFRF.Clear(); ds2DFRF = detObj2.getMismatchCF(_yrmo, _dcn); if (ds2DFRF.Tables[0].Rows.Count > 1) { lblDupDetmismatchDFRF.Visible = true; grdvDupDetailsmismatchDFRF.Visible = true; lblNote3.Visible = true; grdvDupDetailsmismatchDFRF.DataSource = ds2DFRF; grdvDupDetailsmismatchDFRF.DataBind(); } else { lblDupDetmismatchDFRF.Visible = false; grdvDupDetailsmismatchDFRF.Visible = false; lblNote3.Visible = false; } }
protected void bindDfRfAdj(string prymo, string _dcn, string _ssn, string _uDate) { lblDupDetDFRF.Visible = false; grdvDupDetailsDFRF.Visible = false; lblNote2.Visible = false; ClaimsRecon detObj1 = new ClaimsRecon(); string _yrmo = detObj1.latestReconYrmo(); DataSet ds1DFRF = new DataSet(); ds1DFRF.Clear(); ds1DFRF = detObj1.DFRFAging(_yrmo, _dcn); if (ds1DFRF.Tables[0].Rows.Count > 0) { lblDupDetDFRF.Visible = true; grdvDupDetailsDFRF.Visible = true; lblNote2.Visible = true; grdvDupDetailsDFRF.DataSource = ds1DFRF; grdvDupDetailsDFRF.DataBind(); } else { lblDupDetDFRF.Visible = false; grdvDupDetailsDFRF.Visible = false; lblNote2.Visible = false; } DataSet ds2DFRF = new DataSet(); ds2DFRF = detObj1.DFRFAging(prymo, _ssn, _dcn, _uDate); if (ds2DFRF.Tables[0].Rows.Count == 1) { dtvDFRF.DataSource = ds2DFRF; dtvDFRF.DataBind(); } }
protected void lnkAdjCF3_OnClick(object sender, EventArgs e) { lblErrRep.Text = ""; ClaimsRecon repObj3 = new ClaimsRecon(); DataSet ds = new DataSet(); ds.Clear(); string yrmo = repObj3.latestReconYrmo(); string _prevYrmo = AnthRecon.prevYRMO(yrmo); string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo); DataSet dsmismatchCF = new DataSet(); dsmismatchCF.Clear(); string filename = "DFRF_Amount_Mismatch_Aging_" + yrmo; string[][] cols = { new string[] { "YRMO", "Claim ID", "Anthem DF Counter", "DFRF Counter", "Anthem DF Amount", "DFRF Amount", "Variance", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } }; string[][] colsFormat = { new string[] { "string", "string", "number", "number", "decimal", "decimal", "decimal", "decimal", "decimal", "decimal" } }; string[] sheetnames = { "Amount_mismatch_Aging" }; string[] titles = { "Aging Report of Amount mismatch Records for " + yrmo }; try { dsmismatchCF = repObj3.getMismatchCF(yrmo); ExcelReport.ExcelXMLRpt(dsmismatchCF, filename, sheetnames, titles, cols, colsFormat); } catch (Exception ex) { lblErrRep.Text = "Error in generating excel report" + ex.Message; } }
protected void lnkAdjCF2_OnClick(object sender, EventArgs e) { lblErrRep.Text = ""; ClaimsRecon repObj2 = new ClaimsRecon(); DataSet ds = new DataSet(); ds.Clear(); string yrmo = repObj2.latestReconYrmo(); string _prevYrmo = AnthRecon.prevYRMO(yrmo); string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo); DataSet dsSummary = new DataSet(); dsSummary.Clear(); string filename = "DF_RF_Aging_" + yrmo; string[][] cols = { new string[] { "YRMO", "Member ID", "DCN", "Last Update", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } }; string[][] colsFormat = { new string[] { "string", "string", "string", "string", "decimal", "decimal", "decimal", "decimal" } }; string[] sheetnames = { "DF_RF_Aging" }; string[] titles = { "Aging Report of records cleared from DF no RF, not cleared in DF/RF for " + yrmo }; string[] sumTitles = { "Summary Statistics for Aging Report", "Detail Aging Report" }; string[][] sumColsFormat = { new string[] { "string", "number", "number", "decimal", "decimal" } }; try { ds = repObj2.DFRFAging(yrmo); dsSummary = repObj2.getSummary(yrmo, "DFRF"); ExcelReport.ExcelXMLRpt(ds, filename, sheetnames, titles, cols, colsFormat, dsSummary, sumTitles, sumColsFormat); } catch (Exception ex) { lblErrRep.Text = "Error in generating excel report" + ex.Message; } }
protected void btn_xlDFRFmismatchAging_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text; string _prevYrmo = AnthRecon.prevYRMO(yrmo); string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo); ClaimsRecon repObj3 = new ClaimsRecon(); DataSet dsmismatchCF = new DataSet(); dsmismatchCF.Clear(); string filename = "DFRF_Amount_Mismatch_Aging_" + yrmo; string[][] cols = { new string[] { "YRMO", "Claim ID", "Anthem DF Counter", "DFRF Counter", "Anthem DF Amount", "DFRF Amount", "Variance", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } }; string[][] colsFormat = { new string[] { "string", "string", "number", "number", "decimal", "decimal", "decimal", "decimal", "decimal", "decimal" } }; string[] sheetnames = { "Amount_mismatch_Aging" }; string[] titles = { "Aging Report of Amount mismatch Records for " + yrmo }; try { dsmismatchCF = repObj3.getMismatchCF(yrmo); ExcelReport.ExcelXMLRpt(dsmismatchCF, filename, sheetnames, titles, cols, colsFormat); } catch (Exception ex) { MultiView1.SetActiveView(view_main); lbl_error.Text = "Error in generating excel report" + ex.Message; } }
protected void btn_xlDFAging_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text; string _prevYrmo = AnthRecon.prevYRMO(yrmo); string _priorYrmo = AnthRecon.prevYRMO(_prevYrmo); ClaimsRecon repObj1 = new ClaimsRecon(); DataSet ds = new DataSet(); ds.Clear(); DataSet dsSummary = new DataSet(); dsSummary.Clear(); string filename = "DF_no_RF_Aging_" + yrmo; string[][] cols = { new string[] { "YRMO", "SSN", "Claim #", "Name", "Service From Dt", "Service Thru Dt", "Paid date", "Claim Type", "Current YRMO (" + yrmo + ")", "Previous YRMO (" + _prevYrmo + ")", "Prior YRMO (" + _priorYrmo + " & less)" } }; string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" } }; string[] sheetnames = { "DF_no_RF_Aging" }; string[] titles = { "Aging Report of Open DFs not on Anthem's DF no RF report for " + yrmo }; string[] sumTitles = { "Summary Statistics for Aging Report", "Detail Aging Report" }; string[][] sumColsFormat = { new string[] { "string", "number", "number", "decimal", "decimal" } }; try { ds = repObj1.DFnoRFAging(yrmo); dsSummary = repObj1.getSummary(yrmo, "DFnoRF"); ExcelReport.ExcelXMLRpt(ds, filename, sheetnames, titles, cols, colsFormat, dsSummary, sumTitles, sumColsFormat); } catch (Exception ex) { MultiView1.SetActiveView(view_main); lbl_error.Text = "Error in generating excel report" + ex.Message; } }
protected void btn_xl_Click(Object sender, EventArgs e) { ClaimsRecon dobj = new ClaimsRecon(); string dcn = txtSearch.Text; DataSet ds = new DataSet(); ds.Clear(); string filename = "DCN_History"; string[][] cols = { new string[] { "Source", "YRMO", "Amount", "Reconciled" } }; string[][] colsFormat = { new string[] { "string", "string", "decimal", "string" } }; string[] sheetnames = { "DCN_history" }; string[] titles = { "DCN History" }; try { ds = dobj.GetDCNHistory(dcn); ExcelReport.ExcelXMLRpt(ds, filename, sheetnames, titles, cols, colsFormat); } catch (Exception ex) { lbl_error.Text = "Error in generating excel report" + ex.Message; } }
private void SortGridView(string sortExpression, string direction, string source) { ClaimsRecon repObj = new ClaimsRecon(); DataTable dt; DataView dv; string yrmo = repObj.latestReconYrmo(); switch (source) { case "DFAging": dt = repObj.DFnoRFAging(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvDFnoRF.DataSource = dv; grdvDFnoRF.DataBind(); break; case "DFRFAging": dt = repObj.DFRFAging(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvDFRF.DataSource = dv; grdvDFRF.DataBind(); break; case "DFRFmismatchAging": //dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0]; dt = repObj.getMismatchCF(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvmismatchDFRF.DataSource = dv; grdvmismatchDFRF.DataBind(); break; } }
protected void bindDfnoRfAdj(string prymo, string _dcn, string _ssn, string _pDate) { lblDupDetDFnoRF.Visible = false; grdvDupDetails.Visible = false; lblNote1.Visible = false; ClaimsRecon detObj = new ClaimsRecon(); string _yrmo = detObj.latestReconYrmo(); DataSet ds1 = new DataSet(); ds1.Clear(); ds1 = detObj.DFnoRFAging(_yrmo, _dcn); if (ds1.Tables[0].Rows.Count > 0) { lblDupDetDFnoRF.Visible = true; grdvDupDetails.Visible = true; lblNote1.Visible = true; grdvDupDetails.DataSource = ds1; grdvDupDetails.DataBind(); } else { lblDupDetDFnoRF.Visible = false; grdvDupDetails.Visible = false; lblNote1.Visible = false; } DataSet ds2 = new DataSet(); ds2 = detObj.DFnoRFAging(prymo, _ssn, _dcn, _pDate); if (ds2.Tables[0].Rows.Count == 1) { dtvDFnoRF.DataSource = ds2; dtvDFnoRF.DataBind(); } }
private void SortGridView(string sortExpression, string direction) { DataTable dt; DataView dv; ClaimsRecon dobj = new ClaimsRecon(); string dcn = txtSearch.Text; dt = dobj.GetDCNHistory(dcn).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvHistory.DataSource = dv; grdvHistory.DataBind(); }
protected void bindDFRFmismatchAging() { string yrmo = ddlYrmo.SelectedItem.Text; DataSet ds = new DataSet(); ClaimsRecon bobj1 = new ClaimsRecon(); ds = bobj1.getMismatchCF(yrmo); if (ds.Tables[0].Rows.Count > 0) { grdvDFRFmismatchAging.DataSource = ds; grdvDFRFmismatchAging.DataBind(); } }
protected void bindResult() { DataSet ds = new DataSet(); string yrmo = ddlYrmo.SelectedItem.Text.ToString(); ClaimsRecon eObj1 = new ClaimsRecon(); ds = eObj1.DF_DFRFClaimsRecon(yrmo); if (ds.Tables[0].Rows.Count > 0) { resultDiv.Visible = true; grdvResult.DataSource = ds; grdvResult.DataBind(); } }
protected void printReport(string _yrmo) { DataSet ds = new DataSet(); DataSet dsFinal = new DataSet(); dsFinal.Clear(); ClaimsRecon repObj = new ClaimsRecon(); string[][] cols = { new string[] { "YRMO", "Aging Report", "Claim ID", "Amount", "Source", "Notes", "User", "Date" }, new string[] { "YRMO", "Aging Report", "Claim ID", "Amount", "Source", "Notes", "User", "Date" }, new string[] { "YRMO", "Aging Report", "Claim ID", "Amount", "Source", "Notes", "User", "Date" }, new string[] { "YRMO", "Aging Report", "Claim ID", "Amount", "Source", "Notes", "User", "Date" } }; string[][] colsFormat = { new string[] { "string", "string", "string", "decimal", "string", "string", "string", "string" }, new string[] { "string", "string", "string", "decimal", "string", "string", "string", "string" }, new string[] { "string", "string", "string", "decimal", "string", "string", "string", "string" }, new string[] { "string", "string", "string", "decimal", "string", "string", "string", "string" } }; string[] sheetnames = { "MismatchAmounts_CF_Adjustments", "UnmatchedAnthem_CF_Adjustments", "UnmatchedBOA_CF_Adjustments", "Duplicate_CF_Adjustments" }; string[] titles = { "Mismatch Amount - CarryForward Adjustments for YRMO - " + _yrmo, "Unmatched Checks from Anthem - CarryForward Adjustments for YRMO - " + _yrmo, "Unmatched Checks from BOA - CarryForward Adjustments for YRMO - " + _yrmo, "Duplicate Check CarryForwards Adjustments for YRMO - " + _yrmo }; try { ds = repObj.generateAuditAdjReport(_yrmo, "MismatchAmounts"); ds.Tables[0].TableName = "amtMisTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[0].TableName = "amtMisTableF"; ds.Clear(); ds = repObj.generateAuditAdjReport(_yrmo, "AnthemMismatch"); ds.Tables[0].TableName = "anthMisTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[1].TableName = "anthMisTableF"; ds.Clear(); ds = repObj.generateAuditAdjReport(_yrmo, "BOAMismatch"); ds.Tables[0].TableName = "boaMisTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[1].TableName = "boaMisTableF"; ds.Clear(); ds = repObj.generateAuditAdjReport(_yrmo, "DuplicateChecks"); ds.Tables[0].TableName = "dupsTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[1].TableName = "dupsTableF"; ds.Clear(); ExcelReport.ExcelXMLRpt(dsFinal, "CA_CF_Recon_Adjustments_" + _yrmo, sheetnames, titles, cols, colsFormat); } finally { } }
protected void bindDFAging() { DataSet ds = new DataSet(); ClaimsRecon bobj = new ClaimsRecon(); string yrmo = bobj.latestReconYrmo(); if (!yrmo.Equals("-1")) { ds = bobj.DFnoRFAging(yrmo); //if (ds.Tables[0].Rows.Count > 0) //{ grdvDFnoRF.DataSource = ds; grdvDFnoRF.DataBind(); //} } }
protected void bindDFRFmismatchAging() { DataSet ds = new DataSet(); ClaimsRecon bobj1 = new ClaimsRecon(); string yrmo = bobj1.latestReconYrmo(); if (!yrmo.Equals("-1")) { ds = bobj1.getMismatchCF(yrmo); //if (ds.Tables[0].Rows.Count > 0) //{ grdvmismatchDFRF.DataSource = ds; grdvmismatchDFRF.DataBind(); //} } }
protected void btnSearch_Click(object sender, EventArgs e) { string dcn = txtSearch.Text; ClaimsRecon dobj = new ClaimsRecon(); DataSet ds = new DataSet(); ds.Clear(); ds = dobj.GetDCNHistory(dcn); //if (ds.Tables[0].Rows.Count == 0) //{ // historyDiv.Attributes.Add("style", "width:680px;height:50px;margin-top:20px;"); //} //else //{ // historyDiv.Attributes.Add("style", "width:700px;margin-top:20px;"); //} grdvHistory.DataSource = ds; grdvHistory.DataBind(); }
protected void btn_reimport_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; try { ClaimsRecon dObj = new ClaimsRecon(); dObj.DeleteNCAReconData(yrmo); dObj.deleteForced(yrmo, "DFRF"); ImportDAL iObj = new ImportDAL(); iObj.Rollback("DF", yrmo); MultiView1.SetActiveView(view_main); } catch (Exception ex) { lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message; } }
protected void printReport(string _yrmo) { DataSet ds = new DataSet(); DataSet dsFinal = new DataSet(); dsFinal.Clear(); ClaimsRecon repObj = new ClaimsRecon(); string[][] cols = { new string[] { "YRMO", "Aging Report", "Claim ID", "Amount", "Source", "Notes", "User", "Date" } }; string[][] colsFormat = { new string[] { "string", "string", "string", "decimal", "string", "string", "string", "string" } }; string[] sheetnames = { "DFnoRF_CF_Adjustments", "DFRF_CF_Adjustments", "Amount_Mismatch_CF_Adjustments" }; string[] titles = { "DFnoRF - CarryForward Adjustments for YRMO - " + _yrmo, "DFRF - CarryForwards Adjustments for YRMO - " + _yrmo, "DFRF Amount Mismatch - CarryForwards Adjustments for YRMO - " + _yrmo }; try { ds = repObj.generateAuditAdjReport(_yrmo, "DFnoRF"); ds.Tables[0].TableName = "dfnorfTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[0].TableName = "dfnorfTableF"; ds.Clear(); ds = repObj.generateAuditAdjReport(_yrmo, "DFRF"); ds.Tables[0].TableName = "dfrfTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[1].TableName = "dfrfTableF"; ds.Clear(); ds = repObj.generateAuditAdjReport(_yrmo, "DFRFmismatch"); ds.Tables[0].TableName = "dfrfMMTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[2].TableName = "dfrfMMTableF"; ds.Clear(); ExcelReport.ExcelXMLRpt(dsFinal, "NON_CA_CF_Recon_Adjustments_" + _yrmo, sheetnames, titles, cols, colsFormat); } finally { } }
protected void btnOK4_Click(object sender, EventArgs e) { string _Id; lblFErr4.Text = ""; try { string _notes = txtDesc4.Text; if (!cbxReconcile4.Checked) { lblerr4.Text = "* Required"; } else { GridViewRow gr = grdvDupsDupDetails.Rows[0]; _Id = gr.Cells[1].Text; ClaimsRecon adObject3 = new ClaimsRecon(); adObject3.updateForcedRecon(_Id, "DuplicateChecks", _notes, Session["userName"].ToString()); MultiView5.SetActiveView(dupAdj); bindDupsAging(); } } catch (Exception ex) { lblFErr4.Text = ex.Message; } finally { if (cbxReconcile4.Checked) { cbxReconcile4.Checked = false; } txtDesc4.Text = ""; lblerr4.Text = ""; } }
protected void btn_genRpt_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text; DataSet ds = new DataSet(); ds.Clear(); string[][] cols = { new string[] { "YRMO", "FRD Amount", "DF Amount", "Carry Forward Amount", " Variance" } }; string[][] colsFormat = { new string[] { "string", "decimal", "decimal", "decimal", "decimal" } }; string[] sheetnames = { "DFRF_Recon" }; string[] titles = { "Non CA Claims Reconciliation Report for YRMO - " + yrmo }; ClaimsRecon eObj = new ClaimsRecon(); try { ds = eObj.DF_DFRFClaimsRecon(yrmo); ExcelReport.ExcelXMLRpt(ds, "NonCA_Recon_" + yrmo, sheetnames, titles, cols, colsFormat); } catch (Exception ex) { MultiView1.SetActiveView(view_main); lbl_error.Text = "Error in generating excel report" + ex.Message; } }
//protected void grdvDupUnmatchedAnthDetails_OnRowCommand(object sender, GridViewCommandEventArgs e) //{ // if (e.CommandName.Equals("Select")) // { // int index = Convert.ToInt32(e.CommandArgument); // GridViewRow row = grdvDupUnmatchedAnthDetails.Rows[index]; // string _yrmo = row.Cells[1].Text; // string _ssn = row.Cells[2].Text; // string _dcn = row.Cells[3].Text; // string _updatedt = row.Cells[4].Text; // bindDetailAnth(_yrmo, _dcn, _ssn, _updatedt); // } //} //protected void grdvUnmatchedBOADupDetails_OnRowCommand(object sender, GridViewCommandEventArgs e) //{ // if (e.CommandName.Equals("Select")) // { // int index = Convert.ToInt32(e.CommandArgument); // GridViewRow row = grdvUnmatchedBOADupDetails.Rows[index]; // string _yrmo = row.Cells[1].Text; // string _ssn = row.Cells[2].Text; // string _dcn = row.Cells[3].Text; // string _updatedt = row.Cells[4].Text; // bindDetailBOA(_yrmo, _dcn, _ssn, _updatedt); // } //} //protected void grdvDupsDupDetails_OnRowCommand(object sender, GridViewCommandEventArgs e) //{ // if (e.CommandName.Equals("Select")) // { // int index = Convert.ToInt32(e.CommandArgument); // GridViewRow row = grdvDupsDupDetails.Rows[index]; // string _yrmo = row.Cells[1].Text; // string _ssn = row.Cells[2].Text; // string _dcn = row.Cells[3].Text; // string _updatedt = row.Cells[4].Text; // bindDetailDups(_yrmo, _dcn, _ssn, _updatedt); // } //} #endregion protected void btnOK1_Click(object sender, EventArgs e) { string _Id; lblFErr1.Text = ""; try { string _notes = txtDesc1.Text; if (!cbxReconcile1.Checked) { lblerr1.Text = "* Required"; } else { _Id = dtvAmntMis.Rows[3].Cells[1].Text; ClaimsRecon adObject = new ClaimsRecon(); adObject.updateForcedRecon(_Id, "MismatchAmounts", _notes, Session["userName"].ToString()); MultiView2.SetActiveView(amountMismatch); bindAmntMisAging(); } } catch (Exception ex) { lblFErr1.Text = ex.Message; } finally { if (cbxReconcile1.Checked) { cbxReconcile1.Checked = false; } txtDesc1.Text = ""; lblerr1.Text = ""; } }
protected void btnOK2_Click(object sender, EventArgs e) { string _Id; lblFErr2.Text = ""; try { string _notes = txtDesc2.Text; if (!cbxReconcile2.Checked) { lblerr2.Text = "* Required"; } else { _Id = dtvDFRF.Rows[2].Cells[1].Text; ClaimsRecon adObject1 = new ClaimsRecon(); adObject1.updateForcedRecon(_Id, "DFRF", _notes, Session["userName"].ToString()); MultiView3.SetActiveView(viewDFRF); bindDFRFAging(); } } catch (Exception ex) { lblFErr2.Text = ex.Message; } finally { if (cbxReconcile2.Checked) { cbxReconcile2.Checked = false; } txtDesc2.Text = ""; lblerr2.Text = ""; } }
protected void btnOK3_Click(object sender, EventArgs e) { string _Id; lblFErr3.Text = ""; try { string _notes = txtDesc3.Text; if (!cbxReconcile3.Checked) { lblerr3.Text = "* Required"; } else { _Id = dtvUnmatchedBOA.Rows[1].Cells[1].Text; ClaimsRecon adObject2 = new ClaimsRecon(); adObject2.updateForcedRecon(_Id, "BOAMismatch", _notes, Session["userName"].ToString()); MultiView4.SetActiveView(unmatchedBOA); bindUnmatchedBOAAging(); } } catch (Exception ex) { lblFErr3.Text = ex.Message; } finally { if (cbxReconcile3.Checked) { cbxReconcile3.Checked = false; } txtDesc3.Text = ""; lblerr3.Text = ""; } }
private void SortGridView(string sortExpression, string direction, string source) { ClaimsRecon repObj = new ClaimsRecon(); DataTable dt; DataView dv; string yrmo = ddlYrmo.SelectedItem.Text; switch (source) { case "recon": dt = repObj.DF_DFRFClaimsRecon(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvResult.DataSource = dv; grdvResult.DataBind(); break; case "DFAging": //dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0]; dt = repObj.DFnoRFAging(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvDFAging.DataSource = dv; grdvDFAging.DataBind(); break; case "DFRFAging": //dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0]; dt = repObj.DFRFAging(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvDFRFAging.DataSource = dv; grdvDFRFAging.DataBind(); break; case "DFRFmismatchAging": //dt = ReconDAL.getDFAgingRpt(yrmo).Tables[0]; dt = repObj.getMismatchCF(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvDFRFmismatchAging.DataSource = dv; grdvDFRFmismatchAging.DataBind(); break; case "recon_matched": dt = ReconDAL.getMatchedDCNAmnt(yrmo, "Matched").Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvMatched.DataSource = dv; grdvMatched.DataBind(); break; case "recon_mismatched": dt = ReconDAL.getMatchedDCNAmnt(yrmo, "UnMatched").Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvMatched.DataSource = dv; grdvMatched.DataBind(); break; case "recon_unmatchDFRF": dt = ReconDAL.getRFDFUM(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvUnmatchedDFRF.DataSource = dv; grdvUnmatchedDFRF.DataBind(); break; case "recon_unmatchAnth": dt = ReconDAL.getClaimsUM(yrmo).Tables[0]; dv = new DataView(dt); dv.Sort = sortExpression + direction; grdvUnmatchedAnth.DataSource = dv; grdvUnmatchedAnth.DataBind(); break; } }
protected void lnkAdjMatched_OnClick(object sender, EventArgs e) { lblErrRep.Text = ""; ClaimsRecon repObj3 = new ClaimsRecon(); DataSet ds = new DataSet(); DataSet dsFinal = new DataSet(); dsFinal.Clear(); string yrmo = repObj3.latestReconYrmo(); string filename = "DFRF_matched_mismatched_Details_" + yrmo; string[][] cols = { new string[] { "YRMO", "DCN", "Anthem Claims Amount", "DFRF Amount", "Variance" }, new string[] { "YRMO", "DCN", "Anthem Claims Amount", "DFRF Amount", "Variance" }, new string[] { "YRMO", "DCN", "Subscriber ID", "Paid Date", "DFRF Amount" }, new string[] { "YRMO", "DCN", "Subscriber ID", "Paid Date", "Anthem Claims Amount" }, new string[] { "Type", "Record Count", "Dups Count", "Total Count" } }; string[][] colsFormat = { new string[] { "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "string", "string", "decimal" }, new string[] { "string", "string", "string", "string", "decimal" }, new string[] { "string", "string", "string", "string" } }; string[] sheetnames = { "Matched_Records", "Mismatched_Records", "DFRF_with_no_matching_Anthem", "Anthem_with_no_matching_DFRF", "Records_Summary" }; string[] titles = { "DFRF Reconciliation Matched Records by DCN and Amount for " + yrmo, "DFRF Reconciliation Mismatched Records by Amount for " + yrmo, "DCN Records in DF/RF not in Anthem Claims for " + yrmo, "DCN records in Anthem Claims not in DF/RF for " + yrmo, "Summary of records from Anthem DF Report & DFRF Report for " + yrmo }; try { ds = ReconDAL.getMatchedDCNAmnt(yrmo, "Matched"); ds.Tables[0].TableName = "matchedTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[0].TableName = "matchedTableF"; ds.Clear(); ds = ReconDAL.getMatchedDCNAmnt(yrmo, "UnMatched"); ds.Tables[0].TableName = "mismatchedTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[1].TableName = "mismatchedTableF"; ds.Clear(); ds = ReconDAL.getRFDFUM(yrmo); ds.Tables[0].TableName = "unmatch_DFRFTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[2].TableName = "unmatch_DFRFTableF"; ds.Clear(); ds = ReconDAL.getClaimsUM(yrmo); ds.Tables[0].TableName = "unmatch_AnthTable"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[3].TableName = "unmatch_AnthTableF"; ds.Clear(); ds = RecordCount.SummaryRecordsFinal(yrmo); ds.Tables[0].TableName = "summRecords"; dsFinal.Tables.Add(ds.Tables[0].Copy()); dsFinal.Tables[4].TableName = "summRecordsF"; ds.Clear(); ExcelReport.ExcelXMLRpt(dsFinal, filename, sheetnames, titles, cols, colsFormat); } catch (Exception ex) { lblErrRep.Text = "Error in generating excel report" + ex.Message; } }