protected void btnGenerateSalesDetails_Click(object sender, EventArgs e)
{
string path1 = Server.MapPath("PDF-Files");
string filename1 = path1 + "/Report2_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf";
// if file exists delete old report first.
if (File.Exists(filename1))
{
File.Delete(filename1);
}
DataTable dt = new DataTable();
string dates = Convert.ToString(drreportdate1.Text);
string[] fromdate = dates.Substring(0, 10).Split('/');
string fromdate1 = (DateTime.Parse(string.Format("{0}/{1}/{2}", fromdate[1], fromdate[0], fromdate[2]))).ToString("yyyy-MM-dd"); // convert to database date format.
string[] todate = dates.Substring(13, 10).Split('/');
string todate1 = (DateTime.Parse(string.Format("{0}/{1}/{2}", todate[1], todate[0], todate[2]))).ToString("yyyy-MM-dd"); // convert to database date format.
dt = VPCRMSBAL.GetReportDataSalesDetails(fromdate1, todate1, Convert.ToDecimal(Session["UserID"].ToString().Trim()), Session["UserRole"].ToString().Trim(), "All");
ReportDAL.Report2ExportToPdf(dt);
displaypdf2.Visible = true;
displaypdf.Visible = false;
displaypdf2.FilePath = @"~/PDF-Files/Report2_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf";
}
