public void Delete_AllFlights_AllButOneFlight() { City city1 = new City("Barcelona"); city1.Save(); City city2 = new City("Honolulu"); city2.Save(); Flight flight1 = new Flight("12:00 pm", city1.GetName(), city2.GetName(), "Delayed"); flight1.Save(); flight1.AddCities(city1, city2); City city3 = new City("Barcelona"); city3.Save(); City city4 = new City("Honolulu"); city4.Save(); Flight flight2 = new Flight("14:00 pm", city3.GetName(), city4.GetName(), "Delayed"); flight2.Save(); flight2.AddCities(city3, city4); flight1.Delete(); List <Flight> returnedFlights = Flight.GetAll(); List <Flight> expected = new List <Flight> { flight2 }; Assert.Equal(returnedFlights, expected); }
public HomeModule() { Get["/"] = _ => { List <City> allCities = City.GetAll(); return(View["index.cshtml", allCities]); }; Post["/"] = _ => { Flight newFlight = new Flight(Request.Form["departure"], Request.Form["departure-city"], Request.Form["arrival-city"], Request.Form["status"]); newFlight.Save(); return(View["add_flight_success.cshtml", newFlight]); }; Get["/cities"] = _ => { List <City> allCities = City.GetAll(); return(View["cities.cshtml", allCities]); }; Post["/cities"] = _ => { string userInput = Request.Form["name"]; City newCity = new City(userInput); newCity.Save(); List <City> allCities = City.GetAll(); return(View["cities.cshtml", allCities]); }; Get["/flights"] = _ => { List <Flight> allFlights = Flight.GetAll(); return(View["flights.cshtml", allFlights]); }; Post["/flights"] = _ => { string departure = Request.Form["departure"]; int departureCityId = Request.Form["departure-city"]; int arrivalCityId = Request.Form["arrival-city"]; string status = Request.Form["status"]; City departureCity = City.Find(departureCityId); City arrivalCity = City.Find(arrivalCityId); string departureCityString = departureCity.GetName(); string arrivalCityString = arrivalCity.GetName(); Flight newFlight = new Flight(departure, departureCityString, arrivalCityString, status); newFlight.Save(); newFlight.AddCities(departureCity, arrivalCity); List <Flight> allFlights = Flight.GetAll(); return(View["flights.cshtml", allFlights]); }; }
public override bool Equals(System.Object otherCity) { if (!(otherCity is City)) { return(false); } else { City newCity = (City)otherCity; bool idEquality = this.GetId() == newCity.GetId(); bool nameEquality = this.GetName() == newCity.GetName(); return(idEquality && nameEquality); } }
public void UpdateStatus_OneFlight_NewStatus() { City city1 = new City("Barcelona"); city1.Save(); City city2 = new City("Honolulu"); city2.Save(); Flight flight1 = new Flight("12:00 pm", city1.GetName(), city2.GetName(), "Delayed"); flight1.Save(); flight1.AddCities(city1, city2); flight1.UpdateStatus("On Time"); string newStatus = flight1.GetStatus(); Assert.Equal(newStatus, "On Time"); }
public void UpdateDeparture_OneFlight_NewDeparture() { City city1 = new City("Barcelona"); city1.Save(); City city2 = new City("Honolulu"); city2.Save(); Flight flight1 = new Flight("12:00 pm", city1.GetName(), city2.GetName(), "Delayed"); flight1.Save(); flight1.AddCities(city1, city2); flight1.UpdateDeparture("12:00 am"); string newDeparture = flight1.GetDeparture(); Assert.Equal(newDeparture, "12:00 am"); }
public void Test_AddCities_AddsCityToFlight() { //Arrange City departureCity = new City("Chicago"); departureCity.Save(); City arrivalCity = new City("Seattle"); arrivalCity.Save(); Flight testFlight = new Flight("12:00 pm", departureCity.GetName(), arrivalCity.GetName(), "Delayed"); testFlight.Save(); testFlight.AddCities(departureCity, arrivalCity); List <City> result = testFlight.GetCities(); List <City> testList = new List <City> { departureCity, arrivalCity }; //Assert Assert.Equal(testList, result); }
public void UpdateArrivalCity_OneFlight_NewArrivalCity() { City city1 = new City("Barcelona"); city1.Save(); City city2 = new City("Honolulu"); city2.Save(); Flight flight1 = new Flight("12:00 pm", city1.GetName(), city2.GetName(), "Delayed"); flight1.Save(); flight1.AddCities(city1, city2); City city3 = new City("Austin"); city3.Save(); flight1.UpdateArrivalCity(city3); string newArrivalCity = flight1.GetArrivalCity(); Assert.Equal(newArrivalCity, city3.GetName()); }
public void UpdateArrivalCity(City newCity) { City OldArrivalCity = City.FindByName(this.GetArrivalCity()); int OldArrivalCityId = OldArrivalCity.GetId(); SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE flights SET arrival_city = @ArrivalCity OUTPUT INSERTED.arrival_city WHERE id=@FlightId; UPDATE flights_cities SET city_id = @NewArrivalCityId WHERE flight_id = @FlightId AND city_id = @OldArrivalCityId;", conn); SqlParameter arrivalCityParameter = new SqlParameter("@ArrivalCity", newCity.GetName()); SqlParameter flightIdParameter = new SqlParameter("@FlightId", this.GetId()); SqlParameter oldArrivalCity = new SqlParameter("@OldArrivalCityId", OldArrivalCityId); SqlParameter newArrivalCity = new SqlParameter("@NewArrivalCityId", newCity.GetId()); cmd.Parameters.Add(arrivalCityParameter); cmd.Parameters.Add(flightIdParameter); cmd.Parameters.Add(oldArrivalCity); cmd.Parameters.Add(newArrivalCity); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { this._arrivalCity = rdr.GetString(0); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } }