protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                int id         = Convert.ToInt32(Request.QueryString["id"]);
                int locationId = Convert.ToInt32(Request.QueryString["location"]);
                if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
                {
                    string invoicetype = "";
                    try
                    {
                        invoicetype = Request.QueryString["invoicetype"].ToString();
                    }
                    catch (Exception)
                    {
                    }
                    Entities.Register.SalesQuoteRegister sr = new Entities.Register.SalesQuoteRegister();
                    sr = Entities.Register.SalesQuoteRegister.GetDetails(id, locationId);
                    dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
                    lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
                    Entities.Master.Company c = new Entities.Master.Company();
                    c = Entities.Master.Company.GetDetailsByLocation(locationId);
                    lblCompRegNo.Text = c.RegId1;
                    imgLogo.ImageUrl  = "data:image/jpeg;base64, " + c.LogoBase64;
                    //lblCustName.Text = sr.Customer;
                    lblCustomer.Text         = sr.BillingAddress[0].ContactName;
                    lblCustomerAddress1.Text = sr.BillingAddress[0].Address1;
                    lblCustomerAddress2.Text = sr.BillingAddress[0].Address2;
                    lblCustPh.Text           = sr.BillingAddress[0].Phone1;
                    lblCustEmail.Text        = sr.BillingAddress[0].Email;
                    lblCustTRN.Text          = sr.CustomerTaxNo;
                    lblComp.Text             = sr.Company;
                    lblTerms.Text            = sr.TermsandConditon;
                    lblJob.Text          = sr.JobName;
                    lblCompAddr1.Text    = c.Address1;
                    lblCompAddr2.Text    = c.Address2;
                    lblCompPh.Text       = c.MobileNo1;
                    lblCompEmail.Text    = c.Email;
                    lblCustPhone.Text    = sr.BillingAddress[0].Phone1;
                    lblCompanyEmail.Text = c.Email;
                    lblLocName.Text      = sr.Location;
                    lblLocAddr1.Text     = sr.LocationAddress1;
                    lblLocAddr2.Text     = sr.LocationAddress2;
                    lblWords.Text        = NumberToWords(Convert.ToDouble(sr.NetAmount));
                    //lblCustName.Text = sr.Customer;
                    //lblDiscount.Text = Convert.ToString(sr.Discount);
                    //lblFreight.Text = Convert.ToString(sr.FreightAmount);
                    lblLocPhone.Text  = sr.LocationPhone;
                    lblDate.Text      = sr.EntryDateString;
                    lblInvoiceNo.Text = sr.QuoteNumber;
                    lblTax.Text       = Convert.ToString(sr.TaxAmount);
                    lblGross.Text     = Convert.ToString(sr.Gross);
                    lblroundOff.Text  = Convert.ToString(sr.RoundOff);
                    //lblNet.Text = Convert.ToString(sr.NetAmount);
                    lblAmountinWords.Text = Convert.ToString(sr.NetAmount);
                    lblComp.Text          = sr.Company;
                    //lblDuedate.Text = sr.EntryDateString;
                    lblCompanyPhone.Text = c.OfficeNo;
                    //lblAddress.Text = sr.CustomerAddress;
                    //lblCustName.Text = sr.Customer;
                    lblCustPhone.Text = sr.BillingAddress[0].Phone1;
                    //lblTfn.Text = sr.CustomerTaxNo;
                    lblProjectName.Text = sr.JobName;

                    lblDeduction.Text = Convert.ToString(sr.Discount);
                    lblMainHead.Text  = "Sales Order";
                    tAndC.Text        = sr.TermsandConditon; //Entities.Application.Settings.GetSetting(148);

                    if (invoicetype == "delivery")
                    {
                        thRate.Visible  = false;
                        thTotal.Visible = false;

                        for (int i = 0; i < sr.Products.Count; i++)
                        {
                            TableRow  r  = new TableRow();
                            TableCell t1 = new TableCell();
                            t1.Text = (i + 1).ToString();
                            r.Cells.Add(t1);
                            //TableCell t2 = new TableCell();
                            //t2.Text = sr.Products[i].ItemCode;
                            //r.Cells.Add(t2);
                            if (setting.EnableDescription)//Enabled Description
                            {
                                TableCell t3 = new TableCell();
                                t3.Width = 500;
                                string itemName = "<b>";
                                itemName += sr.Products[i].Name;
                                itemName += "</b><br/>";
                                itemName += sr.Products[i].Description;
                                t3.Text   = itemName;
                                r.Cells.Add(t3);
                            }
                            else
                            {
                                TableCell t3 = new TableCell();
                                t3.Text = sr.Products[i].Name;
                                r.Cells.Add(t3);
                            }

                            TableCell t4 = new TableCell();
                            t4.Text = sr.Products[i].Quantity.ToString();
                            t4.Style.Add("text-align", "right");
                            r.Cells.Add(t4);

                            TableCell t5 = new TableCell();
                            t5.Text = sr.Products[i].Unit.ToString();
                            t5.Style.Add("text-align", "right");
                            r.Cells.Add(t5);
                            //TableCell t5 = new TableCell();
                            //t5.Text = sr.Products[i].MRP.ToString();
                            //r.Cells.Add(t5);
                            //TableCell t6 = new TableCell();
                            //t6.Text = sr.Products[i].SellingPrice.ToString();
                            //r.Cells.Add(t6);
                            //TableCell t7 = new TableCell();
                            //t7.Text = sr.Products[i].TaxPercentage.ToString();
                            //r.Cells.Add(t7);
                            //TableCell t8 = new TableCell();
                            //t8.Text = sr.Products[i].Gross.ToString();
                            //r.Cells.Add(t8);
                            //TableCell t9 = new TableCell();
                            //t9.Text = sr.Products[i].TaxAmount.ToString();
                            //r.Cells.Add(t9);
                            //TableCell t10 = new TableCell();
                            //t10.Text = sr.Products[i].NetAmount.ToString();
                            //r.Cells.Add(t10);
                            listTable.Rows.Add(r);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < sr.Products.Count; i++)
                        {
                            TableRow  r  = new TableRow();
                            TableCell t1 = new TableCell();
                            t1.Text = (i + 1).ToString();
                            r.Cells.Add(t1);
                            //TableCell t2 = new TableCell();
                            //t2.Text = sr.Products[i].ItemCode;
                            //r.Cells.Add(t2);
                            if (setting.EnableDescription)//Enabled Description
                            {
                                TableCell t3 = new TableCell();
                                t3.Width = 500;
                                string itemName = "<b>";
                                itemName += sr.Products[i].Name;
                                itemName += "</b><br/>";
                                itemName += sr.Products[i].Description;
                                t3.Text   = itemName;
                                r.Cells.Add(t3);
                            }
                            else
                            {
                                TableCell t3 = new TableCell();
                                t3.Text = sr.Products[i].Name;
                                r.Cells.Add(t3);
                            }

                            TableCell t4 = new TableCell();
                            t4.Text = sr.Products[i].Quantity.ToString();
                            t4.Style.Add("text-align", "right");
                            r.Cells.Add(t4);

                            TableCell t5 = new TableCell();
                            t5.Text = sr.Products[i].Unit.ToString();
                            t5.Style.Add("text-align", "right");
                            r.Cells.Add(t5);
                            //TableCell t5 = new TableCell();
                            //t5.Text = sr.Products[i].MRP.ToString();
                            //r.Cells.Add(t5);
                            TableCell t6 = new TableCell();
                            t6.Text = sr.Products[i].SellingPrice.ToString();
                            t6.Style.Add("text-align", "right");
                            r.Cells.Add(t6);
                            //TableCell t7 = new TableCell();
                            //t7.Text = sr.Products[i].TaxPercentage.ToString();
                            //r.Cells.Add(t7);
                            //TableCell t8 = new TableCell();
                            //t8.Text = sr.Products[i].Gross.ToString();
                            //r.Cells.Add(t8);
                            //TableCell t9 = new TableCell();
                            //t9.Text = sr.Products[i].TaxAmount.ToString();
                            //r.Cells.Add(t9);
                            TableCell t10 = new TableCell();
                            t10.Text = sr.Products[i].Gross.ToString();
                            t10.Style.Add("text-align", "right");
                            r.Cells.Add(t10);
                            listTable.Rows.Add(r);
                        }

                        TableFooterRow tf            = new TableFooterRow();
                        TableFooterRow TaxAmountcell = new TableFooterRow();
                        TableFooterRow SubTotal      = new TableFooterRow();
                        tf.CssClass            = "inv-footer beige";
                        TaxAmountcell.CssClass = "inv-footer beige";
                        SubTotal.CssClass      = "inv-footer ";

                        TableCell tfc1 = new TableCell();
                        tfc1.Text = "<b>VAT AMOUNT</b>";

                        tfc1.ColumnSpan      = 5;
                        tfc1.HorizontalAlign = HorizontalAlign.Right;
                        TaxAmountcell.Cells.Add(tfc1);
                        TableCell tfc2 = new TableCell();
                        tfc2.Text            = "<b>" + Convert.ToString(sr.TaxAmount) + "</b>";
                        tfc2.HorizontalAlign = HorizontalAlign.Right;
                        TaxAmountcell.Cells.Add(tfc2);
                        listTable.Rows.Add(TaxAmountcell);

                        TableCell tfc3 = new TableCell();
                        tfc3.Text            = "<b>SUB TOTAL</b>";
                        tfc3.ColumnSpan      = 5;
                        tfc3.HorizontalAlign = HorizontalAlign.Right;
                        SubTotal.Cells.Add(tfc3);
                        TableCell tfc4 = new TableCell();
                        tfc4.Text            = "<b>" + Convert.ToString(sr.Gross) + "</b>";
                        tfc4.HorizontalAlign = HorizontalAlign.Right;
                        SubTotal.Cells.Add(tfc4);
                        listTable.Rows.Add(SubTotal);



                        TableCell tfc5 = new TableCell();
                        tfc5.Text            = "<b>GRAND TOTAL ( " + setting.CurrencySymbol + " )</b>";
                        tfc5.ColumnSpan      = 5;
                        tfc5.HorizontalAlign = HorizontalAlign.Right;
                        tf.Cells.Add(tfc5);
                        TableCell tfc6 = new TableCell();
                        tfc6.Text            = "<b>" + Convert.ToString(sr.NetAmount) + "</b>";
                        tfc6.HorizontalAlign = HorizontalAlign.Right;
                        tf.Cells.Add(tfc6);
                        listTable.Rows.Add(tf);
                    }
                }
            }
            catch (Exception ex)
            {
                Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
                Response.Write("<script> alert('" + ex.Message + "') </script>");
            }
        }
Exemple #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         int id         = Convert.ToInt32(Request.QueryString["id"]);
         int locationId = Convert.ToInt32(Request.QueryString["location"]);
         if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
         {
             Entities.Register.SalesQuoteRegister sq = new Entities.Register.SalesQuoteRegister();
             sq = Entities.Register.SalesQuoteRegister.GetDetails(id, locationId);
             dynamic setting           = Entities.Application.Settings.GetFeaturedSettings();
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationId);
             int     User = Convert.ToInt32(Request.QueryString["lid"]);
             dynamic obj;
             if (Request.QueryString["lid"] != null)
             {
                 obj = Entities.Application.User.GetUserDetails(User);
             }
             else
             {
                 obj = Entities.Application.User.GetUserDetails(CPublic.GetuserID());
             }
             //dynamic obj = Entities.Application.User.GetUserDetails(CPublic.GetuserID());
             lblUserName.Text       = obj.UserName;
             lblDesignation.Text    = obj.Designation;
             lblCompanyContact.Text = obj.Mobile;
             lblCompanyEmail.Text   = obj.Email;
             imgLogo.ImageUrl       = "data:image/jpeg;base64, " + c.LogoBase64;
             imgLogo1.ImageUrl      = "data:image/jpeg;base64, " + c.LogoBase64;
             imgLogo2.ImageUrl      = "data:image/jpeg;base64, " + c.LogoBase64;
             imgLogo3.ImageUrl      = "data:image/jpeg;base64, " + c.LogoBase64;
             lblCustCompany.Text    = sq.Customer_Name;
             lblCompany.Text        = sq.Company;
             lblCustemail.Text      = sq.BillingAddress[0].Email;
             lblCustState.Text      = sq.BillingAddress[0].State + "," + sq.BillingAddress[0].Country;
             //lblCompanyContact.Text = c.MobileNo1;
             //lblCompanyEmail.Text = sq.CompanyEmail;
             lblDate.Text      = sq.EntryDateString;
             lblReference.Text = sq.QuoteNumber;
             tAndC.Text        = sq.TermsandConditon;
             foreach (var billing in sq.BillingAddress)
             {
                 lblCustName.Text = billing.ContactName;
             }
             for (int i = 0; i < sq.Products.Count; i++)
             {
                 TableRow r = new TableRow();
                 //TableCell t1 = new TableCell();
                 //t1.Text = (i + 1).ToString();
                 //r.Cells.Add(t1);
                 TableCell t2 = new TableCell();
                 t2.Text = sq.Products[i].ItemCode;
                 r.Cells.Add(t2);
                 //TableCell t3 = new TableCell();
                 //t3.Text = sq.Products[i].Name;
                 //r.Cells.Add(t3);
                 if (setting.EnableDescription)//Enabled Description
                 {
                     TableCell t3 = new TableCell();
                     t3.Width = 500;
                     string itemName = "<b>";
                     itemName += sq.Products[i].Name;
                     itemName += "</b><br/>";
                     itemName += sq.Products[i].Description;
                     t3.Text   = itemName;
                     r.Cells.Add(t3);
                 }
                 else
                 {
                     TableCell t3 = new TableCell();
                     t3.Text = sq.Products[i].Name;
                     r.Cells.Add(t3);
                 }
                 TableCell t4 = new TableCell();
                 t4.Text = sq.Products[i].Quantity.ToString();
                 r.Cells.Add(t4);
                 //TableCell t5 = new TableCell();
                 //t5.Text = sq.Products[i].MRP.ToString();
                 //r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = sq.Products[i].SellingPrice.ToString();
                 r.Cells.Add(t6);
                 //TableCell t7 = new TableCell();
                 //t7.Text = sq.Products[i].TaxPercentage.ToString();
                 //r.Cells.Add(t7);
                 //TableCell t8 = new TableCell();
                 //t8.Text = sq.Products[i].Gross.ToString();
                 //r.Cells.Add(t8);
                 //TableCell t9 = new TableCell();
                 //t9.Text = sq.Products[i].TaxAmount.ToString();
                 //r.Cells.Add(t9);
                 TableCell t10 = new TableCell();
                 t10.Text = sq.Products[i].NetAmount.ToString();
                 r.Cells.Add(t10);
                 listTable.Rows.Add(r);
             }
             TableFooterRow tf = new TableFooterRow();
             //TableCell tfc1 = new TableCell();
             //tf.Cells.Add(tfc1);
             //TableCell tfc2 = new TableCell();
             //tf.Cells.Add(tfc2);
             //TableCell tfc3 = new TableCell();
             //tf.Cells.Add(tfc3);
             //TableCell tfc4 = new TableCell();
             //tf.Cells.Add(tfc4);
             TableCell tfc5 = new TableCell();
             tfc5.Text            = "<b>Total in " + setting.CurrencySymbol + "</b>";
             tfc5.ColumnSpan      = 4;
             tfc5.HorizontalAlign = HorizontalAlign.Right;
             tf.Cells.Add(tfc5);
             TableCell tfc6 = new TableCell();
             tfc6.Text            = "<b>" + Convert.ToString(sq.Gross) + "</b>";
             tfc6.HorizontalAlign = HorizontalAlign.Right;
             tf.Cells.Add(tfc6);
             listTable.Rows.Add(tf);
             TableFooterRow TaxAmountcell = new TableFooterRow();
             TableCell      tfc1          = new TableCell();
             tfc1.Text            = "<b>VAT AMOUNT</b>";
             tfc1.ColumnSpan      = 4;
             tfc1.HorizontalAlign = HorizontalAlign.Right;
             TaxAmountcell.Cells.Add(tfc1);
             TableCell tfc2 = new TableCell();
             tfc2.Text            = "<b>" + Convert.ToString(sq.TaxAmount) + "</b>";
             tfc2.HorizontalAlign = HorizontalAlign.Right;
             TaxAmountcell.Cells.Add(tfc2);
             listTable.Rows.Add(TaxAmountcell);
             TableFooterRow TotalCell = new TableFooterRow();
             TableCell      tfc3      = new TableCell();
             tfc3.Text            = "<b>Grand Total in " + setting.CurrencySymbol + "</b>";
             tfc3.ColumnSpan      = 4;
             tfc3.HorizontalAlign = HorizontalAlign.Right;
             TotalCell.Cells.Add(tfc3);
             TableCell tfc4 = new TableCell();
             tfc4.Text            = "<b>" + Convert.ToString(sq.NetAmount) + "</b>";
             tfc4.HorizontalAlign = HorizontalAlign.Right;
             TotalCell.Cells.Add(tfc4);
             listTable.Rows.Add(TotalCell);
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
Exemple #3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         int id         = Convert.ToInt32(Request.QueryString["Id"]);
         int locationid = Convert.ToInt32(Request.QueryString["location"]);
         if (Request.QueryString["Id"] != null && Request.QueryString["location"] != null)
         {
             Entities.Register.SalesQuoteRegister sq = new Entities.Register.SalesQuoteRegister();
             sq = Entities.Register.SalesQuoteRegister.GetDetails(id, locationid);
             dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationid);
             imgLogo.ImageUrl    = "data:image/jpeg;base64, " + c.LogoBase64;
             lblCustName.Text    = sq.Customer_Name;
             lblCompRegId.Text   = sq.CompanyRegId;
             lblLocRegId.Text    = sq.LocationRegId;
             lblCity.Text        = c.City;
             lblCompState.Text   = c.State;
             lblCompCountry.Text = c.Country;
             lblCustState.Text   = sq.BillingAddress[0].State;
             lblCustCountry.Text = sq.BillingAddress[0].Country;
             lblCustTaxNo.Text   = sq.CustomerTaxNo;
             lblCustAddr1.Text   = sq.BillingAddress[0].Address1;
             lblCustAddr2.Text   = sq.BillingAddress[0].Address2;
             lblComp.Text        = sq.Company;
             lblCompAddr1.Text   = c.Address1;
             lblCompAddr2.Text   = c.Address2;
             lblCompPh.Text      = c.MobileNo1;
             lblCompRegId.Text   = c.RegId1;
             lblCustPhone.Text   = sq.BillingAddress[0].Phone1;
             lblLocName.Text     = sq.Location;
             lblLocAddr1.Text    = sq.LocationAddress1;
             lblLocAddr2.Text    = sq.LocationAddress2;
             lblLocPhone.Text    = sq.LocationPhone;
             lblDate.Text        = sq.EntryDateString;
             lblInvoiceNo.Text   = sq.QuoteNumber;
             lblTotal.Text       = Convert.ToString(sq.Gross);
             lblTax.Text         = Convert.ToString(sq.TaxAmount);
             lblNet.Text         = Convert.ToString(sq.NetAmount);
             lblroundOff.Text    = Convert.ToString(sq.RoundOff);
             tAndC.Text          = Entities.Application.Settings.GetSetting(115);
             for (int i = 0; i < sq.Products.Count; i++)
             {
                 TableRow  r  = new TableRow();
                 TableCell t1 = new TableCell();
                 t1.Text = (i + 1).ToString();
                 r.Cells.Add(t1);
                 TableCell t2 = new TableCell();
                 t2.Text = sq.Products[i].ItemCode;
                 r.Cells.Add(t2);
                 TableCell t3 = new TableCell();
                 t3.Text = sq.Products[i].Name;
                 r.Cells.Add(t3);
                 TableCell t4 = new TableCell();
                 t4.Text = sq.Products[i].MRP.ToString();
                 r.Cells.Add(t4);
                 TableCell t5 = new TableCell();
                 t5.Text = sq.Products[i].SellingPrice.ToString();
                 r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = sq.Products[i].Quantity.ToString();
                 r.Cells.Add(t6);
                 TableCell t7 = new TableCell();
                 t7.Text = sq.Products[i].Gross.ToString();
                 r.Cells.Add(t7);
                 TableCell t8 = new TableCell();
                 t8.Text = sq.Products[i].TaxPercentage.ToString();
                 r.Cells.Add(t8);
                 if (c.StateId == sq.BillingAddress[0].StateID)
                 {
                     TableCell t9 = new TableCell();
                     t9.Text = (Convert.ToDecimal(sq.Products[i].TaxAmount) / 2).ToString();
                     r.Cells.Add(t9);
                     TableCell t10 = new TableCell();
                     t10.Text = (Convert.ToDecimal(sq.Products[i].TaxAmount) / 2).ToString();
                     r.Cells.Add(t10);
                     TableCell t11 = new TableCell();
                     t11.Text = "0.00";
                     r.Cells.Add(t11);
                 }
                 else
                 {
                     TableCell t9 = new TableCell();
                     t9.Text = "0.00";
                     r.Cells.Add(t9);
                     TableCell t10 = new TableCell();
                     t10.Text = "0.00";
                     r.Cells.Add(t10);
                     TableCell t11 = new TableCell();
                     t11.Text = sq.Products[i].TaxAmount.ToString();
                     r.Cells.Add(t11);
                 }
                 TableCell t12 = new TableCell();
                 t12.Text = sq.Products[i].NetAmount.ToString();
                 r.Cells.Add(t12);
                 listTable.Rows.Add(r);
             }
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "quote | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         int id         = Convert.ToInt32(Request.QueryString["id"]);
         int locationId = Convert.ToInt32(Request.QueryString["location"]);
         if (Request.QueryString["id"] != null && Request.QueryString["location"] != null)
         {
             Entities.Register.SalesQuoteRegister sq = new Entities.Register.SalesQuoteRegister();
             sq = Entities.Register.SalesQuoteRegister.GetDetails(id, locationId);
             dynamic setting = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(setting.CurrencySymbol);
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationId);
             imgLogo.ImageUrl        = "data:image/jpeg;base64, " + c.LogoBase64;
             lblCustName.Text        = sq.Customer_Name;
             lblComp.Text            = sq.Company;
             lblCompAddr1.Text       = c.Address1;
             lblCompAddr2.Text       = c.Address2;
             lblCompPh.Text          = c.MobileNo1;
             lblCompGst.Text         = c.RegId1;
             lblCompEmail.Text       = sq.CompanyEmail;
             lblCustPhone.Text       = sq.BillingAddress[0].Phone1;
             lblLocName.Text         = sq.Location;
             lblLocAddr1.Text        = sq.LocationAddress1;
             lblLocAddr2.Text        = sq.LocationAddress2;
             lblLocPhone.Text        = sq.LocationPhone;
             lblDate.Text            = sq.EntryDateString;
             lblCompName.Text        = sq.Company;
             lblInvoiceNo.Text       = sq.QuoteNumber;
             lblTax.Text             = Convert.ToString(sq.TaxAmount);
             lblGross.Text           = Convert.ToString(sq.Gross);
             lblroundOff.Text        = Convert.ToString(sq.RoundOff);
             lblNet.Text             = Convert.ToString(sq.NetAmount);
             lblAmountinWords.Text   = NumberToWords(Convert.ToDouble(sq.NetAmount));
             tAndC.Text              = sq.TermsandConditon;
             lblPaymentTerms.Text    = sq.Payment_Terms;
             lblValidity.Text        = sq.Validity;
             lblCompletion.Text      = sq.ETA;
             lblProjectName.Text     = sq.JobName;
             lblCustAddress.Text     = sq.BillingAddress[0].Address1;
             lblCustAddress2.Text    = sq.BillingAddress[0].Address2;
             lblCustEmail.Text       = sq.BillingAddress[0].Email;
             lblCustCompanyName.Text = sq.Customer_Name;
             lblTRN.Text             = sq.CustomerTaxNo;
             for (int i = 0; i < sq.Products.Count; i++)
             {
                 TableRow  r  = new TableRow();
                 TableCell t1 = new TableCell();
                 t1.Text = (i + 1).ToString();
                 r.Cells.Add(t1);
                 //TableCell t2 = new TableCell();
                 //t2.Text = sq.Products[i].ItemCode;
                 //r.Cells.Add(t2);
                 //TableCell t3 = new TableCell();
                 //t3.Text = sq.Products[i].Name;
                 //r.Cells.Add(t3);
                 if (setting.EnableDescription)//Enabled Description
                 {
                     TableCell t3 = new TableCell();
                     t3.Width = 500;
                     string itemName = "<b>";
                     itemName += sq.Products[i].Name;
                     itemName += "</b><br/>";
                     itemName += sq.Products[i].Description;
                     t3.Text   = itemName;
                     r.Cells.Add(t3);
                 }
                 else
                 {
                     TableCell t3 = new TableCell();
                     t3.Text = sq.Products[i].Name;
                     r.Cells.Add(t3);
                 }
                 TableCell t4 = new TableCell();
                 t4.Text = sq.Products[i].Quantity.ToString();
                 r.Cells.Add(t4);
                 //TableCell t5 = new TableCell();
                 //t5.Text = sq.Products[i].MRP.ToString();
                 //r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = sq.Products[i].SellingPrice.ToString();
                 r.Cells.Add(t6);
                 //TableCell t7 = new TableCell();
                 //t7.Text = sq.Products[i].TaxPercentage.ToString();
                 //r.Cells.Add(t7);
                 TableCell t8 = new TableCell();
                 t8.Text = sq.Products[i].Gross.ToString();
                 r.Cells.Add(t8);
                 TableCell t9 = new TableCell();
                 t9.Text = sq.Products[i].TaxAmount.ToString();
                 r.Cells.Add(t9);
                 TableCell t10 = new TableCell();
                 t10.Text = sq.Products[i].NetAmount.ToString();
                 r.Cells.Add(t10);
                 listTable.Rows.Add(r);
             }
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }