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