public Playlist(ExtService e, string u, string n, ulong usr, int c, DateTimeOffset crea, DateTimeOffset mody) { ExternalService = e; Url = u; Name = n; UserID = usr; SongCount = c; Creation = crea; Modify = mody; }
public static async Task AddPlaylist(string p, ulong u, ExtService e = ExtService.None, string url = "") { var connString = Bot.cfg.DbConnectString; var conn = new NpgsqlConnection(connString); await conn.OpenAsync(); var cmd = new NpgsqlCommand("INSERT INTO playlists VALUES (@u,@p,@url,@ext,@cre,@mody)", conn); cmd.Parameters.AddWithValue("u", Convert.ToInt64(u)); cmd.Parameters.AddWithValue("p", p); cmd.Parameters.AddWithValue("url", url); cmd.Parameters.AddWithValue("ext", e.ToString()); cmd.Parameters.AddWithValue("cre", DateTimeOffset.UtcNow); cmd.Parameters.AddWithValue("mody", DateTimeOffset.UtcNow); await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); conn.Close(); conn.Dispose(); }
public ExtController(ExtService dbService) { _extService = dbService; }