/// <summary>
/// Switch Order status to Saved
/// </summary>
private void SaveNewOrder()
{
tblOrder selectedOrder = new tblOrder();
try
{
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
selectedOrder = db.tblOrders.Where(x => x.Id == Order.Id).FirstOrDefault();
if (selectedOrder.State == "Waiting")
{
MessageBox.Show("You Cant Save Order That have State: 'Waiting'");
}
else
{
selectedOrder.State = "Saved";
db.SaveChanges();
MessageBox.Show("Order Saved!");
}
}
AllOrders = GetAllOrders();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
};
}
/// <summary>
/// Saves the Order in database
/// </summary>
private void SaveExecute()
{
try
{
tblOrder order = new tblOrder();
order.Price = Price;
order.State = "Waiting";
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
if (db.tblOrders.Any(x => x.State == "Waiting"))
{
MessageBox.Show($"You already orderd. Order Status: {order.State}");
}
else
{
DateTime dateTime = DateTime.Now;
order.CreatedDate = dateTime.Date;
order.CreatedTime = dateTime.TimeOfDay;
db.tblOrders.Add(order);
db.SaveChanges();
MessageBox.Show($"Ordered Successfully! Order Status: {order.State}");
main.Close();
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
/// <summary>
/// Saves the Order in database
/// </summary>
private void SaveExecute()
{
try
{
tblOrder order = new tblOrder();
order.Price = Price;
order.State = "Waiting";
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
tblGuest guest = db.tblGuests.Where(x => x.Username == "2201996800109").FirstOrDefault();
order.FKGuest = guest.Id;
DateTime dateTime = DateTime.Now;
order.CreatedDate = dateTime.Date;
order.CreatedTime = dateTime.TimeOfDay;
db.tblOrders.Add(order);
db.SaveChanges();
}
MessageBox.Show($"Ordered Successfully! Order Status: {order.State}");
main.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
/// <summary>
/// Logs the Employee or Guest
/// </summary>
private void LogInExecute()
{
if (Username == "2201996800109" && Password == "Gost")
{
try
{
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
if (db.tblOrders.Any(x => x.State == "Waiting"))
{
MessageBox.Show($"You Already Ordered. Order Status: Waiting");
}
else
{
GuestView view = new GuestView();
view.ShowDialog();
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
}
}
else if (Username == "Zaposleni" && Password == "Zaposleni")
{
EmployeeView view = new EmployeeView();
view.ShowDialog();
}
else
{
MessageBox.Show("Incorrect Username or Passwrod");
}
}
/// <summary>
/// Gets All orders from the database
/// </summary>
/// <returns>All Orders</returns>
private List <tblOrder> GetAllOrders()
{
List <tblOrder> allOrders = new List <tblOrder>();
try
{
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
allOrders = db.tblOrders.Where(x => x.Id > 0).ToList();
return(allOrders);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Gets the Guest that ordered selecred order
/// </summary>
private void GetOrderOwner()
{
tblOrder selectedOrder = new tblOrder();
tblGuest guest = new tblGuest();
try
{
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
selectedOrder = db.tblOrders.Where(x => x.Id == Order.Id).FirstOrDefault();
guest = db.tblGuests.Where(x => x.Id == selectedOrder.FKGuest).FirstOrDefault();
}
MessageBox.Show($"Username: {guest.Username}");
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
};
}
/// <summary>
/// Deletes selected Order
/// </summary>
private void DeleteNewOrder()
{
tblOrder selectedOrder = new tblOrder();
try
{
using (PizzaRestourantEntities db = new PizzaRestourantEntities())
{
selectedOrder = db.tblOrders.Where(x => x.Id == Order.Id).FirstOrDefault();
if (selectedOrder.State == "Waiting")
{
MessageBox.Show("You Cant Delete Order That have State: 'Waiting'");
}
else
{
MessageBoxResult result = MessageBox.Show("Do you want to Delete this Order?", "Confirm Deleting", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Cancel:
break;
case MessageBoxResult.Yes:
db.tblOrders.Remove(selectedOrder);
db.SaveChanges();
MessageBox.Show("Order Deleted Successfully!");
break;
case MessageBoxResult.No:
break;
default:
break;
}
}
}
AllOrders = GetAllOrders();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
};
}
