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