public void BindAgencyCloserScreenInfo() { DispatchData dispatchdata = new DispatchData(); d = new Dispatch(); DataSet DS = new DataSet(); d.AgentID = Convert.ToInt32(dpAgent.SelectedItem.Value); d.closedby = GlobalInfo.Userid; d.tokanid = hftokanno.Value; DS = dispatchdata.PrintAgencyCloserInfo(d); string result = string.Empty; 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:150px'>"); sb.Append("<col style = 'width:150px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:120px'>"); 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='2' style='text-align:center; font-size: 80%;'>"); sb.Append("<u> Agency Closer Bill </u> <br/>"); sb.Append("</th>"); sb.Append("<th class='tg-yw4l' colspan='2' style='text-align:right; font-size: 80%;'>"); 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:Left'>"); sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt. Ph:248370, 248605</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td colspan ='2' style='text-align:left; font-size: 80%;'>"); sb.Append("Agency Closer"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(" "); sb.Append("</td>"); sb.Append("<td colspan='2' style='text-align:right; font-size: 80%;'>"); sb.Append("Agency Closer No "); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td colspan ='2' style='text-align:left; font-size: 80%;'>"); sb.Append(DateTime.Now.ToString()); sb.Append("</td>"); sb.Append("<td>"); sb.Append(" "); sb.Append("</td>"); sb.Append("<td colspan='2' style='text-align:right; font-size: 80%;'>"); sb.Append("<b>" + DS.Tables[0].Rows[0]["id"] + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); //sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '5'> </td> </tr>"); sb.Append("<tr style='border-bottom:0.5px solid'>"); sb.Append("<td colspan='2'>"); sb.Append("Route" + " " + "<b>" + DS.Tables[0].Rows[0]["Route"] + "</b>"); sb.Append("</td>"); sb.Append("<td colspan='3'>"); sb.Append("Agent" + " " + "<b>" + DS.Tables[0].Rows[0]["Agent"] + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='text-align:left'>"); sb.Append("<u>" + "Payment Details :" + "</u>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='text-align:left'>"); string loanpaid = string.Empty; if (DS.Tables[0].Rows[0]["loanpaid"].ToString() == "True") { loanpaid = "Yes"; } else { loanpaid = "No"; } sb.Append("Loan Paid :" + " " + "<b>" + loanpaid + "</b>"); sb.Append("</td>"); sb.Append("<td colspan='2' style='text-align:left'>"); string schemepaid = string.Empty; if (DS.Tables[0].Rows[0]["schemepaid"].ToString() == "True") { schemepaid = "Yes"; } else { schemepaid = "No"; } sb.Append("Scheme Paid :" + " " + "<b>" + schemepaid + "</b>"); sb.Append("</td>"); sb.Append("<td colspan='2' style='text-align:left'>"); string incentivepaid = string.Empty; if (DS.Tables[0].Rows[0]["incentivepaid"].ToString() == "True") { incentivepaid = "Yes"; } else { incentivepaid = "No"; } sb.Append("IncentivePaid:" + " " + "<b>" + incentivepaid + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='text-align:left'>"); string depositrefund = string.Empty; if (DS.Tables[0].Rows[0]["depositrefund"].ToString() == "True") { depositrefund = "Yes"; } else { depositrefund = "No"; } sb.Append("Deposit Refund :" + " " + "<b>" + depositrefund + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='text-align:left'>"); sb.Append("<u>" + "Item Returns :" + "</u>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='text-align:left'>"); string freezerreturn = string.Empty; if (DS.Tables[0].Rows[0]["freezerreturn"].ToString() == "True") { freezerreturn = "Yes"; } else { freezerreturn = "No"; } sb.Append("Freezer:" + " " + "<b>" + freezerreturn + "</b>"); sb.Append("</td>"); sb.Append("<td style='text-align:left'>"); string chillpaid = string.Empty; if (DS.Tables[0].Rows[0]["chillpaid"].ToString() == "True") { chillpaid = "Yes"; } else { chillpaid = "No"; } sb.Append("Chillpad :" + " " + "<b>" + chillpaid + "</b>"); sb.Append("</td>"); sb.Append("<td style='text-align:left'>"); string trays = string.Empty; if (DS.Tables[0].Rows[0]["trays"].ToString() == "True") { trays = "Yes"; } else { trays = "No"; } sb.Append("Trays:" + " " + "<b>" + trays + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:0.5px solid'><td colspan='5'></td></tr>"); sb.Append("<tr style='border-bottom:0.5px solid'>"); sb.Append("<td colspan='5'> "); sb.Append("Approved By: " + "<b>" + DS.Tables[0].Rows[0]["Name"] + "</b>"); sb.Append("</td> "); sb.Append("</tr>"); result = sb.ToString(); genratedBIll.Text = result; //Session["ctrl"] = sb.ToString(); Session["ctrl"] = pnlBills; //Response.Redirect("/print.aspx", true); } else { //result = "No Records Found"; //genratedBIll.Text = result; } }