public async void Block(Login item, user3Entities db)
{
TimeSpan timeSpan = new TimeSpan(0, 0, 5);
if (item.CountWrong >= 5 && item.UserName == "Admin")
{
timer.Interval = timeSpan;
timer.Start();
await Task.Run(() => this.timer.Tick += ((o, e) =>
{
item.CountWrong = 0;
db.SaveChanges();
MessageBox.Show(item.UserName + " разблокирован");
timer.Stop();
}));
}
if (item.CountWrong >= 5 && item.UserName == "Manager")
{
timer.Interval = timeSpan;
timer.Start();
await Task.Run(() => this.timer.Tick += ((o, e) =>
{
item.CountWrong = 0;
db.SaveChanges();
MessageBox.Show(item.UserName + " разблокирован");
timer.Stop();
}));
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
Employee emp = new Employee();
emp.Name = Convert.ToString(txtbName.Text);
emp.Surname = Convert.ToString(txtbSurname.Text);
emp.Patronymic = Convert.ToString(txtbPatronymic.Text);
emp.Telephone = Convert.ToString(txtbTelephone.Text);
emp.Restoran = Convert.ToInt32(cbRestorans.SelectedIndex + 1);
emp.BirthDate = DateTime.Parse(dpBirthDate.Text);
emp.NumberOfSales = 0;
Roles rol = cbRole.SelectedItem as Roles;
emp.Role = rol.idRole;
db.Employee.Add(emp);
db.SaveChanges();
Login log = new Login();
log.UserName = txtLogin.Text;
log.Password = txtPassword.Text;
log.Role = rol.idRole;
log.CountWrong = 0;
db.Login.Add(log);
db.SaveChanges();
Close();
}
catch
{ }
}
private void btnCloseZak_Click(object sender, RoutedEventArgs e)
{
if (dgZak.SelectedItem != null)
{
Zakazi zak = dgZak.SelectedItem as Zakazi;
int idZak = Convert.ToInt32(zak.idZakaza);
int Stol = Convert.ToInt32(zak.Stol);
if (zak.Closed == false)
{
if (MessageBox.Show("Вы уверены что хотите закрыть заказ?", "Внимание", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
foreach (var item in db.Zakazi)
{
if (idZak == item.idZakaza)
{
item.DateCloseZakaz = DateTime.Now;
item.Closed = true;
if (item.TypeZakaz == 2)
{
BookingStol t = (BookingStol)db.BookingStol.Where(tt => tt.idStol == item.Stoli.idStola && tt.Status == false).FirstOrDefault();
t.Status = true;
}
}
}
}
foreach (var i in db.Stoli)
{
if (Stol == i.idStola)
{
i.IsBusy = true;
}
}
db.SaveChanges();
dgZak.ItemsSource = db.Zakazi.Where(t => t.DateCloseZakaz.ToString() == "").ToList();
dgZakC.ItemsSource = db.Zakazi.Where(t => t.DateCloseZakaz.ToString() != "").ToList();
foreach (var item in db.Employee)
{
if (item.idEmployee == zak.Employee)
{
item.NumberOfSales = 0;
item.NumberOfSales++;
}
}
db.SaveChanges();
}
else
{
MessageBox.Show("Заказ уже закрыт!");
}
}
else
{
MessageBox.Show("Выберите заказ!");
}
}
private void lvTables_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Stoli s = lvTables.SelectedItem as Stoli;
int idStola = Convert.ToInt32(s.idStola);
if (MessageBox.Show("Освободить стол?", "Внимание", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
foreach (var item in db.Stoli)
{
if (idStola == item.idStola && item.IsBusy == false)
{
item.IsBusy = true;
foreach (var i in db.Zakazi)
{
if (idStola == i.Stol)
{
i.DateCloseZakaz = DateTime.Now;
}
}
}
}
db.SaveChanges();
}
lvTables.ItemsSource = db.Stoli.ToArray().ToList();
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
if (txtbName.Text == "" || txtbSurname.Text == "" || txtbPatr.Text == "" || txtbNominal.Text == "")
{
MessageBox.Show("Заполните все поля");
}
else
{
SkidCards sc = new SkidCards();
Employee emp = cbxEmp.SelectedItem as Employee;
int idEmp = emp.idEmployee;
sc.Surname = txtbName.Text;
sc.Name = txtbName.Text;
sc.Patronymic = txtbPatr.Text;
sc.idEmployee = idEmp;
sc.Nominal = txtbNominal.Text;
sc.NumberCard = txtbNCard.Text;
db.SkidCards.Add(sc);
db.SaveChanges();
Close();
}
}
private void btnDel_Click(object sender, RoutedEventArgs e)
{
if (dgDish.SelectedItem != null)
{
Menu menu = (Menu)dgDish.SelectedItem;
if (MessageBox.Show("Вы точно хотите удалить?", "Внимание", MessageBoxButton.YesNoCancel) == MessageBoxResult.Yes)
{
db.Menu.Remove(menu);
db.SaveChanges();
}
var query = from item in db.Menu
select item;
dgDish.ItemsSource = query.ToList();
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
ZakazBluda zb = new ZakazBluda();
zb.Kolvo = int.Parse(lblCount.Text);
zb.NameBludo = ((Menu)cbBluda.SelectedItem).idBluda;
zb.Cena = ((Menu)cbBluda.SelectedItem).Price;
zb.Summa = ((Menu)cbBluda.SelectedItem).Price * zb.Kolvo;
zb.idZakaza = idZak;
db.ZakazBluda.Add(zb);
db.SaveChanges();
Close();
}
private void btnDel_Click(object sender, RoutedEventArgs e)
{
if (dgSaleCard.SelectedItem != null)
{
SkidCards sc = dgSaleCard.SelectedItem as SkidCards;
db.SkidCards.Remove(sc);
db.SaveChanges();
dgSaleCard.ItemsSource = db.SkidCards.ToArray().ToList();
}
else
{
MessageBox.Show("Выберите поле для удаления!");
}
}
private void btnEnter_Click(object sender, RoutedEventArgs e)
{
bool enter = false;
user3Entities db = new user3Entities();
Login itemLogin = db.Login.Where(i => i.UserName == txtbLogin.Text).FirstOrDefault();
if (itemLogin == null)
{
MessageBox.Show("Ошибка ввода данных!");
}
else
{
foreach (var item in db.Login)
{
if (itemLogin.UserName == item.UserName && pswbPassword.Password == item.Password)
{
this.Login = item.UserName;
this.Dates = DateTime.Now.ToString();
new MainWindow(this.Login, this.Dates).Show();
this.Close();
enter = true;
}
}
if (!enter)
{
itemLogin.CountWrong++;
if (itemLogin.CountWrong < 5)
{
MessageBox.Show($"Неправильно введены логин или пароль Попытка {itemLogin.CountWrong}/5", "Ошибка", MessageBoxButton.OK);
}
if (itemLogin.CountWrong == 5)
{
MessageBox.Show("Этот логин Заблокирован (" + itemLogin.UserName + ")");
Block(itemLogin, db);
}
if (itemLogin.CountWrong > 5)
{
MessageBox.Show("Дождитесь, пока пройдет блокировка");
}
db.SaveChanges();
}
}
}
private void btnRemoveBookingStol_Click(object sender, RoutedEventArgs e)
{
BookingStol itemStol = (BookingStol)dgBooking.SelectedItem;
db.BookingStol.Remove(itemStol);
db.SaveChanges();
List <BookingStol> list = new List <BookingStol>();
foreach (var item in db.BookingStol)
{
DateTime Date = DateTime.Parse(item.DateBooking);
if (Date >= DateTime.Parse(DateTime.Now.ToString("d")))
{
list.Add(item);
}
}
dgBooking.ItemsSource = list;
}
private void btnStol1_Click(object sender, EventArgs e)
{
var tab = db.Stoli.Where(t => t.idStola == 1).FirstOrDefault();
if (tab.IsBusy == true)
{
foreach (var i in db.Stoli)
{
if (tab.idStola == i.idStola)
{
i.IsBusy = false;
}
}
db.SaveChanges();
new RegOrders(tab.idStola, 0, Login).ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Стол занят", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
Menu menu = new Menu();
menu.NameBludo = txtbName.Text;
menu.Wheight = txtbWeight.Text;
menu.Struct = txtbCompos.Text;
menu.RazdelMenu = cbRazdel.SelectedIndex;
menu.Price = Convert.ToInt32(txtbPrice.Text);
if (img != null)
{
menu.Image = img;
}
else
{
}
db.Menu.Add(menu);
db.SaveChanges();
Close();
}
catch
{ }
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
if (stat == 0)
{
Zakazi zak = new Zakazi();
if (lblDate.Content != "")
{
zak.DateOpenZakaz = DateTime.Parse(lblDate.Content.ToString());
zak.TypeZakaz = 2;
}
else
{
zak.DateOpenZakaz = DateTime.Now;
lblDate.Content = DateTime.Now;
zak.TypeZakaz = 1;
}
zak.Stol = idTable;
zak.SummaZakaza = 0;
var emp = db.Employee.Where(i => i.Login.UserName == Login).FirstOrDefault();
zak.Employee = emp.idEmployee;
zak.Closed = false;
db.Zakazi.Add(zak);
db.SaveChanges();
idZak = zak.idZakaza;
txtbStol.Text = Convert.ToString(idTable);
txtbEmployee.Text = emp.Surname.ToString();
btnAdd.IsEnabled = true;
}
else
{
idZak = stat;
var zakaz = db.Zakazi.Where(i => i.idZakaza == stat).FirstOrDefault();
txtbEmployee.Text = zakaz.Employee1.Surname;
if (zakaz.idSCard != null)
{
txtbSkidCard.Text = zakaz.idSCard;
cbSearchSC.IsChecked = true;
txtItogS.Text = zakaz.SummaZakazaS.ToString();
}
if (zakaz.TypeZakaz == 1)
{
lblStasus.Content = "Обычный";
}
else
{
lblStasus.Content = "Предзаказ";
}
lblDate.Content = zakaz.DateOpenZakaz.ToString();
txtItog.Text = zakaz.SummaZakaza.ToString();
txtbStol.Text = zakaz.Stol.ToString();
dgOrdBludo.ItemsSource = db.ZakazBluda.Where(i => i.idZakaza == idZak).ToList();
btnAdd.IsEnabled = true;
btnDel.IsEnabled = true;
btnSave.IsEnabled = true;
Summa = zakaz.SummaZakaza;
//SummaS = (double)zakaz.SummaZakazaS;
}
}
private void btnNext_Click(object sender, EventArgs e)
{
bool proverka = true;
Regex regex = new Regex(@"^[А-ЯЁ][а-яё]+ [А-ЯЁ][а-яё]+$");
Match match = regex.Match(txtFIO.Text);
if (!match.Success)
{
proverka = false;
MessageBox.Show("Поле с ФИО некорректно введено");
}
if (lblNumberStol.Text == "")
{
proverka = false;
MessageBox.Show("Стол не выбран");
}
if (txtNumberPhone.Text == "")
{
proverka = false;
MessageBox.Show("Поле номер телефона не заполнено");
}
regex = new Regex(@"(\+7|8|\b)[\(\s-]*(\d)[\s-]*(\d)[\s-]*(\d)[)\s-]*(\d)[\s-]*(\d)[\s-]*(\d)[\s-]*(\d)[\s-]*(\d)[\s-]*(\d)[\s-]*(\d)");
Match match1 = regex.Match(txtNumberPhone.Text);
if (!match1.Success)
{
proverka = false;
MessageBox.Show("Некорректно введен номер телефона");
}
if (txtTime.Text == "")
{
proverka = false;
MessageBox.Show("Поле время бронирования не заполнено");
}
int result;
if (!int.TryParse(txtCountPeople.Text, out result))
{
proverka = false;
MessageBox.Show("В поле количество необходимо вводить цифры");
}
if (proverka == true)
{
BookingStol bookingStol = new BookingStol();
bookingStol.idStol = int.Parse(lblNumberStol.Text);
bookingStol.TimeBooking = txtTime.Text;
bookingStol.DateBooking = currDate;
bookingStol.ClientFIO = txtFIO.Text;
bookingStol.Status = false;
db.BookingStol.Add(bookingStol);
db.SaveChanges();
MessageBox.Show("Бронь успешно создана");
DialogResult dialogResult = MessageBox.Show("Бронирование успешно создано.\nСделать предзаказ?", "", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
string statusZakaza = "Предзаказ";
RegOrders next = new RegOrders(int.Parse(lblNumberStol.Text), 0, Login);
next.lblStasus.Content = statusZakaza;
next.lblDate.Content = currDate + " " + txtTime.Text;
next.Show();
Close();
}
Close();
}
}
