private void Window_Loaded(object sender, RoutedEventArgs e) { try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { try { if (objectMyDBContext.Database.Exists() == false) { WFAEntity.API.DatabaseRequest.Fill(); //objectMyDBContext.Database.Create(); //WFAEntity.API.Employees objectUser = new WFAEntity.API.Employees(); //objectUser.Name = "user name"; //objectUser.Login = "******"; //objectUser.Password = "******"; //objectMyDBContext.Employees.Add(objectUser); objectMyDBContext.SaveChanges(); } //WFAEntity.API.DatabaseRequest.Fill(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Создание базы данных"); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Подключение к базе данных"); } this.ShowAll(); }
private void ButtonAddEditServices_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditName.Text != string.Empty) { WFAEntity.API.Other_services objectServices = new WFAEntity.API.Other_services( textBlockAddEditName.Text, textBlockAddEditThe_cost.Text, (WFAEntity.API.Employees)ComboBoxAddEditName.SelectedItem ); try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { objectMyDBContext.Other_services.Add(objectServices); objectMyDBContext.SaveChanges(); } MessageBox.Show("Услуга добавлена"); this.DialogResult = true; } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } }
private void Window_Loaded(object sender, RoutedEventArgs e) { //var tmp = MyDBContext.DBContext.Other_services.ToList(); //List<string> Strings = new List<string>(); //for (int i = 0; i < tmp.Count; i++) //{ // Strings.Add(tmp[0].Name + " " + tmp[0].The_cost); //} //ComboBoxAddEditServices.ItemsSource = Strings; //var tmp1 = MyDBContext.DBContext.Employees.ToList(); //List<string> Strings1 = new List<string>(); //for (int i = 0; i < tmp1.Count; i++) //{ // Strings1.Add(tmp1[0].Name + " " + tmp1[0].Surname); //} //ComboBoxAddEditEmployees.ItemsSource = Strings1; using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { ComboBoxAddEditEmployees.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext); ComboBoxAddEditEmployees.Text = "{Binging Name}"; ComboBoxAddEditServices.ItemsSource = WFAEntity.API.DatabaseRequest.GetServices(objectMyDBContext); ComboBoxAddEditServices.Text = "{Binging Name}"; } }
private void deleteSkatesButton_Click(object sender, RoutedEventArgs e) { if (SkatesGrid.SelectedItems.Count > 0) { for (int i = 0; i < SkatesGrid.SelectedItems.Count; i++) { WFAEntity.API.Skates_hire objectSkates = SkatesGrid.SelectedItems[i] as WFAEntity.API.Skates_hire; // if (objectSkates != null) try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Skates_hire Skates = WFAEntity.API.DatabaseRequest.GetSkatesById(objectMyDBContext, objectSkates.ID_skates_hire); objectMyDBContext.Skates_hire.Attach(Skates); objectMyDBContext.Skates_hire.Remove(Skates); objectMyDBContext.SaveChanges(); } //this.ShowAll(SELECTED_TAB.STUDENT); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void Window_Loaded(object sender, RoutedEventArgs e) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { ComboBoxAddEditName.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext); ComboBoxAddEditName.Text = "{Binging Name}"; } }
private void ShowAll() { try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { //var list = WpfApplicationEntity.API.DatabaseRequest.GetMatType(objectMyDBContext); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Тип материалов", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { ComboBoxAddEditClient.ItemsSource = WFAEntity.API.DatabaseRequest.GetClients(objectMyDBContext); ComboBoxAddEditClient.Text = "{Binging Name}"; ComboBoxAddEditShedule.ItemsSource = WFAEntity.API.DatabaseRequest.GetShedule(objectMyDBContext); ComboBoxAddEditShedule.Text = "{Binging Date}"; ComboBoxAddEditServices.ItemsSource = WFAEntity.API.DatabaseRequest.GetServices(objectMyDBContext); ComboBoxAddEditServices.Text = "{Binging Name}"; ComboBoxAddEditSkates.ItemsSource = WFAEntity.API.DatabaseRequest.GetSkates(objectMyDBContext); ComboBoxAddEditSkates.Text = "{Binging Size}"; } }
private void Window_Loaded(object sender, RoutedEventArgs e) { /*var tmp = MyDBContext.DBContext.Employees.ToList(); * List<string> Strings = new List<string>(); * for (int i = 0; i < tmp.Count; i++) * { * Strings.Add(tmp[i].Name); * } * ComboBoxAddEditEmployess.ItemsSource = Strings;*/ using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { ComboBoxAddEditEmployess.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext); ComboBoxAddEditEmployess.Text = "{Binging Name}"; } }
private void Button_Click(object sender, RoutedEventArgs e) { using (WFAEntity.API.MyDBContext MyDBContext = new WFAEntity.API.MyDBContext()) { var tmp = ( from tmpEmployees in MyDBContext.Employees.ToList <Employees>() where tmpEmployees.Login.CompareTo(Log.Text) == 0 && tmpEmployees.Password.CompareTo(Pas.Text) == 0 select tmpEmployees ).ToList(); if (tmp.Count > 0) { if (tmp[0].Login == "Администратор") { Forms.SheduleWindow g = new Forms.SheduleWindow(new MainWindow()); if (g.ShowDialog() == true) { this.ShowAll(); } } else if (tmp[0].Login == "Кассир") { SkatesWindow g = new SkatesWindow(new MainWindow()); if (g.ShowDialog() == true) { this.ShowAll(); } } else if (tmp[0].Login == "Посетитель") { MainWindow g = new MainWindow(); if (g.ShowDialog() == true) { this.ShowAll(); } } } else { MessageBox.Show("Ошибочка"); } } }
public void ShowAll() { try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { ClientGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetClients(objectMyDBContext); EmployeesGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext); SkatesGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithTicket(objectMyDBContext); SheduleGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithSchedule(objectMyDBContext); TicketsGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetClientWithTicket(objectMyDBContext); ServiceGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithServices(objectMyDBContext); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Клиент", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void deleteTicketButton_Click(object sender, RoutedEventArgs e) { // var itm = (Ticket)TicketsGrid.SelectedItem; // var tmp = ( //from tmpTicket in MyDBContext.DBContext.Ticket.ToList<Ticket>() //where tmpTicket.ID_Ticket == itm.ID_Ticket //select tmpTicket // ).ToList(); // MyDBContext.DBContext.Ticket.Remove(tmp[0]); // MyDBContext.DBContext.SaveChanges(); // ShowAll(); if (TicketsGrid.SelectedItems.Count > 0) { for (int i = 0; i < TicketsGrid.SelectedItems.Count; i++) { WFAEntity.API.Ticket objectSkatesTicket = TicketsGrid.SelectedItems[i] as WFAEntity.API.Ticket; //if (objectSkates != null) try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { //WFAEntity.API.Ticket Skates = WFAEntity.API.DatabaseRequest.GetSkatesById(objectMyDBContext, objectSkates.ID_skates_hire); //objectMyDBContext.Skates_hire.Attach(Skates); //objectMyDBContext.Skates_hire.Remove(Skates); objectMyDBContext.SaveChanges(); } //this.ShowAll(SELECTED_TAB.STUDENT); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditTicket_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditCost.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Ticket objectTicket = new WFAEntity.API.Ticket( textBlockAddEditCost.Text, textBlockAddEditAmount.Text, textBlockAddEditStatus.Text, (WFAEntity.API.Client)ComboBoxAddEditClient.SelectedItem, (WFAEntity.API.MK_schedule)ComboBoxAddEditShedule.SelectedItem, (WFAEntity.API.Other_services)ComboBoxAddEditServices.SelectedItem, (WFAEntity.API.Skates_hire)ComboBoxAddEditSkates.SelectedItem ); try { objectMyDBContext.Ticket.Add(objectTicket); objectMyDBContext.SaveChanges(); MessageBox.Show("Билет добавлен"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Employees objectTicket = new WFAEntity.API.Employees(); EditTicket.Cost = textBlockAddEditCost.Text; EditTicket.Amount = textBlockAddEditAmount.Text; EditTicket.Status = textBlockAddEditStatus.Text; try { objectMyDBContext.Ticket.AddOrUpdate(EditTicket); objectMyDBContext.SaveChanges(); MessageBox.Show("Билет Редактирован"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditSkates_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditSize.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Skates_hire objectSkates = new WFAEntity.API.Skates_hire( textBlockAddEditSize.Text, textBlockAddEditTime.Text, textBlockAddEditCount.Text, textBlockAddEditType.Text, (WFAEntity.API.Employees)ComboBoxAddEditEmployess.SelectedItem ); try { objectMyDBContext.Skates_hire.Add(objectSkates); objectMyDBContext.SaveChanges(); MessageBox.Show("Коньки добавлены"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Skates_hire objectSkates = new WFAEntity.API.Skates_hire( textBlockAddEditSize.Text, textBlockAddEditTime.Text, textBlockAddEditType.Text, textBlockAddEditCount.Text, (WFAEntity.API.Employees)ComboBoxAddEditEmployess.SelectedItem ); try { objectMyDBContext.Skates_hire.AddOrUpdate(EditSkates); objectMyDBContext.SaveChanges(); MessageBox.Show("Клиент Редактирован"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditShedule_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditDate.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.MK_schedule objectShedule = new WFAEntity.API.MK_schedule( textBlockAddEditDate.Text, textBlockAddEditPrice.Text, textBlockAddEditStart.Text, textBlockAddEditEnd.Text, (WFAEntity.API.Employees)ComboBoxAddEditEmployees.SelectedItem, (WFAEntity.API.Other_services)ComboBoxAddEditServices.SelectedItem ); try { objectMyDBContext.MK_schedule.Add(objectShedule); objectMyDBContext.SaveChanges(); MessageBox.Show("Расписание добавлено"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.MK_schedule objectShedule = new WFAEntity.API.MK_schedule(); objectShedule.Date = textBlockAddEditDate.Text; objectShedule.Price = textBlockAddEditPrice.Text; objectShedule.Start_time = textBlockAddEditStart.Text; objectShedule.End_time = textBlockAddEditEnd.Text; try { objectMyDBContext.MK_schedule.AddOrUpdate(EditShedule); objectMyDBContext.SaveChanges(); MessageBox.Show("Расписание Редактировано"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditEmployees_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditSurname.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Employees objectEmployees = new WFAEntity.API.Employees(); objectEmployees.ID_employees = objectMyDBContext.Employees.Count(); objectEmployees.ID_employees++; objectEmployees.Surname = textBlockAddEditSurname.Text; objectEmployees.Name = textBlockAddEditName.Text; objectEmployees.Patronymic = textBlockAddEditPatronymic.Text; objectEmployees.Address = textBlockAddEditAddress.Text; objectEmployees.Telephone = textBlockAddEditTelephone.Text; objectEmployees.Position = textBlockAddEditPosition.Text; objectEmployees.Date = textBlockAddEditDate.Text; objectEmployees.Password = textBlockAddEditPassword.Text; objectEmployees.Login = textBlockAddEditLogin.Text; try { objectMyDBContext.Employees.Add(objectEmployees); objectMyDBContext.SaveChanges(); MessageBox.Show("Сотрудник добавлен"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Employees objectEmployees = new WFAEntity.API.Employees(); EditEmployees.Surname = textBlockAddEditSurname.Text; EditEmployees.Name = textBlockAddEditName.Text; EditEmployees.Patronymic = textBlockAddEditPatronymic.Text; EditEmployees.Address = textBlockAddEditAddress.Text; EditEmployees.Telephone = textBlockAddEditTelephone.Text; EditEmployees.Position = textBlockAddEditPosition.Text; EditEmployees.Date = textBlockAddEditDate.Text; EditEmployees.Login = textBlockAddEditLogin.Text; EditEmployees.Password = textBlockAddEditPassword.Text; try { objectMyDBContext.Employees.AddOrUpdate(EditEmployees); objectMyDBContext.SaveChanges(); MessageBox.Show("Клиент Редактирован"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditGroup_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditSurname.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Client objectClient = new WFAEntity.API.Client(); objectClient.Surname = textBlockAddEditSurname.Text; objectClient.Name = textBlockAddEditName.Text; objectClient.Patronymic = textBlockAddEditPatronymic.Text; objectClient.Address = textBlockAddEditAdress.Text; objectClient.Number = textBlockAddEditTelephone.Text; try { objectMyDBContext.Client.Add(objectClient); objectMyDBContext.SaveChanges(); MessageBox.Show("Клиент добавлен"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Client objectClient = new WFAEntity.API.Client(); EditClient.Surname = textBlockAddEditSurname.Text; EditClient.Name = textBlockAddEditName.Text; EditClient.Patronymic = textBlockAddEditPatronymic.Text; EditClient.Address = textBlockAddEditAdress.Text; EditClient.Number = textBlockAddEditTelephone.Text; try { objectMyDBContext.Client.AddOrUpdate(EditClient); objectMyDBContext.SaveChanges(); MessageBox.Show("Клиент Редактирован"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }