public Object GetIdentificationVerification()
{
var identification = dc.Table <UserIdentification>().FirstOrDefault(x => x.UserId == CurrentUserId);
var frontSidePhoto = (from us in dc.Table <UserDocument>()
join fs in dc.Table <FileStorage>() on us.FileStorageId equals fs.Id
where us.UserId == CurrentUserId && us.Tag == "FrontSidePhotoId"
orderby us.UpdatedTime descending
select new { Name = fs.OriginalFileName, fs.Size, fs.ConvertedFileName }).FirstOrDefault();
var backSidePhoto = (from us in dc.Table <UserDocument>()
join fs in dc.Table <FileStorage>() on us.FileStorageId equals fs.Id
where us.UserId == CurrentUserId && us.Tag == "BackSidePhotoId"
orderby us.UpdatedTime descending
select new { Name = fs.OriginalFileName, fs.Size, fs.ConvertedFileName }).FirstOrDefault();
var storage = new FileStorageCore(dc, CurrentUserId);
return(new
{
DocumentNumber = identification?.DocumentNumber,
DocumentTypeId = identification?.DocumentTypeId,
ExpiryDate = identification?.ExpiryDate,
IssueDate = identification?.IssueDate,
FrontSidePhoto = new
{
frontSidePhoto?.Name,
frontSidePhoto?.Size,
Path = (frontSidePhoto?.ConvertedFileName == null) ? "" : storage.GetFilePath(frontSidePhoto.ConvertedFileName)
},
BackSidePhoto = new
{
backSidePhoto?.Name,
backSidePhoto?.Size,
Path = (backSidePhoto?.ConvertedFileName == null) ? "" : storage.GetFilePath(backSidePhoto.ConvertedFileName)
}
});
}
public IActionResult GetDocumentSignature()
{
var file = (from us in dc.Table <UserDocument>()
join fs in dc.Table <FileStorage>() on us.FileStorageId equals fs.Id
where us.UserId == CurrentUserId && us.Tag == "DocumentSignature"
orderby us.UpdatedTime descending
select new { Name = fs.OriginalFileName, fs.Size, fs.ConvertedFileName }).FirstOrDefault();
var storage = new FileStorageCore(dc, CurrentUserId);
return(Ok(new
{
file?.Name,
file?.Size,
Path = (file?.ConvertedFileName == null) ? "" : storage.GetFilePath(file.ConvertedFileName)
}));
}