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