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; }
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 <OrderTax> taxedItems = TaxServices.GetOrderTaxes(order.OrderID); sheet.Table.ExpandedRowCount = 42 + order.OrderItems.Count * 2 + taxedItems.Count; sheet.Table.FullColumns = 1; sheet.Table.FullRows = 1; WorksheetColumn column0 = sheet.Table.Columns.Add(); column0.Width = 186; 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 RowEmail = sheet.Table.Rows.Add(); cell = RowEmail.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewCustomer_Email; cell = RowEmail.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = order.OrderCustomer.Email; cell.MergeAcross = 3; WorksheetRow RowPhone = sheet.Table.Rows.Add(); cell = RowPhone.Cells.Add(); cell.StyleID = "s135"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_CommonSettings_Phone; cell = RowPhone.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = order.OrderCustomer.MobilePhone; 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"; // ----------------------------------------------- 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; cell.Data.Text = item.ArtNo + ", " + item.Name; cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494196"; var html = new StringBuilder(); if (!string.IsNullOrEmpty(item.Color)) { html.Append(Configuration.SettingsCatalog.ColorsHeader + ": " + item.Color + " \n"); } if (!string.IsNullOrEmpty(item.Size)) { html.Append(Configuration.SettingsCatalog.SizesHeader + ": " + item.Size + " \n"); } foreach (EvaluatedCustomOptions ev in item.SelectedOptions) { html.Append(string.Format("- {0}: {1} \n", ev.CustomOptionTitle, ev.OptionTitle)); } cell.Data.Text = html.ToString(); cell.MergeDown = 1; cell = Row.Cells.Add(); cell.StyleID = "m51494216"; cell.Data.Type = DataType.String; 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.String; 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; var ordCurrency = order.OrderCurrency; float productPrice = order.OrderItems.Sum(item => item.Amount * item.Price); Row27.Cells.Add( CatalogService.GetStringPrice(productPrice, ordCurrency.CurrencyValue, ordCurrency.CurrencyCode), DataType.String, "s70"); //----------------------------------------------- if (order.Coupon != null) { 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_Coupon; cell.Index = 4; var productsWithCoupon = order.OrderItems.Where(item => item.IsCouponApplied).Sum(item => item.Price * item.Amount); switch (order.Coupon.Type) { case CouponType.Fixed: Row28.Cells.Add(String.Format("-{0} ({1})", CatalogService.GetStringPrice(order.Coupon.Value, ordCurrency.CurrencyValue, ordCurrency.CurrencyCode), order.Coupon.Code), DataType.String, "s70"); break; case CouponType.Percent: Row28.Cells.Add(String.Format("-{0} ({1}%) ({2})", CatalogService.GetStringPrice(productsWithCoupon * order.Coupon.Value / 100, ordCurrency.CurrencyValue, ordCurrency.CurrencyCode), CatalogService.FormatPriceInvariant(order.Coupon.Value), order.Coupon.Code), DataType.String, "s70"); break; } } // ----------------------------------------------- float totalDiscount = order.OrderDiscount; if (totalDiscount > 0) { 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; Row28.Cells.Add( "-" + CatalogService.GetStringDiscountPercent(productPrice, totalDiscount, ordCurrency.CurrencyValue, ordCurrency.CurrencySymbol, ordCurrency.IsCodeBefore, CurrencyService.CurrentCurrency.PriceFormat, false), DataType.String, "s70"); } // ------------------------------------------------------- if (order.Certificate != null) { 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; Row28.Cells.Add( "-" + string.Format("-{0}", CatalogService.GetStringPrice(order.Certificate.Price, ordCurrency.CurrencyValue, ordCurrency.CurrencyCode)), DataType.String, "s70"); } // ----------------------------------------------- float bonusPrice = order.BonusCost; if (bonusPrice > 0) { WorksheetRow Row28_5 = sheet.Table.Rows.Add(); cell = Row28_5.Cells.Add(); cell.StyleID = "s70"; cell = Row28_5.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_Bonuses; cell.Index = 4; Row28_5.Cells.Add("-" + CatalogService.GetStringPrice(bonusPrice), 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 (OrderTax 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"); } // ----------------------------------------------- if (order.PaymentCost > 0) { WorksheetRow Row291 = sheet.Table.Rows.Add(); cell = Row291.Cells.Add(); cell.StyleID = "s70"; cell = Row291.Cells.Add(); cell.StyleID = "s70"; cell.Data.Type = DataType.String; cell.Data.Text = Resource.Admin_ViewOrder_PaymentExtracharge; cell.Index = 4; Row291.Cells.Add( "+" + CatalogService.GetStringPrice(order.PaymentCost, 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; }