public virtual async Task <int> SaveAsync()
{
int returnValue = 200;
using (var dbContextTransaction = Context.Database.BeginTransaction())
{
try
{
await Context.SaveChangesAsync();
dbContextTransaction.Commit();
}
catch (DbUpdateException ex)
{
var sqlException = ex.GetBaseException() as SqlException;
if (sqlException != null)
{
var number = sqlException.Number;
if (number == 547)
{
returnValue = 501;
}
else
{
returnValue = 500;
}
}
}
catch (Exception)
{
//Log Exception Handling message
returnValue = 500;
dbContextTransaction.Rollback();
}
}
return(returnValue);
}
public async Task DeleteDCF(string stock)
{
var dcfs = _stocksContext.DCFs.Where(x => x.Symbol == stock).ToList();
_stocksContext.RemoveRange(dcfs);
await _stocksContext.SaveChangesAsync();
}
public async Task Save()
{
await context.SaveChangesAsync();
}