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