public void Remove(AirlineCompany t) { if (ExUserNameInAirLineCompanies(t.USER_NAME) == true) { using (SqlConnection conn = new SqlConnection(FlightCenterConfig.connectionString)) { SqlCommand cmd = new SqlCommand("RemoveAirLineCompany", conn); cmd.Connection.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@countryCode", t.COUNTRY_CODE)); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } else { Console.WriteLine($"There is no such a company - {t.AIRLINE_NAME}"); } }
public AirlineCompany Get(int id) // ? { AirlineCompany company = new AirlineCompany(); using (SqlConnection conn = new SqlConnection()) { SqlCommand cmd = new SqlCommand("GetAirLineById", conn); cmd.Connection.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Id", id)); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default); while (reader.Read() == true) { company.ID = (long)reader["ID"]; company.AIRLINE_NAME = (string)reader["AIRLINE_NAME"]; company.USER_NAME = (string)reader["USER_NAME"]; company.PASSWORD = (string)reader["PASSWORD"]; company.COUNTRY_CODE = (long)reader["COUNTRY_CODE"]; } cmd.Connection.Close(); } return(company); }