public async Task <int> CreateTestData(TestTableContractModel model) { int returnValue = 0; NAVCalculatorEntities dc = new NAVCalculatorEntities(); using (var dbContextTransaction = dc.Database.BeginTransaction()) { try { var existsTestData = dc.TestTables .Where(t => t.TestTableId == model.TestTableId) .Select(t => t.TestTableId) .FirstOrDefault(); if (existsTestData > 0) { returnValue = -1; } else { var dataModel = dc.TestTables.Create(); dataModel.TestTableId = model.TestTableId; dataModel.FirstName = model.FirstName; dataModel.SurName = model.SurName; dc.TestTables.Add(dataModel); await dc.SaveChangesAsync(); int TestTableID = dataModel.TestTableId; returnValue = TestTableID; dbContextTransaction.Commit(); } return(returnValue); } catch (Exception ex) { dbContextTransaction.Rollback(); throw; } } }
public async Task <List <TestTable> > GetTestData() { try { NAVCalculatorEntities dc = new NAVCalculatorEntities(); List <TestTable> result = null; using (var dbContextTransaction = dc.Database.BeginTransaction()) { var myTask = Task.Run(() => dc.TestTables.ToList()); result = await myTask; return(result); } } catch (Exception ex) { throw new Exception(ex.Message); } }