示例#1
0
        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();

        }