public bool UpdateFoodMenu(FoodMenu foodMenu) { conn.Open(); string query = string.Format("UPDATE FoodMenu SET FoodItem='{0}', FoodPrice= '{1}' WHERE FoodItem='{2}'", foodMenu.FoodItem, foodMenu.FoodPrice, foodMenu.FoodPrice); SqlCommand cmd = new SqlCommand(query, conn); int r = cmd.ExecuteNonQuery(); conn.Close(); if (r > 0) { return(true); } return(false); }
public FoodMenu GetFoodMenu(string foodItem) { conn.Open(); string quary = string.Format("SELECT * FROM FoodMenu WHERE FoodItem='{0}'", foodItem); SqlCommand cmd = new SqlCommand(quary, conn); SqlDataReader reader = cmd.ExecuteReader(); FoodMenu foodMenu = null; while (reader.Read()) { FoodMenu foodmenu = new FoodMenu(); foodmenu.Id = reader.GetInt32(reader.GetOrdinal("Id")); foodmenu.FoodItem = reader.GetString(reader.GetOrdinal("FoodItem")); foodmenu.FoodPrice = reader.GetString(reader.GetOrdinal("FoodPrice")); } conn.Close(); return(foodMenu); }
public ArrayList GetFoodInfo() { ArrayList foodmenus = new ArrayList(); conn.Open(); string query = "SELECT * FROM FoodMenu"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { FoodMenu foodmenu = new FoodMenu(); foodmenu = new FoodMenu(); foodmenu.Id = reader.GetInt32(reader.GetOrdinal("Id")); foodmenu.FoodItem = reader.GetString(reader.GetOrdinal("FoodItem")); foodmenu.FoodPrice = reader.GetString(reader.GetOrdinal("FoodPrice")); foodmenus.Add(foodmenu); } conn.Close(); return(foodmenus); }