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