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