public void Update(AirlineCompany t)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = ConfigApp.ConnectionString;
cmd.Connection.Open();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"UPDATE AirlineCompany SET Name='{t.Name}',Country_Id={t.Country_Id},User_Id={t.User_Id} WHERE Id={t.Id}";
cmd.ExecuteNonQuery();
}
}
public void Add(AirlineCompany a)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = ConfigApp.ConnectionString;
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreateAirlineCompany";
cmd.Parameters.AddWithValue("@Name", a.Name);
cmd.Parameters.AddWithValue(" @Country_Id", a.Country_Id);
cmd.Parameters.AddWithValue(" @User_Id", a.User_Id);
cmd.ExecuteNonQuery();
}
}
public void UpdateAirlineDetails(LoginToken <Administrators> token, AirlineCompany customer)
{
throw new NotImplementedException();
}
public void RemoveAirline(LoginToken <Administrators> token, AirlineCompany airline)
{
throw new NotImplementedException();
}