public ActionResult RoleDelete(int id) { Session_CRM sess = (Session_CRM)Session["CRM_Session"]; string msg = ""; try { AT_Role role = db.AT_Role.Where(x => x.RoleID == id).FirstOrDefault(); if (role != null) { if (db.AT_Users.Where(x => x.RoleID == role.RoleID && x.IsDeleted != true).Count() > 0) { return(Json("Conflict")); } //role.RoleID = id; //role.IsDeleted = true; //role.UpdateBy = sess.User.UserID; //role.UpdateDate = DateTime.Now; //db.AT_Role.Attach(role); db.AT_RolePermissionJunc.RemoveRange(db.AT_RolePermissionJunc.Where(x => x.RoleID == role.RoleID)); db.AT_Role.Remove(role); db.SaveChanges(); msg = "Role deleted successfully!"; } } catch (Exception ex) { msg = ex.Message; } ViewBag.msg = msg; return(PartialView("_RoleIndex", db.AT_Role.Where(x => x.IsDeleted != true).ToList())); }
public ActionResult _RoleSave(AT_Role role) { Session_CRM sess = (Session_CRM)Session["CRM_Session"]; string msg = ""; try { if (role.RoleID > 0) { if (role.IsActive != true) { if (db.AT_Users.Where(x => x.RoleID == role.RoleID && x.IsDeleted != true).Count() > 0) { return(Json("Conflict")); } } role.UpdateBy = sess.User.UserID; role.UpdateDate = DateTime.Now; db.AT_Role.Attach(role); db.UpdateExcept <AT_Role>(role, x => x.CreateBy, x => x.CreateDate); } else { role.CreateBy = sess.User.UserID; role.CreateDate = DateTime.Now; db.Entry(role).State = System.Data.Entity.EntityState.Added; } db.SaveChanges(); msg = "Role saved successfully!"; } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.ToString().Contains("UNIQUE")) { msg = "Conflict"; } else { msg = ex.Message; } } ViewBag.msg = msg; return(PartialView("_RoleIndex", db.AT_Role.Where(x => x.IsDeleted != true).ToList())); }