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(); }