public ActionResult MyRecipes(RecipeGridViewModel viewModel) { IQueryable <Recipe> recipes = db.Recipes; if (User.IsInRole(RolesConfig.USER)) { recipes = recipes.Where(r => r.User.UserName == User.Identity.Name); } if (viewModel.Query != null) { recipes = recipes.Where(r => r.RecipeName.Contains(viewModel.Query)); } if (viewModel.SortBy != null && viewModel.SortDirection != null) { recipes = recipes.OrderBy(string.Format("{0} {1}", viewModel.SortBy, viewModel.SortDirection)); } viewModel.Count = recipes.Count(); recipes = recipes.Skip((viewModel.Page - 1) * viewModel.PageSize).Take(viewModel.PageSize); //vrati podatke iz baze viewModel.Recipes = recipes.ToList(); return(View("MyRecipes", viewModel)); }
// GET: Recipes public ActionResult Index(RecipeGridViewModel viewModel) { if (Request.HttpMethod == "POST") { viewModel.Page = 1; } IQueryable <Recipe> recipes = db.Recipes; if (viewModel.Query != null) { recipes = recipes.Where(r => r.RecipeName.Contains(viewModel.Query)); } if (viewModel.SortBy != null && viewModel.SortDirection != null) { recipes = recipes.OrderBy(string.Format("{0} {1}", viewModel.SortBy, viewModel.SortDirection)); } ViewBag.Direction = viewModel.SortDirection == "ASC" ? "DESC" : "ASC"; viewModel.Count = recipes.Count(); recipes = recipes.Skip((viewModel.Page - 1) * viewModel.PageSize).Take(viewModel.PageSize); //vrati podatke iz baze viewModel.Recipes = recipes.ToList(); return(View(viewModel)); }
public ActionResult Index(RecipeGridViewModel viewModel, string kategorija) { IQueryable <Recipe> recipes = db.Recipes; if (kategorija != null) { recipes = recipes.Where(r => r.Category.CategoriesName == kategorija); } if (viewModel.Query != null) { recipes = recipes.Where(r => r.RecipeName.Contains(viewModel.Query)); } if (viewModel.SortBy != null && viewModel.SortDirection != null) { recipes = recipes.OrderBy(string.Format("{0} {1}", viewModel.SortBy, viewModel.SortDirection)); } viewModel.Count = recipes.Count(); recipes = recipes.Skip((viewModel.Page - 1) * viewModel.PageSize).Take(viewModel.PageSize); //vrati podatke iz baze viewModel.Recipes = recipes.ToList(); return(View(viewModel)); }