protected void lbDeleteSelected_Click(object sender, EventArgs e) { if ((_selectionFilter != null) && (_selectionFilter.Values != null)) { var currency = CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3); if (!_inverseSelection) { foreach (var id in _selectionFilter.Values) { if (currency != null && currency.CurrencyID != SQLDataHelper.GetInt(id)) { CurrencyService.DeleteCurrency(SQLDataHelper.GetInt(id)); } } } else { var itemsIds = _paging.ItemsIds <int>("CurrencyID as ID"); foreach (int id in itemsIds.Where(id => !_selectionFilter.Values.Contains(id.ToString(CultureInfo.InvariantCulture)))) { if (currency != null && currency.CurrencyID != id) { CurrencyService.DeleteCurrency(id); } } } CurrencyService.RefreshCurrency(); } }
public static string GetStringPrice(decimal price, int qty, string currencyCode, decimal currencyRate) { Currency cur = CurrencyService.Currency(currencyCode); if (cur == null) { return(GetStringPrice(price, currencyRate, currencyCode, 0, qty, false, CurrencyService.DefaultPriceFormat, null, false)); } return(GetStringPrice(price, currencyRate, cur.Symbol, 0, qty, cur.IsCodeBefore, cur.PriceFormat, null, false)); }
private void UpdateCurrency() { var cur = CurrencyService.Currency(ddlCurrs.SelectedValue); CurrencyValue = cur.Value; CurrencyCode = cur.Iso3; CurrencySymbol = cur.Symbol; CurrencyNumCode = cur.NumIso3; IsCodeBefore = cur.IsCodeBefore; Currency = cur; OldCurrencyValue = !string.IsNullOrEmpty(hfOldCurrencyValue.Value) ? Convert.ToDecimal(hfOldCurrencyValue.Value) : CurrencyValue; hfOldCurrencyValue.Value = cur.Value.ToString(); }
public void SetCurrency(string currencyCode, float currencyValue, int currencyNumCode, string currencySymbol, bool isCodeBefore) { ddlCurrs.DataBind(); ddlCurrs.SelectedValue = currencyCode; lcurrency.Text = ddlCurrs.SelectedItem.Text; hfOldCurrencyValue.Value = currencyValue.ToString(); OldCurrencyValue = currencyValue; CurrencyCode = currencyCode; CurrencyNumCode = currencyNumCode; CurrencySymbol = currencySymbol; Currency = CurrencyService.Currency(currencyCode); CurrencyValue = currencyValue; IsCodeBefore = isCodeBefore; }
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteCurrency") { var currency = CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3); if (currency.CurrencyID != SQLDataHelper.GetInt(e.CommandArgument)) { CurrencyService.DeleteCurrency(SQLDataHelper.GetInt(e.CommandArgument)); CurrencyService.RefreshCurrency(); } } if (e.CommandName == "AddCurrency") { GridViewRow footer = grid.FooterRow; float temp; float.TryParse(((TextBox)footer.FindControl("txtNewCurrencyValue")).Text, out temp); if ( temp == 0 || string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewName")).Text) || string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewCode")).Text) || string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewCurrencyISO3")).Text) || string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewPriceFormat")).Text) ) { grid.FooterStyle.BackColor = System.Drawing.Color.FromName("#ffcccc"); return; } var cur = new Currency { Name = ((TextBox)footer.FindControl("txtNewName")).Text, Symbol = ((TextBox)footer.FindControl("txtNewCode")).Text, Value = temp, Iso3 = ((TextBox)footer.FindControl("txtNewCurrencyISO3")).Text, IsCodeBefore = ((CheckBox)footer.FindControl("checkNewIsCodeBefore")).Checked, PriceFormat = ((TextBox)footer.FindControl("txtNewPriceFormat")).Text }; CurrencyService.InsertCurrency(cur); CurrencyService.RefreshCurrency(); grid.ShowFooter = false; } if (e.CommandName == "CancelAdd") { grid.FooterStyle.BackColor = System.Drawing.Color.FromName("#ccffcc"); grid.ShowFooter = false; } }
private void UpdateCurrency() { var cur = CurrencyService.Currency(ddlCurrs.SelectedValue); if (cur == null) { return; } CurrencyValue = cur.Value; CurrencyCode = cur.Iso3; CurrencySymbol = cur.Symbol; CurrencyNumCode = cur.NumIso3; IsCodeBefore = cur.IsCodeBefore; Currency = cur; OldCurrencyValue = !string.IsNullOrEmpty(hfOldCurrencyValue.Value) ? SQLDataHelper.GetFloat(hfOldCurrencyValue.Value) : CurrencyValue; hfOldCurrencyValue.Value = cur.Value.ToString(); }
public static void InitBaseSessionSettings() { HttpContext.Current.Session.Add("IsAdmin", false); //Desing if (CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3) == null) { CurrencyService.RefreshCurrency(); } CurrencyService.CurrentCurrency = CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3) ?? CurrencyService.GetAllCurrencies().First(); // Internal Settings HttpContext.Current.Session.Add("isDebug", false); HttpContext.Current.Session.Add("isAuthorize", false); HttpContext.Current.Session.Add("errOnAsax", false); HttpContext.Current.Session.Add("errMessage", ""); }
public static void InitBaseSessionSettings() { //Setting null values for the global variables (decalring) HttpContext.Current.Session.Add("IsAdmin", false); //Desing if (CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3) == null) { CurrencyService.RefreshCurrency(); } CurrencyService.CurrentCurrency = CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3); // Internal Settings HttpContext.Current.Session.Add("isDebug", false); HttpContext.Current.Session.Add("isAuthorize", false); HttpContext.Current.Session.Add("errOnAsax", false); HttpContext.Current.Session.Add("errMessage", ""); }
public bool SaveData() { if (!ValidateData()) { return(false); } var iso3 = SettingsCatalog.DefaultCurrencyIso3; SettingsCatalog.DefaultCurrencyIso3 = ddlDefaultCurrency.SelectedValue; if (SettingsCatalog.DefaultCurrencyIso3 != iso3) { CurrencyService.CurrentCurrency = CurrencyService.Currency(SettingsCatalog.DefaultCurrencyIso3); } SettingsCatalog.AllowToChangeCurrency = cbAllowToChangeCurrency.Checked; SettingsCatalog.ProductsPerPage = SQLDataHelper.GetInt(txtProdPerPage.Text); SettingsCatalog.EnableProductRating = cbEnableProductRating.Checked; SettingsCatalog.EnablePhotoPreviews = cbEnablePhotoPreviews.Checked; SettingsCatalog.EnableCompareProducts = cbEnableCompareProducts.Checked; SettingsCatalog.EnabledCatalogViewChange = cbEnableCatalogViewChange.Checked; SettingsCatalog.EnabledSearchViewChange = cbEnableSearchViewChange.Checked; SettingsCatalog.DefaultCatalogView = (SettingsCatalog.ProductViewMode)SQLDataHelper.GetInt(ddlCatalogView.SelectedValue); SettingsCatalog.DefaultSearchView = (SettingsCatalog.ProductViewMode)SQLDataHelper.GetInt(ddlSearchView.SelectedValue); SettingsCatalog.DisplayCategoriesInBottomMenu = ckbShowCategoriesInBottomMenu.Checked; SettingsCatalog.ExluderingFilters = cbExluderingFilters.Checked; SettingsCatalog.ShowPriceFilter = chkShowPriceFilter.Checked; SettingsCatalog.ShowProducerFilter = chkShowProducerFilter.Checked; SettingsCatalog.ShowSizeFilter = chkShowSizeFilter.Checked; SettingsCatalog.ShowColorFilter = chkShowColorFilter.Checked; SettingsCatalog.ComplexFilter = cbComplexFilter.Checked; SettingsCatalog.SizesHeader = txtSizesHeader.Text; SettingsCatalog.ColorsHeader = txtColorsHeader.Text; SettingsPictureSize.ColorIconWidthCatalog = txtColorPictureWidthCatalog.Text.TryParseInt(); SettingsPictureSize.ColorIconHeightCatalog = txtColorPictureHeightCatalog.Text.TryParseInt(); SettingsPictureSize.ColorIconWidthDetails = txtColorPictureWidthDetails.Text.TryParseInt(); SettingsPictureSize.ColorIconHeightDetails = txtColorPictureHeightDetails.Text.TryParseInt(); SettingsCatalog.RelatedProductName = txtBlockOne.Text; SettingsCatalog.AlternativeProductName = txtBlockTwo.Text; SettingsCatalog.BuyButtonText = txtBuyButtonText.Text; SettingsCatalog.MoreButtonText = txtMoreButtonText.Text; SettingsCatalog.PreOrderButtonText = txtPreOrderButtonText.Text; SettingsCatalog.DisplayBuyButton = cbDisplayBuyButton.Checked; SettingsCatalog.DisplayMoreButton = cbDisplayMoreButton.Checked; SettingsCatalog.DisplayPreOrderButton = cbDisplayPreOrderButton.Checked; SettingsCatalog.AvaliableFilterEnabled = cbAvaliableFilterEnabled.Checked; SettingsCatalog.AvaliableFilterSelected = cbAvaliableFilterSelected.Checked; SettingsCatalog.PreorderFilterEnabled = cbPreorderFilterEnabled.Checked; SettingsCatalog.PreorderFilterSelected = cbPreorderFilterSelected.Checked; SettingsCatalog.ShowProductsCount = cbShowProductsCount.Checked; LoadData(); return(true); }
private void GenerateWorksheetSheet1(WorksheetCollection sheets, Order order) { Culture.InitializeCulture(); Worksheet sheet = sheets.Add(Resource.Admin_ViewOrder_ItemNum + order.OrderID); sheet.Table.DefaultRowHeight = 15F; sheet.Table.ExpandedColumnCount = 5; List <TaxValue> taxedItems = TaxServices.GetOrderTaxes(order.OrderID); sheet.Table.ExpandedRowCount = 40 + order.OrderItems.Count * 2 + taxedItems.Count; sheet.Table.FullColumns = 1; sheet.Table.FullRows = 1; WorksheetColumn column0 = sheet.Table.Columns.Add(); //column0.Width = 186; Commented By Evgeni to enlarge column width column0.Width = 250; column0.Span = 1; WorksheetColumn column1 = sheet.Table.Columns.Add(); column1.Index = 3; column1.Width = 156; sheet.Table.Columns.Add(120); sheet.Table.Columns.Add(89); // Order ID----------------------------------------------- WorksheetRow Row0 = sheet.Table.Rows.Add(); Row0.Height = 22; WorksheetCell cell; cell = Row0.Cells.Add(); cell.StyleID = "s132"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_ItemNum + order.OrderID; cell.MergeAcross = 4; // Status ----------------------------------------------- WorksheetRow Row1 = sheet.Table.Rows.Add(); cell = Row1.Cells.Add(); cell.StyleID = "s133"; cell.Data.Type = DataType.String; cell.Data.Text = "(" + order.OrderStatus.StatusName + ")"; cell.MergeAcross = 4; // ----------------------------------------------- WorksheetRow Row2 = sheet.Table.Rows.Add(); cell = Row2.Cells.Add(); cell.StyleID = "s134"; cell.MergeAcross = 4; // Date ----------------------------------------------- WorksheetRow Row3 = sheet.Table.Rows.Add(); cell = Row3.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_Date; cell = Row3.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Culture.ConvertDate(order.OrderDate); cell.MergeAcross = 3; // NUmber to status check ----------------------------------------------- WorksheetRow Row4 = sheet.Table.Rows.Add(); cell = Row4.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_Number; cell = Row4.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = order.Number; cell.MergeAcross = 3; // Status comment ----------------------------------------------- WorksheetRow Row5 = sheet.Table.Rows.Add(); cell = Row5.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_StatusComment; cell = Row5.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = order.StatusComment; cell.MergeAcross = 3; // ----------------------------------------------- WorksheetRow Row6 = sheet.Table.Rows.Add(); cell = Row6.Cells.Add(); cell.StyleID = "s136"; cell.MergeAcross = 4; // Headers ----------------------------------------------- WorksheetRow Row7 = sheet.Table.Rows.Add(); Row7.Cells.Add(Resource.Admin_ViewOrder_Billing, DataType.String, "s70"); Row7.Cells.Add(Resource.Admin_ViewOrder_Shipping, DataType.String, "s70"); Row7.Cells.Add(Resource.Admin_ViewOrder_ShippingMethod, DataType.String, "s70"); // Names ----------------------------------------------- WorksheetRow Row8 = sheet.Table.Rows.Add(); Row8.Cells.Add(" " + Resource.Admin_ViewOrder_Name + order.BillingContact.Name, DataType.String, "s70"); Row8.Cells.Add(" " + Resource.Admin_ViewOrder_Name + order.ShippingContact.Name, DataType.String, "s70"); var shippingMethodName = order.ArchivedShippingName; if (order.OrderPickPoint != null) { shippingMethodName += order.OrderPickPoint.PickPointAddress.Replace("<br/>", " "); } Row8.Cells.Add(" " + shippingMethodName, DataType.String, "s70"); // Countries ----------------------------------------------- WorksheetRow Row9 = sheet.Table.Rows.Add(); Row9.Cells.Add(" " + Resource.Admin_ViewOrder_Country + order.BillingContact.Country, DataType.String, "s70"); Row9.Cells.Add(" " + Resource.Admin_ViewOrder_Country + order.ShippingContact.Country, DataType.String, "s70"); Row9.Cells.Add(Resource.Admin_ViewOrder_PaymentType, DataType.String, "s70"); // Cities ----------------------------------------------- WorksheetRow Row10 = sheet.Table.Rows.Add(); Row10.Cells.Add(" " + Resource.Admin_ViewOrder_City + order.BillingContact.City, DataType.String, "s70"); Row10.Cells.Add(" " + Resource.Admin_ViewOrder_City + order.ShippingContact.City, DataType.String, "s70"); Row10.Cells.Add(" " + order.PaymentMethodName, DataType.String, "s70"); // Zones ----------------------------------------------- WorksheetRow Row11 = sheet.Table.Rows.Add(); Row11.Cells.Add(" " + Resource.Admin_ViewOrder_Zone + order.BillingContact.Zone, DataType.String, "s70"); Row11.Cells.Add(" " + Resource.Admin_ViewOrder_Zone + order.ShippingContact.Zone, DataType.String, "s70"); cell = Row11.Cells.Add(); cell.StyleID = "s70"; // Zips ----------------------------------------------- WorksheetRow Row12 = sheet.Table.Rows.Add(); Row12.Cells.Add(" " + Resource.Admin_ViewOrder_Zip + order.BillingContact.Zip, DataType.String, "s70"); Row12.Cells.Add(" " + Resource.Admin_ViewOrder_Zip + order.ShippingContact.Zip, DataType.String, "s70"); cell = Row12.Cells.Add(); cell.StyleID = "s70"; // Adresses ----------------------------------------------- WorksheetRow Row13 = sheet.Table.Rows.Add(); Row13.Cells.Add(" " + Resource.Admin_ViewOrder_Address + order.BillingContact.Address, DataType.String, "s70"); Row13.Cells.Add(" " + Resource.Admin_ViewOrder_Address + order.ShippingContact.Address, DataType.String, "s70"); cell = Row13.Cells.Add(); cell.StyleID = "s70"; // Added by Evgeni //Tel WorksheetRow Row14 = sheet.Table.Rows.Add(); Row14.Cells.Add(" " + Resource.Client_OrderConfirmation_MobilePhone + " :" + order.OrderCustomer.MobilePhone, DataType.String, "s70"); Row14.Cells.Add(" " + Resource.Client_OrderConfirmation_MobilePhone + " :" + order.OrderCustomer.MobilePhone, DataType.String, "s70"); cell = Row14.Cells.Add(); cell.StyleID = "s70"; // // ----------------------------------------------- WorksheetRow Row17 = sheet.Table.Rows.Add(); cell = Row17.Cells.Add(); cell.StyleID = "s134"; cell.MergeAcross = 4; // Orders ----------------------------------------------- WorksheetRow Row18 = sheet.Table.Rows.Add(); cell = Row18.Cells.Add(); cell.StyleID = "s136"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_OrderItem; cell.MergeAcross = 4; // ----------------------------------------------- WorksheetRow Row19 = sheet.Table.Rows.Add(); Row19.Height = 15; cell = Row19.Cells.Add(); cell.StyleID = "s137"; cell.MergeAcross = 4; // Order items table header ----------------------------------------------- WorksheetRow Row20 = sheet.Table.Rows.Add(); Row20.Height = 16; Row20.Cells.Add(Resource.Admin_ViewOrder_ItemName, DataType.String, "s89"); Row20.Cells.Add(Resource.Admin_ViewOrder_CustomOptions, DataType.String, "s90"); Row20.Cells.Add(Resource.Admin_ViewOrder_Price, DataType.String, "s90"); Row20.Cells.Add(Resource.Admin_ViewOrder_ItemAmount, DataType.String, "s90"); Row20.Cells.Add(Resource.Admin_ViewOrder_ItemCost, DataType.String, "s91"); // Order items ----------------------------------------------- foreach (OrderItem item in order.OrderItems) { WorksheetRow Row = sheet.Table.Rows.Add(); cell = Row.Cells.Add(); cell.StyleID = "m51494176"; cell.Data.Type = DataType.String; //Changed by Evgeni to isert ArtNo in order print cell.Data.Text = item.Name + " [" + item.ArtNo + "]"; // cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494196"; var html = new StringBuilder(); foreach (EvaluatedCustomOptions ev in item.SelectedOptions) { html.Append(string.Format("- {0}: {1} \n", ev.CustomOptionTitle, ev.OptionTitle)); } //Changed by Evgeni to isert ArtNo in order print cell.Data.Text = " " + item.ArtNo + " " + html.ToString(); // cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494216"; cell.Data.Type = DataType.String; bool ciscodebefore; string cpriceformat = null; string csign = null; Currency cur = CurrencyService.Currency(order.OrderCurrency.CurrencyCode); ciscodebefore = cur.IsCodeBefore; cpriceformat = cur.PriceFormat; csign = cur.Symbol; cell.Data.Text = CatalogService.GetStringPrice(item.Price, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode); cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494236"; cell.Data.Type = DataType.Number; cell.Data.Text = item.Amount.ToString(); cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494256"; cell.Data.Type = DataType.String; cell.Data.Text = CatalogService.GetStringPrice(item.Price * item.Amount, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode); cell.MergeDown = 1; // ----------------------------------------------- WorksheetRow RowSep = sheet.Table.Rows.Add(); RowSep.Height = 15; } // ----------------------------------------------- WorksheetRow Row27 = sheet.Table.Rows.Add(); Row27.Height = 15; cell = Row27.Cells.Add(); cell.StyleID = "s70"; cell = Row27.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_ItemCost2; cell.Index = 4; decimal orderPrice = ((order.Sum - order.ShippingCost) * 100) / (100 - order.OrderDiscount); Row27.Cells.Add( CatalogService.GetStringPrice(order.Sum, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s70"); // ----------------------------------------------- WorksheetRow Row28 = sheet.Table.Rows.Add(); cell = Row28.Cells.Add(); cell.StyleID = "s70"; cell = Row28.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_ItemDiscount; cell.Index = 4; decimal discount = orderPrice * (order.OrderDiscount / 100); Row28.Cells.Add( "-" + CatalogService.GetStringPrice(discount, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s70"); // ----------------------------------------------- WorksheetRow Row29 = sheet.Table.Rows.Add(); cell = Row29.Cells.Add(); cell.StyleID = "s70"; cell = Row29.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_ShippingPrice; cell.Index = 4; Row29.Cells.Add( "+" + CatalogService.GetStringPrice(order.ShippingCost, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s70"); // ----------------------------------------------- if (taxedItems.Count > 0) { foreach (TaxValue tax in taxedItems) { WorksheetRow Row = sheet.Table.Rows.Add(); cell = Row.Cells.Add(); cell.StyleID = "s70"; cell = Row.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = (tax.TaxShowInPrice ? Resource.Core_TaxServices_Include_Tax + " " : "") + tax.TaxName + ":"; cell.Index = 4; Row.Cells.Add( (tax.TaxShowInPrice ? "" : "+") + CatalogService.GetStringPrice(tax.TaxSum, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s70"); } } else { WorksheetRow Row30a = sheet.Table.Rows.Add(); cell = Row30a.Cells.Add(); cell.StyleID = "s70"; cell = Row30a.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_Taxes; cell.Index = 4; Row30a.Cells.Add( "+" + CatalogService.GetStringPrice(0, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s70"); } // ----------------------------------------------- WorksheetRow Row30 = sheet.Table.Rows.Add(); cell = Row30.Cells.Add(); cell.StyleID = "s70"; cell = Row30.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_TotalPrice; cell.Index = 4; cell = Row30.Cells.Add( CatalogService.GetStringPrice(order.Sum, order.OrderCurrency.CurrencyValue, order.OrderCurrency.CurrencyCode), DataType.String, "s135"); // ----------------------------------------------- WorksheetRow Row31 = sheet.Table.Rows.Add(); cell = Row31.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Client_PrintOrder_YourComment; cell.MergeAcross = 4; // ----------------------------------------------- WorksheetRow Row32 = sheet.Table.Rows.Add(); cell = Row32.Cells.Add(); cell.StyleID = "s141"; cell.Data.Type = DataType.String; cell.Data.Text = order.CustomerComment; cell.MergeAcross = 4; cell.MergeDown = 1; // ----------------------------------------------- // Options // ----------------------------------------------- sheet.Options.Selected = true; sheet.Options.ProtectObjects = false; sheet.Options.ProtectScenarios = false; sheet.Options.PageSetup.Header.Margin = 0.3F; sheet.Options.PageSetup.Footer.Margin = 0.3F; sheet.Options.PageSetup.PageMargins.Bottom = 0.75F; sheet.Options.PageSetup.PageMargins.Left = 0.7F; sheet.Options.PageSetup.PageMargins.Right = 0.7F; sheet.Options.PageSetup.PageMargins.Top = 0.75F; sheet.Options.Print.PaperSizeIndex = 9; sheet.Options.Print.VerticalResolution = 0; sheet.Options.Print.ValidPrinterInfo = true; }
protected void Page_Load(object sender, EventArgs e) { if (EmptyCheck || Order == null) { return; } _currency = (Order.OrderCurrency ?? CurrencyService.Currency("USD")) ?? new Currency { IsCodeBefore = true, Iso3 = "USD", Name = "USD", PriceFormat = CurrencyService.DefaultPriceFormat, Symbol = "$", Value = 1 }; //var check = new Check_PaymentModule(); lCompanyName.Text = _Check.CompanyName; lAddress.Text = _Check.Adress; lCountry.Text = _Check.Country; lState.Text = _Check.State; lCity.Text = _Check.City; lCompanyPhone.Text = _Check.Phone; lInterPhone.Text = _Check.IntPhone; lCompanyFax.Text = _Check.Fax; lOrderDate.Text = AdvantShop.Localization.Culture.ConvertDate(Order.OrderDate); // AdvantShop.Localization.Culture.ConvertDate((DateTime)reader["OrderDate"]); lOrderId.Text = @"#" + Order.OrderID; lShippingMethod.Text = Order.ShippingMethodName; // reader["ShippingMethod"].ToString(); lName.Text = Order.BillingContact.Name; lPhone.Text = Order.OrderCustomer.MobilePhone; //lFax.Text = Order.BillingContact.Fax; //lEmail.Text = Order.BillingContact.Email; lEmail.Text = Order.OrderCustomer.Email; lBillingAddress.Text = Order.BillingContact.Address; lBillingCity.Text = Order.BillingContact.City; lBillingState.Text = Order.BillingContact.Zone; lBillingCountry.Text = Order.BillingContact.Country; lBillingZip.Text = Order.BillingContact.Zip; lShippingAddress.Text = Order.ShippingContact.Address; lShippingCity.Text = Order.ShippingContact.City; lShippingState.Text = Order.ShippingContact.Zone; lShippingCountry.Text = Order.ShippingContact.Country; lShippingZip.Text = Order.ShippingContact.Zip; lSubTotal.Text = EvalPrice((Order.Sum - Order.ShippingCost) * 100.0F / (100 - Order.OrderDiscount)); lShippingCost.Text = EvalPrice(Order.ShippingCost); lDiscount.Text = EvalPrice(Order.OrderDiscount * (Order.Sum - Order.ShippingCost / (100 - Order.OrderDiscount))); var shippingContact = new AdvantShop.Customers.CustomerContact { CountryId = CountryService.GetCountryIdByName(lShippingCountry.Text), RegionId = RegionService.GetRegionIdByName(lShippingState.Text) }; var billingContact = new AdvantShop.Customers.CustomerContact { CountryId = CountryService.GetCountryIdByName(lBillingCountry.Text), RegionId = RegionService.GetRegionIdByName(lBillingState.Text) }; rptOrderItems.DataBind(); IList <OrderItem> dtOrder = Order.OrderItems; var taxedItems = new List <OrderTax>(); //foreach (OrderItem item in dtOrder) //{ // if (item.ProductID != null) // { // ICollection<TaxElement> t = TaxServices.GetTaxesForProduct((int) item.ProductID, billingContact, // shippingContact); // foreach (TaxElement tax in t) // { // TaxValue taxedItem = taxedItems.Find(tv => tv.TaxID == tax.TaxId); // if (taxedItem != null) // { // taxedItem.TaxSum += TaxServices.CalculateTax(item, tax, Order.OrderDiscount); // } // else // { // taxedItems.Add(new TaxValue // { // TaxID = tax.TaxId, // TaxName = tax.Name, // TaxShowInPrice = tax.ShowInPrice, // TaxSum = TaxServices.CalculateTax(item, tax, Order.OrderDiscount) // }); // } // } // } //} literalTaxCost.Text = BuildTaxTable(taxedItems, _currency.Value, _currency.Iso3, Resource.Admin_ViewOrder_Taxes); lTotal.Text = EvalPrice(Order.Sum); }