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