public void T8_GetBands_RetrievesAllVenueBands()
{
Venue testVenue = new Venue("Paramount Theatre");
testVenue.Save();
Band testBand1 = new Band("Brand New");
testBand1.Save();
Band testBand2 = new Band("A Little Old");
testBand2.Save();
DateTime performanceDate1 = new DateTime(2016, 08, 04);
DateTime performanceDate2 = new DateTime(2016, 09, 20);
Performance newPerformance1 = new Performance(testVenue.GetId(), testBand1.GetId(), performanceDate1);
newPerformance1.Save();
Performance newPerformance2 = new Performance(testVenue.GetId(), testBand2.GetId(), performanceDate2);
newPerformance2.Save();
List <Band> testBands = new List <Band> {
testBand1, testBand2
};
List <Band> result = testVenue.GetBands();
Assert.Equal(testBands, result);
}
public void Test_UpdateName_VenueNameUpdate()
{
//Arrange
Venue testVenue = new Venue("Fly Fish");
testVenue.Save();
//Act
Venue.UpdateName(testVenue.GetId(), "Angry Fish");
//Assert
Assert.Equal("Angry Fish", Venue.Find(testVenue.GetId()).GetName());
}
public void T6_GetVenues_RetrievesAllBandVenues()
{
Band testBand = new Band("Brand New");
testBand.Save();
Venue testVenue1 = new Venue("Paramount Theatre");
testVenue1.Save();
Venue testVenue2 = new Venue("Epicodus Classroom");
testVenue2.Save();
DateTime performanceDate1 = new DateTime(2016, 08, 04);
DateTime performanceDate2 = new DateTime(2016, 09, 20);
Performance newPerformance1 = new Performance(testVenue1.GetId(), testBand.GetId(), performanceDate1);
newPerformance1.Save();
Performance newPerformance2 = new Performance(testVenue2.GetId(), testBand.GetId(), performanceDate2);
newPerformance2.Save();
List <Venue> testVenues = new List <Venue> {
testVenue1, testVenue2
};
List <Venue> result = testBand.GetVenues();
Assert.Equal(testVenues, result);
}
public void AddVenue(Venue newVenue)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO bands_venues (venue_id, band_id) VALUES (@VenueId, @BandId);", conn);
SqlParameter venueIdParameter = new SqlParameter();
venueIdParameter.ParameterName = "@VenueId";
venueIdParameter.Value = newVenue.GetId();
cmd.Parameters.Add(venueIdParameter);
SqlParameter bandIdParameter = new SqlParameter();
bandIdParameter.ParameterName = "@BandId";
bandIdParameter.Value = this.GetId();
cmd.Parameters.Add(bandIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void AddVenue(Venue newVenue)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO bands_venues (venue_id, band_id ) VALUES (@VenueId, @BandId);";
MySqlParameter venue_id = new MySqlParameter();
venue_id.ParameterName = "@VenueId";
venue_id.Value = newVenue.GetId();
cmd.Parameters.Add(venue_id);
MySqlParameter band_id = new MySqlParameter();
band_id.ParameterName = "@BandId";
band_id.Value = _id;
cmd.Parameters.Add(band_id);
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
public void Test_Find_FindsVenueInDatabase()
{
Venue testVenue = new Venue("Shatter Dome");
testVenue.Save();
Venue foundVenue = Venue.Find(testVenue.GetId());
Assert.Equal(testVenue, foundVenue);
}
public void Delete_DeleteBandFromVenue()
{
Venue newVenue = new Venue("Tractor Tavern");
newVenue.Save();
Venue.Delete(newVenue.GetId());
Assert.Equal(0, Venue.GetAll().Count);
}
public void T5_Find_FindsVenueInDB()
{
Venue testVenue = new Venue("Paramount Theatre");
testVenue.Save();
Venue foundVenue = Venue.Find(testVenue.GetId());
Assert.Equal(testVenue, foundVenue);
}
public void Delete_RemoveVenueFromDatabase_Deleted()
{
Venue newVenue = new Venue("High Dive");
newVenue.Save();
Venue.Delete(newVenue.GetId());
Assert.Equal(0, Venue.GetAll().Count);
}
public void Test5_FindsVenueInDatabase()
{
Venue testVenue = new Venue("Skydome");
testVenue.Save();
Venue foundVenue = Venue.Find(testVenue.GetId());
Assert.Equal(testVenue, foundVenue);
}
public void Find_FindsVenueInDatabase_true()
{
Venue testVenue = new Venue("Crystal Ballroom");
testVenue.Save();
Venue foundVenue = Venue.Find(testVenue.GetId());
Assert.Equal(testVenue, foundVenue);
}
public void Find_ReturnsVenueBasedOnId_Venue()
{
Venue newVenue = new Venue("The Showbox");
newVenue.Save();
Venue expectedResult = newVenue;
Venue actualResult = Venue.Find(newVenue.GetId());
Assert.Equal(expectedResult, actualResult);
}
public void Venue_Update_UpdatesInDb()
{
Venue testVenue = new Venue("Name");
testVenue.Save();
testVenue.Update("new Name");
Venue newVenue = new Venue("new Name", testVenue.GetId());
Assert.Equal(testVenue, newVenue);
}
public void Find_FindsVenueInDB_True()
{
//Arrange
Venue newVenue = new Venue("AKron Agora", "3308698686");
newVenue.Save();
Venue foundVenue = Venue.Find(newVenue.GetId());
//Assert
Assert.Equal(foundVenue, newVenue);
}
public void Test_Update_UpdateVenueInDatabase()
{
Venue testVenue = new Venue("THE SPACE");
testVenue.Save();
testVenue.Update("THE COLOSSEUM AT CAESAR’S PALACE");
Venue actual = testVenue;
Venue expected = new Venue("THE COLOSSEUM AT CAESAR’S PALACE", testVenue.GetId());
Assert.Equal(expected, actual);
}
public void T4_Save_AssignsIdToVenue()
{
Venue testVenue = new Venue("Paramount Theatre");
testVenue.Save();
Venue savedVenue = Venue.GetAll()[0];
int result = savedVenue.GetId();
int testId = testVenue.GetId();
Assert.Equal(testId, result);
}
public void Find_FindsVenueById_true()
{
//Arrange
Venue newVenue = new Venue("CBGB");
newVenue.Save();
//Act
Venue foundVenue = Venue.Find(newVenue.GetId());
//Assert
Assert.Equal(newVenue, foundVenue);
}
public void Save_SaveToDatabase_SaveWithId()
{
Venue testVenue = new Venue("THE SPACE");
testVenue.Save();
Venue savedVenue = Venue.GetAll()[0];
int result = savedVenue.GetId();
int expected = testVenue.GetId();
Assert.Equal(expected, result);
}
public void Test_Find_FindsVenueInDatabase()
{
//Arrange
Venue testVenue = new Venue("El Corazon");
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Update_UpdatesDatabase_True()
{
Venue newVenue = new Venue("Rose Garden");
newVenue.Save();
newVenue.Update("Moda Center");
Venue testVenue = new Venue("Moda Center");
Venue result = Venue.Find(newVenue.GetId());
Assert.Equal(testVenue, result);
}
public void Update_UpdatesDatabase_True()
{
Venue newVenue = new Venue("Doug Fur");
newVenue.Save();
newVenue.Update("Doug Fir");
Venue testVenue = new Venue("Doug Fir");
Venue result = Venue.Find(newVenue.GetId());
Assert.Equal(testVenue, result);
}
public void Test_Find_FindsVenueInDatabase()
{
//Arrange
Venue testVenue = new Venue("Rose Quarter", "Portland", 20000);
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Test_FindFindsVenueInDatabase()
{
//Arrange
Venue testVenue = new Venue("Name");
testVenue.Save();
//Act
Venue result = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, result);
}
public void AddVenue(Venue newVenue)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO venues_bands (band_id, venue_id) VALUES (@BandId, @VenueId);", conn);
cmd.Parameters.Add(new SqlParameter("@BandId", this.GetId()));
cmd.Parameters.Add(new SqlParameter("@VenueId", newVenue.GetId()));
DB.CloseNonQuery(cmd, conn);
}
public void Test_Find_FindsVenueInDataBAse()
{
//Arrange
Venue testVenue = new Venue("The Hollywood Bowl, Los Angeles, CA");
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Find_VenueById_FoundVenue()
{
Venue newVenue1 = new Venue("Hollywood Bowl");
newVenue1.Save();
Venue newVenue2 = new Venue("Irvine Amphitheater");
newVenue2.Save();
Venue foundVenue = Venue.Find(newVenue2.GetId());
Assert.Equal(foundVenue, newVenue2);
}
public void Find_FindsVenueInDatabase()
{
//Arrange
Venue testVenue = new Venue("The Showbox");
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Edit_ChangesName_true()
{
//Arrange
Venue newVenue = new Venue("CBGBBQ");
newVenue.Save();
//Act
newVenue.Edit("CBGB");
Venue foundVenue = Venue.Find(newVenue.GetId());
//Assert
Assert.Equal("CBGB", foundVenue.GetName());
}
public void Test4_Save_AssignsId()
{
Venue testVenue = new Venue("Skydome");
testVenue.Save();
Venue savedVenue = Venue.GetAll()[0];
int result = savedVenue.GetId();
int testId = testVenue.GetId();
Assert.Equal(testId, result);
}
public void Find_VenueId_ReturnVenueFromDatabase()
{
//Arrange
Venue testVenue = new Venue("THE SPACE");
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Update_UpdatesVenueInDb_True()
{
//Arrange
Venue newVenue = new Venue("AKron Agora", "3308698686");
newVenue.Save();
//Act
newVenue.Edit("Peabodys", "3307625903");
Venue editedVenue = Venue.Find(newVenue.GetId());
//Assert
Assert.Equal("Peabodys", editedVenue.GetName());
}
public void Test_Delete_DeletesVenueFromDatabase()
{
Venue testVenue1 = new Venue("Shatter Dome");
testVenue1.Save();
Venue testVenue2 = new Venue("Belly of the Beast");
testVenue2.Save();
Venue.Delete(testVenue1.GetId());
List<Venue> testList = new List<Venue>{testVenue2};
List<Venue> resultList = Venue.GetAll();
Assert.Equal(testList, resultList);
}
public void T4_Save_AssignsIdToCagetoryObject()
{
//Arrange
Venue testVenue = new Venue("A");
testVenue.Save();
//Act
Venue savedVenue = Venue.GetAll()[0];
int result = savedVenue.GetId();
int testId = testVenue.GetId();
//Assert
Assert.Equal(testId, result);
}
public void Test_Update_UpdatesVenueWithNewValues()
{
Venue testVenue = new Venue("Shatter Dome");
testVenue.Save();
testVenue.SetName("Belly of the Beast");
testVenue.Update();
Venue resultVenue = Venue.Find(testVenue.GetId());
Venue test = new Venue("Belly of the Beast", testVenue.GetId());
Assert.Equal(test, resultVenue);
}
public void Test_Find_FindsVenueInDatabase()
{
//Arrange
Venue testVenue = new Venue("El Corazon");
testVenue.Save();
//Act
Venue foundVenue = Venue.Find(testVenue.GetId());
//Assert
Assert.Equal(testVenue, foundVenue);
}
public void Test_Save_AssignsIdToObject()
{
//Arrange
Venue testVenue = new Venue("The Neptune");
//Act
testVenue.Save();
Venue savedVenue = Venue.GetAll()[0];
int result = savedVenue.GetId();
int testId = testVenue.GetId();
//Assert
Assert.Equal(testId, result);
}
public void AddVenue(Venue newVenue)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO venues_bands (venue_id, band_id) VALUES (@VenueId, @BandId);", conn);
SqlParameter venueIdParameter = new SqlParameter();
venueIdParameter.ParameterName = "@VenueId";
venueIdParameter.Value = newVenue.GetId();
SqlParameter bandIdParameter = new SqlParameter();
bandIdParameter.ParameterName = "@BandId";
bandIdParameter.Value = this.GetId();
cmd.Parameters.Add(venueIdParameter);
cmd.Parameters.Add(bandIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
