private static void AddingWorkers(BusinessContext bc)
        {
            var doc        = XDocument.Load(PATH_TABEL_WORKERS);
            var worksheets = doc.Root.Elements("{urn:schemas-microsoft-com:office:spreadsheet}Worksheet").ToList();

            var lastDate = DateTime.MinValue;

            foreach (var worksheet in worksheets.Where(w => w.Attribute("{urn:schemas-microsoft-com:office:spreadsheet}Name").Value != "Шаблон"))
            {
                string[] date = worksheet.Attribute("{urn:schemas-microsoft-com:office:spreadsheet}Name").Value.Split('.');

                int month = int.Parse(date[0]);
                int year  = int.Parse("20" + date[1]);

                //if (year != 2013 || year == 2013 && month != 11)
                //{
                //    continue;
                //}
                //if (year != 2014)
                //{
                //    continue;
                //}
                Debug.WriteLine(year + " " + month);

                var workers = new List <DirectoryWorker>();

                var rows = worksheet.Elements("{urn:schemas-microsoft-com:office:spreadsheet}Table").Elements("{urn:schemas-microsoft-com:office:spreadsheet}Row").ToList();
                for (int row = 3; row < rows.Count; row += 2)
                {
                    var cellRegularDays  = worksheet.Element("{urn:schemas-microsoft-com:office:spreadsheet}Table").Elements("{urn:schemas-microsoft-com:office:spreadsheet}Row").ToList()[row].Elements("{urn:schemas-microsoft-com:office:spreadsheet}Cell").ToList();
                    var cellOverTimeDays = worksheet.Element("{urn:schemas-microsoft-com:office:spreadsheet}Table").Elements("{urn:schemas-microsoft-com:office:spreadsheet}Row").ToList()[row + 1].Elements("{urn:schemas-microsoft-com:office:spreadsheet}Cell").ToList();

                    string[] workerFio = cellRegularDays[1].Value.Split(' ');

                    string lastName  = workerFio[0].Trim();
                    string firstName = workerFio[1].Trim();
                    string midName   = "";

                    if (workerFio.Count() == 3)
                    {
                        midName = workerFio[2].Trim();
                    }

                    int indexPostName = 0;

                    string postName = "";
                    for (int i = 0; i < cellOverTimeDays.Count; i++)
                    {
                        postName = cellOverTimeDays[i].Value.ToLower();

                        switch (postName)
                        {
                        case "заведующий складом":
                        case "зав. складом":
                            postName = "ЗавСкладом";
                            break;

                        case "зам. зав. складом":
                            postName = "ЗамЗавСкладом";
                            break;

                        case "карщик-кладовщик":
                            postName = "КарщикКладовщик";
                            break;

                        case "оклейщица":
                            postName = "Оклейщик";
                            break;

                        case "бригадир-оклейщик":
                            postName = "БригадирОклейщик";
                            break;
                        }

                        if (postName != "")
                        {
                            postName = postName[0].ToString().ToUpper() + postName.Substring(1);
                            if (bc.ExistsDirectoryPost(postName))
                            {
                                indexPostName = i;
                                break;
                            }
                        }
                    }

                    Debug.WriteLine(lastName + " " + firstName + " " + midName + " : " + postName);

                    var worker = bc.GetDirectoryWorker(lastName, firstName);

                    int day = 0;
                    if (worker == null)
                    {
                        day = 1;

                        if (cellRegularDays[3].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data") == null || cellRegularDays[3].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value == "" || cellRegularDays[3].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value == "0")
                        {
                            for (int i = 4; i < cellRegularDays.Count; i++)
                            {
                                if (cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data") != null &&
                                    (cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value != "" &&
                                     cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value != "0"))
                                {
                                    day = i - 2;
                                    break;
                                }

                                if (cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data") == null ||
                                    cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value == "")
                                {
                                    bool isBreak = false;
                                    for (int j = i + 1; j < cellRegularDays.Count; j++)
                                    {
                                        if (cellRegularDays[j].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data") != null && (
                                                cellRegularDays[j].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value != "" &&
                                                cellRegularDays[j].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value != "0"))
                                        {
                                            day     = j - 2;
                                            isBreak = true;
                                            break;
                                        }
                                    }

                                    if (isBreak)
                                    {
                                        break;
                                    }
                                }
                            }
                        }

                        var currentPost = new CurrentPost
                        {
                            ChangeDate    = new DateTime(year, month, day),
                            DirectoryPost = bc.GetDirectoryPost(postName),
                        };

                        worker = bc.AddDirectoryWorker(lastName, firstName, midName, Gender.Male, DateTime.Now, "1", "1", "1", new DateTime(year, month, day), null, currentPost);

                        day--;
                    }

                    var infoMonth = new InfoMonth
                    {
                        Date      = new DateTime(year, month, 1),
                        BirthDays = 500
                    };

                    worker.InfoMonthes.Add(infoMonth);

                    int  overTimeCounter = 0;
                    bool isIndexOverTime = false;

                    int countDaysInMonth = DateTime.DaysInMonth(year, month);
                    for (int i = 3 + day; i < countDaysInMonth + 3; i++)
                    {
                        var workerDate = new DateTime(year, month, day + 1);

                        if (worker.FireDate != null)
                        {
                            break;
                        }

                        var infoDate = new InfoDate
                        {
                            Date           = workerDate,
                            DescriptionDay = DescriptionDay.Был
                        };

                        if (cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data") != null)
                        {
                            string value = cellRegularDays[i].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value;

                            if (value != "")
                            {
                                double result;
                                if (double.TryParse(value, out result))
                                {
                                    infoDate.CountHours = result;
                                }

                                if (!isIndexOverTime)
                                {
                                    if (cellOverTimeDays[i + indexPostName - 1 - overTimeCounter].Attribute("{urn:schemas-microsoft-com:office:spreadsheet}Index") != null)
                                    {
                                        overTimeCounter++;
                                        isIndexOverTime = true;
                                    }
                                }
                                else
                                {
                                    isIndexOverTime = false;
                                }

                                if (!isIndexOverTime && cellOverTimeDays[i + indexPostName - 1 - overTimeCounter].Value != "")
                                {
                                    if (double.TryParse(cellOverTimeDays[i + indexPostName - 1 - overTimeCounter].Element("{urn:schemas-microsoft-com:office:spreadsheet}Data").Value.Replace(".", ","), out result))
                                    {
                                        infoDate.CountHours += result;
                                    }
                                }



                                if (infoDate.CountHours == 0)
                                {
                                    if (!bc.IsWeekend(workerDate))
                                    {
                                        infoDate.DescriptionDay = DescriptionDay.С;
                                    }

                                    infoDate.CountHours = null;
                                }

                                worker.InfoDates.Add(infoDate);
                            }
                        }
                        else
                        {
                            if (!bc.IsWeekend(workerDate))
                            {
                                infoDate.DescriptionDay = DescriptionDay.С;
                            }

                            infoDate.CountHours = null;
                        }


                        var workerFire = _workersFire.FirstOrDefault(w => w.FirstName == worker.FirstName && w.LastName == worker.LastName);

                        if (workerFire != null)
                        {
                            if (workerDate.Date == workerFire.FireDate.Date)
                            {
                                worker.FireDate = workerFire.FireDate;
                                _workersFire.Remove(workerFire);
                            }
                        }

                        day++;

                        if (lastDate.Date < workerDate.Date)
                        {
                            lastDate = workerDate;
                        }
                    }

                    string   fio     = "";
                    string[] fioMass = null;

                    do
                    {
                        if (rows.Count() <= row + 2)
                        {
                            break;
                        }

                        var cells3 = worksheet.Element("{urn:schemas-microsoft-com:office:spreadsheet}Table").Elements("{urn:schemas-microsoft-com:office:spreadsheet}Row").ToList()[row + 2].Elements("{urn:schemas-microsoft-com:office:spreadsheet}Cell").ToList();
                        if (cells3.Count() > 1)
                        {
                            fio     = cells3[1].Value;
                            fioMass = fio.Split(' ');
                        }
                        else
                        {
                            fio     = "";
                            fioMass = null;
                        }

                        if (fio == "" || bc.ExistsDirectoryPost(fio) || fioMass == null || fioMass.Count() < 2)
                        {
                            row++;
                        }
                    } while (fio == "" || bc.ExistsDirectoryPost(fio) || fioMass == null || fioMass.Count() < 2);

                    workers.Add(worker);
                }


                bc.SaveChanges();
            }

            bc.EditParameter(ParameterType.LastDate, lastDate.ToString());
        }