public List <Client> GetClients() { try { entities = new DataBase.EntitiesWpfDataBase(); return(entities.Client.ToList()); } catch { throw new Exception("ERROR DB"); } }
private void ButAdd_Click(object sender, RoutedEventArgs e) { DataBase.ClientService clientService = new DataBase.ClientService(); var cl = CBClient.SelectedItem as DataBase.Client; var sr = CBservice.SelectedItem as DataBase.Service; if (cl == null) { MessageBox.Show("Выыберите клиента"); return; } if (sr == null) { MessageBox.Show("Выберите услугу"); return; } DateTime date; try { date = Dtp.SelectedDate.Value; } catch { MessageBox.Show("Выберите дату"); return; } date.AddHours(Convert.ToDouble(cbHours.SelectedItem)); date.AddMinutes(Convert.ToDouble(cbMin.SelectedItem)); clientService.ClientID = cl.ID; clientService.ServiceID = sr.ID; clientService.StartTime = date; clientService.Comment = TbComment.Text; DataBase.EntitiesWpfDataBase entities = new DataBase.EntitiesWpfDataBase(); try { entities.ClientService.Add(clientService); entities.SaveChanges(); MessageBox.Show("Добавление произошло успешно"); } catch (Exception ex) { MessageBox.Show("ERROR ADD" + ex.Message); } }
public ClientService() { InitializeComponent(); try { DataBase.EntitiesWpfDataBase entities = new DataBase.EntitiesWpfDataBase(); mainDataGrid.ItemsSource = entities.ClientService.ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AddClient() { InitializeComponent(); DataBase.EntitiesWpfDataBase entities = new DataBase.EntitiesWpfDataBase(); cbGender.ItemsSource = entities.Gender.ToList(); try { clientController = new Controllers.ClientController(); mainGrid.DataContext = clientController.newClient; } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR DB"); } }
public AddClientService() { InitializeComponent(); cbHours.ItemsSource = GetHours(); cbMin.ItemsSource = GetMin(); try { DataBase.EntitiesWpfDataBase entities = new DataBase.EntitiesWpfDataBase(); CBservice.ItemsSource = entities.Service.ToList().OrderBy(x => x.Title); CBClient.ItemsSource = entities.Client.ToList().OrderBy(x => x.FirstName); } catch (Exception ex) { MessageBox.Show("ERROR DB " + ex.Message); } CBClient.SelectedIndex = 0; CBservice.SelectedIndex = 0; }