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); } }