public CommonResult CheckAndSaveAirBagFile()
{
_logger.LogInformation("********** CheckAndSaveAirBagFile is Started!! **********");
var result = new CommonResult <FileResultBase>();
var blobIdQueries = _uow.AirBagFiles.GetAll().Where(x => x.UploadStatus == (int)UploadStatusCode.Before).ToList();
//before statusがnull場合
if (blobIdQueries.Count == 0)
{
_logger.LogInformation("********** Can't find anyting **********");
return(new CommonResult {
ResultType = ResultType.Error, ErrorMessages = { Resources.E_NoQueryError }
});
}
foreach (var blobIdQuery in blobIdQueries)
{
blobIdQuery.UploadStatus = (int)UploadStatusCode.InProcess;
blobIdQuery.UpdatedAt = DateTime.Now.AddHours(9);
_uow.SaveChanges();
if (blobIdQuery.BlobId != 0)
{
var blobInfo = _fileService.GetBlobName("airbag", blobIdQuery.BlobId);
var resultBlobFile = _fileService.DownloadFileFromBlob("airbag", blobInfo.BlobName);
var memoryStream = new MemoryStream(resultBlobFile.Result);
var dataReader = new AirBagDetailDataReader();
try
{
dataReader.LoadFile(memoryStream);
//var validateResult = dataReader.ValidateFormat();
//if (validateResult.ResultType != ResultType.Success)
//{
// return Json(validateResult);
//}
}
catch
{
blobIdQuery.UploadStatus = (int)UploadStatusCode.Error;
blobIdQuery.ErrorMessage = Resources.E_FailedLoadingFile;
blobIdQuery.UpdatedAt = DateTime.Now.AddHours(9);
//_uow.SaveChanges();
var errorResult = new CommonResult <FileResultBase>
{
ResultType = ResultType.Error,
ErrorMessages = new List <string> {
Resources.E_FailedLoadingFile
}
};
return(errorResult);
}
var condition = new AirBagFilePutCondition();
//SetPutConditionBase(condition);
condition.AirBagDetails = dataReader.GetContent();
var validationResult = ValidateCondition(condition);
//if (!validationResult.Succeeded && validationResult.Result != null)
//{
// validationResult.Result.FileName = dataReader.GetFileName();
// TempData.Put(TEMP_ERROR_EXCEL_KEY, validationResult.Result);
//}
var registerResult = RegisterAirBag(condition, blobIdQuery.CreatedBy, blobIdQuery.CreatedAt);
//処理結果生成
//result = new CommonResult<FileResultBase>();
result.ErrorMessages = new List <string>();
//validationチェックでエラー
if (validationResult.ResultType != ResultType.Success)
{
var uploadErrorFileResult = _fileService.UploadStreamExcel(validationResult.Result.Bytes, "ErrorExcel.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "airbag", blobIdQuery.UpdatedBy, blobIdQuery.UpdatedAt ?? DateTime.Now);
var uploadPropertyresult = _fileService.RegisterFilesWithBlobFileProperties(uploadErrorFileResult.Result.BlobName, uploadErrorFileResult.Result.FileName, "airbag", DateTime.Now, "system");
blobIdQuery.UploadStatus = (int)UploadStatusCode.Error;
blobIdQuery.ErrorBlobId = uploadPropertyresult.BlobId;
blobIdQuery.ErrorMessage = Resources.E_FileValidationError;
//一部格納成功
if (registerResult.ResultType == ResultType.Success)
{
result.SuccessMessage = registerResult.SuccessMessage;
}
result.Result = validationResult.Result;
result.ErrorMessages.AddRange(validationResult.ErrorMessages);
blobIdQuery.UpdatedAt = DateTime.Now.AddHours(9);
}
//全件格納成功
else if (registerResult.ResultType == ResultType.Success && validationResult.ResultType == ResultType.Success)
{
blobIdQuery.UploadStatus = (int)UploadStatusCode.Done;
result.SuccessMessage = registerResult.SuccessMessage;
blobIdQuery.UpdatedAt = DateTime.Now.AddHours(9);
}
//全件失敗
else
{
blobIdQuery.UploadStatus = (int)UploadStatusCode.Error;
result.ErrorMessages.AddRange(registerResult.ErrorMessages);
blobIdQuery.ErrorMessage = registerResult.ErrorMessages[0];
blobIdQuery.UpdatedAt = DateTime.Now.AddHours(9);
}
_uow.SaveChanges();
LogComplete();
//return result;
}
}//foreach
return(result);
}
