BolfTracker.Infrastructure.EntityFramework.GameStatisticsRepository.DeleteByMonthAndYear C# (CSharp) Method

DeleteByMonthAndYear() public method

public DeleteByMonthAndYear ( int month, int year ) : void
month int
year int
return void
        public void DeleteByMonthAndYear(int month, int year)
        {
            using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
            {
                connection.Open();

                string command = "DELETE GameStatistics FROM GameStatistics gs INNER JOIN Game g ON g.Id = gs.GameId WHERE (DATEPART (month, g.[Date])) = @Month AND (DATEPART (year, g.[Date])) = @Year";

                connection.Execute(command, new { Month = month, Year = year });
            }
        }