예제 #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     hdApiUrl.Value = WebConfigurationManager.AppSettings["APIURL"].ToString();
     Entities.Master.Company c = new Entities.Master.Company();
     c = Entities.Master.Company.GetDetailsByLocation(CPublic.GetLocationID());
     imgLogo.ImageUrl = "data:image/jpeg;base64, " + c.LogoBase64;
 }
예제 #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.SalesRequestRegister sr = new Entities.Register.SalesRequestRegister();
             sr = Entities.Register.SalesRequestRegister.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  = sr.CustomerName;
             lblComp.Text      = sr.Company;
             lblCompAddr1.Text = c.Address1;
             lblCompAddr2.Text = c.Address2;
             lblCompPh.Text    = c.MobileNo1;
             lblCompGst.Text   = c.RegId1;
             lblCompEmail.Text = c.Email;
             lblCustPhone.Text = sr.BillingAddress[0].Phone1;
             lblLocName.Text   = sr.Location;
             lblLocAddr1.Text  = sr.LocationAddress1;
             lblLocAddr2.Text  = sr.LocationAddress2;
             lblLocPhone.Text  = sr.LocationPhone;
             lblDate.Text      = sr.EntryDateString;
             lblInvoiceNo.Text = sr.RequestNo;
             lblTax.Text       = Convert.ToString(sr.TaxAmount);
             lblGross.Text     = Convert.ToString(sr.Gross);
             lblroundOff.Text  = Convert.ToString(sr.RoundOff);
             lblNet.Text       = Convert.ToString(sr.NetAmount);
             tAndC.Text        = sr.TermsandConditon; //Entities.Application.Settings.GetSetting(127);
             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);
                 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();
                 r.Cells.Add(t4);
                 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);
             }
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "Request | Page_Load(object sender, EventArgs e) ");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
예제 #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.PurchaseQuoteRegister pq = new Entities.Register.PurchaseQuoteRegister();
             pq = Entities.Register.PurchaseQuoteRegister.GetDetails(id, locationid);
             dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationid);
             imgLogo.ImageUrl  = "data:image/jpeg;base64, " + c.LogoBase64;
             lblSupName.Text   = pq.Supplier;
             lblComp.Text      = pq.Company;
             lblCompAddr1.Text = c.Address1;
             lblCompAddr2.Text = c.Address2;
             lblCompPh.Text    = c.MobileNo1;
             lblCompEmail.Text = c.Email;
             lblCompGst.Text   = c.RegId1;
             lblSupPhone.Text  = pq.BillingAddress[0].Phone1;
             lblLocName.Text   = pq.Location;
             lblLocAddr1.Text  = pq.LocationAddress1;
             lblLocAddr2.Text  = pq.LocationAddress2;
             lblLocPhone.Text  = pq.LocationPhone;
             lblDate.Text      = pq.EntryDateString;
             lblInvoiceNo.Text = pq.QuoteNumber;
             lblTax.Text       = Convert.ToString(pq.TaxAmount);
             lblGross.Text     = Convert.ToString(pq.Gross);
             lblroundOff.Text  = Convert.ToString(pq.RoundOff);
             lblNet.Text       = Convert.ToString(pq.NetAmount);
             tAndC.Text        = Entities.Application.Settings.GetSetting(118);
             for (int i = 0; i < pq.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 = pq.Products[i].ItemCode;
                 r.Cells.Add(t2);
                 if (settings.EnableDescription)
                 {
                     TableCell t3 = new TableCell();
                     t3.Width = 500;
                     string itemName = "<b>";
                     itemName += pq.Products[i].Name;
                     itemName += "</b><br/>";
                     itemName += pq.Products[i].Description;
                     t3.Text   = itemName;
                     r.Cells.Add(t3);
                 }
                 else
                 {
                     TableCell t3 = new TableCell();
                     t3.Text = pq.Products[i].Name;
                     r.Cells.Add(t3);
                 }
                 TableCell t4 = new TableCell();
                 t4.Text = pq.Products[i].Quantity.ToString();
                 r.Cells.Add(t4);
                 TableCell t5 = new TableCell();
                 t5.Text = pq.Products[i].MRP.ToString();
                 r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = pq.Products[i].CostPrice.ToString();
                 r.Cells.Add(t6);
                 TableCell t7 = new TableCell();
                 t7.Text = pq.Products[i].Gross.ToString();
                 r.Cells.Add(t7);
                 TableCell t8 = new TableCell();
                 t8.Text = pq.Products[i].TaxPercentage.ToString();
                 r.Cells.Add(t8);
                 TableCell t9 = new TableCell();
                 t9.Text = pq.Products[i].TaxAmount.ToString();
                 r.Cells.Add(t9);
                 TableCell t10 = new TableCell();
                 t10.Text = pq.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>");
     }
 }
예제 #4
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.WareHousing.Damage d = new Entities.WareHousing.Damage();
             d = Entities.WareHousing.Damage.GetDetails(id, locationid);
             dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationid);
             imgLogo.ImageUrl  = "data:image/jpeg;base64, " + c.LogoBase64;
             lblCompAddr1.Text = c.Address1;
             lblComp.Text      = c.Name;
             lblCompEmail.Text = c.Email;
             lblCompPh.Text    = c.Address1;
             lblLocName.Text   = d.Location;
             lblLocAddr1.Text  = d.LocationAddress1;
             lblLocAddr2.Text  = d.LocationAddress2;
             lblLocPhone.Text  = d.LocationPhone;
             lblDate.Text      = d.EntryDateString;
             lblInvoiceNo.Text = d.DamageNo;
             lblGross.Text     = Convert.ToString(d.Gross);
             lblTax.Text       = Convert.ToString(d.TaxAmount);
             lblroundOff.Text  = Convert.ToString(d.RoundOff);
             lblNet.Text       = Convert.ToString(d.NetAmount);
             tAndC.Text        = Entities.Application.Settings.GetSetting(147);
             for (int i = 0; i < d.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 = d.Products[i].Name;
                 r.Cells.Add(t2);
                 TableCell t3 = new TableCell();
                 t3.Text = d.Products[i].ItemCode;
                 r.Cells.Add(t3);
                 TableCell t4 = new TableCell();
                 t4.Text = d.Products[i].Quantity.ToString();
                 r.Cells.Add(t4);
                 TableCell t5 = new TableCell();
                 t5.Text = d.Products[i].MRP.ToString();
                 r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = d.Products[i].CostPrice.ToString();
                 r.Cells.Add(t6);
                 TableCell t7 = new TableCell();
                 t7.Text = d.Products[i].Gross.ToString();
                 r.Cells.Add(t7);
                 TableCell t8 = new TableCell();
                 t8.Text = d.Products[i].TaxPercentage.ToString();
                 r.Cells.Add(t8);
                 TableCell t9 = new TableCell();
                 t9.Text = d.Products[i].TaxAmount.ToString();
                 r.Cells.Add(t9);
                 TableCell t10 = new TableCell();
                 t10.Text = d.Products[i].TaxAmount.ToString();
                 r.Cells.Add(t10);
                 listTable.Rows.Add(r);
             }
         }
     }
     catch (Exception ex)
     {
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
예제 #5
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.SalesEstimate sq = new Entities.Register.SalesEstimate();
             sq = Entities.Register.SalesEstimate.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.CustomerName;
             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.EstimateNumber;
             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;/*Entities.Application.Settings.GetSetting(149);*/
             lblPaymentTerms.Text  = sq.Payment_Terms;
             lblValidity.Text      = sq.Validity;
             lblProjectName.Text   = sq.JobName;
             lblCompletion.Text    = sq.ETA;
             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, "Estimate | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
예제 #6
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)
                {
                    string invoicetype = "";
                    try
                    {
                        invoicetype = Request.QueryString["invoicetype"].ToString();
                    }
                    catch (Exception)
                    {
                    }
                    Entities.Register.SalesDeliveryNote sr = new Entities.Register.SalesDeliveryNote();
                    sr = Entities.Register.SalesDeliveryNote.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.CustomerName;
                    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.DeliveryNoteNumber;
                    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    = "Delivery Note";
                    //lblTrn.Text = sr.CustomerTaxNo;
                    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].CostPrice.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>");
            }
        }
예제 #7
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)
                {
                    string invoicetype = "";
                    try
                    {
                        invoicetype = Request.QueryString["invoicetype"].ToString();
                    }
                    catch (Exception)
                    {
                    }
                    Entities.Register.SalesEntryRegister sr = new Entities.Register.SalesEntryRegister();
                    sr = Entities.Register.SalesEntryRegister.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     = sr.Customer;
                    lblComp.Text         = sr.Company;
                    lblCompAddr1.Text    = c.Address1;
                    lblCompAddr2.Text    = c.Address2;
                    lblCompPh.Text       = c.MobileNo1;
                    lblCompEmail.Text    = sr.CompanyEmail;
                    lblCustPhone.Text    = sr.CustomerPhone;
                    lblLocName.Text      = sr.Location;
                    lblLocAddr1.Text     = sr.LocationAddress1;
                    lblLocAddr2.Text     = sr.LocationAddress2;
                    lblCustomerName.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.SalesBillNo;
                    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 = NumberToWords(Convert.ToDouble(sr.NetAmount));
                    lblCompName.Text      = sr.Company;
                    //lblAddress.Text = sr.CustomerAddress;
                    lblCustName.Text  = sr.Customer;
                    lblCustPhone.Text = sr.CustomerPhone;
                    //lblTfn.Text = sr.CustomerTaxNo;
                    lblProjectName.Text = sr.JobName;
                    lblLPONumber.Text   = sr.LPO;
                    lblDeduction.Text   = Convert.ToString(sr.Discount);
                    lblCustCare.Text    = sr.Careof;
                    if (sr.PaymentStatus == 0)
                    {
                        if (invoicetype == "delivery")
                        {
                            lblMainHead.Text = "DELIVERY NOTE";
                        }
                        else
                        {
                            lblMainHead.Text = "TAX INVOICE";
                        }
                    }
                    else if (sr.PaymentStatus == 1)
                    {
                        if (invoicetype == "delivery")
                        {
                            lblMainHead.Text = "DELIVERY NOTE";
                        }
                        else
                        {
                            lblMainHead.Text = "PROFORMA INVOICE";
                        }
                    }
                    else if (sr.PaymentStatus == 2)
                    {
                        if (invoicetype == "delivery")
                        {
                            lblMainHead.Text = "DELIVERY NOTE";
                        }
                        else
                        {
                            lblMainHead.Text = "PROFORMA INVOICE";
                        }
                    }
                    //lblTrn.Text = sr.CustomerTaxNo;

                    //tAndC.Text = Entities.Application.Settings.GetSetting(148);
                    tAndC.Text           = sr.TermsandConditon;
                    lblPaymentTerms.Text = sr.Payment_Terms;
                    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();
                        r.Cells.Add(t4);
                        //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);
                    }
                }
            }
            catch (Exception ex)
            {
                Entities.Application.Helper.LogException(ex, "Quote | Page_Load(object sender, EventArgs e)");
                Response.Write("<script> alert('" + ex.Message + "') </script>");
            }
        }
예제 #8
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.SalesEntryRegister sr = new Entities.Register.SalesEntryRegister();
             sr = Entities.Register.SalesEntryRegister.GetDetails(id, locationid);
             dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(settings.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    = sr.Customer;
             lblCompRegId.Text   = c.RegId1;
             lblCity.Text        = c.City;
             lblCompState.Text   = c.State;
             lblCompCountry.Text = c.Country;
             lblCustState.Text   = sr.BillingAddress[0].State;
             lblCustCountry.Text = sr.BillingAddress[0].Country;
             lblLocRegId.Text    = sr.LocationRegId;
             lblCustTaxNo.Text   = sr.CustomerTaxNo;
             lblCustAddr1.Text   = sr.BillingAddress[0].Address1;
             lblComp.Text        = sr.Company;
             lblCompAddr1.Text   = c.Address1;
             lblCompAddr2.Text   = c.Address2;
             lblCompPh.Text      = c.MobileNo1;
             lblCustAddr2.Text   = sr.BillingAddress[0].Address2;
             lblCustPhone.Text   = sr.BillingAddress[0].Phone1;
             lblLocName.Text     = sr.Location;
             lblDiscount.Text    = Convert.ToString(sr.Discount);
             lblFreight.Text     = Convert.ToString(sr.FreightAmount);
             lblLocAddr1.Text    = sr.LocationAddress1;
             lblLocAddr2.Text    = sr.LocationAddress2;
             lblLocPhone.Text    = sr.LocationPhone;
             lblDate.Text        = sr.EntryDateString;
             lblInvoiceNo.Text   = sr.SalesBillNo;
             lblTotal.Text       = Convert.ToString(sr.Gross);
             lblTax.Text         = Convert.ToString(sr.TaxAmount);
             lblroundOff.Text    = Convert.ToString(sr.RoundOff);
             lblNet.Text         = Convert.ToString(sr.NetAmount);
             tAndC.Text          = Entities.Application.Settings.GetSetting(116);
             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);
                 if (settings.EnableDescription)//Enabled Description
                 {
                     TableCell t2 = new TableCell();
                     t2.Width = 500;
                     string itemName = "<b>";
                     itemName += sr.Products[i].Name;
                     itemName += "</b><br/>";
                     itemName += sr.Products[i].Description;
                     t2.Text   = itemName;
                     r.Cells.Add(t2);
                 }
                 else
                 {
                     TableCell t2 = new TableCell();
                     t2.Text = sr.Products[i].Name;
                     r.Cells.Add(t2);
                 }
                 TableCell t3 = new TableCell();
                 t3.Text = sr.Products[i].ItemCode;
                 r.Cells.Add(t3);
                 TableCell t4 = new TableCell();
                 t4.Text = sr.Products[i].MRP.ToString();
                 r.Cells.Add(t4);
                 TableCell t5 = new TableCell();
                 t5.Text = sr.Products[i].SellingPrice.ToString();
                 r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = sr.Products[i].Quantity.ToString();
                 r.Cells.Add(t6);
                 TableCell t7 = new TableCell();
                 t7.Text = sr.Products[i].Gross.ToString();
                 r.Cells.Add(t7);
                 TableCell t8 = new TableCell();
                 t8.Text = sr.Products[i].TaxPercentage.ToString();
                 r.Cells.Add(t8);
                 if (sr.BillingAddress[0].StateID == c.StateId)
                 {
                     TableCell t9 = new TableCell();
                     t9.Text = (Convert.ToDecimal(sr.Products[i].TaxAmount) / 2).ToString();
                     r.Cells.Add(t9);
                     TableCell t10 = new TableCell();
                     t10.Text = (Convert.ToDecimal(sr.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 = sr.Products[i].TaxAmount.ToString();
                     r.Cells.Add(t11);
                 }
                 TableCell t12 = new TableCell();
                 t12.Text = sr.Products[i].NetAmount.ToString();
                 r.Cells.Add(t12);
                 listTable.Rows.Add(r);
             }
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "Entry | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
예제 #9
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.GRNEntryRegister grn = new Entities.Register.GRNEntryRegister();
             grn = Entities.Register.GRNEntryRegister.GetDetails(id, locationid);
             dynamic settings = Entities.Application.Settings.GetFeaturedSettings();
             lblCurrency.Text = Convert.ToString(settings.CurrencySymbol);
             Entities.Master.Company c = new Entities.Master.Company();
             c = Entities.Master.Company.GetDetailsByLocation(locationid);
             imgLogo.ImageUrl    = "data:image/jpeg;base64, " + c.LogoBase64;
             lblSupName.Text     = grn.Supplier;
             lblCity.Text        = c.City;
             lblCompCountry.Text = c.Country;
             lblCompState.Text   = c.State;
             lblSupCountry.Text  = grn.BillingAddress[0].Country;
             lblSupState.Text    = grn.BillingAddress[0].State;
             lblCompRegId.Text   = c.RegId1;
             lblSupTaxNo.Text    = grn.SupplierTaxNo;
             lblLocRegId.Text    = grn.LocationRegId;
             lblSupAddr1.Text    = grn.BillingAddress[0].Address1;
             lblSupAddr2.Text    = grn.BillingAddress[0].Address2;
             lblSupPhone.Text    = grn.BillingAddress[0].Phone1;
             lblComp.Text        = c.Name;
             lblCompaddr2.Text   = c.Address2;
             lblCompAddr1.Text   = c.Address1;
             lblCompPh.Text      = c.Address1;
             lblLocName.Text     = grn.Location;
             lblLocAddr1.Text    = grn.LocationAddress1;
             lblLocAddr2.Text    = grn.LocationAddress2;
             lblLocPhone.Text    = grn.LocationPhone;
             lblDate.Text        = grn.EntryDateString;
             lblInvoiceNo.Text   = grn.InvoiceNo;
             lblTax.Text         = Convert.ToString(grn.TaxAmount);
             lblNet.Text         = Convert.ToString(grn.Net);
             tAndC.Text          = Entities.Application.Settings.GetSetting(143);
             for (int i = 0; i < grn.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 = grn.Products[i].ItemCode;
                 r.Cells.Add(t2);
                 TableCell t3 = new TableCell();
                 t3.Text = grn.Products[i].Name;
                 r.Cells.Add(t3);
                 TableCell t4 = new TableCell();
                 t4.Text = grn.Products[i].CostPrice.ToString();
                 r.Cells.Add(t4);
                 TableCell t5 = new TableCell();
                 t5.Text = grn.Products[i].Quantity.ToString();
                 r.Cells.Add(t5);
                 TableCell t6 = new TableCell();
                 t6.Text = grn.Products[i].ModifiedQuantity.ToString();
                 r.Cells.Add(t6);
                 TableCell t7 = new TableCell();
                 t7.Text = grn.Products[i].TaxPercentage.ToString();
                 r.Cells.Add(t7);
                 if (c.StateId == grn.BillingAddress[0].StateID)
                 {
                     TableCell t8 = new TableCell();
                     t8.Text = (Convert.ToDecimal(grn.Products[i].TaxAmount) / 2).ToString();
                     r.Cells.Add(t8);
                     TableCell t9 = new TableCell();
                     t9.Text = (Convert.ToDecimal(grn.Products[i].TaxAmount) / 2).ToString();
                     r.Cells.Add(t9);
                     TableCell t10 = new TableCell();
                     t10.Text = "0.00";
                     r.Cells.Add(t10);
                 }
                 else
                 {
                     TableCell t8 = new TableCell();
                     t8.Text = "0.00";
                     r.Cells.Add(t8);
                     TableCell t9 = new TableCell();
                     t9.Text = "0.00";
                     r.Cells.Add(t9);
                     TableCell t10 = new TableCell();
                     t10.Text = grn.Products[i].TaxAmount.ToString();
                     r.Cells.Add(t10);
                 }
                 TableCell t11 = new TableCell();
                 t11.Text = grn.Products[i].NetAmount.ToString();
                 r.Cells.Add(t11);
                 listTable.Rows.Add(r);
             }
         }
     }
     catch (Exception ex)
     {
         Entities.Application.Helper.LogException(ex, "GRN | Page_Load(object sender, EventArgs e)");
         Response.Write("<script> alert('" + ex.Message + "') </script>");
     }
 }
예제 #10
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.SalesReturnRegister sq = new Entities.Register.SalesReturnRegister();
                    sq = Entities.Register.SalesReturnRegister.GetDetails(id, locationId);
                    dynamic setting           = Entities.Application.Settings.GetFeaturedSettings();
                    Entities.Master.Company c = new Entities.Master.Company();
                    c = Entities.Master.Company.GetDetailsByLocation(locationId);
                    Entities.Application.User use = new Entities.Application.User();
                    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;

                    //lblCustName.Text = sq.CustomerName;
                    lblCompany.Text   = sq.Company;
                    lblCustemail.Text = sq.CustomerEmail;
                    lblCustState.Text = sq.CustomerState + "," + sq.CustomerCountry;
                    //lblCompanyContact.Text = c.MobileNo1;
                    //lblCompanyEmail.Text = sq.CompanyEmail;
                    lblDate.Text = sq.EntryDateString;
                    //lblReference.Text = sq.CreditNoteNumber;
                    //tAndC.Text = sq.TermsandConditon;
                    //lblCustCompany.Text = sq.CustomerName;
                    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            = "Total in " + setting.CurrencySymbol;
                    tfc5.ColumnSpan      = 4;
                    tfc5.HorizontalAlign = HorizontalAlign.Right;
                    tf.Cells.Add(tfc5);
                    TableCell tfc6 = new TableCell();
                    tfc6.Text            = Convert.ToString(sq.Gross);
                    tfc6.HorizontalAlign = HorizontalAlign.Right;
                    tf.Cells.Add(tfc6);
                    listTable.Rows.Add(tf);
                    TableFooterRow TaxAmountcell = new TableFooterRow();
                    TableCell      tfc1          = new TableCell();
                    tfc1.Text            = "VAT AMOUNT";
                    tfc1.ColumnSpan      = 4;
                    tfc1.HorizontalAlign = HorizontalAlign.Right;
                    TaxAmountcell.Cells.Add(tfc1);
                    TableCell tfc2 = new TableCell();
                    tfc2.Text            = Convert.ToString(sq.TaxAmount);
                    tfc2.HorizontalAlign = HorizontalAlign.Right;
                    TaxAmountcell.Cells.Add(tfc2);
                    listTable.Rows.Add(TaxAmountcell);
                    TableFooterRow TotalCell = new TableFooterRow();
                    TableCell      tfc3      = new TableCell();
                    tfc3.Text            = "Grand Total in " + setting.CurrencySymbol;
                    tfc3.ColumnSpan      = 4;
                    tfc3.HorizontalAlign = HorizontalAlign.Right;
                    TotalCell.Cells.Add(tfc3);
                    TableCell tfc4 = new TableCell();
                    tfc4.Text            = Convert.ToString(sq.NetAmount);
                    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>");
            }
        }
예제 #11
0
 public HttpResponseMessage UpdateOrganizationProfile(Entities.Master.Company comp)
 {
     return(Request.CreateResponse(HttpStatusCode.OK, comp.Update()));
 }