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