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