public List <Receptmodels> GetFood(string psql, int pid_user)
{
postgres m = new postgres();
DataTable dt = new DataTable();
List <Receptmodels> mt = new List <Receptmodels>();
dt = m.SqlQuery(psql, postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id_user", pid_user)
});
foreach (DataRow dr in dt.Rows)
{
Receptmodels r = new Receptmodels();
r.Id = Convert.ToInt16(dr["id_recept"].ToString());
r.Name = dr["name"].ToString();
r.Description = (string)dr["description"];
r.Url_pic = (string)dr["url_pic"];
r.Url_recept = (string)dr["url_recept"];
mt.Add(r);
}
return(mt);
}
public ActionResult AddRandomList(int food1, int food2, int food3)
{
var re = new Receptmodels();
_foodServices.AddFoodToUser(User.Identity.Name, food1);
_foodServices.AddFoodToUser(User.Identity.Name, food2);
_foodServices.AddFoodToUser(User.Identity.Name, food3);
return(View());
}
public ActionResult AddNewFood(Receptmodels 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 = "#";
}
_foodservice.AddNewFood(model.Name, model.Description, model.Url_pic, model.Url_recept, Convert.ToInt16(User.Identity.Name));
return(RedirectToAction("ALL", "Food"));
}
public List <Receptmodels> Slumplist(int user_id, DateTime date)
{
date = datefixer(date);
List <Receptmodels> food_list = new List <Receptmodels>();
Receptmodels re = new Receptmodels();
food_list = _foodServices.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;
food_list[number].DateName = NameOfDay(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 EditFood(int id, int page)
{
Receptmodels re = new Receptmodels();
re.Recept = _foodservice.GetFood("SELECT * FROM recept WHERE id_recept =@id_user", id);
re.Id = re.Recept[0].Id;
re.Name = re.Recept[0].Name;
re.Url_pic = re.Recept[0].Url_pic;
re.Url_recept = re.Recept[0].Url_recept;
re.Description = re.Recept[0].Description;
ViewBag.page = page;
TempData["page"] = page;
return(View(re));
}
public ActionResult EditFood(Receptmodels 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"];
_foodservice.EditFood(model.Id, model.Name, model.Description, model.Url_pic, model.Url_recept);
return(RedirectToAction("ALL", "Food", new { page = page }));
}
public void EmailslumplistTest()
{
var list = new List <Receptmodels>();
var recept = new Receptmodels();
recept.Name = "Laxröra";
recept.Url_pic = "1480.jpg";
recept.Date = DateTime.Now;
list.Add(recept);
var body = Email.Emailslumplist("nicklas", "Hej hej de funkar bra", list);
Email.SendEmail("*****@*****.**", "nicklas", "test", body);
Assert.IsNotNull(body);
}
public ActionResult Create(Receptmodels model)
{
int user = Convert.ToInt16(User.Identity.Name);
model.Recept = (List <Receptmodels>)TempData["receptlista"];
slump checkslump = new slump();
bool check = checkslump.Checkslump(model.Recept[0].Date, user);
foreach (var item in model.Recept)
{
slump slump = new slump();
slump.SaveSlump(item.Id, user, item.Date, check);
}
return(RedirectToAction("Index"));
}
// GET: Slumpiator/Create
public ActionResult Create(DateTime date)
{
if (date == null)
{
RedirectToAction("Index");
}
slump slumpe = new slump();
Receptmodels re = new Receptmodels();
re.Recept = slumpe.Slumplist(Convert.ToInt32(User.Identity.Name), date);
ViewBag.check = re.Recept[0].Id;
TempData["receptlista"] = re.Recept;
ViewBag.date = slump.GetIso8601WeekOfYear(date);
return(View(re));
}
public ActionResult Create(int id)
{
DateTime date = DateTime.Now;
if (id == 7)
{
date = date.AddDays(7);
}
Receptmodels re = new Receptmodels();
re.Recept = _slumpServices.Slumplist(Convert.ToInt32(User.Identity.Name), date);
ViewBag.check = re.Recept[0].Id;
ViewBag.date = _slumpServices.GetIso8601WeekOfYear(date);
return(View(re));
}
public List <Receptmodels> GetFoodListForReceptView(string psql, int pid_user, string search)
{
postgres m = new postgres();
DataTable dt = new DataTable();
List <Receptmodels> mt = new List <Receptmodels>();
if (!string.IsNullOrEmpty(search))
{
string modal = "%";
dt = m.SqlQuery(psql, postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id_user", pid_user),
new NpgsqlParameter("@search", modal += search += "%")
});
}
else
{
dt = m.SqlQuery(psql, postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id_user", pid_user)
});
}
foreach (DataRow dr in dt.Rows)
{
Receptmodels r = new Receptmodels();
r.Id = Convert.ToInt16(dr["id_recept"].ToString());
r.Name = dr["name"].ToString();
r.Description = (string)dr["description"];
r.Url_pic = (string)dr["url_pic"];
r.Url_recept = (string)dr["url_recept"];
r.cookingtime = (string)dr["time_name"];
r.TypeOfFood = (string)dr["type_name"];
r.Occasions = dr["occasion_id"].ToString();
r.Rating = (double)dr["average_rating"];
mt.Add(r);
}
return(mt);
}
public List <Receptmodels> Oldslumps(int user_id, DateTime date, DateTime dateto)
{
// Slump Slump = new Slump();
postgres m = new postgres();
List <Receptmodels> mt = new List <Receptmodels>();
DataTable dt = new DataTable();
dt = m.SqlQuery("SELECT foodlist.date_now,foodlist.recept_id,recept.name,recept.description,recept.url_pic,recept.url_recept, cookingtime.time_name, type_of_food.type_name, recept.average_rating,recept.occasion_id FROM public.foodlist join public.recept on foodlist.recept_id = recept.id_recept LEFT JOIN type_of_food ON recept.type_of_food_id = type_of_food.id LEFT JOIN cookingtime ON recept.cookingtime_id = cookingtime.id Where foodlist.user_id = @id_user AND date_now BETWEEN @datefrom AND @dateto ORDER BY date_now DESC; ", postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id_user", user_id),
new NpgsqlParameter("@dateto", dateto),
new NpgsqlParameter("@datefrom", date)
});
foreach (DataRow dr in dt.Rows)
{
Receptmodels r = new Receptmodels();
r.Id = (int)dr["recept_id"];
r.Name = dr["name"].ToString();
r.Date = (DateTime)dr["date_now"];
r.Description = (string)dr["description"];
r.Url_pic = (string)dr["url_pic"];
r.Url_recept = (string)dr["url_recept"];
r.cookingtime = (string)dr["time_name"];
r.TypeOfFood = (string)dr["type_name"];
r.Occasions = dr["occasion_id"].ToString();
r.Rating = (double)dr["average_rating"];
// var dateName = new Slumpservices();
r.DateName = NameOfDay(r.Date);
r.Weeknumbers = GetIso8601WeekOfYear(r.Date).ToString();
mt.Add(r);
}
return(mt);
}
