protected override Task Handle(CancellationToken cancellationToken) { bool isExists = dbContext.ExcelFile.Where(o => o.FileName == Request.FileName).Any(); if (isExists) { return(Response.SetFailed($"This excel file \"{Request.FileName}\" is already exists", "EXIST", true).AsTask()); } else { base.Mapper.Map(Request, Entity); Entity.Body = Request.Body; Entity.FileStateId = 0; var excelFileId = InsertExcelFile(Entity); var stream = new MemoryStream(Request.Body); IList <MfuswiftInfo> mfuswiftInfoList = mFUOperationsHelper.GetMfuswiftInfoList(FileHelper.ExcelExportDataTable(stream)); mFUOperationsHelper.InsertMfuswiftInfoList(mfuswiftInfoList, excelFileId, dbContext); Response.AddMessage("New File Created Successfully.", "", MessageTypes.Success, isEndUserMessage: true); return(Response.SetSuccess().AsTask()); } }
protected override Task Handle(CancellationToken cancellationToken) { var stream = new MemoryStream(Request.Body); IList <MfuswiftInfo> mfuswiftInfoList = mFUOperationsHelper.GetMfuswiftInfoList(FileHelper.ExcelExportDataTable(stream)); var excelFile = Mapper.Map(Request, Entity); mFUOperationsHelper.UpdateExcelFile(excelFile, dbContext); mFUOperationsHelper.InsertMfuswiftInfoList(mfuswiftInfoList, Request.ExcelFileId, dbContext); return(Response.SetSuccessWithEndUserMessage("File Updated Successfully.", "OK").AsTask()); }