private void Save_Position(ModelPosition model, int id)//сохранение в базу { using (RestaurantEnt db = new RestaurantEnt()) { var pos = db.Position.FirstOrDefault(z => z.Id == id); if (pos != null) { pos.Name_Posinion = model.Position; } db.SaveChanges(); } }
private void Create_Check()//создание чека и сразу заносятся подробности в другую таблицу { using (RestaurantEnt db = new RestaurantEnt()) { Checks check = new Checks { Date_of_check = DateTime.Now, Time = DateTime.Now.ToString("HH:mm:ss"), Prase = singelton.Get_Checks.Summ }; db.Checks.Add(check); db.SaveChanges(); Checks[] checs = db.Checks.ToArray(); int col = checs.Length - 1; foreach (var VARIABLE in singelton.Get_Checks.Check_orders) { Check_All all = new Check_All { Id_Checks = checs[col].Id, Name_food = VARIABLE.Name, Prise = VARIABLE.Prise }; db.Check_All.Add(all); } db.SaveChanges(); } singelton.Get_Checks.Clear_ModelMenu(); }
private void SaveFood(ModelFood food) { Save_Img_Add(food); using (RestaurantEnt db = new RestaurantEnt()) { Menu menu = new Menu { Img = food.img, Name_food = food.Name, Descriptions = food.Description, Prise = food.Prise, id_Position = Int32.Parse(food.Position) }; db.Menu.Add(menu); db.SaveChanges(); } }
private void Edit_SaveFood(ModelFood food, int Id, string img) { Save_Img(food, img); using (RestaurantEnt db = new RestaurantEnt()) { var menu = db.Menu.FirstOrDefault(z => z.Id == Id); menu.Name_food = food.Name; menu.Descriptions = food.Description; menu.id_Position = Int32.Parse(food.Position); menu.Prise = food.Prise; menu.Img = food.img; db.SaveChanges(); } }
public PartialViewResult AddPosition(ModelPosition pos) { if (ModelState.IsValid) { using (RestaurantEnt db = new RestaurantEnt()) { Position position = new Position { Name_Posinion = pos.Position }; db.Position.Add(position); db.SaveChanges(); } return(PartialView("TablePosition", Get_Positions())); } else { return(PartialView()); } }
public PartialViewResult Delete(int id)//удаление Ajax линком { List <Model_Table_Menu> list = new List <Model_Table_Menu>(); using (RestaurantEnt db = new RestaurantEnt()) { var food = db.Menu.FirstOrDefault(z => z.Id == id); db.Menu.Remove(food); db.SaveChanges(); foreach (var VARIABLE in db.Menu) { Model_Table_Menu model = new Model_Table_Menu { Id = VARIABLE.Id, Title = VARIABLE.Name_food, Prise = VARIABLE.Prise }; list.Add(model); } } return(PartialView("Sorted", list)); }
public PartialViewResult Delete(int id)//удаление { using (RestaurantEnt db = new RestaurantEnt()) { var food = db.Menu.Where(z => z.id_Position == id).ToList(); if (food.Count != 0) { foreach (var VARIABLE in food)//удаляю все блюда которые закреплены к категории { db.Menu.Remove(VARIABLE); } } var pos = db.Position.FirstOrDefault(z => z.Id == id); if (pos != null) { db.Position.Remove(pos); db.SaveChanges(); } } return(PartialView("TablePosition", Get_Positions())); }