Ejemplo n.º 1
0
        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());
            }
        }
Ejemplo n.º 2
0
        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());
        }