public ReceptmodelsAddEditView GetFoodForEditView(string psql, int pid_user)
{
postgres m = new postgres();
DataTable dt = new DataTable();
dt = m.SqlQuery(psql, postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id_user", pid_user)
});
ReceptmodelsAddEditView r = new ReceptmodelsAddEditView();
foreach (DataRow dr in dt.Rows)
{
r.Id = (int)dr["id_recept"];
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.Ica_id = (int)dr["ica_id"];
r.CookingtimeId = (int)dr["cookingtime_id"];
r.TypeOfFoodId = (int)dr["type_of_food_id"];
r.Occasions = (int)dr["occasion_id"];
r.Rating = (double)dr["average_rating"];
}
return(r);
}
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 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 }));
}
