bool IPermissionHandler.RemoveGroup(string name) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.RemoveGroup, "prm", new DataParameter("Name", name) ); return(Storage.ExecuteNonQuery(sb) > 0); } }
NodePermission[] IPermissionHandler.UserNodes(string username) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.UserNodes, "prm", new DataParameter("UserName", username) ); return(Storage.ExecuteArray <NodePermission>(sb)); } }
bool IPermissionHandler.RemoveUserFromGroup(string username, string groupName) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.RemoveUserFromGroup, "prm", new DataParameter("UserName", username), new DataParameter("GroupName", groupName) ); return(Storage.ExecuteScalar <Int64>(sb) > 0); } }
private Permission IsPermitted(string node, bool isGuest, string authentication = null) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.IsPermitted, "prm", new DataParameter("Node", node), new DataParameter("IsGuest", isGuest), new DataParameter("Authentication", authentication) ); return((Permission)Storage.ExecuteScalar <Int32>(sb)); } }
bool IPermissionHandler.RemoveNodeFromUser(string username, string node, Permission permission) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.RemoveNodeFromUser, "prm", new DataParameter("UserName", username), new DataParameter("Node", node), new DataParameter("Permission", permission) ); return(Storage.ExecuteScalar <Int64>(sb) > 0); } }
bool IPermissionHandler.AddGroupNode(string groupName, string node, Permission permission) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.AddGroupNode, "prm", new DataParameter("GroupName", groupName), new DataParameter("Node", node), new DataParameter("Permission", permission) ); return(Storage.ExecuteScalar <Int64>(sb) > 0); } }
string[] IPermissionHandler.GroupList() { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.GroupList); var lst = Storage.ExecuteArray <GroupList>(sb); if (lst != null) { return(lst.Select(x => x.Name).ToArray()); } } return(null); }
string[] IPermissionHandler.UserGroupList(string username) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.UserGroupList, "prm", new DataParameter("UserName", username) ); var lst = Storage.ExecuteArray <UserGroupList>(sb); if (lst != null) { return(lst.Select(x => x.Name).ToArray()); } } return(null); }
Group IPermissionHandler.FindGroup(string name) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.FindGroup, "prm", new DataParameter("Name", name) ); var arr = Storage.ExecuteArray <Group>(sb); if (arr != null && arr.Length > 0) { return(arr[0]); } } return(null); }
bool IPermissionHandler.AddOrUpdateGroup(string name, bool applyToGuests, string parent, byte r, byte g, byte b, string prefix, string suffix) { using (var sb = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName)) { sb.ExecuteProcedure(Procedures.AddOrUpdateGroup, "prm", new DataParameter("Name", name), new DataParameter("ApplyToGuests", applyToGuests), new DataParameter("Parent", parent), new DataParameter("R", r), new DataParameter("G", g), new DataParameter("B", b), new DataParameter("Prefix", prefix), new DataParameter("Suffix", suffix) ); return(Storage.ExecuteScalar <Int64>(sb) > 0); } }