void RejectInventoryChanges(int orderId)
{
lw.ShoppingCart.ShoppingDsTableAdapters.ShoppingItemsTableAdapter adp = new lw.ShoppingCart.ShoppingDsTableAdapters.ShoppingItemsTableAdapter();
ShoppingDs.ShoppingItemsDataTable dt = adp.GetDataByOrder(orderId);
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
if (row["OptionsKey"] == System.DBNull.Value || row["OptionsKey"].ToString() == "")
{
sb.Append(string.Format("Update Items set StockQuantity = StockQuantity + {0} where ItemId={1};",
row["Quantity"], row["ItemId"]));
}
else
{
sb.Append(string.Format("Update ItemOptionsInventory set Inventory=Inventory+{0} where ItemId={1} and [Key]='{2}';",
row["Quantity"], row["ItemId"], row["OptionsKey"]));
}
}
if (sb.Length > 0)
{
DBUtils.ExecuteQuery(sb.ToString(), cte.lib);
}
}
void Init()
{
sBasket = WebContext.Profile.Basket;
this.Total = sBasket.Total;
this.SubTotal = sBasket.SubTotal;
this.Discount = sBasket.Discount;
this.Tax = sBasket.Tax;
this.Shipping = sBasket.Shipping;
this.Handling = sBasket.Handling;
this.GiftVoucherValue = sBasket.GiftVoucherValue;
this.Weight = sBasket.Weight;
this.GiftVouvher = sBasket.GiftVouvher;
this.Region = sBasket.Region;
this.Country = sBasket.Country;
this.Payment = lw.Payments.Payments.GetPayment(sBasket.PaymentType);
if (sBasket.Items != null && sBasket.Items.Length > 0)
{
BasketItems = this.DeserializeTable(sBasket.Items);
}
else
{
BasketItems = new ShoppingDs.ShoppingItemsDataTable();
}
}
public ShoppingDs.ShoppingItemsDataTable DeserializeTable(byte[] bytes)
{
System.IO.MemoryStream stream = new System.IO.MemoryStream(bytes);
ShoppingDs.ShoppingItemsDataTable dt = new ShoppingDs.ShoppingItemsDataTable();
dt.ReadXml(stream);
stream.Close();
return(dt);
}
public string GetShoppingItems(OrdersDS.OrdersRow order)
{
lw.ShoppingCart.ShoppingDsTableAdapters.ShoppingItemsTableAdapter adp = new lw.ShoppingCart.ShoppingDsTableAdapters.ShoppingItemsTableAdapter();
StringBuilder sb = new StringBuilder();
ShoppingDs.ShoppingItemsDataTable shoppingItems = adp.GetDataByOrder(order.OrderId);
sb.Append("<table width=500 border=1 cellpadding=3>");
sb.Append("<tr style=\"font-weight:bold\"><td>Product</td><td>Quantity</td><td>Unit Price</td><td>Sub Total</td></tr>");
bool alter = false;
foreach (ShoppingDs.ShoppingItemsRow item in shoppingItems)
{
sb.Append(string.Format(
"<tr bgcolor={0}><td>{1}<BR /># {2}<BR>{3}</td><td>{4}<BR />{6}</td><td>{5}</td><td>{7}</td></tr>",
alter ? "#ffffff" : "#efefef",
item.Title, item.ItemNumber, item.Description,
item.Quantity, string.Format("{0:##,###0.00} SAR", item.UnitPrice),
item.PriceFor,
string.Format("{0:##,###0.00} SAR", item.Quantity * item.UnitPrice)
)
);
alter = !alter;
}
sb.Append("<tr><td colspan=4 align=right>");
sb.Append(string.Format("Sub Total: {0:##,###0.00} SAR<br />", order.SubTotal));
sb.Append(string.Format("Shipping: {0:##,###0.00} SAR<br />", order.Shipping));
sb.Append(string.Format("Handling: {0:##,###0.00} SAR<br />", order.Handling));
if (order.Discount > 0)
{
sb.Append(string.Format("Discount: {0:##,###0.00} SAR<br />", order.SubTotal));
}
if (order.VoucherValue != 0)
{
sb.Append(string.Format("Voucher Code Value: {0:##,###0.00} SAR<br />", order.VoucherValue));
}
string paymentName = "";
lw.Payments.Payment payment = lw.Payments.Payments.GetPayment(order.PaymentType);
if (payment != null)
{
paymentName = payment.DisplayName;
}
sb.Append(string.Format("Payment Type: {0}<br />", paymentName));
sb.Append(string.Format("Payment Cost: {0:##,###0.00} SAR<br />", order.PaymentCost));
sb.Append(string.Format("<b>Order Total: {0:##,###0.00} SAR</b><br />", order.Total));
sb.Append("</td></tr></table>");
return(sb.ToString());
}
public override void DataBind()
{
if (bound)
{
return;
}
bound = true;
int orderId = (int)DataBinder.Eval(NamingContainer, "DataItem.OrderId");
OrdersManager oMgr = new OrdersManager();
OrdersDS.OrdersRow order = oMgr.GetOrder(orderId);
ShoppingItemsTableAdapter adp = new ShoppingItemsTableAdapter();
StringBuilder sb = new StringBuilder();
ShoppingDs.ShoppingItemsDataTable shoppingItems = adp.GetDataByOrder(orderId);
HtmlTableRow header = new HtmlTableRow();
header.Attributes["class"] = "header";
HtmlTableCell cell = new HtmlTableCell();
cell.InnerHtml = "Product";
header.Cells.Add(cell);
cell = new HtmlTableCell();
cell.InnerHtml = "Quantity";
header.Cells.Add(cell);
cell = new HtmlTableCell();
cell.InnerHtml = "Unit Price";
cell.Align = "right";
header.Cells.Add(cell);
cell = new HtmlTableCell();
cell.InnerHtml = "Sub Total";
cell.Align = "right";
header.Cells.Add(cell);
this.Rows.Add(header);
bool alter = false;
foreach (ShoppingDs.ShoppingItemsRow item in shoppingItems)
{
HtmlTableRow row = new HtmlTableRow();
row.Attributes["class"] = alter ? "alter" : "";
string temp = string.Format(
"{0}<BR /># {1}<BR>{2}",
item.Title, item.ItemNumber, item.Description
);
cell = new HtmlTableCell();
cell.InnerHtml = temp;
row.Cells.Add(cell);
cell = new HtmlTableCell();
cell.InnerHtml = item.Quantity.ToString();
row.Cells.Add(cell);
cell = new HtmlTableCell();
cell.Align = "right";
cell.InnerHtml = string.Format(" {0:##,###0.00} SAR", item.UnitPrice);
row.Cells.Add(cell);
cell = new HtmlTableCell();
cell.Align = "right";
cell.InnerHtml = string.Format(" {0:##,###0.00} SAR", (item.UnitPrice * item.Quantity));
row.Cells.Add(cell);
alter = !alter;
Rows.Add(row);
}
HtmlTableRow footer = new HtmlTableRow();
footer.Attributes["class"] = "footer";
HtmlTableCell footerCell = new HtmlTableCell();
footerCell.ColSpan = 5;
sb.Append(string.Format("Sub Total: {0:##,###0.00} SAR<br />", order.SubTotal));
sb.Append(string.Format("Shipping: {0:##,###0.00} SAR<br />", order.Shipping));
sb.Append(string.Format("Handling: {0:##,###0.00} SAR<br />", order.Handling));
if (order.Discount > 0)
{
sb.Append(string.Format("Discount: {0:##,###0.00} SAR<br />", order.SubTotal));
}
if (order.VoucherValue != 0)
{
sb.Append(string.Format("Voucher Code Value: {0:##,###0.00} SAR<br />", order.VoucherValue));
}
string paymentName = "";
lw.Payments.Payment payment = lw.Payments.Payments.GetPayment(order.PaymentType);
if (payment != null)
{
paymentName = payment.DisplayName;
}
sb.Append(string.Format("Payment Type: {0}<br />", paymentName));
sb.Append(string.Format("Payment Cost: {0:##,###0.00} SAR<br />", order.PaymentCost));
sb.Append(string.Format("<b>Order Total: {0:##,###0.00} SAR</b><br />", order.Total));
footerCell.InnerHtml = sb.ToString();
footer.Cells.Add(footerCell);
Rows.Add(footer);
base.DataBind();
}
