public ActionResult AddToMyFood(int id, int page)
{
var re = new Foodservices();
re.addFood_user(User.Identity.Name, id);
return(RedirectToAction("ALL", "Food", new { page = page }));
}
// GET: Myfood/Delete/5
public ActionResult Delete(int id, int page)
{
var re = new Foodservices();
re.removefood_user(User.Identity.Name, id);
return(RedirectToAction("index", new { page = page }));
}
public ActionResult AddRandomList(int food1, int food2, int food3)
{
var re = new Foodservices();
re.addFood_user(User.Identity.Name, food1);
re.addFood_user(User.Identity.Name, food2);
re.addFood_user(User.Identity.Name, food3);
return(View());
}
public ActionResult EditFood(int id, int page)
{
var re = new ReceptmodelsAddEditView();
var Foodlist = new Foodservices();
re = Foodlist.GetFoodForEditView("SELECT * FROM recept WHERE id_recept =@id_user", id);
ViewBag.page = page;
TempData["page"] = page;
return(View(re));
}
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);
}
public ActionResult AddNewFood(ReceptmodelsAddEditView model)
{
if (string.IsNullOrWhiteSpace(model.Url_pic))
{
model.Url_pic = "http://www.ica.se/imagevaultfiles/id_53491/cf_6901/ica_recept.png";
}
if (string.IsNullOrWhiteSpace(model.Url_recept))
{
model.Url_recept = "#";
}
var re = new Foodservices();
re.addNewFood(model.Name, model.Description, model.Url_pic, model.Url_recept, Convert.ToInt16(User.Identity.Name), model.Ica_id, model.TypeOfFoodId, model.Occasions, model.Rating, model.CookingtimeId);
return(RedirectToAction("ALL", "Food"));
}
public ActionResult EditFood(ReceptmodelsAddEditView model)
{
if (string.IsNullOrWhiteSpace(model.Url_pic))
{
model.Url_pic = "http://www.ica.se/imagevaultfiles/id_53491/cf_6901/ica_recept.png";
}
if (string.IsNullOrWhiteSpace(model.Url_recept))
{
model.Url_recept = "#";
}
int page = (int)TempData["page"];
model.CookingtimeId = Convert.ToInt16(Request.Form["cookingtime"]);
model.TypeOfFoodId = Convert.ToInt16(Request.Form["typeoffood"]);
var re = new Foodservices();
re.EditFood(model.Id, model.Name, model.Description, model.Url_pic, model.Url_recept, model.Ica_id, model.TypeOfFoodId, model.Occasions, model.Rating, model.CookingtimeId);
return(RedirectToAction("ALL", "Food", new { page = page }));
}
// 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));
}
