private void BindReport() { StringBuilder objste = new StringBuilder("-"); try { DoLog(objste, "Start"); DataSet dsSuperZones = OtherNewClass.AutoMail.AutoMailParams("collection", "", "", "", "", "", "", "", ""); DataTable dtsz = dsSuperZones.Tables[0]; DoLog(objste, "Get Super Zones Count >> " + dtsz.Rows.Count.ToString()); DataTable dt = dsSuperZones.Tables[1]; DoLog(objste, "Get Dates Count >> " + dt.Rows.Count.ToString()); DataTable dtmaildesc = dsSuperZones.Tables[2]; DoLog(objste, "Get Mail setting Count >> " + dtmaildesc.Rows.Count.ToString()); string FirstPath = string.Empty; string SecondPath = string.Empty; if (dt.Rows.Count > 1) { DoLog(objste, "Generating 2 Files"); FirstPath = "../AutoEmailAttachment/CollectionWklyRpt/" + Convert.ToDateTime(dt.Rows[0]["todate"].ToString()).ToString("MM_dd_yyyy_HH_MM") + "/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/"; SecondPath = "../AutoEmailAttachment/CollectionWklyRpt/" + Convert.ToDateTime(dt.Rows[1]["todate"].ToString()).ToString("MM_dd_yyyy_HH_MM") + "/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/"; DirectoryManagement(FirstPath); DoLog(objste, "First Directory Set >> " + FirstPath); DirectoryManagement(SecondPath); DoLog(objste, "Second Directory Set >> " + SecondPath); DataSet ds = BankReceiptPayment.Idv_Chetana_REP_Collection_Report(Convert.ToInt32(0), Convert.ToInt32(dt.Rows[0]["fy"].ToString()), Convert.ToDateTime(dt.Rows[0]["fromdate"].ToString()), Convert.ToDateTime(dt.Rows[0]["todate"].ToString()), ""); DoLog(objste, "First Dataset >> "); DataSet ds1 = BankReceiptPayment.Idv_Chetana_REP_Collection_Report(Convert.ToInt32(0), Convert.ToInt32(dt.Rows[1]["fy"].ToString()), Convert.ToDateTime(dt.Rows[1]["fromdate"].ToString()), Convert.ToDateTime(dt.Rows[1]["todate"].ToString()), ""); DoLog(objste, "Second Dataset >> "); Response.Write(generatefiles(ds, ds1, dtsz, dt.Rows[0]["fromdate"].ToString(), dt.Rows[0]["todate"].ToString(), dt.Rows[1]["fromdate"].ToString(), dt.Rows[1]["todate"].ToString(), FirstPath, SecondPath, dtmaildesc)); DoLog(objste, "Wrote Data >> "); } else { DoLog(objste, "Generating 1 File"); FirstPath = "../AutoEmailAttachment/CollectionWklyRpt/" + Convert.ToDateTime(dt.Rows[0]["todate"].ToString()).ToString("MM_dd_yyyy_HH_MM") + "/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/"; SecondPath = ""; DirectoryManagement(FirstPath); DataSet ds = BankReceiptPayment.Idv_Chetana_REP_Collection_Report(Convert.ToInt32(0), Convert.ToInt32(dt.Rows[0]["fy"].ToString()), Convert.ToDateTime(dt.Rows[0]["fromdate"].ToString()), Convert.ToDateTime(dt.Rows[0]["todate"].ToString()), ""); DoLog(objste, "Main Dataset >> "); Response.Write(generatefiles(ds, null, dtsz, dt.Rows[0]["fromdate"].ToString(), dt.Rows[0]["todate"].ToString(), dt.Rows[0]["fromdate"].ToString(), dt.Rows[0]["todate"].ToString(), FirstPath, SecondPath, dtmaildesc)); DoLog(objste, "Wrote Data >> "); } } catch (Exception wex) { Response.Write("Error >> " + DoLog(objste, "Error >> " + wex.Message).ToString()); } Response.End(); }
private void BindGrid() { try { frdate = txtFromDate.Text.Split('/')[2] + "/" + txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0]; todate = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0]; tdt = Convert.ToDateTime(todate); fdt = Convert.ToDateTime(frdate); if (tdt >= fdt) { DataSet ds = new DataSet(); if (rdWeek.Checked == true) { ds = BankReceiptPayment.Idv_Chetana_REP_Collection_Report(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), Convert.ToInt32(strFY), fdt, tdt, ""); if (ds.Tables[0].Rows.Count > 0) { btnexport.Visible = false; DataView dv1 = new DataView(ds.Tables[0]); Session["Data"] = dv1; FillReport(dv1); } else { MessageBox("Records Not Available "); } } else { //ds = BankReceiptPayment.Idv_Chetana_REP_Collection_Report(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), Convert.ToInt32(strFY), fdt, tdt, "mc"); ds = Other_Z.OtherBAL.GetCollectionReport(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), Convert.ToInt32(strFY), fdt, tdt, ddlMonth.SelectedItem.Value); Session["month"] = ds; if (ds.Tables[1].Rows.Count > 0) { months.DataSource = ds.Tables[1]; months.DataBind(); btnexport.Visible = true; //DataView dv = new DataView(ds.Tables[0]); //dv.RowFilter = "months=" + 3; //Monthgrid.DataSource = dv; //Monthgrid.DataBind(); } else { MessageBox("Records Not Available "); } } } else { MessageBox("From Date is greater than To Date"); } } catch (Exception ex) { MessageBox(ex.Message.ToString()); //txtbankcoder.Focus(); } }