private void BtnSaveMenuorder_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(numUpQuantity.Text.Trim()) ||
string.IsNullOrEmpty(cmbxCustomerIdMenuorder.Text.Trim()) ||
string.IsNullOrEmpty(cmbMenuitemMenuorder.Text.Trim())
)
{
MessageBox.Show("Fill All Fields, Please");
return;
}
MenuOrder menuOrder = new MenuOrder();
string customFullname = cmbxCustomerIdMenuorder.SelectedItem.ToString();
Customer customer = _context.Customers.FirstOrDefault(c => c.Firstname + " " + c.Lastname == customFullname);
string selectedMenuItem = cmbMenuitemMenuorder.SelectedItem.ToString();
Models.MenuItem menuItem = _context.MenuItems.FirstOrDefault(m => m.Name + " " + m.Price + " azn" == selectedMenuItem);
menuOrder.CustomerId = customer.Id;
menuOrder.Customer = customer;
menuOrder.MenuItemId = menuItem.Id;
menuOrder.MenuItem = menuItem;
menuOrder.Quantity = Convert.ToInt32(numUpQuantity.Text.Trim());
menuOrder.Status = true;
orderitems.Add(menuOrder);
FillGridView();
//_context.MenuOrders.Add(menuOrder);
//_context.SaveChanges();
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
int hashCode = 41;
if (Id != null)
{
hashCode = hashCode * 59 + Id.GetHashCode();
}
if (Name != null)
{
hashCode = hashCode * 59 + Name.GetHashCode();
}
if (Category != null)
{
hashCode = hashCode * 59 + Category.GetHashCode();
}
if (Menu != null)
{
hashCode = hashCode * 59 + Menu.GetHashCode();
}
if (MenuOrder != null)
{
hashCode = hashCode * 59 + MenuOrder.GetHashCode();
}
if (Widgets != null)
{
hashCode = hashCode * 59 + Widgets.GetHashCode();
}
return(hashCode);
}
}
public ActionResult Menu(int orderId, int dishId)
{
MenuOrder mo = new MenuOrder();
OrderContent oc = new OrderContent();
List <SortedMenu> sortedMenus = new List <SortedMenu>();
foreach (DishCategory category in db.DishCategories)
{
SortedMenu sm = new SortedMenu();
sm.Category = category;
sm.Dishes = db.Dishes.Where(s => s.CategoryId == category.Id).ToList();
sortedMenus.Add(sm);
}
mo.SortedMenues = sortedMenus;
ViewBag.OrderId = orderId;
oc.DishId = dishId;
oc.OrderId = orderId;
mo.OrderContents = db.OrderContents.Where(s => s.OrderId == orderId);
mo.Order = db.Orders.First(s => s.Id == orderId);
mo.Order.Summary = mo.OrderContents.Select(s => s.Dish.Cost).Sum();
db.OrderContents.Add(oc);
db.SaveChanges();
return(View(mo));
}
private List <MenuOrder> GetMenusInCart(string idString)
{
List <MenuOrder> retList = new List <MenuOrder>();
if (!string.IsNullOrEmpty(idString))
{
string[] ids = idString.Split(",");
foreach (string idSt in ids)
{
if (idSt != "")
{
string[] id_w_quantity = idSt.Split(":");
var id = id_w_quantity[0];
var quantity = Int32.Parse(id_w_quantity[1]);
Menu sp = DAL.MenuGet(id, false);
MenuOrder newOrder = new MenuOrder();
if (sp != null && newOrder != null)
{
newOrder.Menu = sp;
newOrder.Quantity = quantity;
newOrder.ItemPrice = sp.Price;
totalPrice += newOrder.Quantity * newOrder.ItemPrice;
ViewData[newOrder.ID.ToString()] = newOrder.Quantity * newOrder.ItemPrice;
ViewData["TotalPrice"] = totalPrice;
retList.Add(newOrder);
}
}
}
}
return(retList);
}
// Menu Created When clicked Save Button
private void BtnSave_Click(object sender, EventArgs e)
{
if ((cbxCustomer.SelectedIndex >= 0) || (cbxProduct.SelectedIndex >= 0) || (numQuantity.Value > 0))
{
if (ValidateOrder())
{
MenuOrder menuOrder = new MenuOrder();
string[] custarr = cbxCustomer.SelectedItem.ToString().Split('-');
string selectedFname = custarr[1].Trim();
string selectedLname = custarr[0].Trim();
selectedCustomer = _context.Customers.FirstOrDefault(c => c.Firstname == selectedFname && c.Lastname == selectedLname);
menuOrder.Customer = selectedCustomer;
menuOrder.CustomerId = selectedCustomer.Id;
string[] prodarr = cbxProduct.SelectedItem.ToString().Split('|');
string selectedPro = prodarr[0].Trim();
SelectedmenuItem = _context.MenuItems.FirstOrDefault(m => m.Name == selectedPro);
menuOrder.MenuItem = SelectedmenuItem;
menuOrder.MenuItemId = SelectedmenuItem.Id;
menuOrder.Quantity = (int)numQuantity.Value;
menuOrder.Status = true;
cbxCustomer.Enabled = false;
btnOrdered.Enabled = true;
menuOrders.Add(menuOrder);
FillOrderList();
}
}
else
{
MessageBox.Show("Please, fill all fields ");
}
}
public async Task <IActionResult> Edit(int id, [Bind("OrderStatusID,ID,Quantity,ItemPrice,TotalPrice,Comment,MenuID")] MenuOrder menuOrder)
{
if (id != menuOrder.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(menuOrder);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MenuOrderExists(menuOrder.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["MenuID"] = new SelectList(_context.Menu, "ID", "Description", menuOrder.MenuID);
ViewData["OrderStatusID"] = new SelectList(_context.OrderStatus, "ID", "ID", menuOrder.OrderStatusID);
return(View(menuOrder));
}
public MenuOrder CreateMenu(AdaptiveCardDataFactory dataFactory, string teamsId)
{
var Data = JObject.FromObject(dataFactory.Request.Data);
var store = Data.GetValue("store").ToString();
if (store == "")
{
return(null);
}
else
{
//var guid = Guid.NewGuid().ToString();
var menu = new MenuOrder
{
//MenuId = Guid.Parse(menuId),
MenuId = Guid.NewGuid(),
Store = store,
TeamsId = teamsId,
};
context.MenuOrder.Add(menu);
context.SaveChanges();
return(menu);
}
}
public ActionResult Delete(int?id)
{
MenuOrder menuOrder = db.MenuOrders.Find(id);
db.MenuOrders.Remove(menuOrder);
db.SaveChanges();
return(JavaScript("alert('success');"));
}
public ActionResult DeleteConfirmed(int id)
{
MenuOrder menuOrder = db.MenuOrders.Find(id);
db.MenuOrders.Remove(menuOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public MenuOrderForm()
{
InitializeComponent();
_context = new GymDbContext();
selectedItemOrder = new MenuOrder();
orderitems = new List <MenuOrder>();
selectedMenu = new MenuOrder();
}
public AddOrderPage(MenuOrder menuOrder)
{
InitializeComponent();
GetImage(menuOrder.PhotoLink);
addedOrder = menuOrder;
}
private void SeedMenuOrdersList()
{
MenuOrder contentOne = new MenuOrder(3, "chicken combo", "combo meal", "bun, chicken pattie, mayo, lettuce", 6.95m);
MenuOrder contentTwo = new MenuOrder(2, "cheeseburger combo", "combo meal", "bun, pattie, lettuce, pickle, onion, tomato, cheese", 5.95m);
MenuOrder contentThree = new MenuOrder(1, "hamburger combo", "combo meal", "bun, pattie, lettuce, pickle, onion, tomato", 5.75m);
_menuRepo.AddToList(contentOne);
_menuRepo.AddToList(contentTwo);
_menuRepo.AddToList(contentThree);
}
// Constructor ...
public MenuOrderForm()
{
InitializeComponent();
_context = new GymDbContext();
SelectedOrder = new MenuOrder();
menuOrders = new List <MenuOrder>();
selectedCustomer = new Customer();
SelectedmenuItem = new MenuItem();
uniMetods = new UniMetods();
}
public ActionResult Create([Bind(Include = "ID,Username,OrderList,OrderDate,Status")] MenuOrder menuOrder)
{
if (ModelState.IsValid)
{
db.MenuOrders.Add(menuOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menuOrder));
}
private async void MenuList_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
if (null != e.SelectedItem)
{
MenuOrder menuOrder = (MenuOrder)e.SelectedItem;
ListView_Menu.SelectedItem = null;
await Navigation.PushModalAsync(new AddOrderPage(menuOrder));
}
}
public static bool DeleteOrder(int orderID)
{
ApplicationDbContext db = new ApplicationDbContext();
MenuOrder menuOrder = db.MenuOrders.FirstOrDefault(u => u.ID == orderID);
if (menuOrder != null)
{
db.MenuOrders.Remove(menuOrder);
}
return(menuOrder != null);
}
private void DgvMenuOrder_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int id = (int)dgvMenuOrder.Rows[e.RowIndex].Cells[0].Value;
selectedItemOrder = orderitems.FirstOrDefault(a => a.Id == id);
Customer customer = _context.Customers.FirstOrDefault(b => b.Id == selectedItemOrder.CustomerId);
cmbxCustomerIdMenuorder.SelectedItem = customer.Firstname + " " + customer.Lastname;
Models.MenuItem menuItem = _context.MenuItems.FirstOrDefault(m => m.Id == selectedItemOrder.MenuItemId);
cmbMenuitemMenuorder.SelectedItem = menuItem.Name + " " + menuItem.Price + " azn";
}
public static bool CheckOrderCommentPermission(string Name, int OrderID)
{
ApplicationDbContext db = new ApplicationDbContext();
MenuOrder menuOrder = db.MenuOrders.FirstOrDefault(item => item.ID == OrderID);
bool outdated = DateTime.Now.Subtract(menuOrder.OrderDate).Days > 3;
bool commented = db.MenuComments.Where(item => item.OrderID == OrderID).Count() > 0;
bool completed = menuOrder.Status.Equals("已完成");
return(!outdated && !commented && completed);
}
public async Task <IActionResult> Create([Bind("OrderStatusID,ID,Quantity,ItemPrice,TotalPrice,Comment,MenuID")] MenuOrder menuOrder)
{
if (ModelState.IsValid)
{
_context.Add(menuOrder);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MenuID"] = new SelectList(_context.Menu, "ID", "Description", menuOrder.MenuID);
ViewData["OrderStatusID"] = new SelectList(_context.OrderStatus, "ID", "ID", menuOrder.OrderStatusID);
return(View(menuOrder));
}
public ActionResult Confirm(string str, string returnUrl)
{
int id = int.Parse(Request["order_id"]);
MenuOrder menuOrder = db.MenuOrders.Find(id);
menuOrder.Address = Request["address"] == null ? "" : Request["address"];
menuOrder.JD = double.Parse(Request["JD"]);
menuOrder.WD = double.Parse(Request["WD"]);
menuOrder.Text = Request["text"] == null ? "" : Request["text"];
db.Entry(menuOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "MenuOrders"));
}
public override void Execute()
{
var menuDefinition = ExecuteCommand(new GetMenuDefinitionCommand(MenuDefinitionId));
var employeeMenus = ExecuteCommand(new GetEmployeeMenusCommand()
{
MenuDefinitionId = menuDefinition.Id
});
var order = new MenuOrder(menuDefinition, Now(), employeeMenus);
order.IsOrdered = true;
RavenSession.Store(order);
menuDefinition.LastOrderDate = Now();
}
// GET: MenuOrders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuOrder menuOrder = db.MenuOrders.Find(id);
if (menuOrder == null)
{
return(HttpNotFound());
}
return(View(menuOrder));
}
// GET: MenuOrders/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuOrder menuOrder = db.MenuOrders.Find(id);
if (menuOrder == null)
{
return(HttpNotFound());
}
return(View(OrderUtils.GetOrderModel(menuOrder)));
}
public void AddItemToMenuTest()
{
Menu_Repository menuRepo = new Menu_Repository();
MenuOrder contentOne = new MenuOrder(3, "chicken combo", "combo meal", "bun, chicken pattie, mayo, lettuce", 6.95m);
menuRepo.AddToList(contentOne);
List <MenuOrder> content = menuRepo.GetMenuOrdersList();
int actual = menuRepo.GetMenuOrdersList().Count;
int expected = 1;
Assert.AreEqual(expected, actual);
Assert.IsTrue(menuRepo.GetMenuOrdersList().Contains(contentOne));
}
private static int GetNumberInMenuOrder(MenuOrder menuOrder, int itemID)
{
string[] s_ids = menuOrder.OrderList.Split(',');
string item_id = itemID.ToString();
int count = 0;
foreach (string s_id in s_ids)
{
if (s_id.Equals(item_id))
{
count++;
}
}
return(count);
}
//Action<Entity> defaultSelect, defaultDeselect;
public MenuGroup(MenuOrder menuOrder = MenuOrder.vertical)
/*
* public MenuGroup(
* MenuOrder menuOrder = MenuOrder.vertical,
* Action<Entity> defaultSelect = null,
* Action<Entity> defaultDeselect = null
* )
*/
{
menuList = new List <Entity>();
this.menuOrder = menuOrder;
//if (defaultSelect != null) this.defaultSelect = defaultSelect;
//if (defaultDeselect != null) this.defaultDeselect = defaultDeselect;
}
public ActionResult Edit([Bind(Include = "ID,Username,OrderList,OrderDate,Status")] MenuOrder menuOrder)
{
//管理员只能修改用户订单的完成状态
if (ModelState.IsValid)
{
MenuOrder o_menuOrder = db.MenuOrders.Find(menuOrder.ID);
o_menuOrder.Status = menuOrder.Status;
db.Entry(o_menuOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(menuOrder));
}
// “添加评论”功能，返回一张空白评论表，评论内容为对应订单的所有菜品
public ActionResult OrderComment(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuOrder menuOrder = db.MenuOrders.Find(id);
UserCommentModel commentModel = CommentUtils.GetBlankCommentModel(menuOrder);
Session["OrderDetails"] = commentModel;
if (menuOrder == null)
{
return(HttpNotFound());
}
return(View(commentModel));
}
private void Btn_BestellingPlaatsen_Click(object sender, EventArgs e) //bestellingen versturen naar db
{
int recentOrderID = 0;
if (listViewWinkelwagen.Items.Count == 0) //check of alle velden zijn ingevuld
{
MessageBox.Show("Vul alle velden in.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
Table currentTable = Table.GetTable();
MenuItem_Service menuItem_Service = MenuItem_Service.GetMenuItemService();
Table_Service table_Service = Table_Service.GetTableService();
Login_Service s = Login_Service.GetLoginService();
int reservationID = table_Service.GetReservationID(currentTable.currentTable.TableID); //reservationID vinden van betreffende tafel
if (reservationID == 0)
{
MessageBox.Show("Er is geen reservering voor deze tafel.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
Order_Service service = Order_Service.GetOrderService();
if (service.PlaceOrder(reservationID, s.CurrentEmployee.Id))
{
recentOrderID = GetMostRecentOrderID();
List <MenuOrder> menuOrders = new List <MenuOrder>();
MenuOrder_DAO menuOrder_DAO = new MenuOrder_DAO();
foreach (ListViewItem li in listViewWinkelwagen.Items) //Lijst met MenuOrders maken vanuit winkelwagen
{
Model.MenuOrder menuOrder = new MenuOrder(int.Parse(li.SubItems[1].Text), recentOrderID, menuItem_Service.GetMenuItemID(li.Text));
menuOrders.Add(menuOrder);
}
foreach (MenuOrder menuOrder in menuOrders) //lijst met menuOrders naar db sturen
{
menuOrder_DAO.PlaceMenuOrder(menuOrder.Amount, menuOrder.OrderID, menuOrder.MenuItemID);
menuOrder_DAO.UpdateStock(menuOrder.Amount, menuOrder.MenuItemID);
}
OrderPlaced();
this.Refresh(); //zet scherm weer op default
}
else
{
MessageBox.Show("Niet gelukt om de order te maken.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public void RemoveProduct()
{
Menu_Repository menuRepo = new Menu_Repository();
MenuOrder meal = new MenuOrder();
MenuOrder mealThree = new MenuOrder(3, "chicken combo", "combo meal", "bun, chicken pattie, mayo, lettuce", 6.95m);
menuRepo.AddToList(meal);
menuRepo.AddToList(mealThree);
menuRepo.RemoveMeal(mealThree);
int actual = menuRepo.GetMenuOrdersList().Count;
int expected = 1;
Assert.AreEqual(expected, actual);
}
