public List <DishQuantity> GetAllDishes() { List <DishQuantity> order = new List <DishQuantity> { }; MySqlConnection conn = DB.Connection(); conn.Open(); //MySqlCommand cmd = new MySqlCommand("SELECT dishes.* FROM orders JOIN dishes ON (orders.dish_id=dishes.id) WHERE orders.table_order_id=@id", conn); MySqlCommand cmd = new MySqlCommand("SELECT dishes.*, orders.dish_quantity FROM orders JOIN dishes ON (orders.dish_id=dishes.id) WHERE orders.table_order_id=@id ORDER BY dishes.name", conn); cmd.Parameters.Add(new MySqlParameter("@id", Id)); MySqlDataReader rdr = cmd.ExecuteReader(); string name = ""; int dishId = 0; int quantity = 0; while (rdr.Read()) { dishId = rdr.GetInt32(0); name = rdr.GetString(1); quantity = rdr.GetInt32(2); Dish newDish = new Dish(name, dishId); DishQuantity newDishQuantity = new DishQuantity(newDish, quantity); order.Add(newDishQuantity); } conn.Close(); if (conn != null) { conn.Dispose(); } return(order); }
public override bool Equals(System.Object otherDishQuantity) { if (!(otherDishQuantity is DishQuantity)) { return(false); } else { DishQuantity newDishQuantity = (DishQuantity)otherDishQuantity; bool dishEquality = this.GetDish().Equals(newDishQuantity.GetDish()); bool quantityEquality = this.GetQuantity().Equals(newDishQuantity.GetQuantity()); return(dishEquality && quantityEquality); } }