private void SaveExecute() { try { tblCakeList newList = new tblCakeList(); newList.LjubavnoGnezdo = CakeList.LjubavnoGnezdo; newList.Dobos = CakeList.Dobos; newList.Kinder = CakeList.Kinder; newList.Bomba = CakeList.Bomba; newList.Lincer = CakeList.Lincer; newList.Cheese = CakeList.Cheese; context.tblCakeLists.Add(newList); tblOrder newOrder = new tblOrder(); newOrder.CakeListID = newList.CakeListID; newOrder.OrderDate = DateTime.Now; tblUser userToFind = (from r in context.tblUsers where r.Username == InputName select r).FirstOrDefault(); newOrder.UserID = userToFind.UserID; newOrder.TotalPrice = (newList.LjubavnoGnezdo * (1000 + (0.2 * 1000)) + newList.Lincer * (2000 + (0.2) * 2000) + newList.Cheese * (1200 + (0.2 * 1200)) + newList.Dobos * (2500 + (0.2 * 2500)) + newList.Bomba * (800 + (800 * 0.2)) + newList.Kinder * (1100 + (1100 * 0.2))).GetValueOrDefault(); newOrder.NumberOfCakes = 0; context.tblOrders.Add(newOrder); context.SaveChanges(); MessageBox.Show("Order is saved"); Update = true; ViewList = getOrders(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public CreateOrderViewModel(CreateOrder createOrderOpen, string username) { createOrder = createOrderOpen; InputName = username; CakeList = new tblCakeList(); View = new vwOrder(); ViewList = getOrders(); }