public static List <Cuisine> GetAll() { List <Cuisine> allTypes = new List <Cuisine> { }; MySqlCnnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM cuisine;"; MySqlDataeader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { string cuisineName = rdr.GetString(0); string cuisineDescription = rdr.GetString(1); int cuisineId = GetInt32(2); Cuisine newCuisine = new Cuisine(cuisineName, cuisineDescription, cuisineId); allTypes.Add(newCuisine); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allPlaces); }
public static List <Restaurant> GetAll() { List <Restaurant> allPlaces = new List <Restaurant> { }; MySqlCnnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM restaurant;"; MySqlDataeader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { string restaurantName = rdr.GetString(0); int restaurantCuisineId = rdr.GetInt32(1); string restaurantCuisine = rdr.GetString(2); int restaurantId = GetInt32(3); Restaurant newRestaurant = new Restaurant(restaurantName, restaurantCuisineId, restaurantCuisine, restaurantId); allPlaces.Add(newRestaurant); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allPlaces); }