public async Task CreateNewMedicalRequestAsync(string currentUsername, MedicalRequestDTO model)
{
var person = await _dbContext.Persons.FirstOrDefaultAsync(x => x.Mobile == currentUsername);
if (person == null)
{
throw new AwroNoreException("Not any person found for this mobile number");
}
var strategy = _dbContext.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() =>
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
var request = new AN.Core.Domain.MedicalRequest
{
Date = model.Date,
Note = model.Note,
RequestedCountryId = model.CountryId,
RequesterPersonId = person.Id,
CreatedAt = DateTime.Now
};
await _dbContext.MedicalRequests.AddAsync(request);
await _dbContext.SaveChangesAsync();
// Proccess Files
if (model.Files.Any())
{
// Files base url
var basePhotosUrl = _uploadService.GenerateMedicalRequestFilesBaseUrl(request.Id, request.CreatedAt);
var photosDictionary = new Dictionary <IFormFile, (string newFileName, string thumbName)>();
// Process Files Logical Names
foreach (var file in model.Files)
{
var(newFileName, thumbFileName) = _uploadService.GenerateMedicalRequestFileName(request.Id, file);
photosDictionary.Add(file, (newFileName, thumbFileName));
await _dbContext.Attachments.AddAsync(new Attachment
{
Name = newFileName,
Url = $"{basePhotosUrl}/{newFileName}",
ThumbnailUrl = $"{basePhotosUrl}/{thumbFileName}",
DeleteUrl = "DeleteUrl",
Size = (int)file.Length,
Order = model.Files.IndexOf(file),
CreatedAt = DateTime.Now,
Owner = AN.Core.Enums.FileOwner.MEDICAL_REQUEST,
OwnerTableId = request.Id,
FileType = AN.Core.Enums.FileType.Image,
Description = ""
});
}
await _dbContext.SaveChangesAsync();
await _uploadService.UploadMedicalRequestFilesAsync(request.Id, request.CreatedAt, photosDictionary);
}
transaction.Commit();
}
});
}