private void BindPODetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
gvPurchaseOrder.DataSource = dtPOProductList;
gvPurchaseOrder.DataBind();
decimal Total_Net_Qty = 0, Total_Gross_Qty = 0, Total_Durm = 0;
if (dtPOProductList.Rows.Count > 0)
{
for (int count = 0; count < dtPOProductList.Rows.Count; count++)
{
//Total_Amount += Convert.ToDecimal(dtPOProductList.Rows[count]["TotalPrice"].ToString());
Total_Net_Qty += Convert.ToDecimal(dtPOProductList.Rows[count]["Quantity"].ToString());
Total_Gross_Qty += Convert.ToDecimal(dtPOProductList.Rows[count]["GrossQuantity"].ToString());
Total_Durm += Convert.ToDecimal(dtPOProductList.Rows[count]["Packing25"].ToString()) + Convert.ToDecimal(dtPOProductList.Rows[count]["Packing180"].ToString());
}
//lblNetQty.Text = Total_Net_Qty.ToString();
//lblGrossQty.Text = Total_Gross_Qty.ToString();
//lblTotalAmout.Text = string.Format("{0:n0}", Total_Amount);
//lblTotalDrum.Text = Total_Durm.ToString();
//DataTable test = orderObj.Convert_NumberToWord(Total_Amount);
//lblAmount_word.Text = test.Rows[0][0].ToString() + " Only";
}
lblDestination.Text = dtPO.Rows[0]["DestinationCountry"].ToString();
lblDeparture.Text = dtPO.Rows[0]["DestinationPort"].ToString();
}
}
protected void btnCloseOrder_Click(object sender, EventArgs e)
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), "CLOSE", "Raghu", "<br/>" + string.Format("{0:dd MMM yyyy}", DateTime.Now) + ' ' + "CLOSE");
Response.Redirect("~/Admin/OrderAdmin.aspx");
}
private void BuyerDetails()
{
DataTable dtBuyer = buyerObj.BuyerDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtBuyer.Rows.Count > 0)
{
DataRow dr = dtBuyer.Rows[0];
//lblNotifyAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NAddress"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NCity"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NState"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NCountry"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NContactPhoneNo"].ToString();
//lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NContactPhoneNo"].ToString();
lblShipperAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
string[] Address = dtBuyer.Rows[0]["CAddress"].ToString().Split('@');
lblShipperAddress.Text += "<br/>" + Address[0].ToString();
if (Address.Length > 1)
{
lblShipperAddress.Text += "<br/>" + Address[1].ToString() + "," + Address[2].ToString();
}
//lblShipperAddress.Text += "<br>" + dtBuyer.Rows[0]["CAddress"].ToString();
lblShipperAddress.Text += "<br>" + dtBuyer.Rows[0]["CCity"].ToString();
lblShipperAddress.Text += "<br>" + dtBuyer.Rows[0]["CState"].ToString();
lblShipperAddress.Text += "<br>" + dtBuyer.Rows[0]["CCountry"].ToString();
}
}
private void BindOrderBuyerBranchDetails()
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dtOBBD = orderObj.Order_Buyer_Branch_Details(Convert.ToInt32(OrderID));
if (dtOBBD.Rows.Count > 0)
{
//Buyer Addres
lblBuyerAddress.Text = dtOBBD.Rows[0]["BuyerCompanyName"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CAddress"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CCity"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CState"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CCountry"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CContactPhoneNo"].ToString();
lblBuyerAddress.Text += "<br/>" + dtOBBD.Rows[0]["CContactPerson"].ToString();
//Notify address bind
lblNotifyAddress.Text = dtOBBD.Rows[0]["BuyerCompanyName"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NAddress"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NCity"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NState"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NCountry"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NContactPhoneNo"].ToString();
lblNotifyAddress.Text += "<br/>" + dtOBBD.Rows[0]["NContactPerson"].ToString();
//Consignee address bind
lblConsigneeAddress.Text = dtOBBD.Rows[0]["BuyerCompanyName"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CAddress"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CCity"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CState"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CCountry"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CContactPhoneNo"].ToString();
lblConsigneeAddress.Text += "<br/>" + dtOBBD.Rows[0]["CContactPerson"].ToString();
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), "SAMPLE DISPATCH", "Raghu", "<br/>" + '#' + txtLSmsg.Text + " " + " / " + string.Format("{0:dd MMM yyyy}", DateTime.Now) + " ");
Response.Redirect("~/Admin/OrderAdmin.aspx");
}
private void generatePDF()
{
string strpdf = "<table align='center' style='font-family: Verdana; width: 885px'><tr bgcolor='#ffcc66'>";
strpdf += "<td><table align='center' style='font-family: Verdana;'><tr><td align='center' style='font-size: 12px;'>Mudar India Exports</td></tr><tr>";
strpdf += "<td align='center' style='font-size: 10px;'>6-1-744, Kovur Nagar,ANANTAPUR - 515 004,Andhra Pradesh,India</td></tr></table></td></tr><tr>";
strpdf += "<td colspan='4' align='right'><span style='font-size:10px;'>Date: " + lblDate.Text + "</td></tr><tr>";
strpdf += "<td colspan='4' align='center'>To Whomever It may Concern</td></tr><tr>";
strpdf += "<td colspan='4'> </td></tr><tr>";
strpdf += "<td colspan='4' align='center'>We declare that the below mentioned goods</td></tr><tr>";
strpdf += "<td colspan='4'> </td></tr><tr>";
strpdf += "<td colspan='4'><table border='1'>";
//grid start
strpdf += "<tr align='center'><td>S.No.</td><td>Product Name</td><td>Total Drums</td><td>Total Qty in KG</td></tr>";
foreach (GridViewRow gvr in gvProductList.Rows)
{
strpdf += "<tr align='center'><td>" + (gvr.Cells[0].FindControl("lblsnnumber") as Label).Text + "</td><td>" + gvr.Cells[1].Text + "</td><td>" + gvr.Cells[2].Text + "</td><td>" + gvr.Cells[3].Text + "</td></tr>";//<td>" + gvr.Cells[5].Text + "</td><td>" + gvr.Cells[6].Text + "</td>
}
//grid end
strpdf += "</table></td></tr><tr>";
strpdf += "<td width='25%' align='center'<span style='font-size:10px;'> Shipped to :</td><td colspan='2' width='45%' align='left'><span style='font-size:10px;'>" + lblCAddress.Text + ".</td><td width='30%' align='center'><span style='font-size:10px;'> " + lblDCountry.Text + "</td></tr><tr>";
strpdf += "<td width='50%' colspan='2'align='left'> through our Invoice No :<span style='font-size:10px;'>" + lblInvoice.Text + " </td><td width='25%'> Date :<span style='font-size:10px;'>" + lblInvoiceDate.Text + "</td><td width='25%'><span style='font-size:10px;'>is 100% Non-Hazardous</td></tr></table>";
Document document = new Document();
try
{
string Pdf_path = string.Empty;
string orderid = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
Pdf_path = mu.createfolder(orderid.ToString(), MudarUser.OrderPDF) ? WebConfigurationManager.AppSettings["orderpdf"].ToString() + orderid.ToString() + "/NonHazSea_" + orderid + ".pdf" : WebConfigurationManager.AppSettings["orderpdf"].ToString() + "/NonHazSea_" + orderid + ".pdf";
//writer - have our own path!!!
PdfWriter.GetInstance(document, new FileStream(Server.MapPath(Pdf_path), FileMode.Create));
document.Open();
String htmlText = strpdf.ToString();
List <IElement> htmlarraylist = iTextSharp.text.html.simpleparser.HTMLWorker.ParseToList(new StringReader(htmlText), null);
Paragraph mypara = new Paragraph();//make an emtphy paragraph as "holder"
mypara.IndentationLeft = 20;
mypara.InsertRange(0, htmlarraylist);
document.Add(mypara);
document.Close();
//updare path in order report table for nonHazSea
bool result = reportObj.OrderReportsPathInsertandUpdate(Convert.ToInt32(orderid), Convert.ToInt32(Session["BranchOrderID_S"].ToString()), Pdf_path, "Bhanu", string.Empty, rtypeObj.Non_Haz_Sea);
}
catch (Exception exx)
{
Response.Write("<br>____________________________________<br>");
Response.Write("<br>Error: " + exx + "<br>");
Response.Write("<br>StackTrace: " + exx.StackTrace + "<br>");
Response.Write("<br>strPDFDocument: " + strpdf.ToString() + "<br>");
Response.Write("<br>strSelectUserListBuilder: " + strpdf.ToString() + "<br>");
//Console.Error.WriteLine(exx.StackTrace);
//Console.Error.WriteLine(exx.StackTrace);
}
finally
{
//document.Close();
}
}
private void BuyerDetails()
{
DataTable dtBuyer = buyerObj.BuyerDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtBuyer.Rows.Count > 0)
{
lblCompanyAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
}
}
private void BuyerDetails()
{
string BuAddress = string.Empty;
string BcAdress = string.Empty;
string BnAddress = string.Empty;
DataTable dtBuyer = buyerObj.BuyerDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtBuyer.Rows.Count > 0)
{
DataRow dr = dtBuyer.Rows[0];
if (dtBuyer.Rows[0]["CCountry"].ToString() == "INDIA")
{
lblmoney.Text = "INR";
}
else
{
lblmoney.Text = "USD";
}
lblBuyerAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
string[] Address = dtBuyer.Rows[0]["CAddress"].ToString().Split('@');
lblBuyerAddress.Text += "<br/>" + Address[0].ToString();
if (Address.Length > 1)
{
lblBuyerAddress.Text += "<br/>" + Address[1].ToString() + "," + Address[2].ToString();
}
lblBuyerAddress.Text += "<br/>" + dtBuyer.Rows[0]["CCity"].ToString();
lblBuyerAddress.Text += "<br/>" + dtBuyer.Rows[0]["CState"].ToString();
lblBuyerAddress.Text += "<br/>" + dtBuyer.Rows[0]["CCountry"].ToString();
lblBuyerAddress.Text += "<br/>" + dtBuyer.Rows[0]["CContactPerson"].ToString();
lblBuyerAddress.Text += "<br/>" + dtBuyer.Rows[0]["CContactPhoneNo"].ToString();
lblNotifyAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
string[] nAddress = dtBuyer.Rows[0]["NAddress"].ToString().Split('@');
lblNotifyAddress.Text += "<br/>" + nAddress[0].ToString();
if (nAddress.Length > 1)
{
lblNotifyAddress.Text += "<br/>" + nAddress[1].ToString() + "," + nAddress[2].ToString();
}
lblNotifyAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NCity"].ToString();
lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NState"].ToString();
lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NCountry"].ToString();
lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NContactPerson"].ToString();
lblNotifyAddress.Text += "<br>" + dtBuyer.Rows[0]["NContactPhoneNo"].ToString();
lblConsigneeAddress.Text = dtBuyer.Rows[0]["BuyerCompanyName"].ToString();
string[] cAddress = dtBuyer.Rows[0]["CAddress"].ToString().Split('@');
lblNotifyAddress.Text += "<br/>" + cAddress[0].ToString();
if (cAddress.Length > 1)
{
lblNotifyAddress.Text += "<br/>" + cAddress[1].ToString() + "," + cAddress[2].ToString();
}
lblConsigneeAddress.Text += "<br>" + dtBuyer.Rows[0]["CCity"].ToString();
lblConsigneeAddress.Text += "<br>" + dtBuyer.Rows[0]["CState"].ToString();
lblConsigneeAddress.Text += "<br>" + dtBuyer.Rows[0]["CCountry"].ToString();
lblConsigneeAddress.Text += "<br>" + dtBuyer.Rows[0]["CContactPerson"].ToString();
lblConsigneeAddress.Text += "<br>" + dtBuyer.Rows[0]["CContactPhoneNo"].ToString();
}
}
private void BindInvoice()
{
DataTable dtInvoice = invoiceObj.InvoiceDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtInvoice.Rows.Count > 0)
{
lblDeparture.Text = dtInvoice.Rows[0]["DestinationCountry"].ToString();
lblDeparture.Text = dtInvoice.Rows[0]["LoadingPort"].ToString();
}
}
private void BindInvoiceDetails()
{
DataTable invoiceDT = invoiceObj.InvoiceDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (invoiceDT.Rows.Count > 0)
{
lblInvoice.Text = invoiceDT.Rows[0]["InvoiceID"].ToString();
lblInvoiceDate.Text = string.Format("{0: dd MMM yyyy}", Convert.ToDateTime(invoiceDT.Rows[0]["CreatedDate"].ToString()));
}
}
protected void btnClearance_Click(object sender, EventArgs e)
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), "UNDER<BR/>CUSTOM<BR/>CLEARANCE", "Raghu", "<br/>" + string.Format("{0:dd MMM yyyy}", DateTime.Now) + ' ' + "UNDER CUSTOM CLEARANCE");
Session["AdminOrderStatus"] = "UNDER<BR/>CUSTOM<BR/>CLEARANCE";
BinOrderStatusDetails("UNDER CUSTOM CLEARANCE");
btnIntransitSubmit.Visible = true;
ScriptManager.RegisterStartupScript(this, GetType(), "myFunction", "ManageTabs('INTRANSIT','" + Convert.ToString(Session["AdminOrderStatus"]) + "');", true);
}
private void BindDelivaryDetails()
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dtDelivaryDetails = new DataTable();
dtDelivaryDetails = orderobj.OrderList(Convert.ToInt32(OrderID));
if (dtDelivaryDetails.Rows.Count > 0)
{
lblDestCountry.Text = dtDelivaryDetails.Rows[0]["CCountry"].ToString();
}
}
private void BindPODetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
lblPO.Text = dtPO.Rows[0]["PurchaseOrderID"].ToString();
lblPODate.Text = string.Format("{0: dd MMM yyyy}", dtPO.Rows[0]["OrderDate"]);
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
decimal Total_Amount = 0, Total_Durm = 0;
lblbranchorderID.Text = dtPO.Rows[0]["BranchOrderId"].ToString();
if (dtPOProductList.Rows.Count > 0)
{
for (int count = 0; count < dtPOProductList.Rows.Count; count++)
{
Total_Amount += Convert.ToDecimal(dtPOProductList.Rows[count]["TotalPrice"].ToString());
Total_Durm += Convert.ToDecimal(dtPOProductList.Rows[count]["Packing25"].ToString()) + Convert.ToDecimal(dtPOProductList.Rows[count]["Packing180"].ToString());
if (Convert.ToInt32(dtPOProductList.Rows[count]["25dfrom"]) != 0)
{
dtPOProductList.Rows[count]["DrumF"] = dtPOProductList.Rows[count]["25dfrom"].ToString();
dtPOProductList.Rows[count]["DrumT"] = dtPOProductList.Rows[count]["25dto"].ToString();
}
if (Convert.ToInt32(dtPOProductList.Rows[count]["180dfrom"]) != 0)
{
dtPOProductList.Rows[count]["DrumF"] = dtPOProductList.Rows[count]["180dfrom"].ToString();
dtPOProductList.Rows[count]["DrumT"] = dtPOProductList.Rows[count]["180dto"].ToString();
}
}
lblTotalAmout.Text = string.Format("{0:n0}", Total_Amount);
lblTotalDrum.Text = Total_Durm.ToString();
DataTable test = orderObj.Convert_NumberToWord(Total_Amount);
lblAmount_word.Text = test.Rows[0][0].ToString() + " Only";
gvPurchaseOrder.DataSource = dtPOProductList;
gvPurchaseOrder.DataBind();
}
lblPriceTerms.Text = dtPO.Rows[0]["FreightTerms"].ToString();
lblTransport.Text = dtPO.Rows[0]["Transport"].ToString();
lblPayment.Text = dtPO.Rows[0]["PaymentTerms"].ToString();
if (dtPO.Rows[0]["FreightTerms"].ToString() == "FOB INDIA")
{
lblFreight.Text = "Collect";
}
else
{
lblFreight.Text = "Pre-Paid";
}
lblDCountry.Text = dtPO.Rows[0]["DestinationCountry"].ToString();
lblDPort.Text = dtPO.Rows[0]["DestinationPort"].ToString();
lblLport.Text = "";
}
}
private void BindPODetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
lblPO.Text = dtPO.Rows[0]["PurchaseOrderID"].ToString();
lblPODate.Text = string.Format("{0: dd MMM yyyy}", dtPO.Rows[0]["OrderDate"]);
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
gvPurchaseOrder.DataSource = dtPOProductList;
gvPurchaseOrder.DataBind();
}
}
private void BindOrdercountryDetails()
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dt = orderObj.Ordercountry(OrderID);
if (dt.Rows[0]["DestinationCountry"].ToString() == "INDIA")
{
trDispatchdetails.Visible = true;
}
else
{
trDispatchdetails.Visible = false;
}
}
private void BindInvoiceDetails()
{
DataTable dtInvoiceDetails = invoiceObj.InvoiceDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtInvoiceDetails.Rows.Count > 0)
{
lblInviNo.Text = dtInvoiceDetails.Rows[0]["InvoiceId"].ToString();
lblInv.Text = dtInvoiceDetails.Rows[0]["InvoiceId"].ToString();
lblInvoice.Text = dtInvoiceDetails.Rows[0]["InvoiceId"].ToString();
lblInvoiceDt.Text = string.Format("{0: dd MMM yyyy}", dtInvoiceDetails.Rows[0]["CreatedDate"]);
lblInvoiceDate.Text = string.Format("{0: dd MMM yyyy}", dtInvoiceDetails.Rows[0]["CreatedDate"]);
lblPackDt.Text = string.Format("{0: dd MMM yyyy}", dtInvoiceDetails.Rows[0]["CreatedDate"]);
}
}
protected void btnIntransitSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtIntransitDate.Text))
{
DateTime intransitDate = DateTime.ParseExact(txtIntransitDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
string etaStr = "ETA : " + intransitDate.ToString("dd MMM yyyy");
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
orderObj.UpdateOrderETA(Convert.ToInt32(OrderID), intransitDate.ToString());
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), etaStr, "Raghu", "<br/>" + string.Format("{0:dd MMM yyyy}", DateTime.Now) + ' ' + etaStr);
Session["AdminOrderStatus"] = "INTRANSIT";
BinOrderStatusDetails("INTRANSIT");
lblETAText.Text = etaStr;
ScriptManager.RegisterStartupScript(this, GetType(), "myFunction", "ManageTabs('CLOSE','" + Convert.ToString(Session["AdminOrderStatus"]) + "');", true);
}
}
private void BindPODetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
decimal Total_Amount = 0;
for (int count = 0; count < dtPOProductList.Rows.Count; count++)
{
Total_Amount += Convert.ToDecimal(dtPOProductList.Rows[count]["TotalPrice"].ToString());
}
lblInvAmout.Text = string.Format("{0:n0}", Total_Amount);
lblDestCountry.Text = dtPO.Rows[0]["DestinationCountry"].ToString();
}
}
private void BindInvoice()
{
DataTable dtInvoice = invoiceObj.InvoiceDetails(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtInvoice.Rows.Count > 0)
{
lblInvoice.Text = dtInvoice.Rows[0]["Invoiceid"].ToString();
lblInvoiceDate.Text = string.Format("{0: dd MMM yyyy}", Convert.ToDateTime(dtInvoice.Rows[0]["CreatedDate"].ToString()));
lblDCountry.Text = dtInvoice.Rows[0]["DestinationCountry"].ToString();
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
gvProductList.DataSource = dtPOProductList;
gvProductList.DataBind();
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
bool result = false;
int i = Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true));
int j = Convert.ToInt32(lblbranchorderID.Text);
result = invoiceObj.InvoiceInsert(i, j, lblPriceTerms.Text, lblTransport.Text, "India", string.Empty, lblPayment.Text, lblFreight.Text, lblDCountry.Text, lblDPort.Text, Convert.ToDateTime(lblPODate.Text), "aslam", "aslam", MudarApp.Insert, lblInvoice.Text);
if (result)
{
foreach (GridViewRow gvr in gvPurchaseOrder.Rows)
{
string test = gvPurchaseOrder.DataKeys[gvr.DataItemIndex].Value.ToString();
result = invoiceObj.InvoiceProductDetailsINSandUPDandDEL(lblInvoice.Text, Convert.ToInt32(gvPurchaseOrder.DataKeys[gvr.DataItemIndex].Value.ToString()), Convert.ToDecimal((gvr.FindControl("lblQty") as Label).Text), Convert.ToDecimal((gvr.FindControl("lblGQty") as Label).Text), Convert.ToDecimal(gvr.Cells[3].Text), 0, Convert.ToDecimal(gvr.Cells[4].Text), "aslam", string.Empty, MudarApp.Insert);
}
generatePDFforPO();
}
Response.Redirect("~/Mudar/UpdateAdminOrder.aspx");
}
private int getTargetIDfromQS()
{
try
{
if (Request.QueryString["Target"] != null)
{
string qstr = Request.Url.Query;
string targetEnc = qstr.Substring(qstr.IndexOf("Target=") + 7);//Request.QueryString["Target"].ToString();
int targetID = -1;
int.TryParse(Encrypt_Decrypt.Decrypt(targetEnc, key), out targetID);
return(targetID);
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
return(-1);
}
private void BindgvInvoiceDetails()
{
decimal tPrice = 0, tDrums = 0;
//DataTable dtOrder = new DataTable();
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dtOBBD = orderObj.Order_Buyer_Branch_Details(Convert.ToInt32(OrderID));
if (dtOBBD.Rows.Count > 0)
{
foreach (DataRow dr in dtOBBD.Rows)
{
tPrice += Convert.ToDecimal(dr["TotalPrice"].ToString());
tDrums += Convert.ToDecimal(dr["Packing25"].ToString()) + Convert.ToDecimal(dr["Packing180"].ToString());
}
}
lblTotalDrums.Text = tDrums.ToString();
lblTotalAmount.Text = tPrice.ToString();
gvInvoiceOrder.DataSource = dtOBBD;
gvInvoiceOrder.DataBind();
}
private void BindPOProductDetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
lblPO.Text = dtPO.Rows[0]["PurchaseOrderID"].ToString();
lblPODate.Text = string.Format("{0: dd MMM yyyy}", dtPO.Rows[0]["OrderDate"]);
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
dlCOAdetails.DataSource = dtPOProductList;
dlCOAdetails.DataBind();
decimal Total_Durm = 0;
if (dtPOProductList.Rows.Count > 0)
{
for (int count = 0; count < dtPOProductList.Rows.Count; count++)
{
Total_Durm += Convert.ToDecimal(dtPOProductList.Rows[count]["Packing25"].ToString()) + Convert.ToDecimal(dtPOProductList.Rows[count]["Packing180"].ToString());
}
}
}
}
private void BindProductDetails()
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dt = new DataTable();
dt = orderobj.OrderProduct_BPO(Convert.ToInt32(OrderID));
if (dt.Rows.Count > 0)
{
gvPurchaseOrder.DataSource = dt;
gvPurchaseOrder.DataBind();
}
decimal totalamount = 0, totaldrum = 0, tDrums25 = 0, tDrums180 = 0;;
foreach (GridViewRow gvr in gvPurchaseOrder.Rows)
{
var lblQuantity = gvr.FindControl("lblQuantity") as Label;
var lblPacking25 = gvr.FindControl("lblPacking25") as Label;
var lblPacking180 = gvr.FindControl("lblPacking180") as Label;
var lblPOUPPrice = gvr.FindControl("lblPOUPPrice") as Label;
var lblTotalPriceAmount = gvr.FindControl("lblTotalPriceAmount") as Label;
lblTotalPriceAmount.Text = string.Format("{0:0.00}", (Convert.ToDecimal(lblQuantity.Text) * Convert.ToDecimal(lblPOUPPrice.Text)));
totalamount += Convert.ToDecimal(lblTotalPriceAmount.Text);
tDrums25 += Convert.ToDecimal(lblPacking25.Text);
tDrums180 += Convert.ToDecimal(lblPacking180.Text);
}
lblTotalprice.Text = totalamount.ToString();
lblTotalDrums.Text = totaldrum.ToString();
lblDrum25.Text = tDrums25.ToString();
lblDrum180.Text = tDrums180.ToString();
lblTotalprice.Text = string.Format("{0:0.00}", totalamount);
string[] word = lblTotalprice.Text.Split('.');
string main = NumberToWords(Convert.ToInt32(word[0].ToString()));
lblAmount_word.Text += main + ' ' + "Rupees";
if (Convert.ToInt32(word[1].ToString()) > 0)
{
string sub = NumberToWords(Convert.ToInt32(word[1].ToString()));
lblAmount_word.Text += ' ' + " and " + ' ' + sub + ' ' + "Paise";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string QorderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
if (!IsPostBack)
{
dtOrder = orderobj.OrderList(Convert.ToInt32(QorderID));
if (dtOrder.Rows.Count > 0)
{
DataRow dr = dtOrder.Rows[0];
if (dr["OrgType"].ToString() == "1")
{
lblOrgType.Text = "FT";
}
else
{
lblOrgType.Text = string.Empty;
}
Session["PurchaseOrderID"] = dr["PurchaseOrderID"].ToString();
Session["PODate"] = dtOrder.Rows[0]["OrderDate"].ToString();
}
//lblBPO.Text = objApp.GenerateBPOno();
lblBPO.Text = QorderID;
DateTime Tdate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
lblDate.Text = string.Format("{0:dd MMM yyyy}", Tdate);
lblPO.Text = Session["PurchaseOrderID"].ToString();
DateTime date = Convert.ToDateTime(Session["PODate"].ToString());
lblPODate.Text = string.Format("{0:dd MMM yyyy}", date);
BindSupplierList(rblBranchSupplier.SelectedValue);
//lblPO.Text = "LS.2";
BindProductDetails();
BindDelivaryDetails();
BindgvReports();
BindCustomAgent();
BindBranchAddress();
}
}
private void BindPODetails()
{
DataTable dtPO = orderObj.OrderList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
if (dtPO.Rows.Count > 0)
{
DataTable dtPOProductList = orderObj.OrderProductList(Convert.ToInt32(Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true)));
decimal Total_Durm = 0, Tare_wt = 0;
if (dtPOProductList.Rows.Count > 0)
{
for (int count = 0; count < dtPOProductList.Rows.Count; count++)
{
Total_Durm += Convert.ToDecimal(dtPOProductList.Rows[count]["Packing25"].ToString()) + Convert.ToDecimal(dtPOProductList.Rows[count]["Packing180"].ToString());
}
}
lblGrossWt.Text = Convert.ToDecimal(dtPOProductList.Rows[0]["GrossQuantity"]).ToString();
lblNetWt.Text = Convert.ToDecimal(dtPOProductList.Rows[0]["Quantity"]).ToString();
Tare_wt = Convert.ToDecimal(dtPOProductList.Rows[0]["GrossQuantity"].ToString()) - Convert.ToDecimal(dtPOProductList.Rows[0]["Quantity"].ToString());
lblTareWt.Text = Tare_wt.ToString();
lblDrumNo.Text = Total_Durm.ToString();
lblDCountry.Text = dtPO.Rows[0]["DestinationCountry"].ToString();
}
}
private void BindOrderReportPathdetails()
{
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
DataTable dtORPD = reportObj.OrderReportsPathGetDetails(Convert.ToInt32(OrderID));//Convert.ToInt32(lblBranchOrderID.Text));
if (dtORPD.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtORPD.Rows[0]["Invoice"].ToString()))
{
string[] path = dtORPD.Rows[0]["Invoice"].ToString().Split('/');
string[] path2 = path[path.Length - 1].Split('.');
string InvoiceID = path2[0].ToString();
hlInvoice.Text = InvoiceID;
}
hlInvoice.NavigateUrl = dtORPD.Rows[0]["Invoice"].ToString();
hlPacking.NavigateUrl = dtORPD.Rows[0]["Packing"].ToString();
hlCoverLetter.NavigateUrl = dtORPD.Rows[0]["Cover_Letter"].ToString();
hlFIRCover.NavigateUrl = dtORPD.Rows[0]["Fir_Cover_Letter"].ToString();
hlHazSea.NavigateUrl = dtORPD.Rows[0]["Non_Haz_Sea"].ToString();
hlHazAir.NavigateUrl = dtORPD.Rows[0]["Non_Haz_Air"].ToString();
bindReports(dtORPD);
}
}
protected void btnIntransitSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtIntransitDate.Text))
{
DateTime intransitDate = DateTime.ParseExact(txtIntransitDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
string etaStr = " ETA" + "<br/>" + intransitDate.ToString("dd MMM yyyy");
string OrderID = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
orderObj.UpdateOrderETA(Convert.ToInt32(OrderID), intransitDate.ToString());
DataTable dt = orderObj.Ordercountry(OrderID);
if (dt.Rows[0]["DestinationCountry"].ToString() == "INDIA")
{
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), etaStr, "Raghu", "<br/>" + "$" + txtDispatch.Text + " " + string.Format("{0:dd MMM yyyy}", DateTime.Now) + "$" + ' ' + etaStr);
}
else
{
orderObj.OrderDetails_UPD(Convert.ToInt32(OrderID), etaStr, "Raghu", "<br/>" + string.Format("{0:dd MMM yyyy}", DateTime.Now) + ' ' + etaStr);
}
Session["AdminOrderStatus"] = "INTRANSIT";
BinOrderStatusDetails("INTRANSIT");
ScriptManager.RegisterStartupScript(this, GetType(), "myFunction", "ManageTabs('CLOSE','" + Convert.ToString(Session["AdminOrderStatus"]) + "');", true);
Response.Redirect("~/Admin/OrderAdmin.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
if (Page.Request.QueryString.Count > 0 && Page.Request.QueryString["CID"] != null)
{
string ID = Encrypt_Decrypt.Decrypt(Page.Request.QueryString["CID"].ToString(), key);
long CID = 0;
if (long.TryParse(ID, out CID) && CID > 0)
{
int permisionLevel = 0;
if (Common.CheckUserInRole(UserID, 5))
{
permisionLevel = 1; // view all clients from all branches
}
else
{
if (Common.CheckUserInRole(UserID, 6))
{
permisionLevel = 2; // view all clients from my branche
}
else
{
List <string> groups = new List <string>();
groups.Add("SalesMen");
if (Common.CheckUserInGroups(UserID, groups))
{
permisionLevel = 3; // view my clients
}
}
}
if (permisionLevel > 0)
{
int BranchID = Common.GetUserBranchID(UserID);
V_Client_Useer client = new V_Client_Useer();
client.Where.ID.Value = CID;
if (permisionLevel == 2)
{
client.Where.BranchID.Value = BranchID;
}
if (permisionLevel == 3)
{
client.Where.SalesPersonID.Value = UserID;
}
if (client.Query.Load())
{
if (client.DefaultView != null && client.DefaultView.Count > 0)
{
DIV_Content.Visible = true;
Get_Client_Details(client);
if (Common.CheckUserInRole(UserID, 1) && client.BranchID == BranchID)
{
LBTN_Edit.Visible = true;
}
else
{
LBTN_Edit.Visible = false;
}
//GetTextboxes(int.Parse(myID));
LoadClientOrders(client.ID);
LoadClientVolume(client.ID);
LoadClientOpenOffer(client.ID);
if (client.SalesPersonID == UserID && Common.CheckUserInRole(UserID, 7))//AddNewOfferRole
{
btnCreateNewOffer.Visible = true;
}
if (client.s_SupportedByCompany != "")
{
if (client.SupportedByCompany)
{
CHB_SupportedByCompany.Checked = true;
TXT_SupportedBy.Visible = true;
TXT_SupportedBy.Text = client.SupportedBy;
}
}
}
else
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "Please Select a correct Client";
}
}
else
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "Please Select a correct Client";
}
}
else
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "You Don't have permission to view this client";
}
}
else
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "Please Select a correct Client";
}
}
else
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "Please Select a correct Client";
}
}
//String myString = HttpContext.Current.Request.Url.PathAndQuery;
//myString = myString.Substring(myString.IndexOf('?') + 1);
// String myID = getTaskLinkEnc(myString);
// Get_Client_Details(int.Parse(myID));
//ShowBoxesBasedOnType(myType);
//GetTextboxes(int.Parse(myID));
}
catch (Exception ex)
{
LBL_MSG.Visible = true;
LBL_MSG.Text = "Page_Load:" + ex.Message;
}
}
private void generatePDF()
{
string strpdf = "<table align='center' style='font-family:Verdana;width:885px;'><tr>";
strpdf += "<td width='50%'></td><td width='50%' align='right'> Date:" + lblTodayDate.Text + "</td></tr><tr>";
strpdf += "<td colspan='2' align='left'>" + txtAddress.Text.Replace("\r\n", "<br/>") + "</td></tr><tr>";
strpdf += "<td colspan='2'></td></tr><tr>";
strpdf += "<td colspan='2'></td></tr><tr>";
strpdf += "<td colspan='2'> Dear Sir:<span style='font-size:10px;'>" + txtDearsir.Text + "</td></tr><tr>";
strpdf += "<td colspan='2'></td></tr><tr>";
strpdf += "<td> Sub:- <span style='font-size:10px;'>Submission of Export Documents</td></tr><tr>";
strpdf += "<td colspan='2'></td></tr><tr>";
strpdf += "<td> Ref:- <span style='font-size:10px;'>Our Inv No : " + lblInviNo.Text + " Dt : " + lblInvoiceDate.Text + " </td><td align='center'><span style='font-size:10px;'>FIR no:" + txtFIRno.Text + "</td></tr><tr>";
strpdf += "<td colspan='2'></td></tr><tr>";
strpdf += "<td colspan='2'align='center' style='font-size: 10px;';>Please find the below mentioned documents against the above mentioned FIR</td></tr><tr>";
strpdf += "<td colspan='2' align='center'> </td></tr><tr>";
strpdf += "<td colspan='2'align='center'><table border='1'>'<tr>";
strpdf += "<td bgcolor='#FFCC66'><b> Description </b></td><td bgcolor='#FFCC66' colspan='3' ><b>Document Reference</b></td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>Buyer</td><td colspan='2'> " + lblCompanyAddress.Text + " </td><td> " + lblDestCountry.Text + " </td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>Inv No</td><td>" + lblInvoice.Text + "</td><td>Dt</td><td>" + lblInvoiceDt.Text + "</td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>Packing List No</td><td><asp:Label ID=" + lblInv.Text + " /></td><td>Dt</td><td><asp:Label ID='lblPackDt' runat='server' /></td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>AWB / BoL</td><td colspan='3'>" + lblAWB.Text + "</td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>SDF No</td><td>" + txtSDFNo.Text + "</td><td>Dt</td><td>" + txtSDFNoDt.Text + "</td></tr><tr>";
strpdf += "<td bgcolor='#FFCC66'>EP Copy</td><td>" + txtEPcopy.Text + "</td><td>Dt</td><td>" + txtEPcopyDt.Text + "</td></tr></table><tr>";
strpdf += "<td colspan='2' align='center'> </td></tr><tr>";
strpdf += "<td colspan='2' align='center'><span style='font-size:10px;'>Please find the details of FIR against the above mentioned shipment</td></tr><tr>";
strpdf += "<td colspan='2'><table border='1'><tr align='center'>";
strpdf += "<td bgcolor='#FFCC66'><b>Invoice<br />Amount in USD</b></td><td bgcolor='#FFCC66'><b> FIR NO </b></td><td bgcolor='#FFCC66'><b>FIR Date</b></td><td bgcolor='#FFCC66'><b>FIR Amount in USD</b></td><td bgcolor='#FFCC66'><b>Amount<br /> Against the Invoice in USD</b></td></tr><tr>";
strpdf += "<td><b>" + lblInvAmout.Text + "</b></td><td><b> " + lblFIRnum.Text + " </b></td><td><b>" + txtFIRDate.Text + "</b></td><td><b>" + txtFIRAmt.Text + "</b></td><td><b>" + txtAmtAgnistINV.Text + "</b></td></tr></table><tr align='center'>";
strpdf += "<td colspan='2' align='center'> </td></tr><tr>";
strpdf += "<td colspan='2' align='center'>Please acknowledge the receipt of all the documents in order</td></tr><tr>";
strpdf += "<td colspan='2' align='center'> </td></tr></table>";
Document document = new Document();
try
{
string Pdf_path = string.Empty;
string orderid = Encrypt_Decrypt.Decrypt(Session["sOrderID"].ToString().Trim(), true);
Pdf_path = mu.createfolder(orderid.ToString(), MudarUser.OrderPDF) ? WebConfigurationManager.AppSettings["orderpdf"].ToString() + orderid.ToString() + "/FIR_Covering Letter_" + orderid + ".pdf" : WebConfigurationManager.AppSettings["orderpdf"].ToString() + "/FIR_Covering Letter_" + orderid + ".pdf";
//writer - have our own path!!!
PdfWriter.GetInstance(document, new FileStream(Server.MapPath(Pdf_path), FileMode.Create));
document.Open();
//Here is where your HTML source goes................
String htmlText = strpdf.ToString();
//make an arraylist ....with STRINGREADER since its no IO reading file...
List <IElement> htmlarraylist = iTextSharp.text.html.simpleparser.HTMLWorker.ParseToList(new StringReader(htmlText), null);
////add the collection to the document
//for (int k = 0; k < htmlarraylist.Count; k++)
//{
// document.Add((IElement)htmlarraylist[k]);
//}
//document.Add(new Paragraph("And the same with indentation...."));
// or add the collection to an paragraph
// if you add it to an existing non emtpy paragraph it will insert it from
//the point youwrite -
Paragraph mypara = new Paragraph();//make an emtphy paragraph as "holder"
mypara.IndentationLeft = 20;
mypara.InsertRange(0, htmlarraylist);
document.Add(mypara);
document.Close();
bool result = reportObj.OrderReportsPathInsertandUpdate(Convert.ToInt32(orderid), Convert.ToInt32(Session["BranchOrderID_S"].ToString()), Pdf_path, "Bhanu", string.Empty, rtypeObj.Fir_Cover_Letter);
}
catch (Exception exx)
{
Response.Write("<br>____________________________________<br>");
Response.Write("<br>Error: " + exx + "<br>");
Response.Write("<br>StackTrace: " + exx.StackTrace + "<br>");
Response.Write("<br>strPDFDocument: " + strpdf.ToString() + "<br>");
Response.Write("<br>strSelectUserListBuilder: " + strpdf.ToString() + "<br>");
//Console.Error.WriteLine(exx.StackTrace);
//Console.Error.WriteLine(exx.StackTrace);
}
finally
{
//document.Close();
}
}
