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