public void ConfirmOrder(vwOrder order) { try { using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities()) { tblOrder orderToEdit = context.tblOrders.Where(x => x.OrderID == order.OrderID).FirstOrDefault(); orderToEdit.OrderDate = DateTime.Now; context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public void DenyOrder(vwOrder order) { try { using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities()) { tblOrder orderToReject = context.tblOrders.Where(x => x.OrderID == order.OrderID).FirstOrDefault(); orderToReject.OrderStatus = "denied"; context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public void DeleteOrder(int orderID) { try { using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities()) { tblOrder orderToDelete = (from o in context.tblOrders where o.OrderID == orderID select o).First(); context.tblOrders.Remove(orderToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public tblOrder ChangeOrderStatus(tblOrder order) { try { using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities()) { tblOrder orderTochange = (from o in context.tblOrders where o.OrderID == order.OrderID select o).First(); orderTochange.OrderStatus = order.OrderStatus; context.SaveChanges(); return(order); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblOrder CreateOrder(tblOrder order) { try { using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities()) { tblOrder newOrder = new tblOrder(); newOrder.Username = order.Username; newOrder.ProductID = order.ProductID; newOrder.Quantity = order.Quantity; newOrder.OrderDate = DateTime.Now; newOrder.OrderStatus = order.OrderStatus; context.tblOrders.Add(newOrder); context.SaveChanges(); order.OrderID = newOrder.OrderID; return(order); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }