Exemplo n.º 1
0
 private void ShowAll()
 {
     {
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 // VolunteerGrid.ItemsSource = WpfApplicationEntity.API.DatabaseRequest.GetNeedys(objectMyDBContext);
                 needysGrid.ItemsSource      = WpfApplicationEntity.API.DatabaseRequest.GetNeedys(objectMyDBContext);
                 ActionGrid.ItemsSource      = WpfApplicationEntity.API.DatabaseRequest.GetActions(objectMyDBContext);
                 VolunteerGrid.ItemsSource   = WpfApplicationEntity.API.DatabaseRequest.GetVolunteers(objectMyDBContext);
                 serviceGrid.ItemsSource     = WpfApplicationEntity.API.DatabaseRequest.GetServices(objectMyDBContext);
                 typeactionGrid.ItemsSource  = WpfApplicationEntity.API.DatabaseRequest.GetType_Actions(objectMyDBContext);
                 typeServiceGrid.ItemsSource = WpfApplicationEntity.API.DatabaseRequest.GetType_Services(objectMyDBContext);
                 registrationforavolunteerGrid.ItemsSource = WpfApplicationEntity.API.DatabaseRequest.GetRegistration_for_a_volunteers(objectMyDBContext);
                 registrationforaneedsGrid.ItemsSource     = WpfApplicationEntity.API.DatabaseRequest.GetRegistration_for_a_needss(objectMyDBContext);
                 actionfortheneedyGrid.ItemsSource         = WpfApplicationEntity.API.DatabaseRequest.GetAction_for_the_needys(objectMyDBContext);
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 2
0
 private void ReportServiceButton_Click(object sender, RoutedEventArgs e)
 {
     {
         Excel._Application exApp = new Excel.Application();
         exApp.Workbooks.Add();
         Worksheet workSheet = (Worksheet)exApp.ActiveSheet;
         workSheet.Cells[1].EntireRow.Font.Bold         = true;
         workSheet.Cells.EntireRow.Font.Size            = 14;
         workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
         workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 1] = "Название";
         workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 2] = "Затраченное время";
         workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 3] = "Тип услуги";
         workSheet.Cells[1, 4].EntireColumn.ColumnWidth = 25;
         workSheet.Cells[1, 4].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 4] = "Регистрация нуждающегося";
         workSheet.Cells[1, 5].EntireColumn.ColumnWidth = 15;
         workSheet.Cells[1, 5].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 5] = "Регистрация волонтера";
         int i = 2;
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 List <WpfApplicationEntity.API.Service> actions = WpfApplicationEntity.API.DatabaseRequest.GetServices(objectMyDBContext).ToList();
                 foreach (WpfApplicationEntity.API.Service action in actions)
                 {
                     workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 1] = action.Name;
                     workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 2] = action.SpendingTime;
                     workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 3] = action.Type_Service.Name;
                     workSheet.Cells[i, 4].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 4] = action.Registration_for_a_needs.ActualDate;
                     workSheet.Cells[i, 5].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 5] = action.Registration_for_a_volunteer.Date;
                     i++;
                 }
                 string pathToXlsFile = Environment.CurrentDirectory +
                                        "\\Услуги.xls";
                 workSheet.SaveAs(pathToXlsFile);
                 exApp.Quit();
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 3
0
 private void ReportRegistrationForANeedsButton_Click(object sender, RoutedEventArgs e)
 {
     {
         Excel._Application exApp = new Excel.Application();
         exApp.Workbooks.Add();
         Worksheet workSheet = (Worksheet)exApp.ActiveSheet;
         workSheet.Cells[1].EntireRow.Font.Bold         = true;
         workSheet.Cells.EntireRow.Font.Size            = 14;
         workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
         workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 1] = "Планируемая дата";
         workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 2] = "Дата подачи";
         workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 3] = "Фактическая дата";
         workSheet.Cells[1, 4].EntireColumn.ColumnWidth = 25;
         workSheet.Cells[1, 4].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 4] = "Запись волонтера";
         int i = 2;
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 List <WpfApplicationEntity.API.Registration_for_a_needs> actions = WpfApplicationEntity.API.DatabaseRequest.GetRegistration_for_a_needss(objectMyDBContext).ToList();
                 foreach (WpfApplicationEntity.API.Registration_for_a_needs action in actions)
                 {
                     workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 1] = action.PlannedDate;
                     workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 2] = action.ApplicationDate;
                     workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 3] = action.ActualDate;
                     workSheet.Cells[i, 4].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 4] = action.Registration_for_a_volunteer.Date;
                     i++;
                 }
                 string pathToXlsFile = Environment.CurrentDirectory +
                                        "\\Регистрация_нуждающегося.xls";
                 workSheet.SaveAs(pathToXlsFile);
                 exApp.Quit();
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 4
0
 private void Window_Loaded(object sender, RoutedEventArgs e)
 {
     try
     {
         using (WpfApplicationEntity.API.MyDBContext objectMyDBContext = new WpfApplicationEntity.API.MyDBContext())
         {
             if (objectMyDBContext.Database.Exists() == false)
             {
                 objectMyDBContext.Database.Create();
             }
         }
     }
     catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка"); }
     this.ShowAll();
 }
Exemplo n.º 5
0
 private void ReportTypeActionButton_Click(object sender, RoutedEventArgs e)
 {
     {
         Excel._Application exApp = new Excel.Application();
         exApp.Workbooks.Add();
         Worksheet workSheet = (Worksheet)exApp.ActiveSheet;
         workSheet.Cells[1].EntireRow.Font.Bold         = true;
         workSheet.Cells.EntireRow.Font.Size            = 14;
         workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
         workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 1] = "Название";
         workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 2] = "Описание";
         workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 3] = "Длительность";
         int i = 2;
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 List <WpfApplicationEntity.API.Type_Action> actions = WpfApplicationEntity.API.DatabaseRequest.GetType_Actions(objectMyDBContext).ToList();
                 foreach (WpfApplicationEntity.API.Type_Action action in actions)
                 {
                     workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 1] = action.Name;
                     workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 2] = action.Discription;
                     workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 3] = action.Duration;
                     i++;
                 }
                 string pathToXlsFile = Environment.CurrentDirectory +
                                        "\\Типы_акций.xls";
                 workSheet.SaveAs(pathToXlsFile);
                 exApp.Quit();
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 6
0
 private void searchNeedy_TextChanged(object sender, TextChangedEventArgs e)
 {
     using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                new WpfApplicationEntity.API.MyDBContext())
     {
         List <Needy> searching = WpfApplicationEntity.API.DatabaseRequest.GetNeedys(objectMyDBContext).ToList();
         List <Needy> needys    = new List <Needy>();
         foreach (var item in searching)
         {
             if (item.MiddleName.IndexOf(searchNeedy.Text) != -1)
             {
                 needys.Add(item);
             }
         }
         needysGrid.ItemsSource = needys;
     }
 }
Exemplo n.º 7
0
 private void searchVolunteer_TextChanged(object sender, TextChangedEventArgs e)
 {
     using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                new WpfApplicationEntity.API.MyDBContext())
     {
         List <Volunteer> searching  = WpfApplicationEntity.API.DatabaseRequest.GetVolunteers(objectMyDBContext).ToList();
         List <Volunteer> volunteers = new List <Volunteer>();
         foreach (var item in searching)
         {
             if (item.MiddleName.IndexOf(searchVolunteer.Text) != -1)
             {
                 volunteers.Add(item);
             }
         }
         VolunteerGrid.ItemsSource = volunteers;
     }
 }
Exemplo n.º 8
0
 private void ReportNeedyButton_Click(object sender, RoutedEventArgs e)
 {
     {
         Excel._Application exApp = new Excel.Application();
         exApp.Workbooks.Add();
         Worksheet workSheet = (Worksheet)exApp.ActiveSheet;
         workSheet.Cells[1].EntireRow.Font.Bold         = true;
         workSheet.Cells.EntireRow.Font.Size            = 14;
         workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
         workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 1] = "Фамилия";
         workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 2] = "Имя";
         workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 3] = "Отчество";
         workSheet.Cells[1, 4].EntireColumn.ColumnWidth = 25;
         workSheet.Cells[1, 4].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 4] = "Адрес";
         workSheet.Cells[1, 5].EntireColumn.ColumnWidth = 15;
         workSheet.Cells[1, 5].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 5] = "Инвалидность";
         workSheet.Cells[1, 6].EntireColumn.ColumnWidth = 15;
         workSheet.Cells[1, 6].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 6] = "Номер телефона";
         workSheet.Cells[1, 7].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 7].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 7] = "Пол";
         workSheet.Cells[1, 8].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 8].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 8] = "Регистрация нуждающегося";
         workSheet.Cells[1, 9].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 9].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 9] = "Акция нуждающегося";
         int i = 2;
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 List <WpfApplicationEntity.API.Needy> actions = WpfApplicationEntity.API.DatabaseRequest.GetNeedys(objectMyDBContext).ToList();
                 foreach (WpfApplicationEntity.API.Needy action in actions)
                 {
                     workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 1] = action.MiddleName;
                     workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 2] = action.SurName;
                     workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 3] = action.LastName;
                     workSheet.Cells[i, 4].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 4] = action.Addres;
                     workSheet.Cells[i, 5].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 5] = action.Disability;
                     workSheet.Cells[i, 6].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 6] = action.PhoneNumber;
                     workSheet.Cells[i, 7].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 7] = action.Genus;
                     workSheet.Cells[i, 8].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 8] = action.Registration_for_a_needs.ActualDate;
                     workSheet.Cells[i, 9].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 9] = action.Action_for_the_needy.Name;
                     i++;
                 }
                 string pathToXlsFile = Environment.CurrentDirectory +
                                        "\\Нуждающиеся.xls";
                 workSheet.SaveAs(pathToXlsFile);
                 exApp.Quit();
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 9
0
 private void ReportActionButton_Click(object sender, RoutedEventArgs e)
 {
     {
         Excel._Application exApp = new Excel.Application();
         exApp.Workbooks.Add();
         Worksheet workSheet = (Worksheet)exApp.ActiveSheet;
         workSheet.Cells[1].EntireRow.Font.Bold         = true;
         workSheet.Cells.EntireRow.Font.Size            = 14;
         workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
         workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 1] = "Время начала";
         workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 2] = "Время конца";
         workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 3] = "Дата проведения";
         workSheet.Cells[1, 4].EntireColumn.ColumnWidth = 25;
         workSheet.Cells[1, 4].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 4] = "Количество волонтёров";
         workSheet.Cells[1, 5].EntireColumn.ColumnWidth = 15;
         workSheet.Cells[1, 5].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 5] = "Количество нуждающихся";
         workSheet.Cells[1, 6].EntireColumn.ColumnWidth = 15;
         workSheet.Cells[1, 6].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 6] = "Акция для нуждающегося";
         workSheet.Cells[1, 7].EntireColumn.ColumnWidth = 20;
         workSheet.Cells[1, 7].Interior.ColorIndex      = 17;
         workSheet.Cells[1, 7] = "Тип акции";
         int i = 2;
         try
         {
             using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                        new WpfApplicationEntity.API.MyDBContext())
             {
                 List <WpfApplicationEntity.API.Action> actions = WpfApplicationEntity.API.DatabaseRequest.GetActions(objectMyDBContext).ToList();
                 foreach (WpfApplicationEntity.API.Action action in actions)
                 {
                     workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 1] = action.StarTime;
                     workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 2] = action.EndTime;
                     workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 3] = action.TheDateOfThe;
                     workSheet.Cells[i, 4].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 4] = action.NumberOfVolonteers;
                     workSheet.Cells[i, 5].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 5] = action.NumberOfNeeds;
                     workSheet.Cells[i, 6].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 6] = action.Action_for_the_needy.Name;
                     workSheet.Cells[i, 7].Interior.ColorIndex = 24;
                     workSheet.Cells[i, 7] = action.Type_Action.Name;
                     i++;
                 }
                 string pathToXlsFile = Environment.CurrentDirectory +
                                        "\\Акции.xls";
                 workSheet.SaveAs(pathToXlsFile);
                 exApp.Quit();
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
         }
     }
 }
Exemplo n.º 10
0
        private void ReportEmployeeButton_Click(object sender, RoutedEventArgs e)
        {
            Excel._Application exApp = new Excel.Application();
            exApp.Workbooks.Add();
            Worksheet workSheet = (Worksheet)exApp.ActiveSheet;

            workSheet.Cells[1].EntireRow.Font.Bold         = true;
            workSheet.Cells.EntireRow.Font.Size            = 14;
            workSheet.Cells.EntireRow.Font.Name            = "TimesNewRoman";
            workSheet.Cells[1, 1].EntireColumn.ColumnWidth = 20;
            workSheet.Cells[1, 1].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 1] = "Адрес";
            workSheet.Cells[1, 2].EntireColumn.ColumnWidth = 20;
            workSheet.Cells[1, 2].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 2] = "Дата рождения";
            workSheet.Cells[1, 3].EntireColumn.ColumnWidth = 20;
            workSheet.Cells[1, 3].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 3] = "Имя";
            workSheet.Cells[1, 4].EntireColumn.ColumnWidth = 25;
            workSheet.Cells[1, 4].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 4] = "Фамилия";
            workSheet.Cells[1, 5].EntireColumn.ColumnWidth = 15;
            workSheet.Cells[1, 5].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 5] = "Отчество";
            workSheet.Cells[1, 6].EntireColumn.ColumnWidth = 15;
            workSheet.Cells[1, 6].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 6] = "Логин";
            workSheet.Cells[1, 7].EntireColumn.ColumnWidth = 20;
            workSheet.Cells[1, 7].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 7] = "Пароль";
            workSheet.Cells[1, 8].EntireColumn.ColumnWidth = 20;
            workSheet.Cells[1, 8].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 8] = "Номер телефона";
            workSheet.Cells[1, 9].EntireColumn.ColumnWidth = 15;
            workSheet.Cells[1, 9].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 9] = "Пол";
            workSheet.Cells[1, 10].EntireColumn.ColumnWidth = 28;
            workSheet.Cells[1, 10].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 10] = "Акция для нуждающегося";
            workSheet.Cells[1, 11].EntireColumn.ColumnWidth = 5;
            workSheet.Cells[1, 11].Interior.ColorIndex      = 17;
            workSheet.Cells[1, 11] = "Регистрация для волонтёра";
            int i = 2;

            try
            {
                using (WpfApplicationEntity.API.MyDBContext objectMyDBContext =
                           new WpfApplicationEntity.API.MyDBContext())
                {
                    List <Volunteer> volunteers = DatabaseRequest.GetVolunteers(objectMyDBContext).ToList();
                    foreach (Volunteer volunteer in volunteers)
                    {
                        workSheet.Cells[i, 1].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 1] = volunteer.Addres;
                        workSheet.Cells[i, 2].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 2] = volunteer.DateOfBirth;
                        workSheet.Cells[i, 3].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 3] = volunteer.MiddleName;
                        workSheet.Cells[i, 4].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 4] = volunteer.SurName;
                        workSheet.Cells[i, 5].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 5] = volunteer.LastName;
                        workSheet.Cells[i, 6].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 6] = volunteer.Login;
                        workSheet.Cells[i, 7].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 7] = volunteer.Password;
                        workSheet.Cells[i, 8].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 8] = volunteer.PhoneNumber;
                        workSheet.Cells[i, 9].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 9] = volunteer.Genus;
                        workSheet.Cells[i, 10].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 10] = volunteer.Action_for_the_needy.Name;         //
                        workSheet.Cells[i, 11].Interior.ColorIndex = 24;
                        workSheet.Cells[i, 11] = volunteer.Registration_for_a_volunteer.Date; //
                        i++;
                    }
                    string pathToXlsFile = Environment.CurrentDirectory +
                                           "\\Волонтёры.xls";
                    workSheet.SaveAs(pathToXlsFile);
                    exApp.Quit();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }