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;
}
}
protected void lnk_genDtlRptA2_OnClick(object sender, EventArgs e)
{
string filename = "Planhier_Rate_Audit";
string[] sheetnames = { "rate_audit" };
string[] titles = { "Audit Information for Planhier Rates" };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string", "string", "string" } };
CAExcelRpt xlobj = new CAExcelRpt();
DataSet dsrptA2 = new DataSet();
dsrptA2 = BenhierDAL.getRateAuditReport();
xlobj.ExcelXMLRpt(dsrptA2, filename, sheetnames, titles, colsFormat);
}
protected void lnk_genDtlRptA1_OnClick(object sender, EventArgs e)
{
string filename = "Benefit_Hierarchy_Audit";
string[] sheetnames = { "ben_audit" };
string[] titles = { "Audit Information for Benefit Hierarchy" };
string[][] colsFormat = { new string[] { "string", "string", "string", "string", "string", "string", "string" } };
CAExcelRpt xlobj = new CAExcelRpt();
DataSet dsrptA1 = new DataSet();
dsrptA1 = BenhierDAL.getPlanhierAuditReport();
xlobj.ExcelXMLRpt(dsrptA1, filename, sheetnames, titles, colsFormat);
}
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;
}
}
