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(); }