public ActionResult All(int?page, int?size) { int SizeofPage = 20; string search = "", cookingtime = "Över 60 minuter"; bool chicken = false, biff = false, fish = false, meat = false, pork = false, sausager = false, vego = false; if (size != null) { SizeofPage = size.Value; } var post = (IndexViewModel)Session["SearchFilter"]; var recept = new List <Receptmodels>(); var food = new Foodservices(); if (post != null) //!string.IsNullOrEmpty(search) { var sql = food.CreateSearchString(post.ChickenFilter, post.VegoFilter, post.FishFilter, post.BeefFilter, post.PorkFilter, post.SausageFilter, post.MeatFilter, post.OtherFilter, post.Sökord, post.Cookingtime); recept = food.GetFoodListForReceptView("SELECT * FROM public.recept_search_view" + sql, Convert.ToInt32(User.Identity.Name), post.Sökord); chicken = post.ChickenFilter; biff = post.BeefFilter; search = post.Sökord; fish = post.FishFilter; meat = post.MeatFilter; pork = post.PorkFilter; sausager = post.SausageFilter; vego = post.VegoFilter; cookingtime = post.Cookingtime; } else { recept = food.GetFoodListForReceptView("SELECT * FROM public.recept_search_view", Convert.ToInt32(User.Identity.Name), null); } ViewBag.Myfood = food.GetFood("SELECT * FROM recept WHERE id_recept IN (SELECT recept_id FROM users_has_recept WHERE user_id =@id_user)", Convert.ToInt32(User.Identity.Name)); ViewBag.food = recept; var pager = new Pager(recept.Count, page, SizeofPage); var viewModel = new IndexViewModel { Items = recept.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize), Pager = pager, Sökord = search, Size = SizeofPage, BeefFilter = biff, ChickenFilter = chicken, FishFilter = fish, MeatFilter = meat, PorkFilter = pork, SausageFilter = sausager, VegoFilter = vego, Cookingtime = cookingtime }; return(View(viewModel)); }
public ActionResult All(FormCollection form, int?size) { int SizeofPage = 20; if (size != null) { SizeofPage = size.Value; } var Sökord = Request.Form["Sökord"]; var cookingtime = Request.Form["cookingtime"]; var ChickenFilter = Convert.ToBoolean(Request.Form["ChickenFilter"].Split(',')[0]); var VegoFilter = Convert.ToBoolean(Request.Form["VegoFilter"].Split(',')[0]); var FishFilter = Convert.ToBoolean(Request.Form["FishFilter"].Split(',')[0]); var BeefFilter = Convert.ToBoolean(Request.Form["BeefFilter"].Split(',')[0]); var PorkFilter = Convert.ToBoolean(Request.Form["PorkFilter"].Split(',')[0]); var SausageFilter = Convert.ToBoolean(Request.Form["SausageFilter"].Split(',')[0]); var MeatFilter = Convert.ToBoolean(Request.Form["MeatFilter"].Split(',')[0]); var food = new Foodservices(); var recept = new List <Receptmodels>(); var sql = food.CreateSearchString(ChickenFilter, VegoFilter, FishFilter, BeefFilter, PorkFilter, SausageFilter, MeatFilter, false, Sökord, cookingtime); recept = food.GetFoodListForReceptView("SELECT * FROM public.recept_search_view" + sql, Convert.ToInt32(User.Identity.Name), Sökord); ViewBag.Myfood = food.GetFood("SELECT * FROM recept WHERE id_recept IN (SELECT recept_id FROM users_has_recept WHERE user_id =@id_user)", Convert.ToInt32(User.Identity.Name)); ViewBag.food = recept; var pager = new Pager(recept.Count, 1, SizeofPage); var viewModel = new IndexViewModel { Items = recept.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize), Pager = pager, Sökord = Sökord, Size = SizeofPage, BeefFilter = BeefFilter, ChickenFilter = ChickenFilter, FishFilter = FishFilter, MeatFilter = MeatFilter, PorkFilter = PorkFilter, SausageFilter = SausageFilter, VegoFilter = VegoFilter, Cookingtime = cookingtime }; Session["SearchFilter"] = viewModel; return(View(viewModel)); }