private PayCodeModel[] GetDefinedPayCodesFromFile(string contentRootPath, ILogger <DbInitializer> logger) { string paycodeFilePath = Path.Combine(contentRootPath, "Setup", "Paycode_Incentives.xlsx"); BlockingCollection <PayCodeModel> payCodeList = new BlockingCollection <PayCodeModel>(); try { FileStream stream = File.Open(paycodeFilePath, FileMode.Open, FileAccess.Read); using (var package = new ExcelPackage(stream)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; var rowCount = worksheet.Dimension.Rows; Parallel.For(2, rowCount, row => { var paycode = new PayCodeModel { PayCode = worksheet.Cells[row, 1].Value.ToString().Trim(), PayCodeDescription = worksheet.Cells[row, 2].Value.ToString().Trim(), IsActive = true }; payCodeList.Add(paycode); }); } return(payCodeList.ToArray()); } catch (Exception ex) { logger.LogError($"An error occured while seeding the paycode - {ex}"); return(payCodeList.ToArray()); } }
private PayCodeViewModel PopulatePayCodeViewModel(PayCodeModel model) { return(new PayCodeViewModel() { Id = model.Id, PayCode = model.PayCode, PayCodeDescription = model.PayCodeDescription, IsActive = model.IsActive }); }