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();
}
