public static async Task <List <EventImage> > GetEventImages(string gameName)
{
#region GetAsync
var list = new List <EventImage>();
await using var cmd =
new MySqlCommand(
$"SELECT * FROM {Name} WHERE Game = '{gameName}' ORDER BY `Timestamp` DESC")
{
Connection = new MySqlConnection(_connectionString)
};
try
{
await cmd.Connection.OpenAsync();
var reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
var eventImage = new EventImage
{
GameName = reader["Game"].ToString(),
Timestamp = long.Parse(reader["Timestamp"].ToString() ?? "0")
};
eventImage.SetUrl(reader["Image"].ToString());
list.Add(eventImage);
}
}
catch (Exception exception)
{
Logger.Log(exception, Logger.ErrorLevel.Error);
}
finally
{
if (cmd.Connection != null)
{
await cmd.Connection.CloseAsync();
}
}
return(list);
#endregion
}
