public GetFinalizedByMonthAndYear ( int month, int year ) : IEnumerable |
||
month | int | |
year | int | |
return | IEnumerable |
public IEnumerable<Game> GetFinalizedByMonthAndYear(int month, int year)
{
using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
{
connection.Open();
string query = "SELECT g.* FROM Game g INNER JOIN GameStatistics gs ON gs.GameId = g.Id WHERE (DATEPART (month, g.[Date])) = @Month AND (DATEPART (year, g.[Date])) = @Year";
var games = connection.Query<Game>(query, new { Month = month, Year = year }).ToList();
return games;
}
}