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); } }