// Method that update order status public tblOrder EditOrderStatus(tblOrder order) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblOrder orderToEdit = (from e in context.tblOrders where e.OrderID == order.OrderID select e).First(); tblOrder oldOrderStatus = new tblOrder(); oldOrderStatus.Name = order.Name; oldOrderStatus.Price = order.Price; oldOrderStatus.OrderStatus = order.OrderStatus; oldOrderStatus.OrderDate = order.OrderDate; oldOrderStatus.UserID = order.UserID; orderToEdit.Name = order.Name; orderToEdit.Price = order.Price; orderToEdit.OrderStatus = order.OrderStatus; orderToEdit.OrderDate = order.OrderDate; orderToEdit.UserID = order.UserID; context.SaveChanges(); return(order); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblUser FindUser(string jmbg) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblUser user = (from e in context.tblUsers where e.jmbg == jmbg select e).First(); return(user); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// Method that archives order, delete from database public void ArchiveOrder(int orderID) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblOrder orderToDelete = (from e in context.tblOrders where e.OrderID == orderID select e).First(); context.tblOrders.Remove(orderToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
// Method that reads all orders from database public List <tblOrder> GetAllOrders() { try { using (PizzeriaEntities context = new PizzeriaEntities()) { List <tblOrder> list = new List <tblOrder>(); list = (from x in context.tblOrders select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// Mhetod that reads users order public List <tblOrder> GetUserOrder() { try { using (PizzeriaEntities context = new PizzeriaEntities()) { List <tblOrder> order = new List <tblOrder>(); order = (from e in context.tblOrders where e.UserID == userId select e).ToList(); return(order); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// Method that add user to database by his jmbg public tblUser AddUser(string user) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblUser newUser = new tblUser(); newUser.jmbg = user; context.tblUsers.Add(newUser); context.SaveChanges(); userId = newUser.UserID; return(newUser); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// Method that add order to database public void AddOrder(tblOrder order) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblOrder newOrder = new tblOrder(); newOrder.Name = order.Name; newOrder.OrderDate = DateTime.Now; newOrder.Price = order.Price; newOrder.OrderStatus = "on hold"; newOrder.UserID = userId; context.tblOrders.Add(newOrder); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
// Methot to check if User has already make an order in the past public bool IsUser(string jmbg) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblUser emloyee = (from e in context.tblUsers where e.jmbg == jmbg select e).First(); if (emloyee == null) { return(false); } else { return(true); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }