protected override Task Handle(CancellationToken cancellationToken)
{
var mfuFile = new Mfufile()
{
EnterDate = DateTime.Now,
FileName = configuration.GetValue <string>("FileName:RP147")
};
var mfuFileResult = dbContext.Add(mfuFile);
MemoryStream fileStream = new MemoryStream(Request.ImportedFile.File);
var mfumodelList = GetMfuModelList(FileHelper.ExcelExportDataTable(fileStream));
foreach (var mfumodel in mfumodelList)
{
mfumodel.FileId = mfuFileResult.Entity.FileId;
dbContext.Mfumodel.Add(mfumodel);
}
dbContext.SaveChanges();
Response.AddMessage("File Imported Successfully.", "", MessageTypes.Success, isEndUserMessage: true);
return(Response.SetSuccess().AsTask());
}
private int InsertExcelFile(ExcelFile excelFile)
{
var result = dbContext.Add(excelFile);
dbContext.SaveChanges();
mFUOperationsHelper.InsertExcelFileHistory(result.Entity, dbContext);
return(result.Entity.ExcelFileId);
}