public List <MemberDocumentStorage> GetReferencesByCustomer(int memberId)
{
try
{
DocumentstorageContext context = new DocumentstorageContext(_connectionString);
return(context.MemberDocumentStorage.Where(x => x.MemberId == memberId).ToList());
}
catch
{
//add logging
throw;
}
}
public async Task <bool> AddCustomerReferenceAsync(MemberDocumentStorage document)
{
try
{
DocumentstorageContext context = new DocumentstorageContext(_connectionString);
context.Add(document);
await context.SaveChangesAsync();
return(true);
}
catch
{
//add logging
throw;
}
}
public async Task <bool> DeleteDocumentRecordByURIAsync(int memberId, string uri)
{
try
{
DocumentstorageContext context = new DocumentstorageContext(_connectionString);
var entity =
context.MemberDocumentStorage.FirstOrDefault(x => x.MemberId == memberId && x.FileUri == uri);
context.MemberDocumentStorage.Remove(entity);
await context.SaveChangesAsync();
return(true);
}
catch
{
//add logging
throw;
}
}
