public void Find_FindBandInDatabase_BandId()
{
Band newBand = new Band("Grateful Dead");
newBand.Save();
Band foundBand = Band.Find(newBand.GetId());
Assert.Equal(newBand, foundBand);
}
public void Band_Update_UpdatesBand()
{
Band firstBand = new Band("Ween");
firstBand.Save();
firstBand.Update("Dexy's Midnight Runners");
Band resultBand = Band.Find(firstBand.GetId());
Assert.Equal("Dexy's Midnight Runners", resultBand.GetName());
}
public void Find_ForBand_FindsBandInDatabase()
{
//Arrange
Band testBand = new Band("Pajama Funnel");
testBand.Save();
//Act, Assert
Band foundBand = Band.Find(testBand.GetId());
Assert.Equal(testBand, foundBand);
}
public void Save_AssignsIdToNewBandObject_BandId()
{
Band savedBand = new Band("Grateful Dead");
savedBand.Save();
Band testBand = Band.GetAll()[0];
int savedId = savedBand.GetId();
int testId = testBand.GetId();
Assert.Equal(savedId, testId);
}
public void Find_FindsBandInDatabase_Band()
{
//Arrange
Band testBand = new Band("The Beatles");
testBand.Save();
//Act
Band foundBand = Band.Find(testBand.GetId());
//Assert
Assert.Equal(testBand, foundBand);
}
public override bool Equals(Object otherBand)
{
if (!(otherBand is Band))
{
return(false);
}
else
{
Band newBand = (Band)otherBand;
bool idEquality = (this.GetId() == newBand.GetId());
bool nameEquality = (this.GetName() == newBand.GetName());
return(idEquality && nameEquality);
}
}
public void Save_AssignIdtoObject_int()
{
//Arrange
Band testBand = new Band("The Beatles");
//Act
testBand.Save();
Band savedBand = Band.GetAll()[0];
//Assert
int actualResult = savedBand.GetId();
int expectedResult = testBand.GetId();
Assert.Equal(expectedResult, actualResult);
}
public void Test_AddShow_AddsAShowWithBandAndVenue()
{
//Arrange
Band testBand = new Band("Ween");
testBand.Save();
Venue testVenue = new Venue("Chad's");
testVenue.Save();
//Act
testVenue.AddShow(testBand.GetId(), testDate);
List<Venue> expectedVenue = new List<Venue> {testVenue};
List<Venue> result= testBand.GetVenues();
//Assert
Assert.Equal(expectedVenue, result);
}
public override bool Equals(Object otherBand)
{
if (!(otherBand is Band))
{
return(false);
}
else
{
Band newBand = (Band)otherBand;
bool idEquality = _id == newBand.GetId();
bool nameEquality = _name == newBand.GetName();
bool contactEquality = _contact == newBand.GetContact();
return(idEquality && nameEquality && contactEquality);
}
}
public void AddBand(Band newBand)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO bands_venues (venue_id, band_id) VALUES (@VenueId, @BandId);", conn);
cmd.Parameters.AddWithValue("@VenueId", this.GetId());
cmd.Parameters.AddWithValue("@BandId", newBand.GetId());
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void Test_Find_ReturnsASpecificBandObject()
{
//Arrange
Band newBand = new Band("Ween");
newBand.Save();
//Act
Band foundBand = Band.Find(newBand.GetId());
//Assert
Assert.Equal(newBand, foundBand);
}
