public ActionResult AgentDelete(int id) { Session_CRM sess = (Session_CRM)Session["CRM_Session"]; string msg = ""; AT_Users usr = db.AT_Users.Where(x => x.UserID == id).FirstOrDefault(); try { if (usr != null) { usr.IsDeleted = true; usr.UpdateBy = sess.User.UserID; usr.UpdateDate = DateTime.Now; db.AT_Users.Attach(usr); db.UpdateOnly <AT_Users>(usr, x => x.IsDeleted, x => x.UpdateBy, x => x.UpdateDate); db.SaveChanges(); msg = "User Successfully Deleted."; } } catch (Exception ex) { msg = ex.Message; } db = new HRMSEntities(); ViewBag.msg = msg; return(PartialView("_AgentIndex", db.AT_Users.Where(a => a.IsDeleted != true).ToList())); }