private void ReadEmployees()
{
FileInfo fileInfo = new FileInfo(ShiftPath);
ExcelWorksheet worksheet;
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
try
{
if (fileInfo.Exists)
{
worksheet = package.Workbook.Worksheets[CurrentDate.DayOfWeekIndex()];
int from = 5 + 1;
int to = 5 + (24 * 2);
for (int i = 3; i <= worksheet.Dimension.End.Row; i++)
{
int row = -1;
if (!int.TryParse(worksheet.Cells[i, 1].Text, out row))
{
continue;
}
var number = worksheet.Cells[i, 3].Text;
var shifts = CreateShifts(worksheet.Cells[i, from, i, to]);
var employee = new Employee
{
Number = number,
Shifts = shifts
};
Employees.Add(employee);
}
}
}
catch (Exception e)
{
throw new Exception("Error in reading shift File\n" + e.Message);
}
}
}
