public void TestCreateCalendarDays()
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassCalendar> querycal =
from elem in sql.CalendarList()
where elem.Month == 4
select elem;
ClassCalendar calendar = querycal.First();
int id = calendar.CalendarId;
sql.CreateCalendarDays("(1,'07:00:00','20:00:00'," + id + "),(2,'07:00:00','20:00:00'," + id + "),(3,'07:00:00','20:00:00'," + id + ")");
IEnumerable <ClassCalendarDay> query =
from elem in sql.ListOfCalendarDays(id)
where elem.Day == 1 && elem.StartTime.CompareTo(new TimeSpan(7, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(20, 0, 0)) == 0
select elem;
Assert.Single(query);
query =
from elem in sql.ListOfCalendarDays(id)
where elem.Day == 2 && elem.StartTime.CompareTo(new TimeSpan(7, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(20, 0, 0)) == 0
select elem;
Assert.Single(query);
query =
from elem in sql.ListOfCalendarDays(id)
where elem.Day == 3 && elem.StartTime.CompareTo(new TimeSpan(7, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(20, 0, 0)) == 0
select elem;
Assert.Single(query);
}
public void TestCreateTerms()
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassCalendar> querycal =
from elem in sql.CalendarList()
where elem.Month == 2
select elem;
ClassCalendar calendar = querycal.First();
sql.CreateTerms("('08:00:00','12:00:00','2000-2-1',3,1,100,1),('13:00:00','15:00:00','2000-2-2',4,2,200,2)");
ClassGenerateCalendar.ShareCalendar(calendar, sql);
List <ClassTerm> list = sql.ListOfTerms();
IEnumerable <ClassTerm> query =
from elem in list
where elem.TermId == 3 && elem.CalendarDay.CalendarDayId == 1 && elem.Doctor.Doctor_id == 1 && elem.StartTime.CompareTo(new TimeSpan(8, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(12, 0, 0)) == 0
select elem;
Assert.Single(query);
query =
from elem in list
where elem.TermId == 4 && elem.CalendarDay.CalendarDayId == 2 && elem.Doctor.Doctor_id == 2 && elem.StartTime.CompareTo(new TimeSpan(13, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(15, 0, 0)) == 0
select elem;
Assert.Single(query);
querycal =
from elem in sql.CalendarList()
where elem.Month == 2
select elem;
calendar = querycal.First();
Assert.Equal(2, calendar.Status.StatusId);
}
public void TestCalendarList()
{
SqlCalendar sql = new SqlCalendar();
Assert.Equal(3, sql.CalendarList().Count);
IEnumerable <ClassCalendar> query =
from elem in sql.CalendarList()
where elem.Year == 2000 && elem.Month == 2 && elem.CalendarId == 1 && elem.Status.StatusId == 1
select elem;
Assert.Single(query);
query =
from elem in sql.CalendarList()
where elem.Year == 2000 && elem.Month == 3 && elem.CalendarId == 2 && elem.Status.StatusId == 3
select elem;
Assert.Single(query);
query =
from elem in sql.CalendarList()
where elem.Year == 2000 && elem.Month == 4 && elem.CalendarId == 3 && elem.Status.StatusId == 1
select elem;
Assert.Single(query);
}
public void TestTermLisTSelectedDoctor()
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassTerm> query =
from elem in sql.TermLisTSelectedDoctor(1, 1)
select elem;
Assert.Single(query);
}
public void TestDoctorList(bool active, int doctorId, string name, string surname, int officeNumber)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassDoctor> query =
from elem in sql.DoctorList()
where elem.Active == active && elem.Doctor_id == doctorId && elem.Name == name && elem.Surname == surname && elem.OfficeNumber == officeNumber
select elem;
Assert.Single(query);
}
public void TestListFixedTermsForSpecifiedDoctor(int doctorId, int day)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassFixedTerms> query =
from elem in sql.ListFixedTermsForSpecifiedDoctor(doctorId)
where elem.Day == day
select elem;
Assert.Single(query);
}
public void TestListOfCalendarDoctor(int calendarDoctorId, int calendarId, int doctorId, int statusId)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassCalendarDoctor> query =
from elem in sql.ListOfCalendarDoctor(calendarId)
where elem.CalendarDoctorId == calendarDoctorId && elem.Doctor.Doctor_id == doctorId && elem.Status.StatusId == statusId
select elem;
Assert.Single(query);
}
public void TestStatusList(int id, string status)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassStatus> query =
from elem in sql.StatusList()
where elem.StatusId == id && elem.Status == status
select elem;
Assert.Single(query);
}
public void TestListOfTerms(int termId, int calendarDayId, int doctorId, int calendarDoctorId, int officeNumber)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassTerm> query =
from elem in sql.ListOfTerms()
where elem.TermId == termId && elem.CalendarDay.CalendarDayId == calendarDayId && elem.Doctor.Doctor_id == doctorId && elem.CalendarDoctor.CalendarDoctorId == calendarDoctorId && elem.Office.OfficeNumber == officeNumber
select elem;
Assert.Single(query);
}
public void TestTermsForSpecifiedYearAndMonth(int termId, int calendarDayId, int calendarDoctorId, int officeNumber, int year, int month)
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassTerm> query =
from elem in sql.TermsForSpecifiedYearAndMonth(year, month)
where elem.TermId == termId && elem.CalendarDay.CalendarDayId == calendarDayId && elem.CalendarDoctor.CalendarDoctorId == calendarDoctorId && elem.Office.OfficeNumber == officeNumber
select elem;
Assert.Single(query);
}
public void TestUpdateCalendarStatus()
{
SqlCalendar sql = new SqlCalendar();
sql.UpdateCalendarStatus(3, 3);
IEnumerable <ClassCalendar> query =
from elem in sql.CalendarList()
where elem.Status.StatusId == 3 && elem.CalendarId == 3
select elem;
Assert.Single(query);
}
public void TestDeleteTerm()
{
SqlCalendar sql = new SqlCalendar();
sql.DeleteTerm(1);
IEnumerable <ClassTerm> query =
from elem in sql.ListOfTerms()
where elem.TermId == 1
select elem;
Assert.Empty(query);
}
public void TestDeleteCalendarDay()
{
SqlCalendar sql = new SqlCalendar();
sql.DeleteCalendarDay(1);
IEnumerable <ClassCalendarDay> query =
from elem in sql.ListOfCalendarDays(1)
where elem.CalendarDayId == 1
select elem;
Assert.Empty(query);
}
public void TestUpdateOffice()
{
SqlCalendar sql = new SqlCalendar();
sql.UpdateOffice(1, 200);
IEnumerable <ClassTerm> query =
from elem in sql.ListOfTerms()
where elem.TermId == 1 && elem.Office.OfficeNumber == 200
select elem;
Assert.Single(query);
}
public void TestCreateCalendarDoctor()
{
int id = 3;
SqlCalendar sql = new SqlCalendar();
int expected = sql.ListOfCalendarDoctor(id).Count + 1;
sql.CreateCalendarDoctor(1, 3);
int actual = sql.ListOfCalendarDoctor(id).Count;
IEnumerable <ClassCalendarDoctor> query =
from elem in sql.ListOfCalendarDoctor(id)
where elem.Doctor.Doctor_id == 1 && elem.Status.StatusId == 6
select elem;
Assert.Single(query);
}
public void TestListOfCalendarDays()
{
SqlCalendar sql = new SqlCalendar();
IEnumerable <ClassCalendarDay> query =
from elem in sql.ListOfCalendarDays(1)
where elem.CalendarDayId == 1 && elem.Day == 1 && elem.StartTime.CompareTo(new TimeSpan(7, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(20, 0, 0)) == 0
select elem;
Assert.Single(query);
query =
from elem in sql.ListOfCalendarDays(1)
where elem.CalendarDayId == 2 && elem.Day == 2 && elem.StartTime.CompareTo(new TimeSpan(7, 0, 0)) == 0 && elem.EndTime.CompareTo(new TimeSpan(20, 0, 0)) == 0
select elem;
Assert.Single(query);
}
public void TestCreateCalendar()
{
SqlCalendar sql = new SqlCalendar();
int expected = sql.CalendarList().Count + 1;
sql.CreateCalendar(2000, 1);
int actual = sql.CalendarList().Count;
Assert.Equal(expected, actual);
IEnumerable <ClassCalendar> query =
from elem in sql.CalendarList()
where elem.Year == 2000 && elem.Month == 1 && elem.Status.StatusId == 1
select elem;
Assert.Single(query);
}
public void TestDeleteCalendarAndApropriateCalendarDays()
{
SqlCalendar sql = new SqlCalendar();
sql.DeleteCalendarAndApropriateCalendarDays(1);
IEnumerable <ClassCalendarDay> query =
from elem in sql.ListOfCalendarDays(1)
select elem;
Assert.Empty(query);
IEnumerable <ClassCalendar> query2 =
from elem in sql.CalendarList()
where elem.CalendarId == 1
select elem;
Assert.Empty(query2);
}
public void TestGenerationOfCalendar()
{
SqlCalendar sql = new SqlCalendar();
List <int> expected = ClassGenerateCalendar.WorkingDaysInMonth(2000, 1);
ClassGenerateCalendar.GenerateCalendar(2000, 1, sql);
List <ClassCalendar> list = sql.CalendarList();
IEnumerable <ClassCalendar> query =
from elem in list
where elem.Year == 2000 && elem.Month == 1
select elem;
Assert.Single(query);
int calendarId = (query.First()).CalendarId;
List <ClassCalendarDay> actual = sql.ListOfCalendarDays(calendarId);
for (int i = 0; i < expected.Count; i++)
{
Assert.Equal(expected[i], actual[i].Day);
}
}
public void TestSelectCalendarId(int year, int month, int expected)
{
SqlCalendar sql = new SqlCalendar();
Assert.Equal(expected, sql.SelectCalendarId(year, month));
}
public void TestSelectCalendarDayId(int Day, int Calendar_id, int expected)
{
SqlCalendar sql = new SqlCalendar();
Assert.Equal(expected, sql.SelectCalendarDayId(Day, Calendar_id));
}
public void TestSelectStatusId(EnumStatus enumstatus, int expected)
{
SqlCalendar sql = new SqlCalendar();
Assert.Equal(expected, sql.SelectStatusId(enumstatus));
}