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