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