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)); }