public void DBDistrictTest_Persist_Delete() { DBDistrict db = new DBDistrict(); const string dName = "Norway"; var district = new District() { Name = dName, PrimarySalesperson = new Salesperson() { Id = 2 } }; var countOld = db.GetAll().Count(); db.Persist(district); var countNew = db.GetAll().Count(); Assert.AreNotEqual(countOld, countNew); district = db.GetAll().ToList().SingleOrDefault(x => x.Name.Equals(dName)); db.Delete(district.Id); countNew = db.GetAll().Count(); Assert.AreEqual(countOld, countNew); }
public void DBDistrictTest_GetAll() { DBDistrict db = new DBDistrict(); var d = db.GetAll(); Assert.IsNotNull(d); Assert.AreNotEqual(0, d.Count()); }
public void DBDistrictTest_Get() { DBDistrict db = new DBDistrict(); var resp = db.Get(1); Assert.IsTrue(resp.Name.ToLower().Contains("denmark")); Assert.IsNotNull(resp.PrimarySalesperson); Assert.IsNotNull(resp.SecondarySalespeople); Assert.AreNotEqual(0, resp.SecondarySalespeople.Count()); }
public void DBDistrictTest_DeleteSecondary_fail_DistrictID() { DBDistrict db = new DBDistrict(); var person = new Salesperson() { Id = 1 }; var district = new District() { Id = -1 }; db.DeleteSecondary(person, district); }
public void DBDistrictTest_AssignSecondary_fail_PersonID() { DBDistrict db = new DBDistrict(); var person = new Salesperson() { Id = -1 }; var district = new District() { Id = 1 }; db.AssignSecondary(person, district); }
public void DBDistrictTest_Update() { DBDistrict db = new DBDistrict(); const int id = 2; var district = db.Get(id); var nameOld = district.Name; var nameNew = "Norway"; district.Name = nameNew; db.Update(district); district = db.Get(id); Assert.AreEqual(nameNew, district.Name); district.Name = nameOld; db.Update(district); district = db.Get(id); Assert.AreEqual(nameOld, district.Name); }
public void DBDistrictTest_AssignSecondary_DeleteSecondary() { DBDistrict db = new DBDistrict(); var person = new Salesperson() { Id = 3 }; var district = new District() { Id = 1 }; var countOld = db.Get(1).SecondarySalespeople.Count(); db.AssignSecondary(person, district); var countNew = db.Get(1).SecondarySalespeople.Count(); Assert.AreNotEqual(countOld, countNew); db.DeleteSecondary(person, district); countNew = db.Get(1).SecondarySalespeople.Count(); Assert.AreEqual(countOld, countNew); }
public void DBDistrictTest_Get_fail_ID() { DBDistrict db = new DBDistrict(); db.Get(-1); }
public DistrictController() { db = new DBDistrict(); }