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