protected void btngenrateBill_click(object sender, EventArgs e) { string result = string.Empty; DS = billdata.AgentSchemeDetails(Convert.ToInt32(dpRoute.SelectedItem.Value)); if (!Comman.Comman.IsDataSetEmpty(DS)) { StringBuilder sb = new StringBuilder(); sb.Append("<style type='text / css'>"); sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }"); sb.Append(".tg .tg-yw4l{vertical-align:top}"); sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}"); sb.Append("</style>"); //sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>"); sb.Append("<table class='tg style1' style=' position:relative;align:center;'>"); sb.Append("<colgroup>"); sb.Append("<col style = 'width:80px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:160px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("</colgroup>"); sb.Append("<tr>"); sb.Append("<th class='tg-yw4l' rowspan='2'>"); sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>"); sb.Append("</th>"); sb.Append("<th class='tg-baqh' colspan='4' style='text-align:center'>"); sb.Append("<u>Agency Scheme Details </u> <br/>"); sb.Append("</th>"); sb.Append("<th class='tg-yw4l' style='text-align:right'>"); sb.Append("TIN:330761667331<br>"); sb.Append("</th>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>"); sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("PH:248370,248605"); sb.Append("</td> </tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td colspan='3'>"); sb.Append(dpRoute.SelectedItem.Text); sb.Append("</td>"); sb.Append("<td colspan='3' style='text-align:right'>"); sb.Append(DateTime.Now.ToString("dd-mm-yyyy HH:mm")); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td>"); sb.Append("<b>Sr.No.</b>"); sb.Append("</td>"); sb.Append("<td>"); sb.Append("<b>Agency Code</b>"); sb.Append("</td>"); sb.Append("<td colspan = '2'>"); sb.Append("<b>Agency Name</b>"); sb.Append("</td>"); //sb.Append("<td>"); //sb.Append("<b>Route Name</b>"); //sb.Append("</td>"); sb.Append("<td style='text-align:right'>"); sb.Append("<b>Scheme Amt</b>"); sb.Append("</td>"); sb.Append("<td style='text-align:right'>"); sb.Append("<b>Total Scheme</b>"); sb.Append("</td>"); sb.Append("</tr>"); int srno = 0; foreach (DataRow row in DS.Tables[0].Rows) { srno++; sb.Append("<tr>"); sb.Append("<td>"); sb.Append(srno.ToString()); sb.Append("</td>"); sb.Append("<td>"); sb.Append(row["AgentCode"].ToString()); sb.Append("</td>"); sb.Append("<td colspan = '2'>"); sb.Append(row["AgentName"].ToString()); sb.Append("</td>"); //sb.Append("<td>"); //sb.Append(row["RouteName"].ToString()); ; //sb.Append("</td>"); sb.Append("<td style='text-align:right'>"); sb.Append(Convert.ToDecimal(row["SchemeAmount"]).ToString("#0.00")); sb.Append("</td>"); sb.Append("<td style='text-align:right'>"); if (string.IsNullOrEmpty(row["TotalSchemeAmount"].ToString())) { sb.Append("0.00"); } else { sb.Append(Convert.ToDecimal(row["TotalSchemeAmount"]).ToString("#0.00")); } sb.Append("</td>"); sb.Append("</tr>"); } result = sb.ToString(); genratedBIll.Text = result; //Session["ctrl"] = sb.ToString(); Session["ctrl"] = pnlBill; //Response.Redirect("/print.aspx", true); } else { result = "Bill not found"; genratedBIll.Text = result; } }
protected void btngenrateBill_click(object sender, EventArgs e) { string result = string.Empty; DS = billdata.AgentSchemeDetails(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value)); if (!Comman.Comman.IsDataSetEmpty(DS)) { DataView view = new DataView(DS.Tables[0]); view.Sort = "RouteCode ASC"; DataTable distinctValues = view.ToTable(true, "RouteCode", "RouteName"); StringBuilder sb = new StringBuilder(); sb.Append("<style type='text / css'>"); sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; }"); sb.Append(".tg .tg-yw4l{vertical-align:top}"); sb.Append(".tg .tg-baqh{text-align:center;vertical-align:top}"); sb.Append("</style>"); //sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>"); sb.Append("<table class='tg style1' style=' position:relative;align:center;'>"); sb.Append("<colgroup>"); sb.Append("<col style = 'width:80px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:160px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("</colgroup>"); sb.Append("<tr>"); sb.Append("<th class='tg-yw4l' rowspan='2'>"); sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>"); sb.Append("</th>"); sb.Append("<th class='tg-baqh' colspan='4' style='text-align:center'>"); sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>"); sb.Append("</th>"); sb.Append("<th class='tg-yw4l' style='text-align:right'>"); sb.Append("GSTIN: 33AAECN2463R1Z2<br>"); sb.Append("</th>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center'>"); sb.Append("<b><u>Agency Scheme Summary </u> </b><br/>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("PH:248370,248605"); sb.Append("</td> </tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td colspan='3'>"); sb.Append(dpRoute.SelectedItem.Text); sb.Append("</td>"); sb.Append("<td colspan='3' style='text-align:right'>"); sb.Append(DateTime.Now.ToString("dd-MM-yyyy HH:mm")); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td style='text-align:left'>"); sb.Append("Start Date: "); sb.Append("</td>"); sb.Append("<td colspan='2'>"); sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy")); sb.Append("</td>"); sb.Append("<td style='text-align:right'>"); sb.Append("End Date: "); sb.Append("</td>"); sb.Append("<td colspan='2' style='text-align:right'>"); sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy")); sb.Append("</td>"); sb.Append("</tr>"); int totalentries = 0; double routeschemeamt = 0.00; foreach (DataRow rows in distinctValues.Rows) { sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'> </td></tr>"); totalentries++; sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td>"); sb.Append("<b>" + totalentries + "</b>"); sb.Append("</td>"); sb.Append("<td colspan='2'>"); sb.Append("<b>" + rows["RouteCode"].ToString() + "</b>"); sb.Append("</td>"); sb.Append("<td colspan = '3'>"); sb.Append("<b>" + rows["RouteName"].ToString() + "</b>"); sb.Append("</td>"); //sb.Append("<td>"); //sb.Append("<b>Route Name</b>"); //sb.Append("</td>"); sb.Append("</tr>"); int srno = 0; double schemeamt = 0.00; double totalsheme = 0.00; foreach (DataRow row in DS.Tables[0].Rows) { if (rows["RouteCode"].ToString() == row["RouteCode"].ToString()) { srno++; sb.Append("<tr>"); sb.Append("<td>"); sb.Append(srno.ToString()); sb.Append("</td>"); sb.Append("<td>"); sb.Append(row["AgentCode"].ToString()); sb.Append("</td>"); sb.Append("<td colspan = '2'>"); sb.Append(row["AgentName"].ToString()); sb.Append("</td>"); sb.Append("<td colspan = '2' style='text-align:right'>"); if (string.IsNullOrEmpty(row["Scheme"].ToString())) { sb.Append("0.00"); } else { sb.Append(Convert.ToDecimal(row["Scheme"]).ToString("#0.00")); schemeamt += Convert.ToDouble(row["Scheme"]); totalsheme += schemeamt; } sb.Append("</td>"); sb.Append("</tr>"); } } sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td>"); sb.Append("Total"); sb.Append("</td>"); sb.Append("<td>"); sb.Append("Count"); sb.Append("</td>"); sb.Append("<td colspan='2'>"); sb.Append(srno.ToString()); sb.Append("</td>"); sb.Append("<td colspan = '2' style='text-align:right'>"); sb.Append(Convert.ToDecimal(schemeamt).ToString("#0.00")); routeschemeamt += schemeamt; sb.Append("</td>"); sb.Append("</tr>"); } sb.Append("<tr style='border-bottom:1px solid'><td colspan='6'></td></tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td>"); sb.Append("Total"); sb.Append("</td>"); sb.Append("<td>"); sb.Append("Route Count"); sb.Append("</td>"); sb.Append("<td colspan='2'>"); sb.Append(totalentries.ToString()); sb.Append("</td>"); sb.Append("<td colspan = '2' style='text-align:right'>"); sb.Append(Convert.ToDecimal(routeschemeamt).ToString("#0.00")); sb.Append("</td>"); sb.Append("</tr>"); result = sb.ToString(); genratedBIll.Text = result; //Session["ctrl"] = sb.ToString(); Session["ctrl"] = pnlBill; //Response.Redirect("/print.aspx", true); } else { result = "Bill not found"; genratedBIll.Text = result; } }