public UserInterface(string connectionString) { this.connectionString = connectionString; venueIO = new VenuesDAL(connectionString); spaceIO = new SpacesDAL(connectionString); reservationIO = new ReservationsDAL(connectionString); bookingSystem = new BookingSystem(connectionString); }
public void SearchAvailableSpacesTest() { //Arrange SpacesDAL testObj = new SpacesDAL(connectionString); DateTime testDate = new DateTime(2020, 6, 15); int newId = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string sqlInsertVenue = "INSERT INTO venue (name, city_id, description) VALUES ('ZZZZ', 3, 'XXXX')"; string sqlInsertSpace = "INSERT INTO space (name, is_accessible, venue_id, daily_rate, max_occupancy, open_from, open_to) VALUES ('RRRR', 0, @venue_id, 350.00, 100000, 2, 10)" + "INSERT INTO space (name, is_accessible, venue_id, daily_rate, max_occupancy) VALUES ('ZZZZ', 1, @venue_id, 600.00, 100000)"; string sqlGetInsertedVenueID = "SELECT id FROM Venue WHERE name = 'ZZZZ'"; SqlCommand cmd = new SqlCommand(sqlInsertVenue, conn); int count = cmd.ExecuteNonQuery(); Assert.IsTrue(count > 0); cmd = new SqlCommand(sqlGetInsertedVenueID, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { newId = Convert.ToInt32(reader["id"]); } reader.Close(); cmd = new SqlCommand(sqlInsertSpace, conn); cmd.Parameters.AddWithValue("@venue_id", newId); count = cmd.ExecuteNonQuery(); Assert.IsTrue(count > 0); } //Act List <Space> result = testObj.SearchForAvailableSpaces(newId, testDate, 1, 99999); //Assert Assert.AreEqual(2, result.Count); }
public void GetSpacesForVenueTest() { //Arrange SpacesDAL testObj = new SpacesDAL(connectionString); int newId = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string sqlInsertVenue = "INSERT INTO venue (name, city_id, description) VALUES ('ZZZZ', 3, 'XXXX')"; string sqlGetInsertedVenueID = "SELECT id FROM venue WHERE name = 'ZZZZ'"; string sqlInsertSpaces = "INSERT INTO space (venue_id, name, is_accessible, daily_rate, max_occupancy) VALUES (@id, 'YYYY', 1, 400.00, 100)" + "INSERT INTO space (venue_id, name, is_accessible, daily_rate, max_occupancy) VALUES (@id, 'VVVV', 1, 3500.00, 200); "; SqlCommand cmd = new SqlCommand(sqlInsertVenue, conn); int count = cmd.ExecuteNonQuery(); cmd = new SqlCommand(sqlGetInsertedVenueID, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { newId = Convert.ToInt32(reader["id"]); } reader.Close(); cmd = new SqlCommand(sqlInsertSpaces, conn); cmd.Parameters.AddWithValue("@id", newId); cmd.ExecuteNonQuery(); } //Act List <Space> result = testObj.GetSpacesForVenue(newId); //Assert Assert.AreEqual(2, result.Count); }