public vwOrder ViewOrder(string username)
{
try
{
using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities())
{
return(context.vwOrders.Where(x => x.Username == username).FirstOrDefault());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
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 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 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());
}
}
private vwOrder FindOrderByID(int id)
{
try
{
using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities())
{
vwOrder order = (from x in context.vwOrders where x.OrderID == id select x).FirstOrDefault();
return(order);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public List <tblProduct> GetAllProducts()
{
try
{
using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities())
{
List <tblProduct> list = new List <tblProduct>();
list = (from x in context.tblProducts select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwOrder> GetAllOrders()
{
try
{
using (DAN_XLVIIIEntities context = new DAN_XLVIIIEntities())
{
List <vwOrder> orders = new List <vwOrder>();
orders = (from x in context.vwOrders select x).ToList();
return(orders);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
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);
}
}
