protected void Button2_Click(object sender, EventArgs e) { Label1.Text = " ( " + DateTime.Now.ToString() + " )"; Response.ContentType = "application/pdf"; Response.AppendHeader("content-disposition", "attachement;filename=Results.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); Panel2.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f); HTMLWorker htmlparser = new HTMLWorker(pdfDocument); PdfWriter.GetInstance(pdfDocument, Response.OutputStream); pdfDocument.Open(); htmlparser.Parse(sr); pdfDocument.Close(); Response.Write(pdfDocument); pdfDocument.Close(); Response.Write(pdfDocument); Response.End(); }
protected void btnExport_Click(object sender, EventArgs e) { try { if (ddlPonumber.SelectedIndex != 0) { string MainCategory = ClsPurchaseInvoice.Get_MainCategory_BasedOn_POID(Convert.ToInt64(ddlPonumber.SelectedValue.ToString())); if (MainCategory != "Support") { Panel1.Visible = true; value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString()); if (value != -1) { DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value); lbl_Ponumber.Text = dt.Rows[0]["PO Number"].ToString(); lbl_PoDate.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy"); lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString(); lbl_Bill_Address.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Ship_Address.Text = dt.Rows[0]["ShippingAddress"].ToString(); //lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Term4.Text = "4. Warranty :" + dt.Rows[0]["Warranty"].ToString(); lblBillGST.Text = dt.Rows[0]["GST"].ToString(); lblBillPAN.Text = dt.Rows[0]["PAN"].ToString(); lblSPA.Text = dt.Rows[0]["SPANumber"].ToString(); // lblShipGST.Text= dt.Rows[0]["GST"].ToString(); lblShipPAN.Text = dt.Rows[0]["PAN"].ToString(); DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value); int CategoryID = 0; //foreach (DataRow row in DT1.Rows) //{ //for (int i = 0; i < DT1.Rows.Count - 1; i++) //{ // CategoryID = Convert.ToInt32(DT1.Rows[i]["catagoryid"].ToString()); //if (CategoryID == 33) //{ //GetSalesManager(); GetSalesManagerAMC1(); //lbl_Term3.Text = ""; //} //else //{ // GetSalesManager(); //} // } //if (CategoryID == 33) //{ //foreach (GridViewRow row in GridView1.Rows) //{ // foreach (TableCell cell in row.Cells) // { // row.Cells[0].Width = 10; // } //} Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView1.HeaderRow.Style.Add("width", "10%"); GridView1.HeaderRow.Style.Add("font-size", "10px"); GridView1.Style.Add("font-size", "8px"); Panel1.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 100f, 100f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfWriter.PageEvent = new Comman.ITextEvents(); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); // Response.End(); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest(); Panel1.Visible = false; GetMasterList(); #region old code //} //else //{ // Response.ContentType = "application/pdf"; // Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); // Response.Cache.SetCacheability(HttpCacheability.NoCache); // StringWriter sw = new StringWriter(); // HtmlTextWriter hw = new HtmlTextWriter(sw); // GvwSaleseOrderDetails.HeaderRow.Style.Add("width", "10%"); // GvwSaleseOrderDetails.HeaderRow.Style.Add("font-size", "10px"); // GvwSaleseOrderDetails.Style.Add("font-size", "8px"); // Panel1.RenderControl(hw); // StringReader sr = new StringReader(sw.ToString()); // Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f); // HTMLWorker htmlparser = new HTMLWorker(pdfDoc); // PdfWriter.GetInstance(pdfDoc, Response.OutputStream); // pdfDoc.Open(); // htmlparser.Parse(sr); // pdfDoc.Close(); // Response.Write(pdfDoc); // // Response.End(); // HttpContext.Current.Response.Flush(); // HttpContext.Current.Response.SuppressContent = true; // HttpContext.Current.ApplicationInstance.CompleteRequest(); // Panel1.Visible = false; // GetMasterList(); //} #endregion } else { Panel1.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } else { Panel2.Visible = true; value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString()); if (value != -1) { DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value); lbl_PonumberSupport.Text = dt.Rows[0]["PO Number"].ToString(); lbl_PoDateSupport.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy"); lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString(); lbl_Bill_Address_Support.Text = dt.Rows[0]["BillingAddress"].ToString(); lbl_Ship_Address_Support.Text = dt.Rows[0]["ShippingAddress"].ToString(); lblSPA.Text = dt.Rows[0]["SPANumber"].ToString(); lblSupBilGST.Text = dt.Rows[0]["GST"].ToString(); lblSupBilPAN.Text = dt.Rows[0]["PAN"].ToString(); //lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString(); DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value); foreach (DataRow row in DT1.Rows) { int CategoryID = Convert.ToInt32(DT1.Rows[0]["catagoryid"].ToString()); if (CategoryID == 5 || CategoryID == 20 || CategoryID == 30 || CategoryID == 31 || CategoryID == 32 || CategoryID == 33 || CategoryID == 42) { //GetSalesManagerSupport(); GetSalesManagerAMC(); lbl_Term3.Text = ""; } else { GetSalesManagerSupport(); } } Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=PO.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView3.HeaderRow.Style.Add("width", "10%"); GridView3.HeaderRow.Style.Add("font-size", "10px"); GridView3.Style.Add("font-size", "8px"); Panel2.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 130f, 100f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfWriter.PageEvent = new Comman.ITextEvents(); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); // Response.End(); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest(); Panel2.Visible = false; GetMasterList(); } else { Panel2.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } } else { Panel1.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false); } } catch (Exception ex) { } //ddlPonumber.SelectedItem.Value = "-1"; }