public void GetCurrentWeekNumber_ShouldBeNewWeek() { List <WeeklyStats> stats = repoLayer.GetWeeklyStats(serviceLayer.GetConnection()); repoLayer.ClearWeeklyStats(serviceLayer.GetConnection()); foreach (WeeklyStats stat in stats) { stat.WeekDate = stat.WeekDate.AddDays(-8); repoLayer.InsertWeeklyStats(serviceLayer.GetConnection(), stat); } serviceLayer.GetCurrentWeekNumber().Should().Be(6); }
/// <summary> /// Get weekly stats for a year /// </summary> /// <param name="year"></param> /// <returns></returns> public List <WeeklyStats> GetWeeklyStatsForYear(int year) { DateTime yearStart = DateTime.Parse("01/01/" + year); DateTime yearEnd = DateTime.Parse("31/12/" + year); return(repoLayer.GetWeeklyStats(connection).Where(x => x.WeekDate >= yearStart && x.WeekDate <= yearEnd).ToList()); }