public void TestOrmAdapter_Remove2() { OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); int BillCount = _oa.GetBills().Count(); _oa.RemoveBill(1); int newBillCount = _oa.GetBills().Count(); Assert.True(newBillCount == BillCount - 1); }
public void TestOrmAdapter_Get2() { _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); List <Bill> bills = _oa.GetBills(); // _tdb.Database.EnsureDeleted(); Assert.True(bills.Count != 0); }
public void TestOrmAdapter_Get1() { _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); List <Income> incomes = _oa.GetIncomes(); // _tdb.Database.EnsureDeleted(); Assert.True(incomes.Count != 0); }
public void TestOrmAdapter_Remove1() { OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); int IncomeCount = _oa.GetIncomes().Count(); _oa.RemoveIncome(2); int newIncomeCount = _oa.GetIncomes().Count(); _tdb.Database.EnsureDeleted(); Assert.True(newIncomeCount == IncomeCount - 1); }
public void Test_TestDbContext() { //Arrange _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); //Act var members = _tdb.Member.ToList(); // _tdb.Database.EnsureDeleted(); //Assert Assert.True(members.Count() != 0); //Should be 4. Passes. }
public void Test_GetBudgetTest() { //Arrange Test_BudgetDbContext _tdb = new Test_BudgetDbContext(); _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext> _oa = new OrmAdapter <Test_BudgetDbContext>(_tdb); BudgetController budgetController = new BudgetController(_tdb); //Act var budget = budgetController.GetBudget(1); _tdb.Database.EnsureDeleted(); //Assert Assert.True(budget != null); // }
public void TestOrmAdapter_Update1() { _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); Income income = _tdb.Income.Where(m => m.Id == 1).SingleOrDefault(); income.Name = "Great job"; _oa.UpdateIncome(income); Income inc = _tdb.Income.Where(m => m.Id == 1).SingleOrDefault(); string newName = inc.Name; // _tdb.Database.EnsureDeleted(); Assert.True(newName == "Great job"); }
public void TestOrmAdapter_Update2() { _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); Bill bill = _tdb.Bill.Where(b => b.Id == 1).SingleOrDefault(); bill.Name = "Orange Juice"; _oa.UpdateBill(bill); Bill bill1 = _tdb.Bill.Where(b => b.Id == 1).SingleOrDefault(); string newName = bill1.Name; // _tdb.Database.EnsureDeleted(); Assert.True(newName == "Orange Juice"); }
public void Test_CreateGoalTest() { //Arrange Test_BudgetDbContext _tdb = new Test_BudgetDbContext(); _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext> _oa = new OrmAdapter <Test_BudgetDbContext>(_tdb); BudgetController budgetController = new BudgetController(_tdb); Goal goal = new Goal(); //Act var goal2 = budgetController.CreateGoal(goal); _tdb.Database.EnsureDeleted(); //Assert Assert.True(goal2 != null); // }
public void Test_CreateIncomeTest() { //Arrange Test_BudgetDbContext _tdb = new Test_BudgetDbContext(); _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext> _oa = new OrmAdapter <Test_BudgetDbContext>(_tdb); BudgetController budgetController = new BudgetController(_tdb); Income income = new Income(); //Act var income2 = budgetController.CreateIncome(income); _tdb.Database.EnsureDeleted(); //Assert Assert.True(income2 != null); // }
public void Test_CreateExpenseTest() { //Arrange Test_BudgetDbContext _tdb = new Test_BudgetDbContext(); _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext> _oa = new OrmAdapter <Test_BudgetDbContext>(_tdb); BudgetController budgetController = new BudgetController(_tdb); Expense expense = new Expense(); //Act var expense2 = budgetController.CreateExpense(expense); _tdb.Database.EnsureDeleted(); //Assert Assert.True(expense2 != null); // }
public void TestOrmAdapter_Insert2() { //Arrange _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); //Act bool insertbillbool = _oa.InsertBill(new Bill() { Id = 99, Name = "testbill" }); Bill bill = _tdb.Bill.Where(b => b.Id == 99).SingleOrDefault(); string name = bill.Name; _tdb.Database.EnsureDeleted(); //Assert Assert.True(name == "testbill"); }
public void TestOrmAdapter_Insert1() { //Arrange _tdb.Database.EnsureCreated(); OrmAdapter <Test_BudgetDbContext2> _oa = new OrmAdapter <Test_BudgetDbContext2>(_tdb); //Act bool insertincomebool = _oa.InsertIncome(new Income() { Id = 100, Name = "Lockheed", Amount = 10000 }); Income income = _tdb.Income.Where(m => m.Id == 100).SingleOrDefault(); string name = income.Name; // _tdb.Database.EnsureDeleted(); //Assert Assert.True(name == "Lockheed"); }
public MemberRepository(T db) { _db = db; _oa = new OrmAdapter <T>(_db); }