public void YearQuarter_FromString_Success()
{
string expected = "B014";
YearQuarter yrq = YearQuarter.FromString(expected);
Assert.AreEqual(expected, yrq.ToString());
}
public void YearQuarter_FriendlyName_Success()
{
string expected = "Spring 2011";
YearQuarter yrq = YearQuarter.FromString("B014");
Assert.AreEqual(expected, yrq.FriendlyName);
}
public void GetSections_Fall2011_OnCampus_WideTimeRange()
{
using (OdsRepository repository = new OdsRepository())
{
TimeSpan startTime = new TimeSpan(2, 55, 0);
TimeSpan endTime = new TimeSpan(22, 55, 0);
IList <ISectionFacet> facets = new List <ISectionFacet>();
facets.Add(new TimeFacet(startTime, endTime));
facets.Add(new ModalityFacet(ModalityFacet.Options.OnCampus));
facets.Add(new AvailabilityFacet(AvailabilityFacet.Options.All));
string subject = null;
// IList<Section> sections = repository.GetSections(subject, YearQuarter.FromString("B122"), facets);
IList <Section> sections = repository.GetSections(YearQuarter.FromString("B122"), facets);
Assert.IsTrue(sections.Count > 0, "No sections were returned");
// make sure we have sections that fall in the specified range...
int rightSectionCount = sections.Where(s => s.Offered.Where(o => (o.StartTime.HasValue && o.StartTime.Value.TimeOfDay.CompareTo(startTime) >= 0 && o.StartTime.Value.TimeOfDay.CompareTo(endTime) <= 0)).Count() > 0).Count();
Assert.IsTrue(rightSectionCount > 0, "Section records do not include start/end times in the specified range.");
// ... and that we don't have any that fall outside that range
int wrongSectionCount = sections.Where(s => s.Offered.Where(o => (o.StartTime.HasValue && o.StartTime.Value.TimeOfDay.CompareTo(startTime) < 0 && o.StartTime.Value.TimeOfDay.CompareTo(endTime) > 0)).Count() > 0).Count();
Assert.IsTrue(wrongSectionCount <= 0, "Found {0} sections with start/end times outside of {1} - {2}", wrongSectionCount, startTime, endTime);
}
}
public void YearQuarter_Equals_AnotherCreatedFromFriendlyName()
{
YearQuarter yrq1 = YearQuarter.FromString("B121");
YearQuarter yrq2 = YearQuarter.FromFriendlyName("Summer 2011");
Assert.AreEqual(yrq1, yrq2);
}
public void YearQuarter_Equals_Another()
{
YearQuarter yrq1 = YearQuarter.FromString("B121");
YearQuarter yrq2 = YearQuarter.FromString("B121");
Assert.AreEqual(yrq1, yrq2);
}
public void YearQuarter_Max()
{
string yrqMin = TestHelper.MaxYrq;
YearQuarter yrq = YearQuarter.FromString(yrqMin);
Assert.AreEqual(yrqMin, yrq.ID);
Assert.AreEqual("[Maximum]", yrq.FriendlyName);
}
public void GetSectionsByCourseID_WithYrq_Success()
{
using (OdsRepository repository = new OdsRepository())
{
YearQuarter yrq = YearQuarter.FromString("B012");
IList <Section> sections = repository.GetSections(CourseID.FromString("ART 101"), yrq);
Assert.IsTrue(sections.Count > 0);
}
}
public void GetSections_VerifyCommonCourseCharacterRemovedFromCourseID()
{
using (OdsRepository repository = new OdsRepository())
{
IList <Section> sections = repository.GetSections("ENGL", YearQuarter.FromString("B122"));
int count = sections.Where(s => s.CourseID.Contains("&")).Count();
Assert.IsTrue(count == 0, "{0} records found to still contain the CCN character ('&') in the CourseID", count);
}
}
public void GetSectionsBySubject_WithQuarterFilter_Success()
{
using (OdsRepository repository = new OdsRepository())
{
YearQuarter yrq = YearQuarter.FromString("B122");
IList <Section> sections = repository.GetSections("ENGL", yrq);
int count = sections.Where(s => s.Yrq.ID == "B122" && s.CourseID.StartsWith("ENGL")).Count();
Assert.AreEqual(sections.Count, count);
}
}
public void GetSectionsByYearQuarter_Success()
{
using (OdsRepository repository = new OdsRepository())
{
string yearQuarterId = "B012";
YearQuarter yrq = YearQuarter.FromString(yearQuarterId);
IList <Section> sections = repository.GetSections(yrq);
int count = sections.Where(s => s.Yrq.ID == yearQuarterId).Count();
Assert.AreEqual(sections.Count, count);
}
}
// [Conditional("BC_ONLY")]
public void GetSectionsByCourseID_WithYrq_VerifyInstructorEmail()
{
using (OdsRepository repository = new OdsRepository())
{
YearQuarter yrq = YearQuarter.FromString("B233");
string courseId = "ART 101";
IList <Section> sections = repository.GetSections(CourseID.FromString(courseId), yrq, TestHelper.GetFacets());
Assert.IsTrue(sections.Count > 0, "No sections found for {0} in {1}", courseId, yrq.FriendlyName);
int emailCount = sections.Where(s => s.Offered.Where(o => !string.IsNullOrWhiteSpace(o.InstructorEmail)).Count() > 0).Count();
Assert.IsTrue(emailCount > 0, "No instructor e-mails found.");
}
}
public void GetSectionsBySubject_WithQuarterFilter_OnCampus_Success()
{
using (OdsRepository repository = new OdsRepository())
{
YearQuarter yrq = YearQuarter.FromString("B122");
IList <ISectionFacet> facets = new List <ISectionFacet>(1);
facets.Add(new ModalityFacet(ModalityFacet.Options.OnCampus));
IList <Section> sections = repository.GetSections("ART", yrq, facets);
Assert.IsTrue(sections.Count > 0, "No records found.");
int count = sections.Where(s => s.Yrq.ID == yrq.ID && s.CourseID.StartsWith("ART")).Count();
Assert.AreEqual(sections.Count, count);
}
}
public void GetSections_ThreeQuarters_Success()
{
IList <YearQuarter> yearQuartersToFilter = new List <YearQuarter>();
yearQuartersToFilter.Add(YearQuarter.FromString("B014"));
yearQuartersToFilter.Add(YearQuarter.FromString("B121"));
yearQuartersToFilter.Add(YearQuarter.FromString("B122"));
int returnedCount = TestHelper.GetSectionCountWithFilter(new YearQuarterFacet(yearQuartersToFilter), false);
int actualCount = _dataVerifier.GetSectionCount(string.Format("YearQuarterID in ('{0}', '{1}', '{2}')",
yearQuartersToFilter[0].ID,
yearQuartersToFilter[1].ID,
yearQuartersToFilter[2].ID));
Assert.AreEqual(actualCount, returnedCount);
}
public void GetSections_VerifySortedByCourseID()
{
using (OdsRepository repository = new OdsRepository())
{
IList <Section> sections = repository.GetSections("ENGL", YearQuarter.FromString("B122"));
string prevCourseID = " ";
// TODO: is there a more efficient way to determine that the whole list is sorted?
foreach (ISection section in sections)
{
string thisCourseID = section.CourseID;
Assert.IsTrue(thisCourseID.CompareTo(prevCourseID) >= 0, "Invalid order found: [{0}] is not less than [{1}]", prevCourseID, thisCourseID);
prevCourseID = thisCourseID;
}
}
}
public void RetrievingPresentAndFutureDescriptions()
{
using (OdsRepository ods = new OdsRepository())
{
ICourseID courseID = CourseID.FromString("ECON&201");
IList <CourseDescription> descs = ods.GetCourseDescription(courseID, YearQuarter.FromString("B234"));
Assert.IsNotNull(descs);
foreach (CourseDescription desc in descs)
{
Console.Out.WriteLine("[{0}] {1}", desc.YearQuarterBegin, desc.Description);
}
Assert.IsTrue(descs.Count > 1, "ECON& 201 should have 2 descriptions, but only has {0}", descs.Count);
}
}
public void GetSubjectsWithYrq_Modality_Online_Success()
{
using (OdsRepository repo = new OdsRepository())
{
YearQuarter yearQuarter = YearQuarter.FromString("B122");
IList <ISectionFacet> facets = new List <ISectionFacet>();
facets.Add(new ModalityFacet(ModalityFacet.Options.Online));
IList <CoursePrefix> actual = repo.GetCourseSubjects(yearQuarter, facets);
int expectedCount = _dataVerifier.GetCourseSubjectCountForSections(string.Format("YearQuarterID = '{0}' and SBCTCMisc1 like '3%'", yearQuarter.ID), true);
Assert.AreEqual(expectedCount, actual.Count);
int allCount = _dataVerifier.GetCourseSubjectCountForSections(string.Format("YearQuarterID = '{0}'", yearQuarter.ID));
Assert.IsTrue(allCount > actual.Count, "Count of online sections is not less than all sections");
}
}
public void GetSectionsBySubjectList_Success()
{
using (OdsRepository repository = new OdsRepository())
{
IList <ISectionFacet> facets = TestHelper.GetFacets();
IList <string> subjects = new List <string>(2)
{
"ENGL", "ENGL&"
};
YearQuarter yrq = YearQuarter.FromString("B122");
IList <Section> sections = repository.GetSections(subjects, yrq);
int count = sections.Where(s => s.CourseSubject == "ENGL").Count();
Assert.AreEqual(sections.Count, count);
}
}
public void GetSections_Verify_IsVariableCredits_Flag()
{
IList <Section> sections = TestHelper.GetSectionsWithFilter(new YearQuarterFacet(YearQuarter.FromString("B123")), false);
// IList<Section> engl = sections.Where(s => s.CourseSubject.ToUpper() == "ENGL" && s.CourseNumber == "299").ToList();
int actual = sections.Where(s => s.IsVariableCredits).Count();
int expected = _dataVerifier.GetSectionCount("isnull(VariableCredits, 0) <> 0 and YearQuarterID = 'B123'");
Assert.AreEqual(expected, actual);
}
