protected void btnSearch_Click(object sender, EventArgs e) { DataSet DS = new DataSet(); Dispatch disp = new Dispatch(); DispatchData dispatchData = new DispatchData(); string result = string.Empty; disp.DispatchDate = Convert.ToDateTime(txtOrderDate.Text).ToString("dd-MM-yyyy"); disp.UserID = Convert.ToInt32(dpUsers.SelectedItem.Value); disp.CategoryId = Convert.ToInt32(dpCategory.SelectedItem.Value); DS = dispatchData.GetDispatchUserShiftwise(disp); 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: 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:180px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:120px'>"); sb.Append("<col style = 'width:80px'>"); 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("<b>Nanjil Integrated Dairy Development ,Mulagumoodu, K.K.Dt.</b> <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 !important'>"); sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:center'>"); sb.Append("<u> User ShiftWise Report </u>"); 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(dpUsers.SelectedItem.Text.ToString()); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:center; border-bottom: 0px'>"); sb.Append("<b><u> " + dpCategory.SelectedItem.Text.ToString()); sb.Append("</b></u></td>"); sb.Append("<td class='tg-yw4l' colspan='2' style='text-align:right'>"); sb.Append("Date : " + Convert.ToDateTime(txtOrderDate.Text).ToString("dd-MM-yyyy")); 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' colspan='2' 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>Sales </b>"); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' style='text-align:left'>"); //sb.Append("<b>Return </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' colspan='2' 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='4' style='text-align:left'>"); sb.Append("Dispatch Clerk "); sb.Append("</td>"); sb.Append("<td class='tg-yw4l' colspan='4' style='text-align:right'>"); 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(); DispatchSummary.Text = result; //Session["ctrl"] = sb.ToString(); Session["ctrl"] = pnlDispatchSummary; //Response.Redirect("/print.aspx", true); } else { result = "Order not FOund"; DispatchSummary.Text = result; } }