public static RecipeModel GetRecipes(int id)
{
using (Mbl_Model ctx = new Mbl_Model())
{
var recipe = ctx.Recipes.SingleOrDefault(a => a.RecipeId == id);
if (recipe != null)
{
var recipeModel = new RecipeModel
{
id = recipe.RecipeId,
name = recipe.RecipeName,
instructions = recipe.PreparationMethod
};
recipeModel.ingredients = (from p in ctx.Ingredients
join p1 in ctx.MeasurementUnits on p.MeasurementUnitId equals p1.UnitId
where p.RecipeId == id
select new RecipeIngrediant {
name = p.Food.FoodName,
quantity = p.Quantity,
unitName = p1.UnitName
}).ToList();
return(recipeModel);
}
;
return(null);
}
}
public static List <RecipeModel> GetRecipesByName(string name)
{
using (Mbl_Model ctx = new Mbl_Model())
{
var recipes = ctx.Recipes.Where(a => a.RecipeName.Contains(name)).Take(100).Select(x => new RecipeModel
{
id = x.RecipeId,
name = x.RecipeName
});
return(recipes.ToList());
}
}
public static List <RecipeModel> GetRecipes()
{
using (Mbl_Model ctx = new Mbl_Model())
{
var recipes = ctx.Recipes.OrderByDescending(x => x.CreatedDate).Select(x => new RecipeModel
{
id = x.RecipeId,
name = x.RecipeName,
displayName = x.Users.DisplayName,
categories = x.Categories.Select(cat => cat.CategoryName).ToList()
});
return(recipes.ToList());
}
}