public void Venue_Update_UpdateDatabaseAndLocalObject() { Venue testVenue = new Venue("Manhattan Square"); testVenue.Save(); testVenue.Update("Central Park"); Venue expectedVenue = new Venue("Central Park", testVenue.GetId()); Assert.Equal(expectedVenue, Venue.Find(testVenue.GetId())); }
public void AddVenue(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO bands_venues (band_id, venue_id) VALUES (@BandId, @VenueId);"; 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 Update_AlterDatabaseEntry_ReturnNewVenue() { // This test will check to see if the Venue.Update() method writes new values to the database and the returns the altered object to the local instance // arrange Venue newVenue = new Venue("Fire"); newVenue.Save(); Venue otherVenue = new Venue("Water"); // act newVenue.Update("Water"); otherVenue.SetId(newVenue.GetId()); // assert Assert.Equal(otherVenue, Venue.Find(newVenue.GetId())); }
public void Find_OneVenueId_ReturnVenueFromDatabase() { //Arrange Venue testVenue = new Venue("Manhattan Square"); testVenue.Save(); //Act Venue foundVenue = Venue.Find(testVenue.GetId()); //Assert Assert.Equal(testVenue, foundVenue); }
public void DeleteVenue(Venue newVenue) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("DELETE FROM bands_venues WHERE venue_id = @VenueId AND band_id = @BandId;", conn); cmd.Parameters.Add(new SqlParameter("@VenueId", newVenue.GetId().ToString())); cmd.Parameters.Add(new SqlParameter("@BandId", this.GetId().ToString())); cmd.ExecuteNonQuery(); DB.CloseSqlConnection(conn); }
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); cmd.Parameters.Add(new SqlParameter("@VenueId", newVenue.GetId().ToString())); cmd.Parameters.Add(new SqlParameter("@BandId", this.GetId().ToString())); cmd.ExecuteNonQuery(); DB.CloseSqlConnection(conn); }
public override bool Equals(System.Object randomVenue) { if (!(randomVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)randomVenue; bool idEquality = (this.GetId() == newVenue.GetId()); bool nameEquality = (this.GetName() == newVenue.GetName()); return(idEquality && nameEquality); } }
public void Find_GetObjectFromDatabase_ReturnVenue() { // This test will check to see if the programs Venue.Find() method can get a venue object from the database and return it // arrange Venue newVenue = new Venue("Fire"); newVenue.Save(); // act Venue foundVenue = Venue.Find(newVenue.GetId()); // assert Assert.Equal(newVenue, foundVenue); }
public void Save_OneVenue_VenueSavedWithCorrectID() { //Arrange Venue testVenue = new Venue("Manhattan Square"); testVenue.Save(); Venue savedVenue = Venue.GetAll()[0]; //Act int output = savedVenue.GetId(); int verify = testVenue.GetId(); //Assert Assert.Equal(verify, output); }
public void AddVenue(Venue newVenue) { // This function will add a connection between the BAND and the VENUE in the join table SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("DELETE FROM bands_venues WHERE band_id = @NewBandId AND venue_id = @NewVenueId; INSERT INTO bands_venues (band_id, venue_id) VALUES (@NewBandId, @NewVenueId);", conn); cmd.Parameters.Add(new SqlParameter("@NewBandId", this.GetId())); cmd.Parameters.Add(new SqlParameter("@NewVenueId", newVenue.GetId())); cmd.ExecuteNonQuery(); DB.CloseSqlConnection(conn); }
public override bool Equals(System.Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)otherVenue; bool idEquality = this.GetId() == newVenue.GetId(); bool nameEquality = this.GetName() == newVenue.GetName(); bool contactEquality = this.GetContact() == newVenue.GetContact(); bool addressEquality = this.GetAddress() == newVenue.GetAddress(); bool eventDateEquality = this.GetEventDate() == newVenue.GetEventDate(); return(idEquality && nameEquality && eventDateEquality && contactEquality && addressEquality); } }