private void ImportExcelWorkerDoWork(object sender, DoWorkEventArgs e)
{
// run all background tasks here
try
{
foreach (var name in fileNames)
{
var schedule = ExcelParser.GetScheduleFromExcel(name);
foreach (KeyValuePair <ScheduleRecordDto, List <int> > entry in schedule)
{
bool isAdded = ScheduleRecordDao.AddIfNotExists(entry.Key);
if (!isAdded)
{
continue;
}
foreach (var weekNumber in entry.Value)
{
//TSR
if (weekNumber == 8)
{
continue;
}
WeekScheduleDao.AddWeekSchedule(weekNumber: weekNumber, scheduleRecordId: entry.Key.Id);
}
}
}
}
catch (InvalidInputException ex)
{
ShowPopup(ex.Message);
}
}
