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