public void Test_Find_FindsFlightInDatabase()
{
DateTime departing_time= new DateTime(2016,06,05);
DateTime returning_time = new DateTime(2016, 1, 1);
Flight testFlight = new Flight("E201","On time",departing_time,returning_time);
testFlight.Save();
Flight foundFlight = Flight.Find(testFlight.GetId());
Assert.Equal(testFlight, foundFlight);
}
public void Test_Save_AssignsIdToObject()
{
DateTime departing_time= new DateTime(2016,06,05);
DateTime returning_time = new DateTime(2016, 1, 1);
Flight testFlight = new Flight("E201","On time",departing_time,returning_time);
testFlight.Save();
Flight savedFlight = Flight.GetAll()[0];
int result=savedFlight.GetId();
int testId=testFlight.GetId();
Assert.Equal(testId,result);
}
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();
}
}
