public void TestGetAllergiesByType()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
List <Allergy> allergies = dao.GetAllergiesByType(2); // Food
Assert.AreEqual(20, allergies.Count);
}
public void TestGetAllergies()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
List <Allergy> allergies = dao.GetAllergies();
Assert.AreEqual(74, allergies.Count);
}
public void TestGetAllergyTypes()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
List <AllergyType> types = dao.getAllergyTypes();
Assert.IsNotNull(types);
Assert.AreEqual(8, types.Count);
}
public void TestGetAllergiesByChildId()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
List <Allergy> allergies = dao.GetAllergiesByChildId(ellie);
Assert.AreEqual(1, allergies.Count);
Assert.AreEqual("Banana", allergies[0].Name);
}
public void TestRemoveAllergryFromChild()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
bool isRowAffected = dao.RemoveAllergyFromChild(ellie, 27);
List <Allergy> allergies = dao.GetAllergiesByChildId(ellie);
Assert.IsTrue(isRowAffected);
Assert.AreEqual(0, allergies.Count);
}
public void TestAddAllergyToChild()
{
AllergySqlDAO dao = new AllergySqlDAO(this.connectionString);
bool isRowAffected = dao.AddAllergyToChild(ellie, 33);
List <Allergy> allergies = dao.GetAllergiesByChildId(ellie);
Assert.IsTrue(isRowAffected);
Assert.AreEqual(2, allergies.Count);
Assert.AreEqual("Mustard Seed", allergies[1].Name);
}
