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)); }
public List <Receptmodels> Slumplist(int user_id, DateTime date) { date = datefixer(date); List <Receptmodels> food_list = new List <Receptmodels>(); Receptmodels re = new Receptmodels(); var recpet = new Foodservices(); food_list = recpet.GetFood("SELECT * FROM recept WHERE id_recept IN (SELECT recept_id FROM users_has_recept WHERE user_id =@id_user)", user_id); int maxdays = 5; int maxnumber = food_list.Count; Random rnd = new Random(); List <Receptmodels> random_list = new List <Receptmodels>(); int i = 0; bool check = true; if (maxnumber > 7) { while (i < maxdays) { check = true; int number = rnd.Next(1, maxnumber); foreach (var item in random_list) { if (item.Id == food_list[number].Id) { check = false; } } if (check) { food_list[number].Date = date; random_list.Add(food_list[number]); i++; date = date.AddDays(1); } } } if (maxnumber <= 7) { re.Id = -10; re.Name = "Inte tillräckligt med maträtter för att slumpa fram en vecka!!!"; random_list.Add(re); } return(random_list); }
// GET: Myfood public ActionResult Index(int?page, int?size) { int SizeofPage = 20; if (size != null) { SizeofPage = size.Value; } var food_list = new List <Receptmodels>(); var re = new Foodservices(); food_list = re.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)); var pager = new Pager(food_list.Count, page, SizeofPage); var viewModel = new IndexViewModel { Items = food_list.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize), Pager = pager, Size = SizeofPage }; return(View(viewModel)); }