public AdminModule(IConfiguration config, IGumroadApi gumroad, RootDatabase db, ResponsiveService responsive) { _config = config; _gumroad = gumroad; _db = db; _responsive = responsive; }
public ReactionWatcherService( ILogger <ReactionWatcherService> logger, DiscordSocketClient discord, LinkingService linking, RootDatabase db) { _logger = logger; _discord = discord; _linking = linking; _db = db; _syncedProducts = new ConcurrentDictionary <ulong, RexoProduct>(); _discord.ReactionAdded += OnReactionAddedAsync; }
private bool CheckReferenceData(long tableId, string tableName, string schema, List <Column> columns) { // If table is deference data // For check reference data bool existAddOrUpdate = false; if (ExtendProperties.Any(x => x.major_id == tableId && x.name.Equals("ReferenceData", StringComparison.OrdinalIgnoreCase) && x.value.Equals("Enum", StringComparison.OrdinalIgnoreCase))) { var data = SqlService.LoadData(CurrentSqlConnection, tableName, $"SELECT * FROM [{schema}].[{tableName}]"); if (data.Rows.Count > 0) { var tableElement = new XElement("Table"); var dataElement = new XElement("Data"); tableElement.SetAttributeValue("Name", tableName); if (schema.ToLower() != "dbo") { tableElement.SetAttributeValue("Schema", schema); } foreach (var rowData in data.Rows.Cast <DataRow>()) { var rowElement = new XElement("Row"); foreach (var column in data.Columns.Cast <DataColumn>().OrderBy(x => x.ColumnName)) { if (column.ColumnName.Equals("ID", StringComparison.OrdinalIgnoreCase) || rowData[column.ColumnName] == System.DBNull.Value) { continue; } existAddOrUpdate = true; rowElement.SetAttributeValue(XmlConvert.EncodeName(column.ColumnName) ?? column.ColumnName, rowData[column.ColumnName].ToString()); } existAddOrUpdate = true; dataElement.Add(rowElement); } var columnType = GetColumnTypes(columns); dataElement.AddFirst(columnType); tableElement.Add(dataElement); RootDatabase.Add(tableElement); } } return(existAddOrUpdate); }
private void SaveChanges(string output) { if (UpdateTables.HasElements) { RootDatabase.Add(UpdateTables); } if (AddTables.HasElements) { RootDatabase.Add(AddTables); } if (RemoveTables.HasElements) { RootDatabase.Add(RemoveTables); } Doc.Add(RootDatabase); Doc.Save(output); }
public GuildConfigModule(RootDatabase db) { _db = db; }
public UserConfigModule(RootDatabase db) { _db = db; }