public IActionResult GetFavRecipes(int id) { var myRecipePntrs = from recipePtr in _context.UserRecipeFavorite where recipePtr.UserId == id && recipePtr.Favorite == true select recipePtr; var tempList = myRecipePntrs.ToList(); List <UserRecipeVM> myRecipes = new List <UserRecipeVM>(); foreach (UserRecipeFavorite recipePtr in tempList) { var recipeObj = new Recipe(); recipeObj = _context.Recipes.FirstOrDefault(r => r.Id == recipePtr.RecipeId); var recipe = new UserRecipeVM(); recipe.UserId = recipePtr.UserId; recipe.RecipeId = recipePtr.RecipeId; recipe.Favorite = recipePtr.Favorite; recipe.RecipeName = recipeObj.RecipeName; recipe.Description = recipeObj.Description; recipe.OwnerId = recipeObj.OwnerId; recipe.Shared = recipeObj.Shared; recipe.Notes = recipeObj.Notes; recipe.MyRating = recipeObj.MyRating; recipe.ShareRating = recipeObj.ShareRating; recipe.NumShareRatings = recipeObj.NumShareRatings; recipe.RecipePic = recipeObj.RecipePic; recipe.PrepTime = recipeObj.PrepTime; recipe.CookTime = recipeObj.CookTime; recipe.RecipeServings = recipeObj.RecipeServings; recipe.ServingSize = recipeObj.ServingSize; myRecipes.Add(recipe); } if (myRecipes.Count() == 0) { return(NotFound()); } return(new ObjectResult(myRecipes)); }
public IActionResult GetSharedRecipes(int userId) { //var userId = 240; List <Recipe> tempSharedList = new List <Recipe>(); //if (searchStr != null) //{ // var tmpSharedRecipes = from recipe in _context.Recipes // where (recipe.Description.Contains('%' + searchStr + '%')) // select recipe; // tempSharedList = tmpSharedRecipes.ToList(); //} //else //{ var tmpSharedRecipes = from recipe in _context.Recipes where recipe.Shared == true select recipe; tempSharedList = tmpSharedRecipes.ToList(); //var tempSharedList = tmpSharedRecipes.ToList(); //} List <UserRecipeVM> sharedRecipes = new List <UserRecipeVM>(); foreach (Recipe recipePtr in tempSharedList) { var recipe = new UserRecipeVM(); var recipeObj = new UserRecipeFavorite(); recipeObj = _context.UserRecipeFavorite.FirstOrDefault(u => u.RecipeId == recipePtr.Id && u.UserId == userId); if (recipeObj != null) { recipe.Favorite = recipeObj.Favorite; } else { recipe.Favorite = false; } recipe.UserId = userId; recipe.RecipeId = recipePtr.Id; recipe.RecipeName = recipePtr.RecipeName; recipe.Description = recipePtr.Description; recipe.OwnerId = recipePtr.OwnerId; recipe.Shared = recipePtr.Shared; recipe.Notes = recipePtr.Notes; recipe.MyRating = recipePtr.MyRating; recipe.ShareRating = recipePtr.ShareRating; recipe.NumShareRatings = recipePtr.NumShareRatings; recipe.RecipePic = recipePtr.RecipePic; recipe.PrepTime = recipePtr.PrepTime; recipe.CookTime = recipePtr.CookTime; recipe.RecipeServings = recipePtr.RecipeServings; recipe.ServingSize = recipePtr.ServingSize; sharedRecipes.Add(recipe); } if (sharedRecipes.Count() == 0) { return(NotFound()); } return(new ObjectResult(sharedRecipes)); }