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