protected void dpPOCode_SelectedIndexChanged1(object sender, EventArgs e)
{
purchaseData = new PurchaseData();
DS = new DataSet();
order = new Order();
order.OrderId = Convert.ToInt32(dpPOCode.SelectedItem.Value);
order.Flag = 3;
order.OrderDate = string.Empty;
rpAgentOrderdetails.DataSource = purchaseData.GetOrderList(order);
rpAgentOrderdetails.DataBind();
dpSelect();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
purchaseData = new PurchaseData();
DS = new DataSet();
order = new Order();
order.OrderDate = string.IsNullOrEmpty(txtPODate.Text) ? string.Empty : Convert.ToDateTime(txtPODate.Text).ToString("dd-MM-yyyy");
order.Flag = 1; //for getting Approved Request Details by Date
DS = purchaseData.GetOrderList(order);
rpRequestList.DataSource = DS;
rpRequestList.DataBind();
//lblBoxHeader.Text = "New Request List";
upList.Update();
}
private void GetDetailsById(int orderId)
{
purchaseData = new PurchaseData();
DS = new DataSet();
order = new Order();
string result = string.Empty;
order.OrderId = orderId;
order.Flag = 2; //for getting Order Details
DS = purchaseData.GetOrderList(order);
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; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:50px'>");
sb.Append("<col style = 'width:220px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:80px'>");
sb.Append("<col style = 'width:80px'>");
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='3' style='border-bottom:1px solid'>");
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>Purchase Order </u> <br/>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' colspan='3' style='text-align:right'>");
sb.Append("GSTIN: 33AAECN2463R1Z2<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr >");
sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:center; Font-size:15px'>");
sb.Append("<b>Nanjil Integrated Dairy Development</b>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("CST: 1078823");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:center'>");
sb.Append("<b>5/15, Mulagumoodu, Kanyakumari-629167, TamilNadu,India</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("<tr> <td colspan='8' style=text-align:right; padding-top:10px>");
sb.Append("Order No: NIDD-PO-" + DS.Tables[0].Rows[0]["OrderId"]);
sb.Append("</td></tr>");
sb.Append("<tr> <td colspan='8' style=text-align:right; padding-top:10px>");
sb.Append("Date : " + DateTime.Now.ToLongDateString());
sb.Append("</td></tr>");
sb.Append("<tr> <td style=text-align:right> To, </td> </tr>");
sb.Append("<tr> <td>   </td> <td colspan=3> <b>");
sb.Append(DS.Tables[0].Rows[0]["VendorCode"] + " " + DS.Tables[0].Rows[0]["VendorName"]);
sb.Append("</b> </td></tr>");
sb.Append("<tr> <td>   </td> <td colspan=3>");
sb.Append(DS.Tables[0].Rows[0]["Address"]);
sb.Append("</td></tr>");
sb.Append("<tr> <td>   </td> <td colspan=3>");
sb.Append(DS.Tables[0].Rows[0]["City"]);
sb.Append("</td></tr>");
sb.Append("<tr> <td>   </td> <td colspan=3>");
sb.Append(DS.Tables[0].Rows[0]["State"]);
sb.Append("</td></tr>");
sb.Append("<tr> <td>   </td> <td colspan=3> Phone:");
sb.Append(DS.Tables[0].Rows[0]["Mobile"] + " , " + DS.Tables[0].Rows[0]["Phone"]);
sb.Append("</td></tr>");
sb.Append("<tr> <td>   </td> <td colspan=3> Email: ");
sb.Append(DS.Tables[0].Rows[0]["Email"]);
sb.Append("</td></tr>");
sb.Append("<tr><td> </td><tr>");
sb.Append("<tr> <td style=text-align:right> <b> Dear Sir </b> </td></tr>");
sb.Append("<tr><td> </td> <td colspan='5'> <b> We are placing the order for followings </b> </td></tr>");
sb.Append("<tr style='border:solid;border-width:1px;'> <td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Sr.No</td> <td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Items</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Quantity</td> <td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Rate</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Excise</td> <td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>CST</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>VAT</td> <td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>Amount </td> </tr>");
foreach (DataRow row in DS.Tables[1].Rows)
{
sb.Append("<tr style='border:solid;border-width:1px;'>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["srno"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["ItemName"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["Quantity"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(Convert.ToDecimal(row["Price"]).ToString("#0.00") + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["Excise"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["CST"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(row["VAT"].ToString() + "</td>");
sb.Append("<td style='border:solid;border-width:1px;padding:1px; padding-left:3px'>");
sb.Append(Convert.ToDecimal(row["Amt"]).ToString("#0.00") + "</td>");
sb.Append("</tr>");
}
sb.Append("<tr><td> </td><tr>");
sb.Append("<tr><td> </td><tr>");
sb.Append("<tr> <td colspan='4'> <b><u> Terms and Conditions </u></b></td></tr>");
sb.Append("<tr> <td> </td> <td> <b> Frieght : </b>" + DS.Tables[0].Rows[0]["Frieght"] + "</td></tr>");
sb.Append("<tr> <td> </td> <td> <b> Payment Terms : </b>" + DS.Tables[0].Rows[0]["PaymentTerms"] + "</td></tr>");
sb.Append("<tr> <td> </td> <td colspan='5'> <b> Billing & Delivery Address : Nanjil Integrated Dairy Development </b></td></tr>");
sb.Append("<tr> <td> </td> <td> <b> Amount : </b>" + Convert.ToDecimal(DS.Tables[0].Rows[0]["TotalAmt"]).ToString("#0.00") + "</td></tr>");
sb.Append("<tr> <td> </td> <td> <b> Required Date : </b>" + DS.Tables[0].Rows[0]["TillDate"] + "</td></tr>");
sb.Append("<tr> <td> </td> <td> <b> Transportation Damage : </b>" + DS.Tables[0].Rows[0]["TransDamage"] + "</td></tr>");
sb.Append("<tr><td> </td><tr>");
sb.Append("<tr> <td colspan='4'>   </td> <td colspan='4' style='text-align:center'> Yours Sincerely </td> </td>");
sb.Append("<tr> <td colspan='4'>   </td> <td colspan='4' style='text-align:center'> <b>For Nanjil Integrated Dairy Development</b> </td> </td>");
sb.Append("<tr><td> </td><tr>");
sb.Append("<tr><td> </td><tr>");
if (Convert.ToDecimal(DS.Tables[0].Rows[0]["TotalAmt"]) > 49999)
{
sb.Append("<tr> <td colspan='4'>   </td> <td colspan='4' style='text-align:center'><b> Managing Director</b></td> </td>");
}
else
{
sb.Append("<tr> <td colspan='4'>   </td> <td colspan='4' style='text-align:center'><b> Purchase Manager</b></td> </td>");
}
sb.Append("");
sb.Append("");
sb.Append("");
result = sb.ToString();
RequestDetails.Text = result;
Session["ctrl"] = pnlRequestDetails;
}
}