public static CityFood FindById(int searchId)
{
int id = 0;
int cityID = 0;
int foodID = 0;
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM cities_food WHERE id = @idMatch;";
MySqlParameter parameterId = new MySqlParameter();
parameterId.ParameterName = "@idMatch";
parameterId.Value = searchId;
cmd.Parameters.Add(parameterId);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
id = rdr.GetInt32(0);
cityID = rdr.GetInt32(1);
foodID = rdr.GetInt32(2);
}
CityFood foundCityFood = new CityFood(cityID, foodID, id);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundCityFood);
}
public static List <CityFood> GetAll()
{
List <CityFood> newCityActivities = new List <CityFood> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM cities_food;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
int cityID = rdr.GetInt32(1);
int foodID = rdr.GetInt32(2);
CityFood newCityFood = new CityFood(cityID, foodID, id);
newCityActivities.Add(newCityFood);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(newCityActivities);
}
public override bool Equals(System.Object otherCityFood)
{
if (!(otherCityFood is CityFood))
{
return(false);
}
else
{
CityFood newCityFood = (CityFood)otherCityFood;
bool idEquality = (this.GetId() == newCityFood.GetId());
bool cityIDEquality = (this.GetCityID() == newCityFood.GetCityID());
bool foodIDEquality = (this.GetFoodID() == newCityFood.GetFoodID());
return(idEquality && cityIDEquality && foodIDEquality);
}
}
