protected void bindDetailDups(int _chq)
{
lblDupDetDups.Visible = false;
grdvDupsDupDetails.Visible = false;
lblNote4.Visible = false;
CAClaimsDAL detObj3 = new CAClaimsDAL();
string _yrmo = detObj3.getLatestYRMOAdj();
DataSet ds1Dups = new DataSet();
ds1Dups.Clear();
ds1Dups = detObj3.GetDupCheckDetails(_yrmo, _chq);
if (ds1Dups.Tables[0].Rows.Count > 1)
{
lblDupDetDups.Visible = true;
grdvDupsDupDetails.Visible = true;
lblNote4.Visible = true;
grdvDupsDupDetails.DataSource = ds1Dups;
grdvDupsDupDetails.DataBind();
}
else
{
lblDupDetDups.Visible = false;
grdvDupsDupDetails.Visible = false;
lblNote4.Visible = false;
}
}
protected void btn_reconAgn_Click(object sender, EventArgs e)
{
CAClaimsDAL cobj = new CAClaimsDAL();
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
cobj.DeleteReconData(yrmo);
if (RptsImported())
{
AnthRecon.CAClaimsRecon(yrmo);
cobj.retainForcedAdj(yrmo);
ViewResult();
auditRecon(yrmo);
}
}
catch (Exception ex)
{
MultiView1.SetActiveView(view_main);
cobj.DeleteReconData(yrmo);
lbl_error.Text = "Error in re-reconciliation.<br />" + ex.Message;
}
}
protected void btn_reconcile_Click(object sender, EventArgs e)
{
checkPastRecon();
CAClaimsDAL cobj = new CAClaimsDAL();
string yrmo = ddlYrmo.SelectedItem.Text;
if (Page.IsValid)
{
lbl_error.Text = "";
try
{
string _monthList = AnthRecon.CheckReconOrder(yrmo, "CA");
if (_monthList.Equals(""))
{
if (RptsImported())
{
AnthRecon.CAClaimsRecon(yrmo);
ViewResult();
auditRecon(yrmo);
}
}
else
{
lbl_error.Text = "Reconciliation for " + _monthList + " not completed!";
}
}
catch (Exception ex)
{
MultiView1.SetActiveView(view_main);
cobj.DeleteReconData(yrmo);
lbl_error.Text = "Error - " + ex.Message;
}
}
}
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");
bindDupsAging();
bindUnmatchedAnthAging();
bindUnmatchedBOAAging();
bindAmntMisAging();
CAClaimsDAL yObj = new CAClaimsDAL();
string _yrmo = yObj.getLatestYRMOAdj();
if (!_yrmo.Equals("-1"))
{
lblH1.Text = " for YRMO - " + _yrmo;
lblH2.Text = " for YRMO - " + _yrmo;
lblH3.Text = " for YRMO - " + _yrmo;
lblH4.Text = " for YRMO - " + _yrmo;
lnkAdjCF.Text = "Generate Carry Forward Report with Aging for YRMO - " + _yrmo;
lnkAdjMatched.Text = "Generate Detail Report of matched and mismatched records for YRMO - " + _yrmo;
}
}
}
protected void lnk_genDtlRpt_OnClick(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
CAExcelRpt xlobj = new CAExcelRpt();
CAClaimsDAL caobj = new CAClaimsDAL();
DataSet dsFinal = new DataSet();
dsFinal.Clear();
DataSet ds = new DataSet();
ds.Clear();
string filename = "CA_Claims_Recon_detail_" + yrmo;
string[] sheetnames = { "matched_Check&Amt", "mismatched_Amounts", "unmatchedCheck_Anthem", "unmatchedCheck_BOA", "duplicate_checks" };
string[] titles = { "California Claims Reconciliation Matched Records by Check# and Amount for " + yrmo,
"California Claims Reconciliation Mismatched Amount Records for " + yrmo,
"California Claims Reconciliation Un-Matched Check Records from Anthem for " + yrmo,
"California Claims Reconciliation Un-Matched Check Records from BOA for " + yrmo,
"California Claims Reconciliation Duplicate Check Record Details for " + yrmo };
string[][] colsFormat = { new string[] { "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string", "decimal", "decimal" },
new string[] { "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string", "decimal", "decimal" },
new string[] { "checknum", "string", "string", "string", "string", "string", "string", "string", "decimal" },
new string[] { "checknum", "string", "string", "decimal" },
new string[] { "string", "checknum", "string", "string", "string", "string", "string", "string", "string", "string", "decimal", "decimal", "string" } };
try
{
ds = caobj.GetMatchedChecknAmtRecords(yrmo);
ds.Tables[0].TableName = "matchedTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[0].TableName = "matchedTableF";
ds.Clear();
ds = caobj.GetAmtMismatchCheckRecords(yrmo);
ds.Tables[0].TableName = "mismatchAmtTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[1].TableName = "mismatchAmtTableF";
ds.Clear();
ds = caobj.GetAnthMismatch(yrmo);
ds.Tables[0].TableName = "AnthUnmatchedTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[2].TableName = "AnthUnmatchedTableF";
ds.Clear();
ds = caobj.GetBOAMismatch(yrmo);
ds.Tables[0].TableName = "BOAUnmatchedTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[3].TableName = "BOAUnmatchedTableF";
ds.Clear();
ds = caobj.GetDupChecksDetails(yrmo);
ds.Tables[0].TableName = "DupDtlTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[4].TableName = "DupDtlTableF";
ds.Clear();
xlobj.ExcelXMLRpt(dsFinal, filename, sheetnames, titles, colsFormat);
}
catch (Exception ex)
{
lbl_error.Text = "Error in generating CA Claims Report of matched and mismatched records for YRMO - " + yrmo + "<br />" + ex.Message;
}
}
// CA Claims Recon
public static void CAClaimsRecon(string yrmo)
{
CAClaimsDAL cobj = new CAClaimsDAL();
cobj.SetAnthDup(yrmo);
cobj.SetBOADup(yrmo);
cobj.SetCurrentCF(yrmo);
cobj.UpdatePrevCF(yrmo);
cobj.SetReconciled(yrmo);
}
protected void bindDetailBOA(string prymo, int _chq)
{
CAClaimsDAL detObj2 = new CAClaimsDAL();
DataSet ds1BOA = new DataSet();
ds1BOA.Clear();
ds1BOA = detObj2.GetBOAMismatchAging(prymo, _chq);
dtvUnmatchedBOA.DataSource = ds1BOA;
dtvUnmatchedBOA.DataBind();
}
protected void bindDetailAmntMis(string prymo, int _chq)
{
CAClaimsDAL detObj = new CAClaimsDAL();
DataSet ds1 = new DataSet();
ds1.Clear();
ds1 = detObj.GetAmtMismatchAging(prymo, _chq);
dtvAmntMis.DataSource = ds1;
dtvAmntMis.DataBind();
}
protected void bindDetailAnth(string prymo, int _chq)
{
CAClaimsDAL detObj1 = new CAClaimsDAL();
DataSet ds1Anth = new DataSet();
ds1Anth.Clear();
ds1Anth = detObj1.GetAnthMismatchAging(prymo, _chq);
dtvAnth.DataSource = ds1Anth;
dtvAnth.DataBind();
}
protected void lnkAdjCF_OnClick(object sender, EventArgs e)
{
lblErrRep.Text = "";
CAClaimsDAL caobj = new CAClaimsDAL();
CAExcelRpt xlobj = new CAExcelRpt();
DataSet dsFinal = new DataSet();
dsFinal.Clear();
DataSet ds = new DataSet();
ds.Clear();
string yrmo = caobj.getLatestYRMOAdj();
string filename = "CA_Claims_CFAging_" + yrmo;
string[] sheetnames = { "mismatched_amounts_CF", "unmatched_Anthem_CF", "unmatched_BOA_CF", "duplicate_checks_CF" };
string[] titles = { "Mismatched Amount Carry Forwards with Aging for YRMO : " + yrmo, "Un-Matched Carry Forwards from Anthem with Aging for YRMO : " + yrmo, "Un-Matched Carry Forwards from BOA with Aging for YRMO : " + yrmo, "Duplicate Check Carry Forwards with Aging for YRMO : " + yrmo };
string[][] colsFormat = { new string[] { "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "string", "string", "decimal", "decimal", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "checknum", "string", "string", "decimal", "decimal", "decimal" }, new string[] { "string", "string", "string", "string", "checknum", "string", "string", "string", "string", "string", "decimal", "decimal", "decimal" } };
try
{
ds = caobj.GetAmtMismatchAging(yrmo);
ds.Tables[0].TableName = "matchTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[0].TableName = "matchTableF";
ds.Clear();
ds = caobj.GetAnthMismatchAging(yrmo);
ds.Tables[0].TableName = "AnthUnmatchTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[1].TableName = "AnthUnmatchTableF";
ds.Clear();
ds = caobj.GetBOAMismatchAging(yrmo);
ds.Tables[0].TableName = "BOAUnmatchTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[2].TableName = "BOAUnmatchTableF";
ds.Clear();
ds = caobj.GetDupsAging(yrmo);
ds.Tables[0].TableName = "DupTable";
dsFinal.Tables.Add(ds.Tables[0].Copy());
dsFinal.Tables[2].TableName = "DupTableF";
ds.Clear();
xlobj.ExcelXMLRpt(dsFinal, filename, sheetnames, titles, colsFormat);
}
catch (Exception ex)
{
lblErrRep.Text = "Error in generating Carry Forward report with aging for YRMO - " + yrmo + "<br />" + ex.Message;
}
}
protected void checkPastRecon()
{
CAClaimsDAL cobj = new CAClaimsDAL();
string _yrmo = ddlYrmo.SelectedItem.Text.ToString();
if (cobj.Reconciled(_yrmo))
{
MultiView1.SetActiveView(view_reconAgn);
lbl_reconAgn.Text = "Reconciled already for year-month (YRMO): " + _yrmo + ".<br /> Do you want to re-reconcile?";
}
else
{
lbl_error.Text = "";
MultiView1.SetActiveView(view_main);
}
}
protected void bindAmntMisAging()
{
DataSet ds = new DataSet();
ds.Clear();
CAClaimsDAL misObj = new CAClaimsDAL();
string yrmo = misObj.getLatestYRMOAdj();
if (!yrmo.Equals("-1"))
{
ds = misObj.GetAmtMismatchAgingAdj(yrmo);
//if (ds.Tables[0].Rows.Count > 0)
//{
grdvAmntMis.DataSource = ds;
grdvAmntMis.DataBind();
//}
}
}
protected void bindUnmatchedBOAAging()
{
DataSet ds = new DataSet();
ds.Clear();
CAClaimsDAL unBOAObj = new CAClaimsDAL();
string yrmo = unBOAObj.getLatestYRMOAdj();
if (!yrmo.Equals("-1"))
{
ds = unBOAObj.GetBOAMismatchAgingAdj(yrmo);
//if (ds.Tables[0].Rows.Count > 0)
//{
grdvUnmatchedBOA.DataSource = ds;
grdvUnmatchedBOA.DataBind();
//}
}
}
protected void bindDupsAging()
{
DataSet ds = new DataSet();
ds.Clear();
CAClaimsDAL dupObj = new CAClaimsDAL();
string yrmo = dupObj.getLatestYRMOAdj();
if (!yrmo.Equals("-1"))
{
ds = dupObj.GetDistinctDupsAgingAdj(yrmo);
//if (ds.Tables[0].Rows.Count > 0)
//{
grdvDups.DataSource = ds;
grdvDups.DataBind();
//}
}
}
private void SortGridView(string sortExpression, string direction, string source)
{
CAClaimsDAL sortObj = new CAClaimsDAL();
DataTable dt;
DataView dv;
string yrmo = sortObj.getLatestYRMOAdj();
switch (source)
{
case "AmntMisAging":
dt = sortObj.GetAmtMismatchAgingAdj(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvAmntMis.DataSource = dv;
grdvAmntMis.DataBind();
break;
case "UnmatchedAnthAging":
dt = sortObj.GetAnthMismatchAgingAdj(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvUnmatchedAnth.DataSource = dv;
grdvUnmatchedAnth.DataBind();
break;
case "UnmatchedBOAAging":
dt = sortObj.GetBOAMismatchAgingAdj(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvUnmatchedBOA.DataSource = dv;
grdvUnmatchedBOA.DataBind();
break;
case "DupsAging":
dt = sortObj.GetDistinctDupsAgingAdj(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvDups.DataSource = dv;
grdvDups.DataBind();
break;
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
CAClaimsDAL dObj = new CAClaimsDAL();
dObj.DeleteReconData(yrmo);
ClaimsRecon dobj1 = new ClaimsRecon();
dobj1.deleteForced(yrmo, "BOA");
ImportDAL iObj = new ImportDAL();
iObj.Rollback("BOA", yrmo);
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
void ViewResult()
{
CAClaimsDAL cobj = new CAClaimsDAL();
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
Boolean balanced;
balanced = cobj.Balanced(yrmo);
MultiView1.SetActiveView(view_result);
resultDiv.Visible = false;
CFDiv.Visible = false;
img_CF.ImageUrl = "~/styles/images/collapsed1.gif";
CFRptDiv.Visible = false;
img_dtl.ImageUrl = "~/styles/images/collapsed1.gif";
dtlDiv.Visible = false;
dtlRptDiv.Visible = false;
resultDiv.Visible = true;
CFDiv.Visible = true;
dtlDiv.Visible = true;
}
private void SortGridView(string sortExpression, string direction, string source)
{
DataTable dt;
DataView dv;
string yrmo = ddlYrmo.SelectedItem.Text;
CAClaimsDAL caobj = new CAClaimsDAL();
switch (source)
{
case "CF_match":
dt = caobj.GetAmtMismatchAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvCF_match.DataSource = dv;
grdvCF_match.DataBind();
break;
case "CF_unmatch_Anth":
dt = caobj.GetAnthMismatchAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvCF_unmatchAnth.DataSource = dv;
grdvCF_unmatchAnth.DataBind();
break;
case "CF_unmatch_BOA":
dt = caobj.GetBOAMismatchAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvCF_unmatchBOA.DataSource = dv;
grdvCF_unmatchBOA.DataBind();
break;
case "CF_Dup":
dt = caobj.GetDupsAging(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdvCF_Dup.DataSource = dv;
grdvCF_Dup.DataBind();
break;
case "DtlMatched":
dt = caobj.GetMatchedChecknAmtRecords(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlmat.DataSource = dv;
grdv_dtlmat.DataBind();
break;
case "DtlMismatch":
dt = caobj.GetAmtMismatchCheckRecords(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlmismat.DataSource = dv;
grdv_dtlmismat.DataBind();
break;
case "DtlUnMatchedAnth":
dt = caobj.GetAnthMismatch(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlunmatAnth.DataSource = dv;
grdv_dtlunmatAnth.DataBind();
break;
case "DtlUnMatchedBOA":
dt = caobj.GetBOAMismatch(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlunmatBOA.DataSource = dv;
grdv_dtlunmatBOA.DataBind();
break;
case "DtlDup":
dt = caobj.GetDupChecksDetails(yrmo).Tables[0];
dv = new DataView(dt);
dv.Sort = sortExpression + direction;
grdv_dtlDup.DataSource = dv;
grdv_dtlDup.DataBind();
break;
}
}
protected void bindResult(string _src)
{
DataSet ds = new DataSet();
ds.Clear();
string yrmo = ddlYrmo.SelectedItem.Text;
CAClaimsDAL caobj = new CAClaimsDAL();
switch (_src)
{
case "CF":
mismatchCF.Visible = false;
unmatchAnthCF.Visible = false;
unmatchBOACF.Visible = false;
DupCF.Visible = false;
ds = caobj.GetAmtMismatchAging(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
mismatchCF.Attributes.Add("style", "width:700px;height:50px");
}
else
{
mismatchCF.Attributes.Add("style", "width:700px;height:250px");
}
mismatchCF.Visible = true;
grdvCF_match.DataSource = ds;
grdvCF_match.DataBind();
ds.Clear();
ds = caobj.GetAnthMismatchAging(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
unmatchAnthCF.Attributes.Add("style", "width:700px;height:50px");
}
else
{
unmatchAnthCF.Attributes.Add("style", "width:700px;height:250px");
}
unmatchAnthCF.Visible = true;
grdvCF_unmatchAnth.DataSource = ds;
grdvCF_unmatchAnth.DataBind();
ds.Clear();
ds = caobj.GetBOAMismatchAging(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
unmatchBOACF.Attributes.Add("style", "width:700px;height:50px");
}
else
{
unmatchBOACF.Attributes.Add("style", "width:700px;height:250px");
}
unmatchBOACF.Visible = true;
grdvCF_unmatchBOA.DataSource = ds;
grdvCF_unmatchBOA.DataBind();
ds.Clear();
ds = caobj.GetDupsAging(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
DupCF.Attributes.Add("style", "width:700px;height:50px");
}
else
{
DupCF.Attributes.Add("style", "width:700px;height:250px");
}
DupCF.Visible = true;
grdvCF_Dup.DataSource = ds;
grdvCF_Dup.DataBind();
ds.Clear();
break;
case "detail":
matchDtl.Visible = false;
mismatchAmt.Visible = false;
unmatchAnthDtl.Visible = false;
unmatchBOADtl.Visible = false;
ds = caobj.GetMatchedChecknAmtRecords(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
matchDtl.Attributes.Add("style", "width:700px;height:50px");
}
else
{
matchDtl.Attributes.Add("style", "width:700px;height:250px");
}
matchDtl.Visible = true;
grdv_dtlmat.DataSource = ds;
grdv_dtlmat.DataBind();
ds.Clear();
ds = caobj.GetAmtMismatchCheckRecords(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
mismatchAmt.Attributes.Add("style", "width:700px;height:50px");
}
else
{
mismatchAmt.Attributes.Add("style", "width:700px;height:250px");
}
mismatchAmt.Visible = true;
grdv_dtlmismat.DataSource = ds;
grdv_dtlmismat.DataBind();
ds.Clear();
ds = caobj.GetAnthMismatch(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
unmatchAnthDtl.Attributes.Add("style", "width:700px;height:50px");
}
else
{
unmatchAnthDtl.Attributes.Add("style", "width:700px;height:250px");
}
unmatchAnthDtl.Visible = true;
grdv_dtlunmatAnth.DataSource = ds;
grdv_dtlunmatAnth.DataBind();
ds.Clear();
ds = caobj.GetBOAMismatch(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
unmatchBOADtl.Attributes.Add("style", "width:700px;height:50px");
}
else
{
unmatchBOADtl.Attributes.Add("style", "width:700px;height:250px");
}
unmatchBOADtl.Visible = true;
grdv_dtlunmatBOA.DataSource = ds;
grdv_dtlunmatBOA.DataBind();
ds.Clear();
ds = caobj.GetDupChecksDetails(yrmo);
if (ds.Tables[0].Rows.Count == 0)
{
DupDtl.Attributes.Add("style", "width:700px;height:50px");
}
else
{
DupDtl.Attributes.Add("style", "width:700px;height:250px");
}
DupDtl.Visible = true;
grdv_dtlDup.DataSource = ds;
grdv_dtlDup.DataBind();
break;
}
}
