/// <summary> /// approve execute /// </summary> private void ApproveOrderExecute() { try { if (Order != null) { int orderId = Order.OrderID; if (Order.OrderStatus == "pending") { service.ApproveOrder(orderId); MessageBox.Show("Order approved"); } else if (Order.OrderStatus == "approved") { MessageBox.Show("Order already approved"); } else { MessageBox.Show("Can't approve denied order"); } using (OrderDBEntities1 context = new OrderDBEntities1()) { OrderList = context.tblOrders.ToList(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// Add item execute /// </summary> private void AddItemExecute() { try { if (Item != null) { OrderDBEntities1 db = new OrderDBEntities1(); tblOrder order = new tblOrder(); string quantityItem = MainWindow.quantity; DateTime dateNow = DateTime.Now; order.TotalPrice = Item.ItemPrice * int.Parse(quantityItem); order.OrderStatus = "pending"; order.OrderCreated = dateNow; order.UserID = Service.currentUser.UserID; order.ItemID = Item.ItemID; Service.currentOrder = order; db.tblOrders.Add(order); db.SaveChanges(); MessageBox.Show("Order successfuly created. Your order is pending."); Login log = new Login(); main.Close(); log.Show(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// delete order execute /// </summary> private void DeleteOrderExecute() { try { if (Order != null) { int orderId = Order.OrderID; if (Order.OrderStatus == "pending") { service.DenyOrder(orderId); MessageBox.Show("Order denied"); } else { service.DeleteOrder(orderId); MessageBox.Show("Order deleted"); } using (OrderDBEntities1 context = new OrderDBEntities1()) { OrderList = context.tblOrders.ToList(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// Constructor with one parameter /// </summary> /// <param name="mainOpen">Main window</param> public MainWindowViewModel(MainWindow mainOpen) { main = mainOpen; using (OrderDBEntities1 context = new OrderDBEntities1()) { ItemList = context.tblItems.ToList(); } }
/// <summary> /// Constructor with one parameter /// </summary> /// <param name="mainOpen">Main window</param> public EmployeeViewModel(Employee employeeOpen) { view = employeeOpen; using (OrderDBEntities1 context = new OrderDBEntities1()) { OrderList = context.tblOrders.ToList(); } }
/// <summary> /// delete order /// </summary> /// <param name="orderID">order id</param> public void AddUser(tblUser user) { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { context.tblUsers.Add(user); context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } }
/// <summary> /// deny order /// </summary> /// <param name="orderID">order id</param> public void DenyOrder(int orderID) { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { tblOrder orderToDeny = (from r in context.tblOrders where r.OrderID == orderID select r).First(); orderToDeny.OrderStatus = "denied"; context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } }
/// <summary> /// get all items from database /// </summary> /// <returns></returns> public List <tblItem> GetAllItems() { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { List <tblItem> items = new List <tblItem>(); items = context.tblItems.ToList(); return(items); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// get all users from database /// </summary> /// <returns></returns> public List <tblUser> GetAllUsers() { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { List <tblUser> users = new List <tblUser>(); users = context.tblUsers.ToList(); return(users); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// delete order /// </summary> /// <param name="orderID">order id</param> public tblUser GetUser(string jmbg) { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { tblUser user = (from r in context.tblUsers where r.JMBG == jmbg select r).First(); return(user); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// chech user order status /// </summary> /// <param name="userID">user id</param> /// <returns>pending or not</returns> public string GetOrderStatus(int userID) { try { using (OrderDBEntities1 context = new OrderDBEntities1()) { List <tblOrder> orders = new List <tblOrder>(); orders = context.tblOrders.ToList(); List <tblOrder> userOrders = orders.Where(u => u.UserID == userID).ToList(); string status = userOrders[userOrders.Count - 1].OrderStatus; return(status); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// chech user order status /// </summary> /// <param name="userID">user id</param> /// <returns>pending or not</returns> public bool CheckOrderStatus(int userID) { int a = 0; try { using (OrderDBEntities1 context = new OrderDBEntities1()) { List <tblOrder> orders = new List <tblOrder>(); orders = context.tblOrders.ToList(); List <tblOrder> userOrders = orders.Where(u => u.UserID == userID).ToList(); for (int i = 0; i < userOrders.Count; i++) { if (userOrders[i].OrderStatus == "pending") { a++; } } } if (a > 0) { return(true); } else { return(false); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(false); } }