protected void Button2_Click(object sender, EventArgs e)
{
iframShowFiles.Visible = true;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = Getdata(TextBox3.Text, TextBox4.Text, route_id, plant_Code, Company_code);
ds.Tables.Add(dt);
if (dt.Rows.Count > 0)
{
///
DataSet ds1 = new DataSet();
DataTable dt1 = new DataTable();
dt1 = Getdata1(TextBox3.Text, TextBox4.Text, route_id, plant_Code, Company_code);
ds1.Tables.Add(dt1);
///
// int i = 1;
// for (i = 1; i <= dt1.Rows.Count; i++)
//{
int i = 1;
string na = Convert.ToString(i);
string name1 = Server.MapPath(".") + "/kk/" + plant_Code.Trim() + '_' + TextBox3.Text.Trim() + '_' + TextBox4.Text.Trim() + '_' + "Bill";
name2 = Server.MapPath(".") + "/kk/" + "Nasa-logo1.gif";
//name2 = Server.MapPath(".") + "/kk/" + "onezero .jpg";
SETBO();
CreatePdf pd = new CreatePdf(ds, name1, i, ds1, Cpdf);
pd.Execute1();
string fileName = plant_Code.Trim() + '_' + TextBox3.Text.Trim() + '_' + TextBox4.Text.Trim() + '_' + "Bill.pdf";
string surverUrl = Request.Url.AbsoluteUri.Split('/')[0] + "//" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/";
string fileStoreLocation = "kk/";
string downloadFilePath = surverUrl + fileStoreLocation + fileName;
iframShowFiles.Attributes.Add("src", downloadFilePath);
//object TargetFile = name1 + ".pdf".ToString();
//System.IO.FileInfo file = new System.IO.FileInfo(TargetFile.ToString());
//if (File.Exists(TargetFile.ToString()))
//{
// File.Delete(TargetFile.ToString());
//}
name1 = string.Empty;
}
else
{
iframShowFiles.Visible = false;
WebMsgBox.Show("Report Not Found...");
}
}
