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()));
}
