public async Task <IEnumerable <MatchSchedules> > GetMatchSchedulesByRoundAndTimeAsync(int round, DateTime date)
{
var connStr = DbConnection.connectionString;
var cmdStr = "Select * from match_schedules where round=@round and datetime=@date;";
var matches = new List <MatchSchedules>();
using (var conn = new NpgsqlConnection(connStr)) {
using (var cmd = new NpgsqlCommand(cmdStr, conn)) {
await conn.OpenAsync();
cmd.Parameters.AddWithValue("@round", round);
cmd.Parameters.AddWithValue("@date", date);
using (NpgsqlDataReader rd = await cmd.ExecuteReaderAsync()) {
while (rd.Read())
{
var match = new MatchSchedules()
{
MatchID = Convert.ToInt32(rd["match_id"]),
Datetime = rd.GetDateTime("datetime"),
Attendance = rd.GetInt32("attendance"),
HomeName = rd.GetString("hometeam_name"),
AwayName = rd.GetString("awayteam_name"),
StadiumName = rd.GetString("stadium_name"),
HomeImage = rd.GetString("homae_image"),
AwayImage = rd.GetString("away_image"),
Round = Convert.ToInt32(rd["round"])
};
matches.Add(match);
}
}
}
}
return(matches);
}
public async Task <IEnumerable <MatchSchedules> > GetMatchSchedulesAsync()
{
List <MatchSchedules> matches = new List <MatchSchedules> ();
var connStr = DbConnection.connectionString;
using (NpgsqlConnection conn = new NpgsqlConnection(connStr)) {
var cmdStr = "select * from match_schedules";
using (NpgsqlCommand cmd = new NpgsqlCommand(cmdStr, conn)) {
await conn.OpenAsync();
using (NpgsqlDataReader rd = await cmd.ExecuteReaderAsync()) {
while (rd.Read())
{
var match = new MatchSchedules()
{
MatchID = Convert.ToInt32(rd["match_id"]),
Datetime = rd.GetDateTime("datetime"),
Attendance = rd.GetInt32("attendance"),
HomeName = rd.GetString("hometeam_name"),
AwayName = rd.GetString("awayteam_name"),
StadiumName = rd.GetString("stadium_name"),
HomeImage = rd.GetString("homae_image"),
AwayImage = rd.GetString("away_image"),
Round = Convert.ToInt32(rd["round"])
};
matches.Add(match);
}
}
}
}
return(matches);
}
