public static long Insert(MSSQLConnector conn, string node, Permission permission)
{
using (var bl = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName))
{
bl.InsertInto(TableDefinition.TableName,
new DataParameter(TableDefinition.ColumnNames.Node, node),
new DataParameter(TableDefinition.ColumnNames.Permission, permission)
);
return(((IDataConnector)conn).ExecuteInsert(bl));
}
}
public static long Insert(MSSQLConnector conn, string node, Permission permission)
{
using (var bl = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName))
{
bl.InsertInto(TableDefinition.TableName,
new DataParameter(TableDefinition.ColumnNames.Node, node),
new DataParameter(TableDefinition.ColumnNames.Permission, permission)
);
return ((IDataConnector)conn).ExecuteInsert(bl);
}
}
public static long Insert(MSSQLConnector conn, long groupId, long permissionId)
{
using (var bl = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName))
{
bl.InsertInto(TableDefinition.TableName,
new DataParameter(TableDefinition.ColumnNames.GroupId, groupId),
new DataParameter(TableDefinition.ColumnNames.PermissionId, permissionId)
);
return ((IDataConnector)conn).ExecuteInsert(bl);
}
}
static void CreateGroup(string name, bool guest, string parent, byte r, byte g, byte b, string[] nodes, MSSQLConnector conn)
{
long id;
using (var bl = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName))
{
bl.InsertInto(TableName,
new DataParameter(ColumnNames.Name, name),
new DataParameter(ColumnNames.ApplyToGuests, guest),
new DataParameter(ColumnNames.Parent, parent),
new DataParameter(ColumnNames.Chat_Red, r),
new DataParameter(ColumnNames.Chat_Green, g),
new DataParameter(ColumnNames.Chat_Blue, b)
);
id = ((IDataConnector)conn).ExecuteInsert(bl);
}
foreach (var nd in nodes)
{
var nodeId = PermissionTable.Insert(conn, nd, Permission.Permitted);
GroupPermissions.Insert(conn, id, nodeId);
}
}
static void CreateGroup(string name, bool guest, string parent, byte r, byte g, byte b, string[] nodes, MSSQLConnector conn)
{
long id;
using (var bl = new MSSQLQueryBuilder(SqlPermissions.SQLSafeName))
{
bl.InsertInto(TableName,
new DataParameter(ColumnNames.Name, name),
new DataParameter(ColumnNames.ApplyToGuests, guest),
new DataParameter(ColumnNames.Parent, parent),
new DataParameter(ColumnNames.Chat_Red, r),
new DataParameter(ColumnNames.Chat_Green, g),
new DataParameter(ColumnNames.Chat_Blue, b)
);
id = ((IDataConnector)conn).ExecuteInsert(bl);
}
foreach (var nd in nodes)
{
var nodeId = PermissionTable.Insert(conn, nd, Permission.Permitted);
GroupPermissions.Insert(conn, id, nodeId);
}
}
