protected void btngenrateBill_Click(object sender, EventArgs e) { string result = string.Empty; int flag = 1; DS = dispatchData.GetSalesManWiseReturnedTraysReport((Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy"), (Convert.ToDateTime(txtEndDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpSalesMan.SelectedItem.Value), flag); 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("<colgroup>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:200px'>"); sb.Append("<col style = 'width:200px'>"); 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("<u>SalesmanWise Return Trays Report</u> <br/>"); 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>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>"); sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:left'>"); sb.Append("Start Date:" + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy")); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:right'>"); sb.Append("End Date:" + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy")); sb.Append("</td>"); sb.Append("<tr style='border-bottom:2px solid'>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:left'>"); if (Convert.ToInt32(dpSalesMan.SelectedItem.Value) == 0) { sb.Append("Salesman : " + "All"); } else { sb.Append("Salesman : " + dpSalesMan.SelectedItem.Text.ToString()); } sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:right'>"); sb.Append("Date : " + DateTime.Now.ToString("dd-MM-yyyy")); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Dispatch Date </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Route</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>Out</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>In</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>Excess</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>Short</b>"); sb.Append("</td>"); sb.Append("</tr>"); int count1 = 0; int outtrays1 = 0; int intrays1 = 0; int excesstrays1 = 0; int shorttrays1 = 0; int totalouttrays1 = 0; int totalintrays1 = 0; int totalexcesstrays1 = 0; int totalshorttrays1 = 0; foreach (DataRow row in DS.Tables[0].Rows) { count1++; sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '6'> </td> </tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:left'>"); sb.Append("<b>" + row["EmployeeCode"] + "</b>"); sb.Append(" "); sb.Append("<b>" + row["EmployeeName"] + "</b>"); sb.Append("</td>"); int count = 0; int outtrays = 0; int intrays = 0; int excesstrays = 0; int shorttrays = 0; int totalouttrays = 0; int totalintrays = 0; int totalexcesstrays = 0; int totalshorttrays = 0; foreach (DataRow rows in DS.Tables[1].Rows) { if (row["EmployeeCode"].ToString() == rows["EmployeeCode"].ToString()) { count++; sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(rows["DispatchDate"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(rows["RouteCode"].ToString()); sb.Append(" "); sb.Append(rows["RouteName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { outtrays = Convert.ToInt32(rows["TraysDispached"]); } catch { outtrays = 0; } sb.Append(outtrays.ToString()); totalouttrays += outtrays; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { intrays = Convert.ToInt32(rows["TraysReturned"]); } catch { intrays = 0; } sb.Append(intrays.ToString()); totalintrays += intrays; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { excesstrays = intrays - outtrays; } catch { excesstrays = 0; } if (excesstrays < 0) { excesstrays = 0; } sb.Append(excesstrays.ToString()); totalexcesstrays += excesstrays; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { shorttrays = outtrays - intrays; } catch { shorttrays = 0; } if (shorttrays < 0) { shorttrays = 0; } sb.Append(shorttrays.ToString()); totalshorttrays += shorttrays; 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 class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("<b>" + "SubTotal " + count1.ToString() + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { outtrays1 = Convert.ToInt32(row["TraysDispached"]); } catch { outtrays1 = 0; } sb.Append("<b>" + outtrays1.ToString() + "</b>"); totalouttrays1 += outtrays1; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { intrays1 = Convert.ToInt32(row["TraysReturned"]); } catch { intrays1 = 0; } sb.Append("<b>" + intrays1.ToString() + "</b>"); totalintrays1 += intrays1; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { excesstrays1 = intrays1 - outtrays1; } catch { excesstrays1 = 0; } if (excesstrays1 < 0) { excesstrays1 = 0; } sb.Append("<b>" + excesstrays1.ToString() + "</b>"); totalexcesstrays1 += excesstrays1; sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); try { shorttrays1 = outtrays1 - intrays1; } catch { shorttrays1 = 0; } if (shorttrays1 < 0) { shorttrays1 = 0; } sb.Append("<b>" + shorttrays1.ToString() + "</b>"); totalshorttrays1 += shorttrays1; 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 class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("<b>" + "Total " + count1.ToString() + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>" + totalouttrays1 + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>" + totalintrays1 + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>" + totalexcesstrays1 + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:right'>"); sb.Append("<b>" + totalshorttrays1 + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); result = sb.ToString(); genratedBIll.Text = result; Session["ctrl"] = pnlBill; } else { result = "Report Not Found"; genratedBIll.Text = result; } }