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