public void UpdateFood(int id, string name, decimal price, BFoodCategory foodCategory) { BFood food = new BFood(id, name, price, foodCategory); FoodController foodController = new FoodController(); foodController.UpdateFood(food); }
public void CreateFood(string name, decimal price, int foodCategoryId, BFoodCategory foodCategory) { BFood food = new BFood(name, price, foodCategoryId, foodCategory); FoodController foodController = new FoodController(); foodController.CreateFood(food); }
public List <BFood> GetAllFoodCat() { List <BFood> foods = new List <BFood>(); BFood tempF; BFoodCategory tempFC; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "select fo.id as id, fo.name, fo.price, fo.foodCategoryId, fc.id as category, fc.name as foodCategoryName from Food fo RIGHT OUTER JOIN FoodCategory fc ON fo.foodCategoryId = fc.id"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tempF = new BFood(); tempFC = new BFoodCategory(); tempF.Id = reader.GetInt32(reader.GetOrdinal("id")); tempF.Name = reader.GetString(reader.GetOrdinal("name")); tempF.Price = reader.GetDecimal(reader.GetOrdinal("price")); tempF.FoodCategoryId = reader.GetInt32(reader.GetOrdinal("foodCategoryId")); tempFC.Id = reader.GetInt32(reader.GetOrdinal("category")); tempFC.Name = reader.GetString(reader.GetOrdinal("foodCategoryName")); tempF.FoodCategory = tempFC; foods.Add(tempF); } } } return(foods); }
public List <BFood> GetAllFood() { List <BFood> foods = new List <BFood>(); BFood tempF; BFoodCategory tempFC; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "select food.id as fid, food.name as fname, food.price as price, foodcategory.id as id, FoodCategory.name as name from Food, FoodCategory where Food.foodCategoryID = FoodCategory.id"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tempF = new BFood(); tempFC = new BFoodCategory(); tempF.Id = reader.GetInt32(reader.GetOrdinal("fid")); tempF.Name = reader.GetString(reader.GetOrdinal("fname")); tempF.Price = reader.GetDecimal(reader.GetOrdinal("price")); tempFC.Id = reader.GetInt32(reader.GetOrdinal("id")); tempFC.Name = reader.GetString(reader.GetOrdinal("name")); tempF.FoodCategory = tempFC; foods.Add(tempF); } } } return(foods); }
public List <BFoodCategory> GetAllFoodCat2() { List <BFoodCategory> foodCats = new List <BFoodCategory>(); BFoodCategory tempFC; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "select FoodCategory.id, FoodCategory.name from FoodCategory;"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tempFC = new BFoodCategory(); tempFC.Id = reader.GetInt32(reader.GetOrdinal("id")); tempFC.Name = reader.GetString(reader.GetOrdinal("name")); foodCats.Add(tempFC); } } } return(foodCats); }