public ActionResult Deletestaff(string button) { var userid = Session["userid"].ToString(); using (Models.masterEntities1 db = new Models.masterEntities1()) { var update = db.todolist.Where(x => x.staffid.ToString() == button).FirstOrDefault(); update.statu = "1"; db.SaveChanges(); return(RedirectToAction("Todolist")); } }
// GET: Todolist public ActionResult TodoList() { var userid = Session["userid"].ToString(); using (Models.masterEntities1 db = new Models.masterEntities1()) { var dolist = db.todolist.SqlQuery("select * from todolist where userid = '" + userid + "' and statu = '0'").ToList(); ViewBag.todolist = dolist; return(View()); } }
public ActionResult Addnewstaff(string addnewstaff) { Models.todolist todo = new Models.todolist { userid = Session["userid"].ToString(), staff = addnewstaff, statu = "0" }; using (Models.masterEntities1 db = new Models.masterEntities1()) { db.todolist.Add(todo); db.SaveChanges(); } return(RedirectToAction("Todolist")); }