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