using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; namespace AdminControls { public class OrderContentsControl : WebBlocksControl { private int _OrderID = 0; public int OrderID { set { _OrderID = value; } } protected Table tbOrderContents; protected override void Render(HtmlTextWriter writer) { writer.Write("\n"); writer.Write(""); DataTable dt = Database.OrderItems_GetByOrderID(_OrderID); double total = 0; foreach (DataRow drx in dt.Rows) { writer.Write(""); writer.Write(""); writer.Write(""); total += (double)(decimal)drx["Cost"]; writer.Write(""); } // select order information DataRow dr = Database.Orders_GetByOrderID(_OrderID); // get discounts DataTable dtDiscounts = Database.OrderDiscounts_GetByOrderID(_OrderID); if (dr != null) { writer.Write(""); writer.Write(""); foreach (DataRow drDiscount in dtDiscounts.Rows) { writer.Write(""); } writer.Write(""); writer.Write(""); } writer.Write("
QuantityProduct NameUnit PriceCost
"); writer.Write(drx["Quantity"].ToString()); writer.Write(""); writer.Write((string)drx["Name"]); writer.Write(""); writer.Write(((decimal)drx["Price"]).ToString("C")); writer.Write(""); writer.Write(((decimal)drx["Cost"]).ToString("C")); writer.Write("
Sub Total"); writer.Write(total.ToString("C")); writer.Write("
Tax"); writer.Write(((decimal)dr["TaxAmount"] > 0 ? "Tax Charged" : "Tax Not Charged")); writer.Write(""); writer.Write(((decimal)dr["TaxAmount"]).ToString("C")); writer.Write("
Discount"); writer.Write((string)drDiscount["DiscountName"]); writer.Write(""); writer.Write((-(decimal)dr["DiscountAmount"]).ToString("C")); writer.Write("
Shipping"); writer.Write((string)dr["ShippingMethod"]); writer.Write(""); writer.Write(((decimal)dr["ShippingAmount"]).ToString("C")); writer.Write("
Grand Total"); writer.Write(((decimal)dr["Amount"]).ToString("C")); writer.Write("
"); } } }