public void TestGetListOfWorkingDayInCurrentMonth()
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassTerm> querry = from elem in sql.TestGetListOfWorkingDayInCurrentMonth2(2)
where elem.Doctor.Doctor_id == 2
select elem;
Xunit.Assert.Single(querry);
}
public void TestUpdateTerm()
{
SqlCalendar sql = new SqlCalendar();
sql.UpdateTerm(1, new DateTime(2000, 3, 7), 2);
IEnumerable <ClassTerm> querry = from elem in sql.ListOfTerms()
where elem.TermId == 2 && elem.CalendarDay.CalendarDayId == 1
select elem;
Xunit.Assert.Single(querry);
}
public void TestCreateTerm()
{
SqlCalendar sql = new SqlCalendar();
sql.CreateTerm(new TimeSpan(15, 0, 0), new TimeSpan(16, 0, 0), 2, 6, 2, 1, new DateTime(2000, 5, 6));
IEnumerable <ClassTerm> querry = from elem in sql.ListOfTerms()
where elem.StartTime == new TimeSpan(15, 0, 0) && elem.EndTime == new TimeSpan(16, 0, 0) && elem.CalendarDoctor.CalendarDoctorId == 2 &&
elem.CalendarDay.CalendarDayId == 6 && elem.Office.OfficeId == 2 && elem.Doctor.Doctor_id == 1 &&
elem.Date == new DateTime(2000, 5, 6)
select elem;
Xunit.Assert.Single(querry);
}
public void TestGetCalendarIdForDoctor(int doctorId, int calendarId, int expected)
{
SqlCalendar sql = new SqlCalendar();
Xunit.Assert.Equal(expected, sql.GetCalendarIdForDoctor(doctorId, calendarId));
}
