public void AddObject2(Object2 newObject2) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO object1s_object2s (object1_id, object2_id) VALUES (@Object1Id, @Object2Id);", conn); SqlParameter object1IdParameter = new SqlParameter(); object1IdParameter.ParameterName = "@Object1Id"; object1IdParameter.Value = this.GetId(); cmd.Parameters.Add(object1IdParameter); SqlParameter object2IdParameter = new SqlParameter(); object2IdParameter.ParameterName = "@Object2Id"; object2IdParameter.Value = newObject2.GetId(); cmd.Parameters.Add(object2IdParameter); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }
public void Test_Update_UpdatesInDb() { Object2 testObject2 = new Object2("Name"); testObject2.Save(); testObject2.Update("Other name"); Object2 newObject2 = new Object2("Other name", testObject2.GetId()); Assert.Equal(testObject2, newObject2); }
public void Test_FindFindsObject2InDatabase() { //Arrange Object2 testObject2 = new Object2("Name"); testObject2.Save(); //Act Object2 result = Object2.Find(testObject2.GetId()); //Assert Assert.Equal(testObject2, result); }
public override bool Equals(System.Object otherObject2) { if (!(otherObject2 is Object2)) { return(false); } else { Object2 newObject2 = (Object2)otherObject2; bool idEquality = this.GetId() == newObject2.GetId(); bool nameEquality = this.GetName() == newObject2.GetName(); return(idEquality && nameEquality); } }
public void Test_SaveAssignsIdToObject() { //Arrange Object2 testObject2 = new Object2("Name"); testObject2.Save(); //Act Object2 savedObject2 = Object2.GetAll()[0]; Console.WriteLine(testObject2.GetName()); int result = savedObject2.GetId(); int testId = testObject2.GetId(); //Assert Assert.Equal(testId, result); }