public ActionResult Edit(long id) { try{ ViewBag.Head = "Roles - Edit"; Models.RoleModel rle = new Models.RoleModel(); CLayer.Role rp = BLayer.RolePermissions.GetRole(id); rle.Id = rp.Id; rle.Name = rp.Name; rle.PermissionIds = ""; rle.Permissions = BLayer.RolePermissions.GetAllPermissions((int)id); foreach (CLayer.RolePermission r in rle.Permissions) { if (!r.HasAccess) { if (rle.PermissionIds == "") { rle.PermissionIds = r.ModuleId.ToString(); } else { rle.PermissionIds = rle.PermissionIds + "," + r.ModuleId.ToString(); } } } return(View(rle)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public long SaveRole(CLayer.Role role) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pId", DataPlug.DataType._Varchar, role.Id)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, role.Name)); object val = Connection.ExecuteQueryScalar("role_Save", param); return(Connection.ToLong(val)); }
public ActionResult Save(Models.RoleModel data) { try { CLayer.Role rp = new CLayer.Role(); rp.Id = data.Id; rp.Name = data.Name; long roleId = BLayer.RolePermissions.SaveRole(rp); string ids = data.PermissionIds; if (ids == null) { ids = ""; } if (ids != "") { ids = ids.Trim(); } if (ids == "") { BLayer.RolePermissions.ClearBlockedPermissions(roleId); } else { string[] id = ids.Split(new char[] { ',' }); List <int> pids = new List <int>(); int j = 0; for (int i = 0; i < id.Length; i++) { j = 0; if (int.TryParse(id[i], out j)) { pids.Add(j); } } if (pids.Count > 0) { BLayer.RolePermissions.SaveRolePermission((int)roleId, pids); } else { BLayer.RolePermissions.ClearBlockedPermissions(roleId); } } } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } return(RedirectToAction("Index")); }
public CLayer.Role GetRole(long id) { String sql = "Select * from Roles Where Id=" + id.ToString(); DataTable dt = Connection.GetSQLTable(sql); if (dt.Rows.Count == 0) { return(null); } CLayer.Role r = new CLayer.Role(); r.Id = Connection.ToLong(dt.Rows[0]["Id"]); r.Name = Connection.ToString(dt.Rows[0]["Name"]); return(r); }
public static long SaveRole(CLayer.Role role) { DataLayer.RolePermissions rp = new DataLayer.RolePermissions(); return(rp.SaveRole(role)); }