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 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;
}
}
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;
}
}
