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