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