예제 #1
0
    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");
    }
예제 #3
0
    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();
        }
    }
예제 #4
0
    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");
    }
예제 #6
0
    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'>&nbsp;</td></tr><tr>";
        strpdf += "<td colspan='4' align='center'>We declare that the below mentioned goods</td></tr><tr>";
        strpdf += "<td colspan='4'>&nbsp;</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;'>&nbsp;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'>&nbsp;through our Invoice No&nbsp;:<span style='font-size:10px;'>" + lblInvoice.Text + " </td><td width='25%'>&nbsp;Date&nbsp; :<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();
        }
    }
예제 #9
0
    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();
        }
    }
예제 #10
0
    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);
    }
예제 #12
0
    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();
        }
    }
예제 #19
0
    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);
 }
예제 #22
0
    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();
    }
예제 #23
0
    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());
                }
            }
        }
    }
예제 #24
0
    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";
        }
    }
예제 #25
0
    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");
     }
 }
예제 #29
0
        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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dear Sir:<span style='font-size:10px;'>" + txtDearsir.Text + "</td></tr><tr>";
        strpdf += "<td colspan='2'></td></tr><tr>";
        strpdf += "<td>&nbsp;Sub:- <span style='font-size:10px;'>Submission of Export Documents</td></tr><tr>";
        strpdf += "<td colspan='2'></td></tr><tr>";
        strpdf += "<td>&nbsp;Ref:- <span style='font-size:10px;'>Our Inv No : " + lblInviNo.Text + " &nbsp;&nbsp;&nbsp;  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'>&nbsp;</td></tr><tr>";
        strpdf += "<td colspan='2'align='center'><table border='1'>'<tr>";
        strpdf += "<td bgcolor='#FFCC66'><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></td><td bgcolor='#FFCC66' colspan='3' ><b>Document Reference</b></td></tr><tr>";
        strpdf += "<td bgcolor='#FFCC66'>Buyer</td><td colspan='2'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + lblCompanyAddress.Text + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td>&nbsp;&nbsp;" + lblDestCountry.Text + " &nbsp;&nbsp;&nbsp;</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'>&nbsp;</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>&nbsp;&nbsp;&nbsp;FIR NO&nbsp;&nbsp;&nbsp;</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>&nbsp;&nbsp;" + lblFIRnum.Text + "&nbsp;&nbsp;</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'>&nbsp;</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'>&nbsp;</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();
        }
    }