public async Task <ActionResult> Import([FromForm] IFormFile file2)
{
IFormFile file = Request.Form.Files["UploadedFile"];
object createdBy = Request.Form["CreatedBy"];
var datasList = new List <IngredientForImportExcelDto>();
//var datasList2 = new List<UploadDataVM2>();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
if ((file != null) && (file.Length > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
int userid = createdBy.ToInt();
using (var package = new ExcelPackage(file.OpenReadStream()))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
datasList.Add(new IngredientForImportExcelDto()
{
Name = workSheet.Cells[rowIterator, 1].Value.ToSafetyString(),
SupplierID = workSheet.Cells[rowIterator, 2].Value.ToInt(),
});
}
}
datasList.ForEach(item =>
{
var generator = new RandomGenerator();
var code = generator.RandomStringNumber(8);
if (datasList.Any(x => x.Code == code))
{
code = generator.RandomStringNumber(8);
}
item.Code = code;
item.CreatedDate = DateTime.Now;
item.CreatedBy = userid;
});
return(Ok(await _ingredientService.AddRangeAsync(datasList)));
}
else
{
return(StatusCode(500));
}
}
