private void generateGatePass(int id) { DataSet DS = new DataSet(); DispatchData dispatchData = new DispatchData(); string result = string.Empty; DS = dispatchData.GenerateDispatchSummary(id); if (!Comman.Comman.IsDataSetEmpty(DS)) { StringBuilder sb = new StringBuilder(); //foreach (DataRow row in DS.Tables[0].Rows) //{ // int count = 0; // int qty = 0; sb.Append("<style type='text / css'>"); sb.Append(".tg { border-collapse:collapse; border - spacing:0; border: 0px; }"); 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:80px'>"); sb.Append("<col style = 'width:100px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:120px'>"); 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='6' style='text-align:center'>"); sb.Append("<u> Gate Pass </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 !important'>"); sb.Append("<td class='tg-yw4l' colspan='6' 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("<hr>"); sb.Append("<tr style='border-bottom:0.5px dotted'>"); sb.Append("<td colspan='2'>"); sb.Append(DS.Tables[0].Rows[0]["RouteCode"].ToString() + " "); sb.Append(DS.Tables[0].Rows[0]["RouteName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center; border-bottom: 0px'>"); sb.Append("<b><u> " + DS.Tables[0].Rows[0]["CategoryName"].ToString()); sb.Append("</b></u></td>"); sb.Append("<td class='tg-yw4l' colspan='2' 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:0.5px dotted'>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("Driver : " + DS.Tables[0].Rows[0]["FirstDriver"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' rowspan='2' colspan='2' style='text-align:center'>"); sb.Append("GatePass ID: <b> GP" + id.ToString() + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' rowspan='2' style='text-align:center'>"); sb.Append("Dispatch ID: <b> DS" + id.ToString() + "</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("Salesman I: " + DS.Tables[0].Rows[0]["FirstSalesman"].ToString()); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:0.5px dotted'>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("Driver II : " + DS.Tables[0].Rows[0]["SecondDriver"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("Salesman II : " + DS.Tables[0].Rows[0]["SecondSalesman"].ToString()); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("Vehicle No: " + DS.Tables[0].Rows[0]["VehicleNo"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:left'>"); sb.Append("Starting Time: " + DateTime.Now.ToString("dd-MM-yyyy hh:mm:ss")); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:left'>"); sb.Append("Ending Time: "); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '8'> </td> </tr>"); sb.Append("<tr style='border-bottom:1px solid'>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b> Sr. No: </b> "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Product Name </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Commodity </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:center'>"); sb.Append("<b>Quantity </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Unit Type </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b></b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b> </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("</tr>"); int cnt = 1; foreach (DataRow row in DS.Tables[1].Rows) { sb.Append("<tr style='border-bottom:0.5px dotted'>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(cnt.ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(row["ProductName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(row["CommodityName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:center'>"); sb.Append(row["TotalQuantity"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(row["UnitName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("</tr>"); cnt++; } sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '8'> </td> </tr>"); sb.Append("<tr style='border-Top:1px Solid;border-bottom:0.5px dotted'>"); sb.Append("<td class='tg-yw4l' rowspan='3' style='text-align:left'>"); sb.Append("<b>Crates Particular </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Item</b>"); //sb.Append(DS.Tables[0].Rows[0]["ProductName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Tray</b> "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Ice Box</b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("<b>Cartons/Ice Pad </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append("<b>Others </b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:0.5px dotted'>"); //sb.Append("<td class='tg-yw4l' rowspan='3' style='text-align:left'>"); //sb.Append("Crates Perticular "); //sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Dispatch</b>"); //sb.Append(DS.Tables[0].Rows[0]["ProductName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(DS.Tables[0].Rows[0]["TraysDispached"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append(DS.Tables[0].Rows[0]["IceBoxDispached"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append(DS.Tables[0].Rows[0]["CartonsDispached"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:left'>"); sb.Append(DS.Tables[0].Rows[0]["OtherDispached"].ToString()); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr style='border-bottom:1px Solid'>"); //sb.Append("<td class='tg-yw4l' rowspan='3' style='text-align:left'>"); //sb.Append("Crates Perticular "); //sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); sb.Append("<b>Returned</b>"); //sb.Append(DS.Tables[0].Rows[0]["ProductName"].ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:center'>"); sb.Append(""); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:Center'>"); sb.Append(""); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:Center'>"); sb.Append(""); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:Center'>"); sb.Append(""); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' colspan='8' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' colspan='8' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' colspan='8' style='text-align:left'>"); sb.Append(" "); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:left'>"); sb.Append("Dispatch Clerk "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:center'>"); sb.Append("Production Manager "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='3' style='text-align:right'>"); sb.Append("Sales Man "); sb.Append("</td>"); sb.Append("</tr>"); result = sb.ToString(); GatePass.Text = result; //Session["ctrl"] = sb.ToString(); Session["ctrl"] = pnlGatePass; //Response.Redirect("/print.aspx", true); upGatePass.Update(); } else { result = "Order not FOund"; GatePass.Text = result; } }