private async Task InternalAddAsync(ulong userId, string userName, string discrim, string avatar, string reason, long amount, bool gamble) { if (amount < 0) { throw new ArgumentException("You can't add negative amounts. Use RemoveAsync method for that.", nameof(amount)); } using (var uow = _db.GetDbContext()) { InternalChange(userId, userName, discrim, avatar, reason, amount, gamble, uow); await uow.SaveChangesAsync(); } }
public void EnsureMigrated() { using var uow = _db.GetDbContext(); using var conn = uow._context.Database.GetDbConnection(); // check if bot config exists using (var checkTableCommand = conn.CreateCommand()) { // make sure table still exists checkTableCommand.CommandText = "SELECT name FROM sqlite_master WHERE type='table' AND name='BotConfig';"; var checkReader = checkTableCommand.ExecuteReader(); if (!checkReader.HasRows) { return; } } MigrateBotConfig(conn); using var dropBlockedTable = conn.CreateCommand(); dropBlockedTable.CommandText = "DROP TABLE IF EXISTS BlockedCmdOrMdl;"; dropBlockedTable.ExecuteNonQuery(); }
public string GetDmGreetMsg(ulong id) { using (var uow = _db.GetDbContext()) { return(uow.GuildConfigs.ForId(id, set => set)?.DmGreetMessageText); } }
public void EnsureMigrated() { using var uow = _db.GetDbContext(); using var conn = uow._context.Database.GetDbConnection(); Migrate(conn); }