public ORDER_ADD(employee emp)
{
InitializeComponent();
this.emp = emp;
selectList.DataSource = list_of_dishes.SelectListDishAva();
var comboList = list_of_table.ComboTab(emp);
foreach (int i in comboList)
{
comboTable.Items.Add(i);
}
var comboselection = menu.ComboSel();
foreach (menu i in comboselection)
{
comboSelection.Items.Add(i.name_selection);
}
selectList.Columns[0].Visible = false;
selectList.Columns[1].HeaderText = " НАЗВАНИЕ\r\nБЛЮДА";
selectList.Columns[2].Visible = false;
selectList.Columns[3].HeaderText = " РАЗДЕЛ";
selectList.Columns[4].HeaderText = " ЦЕНА";
}
public bool SaveEmp(int id, string surname, string name, string lastname, string login, string password, int?id_pos) //сохранение изменений
{
var emp = db.employee.FirstOrDefault(w => w.id_employee == id);
if ((surname != "") && (name != "") && (login != "") && (id_pos != null) && ((emp.password != null && password != "") || (emp.password != null && password == "")))
{
if (emp == null)
{
emp = new employee();
emp.id_employee = id;
}
emp.surname = Savestring(surname);
emp.name = Savestring(name);
emp.lastname = Savestring(lastname);
if (emp.login != login) //при создании БД на логин было наложено ограничение того, чтобы он не повторялся если он изменился, то изменяем
{
emp.login = login;
}
if (password != "")
{
emp.password = GetHash(password);
}
else
{
emp.password = emp.password;
}
emp.id_position = id_pos;
db.employee.AddOrUpdate(emp);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public SELECT_LIST(int item, employee emp)
{
InitializeComponent();
this.item = item;
this.emp = emp;
try {
switch (item)
{
case 0:
{
comboBoxItem.Visible = true;
selectList.DataSource = emp.SelectListEmp();
selectList.Columns[0].Visible = false;
selectList.Columns[1].HeaderText = "ФАМИЛИЯ";
selectList.Columns[2].HeaderText = "ИМЯ";
selectList.Columns[3].HeaderText = "ОТЧЕСТВО";
selectList.Columns[4].HeaderText = "ЛОГИН";
selectList.Columns[5].Visible = false;
selectList.Columns[6].Visible = false;
selectList.Columns[7].HeaderText = "ДОЛЖНОСТЬ";
foreach (string i in employee.ComboBoxItem())
{
comboBoxItem.Items.Add(i);
}
}
break;
case 1:
{
comboBoxItem.Visible = true;
selectList.DataSource = dish.SelectListDish();
selectList.Columns[0].Visible = false;
selectList.Columns[1].HeaderText = " НАЗВАНИЕ\r\nБЛЮДА";
selectList.Columns[2].Visible = false;
selectList.Columns[3].HeaderText = " РАЗДЕЛ";
selectList.Columns[4].HeaderText = " ДОСТУПНОСТЬ";
selectList.Columns[5].HeaderText = " ЦЕНА (руб)";
foreach (string i in list_of_dishes.ComboBoxItem())
{
comboBoxItem.Items.Add(i);
}
}
break;
case 2:
{
stocks stock = new stocks();
selectList.DataSource = stock.SelectListStocks();
selectList.Columns[0].Visible = false;
selectList.Columns[1].HeaderText = "НАЧАЛО\r\nАКЦИИ";
selectList.Columns[2].HeaderText = "КОНЕЦ\r\nАКЦИИ";
selectList.Columns[3].HeaderText = "РАЗМЕР\r\n СКИДКИ В %";
selectList.Columns[4].Visible = false;
labelSearch.Visible = false;
comboBoxItem.Visible = false;
textBoxsearch.Visible = false;
searchh.Visible = true;
comboBoxSearch.Visible = true;
buttonSearch.Visible = false;
foreach (string i in stocks.ComboBoxItem())
{
comboBoxSearch.Items.Add(i);
}
} break;
}
}
catch { MessageForm f = new MessageForm(); f.ShowDialog(); }
}
public List <int> SelectOrder(employee emp) //вывод списка заказов официанта
{
var ordList = db.orders.Where(p => p.id_employee == emp.id_employee && p.given_out != true).Select(p => p.id_order).ToList();
return(ordList);
}
