public ICollection <sys_server_role_member> GetServerRoleMembers(sys_server_principal principal)
{
using (var cnn = Connection())
return(cnn.Query <sys_server_role_member>(@"
SELECT role_principal_id, member_principal_id
FROM sys_server_role_member
WHERE role_principal_id = @principal_id", new { principal.principal_id }).ToList());
}
public ICollection <sys_server_permission> GetServerPermissions(sys_server_principal principal)
{
using (var cnn = Connection())
return(cnn.Query <sys_server_permission>(@"
SELECT class, grantee_principal_id, grantor_principal_id, type, state
FROM sys_server_permission
WHERE grantee_principal_id = @principal_id", new { principal.principal_id }).ToList());
}
public bool SaveServerPrincipal(sys_server_principal principal)
{
using (var cnn = Connection())
return(principal.principal_id == 0
? (principal.principal_id = (int)cnn.Query <long>(@"
INSERT INTO sys_server_principal (name, sid, type, is_disabled, default_database_name, default_language_name)
VALUES (@name, @sid, @type, @is_disabled, @default_database_name, @default_language_name);
SELECT last_insert_rowid();", principal).First()) != 0
: cnn.Query <int>(@"
UPDATE sys_server_principal
SET name = @name, sid = @sid, type = @type, is_disabled = @is_disabled, modify_date = datetime(), default_database_name = @default_database_name, default_language_name = @default_language_name
WHERE principal_id = @principal_id;
SELECT changes();", principal).First() != 0);
}