private void Edit_Show_Position(int id)//метод для редактирования для показа существующей позиции { List <SelectListItem> item = new List <SelectListItem>(); using (RestaurantEnt db = new RestaurantEnt()) { foreach (var VARIABLE in db.Position) { if (id == VARIABLE.Id) { item.Add(new SelectListItem { Text = VARIABLE.Name_Posinion, Value = $"{VARIABLE.Id}", Selected = true }); } else { item.Add(new SelectListItem { Text = VARIABLE.Name_Posinion, Value = $"{VARIABLE.Id}" }); } } } ViewBag.items = item; }
public Model_List_Peges Get_Menu(string position, int pages)//достаю из базы по 4 позиции { Model_List_Peges listPeges = new Model_List_Peges(); using (RestaurantEnt db = new RestaurantEnt()) { var menu = position == null ? db.Menu.OrderBy(z => z.Id).Skip((pages - 1) * PageSize).Take(PageSize).ToList() : db.Menu.Where(z => z.Position.Name_Posinion == position).OrderBy(z => z.Id) .Skip((pages - 1) * PageSize).Take(PageSize).ToList(); listPeges.pagingInfo.CurrentPage = pages; listPeges.pagingInfo.ItemsPerPage = PageSize; listPeges.pagingInfo.Position = position; listPeges.pagingInfo.TotalItems = position == null ? db.Menu.ToList().Count : db.Menu.Where(z => z.Position.Name_Posinion == position).ToList().Count; foreach (var VARIABLE in menu) { ModelMenu model = new ModelMenu { Id = VARIABLE.Id, Name = VARIABLE.Name_food, Description = VARIABLE.Descriptions, Prise = VARIABLE.Prise, Img = VARIABLE.Img }; listPeges.menu.Add(model); } } return(listPeges); }
public List <Checks> GetChecks() { List <Checks> checkses = null; using (RestaurantEnt db = new RestaurantEnt()) { checkses = db.Checks.ToList(); } return(checkses); }
private List <string> GetPosition() { List <string> var; using (RestaurantEnt db = new RestaurantEnt()) { var = db.Position.Select(z => z.Name_Posinion).ToList(); } return(var); }
public bool Get_Valid(Model_Admin admin)// проверка на правильность написания логин и пароль { using (RestaurantEnt db =new RestaurantEnt()) { var user = db.Admin.Where(z => z.Name == admin.Login && z.Passvord == admin.Password).ToList(); if (user.Count != 0) { return true; } } return false; }
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 object Get_Id_Position(int id) { ModelPosition model = new ModelPosition(); using (RestaurantEnt db = new RestaurantEnt()) { var pos = db.Position.FirstOrDefault(z => z.Id == id); model.Id = pos.Id; model.Position = pos.Name_Posinion; } return(model); }
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(); } }
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(); } }
public void Show_Position()//для отображения в DropDownlist { List <SelectListItem> item = new List <SelectListItem>(); using (RestaurantEnt db = new RestaurantEnt()) { foreach (var VARIABLE in db.Position) { item.Add(new SelectListItem { Text = VARIABLE.Name_Posinion, Value = $"{VARIABLE.Id}" }); } } ViewBag.items = item; }
public List <ModelPosition> Get_Positions() { List <ModelPosition> lists = new List <ModelPosition>(); using (RestaurantEnt db = new RestaurantEnt()) { var pos = db.Position.ToList(); foreach (var VARIABLE in pos) { ModelPosition model = new ModelPosition { Id = VARIABLE.Id, Position = VARIABLE.Name_Posinion }; lists.Add(model); } } return(lists); }
public ActionResult EditFood(int id)//редактирование { ModelFood food; using (RestaurantEnt db = new RestaurantEnt()) { var menu = db.Menu.FirstOrDefault(z => z.Id == id); food = new ModelFood { Id = menu.Id, Name = menu.Name_food, Description = menu.Descriptions, Prise = menu.Prise, Position = menu.id_Position.ToString() }; food.Set_Img(menu.Img); Edit_Show_Position(menu.id_Position); } return(View(food)); }
public List <Model_Table_Menu> GetMenu() { List <Model_Table_Menu> list = new List <Model_Table_Menu>(); using (RestaurantEnt db = new RestaurantEnt()) { var menu = db.Menu.ToList(); foreach (var VARIABLE in menu) { Model_Table_Menu food = new Model_Table_Menu { Id = VARIABLE.Id, Title = VARIABLE.Name_food, Prise = VARIABLE.Prise }; list.Add(food); } } return(list); }
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 Sorted(string PositionId)//сортировка по позициям { int poz = Int32.Parse(PositionId); List <Model_Table_Menu> list = new List <Model_Table_Menu>(); using (RestaurantEnt db = new RestaurantEnt()) { var menu = db.Menu.Where(z => z.id_Position == poz).ToList(); foreach (var VARIABLE in menu) { Model_Table_Menu food = new Model_Table_Menu { Id = VARIABLE.Id, Title = VARIABLE.Name_food, Prise = VARIABLE.Prise }; list.Add(food); } } return(PartialView(list)); }
public PartialViewResult Day()//сортировка заказы за день { List <Model_Check> Listchecs = new List <Model_Check>(); using (RestaurantEnt db = new RestaurantEnt()) { var checks = db.Checks.Where(z => z.Date_of_check.Day == DateTime.Now.Day).ToList(); foreach (var VARIABLE in checks) { Model_Check check = new Model_Check { Data_of_check = VARIABLE.Date_of_check, Id = VARIABLE.Id, Time = VARIABLE.Time, Prise = VARIABLE.Prase }; Listchecs.Add(check); } } return(PartialView(Listchecs)); }
public List <ModelMore> GetAlls_More(int id) { List <ModelMore> lists = new List <ModelMore>(); using (RestaurantEnt db = new RestaurantEnt()) { var list = db.Check_All.Where(z => z.Id_Checks == id).ToList(); foreach (var VARIABLE in list) { ModelMore more = new ModelMore { Time = VARIABLE.Checks.Time, Name = VARIABLE.Name_food, Prise = VARIABLE.Prise }; lists.Add(more); } } return(lists); }
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 ModelMenu GetOrder(int id)// метод для получения блюда из базы и сохраняем в контеинер { ModelMenu order = null; using (RestaurantEnt db = new RestaurantEnt()) { var or = db.Menu.FirstOrDefault(z => z.Id == id); if (or != null) { order = new ModelMenu { Description = or.Descriptions, Id = or.Id, Img = or.Img, Name = or.Name_food, Prise = or.Prise }; } } return(order); }
public PartialViewResult Year()//за год { List <Model_Check> Listchecs = new List <Model_Check>(); using (RestaurantEnt db = new RestaurantEnt()) { var checks = db.Checks.Where(z => z.Date_of_check.Year == DateTime.Now.Year).ToList(); foreach (var VARIABLE in checks) { Model_Check check = new Model_Check { Data_of_check = VARIABLE.Date_of_check, Id = VARIABLE.Id, Time = VARIABLE.Time, Prise = VARIABLE.Prase }; Listchecs.Add(check); } } return(PartialView("Day", Listchecs)); }
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(); }
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())); }