public void UpdateWONumbersWithEPPlus(IFormFile file)
{
DataTable tblContent = GenerateDataTableFromExcel(file);
List <WordOrderNumbers> workOrderNumbers = new List <WordOrderNumbers>();
foreach (DataRow tblRow in tblContent.Rows)
{
WordOrderNumbers workOrderNumber = new WordOrderNumbers()
{
WorkOrderNumber = tblRow["Work Order Number"].ToString(),
SerialNumber = tblRow["Serial Number (Primary Incident Asset Serial Number) (Asset)"].ToString()
};
workOrderNumbers.Add(workOrderNumber);
}
this._context.WordOrderNumber.AddRange(workOrderNumbers);
this._context.SaveChanges();
}
/// <summary>
/// This method use npoi package to save the file
/// </summary>
/// <param name="file"></param>
public void UpdateWONumbers(IFormFile file)
{
var stream = file.OpenReadStream();
XSSFWorkbook workBook = new XSSFWorkbook(stream);
var excelSheet = workBook.GetSheetAt(0);
List <WordOrderNumbers> workOrderNumbers = new List <WordOrderNumbers>();
for (int i = 0; i < excelSheet.LastRowNum; i++)
{
WordOrderNumbers workOrderNumber = new WordOrderNumbers()
{
WorkOrderNumber = excelSheet.GetRow(i).GetCell(0).ToString(),
SerialNumber = excelSheet.GetRow(i).GetCell(1).ToString()
};
workOrderNumbers.Add(workOrderNumber);
}
this._context.WordOrderNumber.AddRange(workOrderNumbers);
this._context.SaveChanges();
}
