protected void btnGenerate_Click(object sender, EventArgs e)
{
string path = Server.MapPath("PDF-Files");
string filename = path + "/Report1_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf";
if (File.Exists(filename)) // if file exists
{
File.Delete(filename); // delete file
}
DataTable dt = new DataTable();
// get daterange values from form.
string dates = Convert.ToString(drreportdate.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.GetReportData(fromdate1, todate1, Convert.ToDecimal(Session["UserID"].ToString().Trim()), Session["UserRole"].ToString().Trim());
ReportDAL.Report1ExportToPdf(dt); // Generate PDF first.
displaypdf.Visible = true;
displaypdf2.Visible = false;
displaypdf.FilePath = @"~/PDF-Files/Report1_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf";
}
