/// <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;
}
