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