private void saveServiceOnAbonementButton_Click(object sender, RoutedEventArgs e) { if (serviceTypeComboBox.SelectedIndex == 0) { if (AddDefend.AddServicePositionDefendGroup((string)serviceTypeComboBox.SelectedValue, (string)serviceTitleComboBox.SelectedValue, roomNumTextBox.Text) == true) { try { using (var Db = new DatabaseContext()) { ServicePosition serviceposition = new ServicePosition(); serviceposition.abonement_id = abonement_id_g; serviceposition.service_id = Db.GroupServicesForAbonement.FirstOrDefault(gs => gs.title == (string)serviceTitleComboBox.SelectedValue).id; int i = countTimesServiceComboBox.SelectedIndex; switch (i) { case 1: serviceposition.count = 8; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; case 2: serviceposition.count = 12; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; default: serviceposition.count = 1; // dateendDatePicker.SelectedDate = Convert.ToDateTime(dateBeginDatePicker.SelectedDate); serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; } Db.ServicePosition.Add(serviceposition); Db.SaveChanges(); additionalPaymentTextBox.Text = "0"; GroupServiceSum(); } } catch (Exception) { MessageBox.Show("Ошибка соединения с сервером!", "Ошибка соединения", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Возможно, были введены некорректные данные!", "Ошибка ввода данных", MessageBoxButton.OK, MessageBoxImage.Error); } } if (serviceTypeComboBox.SelectedIndex == 1) { if (AddDefend.AddServicePositionDefendPersonal((string)serviceTypeComboBox.SelectedValue, (string)serviceTitleComboBox.SelectedValue, (string)coachComboBox.SelectedValue) == true) { try { using (var Db = new DatabaseContext()) { ServicePosition serviceposition = new ServicePosition(); serviceposition.abonement_id = abonement_id_g; serviceposition.service_id = Db.PersonalServicesForAbonement.FirstOrDefault(ps => ps.title == (string)serviceTitleComboBox.SelectedValue).id; int i = countTimesServiceComboBox.SelectedIndex; switch (i) { case 1: serviceposition.count = 8; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; case 2: serviceposition.count = 12; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; default: serviceposition.count = 1; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; } Db.ServicePosition.Add(serviceposition); Db.SaveChanges(); PersonalServiceSum(); } } catch (Exception) { MessageBox.Show("Ошибка соединения с сервером!", "Ошибка соединения", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Возможно, были введены некорректные данные!", "Ошибка ввода данных", MessageBoxButton.OK, MessageBoxImage.Error); } } ItemsSourseToTable(); }
private void saveServiceOnAbonementButton_Click(object sender, RoutedEventArgs e) { if (serviceTypeComboBox.SelectedIndex == 0) { if(AddDefend.AddServicePositionDefendGroup((string)serviceTypeComboBox.SelectedValue, (string)serviceTitleComboBox.SelectedValue, roomNumTextBox.Text) == true) { try { using (var Db = new DatabaseContext()) { ServicePosition serviceposition = new ServicePosition(); serviceposition.abonement_id = abonement_id_g; serviceposition.service_id= Db.GroupServicesForAbonement.FirstOrDefault(gs => gs.title == (string)serviceTitleComboBox.SelectedValue).id; int i=countTimesServiceComboBox.SelectedIndex; switch (i) { case 1: serviceposition.count = 8; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; case 2: serviceposition.count = 12; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; default: serviceposition.count = 1; // dateendDatePicker.SelectedDate = Convert.ToDateTime(dateBeginDatePicker.SelectedDate); serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; } Db.ServicePosition.Add(serviceposition); Db.SaveChanges(); additionalPaymentTextBox.Text = "0"; GroupServiceSum(); } } catch (Exception) { MessageBox.Show("Ошибка соединения с сервером!", "Ошибка соединения", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Возможно, были введены некорректные данные!", "Ошибка ввода данных", MessageBoxButton.OK, MessageBoxImage.Error); } } if (serviceTypeComboBox.SelectedIndex == 1) { if(AddDefend.AddServicePositionDefendPersonal((string)serviceTypeComboBox.SelectedValue, (string)serviceTitleComboBox.SelectedValue, (string)coachComboBox.SelectedValue) == true) { try { using (var Db = new DatabaseContext()) { ServicePosition serviceposition = new ServicePosition(); serviceposition.abonement_id = abonement_id_g; serviceposition.service_id = Db.PersonalServicesForAbonement.FirstOrDefault(ps => ps.title == (string)serviceTitleComboBox.SelectedValue).id; int i = countTimesServiceComboBox.SelectedIndex; switch (i) { case 1: serviceposition.count = 8; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; case 2: serviceposition.count = 12; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; default: serviceposition.count = 1; serviceposition.date_end = Convert.ToDateTime(dateendDatePicker.SelectedDate); break; } Db.ServicePosition.Add(serviceposition); Db.SaveChanges(); PersonalServiceSum(); } } catch (Exception) { MessageBox.Show("Ошибка соединения с сервером!", "Ошибка соединения", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Возможно, были введены некорректные данные!", "Ошибка ввода данных", MessageBoxButton.OK, MessageBoxImage.Error); } } ItemsSourseToTable(); }