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));
}
