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