private void ExportGridToPDF() { StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); StringBuilder sb = new StringBuilder(); StringBuilder sb1 = new StringBuilder(); sb.Append("<table width = '100%' cellspacing='0' cellpadding ='2'>"); sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'><b>Unpaid Bill Report</b></td></tr></table>"); sb.Append("</br>"); GridViewUnpaidBillShow.RenderControl(hw); sb1.Append("<table border = '1'>"); sb1.Append("<tr><td align = 'right' colspan = '"); sb1.Append(GridViewUnpaidBillShow.HeaderRow.Cells.Count - 1); sb1.Append("'>Total</td>"); sb1.Append("<td>"); sb1.Append(HiddenField1.Value); sb1.Append("</td>"); sb1.Append("</tr></table>"); StringReader sr2 = new StringReader(sb1.ToString()); StringReader sr1 = new StringReader(sb.ToString()); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr1); htmlparser.Parse(sr); htmlparser.Parse(sr2); pdfDoc.Close(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=UnPaidBill.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.Flush(); Response.Clear(); Response.End(); }
protected void btnShowUnpaidBill_Click(object sender, EventArgs e) { decimal sumOfUnPaidAmount = 0; DateTime fromDate = Convert.ToDateTime(txtFromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); List <Payments> UnpaidBillReport = patientManager.GetUnPaidBillReport(fromDate, toDate); GridViewUnpaidBillShow.DataSource = UnpaidBillReport; GridViewUnpaidBillShow.DataBind(); foreach (var billReport in UnpaidBillReport) { sumOfUnPaidAmount += billReport.UnPaidBill; } HiddenField1.Value = sumOfUnPaidAmount.ToString(); txtUnpaidTotal.Text = HiddenField1.Value; Clear(); }