public void T4_Save_AssignsIdToCagetoryObject()
{
//Arrange
City testCity = new City("Seattle","WA","USA");
testCity.Save();
//Act
City savedCity = City.GetAll()[0];
int result = savedCity.GetId();
int testId = testCity.GetId();
//Assert
Assert.Equal(testId, result);
}
public void T5_Find_FindsCityInDatabase()
{
//Arrange
City testCity = new City("Seattle","WA","USA");
testCity.Save();
//Act
City foundCity = City.Find(testCity.GetId());
//Assert
Assert.Equal(testCity, foundCity);
}
public void AddCity(City departCity,City arrivalCity)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO flights_cities (flight_id,departing_city_id,returning_city_id) VALUES (@FlightId, @DepartCityId,@ArrivalCityId);", conn);
SqlParameter flightIdParameter = new SqlParameter();
flightIdParameter.ParameterName = "@FlightId";
flightIdParameter.Value = this.GetId();
cmd.Parameters.Add(flightIdParameter);
SqlParameter departCityParameter = new SqlParameter();
departCityParameter.ParameterName = "@DepartCityId";
departCityParameter.Value = departCity.GetId();
cmd.Parameters.Add(departCityParameter);
SqlParameter arrivalCityParameter = new SqlParameter();
arrivalCityParameter.ParameterName = "@ArrivalCityId";
arrivalCityParameter.Value = arrivalCity.GetId();
cmd.Parameters.Add(arrivalCityParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void AddFlyingFromFlight(Flight newFlight, City FlyingToCity)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO flights_cities(flight_id,departing_city_id,returning_city_id) VALUES(@FlightId,@DepartCityId,@ReturningCityId);",conn);
SqlParameter newFlightIdParameter = new SqlParameter();
newFlightIdParameter.ParameterName = "@FlightId";
newFlightIdParameter.Value=newFlight.GetId();
cmd.Parameters.Add(newFlightIdParameter);
SqlParameter departCityIdParameter = new SqlParameter();
departCityIdParameter.ParameterName="@DepartCityId";
departCityIdParameter.Value=this.GetId();
cmd.Parameters.Add(departCityIdParameter);
SqlParameter ReturningCityIdParameter = new SqlParameter();
ReturningCityIdParameter.ParameterName="@ReturningCityId";
ReturningCityIdParameter.Value=FlyingToCity.GetId();
cmd.Parameters.Add(ReturningCityIdParameter);
cmd.ExecuteNonQuery();
if(conn != null)
{
conn.Close();
}
}