public void TestCorrectHandicapReportLocated() { HandicapReport foundHandicapReport = playerScores.GetHandicapReport(new DateTime(2020, 02, 01)); Assert.NotNull(foundHandicapReport); Assert.Equal("Shareholder Member", foundHandicapReport.MemberName); Assert.Equal(2, foundHandicapReport.LastUpdated.Month); Assert.Equal(2020, foundHandicapReport.LastUpdated.Year); Assert.Equal(5.9, foundHandicapReport.HandicapFactor); Assert.Equal(12.9, foundHandicapReport.Average); Assert.Equal(6.20, foundHandicapReport.BestOfTenAverage); }
public List <HandicapReport> GetHandicapReport(DateTime Time) { List <HandicapReport> handicapReport = new List <HandicapReport>(); List <Member> members = new List <Member>(); Members MemberManager = new Members(); members = MemberManager.GetAllMember(); foreach (Member member in members) { HandicapReport MemberReport = new HandicapReport(); MemberReport.MemberNumber = member.MemberNumber; MemberReport.MemberName = member.FirstName + ' ' + member.LastName; handicapReport.Add(MemberReport); } SqlConnection SampleConnection = new SqlConnection(); SampleConnection.ConnectionString = connectionString; SampleConnection.Open(); SqlCommand GetHandicapReport = new SqlCommand(); GetHandicapReport.CommandType = CommandType.StoredProcedure; GetHandicapReport.Connection = SampleConnection; GetHandicapReport.CommandText = "GetHandicapReport"; GetHandicapReport.Parameters.AddWithValue("@Time", Time); SqlParameter returnCode = new SqlParameter(); returnCode.ParameterName = "@ReturnCode"; returnCode.Direction = ParameterDirection.ReturnValue; returnCode.SqlDbType = SqlDbType.Int; GetHandicapReport.Parameters.Add(returnCode); SqlDataReader DataReader; DataReader = GetHandicapReport.ExecuteReader(); if (DataReader.HasRows) { while (DataReader.Read()) { for (int i = 0; i < handicapReport.Count; i++) { if (handicapReport[i].MemberNumber == DataReader["MemberNumber"].ToString() && handicapReport[i].Last20Rounds == null) { List <double> HandicapDifferentialList = new List <double>(); double num = double.Parse(DataReader["HandicapDifferential"].ToString()); HandicapDifferentialList.Add(num); handicapReport[i].Last20Rounds = HandicapDifferentialList; } else if (handicapReport[i].MemberNumber == DataReader["MemberNumber"].ToString()) { handicapReport[i].Last20Rounds.Add(double.Parse(DataReader["HandicapDifferential"].ToString())); } } } } else { handicapReport = null; } SampleConnection.Close(); return(handicapReport); }