public List <AirlineService> GetAirlineServices()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT airline_services_id FROM airline_services_flights WHERE flights_id = @FlightId;", conn);
SqlParameter flightIdParameter = new SqlParameter();
flightIdParameter.ParameterName = "@FlightId";
flightIdParameter.Value = this.GetId();
cmd.Parameters.Add(flightIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
List <int> airlineServiceIds = new List <int> {
};
while (rdr.Read())
{
int airlineServiceId = rdr.GetInt32(0);
airlineServiceIds.Add(airlineServiceId);
}
if (rdr != null)
{
rdr.Close();
}
List <AirlineService> airlineServices = new List <AirlineService> {
};
foreach (int airlineServiceId in airlineServiceIds)
{
SqlCommand airlineServiceQuery = new SqlCommand("SELECT * FROM airline_services WHERE id = @AirlineServiceId;", conn);
SqlParameter airlineServiceIdParameter = new SqlParameter();
airlineServiceIdParameter.ParameterName = "@AirlineServiceId";
airlineServiceIdParameter.Value = airlineServiceId;
airlineServiceQuery.Parameters.Add(airlineServiceIdParameter);
SqlDataReader queryReader = airlineServiceQuery.ExecuteReader();
while (queryReader.Read())
{
int thisAirlineServiceId = queryReader.GetInt32(0);
string airlineServiceName = queryReader.GetString(1);
AirlineService foundAirlineService = new AirlineService(airlineServiceName, thisAirlineServiceId);
airlineServices.Add(foundAirlineService);
}
if (queryReader != null)
{
queryReader.Close();
}
}
if (conn != null)
{
conn.Close();
}
return(airlineServices);
}
public void AddAirlineService(AirlineService newAirlineService)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO airline_services_flights (airline_services_id, flights_id) VALUES (@AirlineServiceId, @FlightId);", conn);
SqlParameter airlineServiceIdParameter = new SqlParameter();
airlineServiceIdParameter.ParameterName = "@AirlineServiceId";
airlineServiceIdParameter.Value = newAirlineService.GetId();
cmd.Parameters.Add(airlineServiceIdParameter);
SqlParameter flightIdParameter = new SqlParameter();
flightIdParameter.ParameterName = "@FlightId";
flightIdParameter.Value = this.GetId();
cmd.Parameters.Add(flightIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public static List <AirlineService> GetAll()
{
List <AirlineService> allAirlineServices = new List <AirlineService> {
};
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM airline_services;", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int airlineServiceId = rdr.GetInt32(0);
string airlineServiceName = rdr.GetString(1);
AirlineService newAirlineService = new AirlineService(airlineServiceName, airlineServiceId);
allAirlineServices.Add(newAirlineService);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(allAirlineServices);
}
public static AirlineService Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM airline_services WHERE id = @AirlineServiceId;", conn);
SqlParameter airlineServiceIdParameter = new SqlParameter();
airlineServiceIdParameter.ParameterName = "@AirlineServiceId";
airlineServiceIdParameter.Value = id.ToString();
cmd.Parameters.Add(airlineServiceIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int foundAirlineServiceId = 0;
string foundAirlineServiceName = null;
while (rdr.Read())
{
foundAirlineServiceId = rdr.GetInt32(0);
foundAirlineServiceName = rdr.GetString(1);
}
AirlineService foundAirlineService = new AirlineService(foundAirlineServiceName, foundAirlineServiceId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundAirlineService);
}
public override bool Equals(System.Object otherAirlineService)
{
if (!(otherAirlineService is AirlineService))
{
return(false);
}
else
{
AirlineService newAirlineService = (AirlineService)otherAirlineService;
bool idEquality = this.GetId() == newAirlineService.GetId();
bool nameEquality = this.GetName() == newAirlineService.GetName();
return(idEquality && nameEquality);
}
}
