public ActionResult DeleteConfirmed(int id) { tbl_recipe tbl_recipe = db.tbl_recipe.Find(id); db.tbl_recipe.Remove(tbl_recipe); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "r_id,r_name,r_desc,userid,Admin_Reply,fl_ref")] tbl_recipe tbl_recipe) { if (ModelState.IsValid) { db.Entry(tbl_recipe).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.fl_ref = new SelectList(db.tbl_flavour, "fl_id", "fl_name", tbl_recipe.fl_ref); ViewBag.userid = new SelectList(db.TBL_USER, "u_id", "u_name", tbl_recipe.userid); return(View(tbl_recipe)); }
// GET: Recipe/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_recipe tbl_recipe = db.tbl_recipe.Find(id); if (tbl_recipe == null) { return(HttpNotFound()); } return(View(tbl_recipe)); }
// GET: Recipe/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_recipe tbl_recipe = db.tbl_recipe.Find(id); if (tbl_recipe == null) { return(HttpNotFound()); } ViewBag.fl_ref = new SelectList(db.tbl_flavour, "fl_id", "fl_name", tbl_recipe.fl_ref); ViewBag.userid = new SelectList(db.TBL_USER, "u_id", "u_name", tbl_recipe.userid); return(View(tbl_recipe)); }
public ActionResult ReplyforRecipe() { var joinresult = db.tbl_recipe.Join(db.TBL_USER, b => b.userid, p => p.u_id, (b, p) => new { b.r_id, b.r_desc, b.r_name, b.fl_ref }); List <tbl_recipe> recipe = new List <tbl_recipe>(); //for(int i=0;i<result.Count();i++) foreach (var item in joinresult) { tbl_recipe tempbug = new tbl_recipe(); tempbug.r_id = item.r_id; tempbug.r_name = item.r_name; tempbug.r_desc = item.r_desc; // tempbug.f_contact = item.f_contact; //tempbug.f_text = item.f; // tempbug.Admin_Reply = item.Admin_Reply; recipe.Add(tempbug); } return(View(recipe)); }