/// <summary> /// Purpose: Grabs order information based on ID /// Accepts: Int /// Returns: Hashtable /// </summary> public Hashtable GetOrderByID(int id) { Order obj = new Order(); QuickStart_DBEntities dbContext; Hashtable hsh = new Hashtable(); try { dbContext = new QuickStart_DBEntities(); obj = dbContext.Orders.FirstOrDefault(o => o.OrderID == id); if (obj != null) { hsh["orderid"] = obj.OrderID; hsh["userid"] = obj.UserID; hsh["subtotal"] = obj.Subtotal; hsh["taxes"] = obj.Taxes; hsh["deliverytypeid"] = obj.DeliveryTypeID; hsh["deliverycost"] = obj.DeliveryCost; hsh["grandtotal"] = obj.GrandTotal; hsh["created"] = obj.Created; hsh["modified"] = obj.Modified; } } catch (Exception ex) { ErrorLoggerData.ErrorRoutine(ex, "OrderData", "GetOrderByID"); } return hsh; }
/// <summary> /// Deprecated Method for adding a new object to the Orders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToOrders(Order order) { base.AddObject("Orders", order); }
/// <summary> /// Create a new Order object. /// </summary> /// <param name="orderID">Initial value of the OrderID property.</param> public static Order CreateOrder(global::System.Int32 orderID) { Order order = new Order(); order.OrderID = orderID; return order; }
/// <summary> /// Purpose: Update an existing Order in the database /// Accepts: Hashtable /// Returns: Boolean /// </summary> public bool UpdateOrder(Hashtable hsh) { bool isSuccess = false; Order order = new Order(); QuickStart_DBEntities dbContext; try { dbContext = new QuickStart_DBEntities(); int orderid = Convert.ToInt32(hsh["orderid"]); order = dbContext.Orders.FirstOrDefault(o => o.OrderID == orderid); order.UserID = Convert.ToInt32(hsh["userid"]); order.Subtotal = Convert.ToDouble(hsh["subtotal"]); order.Taxes = Convert.ToDouble(hsh["taxes"]); order.DeliveryCost = Convert.ToDouble(hsh["deliverycost"]); order.DeliveryTypeID= Convert.ToInt32(hsh["deliverytypeid"]); order.GrandTotal = Convert.ToDouble(hsh["grandtotal"]); //need 'modified' but not 'created' during an update order.Modified = DateTime.Now; dbContext.SaveChanges(); isSuccess = true; } catch (Exception e) { ErrorRoutine(e, "OrderData", "UpdateOrder"); } return isSuccess; }