public override string ProcessJavascript(Order order)
{
int orderItemsCount = 0;
string orderItems = "";
var subtotal = order.OrderItems.Sum(item => item.Amount * item.Price);
// сумма налогов не включенных в стоимость товара
var taxTotal = TaxServices.GetOrderTaxes(order.OrderID).Where(t => !t.TaxShowInPrice).Sum(t => t.TaxSum);
var totalDiscount = (float)Math.Round(subtotal / 100 * order.OrderDiscount, 2);
taxTotal += order.PaymentCost;
foreach (var item in order.OrderItems)
{
var percent = item.Price * item.Amount * 100 / subtotal;
item.Price += percent * taxTotal / (100 * item.Amount);
item.Price -= percent * totalDiscount / (100 * item.Amount);
orderItemsCount++;
orderItems += string.Format("&TC_{0}={1}&TPr_{0}={2}&TName_{0}={3}",
orderItemsCount, item.Amount, item.Price.ToString("F"), HttpUtility.UrlEncode(item.Name));
}
var shippingCost = order.ShippingCost / order.OrderCurrency.CurrencyValue;
if (shippingCost > 0)
{
orderItemsCount++;
orderItems += string.Format("&TC_{0}={1}&TPr_{0}={2}&TName_{0}={3}",
orderItemsCount, 1, ((float)Math.Round(shippingCost)).ToString("F"), HttpUtility.UrlEncode("Доставка"));
}
var link = String.Format("https://anketa.bank.rs.ru/minipotreb.php?idTpl={0}&TTName={1}&Order={2}&TCount={3}{4}&UserName={5}&UserLastName={6}&UserMail={7}",
PartnerId,
SettingsMain.SiteUrl.Replace("http://", ""),
order.OrderID,
orderItemsCount,
orderItems,
order.OrderCustomer.FirstName,
order.OrderCustomer.LastName,
order.OrderCustomer.Email != "admin" ? order.OrderCustomer.Email : "");
var sb = new StringBuilder();
sb.Append("<script type=\"text/javascript\"> ");
sb.AppendLine("function openrsbcredit() {{");
sb.AppendFormat("window.open(\"{0}\", \"_blank\");\r\n", link);
sb.AppendLine("}} ");
sb.AppendLine("</script>");
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (EmptyCheck || Order == null)
{
return;
}
liCompanyName.Text = Bill.CompanyName;
liCompanyName2.Text = Bill.CompanyName;
liCompanyCode.Text = Bill.CompanyCode;
liCredit.Text = Bill.Credit;
liBankCode.Text = Bill.BankCode;
liBankName.Text = Bill.BankName;
liCompanyEssencials.Text = Bill.CompanyEssentials;
liOrderNum.Text = string.Format("Рахунок на оплату № {0} від {1} {2} {3} р.",
Order.OrderID, Order.OrderDate.Day.ToString("0#"),
Months[Order.OrderDate.Month - 1], Order.OrderDate.Year);
liBuyerInfo.Text = Order.BillingContact.Name;
rprOrrderItems.DataSource = Order.OrderItems;
rprOrrderItems.DataBind();
trDiscount.Visible = Order.TotalDiscount != 0;
liDiscount.Text = GetPrice(Order.TotalDiscount, Order.OrderCurrency);
liTotal.Text = GetPrice(Order.Sum, Order.OrderCurrency);
hfTotal.Value = GetPriceFormat(Order.Sum, Order.OrderCurrency);
liTotalCount.Text = string.Format("Всього найменувань {0}, на суму {1} грн.",
Order.OrderItems.Count,
GetPrice(Order.Sum, Order.OrderCurrency));
var taxes = TaxServices.GetOrderTaxes(Order.OrderID).Where(p => p.TaxSum > 0).ToList();
if (taxes.Count > 0)
{
var taxSum = (float)Math.Round(taxes.Sum(t => t.TaxSum), 2);
liTaxSum.Text = GetPrice(taxSum, Order.OrderCurrency);
hfTax.Value = GetPriceFormat(taxSum, Order.OrderCurrency);
trTax.Visible = true;
trTaxSum.Visible = true;
}
else
{
trTax.Visible = false;
trTaxSum.Visible = false;
}
}
private string GetOrderJson(Order order)
{
var orderItems = order.OrderItems;
float subtotal = order.OrderItems.Sum(item => item.Amount * item.Price);
// сумма налогов не включенных в стоимость товара
var taxTotal = TaxServices.GetOrderTaxes(order.OrderID).Where(t => !t.TaxShowInPrice).Sum(t => t.TaxSum);
float totalDiscount = (float)Math.Round(subtotal / 100 * order.OrderDiscount, 2);
foreach (var item in orderItems)
{
var percent = item.Price * item.Amount * 100 / subtotal;
item.Price += percent * taxTotal / (100 * item.Amount);
item.Price -= percent * totalDiscount / (100 * item.Amount);
}
var shopCartItems = orderItems.Select(item => new
{
model = item.Name,
count = item.Amount,
price = (float)Math.Round(item.Price * item.Amount)
}).ToList();
var shippingCost = order.ShippingCost / order.OrderCurrency.CurrencyValue;
if (shippingCost > 0)
{
shopCartItems.Add(new
{
model = "Доставка",
count = 1F,
price = (float)Math.Round(shippingCost)
});
}
return(JsonConvert.SerializeObject(shopCartItems));
}
/// <summary>
/// Генерирует json с заказами
/// </summary>
private string GetOrderJson(Order order, string partnerId)
{
var orderItems = order.OrderItems;
float subtotal = order.OrderItems.Sum(item => item.Amount * item.Price);
// сумма налогов не включенных в стоимость товара
var taxTotal = TaxServices.GetOrderTaxes(order.OrderID).Where(t => !t.TaxShowInPrice).Sum(t => t.TaxSum);
var totalDiscount = (float)Math.Round(subtotal / 100 * order.OrderDiscount, 2);
foreach (var item in orderItems)
{
var percent = item.Price * item.Amount * 100 / subtotal;
item.Price += percent * taxTotal / (100 * item.Amount);
item.Price -= percent * totalDiscount / (100 * item.Amount);
}
var shopCartItems = orderItems.Select(item => item.ProductID != null ? new
{
id = item.ArtNo,
name = item.Name,
price = (float)Math.Round(item.Price),
type = ProductService.GetCategoriesByProductId((int)item.ProductID).FirstOrDefault().Name,
count = item.Amount.ToString("#")
} : null).ToList();
var array = new
{
items = shopCartItems
};
return(JsonConvert.SerializeObject(array));
}
/// <summary>
/// Генерирует json с заказами
/// </summary>
private string GetOrderJson(Order order, string partnerId)
{
var orderItems = order.OrderItems;
decimal subtotal = order.OrderItems.Sum(item => item.Amount * item.Price);
// сумма налогов не включенных в стоимость товара
var taxTotal = TaxServices.GetOrderTaxes(order.OrderID).Where(t => !t.TaxShowInPrice).Sum(t => t.TaxSum);
var totalDiscount = Math.Round(subtotal / 100 * order.OrderDiscount, 2);
foreach (var item in orderItems)
{
var percent = item.Price * item.Amount * 100 / subtotal;
item.Price += percent * taxTotal / (100 * item.Amount);
item.Price -= percent * totalDiscount / (100 * item.Amount);
}
var shopCartItems = orderItems.Select(item => new
{
title = item.Name,
category = item.ItemType == EnumItemType.Product ?
ProductService.GetCategoriesByProductId(item.EntityId).FirstOrDefault().Name
: "",
qty = item.Amount,
price = Math.Round(item.Price)
}).ToList();
var shippingCost = order.ShippingCost / order.OrderCurrency.CurrencyValue;
if (shippingCost > 0)
{
shopCartItems.Add(new
{
title = "Доставка",
category = "",
qty = 1,
price = Math.Round(shippingCost)
});
}
var details = new
{
firstname = order.OrderCustomer.FirstName,
lastname = order.OrderCustomer.LastName,
middlename = "",
email = order.OrderCustomer.Email != "admin" ? order.OrderCustomer.Email : "",
cellphone = order.OrderCustomer.MobilePhone
};
var array = new
{
items = shopCartItems,
details,
partnerId = partnerId,
partnerName = SettingsMain.ShopName.Replace("\"", "").Replace("'", ""),
partnerOrderId = Sandbox ? (order.Number.ToString() + "-kvk-test") : order.OrderID.ToString(),
deliveryType = ""
};
OrderSum = shopCartItems.Sum(item => item.price * item.qty);
return(JsonConvert.SerializeObject(array));
}
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;
}
protected void Page_Load(object sender, EventArgs e)
{
if (EmptyCheck || Order == null)
{
Error404();
return;
}
lblOrderID.Text = Order.OrderID.ToString();
lblcompanyname.Text = Bill.CompanyName; // bill2.CompanyName;
lTransactAccount.Text = Bill.TransAccount; // bill2.PayBill;
lblinn.Text = Bill.INN;
divKPP.Visible = Bill.KPP.IsNotEmpty();
lblkpp.Text = Bill.KPP.IsNotEmpty() ? Bill.KPP : string.Empty;
lblbank.Text = Bill.BankName;
lCorrespondentAccount.Text = Bill.CorAccount;
lblbik.Text = Bill.BIK;
lblProvider.Text = string.Format("ИНН {0}, {1} {2}, {3}{4}", Bill.INN,
Bill.KPP.IsNullOrEmpty() ? string.Empty : "КПП " + Bill.KPP + ",",
Bill.CompanyName, Bill.Address,
(Bill.Telephone.IsNullOrEmpty() ? string.Empty : ", тел. " + Bill.Telephone));
lblDirector.Text = (string.IsNullOrEmpty(Bill.Director)) ? "______________________" : Bill.Director;
lblAccountant.Text = (string.IsNullOrEmpty(Bill.Accountant)) ? "______________________" : Bill.Accountant;
lblManager.Text = (string.IsNullOrEmpty(Bill.Manager)) ? "______________________" : Bill.Manager;
lblDateTime.Text = (Order.OrderDate).ToString("dd.MM.yy");
string userAddress =
(new List <string>()
{
Order.BillingContact.Name,
Order.BillingContact.Country,
Order.BillingContact.Zone,
Order.BillingContact.City,
Order.BillingContact.Address
}).Where(s => s.IsNotEmpty()).AggregateString(", ");
if (Order.PaymentDetails != null)
{
lblBuyer.Text = string.Format("{0}{1}{2}", (string.IsNullOrEmpty(Order.PaymentDetails.INN)) ? "" : ("ИНН " + Order.PaymentDetails.INN + ", "),
(string.IsNullOrEmpty(Order.PaymentDetails.CompanyName)) ? "" : Order.PaymentDetails.CompanyName + ", ",
userAddress);
}
else
{
lblBuyer.Text = userAddress;
}
if (Order.OrderItems != null && Order.OrderItems.Any())
{
rptOrderItems.DataBind();
}
else
{
rptOrderItems.Visible = false;
}
if (Order.OrderCertificates != null && Order.OrderCertificates.Any())
{
rptOrderCertificates.DataBind();
}
else
{
rptOrderCertificates.Visible = false;
}
trShipping.DataBind();
trPaymentCost.Visible = Order.PaymentCost != 0;
float priceSum = Order.OrderItems.Sum(oi => oi.Price * oi.Amount) + Order.ShippingCost + Order.PaymentCost;
lbltotalprice.Text = CatalogService.GetStringPrice(priceSum, Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode);
lTotalDiscount.Text = CatalogService.GetStringPrice(Order.TotalDiscount, Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode);
lbltotalpricetopay.Text = CatalogService.GetStringPrice(Order.Sum, Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode);
lbltotalprice2.Text = lbltotalpricetopay.Text;
literalTaxCost.Text =
BuildTaxTable(TaxServices.GetOrderTaxes(Order.OrderID).Where(p => p.TaxSum > 0).ToList(), Order.OrderCurrency);
float sumToRender = Order.Sum / Order.OrderCurrency.CurrencyValue;
var intPart = (int)(Math.Floor(sumToRender));
int floatPart = sumToRender != 0
? SQLDataHelper.GetInt(Math.Round(sumToRender - Math.Floor(sumToRender), 2) * 100)
: 0;
string script = "<script>num2str(\'" + intPart + "\', \'str\');</script>";
switch (floatPart % 10)
{
case 1:
lbltotalkop.Text = floatPart.ToString("0#") + @" копейка";
break;
case 2:
case 3:
case 4:
lbltotalkop.Text = floatPart.ToString("0#") + @" копейки";
break;
default:
lbltotalkop.Text = floatPart.ToString("0#") + @" копеек";
break;
}
ClientScript.RegisterStartupScript(typeof(String), "A", script);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["ordernumber"].IsNullOrEmpty())
{
Response.Redirect("default.aspx");
return;
}
try
{
var orderId = OrderService.GetOrderIdByNumber(Request["ordernumber"]);
lblOrderID.Text = Resource.Admin_ViewOrder_ItemNum + orderId;
Order = OrderService.GetOrder(orderId);
if (Order == null)
{
Response.Redirect("default.aspx");
return;
}
OrdCurrency = Order.OrderCurrency;
lOrderDate.Text = AdvantShop.Localization.Culture.ConvertDate(Order.OrderDate);
if (Order.OrderCertificates != null && Order.OrderCertificates.Count > 0)
{
trBilling.Visible = false;
trShipping.Visible = false;
}
var productPrice = Order.OrderCertificates != null && Order.OrderCertificates.Count > 0
? Order.OrderCertificates.Sum(item => item.Sum)
: Order.OrderItems.Sum(item => item.Amount * item.Price);
var totalDiscount = Order.OrderDiscount;
lblProductPrice.Text = CatalogService.GetStringPrice(productPrice, OrdCurrency.CurrencyValue,
OrdCurrency.CurrencyCode);
trDiscount.Visible = Order.OrderDiscount != 0;
lblOrderDiscount.Text = string.Format("-{0}",
CatalogService.GetStringDiscountPercent(productPrice, totalDiscount,
OrdCurrency.CurrencyValue,
Order.OrderCurrency.CurrencySymbol, Order.OrderCurrency.IsCodeBefore,
CurrencyService.CurrentCurrency.PriceFormat, false));
trBonus.Visible = Order.BonusCost != 0;
lblOrderBonus.Text = string.Format("-{0}",
CatalogService.GetStringPrice(Order.BonusCost,
Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode));
if (Order.Certificate != null)
{
trCertificate.Visible = true;
lblCertificate.Text = string.Format("-{0}",
CatalogService.GetStringPrice(Order.Certificate.Price,
OrdCurrency.CurrencyValue,
OrdCurrency.CurrencyCode));
}
else
{
trCertificate.Visible = false;
}
if (Order.Coupon != null)
{
var productsWithCoupon = Order.OrderItems.Where(item => item.IsCouponApplied).Sum(item => item.Price * item.Amount);
trCoupon.Visible = true;
switch (Order.Coupon.Type)
{
case CouponType.Fixed:
lblCoupon.Text = String.Format("-{0} ({1})",
CatalogService.GetStringPrice(Order.Coupon.Value, OrdCurrency.CurrencyValue, OrdCurrency.CurrencyCode),
Order.Coupon.Code);
break;
case CouponType.Percent:
lblCoupon.Text = String.Format("-{0} ({1}%) ({2})",
CatalogService.GetStringPrice(productsWithCoupon * Order.Coupon.Value / 100, OrdCurrency.CurrencyValue, OrdCurrency.CurrencyCode),
CatalogService.FormatPriceInvariant(Order.Coupon.Value),
Order.Coupon.Code);
break;
}
}
else
{
trCoupon.Visible = false;
}
lblShippingPrice.Text = string.Format("{0}{1}", Order.ShippingCost > 0 ? "+" : "",
CatalogService.GetStringPrice(Order.ShippingCost, Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode));
PaymentRow.Visible = Order.PaymentCost != 0;
lblPaymentPrice.Text = string.Format("{0}{1}", Order.PaymentCost > 0 ? "+" : "",
CatalogService.GetStringPrice(Order.PaymentCost, Order.OrderCurrency.CurrencyValue, Order.OrderCurrency.CurrencyCode));
List <OrderTax> taxedItems = TaxServices.GetOrderTaxes(Order.OrderID);
if (taxedItems.Count > 0)
{
literalTaxCost.Text = TaxServices.BuildTaxTable(taxedItems, Order.OrderCurrency.CurrencyValue,
Order.OrderCurrency.CurrencyCode,
Resource.Admin_ViewOrder_Taxes);
}
lblTotalPrice.Text = CatalogService.GetStringPrice(Order.Sum, Order.OrderCurrency.CurrencyValue,
Order.OrderCurrency.CurrencyCode);
// ------------------------------------------------------------------------------------
if (Order.OrderCertificates == null || Order.OrderCertificates.Count == 0)
{
lvOrderItems.DataSource = Order.OrderItems;
lvOrderItems.DataBind();
}
else
{
lvOrderGiftCertificates.DataSource = Order.OrderCertificates;
lvOrderGiftCertificates.DataBind();
}
MapAdress = Order.ShippingContact.Country + "," + Order.ShippingContact.Zone + "," +
Order.ShippingContact.City + "," + Order.ShippingContact.Address;
}
catch (Exception ex)
{
Debug.LogError(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request["ordernumber"]))
{
Response.Redirect("default.aspx");
}
try
{
int orderId = OrderService.GetOrderIdByNumber(Request["ordernumber"]);
lblOrderID.Text = Resource.Admin_ViewOrder_ItemNum + orderId;
//Added by Evgeni
lOrder0.Text = orderId.ToString();
if (!IsPostBack)
{
Order ord = OrderService.GetOrder(orderId);
if (ord != null)
{
ordCurrency = ord.OrderCurrency;
lOrderDate.Text = AdvantShop.Localization.Culture.ConvertDate(ord.OrderDate);
lNumber.Text = ord.Number;
lblOrderStatus.Text = @"(" + ord.OrderStatus.StatusName + @")";
lblShipping.Text = @"<b>" + Resource.Admin_ViewOrder_Name + @"</b> " + ord.ShippingContact.Name;
lblShipping.Text += @"<br />";
lblShipping.Text += @" <b>" + Resource.Admin_ViewOrder_Country +
@"</b> " + ord.ShippingContact.Country + @"<br />";
lblShipping.Text += @" <b>" + Resource.Admin_ViewOrder_City +
@"</b> " + ord.ShippingContact.City + @"<br />";
if (ord.ShippingContact.Zone != null)
{
lblShipping.Text += @" <b>" + Resource.Admin_ViewOrder_Zone +
@"</b> " + ord.ShippingContact.Zone.Trim() + @"<br />";
}
if (ord.ShippingContact.Zip != null)
{
lblShipping.Text += @" <b>" + Resource.Admin_ViewOrder_Zip +
@"</b> " + ord.ShippingContact.Zip.Trim() + @"<br />";
}
lblShipping.Text += @" <b>" + Resource.Admin_ViewOrder_Address +
@"</b> " + ord.ShippingContact.Address + @"<br />";
lblBilling.Text = @"<b>" + Resource.Admin_ViewOrder_Name + @"</b> " + ord.BillingContact.Name;
lblBilling.Text += @"<br />";
lblBilling.Text += @" <b>" + Resource.Admin_ViewOrder_Country +
@"</b> " + ord.BillingContact.Country + @"<br />";
lblBilling.Text += @" <b>" + Resource.Admin_ViewOrder_City +
@"</b> " + ord.BillingContact.City + @"<br />";
if (ord.BillingContact.Zone != null)
{
lblBilling.Text += @" <b>" + Resource.Admin_ViewOrder_Zone +
@"</b> " + ord.BillingContact.Zone.Trim() + @"<br />";
}
if (ord.BillingContact.Zip != null)
{
lblBilling.Text += @" <b>" + Resource.Admin_ViewOrder_Zip +
@"</b> " + ord.BillingContact.Zip.Trim() + @"<br />";
}
lblBilling.Text += @" <b>" + Resource.Admin_ViewOrder_Address +
@"</b> " + ord.BillingContact.Address + @"<br />";
lblShippingMethod.Text = @"<b>" + ord.ArchivedShippingName + @"</b>";
if (ord.OrderPickPoint != null)
{
lblShippingMethod.Text += @"</br><b>" + ord.OrderPickPoint.PickPointAddress + @"</b>";
}
lblPaymentType.Text = @"<b>" + ord.PaymentMethodName + @"</b>";
// ------------------------------------------------------------------------------------
decimal productPrice = ord.OrderItems.Sum(item => item.Amount * item.Price);
decimal totalDiscount = ord.OrderDiscount;
lblProductPrice.Text = CatalogService.GetStringPrice(productPrice, ordCurrency.CurrencyValue, ordCurrency.CurrencyCode);
trDiscount.Visible = ord.OrderDiscount != 0;
lblOrderDiscount.Text = string.Format("-{0}", CatalogService.GetStringDiscountPercent(productPrice, totalDiscount,
ordCurrency.CurrencyValue, ord.OrderCurrency.CurrencySymbol,
ord.OrderCurrency.IsCodeBefore, CurrencyService.CurrentCurrency.PriceFormat, false));
if (ord.Certificate != null)
{
trCertificate.Visible = true;
lblCertificate.Text = string.Format("-{0}",
CatalogService.GetStringPrice(ord.Certificate.Price,
ordCurrency.CurrencyValue,
ordCurrency.CurrencyCode));
}
else
{
trCertificate.Visible = false;
}
if (ord.Coupon != null)
{
trCoupon.Visible = true;
switch (ord.Coupon.Type)
{
case CouponType.Fixed:
lblCoupon.Text = String.Format("-{0} ({1})",
CatalogService.GetStringPrice(ord.Coupon.Value,
ordCurrency.CurrencyValue,
ordCurrency.CurrencyCode),
ord.Coupon.Code);
break;
case CouponType.Percent:
lblCoupon.Text = String.Format("-{0} ({1}%) ({2})",
CatalogService.GetStringPrice(ord.Coupon.Value,
ordCurrency.CurrencyValue,
ordCurrency.CurrencyCode),
CatalogService.FormatPriceInvariant(ord.Coupon.Value),
ord.Coupon.Code);
break;
}
}
else
{
trCoupon.Visible = false;
}
lblShippingPrice.Text = string.Format("+{0}", CatalogService.GetStringPrice(ord.ShippingCost, ord.OrderCurrency.CurrencyValue, ord.OrderCurrency.CurrencyCode));
List <TaxValue> taxedItems = TaxServices.GetOrderTaxes(ord.OrderID);
literalTaxCost.Text = TaxServices.BuildTaxTable(taxedItems, ord.OrderCurrency.CurrencyValue, ord.OrderCurrency.CurrencyCode, Resource.Admin_ViewOrder_Taxes);
//Added By Evgeni
lblTotalPrice.Text = lblTotalPrice0.Text = CatalogService.GetStringPrice(ord.Sum, ord.OrderCurrency.CurrencyValue, ord.OrderCurrency.CurrencyCode);
// ------------------------------------------------------------------------------------
if (string.IsNullOrEmpty(ord.CustomerComment))
{
lblUserComments.Visible = false;
}
else
{
lblUserComments.Text = Resource.Client_PrintOrder_YourComment + @" <br /> " + ord.CustomerComment;
lblUserComments.Visible = true;
}
lStatusComment.Text = ord.StatusComment;
DataListOrderItems.DataSource = ord.OrderItems;
DataListOrderItems.DataBind();
}
}
}
catch (Exception ex)
{
Debug.LogError(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (EmptyCheck || Order == null)
{
return;
}
string company = HttpUtility.UrlDecode(Request["bill_companyname"]);
string inn = HttpUtility.UrlDecode(Request["bill_inn"]);
lblOrderID.Text = Order.OrderID.ToString();
lblcompanyname.Text = Bill.CompanyName; // bill2.CompanyName;
lTransactAccount.Text = Bill.TransAccount; // bill2.PayBill;
lblinn.Text = Bill.INN;
lblkpp.Text = Bill.KPP;
lblbank.Text = Bill.BankName;
lCorrespondentAccount.Text = Bill.CorAccount;
lblbik.Text = Bill.BIK;
lblProvider.Text = string.Format("ИНН {0} КПП {1} {2} {3} {4}", Bill.INN, Bill.KPP, Bill.CompanyName,
Bill.Address,
((string.IsNullOrEmpty(Bill.Telephone)) ? "" : ", тел. " + Bill.Telephone));
lblDirector.Text = (string.IsNullOrEmpty(Bill.Director)) ? "______________________" : Bill.Director;
lblAccountant.Text = (string.IsNullOrEmpty(Bill.Accountant)) ? "______________________" : Bill.Accountant;
lblManager.Text = (string.IsNullOrEmpty(Bill.Manager)) ? "______________________" : Bill.Manager;
lblDateTime.Text = (Order.OrderDate).ToString("dd.MM.yy");
string userAddress = Order.BillingContact.Address;
lblBuyer.Text = string.Format("{0}{1} {2}", (string.IsNullOrEmpty(inn)) ? "" : ("ИНН " + inn + " "), company,
userAddress);
ShippingPrice = Order.ShippingCost / Order.OrderCurrency.CurrencyValue;
rptOrderItems.DataBind();
trShipping.DataBind();
decimal priceSum = Order.OrderItems.Sum(oi => oi.Price * oi.Amount);
decimal discount = Order.TotalDiscount;
lbltotalprice.Text = priceSum.ToString("##,##0.00") + ' ' + @"руб.";
lTotalDiscount.Text = discount.ToString("##,##0.00") + ' ' + @"руб.";
lbltotalpricetopay.Text = Order.Sum.ToString("##,##0.00") + ' ' + @"руб.";
lbltotalprice2.Text = lbltotalpricetopay.Text;
//NOTE using RUR - unstable!!!!
literalTaxCost.Text = BuildTaxTable(TaxServices.GetOrderTaxes(Order.OrderID).Where(p => p.TaxSum > 0).ToList());
var intPart = (int)(Math.Floor(Order.Sum));
int floatPart = Order.Sum != 0 ? Convert.ToInt32(Math.Round(Order.Sum - Math.Floor(Order.Sum), 2) * 100) : 0;
string script = "<script>num2str(\'" + intPart + "\', \'str\');</script>";
switch (floatPart % 10)
{
case 1:
lbltotalkop.Text = floatPart.ToString("0#") + @" копейка";
break;
case 2:
case 3:
case 4:
lbltotalkop.Text = floatPart.ToString("0#") + @" копейки";
break;
default:
lbltotalkop.Text = floatPart.ToString("0#") + @" копеек";
break;
}
ClientScript.RegisterStartupScript(typeof(String), "A", script);
}
