SIMS 7 - TPTimetable

TPTimetable.GetXmlEmployeeTimetable (int employeeId,DateTime startDate,DateTime endDate)

This interface gets timetable of an employee passed as parameter for the supplied date range. It gets timetable of all employees when ‘0’ is passed as parameter. It will get all the repetitive event instances of the timetable within the date range supplied.

Sample code and output for this interface is shown below:

TPTimetable timetable = new TPTimetable();
string testdata = timetable.GetXmlEmployeeTimetable(26, DateTime.Parse("01/09/2009"), DateTime.Parse("23/02/2010"));                    

<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>
<Timetables>
  <Timetable>
    <EmployeeID>26</EmployeeID>
    <EventInstanceID>25291</EventInstanceID>
    <EventID>201</EventID>
    <TimetableDate>2009-09-02T09:15:00</TimetableDate>
    <PeriodName>Wed:1</PeriodName>
    <PeriodNumber>11</PeriodNumber>
    <BaseGroupID>5370</BaseGroupID>
    <LocationID>52</LocationID>
    <SubjectID>556</SubjectID>
  </Timetable>
  <Timetable>
    <EmployeeID>26</EmployeeID>
    <EventInstanceID>25292</EventInstanceID>
    <EventID>202</EventID>
    <TimetableDate>2009-09-02T10:15:00</TimetableDate>
    <PeriodName>Wed:2</PeriodName>
    <PeriodNumber>12</PeriodNumber>
    <BaseGroupID>5370</BaseGroupID>
    <LocationID>52</LocationID>
    <SubjectID>556</SubjectID>
  </Timetable>
  <Timetable>
    <EmployeeID>26</EmployeeID>
    <EventInstanceID>25293</EventInstanceID>
    <EventID>203</EventID>
    <TimetableDate>2009-09-02T11:35:00</TimetableDate>
    <PeriodName>Wed:3</PeriodName>
    <PeriodNumber>13</PeriodNumber>
    <BaseGroupID>5042</BaseGroupID>
    <LocationID>52</LocationID>
    <SubjectID>556</SubjectID>
  </Timetable>
  <Timetable>
    <EmployeeID>26</EmployeeID>
    <EventInstanceID>25294</EventInstanceID>
    <EventID>204</EventID>
    <TimetableDate>2009-09-02T12:35:00</TimetableDate>
    <PeriodName>Wed:4</PeriodName>
    <PeriodNumber>14</PeriodNumber>
    <BaseGroupID>5042</BaseGroupID>
    <LocationID>52</LocationID>
    <SubjectID>556</SubjectID>
  </Timetable>
</Timetables>

TPTimetable.GetXmlClassTimetables(System.Int32 model, System.DateTime effectiveDate)

This interface obtains a timetable for active classes for the specified date and TT model ID.

Sample code and output for this interface is shown below:

TPTimetable timetable = new TPTimetable();
string testdata = timetable.GetXmlClassTimetables (2, DateTime.Parse("07/09/2011"));            

<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?> 
  <ClassTimetables>
  <ClassTimetable>
  <ClassID>5478</ClassID> 
  <ClassName>7A/Ps</ClassName> 
  <SubjectID>551</SubjectID> 
  <SubjectCode>Ps</SubjectCode> 
  <PeriodID>9404</PeriodID> 
  <PeriodIndex>20</PeriodIndex> 
  <RoomID>64</RoomID> 
  <EventID>210</EventID> 
  <TeacherID>29</TeacherID> 
  <CycleDay>4</CycleDay> 
  <RoomCode>T4</RoomCode> 
  <RoomName>Technology 4</RoomName> 
  </ClassTimetable>
 <ClassTimetable>
  <ClassID>5479</ClassID> 
  <ClassName>7B/Ps</ClassName> 
  <SubjectID>551</SubjectID> 
  <SubjectCode>Ps</SubjectCode> 
  <PeriodID>9405</PeriodID> 
  <PeriodIndex>20</PeriodIndex> 
  <RoomID>56</RoomID> 
  <EventID>210</EventID> 
  <TeacherID>25</TeacherID> 
  <CycleDay>4</CycleDay> 
  <RoomCode>S5</RoomCode> 
  <RoomName>Science Lab 5</RoomName> 
  </ClassTimetable>
 <ClassTimetable>
  <ClassID>5480</ClassID> 
  <ClassName>7C/Ps</ClassName> 
  <SubjectID>551</SubjectID> 
  <SubjectCode>Ps</SubjectCode> 
  <PeriodID>9406</PeriodID> 
  <PeriodIndex>20</PeriodIndex> 
  <RoomID>55</RoomID> 
  <EventID>210</EventID> 
  <TeacherID>27</TeacherID> 
  <CycleDay>4</CycleDay> 
  <RoomCode>S4</RoomCode> 
  <RoomName>Science Lab 4</RoomName> 
  </ClassTimetable>

TPTimetable.GetXmlStudentTimetable (int studentId,DateTime startDate,DateTime endDate)

This interface gets timetable of a student passed as parameter for the supplied date range. It gets timetable of all students when ‘0’ is passed as parameter. It will get all the repetitive event instances of the timetable within the date range supplied.

Sample code and output for this interface is shown below:

TPTimetable timetable = new TPTimetable();
string testdata = timetable.GetXmlStudentTimetable (5253, DateTime.Parse("01/09/2009"), DateTime.Parse("23/02/2010"));            

<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>
<Timetables>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID>82</EmployeeID>
    <EventInstanceID>25291</EventInstanceID>
    <EventID>201</EventID>
    <TimetableDate>2009-09-02T09:15:00</TimetableDate>
    <PeriodName>Wed:1</PeriodName>
    <PeriodNumber>11</PeriodNumber>
    <BaseGroupID>5390</BaseGroupID>
    <LocationID>4</LocationID>
    <SubjectID>521</SubjectID>
  </Timetable>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID>82</EmployeeID>
    <EventInstanceID>25292</EventInstanceID>
    <EventID>202</EventID>
    <TimetableDate>2009-09-02T10:15:00</TimetableDate>
    <PeriodName>Wed:2</PeriodName>
    <PeriodNumber>12</PeriodNumber>
    <BaseGroupID>5390</BaseGroupID>
    <LocationID>4</LocationID>
    <SubjectID>521</SubjectID>
  </Timetable>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID />
    <EventInstanceID>25293</EventInstanceID>
    <EventID>203</EventID>
    <TimetableDate>2009-09-02T11:35:00</TimetableDate>
    <PeriodName>Wed:3</PeriodName>
    <PeriodNumber>13</PeriodNumber>
    <BaseGroupID>5377</BaseGroupID>
    <LocationID>63</LocationID>
    <SubjectID>520</SubjectID>
  </Timetable>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID />
    <EventInstanceID>25294</EventInstanceID>
    <EventID>204</EventID>
    <TimetableDate>2009-09-02T12:35:00</TimetableDate>
    <PeriodName>Wed:4</PeriodName>
    <PeriodNumber>14</PeriodNumber>
    <BaseGroupID>5377</BaseGroupID>
    <LocationID>63</LocationID>
    <SubjectID>520</SubjectID>
  </Timetable>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID>77</EmployeeID>
    <EventInstanceID>25295</EventInstanceID>
    <EventID>205</EventID>
    <TimetableDate>2009-09-02T14:30:00</TimetableDate>
    <PeriodName>Wed:5</PeriodName>
    <PeriodNumber>15</PeriodNumber>
    <BaseGroupID>5386</BaseGroupID>
    <LocationID>3</LocationID>
    <SubjectID>549</SubjectID>
  </Timetable>
  <Timetable>
    <StudentID>5253</StudentID>
    <EmployeeID>82</EmployeeID>
    <EventInstanceID>25298</EventInstanceID>
    <EventID>207</EventID>
    <TimetableDate>2009-09-03T10:15:00</TimetableDate>
    <PeriodName>Thu:2</PeriodName>
    <PeriodNumber>17</PeriodNumber>
    <BaseGroupID>5390</BaseGroupID>
    <LocationID>4</LocationID>
    <SubjectID>521</SubjectID>
  </Timetable>
</Timetables>