public void AddDisease(Disease newDisease)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO diseases_remedies (diseases_id, remedies_id) VALUES (@DiseaseId, @RemedyId);", conn);
SqlParameter diseaseIdParameter = new SqlParameter();
diseaseIdParameter.ParameterName = "@DiseaseId";
diseaseIdParameter.Value = newDisease.GetId();
cmd.Parameters.Add(diseaseIdParameter);
SqlParameter remedyIdParameter = new SqlParameter();
remedyIdParameter.ParameterName = "@RemedyId";
remedyIdParameter.Value = this.GetId();
cmd.Parameters.Add(remedyIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void Test_Find_FindsDiseaseInDatabase()
{
//Arrange
Disease testDisease = new Disease("cold", "running nose", "image1", 1);
testDisease.Save();
//Act
Disease foundDisease = Disease.Find(testDisease.GetId());
//Assert
Assert.Equal(testDisease, foundDisease);
}
public override bool Equals(System.Object otherDisease)
{
if (!(otherDisease is Disease))
{
return(false);
}
else
{
Disease newDisease = (Disease)otherDisease;
bool idEquality = (this.GetId() == newDisease.GetId());
bool nameEquality = (this.GetName() == newDisease.GetName());
bool symtomsEquality = (this.GetSymtoms() == newDisease.GetSymtoms());
bool imageEquality = (this.GetImage() == newDisease.GetImage());
bool category_idEquality = (this.GetCategoryId() == newDisease.GetCategoryId());
return(idEquality && nameEquality && imageEquality && symtomsEquality && category_idEquality);
}
}
