protected override void GenerateOutput()
{
if (this.HasState())
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
string sqlPath = "";
int recordCount = 0;
int subjectId;
switch (this._state)
{
case TimetableSelectionStates.UniqueYeargroup:
this.SetSearchTerm();
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/yeargroups.sql";
break;
case TimetableSelectionStates.UniqueRoom:
this.SetSearchTerm();
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/rooms.sql";
break;
case TimetableSelectionStates.ClassSubject:
this.SetSearchTerm();
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/subjects.sql";
break;
case TimetableSelectionStates.ClassQualification:
this.GetId(out subjectId);
paramBuilder.AddParameter(SqlDbType.Int, "@SubjectId", subjectId);
this.SetSearchTerm();
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/qualifications.sql";
break;
case TimetableSelectionStates.ClassClass:
this.GetId(out subjectId);
this.SetSearchTerm();
paramBuilder.AddParameter(SqlDbType.Int, "@SubjectQualificationId", subjectId);
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/classes.sql";
break;
case TimetableSelectionStates.ClassRoom:
this.SetSearchTerm();
sqlPath = "/Sql/Specific/Staff/Modify/Teaching/Timetable/Selection/rooms.sql";
break;
}
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", this._searchTerm);
switch (this._state)
{
case TimetableSelectionStates.UniqueRoom:
case TimetableSelectionStates.ClassRoom:
Core.Helpers.Elements.RecordLists.Record noRoomRecord = new Core.Helpers.Elements.RecordLists.Record();
noRoomRecord.Colour = Core.Helpers.Elements.RecordLists.Colours.Yellow;
noRoomRecord.LeftSide.Image.Source = "nodoor.png";
noRoomRecord.LeftSide.Image.ToolTip = "Teaching does not take place in a room";
noRoomRecord.LeftSide.MainText = "<em>Teaching does not take place in a room</em>";
if (this._state.Equals(TimetableSelectionStates.UniqueRoom))
{
noRoomRecord.OnClick = "setUniqueRoom();";
}
else
{
noRoomRecord.OnClick = "setClassRoom();";
}
recordCollection.Add(noRoomRecord);
break;
}
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader(sqlPath, paramBuilder.Parameters)) {
if (dataReader.HasRows)
{
while (dataReader.Read())
{
switch (this._state)
{
case TimetableSelectionStates.UniqueYeargroup:
Core.Helpers.Elements.RecordLists.Record yeargroupRecord = new Core.Helpers.Elements.RecordLists.Record();
yeargroupRecord.LeftSide.Image.Source = "yeargroup.png";
yeargroupRecord.LeftSide.Image.ToolTip = "Yeargroup";
yeargroupRecord.LeftSide.MainText = dataReader["Name"] as string;
yeargroupRecord.OnClick = "setUniqueYeargroup('" + dataReader["Name"] as string + "', " + (int)dataReader["Id"] + ");";
recordCount++;
recordCollection.Add(yeargroupRecord);
break;
case TimetableSelectionStates.UniqueRoom:
case TimetableSelectionStates.ClassRoom:
Core.Helpers.Elements.RecordLists.Record roomRecord = new Core.Helpers.Elements.RecordLists.Record();
roomRecord.LeftSide.Image.Source = "door.png";
roomRecord.LeftSide.Image.ToolTip = "Room";
roomRecord.LeftSide.MainText = dataReader["Name"] as string;
if (this._state.Equals(TimetableSelectionStates.UniqueRoom))
{
roomRecord.OnClick = "setUniqueRoom('" + dataReader["Name"] as string + "', " + (int)dataReader["Id"] + ");";
}
else
{
roomRecord.OnClick = "setClassRoom('" + dataReader["Name"] as string + "', " + (int)dataReader["Id"] + ");";
}
recordCount++;
recordCollection.Add(roomRecord);
break;
case TimetableSelectionStates.ClassSubject:
Core.Helpers.Elements.RecordLists.Record subjectRecord = new Core.Helpers.Elements.RecordLists.Record();
subjectRecord.LeftSide.Image.Source = "subject.png";
subjectRecord.LeftSide.Image.ToolTip = "Subject";
subjectRecord.LeftSide.MainText = dataReader["Name"] as string;
string subjectName;
if (string.IsNullOrEmpty(dataReader["Abbreviation"] as string))
{
subjectName = dataReader["Name"] as string;
}
else
{
subjectName = dataReader["Abbreviation"] as string;
}
subjectRecord.OnClick = "setClassSubject('" + subjectName + "', " + (int)dataReader["Id"] + ");";
recordCount++;
recordCollection.Add(subjectRecord);
break;
case TimetableSelectionStates.ClassQualification:
Core.Helpers.Elements.RecordLists.Record qualificationRecord = new Core.Helpers.Elements.RecordLists.Record();
qualificationRecord.LeftSide.Image.Source = "lightbulb.png";
qualificationRecord.LeftSide.Image.ToolTip = "Qualification";
qualificationRecord.LeftSide.MainText = dataReader["Name"] as string;
qualificationRecord.OnClick = "setClassQualification('" + dataReader["Name"] as string + "', " + (int)dataReader["Id"] + ");";
recordCount++;
recordCollection.Add(qualificationRecord);
break;
case TimetableSelectionStates.ClassClass:
Core.Helpers.Elements.RecordLists.Record classRecord = new Core.Helpers.Elements.RecordLists.Record();
classRecord.LeftSide.Image.Source = "class.png";
classRecord.LeftSide.Image.ToolTip = "Class";
classRecord.LeftSide.MainText = dataReader["Name"] as string;
classRecord.OnClick = "setClassClass('" + dataReader["Name"] as string + "', " + (int)dataReader["Id"] + ");";
recordCount++;
recordCollection.Add(classRecord);
break;
}
}
this.Page.Contents = recordCollection.ToString();
}
else
{
switch (this._state)
{
case TimetableSelectionStates.UniqueYeargroup:
Core.Helpers.Elements.Alerts.Alert noYeargroupsAlert = new Core.Helpers.Elements.Alerts.Alert("NoYeargroups");
noYeargroupsAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noYeargroupsAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/noyeargroups.html").ToString();
this.Page.Contents = noYeargroupsAlert.ToString();
break;
case TimetableSelectionStates.UniqueRoom:
case TimetableSelectionStates.ClassRoom:
this.Page.Contents = recordCollection.ToString();
break;
case TimetableSelectionStates.ClassSubject:
Core.Helpers.Elements.Alerts.Alert noSubjectsAlert = new Core.Helpers.Elements.Alerts.Alert("NoSubjects");
noSubjectsAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noSubjectsAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/nosubjects.html").ToString();
this.Page.Contents = noSubjectsAlert.ToString();
break;
case TimetableSelectionStates.ClassQualification:
Core.Helpers.Elements.Alerts.Alert noQualificationsAlert = new Core.Helpers.Elements.Alerts.Alert("NoQualifications");
noQualificationsAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noQualificationsAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/noqualifications.html").ToString();
this.Page.Contents = noQualificationsAlert.ToString();
break;
case TimetableSelectionStates.ClassClass:
Core.Helpers.Elements.Alerts.Alert noClassesAlert = new Core.Helpers.Elements.Alerts.Alert("NoClasses");
noClassesAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noClassesAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/noclasses.html").ToString();
this.Page.Contents = noClassesAlert.ToString();
break;
}
}
}
string statusMessage = "";
switch (this._state)
{
case TimetableSelectionStates.UniqueYeargroup:
if (recordCount.Equals(0))
{
statusMessage = "Found no yeargroups!";
}
else if (recordCount.Equals(1))
{
statusMessage = "Found <strong>1</strong> yeargroup";
}
else
{
statusMessage = "Found <strong>" + recordCount + "</strong> yeargroups";
}
break;
case TimetableSelectionStates.UniqueRoom:
case TimetableSelectionStates.ClassRoom:
if (recordCount.Equals(0))
{
statusMessage = "Found no rooms!";
}
else if (recordCount.Equals(1))
{
statusMessage = "Found <strong>1</strong> room";
}
else
{
statusMessage = "Found <strong>" + recordCount + "</strong> rooms";
}
break;
case TimetableSelectionStates.ClassSubject:
if (recordCount.Equals(0))
{
statusMessage = "Found no subjects!";
}
else if (recordCount.Equals(1))
{
statusMessage = "Found <strong>1</strong> subject";
}
else
{
statusMessage = "Found <strong>" + recordCount + "</strong> subjects";
}
break;
case TimetableSelectionStates.ClassQualification:
if (recordCount.Equals(0))
{
statusMessage = "Found no qualifications!";
}
else if (recordCount.Equals(1))
{
statusMessage = "Found <strong>1</strong> qualification";
}
else
{
statusMessage = "Found <strong>" + recordCount + "</strong> qualifications";
}
break;
case TimetableSelectionStates.ClassClass:
if (recordCount.Equals(0))
{
statusMessage = "Found no classes!";
}
else if (recordCount.Equals(1))
{
statusMessage = "Found <strong>1</strong> class";
}
else
{
statusMessage = "Found <strong>" + recordCount + "</strong> classes";
}
break;
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("StaffTeachingTimetableSelection"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["StaffTeachingTimetableSelection"] = statusMessage;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("StaffTeachingTimetableSelection", statusMessage);
}
}
else
{
if (this._success)
{
Core.Helpers.Elements.Alerts.Alert success = new Core.Helpers.Elements.Alerts.Alert("Success");
success.Colour = Core.Helpers.Elements.Alerts.Colours.Green;
success.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/success.html").ToString();
this.Page.Contents = success.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert noSelection = new Core.Helpers.Elements.Alerts.Alert("NoSelection");
noSelection.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noSelection.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Period/Selection/noselectionstate.html").ToString();
this.Page.Contents = noSelection.ToString();
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("StaffTeachingTimetableSelection"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["StaffTeachingTimetableSelection"] = "";
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("StaffTeachingTimetableSelection", "");
}
}
}
protected override void GenerateOutput()
{
string searchTerm = this.GetSearchTerm();
string alertMessage = this.GetAlertMessage();
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", searchTerm);
if ((!string.IsNullOrEmpty(alertMessage)) && (alertMessage.Equals("unknownoutside")))
{
Core.Helpers.Elements.Alerts.Alert unknownTeachingAlert = new Core.Helpers.Elements.Alerts.Alert("UnknownTeaching");
unknownTeachingAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
unknownTeachingAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Landing/Outside/unknown.html").ToString();
unknownTeachingAlert.NoScript = false;
unknownTeachingAlert.ShowCloseBox = true;
unknownTeachingAlert.StartHidden = false;
this.Page.Contents = unknownTeachingAlert.ToString();
}
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Staff/Landing/outside.sql", paramBuilder.Parameters)) {
if (dataReader.HasRows)
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
int recordCount = 0;
while (dataReader.Read())
{
Records.OutsideCoverStaffMember outsideCoverStaffRecord = new Records.OutsideCoverStaffMember();
StaffNameFormatter staffName = new StaffNameFormatter();
staffName.Forename = dataReader["Forename"] as string;
staffName.Surname = dataReader["Surname"] as string;
outsideCoverStaffRecord.Id = (int)dataReader["OutsideCoverStaffId"];
outsideCoverStaffRecord.Name = staffName;
recordCollection.Add(outsideCoverStaffRecord.Record);
recordCount++;
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("StaffOutsideCount"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["StaffOutsideCount"] = recordCount;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("StaffOutsideCount", recordCount);
}
this.Page.Contents += recordCollection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert noOutsideStaffAlert = new Core.Helpers.Elements.Alerts.Alert("NoOutsideStaff");
noOutsideStaffAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noOutsideStaffAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Landing/Outside/none.html").ToString();
noOutsideStaffAlert.NoScript = false;
noOutsideStaffAlert.ShowCloseBox = false;
noOutsideStaffAlert.StartHidden = false;
this.Page.Contents += noOutsideStaffAlert.ToString();
}
}
}
protected override void GenerateOutput()
{
Core.Helpers.Path.Parser sourcePath = new Core.Helpers.Path.Parser(Core.WebServer.Request["sourcepath"]);
bool validSourceDate = this.CheckInputValidity(false, sourcePath);
bool validAjaxDate = this.CheckInputValidity(true, this.Path);
if (!validSourceDate && !validAjaxDate)
{
Core.Helpers.Elements.Alerts.Alert noDate = new Core.Helpers.Elements.Alerts.Alert("NoDate");
noDate.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
noDate.NoScript = false;
noDate.ShowCloseBox = false;
noDate.StartHidden = false;
noDate.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Slips/Requests/nodate.html").ToString();
this.Page.Contents = noDate.ToString();
}
else
{
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
string searchTerm = "";
if (this.Path.HasNext())
{
searchTerm = this.Path.Next();
}
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@Date", this._selectedDate);
paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this._timetableWeek);
paramBuilder.AddParameter(SqlDbType.Int, "@DayNo", (int)(this._selectedDate.DayOfWeek + 1));
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", searchTerm);
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Cover/slips/selective.sql", paramBuilder.Parameters)) {
if (dataReader.HasRows)
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
while (dataReader.Read())
{
Records.CoverSelected record = new Records.CoverSelected();
record.Record.Colour = Core.Helpers.Elements.RecordLists.Colours.Blue;
record.IsInternalCover = (bool)dataReader["IsInternal"];
record.Period = (int)dataReader["Period"];
record.CommitmentName = dataReader["CommitmentName"] as string;
UserManagement.StaffNameFormatter absenteeNameFormatter = new UserManagement.StaffNameFormatter();
absenteeNameFormatter.Forename = dataReader["AbsentForename"] as string;
absenteeNameFormatter.Surname = dataReader["AbsentSurname"] as string;
absenteeNameFormatter.HoldingName = dataReader["AbsentHoldingName"] as string;
record.AbsenteeName = absenteeNameFormatter;
record.AbsenteeNameToolTip = absenteeNameFormatter;
UserManagement.StaffNameFormatter coveringNameFormatter = new UserManagement.StaffNameFormatter();
coveringNameFormatter.Forename = dataReader["CoverForename"] as string;
coveringNameFormatter.Surname = dataReader["CoverSurname"] as string;
coveringNameFormatter.HoldingName = dataReader["CoverHoldingName"] as string;
record.CoverStaffName = coveringNameFormatter;
recordCollection.Add(record.Record);
}
this.Page.Contents = recordCollection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert noRequests = new Core.Helpers.Elements.Alerts.Alert("NoRequests");
noRequests.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noRequests.NoScript = false;
noRequests.ShowCloseBox = false;
noRequests.StartHidden = false;
noRequests.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Slips/Requests/norequests.html").ToString();
this.Page.Contents = noRequests.ToString();
}
}
}
}
protected override void GenerateOutput()
{
string searchTerm = this.GetSearchTerm();
string alertMessage = this.GetAlertMessage();
List <Accounts.NonTeachingAccount> searchResults = Core.WebServer.PleaseTakes.Session.CurrentInstance.School.Settings.NonTeachingAccounts.Search(searchTerm);
if ((!string.IsNullOrEmpty(alertMessage)) && (alertMessage.Equals("unknownnonteaching")))
{
Core.Helpers.Elements.Alerts.Alert unknownTeachingAlert = new Core.Helpers.Elements.Alerts.Alert("UnknownTeaching");
unknownTeachingAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
unknownTeachingAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Landing/Nonteaching/unknown.html").ToString();
unknownTeachingAlert.NoScript = false;
unknownTeachingAlert.ShowCloseBox = true;
unknownTeachingAlert.StartHidden = false;
this.Page.Contents = unknownTeachingAlert.ToString();
}
if (searchResults.Count > 0)
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
foreach (Accounts.NonTeachingAccount account in searchResults)
{
Records.NonTeachingStaffMember nonTeachingStaffRecord = new Records.NonTeachingStaffMember();
StaffNameFormatter staffName = new StaffNameFormatter();
staffName.DisplayForenameFirst = true;
staffName.Forename = account.Forename;
staffName.Surname = account.Surname;
nonTeachingStaffRecord.Username = account.Username;
nonTeachingStaffRecord.Name = staffName;
nonTeachingStaffRecord.IsAccountActive = account.IsActive;
recordCollection.Add(nonTeachingStaffRecord.Record);
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("StaffNonTeachingCount"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["StaffNonTeachingCount"] = searchResults.Count;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("StaffNonTeachingCount", searchResults.Count);
}
this.Page.Contents += recordCollection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert noNonTeachingAlert = new Core.Helpers.Elements.Alerts.Alert("NoNonTeaching");
noNonTeachingAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noNonTeachingAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Landing/Nonteaching/none.html").ToString();
noNonTeachingAlert.NoScript = false;
noNonTeachingAlert.ShowCloseBox = false;
noNonTeachingAlert.StartHidden = false;
this.Page.Contents += noNonTeachingAlert.ToString();
}
}
protected override void GenerateOutput()
{
if (this.HasStaffId())
{
this.SetSearchTerm();
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
recordCollection.Id = "Department";
paramBuilder.AddParameter(SqlDbType.Int, "@StaffId", this._staffId);
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", this._searchTerm);
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Staff/Modify/Teaching/department.sql", paramBuilder.Parameters)) {
dataReader.Read();
if (((bool)dataReader["Status"]))
{
dataReader.NextResult();
if (dataReader.HasRows)
{
int recordCount = 0;
while (dataReader.Read())
{
Core.Helpers.Elements.RecordLists.Record departmentRecord = new Core.Helpers.Elements.RecordLists.Record();
int departmentId = (int)dataReader["Id"];
departmentRecord.LeftSide.Image.Source = "books.png";
departmentRecord.LeftSide.Image.ToolTip = "Department";
departmentRecord.LeftSide.MainText = dataReader["Name"] as string;
departmentRecord.Id = departmentId.ToString();
departmentRecord.OnClick = "getResponse('Department" + departmentId + "', '?path=/staff/modify/update/teaching/department/" + this._staffId + "/" + departmentId + "/', false, false, true);";
if ((bool)dataReader["IsSelected"])
{
departmentRecord.Colour = Core.Helpers.Elements.RecordLists.Colours.Green;
}
else
{
departmentRecord.Colour = Core.Helpers.Elements.RecordLists.Colours.Blue;
}
recordCollection.Add(departmentRecord);
recordCount++;
}
this.Page.Contents = recordCollection.ToString();
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("StaffTeachingDepartmentSelection"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["StaffTeachingDepartmentSelection"] = recordCount;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("StaffTeachingDepartmentSelection", recordCount);
}
}
else
{
Core.Helpers.Elements.Alerts.Alert noResultsAlert = new Core.Helpers.Elements.Alerts.Alert("NoResults");
noResultsAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noResultsAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Department/noresults.html").ToString();
this.Page.Contents = noResultsAlert.ToString();
}
}
else
{
Core.Helpers.Elements.Alerts.Alert invalidAlert = new Core.Helpers.Elements.Alerts.Alert("InvalidDetails");
invalidAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
invalidAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Department/invalid.html").ToString();
this.Page.Contents = invalidAlert.ToString();
}
}
}
else
{
Core.Helpers.Elements.Alerts.Alert missingAlert = new Core.Helpers.Elements.Alerts.Alert("MissingDetails");
missingAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
missingAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Staff/Modify/Teaching/Department/missing.html").ToString();
this.Page.Contents = missingAlert.ToString();
}
}
protected override void GenerateOutput()
{
bool isInternal = false;
bool showZeroEntitlement = false;
string statusMessage = "";
if (this.Path.HasNext())
{
int coverId;
string searchTerm;
if (this.GetBoolInput(out isInternal) && this.GetBoolInput(out showZeroEntitlement) && this.CheckInputValidity() && this.GetCoverId(out coverId))
{
DateTime startDate = Core.WebServer.PleaseTakes.Session.CurrentInstance.School.Settings.Timetabling.SessionDetails.CurrentSession.GetDateSessionInformation(this._selectedDate).RotationStartDate;
DateTime endDate = Core.WebServer.PleaseTakes.Session.CurrentInstance.School.Settings.Timetabling.SessionDetails.CurrentSession.GetDateSessionInformation(this._selectedDate).RotationEndDate;
searchTerm = this.GetSearchTerm();
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.Int, "@CoverId", coverId);
paramBuilder.AddParameter(SqlDbType.Bit, "@GetInternalStaff", isInternal);
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@CurrentDate", this._selectedDate);
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@StartDate", startDate);
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@EndDate", endDate);
paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this._timetableWeek);
paramBuilder.AddParameter(SqlDbType.Int, "@DayNo", (int)(this._selectedDate.DayOfWeek + 1));
paramBuilder.AddParameter(SqlDbType.Bit, "@ShowZeroEntitlement", showZeroEntitlement);
if (string.IsNullOrEmpty(searchTerm))
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", "");
}
else
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", searchTerm);
}
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Cover/Arrange/Selection/Selection/list.sql", paramBuilder.Parameters)) {
dataReader.Read();
if ((bool)dataReader["DoesExist"])
{
dataReader.NextResult();
int staffCount = 0;
if (dataReader.HasRows)
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
recordCollection.Id = "Selection";
while (dataReader.Read())
{
Records.Selection selectionRecord = new Records.Selection();
selectionRecord.Id = ((int)dataReader["Id"]).ToString();
selectionRecord.IsInternal = isInternal;
selectionRecord.Entitlement = (int)dataReader["RemainingEntitlement"];
selectionRecord.IsSelected = (bool)dataReader["IsSelected"];
if (isInternal)
{
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = dataReader["Forename"] as string;
nameFormatter.Surname = dataReader["Surname"] as string;
nameFormatter.HoldingName = dataReader["HoldingName"] as string;
selectionRecord.StaffName = nameFormatter;
}
else
{
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = dataReader["Forename"] as string;
nameFormatter.Surname = dataReader["Surname"] as string;
selectionRecord.StaffName = nameFormatter;
}
recordCollection.Add(selectionRecord.Record);
staffCount++;
}
this.Page.Contents = recordCollection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert noResultsAlert = new Core.Helpers.Elements.Alerts.Alert("NoReults");
noResultsAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
noResultsAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Arrange/Selection/Selection/noresults.html").ToString();
noResultsAlert.NoScript = false;
noResultsAlert.ShowCloseBox = false;
noResultsAlert.StartHidden = false;
this.Page.Contents = noResultsAlert.ToString();
}
if (staffCount.Equals(0))
{
statusMessage = "<strong>Couldnae find anyone!</strong>";
}
else
if (staffCount.Equals(1))
{
if (isInternal)
{
statusMessage = "Found <strong>1</strong> member of teaching staff";
}
else
{
statusMessage = "Found <strong>1</strong> member of outside cover staff";
}
}
else
if (isInternal)
{
statusMessage = "Found <strong>" + staffCount + "</strong> members of teaching staff";
}
else
{
statusMessage = "Found <strong>" + staffCount + "</strong> members of outside cover staff";
}
}
else
{
Core.Helpers.Elements.Alerts.Alert requestDoesNotExistAlert = new Core.Helpers.Elements.Alerts.Alert("RequestDoesNotExist");
requestDoesNotExistAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
requestDoesNotExistAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Arrange/Selection/Selection/requestdoesnotexist.html").ToString();
requestDoesNotExistAlert.NoScript = false;
requestDoesNotExistAlert.ShowCloseBox = false;
requestDoesNotExistAlert.StartHidden = false;
this.Page.Contents = requestDoesNotExistAlert.ToString();
}
}
}
else
{
Core.Helpers.Elements.Alerts.Alert badInputAlert = new Core.Helpers.Elements.Alerts.Alert("BadInput");
badInputAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
badInputAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Arrange/Selection/Selection/badinput.html").ToString();
badInputAlert.NoScript = false;
badInputAlert.ShowCloseBox = false;
badInputAlert.StartHidden = false;
this.Page.Contents = badInputAlert.ToString();
}
}
else
{
Core.Helpers.Elements.Alerts.Alert noRequestSelectedAlert = new Core.Helpers.Elements.Alerts.Alert("NoRequestSelected");
noRequestSelectedAlert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
noRequestSelectedAlert.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Arrange/Selection/Selection/norequestselected.html").ToString();
noRequestSelectedAlert.NoScript = false;
noRequestSelectedAlert.ShowCloseBox = false;
noRequestSelectedAlert.StartHidden = false;
this.Page.Contents = noRequestSelectedAlert.ToString();
}
if (!string.IsNullOrEmpty(statusMessage))
{
string hoverMessage = "";
if (isInternal && showZeroEntitlement)
{
hoverMessage = "Showing all available teaching staff";
}
else if (isInternal && !showZeroEntitlement)
{
hoverMessage = "Showing available teaching staff with a remaining entitlement of 1 or greater";
}
else if (!isInternal && showZeroEntitlement)
{
hoverMessage = "Showing all available outside cover staff";
}
else
{
hoverMessage = "Showing available outside cover staff with a remaining entitlement of 1 or greater";
}
statusMessage = "<p class=\"Plain\" title=\"" + hoverMessage + "\">" + statusMessage + "</p>";
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("ArrangeSelectionInfo"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["ArrangeSelectionInfo"] = statusMessage;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("ArrangeSelectionInfo", statusMessage);
}
}
protected override void GenerateOutput()
{
if (this.CheckInputValidity())
{
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@Date", this._selectedDate);
paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this._timetableWeek);
paramBuilder.AddParameter(SqlDbType.Int, "@DayNo", (int)(this._selectedDate.DayOfWeek + 1));
if (this.Path.HasNext() && this.Path.Peek().Equals("notrequired"))
{
this.Path.Next();
paramBuilder.AddParameter(SqlDbType.Bit, "@GetNoCoverRequests", 1);
}
else
{
paramBuilder.AddParameter(SqlDbType.Bit, "@GetNoCoverRequests", 0);
}
if (this.Path.HasNext())
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", this.Path.Next());
}
else
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", "");
}
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Cover/Arrange/Selection/Requests/list.sql", paramBuilder.Parameters)) {
if (dataReader.HasRows)
{
Core.Helpers.Elements.RecordLists.Collection recordCollection = new Core.Helpers.Elements.RecordLists.Collection();
int requestsCount = 0;
while (dataReader.Read())
{
Records.RequestBase record = new Records.RequestBase();
if ((bool)dataReader["IsBusy"])
{
if ((!dataReader["IsYeargroupAway"].Equals(System.DBNull.Value)) && ((bool)dataReader["IsYeargroupAway"]))
{
Records.NoCoverRequired newRecord = new Records.NoCoverRequired();
newRecord.CommitmentName = dataReader["CommitmentName"] as string;
newRecord.IsYeargroupAway = true;
record = newRecord;
}
else if (!(bool)dataReader["TeachingClass"])
{
Records.NoCoverRequired newRecord = new Records.NoCoverRequired();
newRecord.CommitmentName = dataReader["CommitmentName"] as string;
newRecord.IsNotTeaching = true;
record = newRecord;
}
else
{
if ((bool)dataReader["HasCover"])
{
if ((bool)dataReader["IsInternalCover"])
{
Records.CoverSelected newRecord = new Records.CoverSelected();
newRecord.IsInternalCover = true;
newRecord.Id = "Request" + (int)dataReader["CoverId"];
newRecord.OnClick = "switchToSelection(" + (int)dataReader["CoverId"] + ", " + this._selectedDate.Year + ", " + this._selectedDate.Month + ", " + this._selectedDate.Day + ", true)";
newRecord.CommitmentName = dataReader["CommitmentName"] as string;
UserManagement.StaffNameFormatter coveringStaffNameFormatter = new UserManagement.StaffNameFormatter();
coveringStaffNameFormatter.Forename = dataReader["CoverForename"] as string;
coveringStaffNameFormatter.Surname = dataReader["CoverSurname"] as string;
coveringStaffNameFormatter.HoldingName = dataReader["CoverHoldingName"] as string;
newRecord.CoverStaffName = coveringStaffNameFormatter;
//newRecord.CoverStaffName = Core.Utils.FormatStaffName(dataReader["CoverForename"] as string, dataReader["CoverSurname"] as string, dataReader["CoverHoldingName"] as string, false, false, false);
record = newRecord;
}
else
{
Records.CoverSelected newRecord = new Records.CoverSelected();
newRecord.IsInternalCover = false;
newRecord.Id = "Request" + (int)dataReader["CoverId"];
newRecord.OnClick = "switchToSelection(" + (int)dataReader["CoverId"] + ", " + this._selectedDate.Year + ", " + this._selectedDate.Month + ", " + this._selectedDate.Day + ", true)";
newRecord.CommitmentName = dataReader["CommitmentName"] as string;
UserManagement.StaffNameFormatter coveringStaffNameFormatter = new UserManagement.StaffNameFormatter();
coveringStaffNameFormatter.Forename = dataReader["CoverForename"] as string;
coveringStaffNameFormatter.Surname = dataReader["CoverSurname"] as string;
newRecord.CoverStaffName = coveringStaffNameFormatter;
//newRecord.CoverStaffName = Core.Utils.FormatStaffName(dataReader["CoverForename"] as string, dataReader["CoverSurname"] as string, null, false, false, false);
record = newRecord;
}
}
else
{
Records.NoCoverSelected newRecord = new Records.NoCoverSelected();
newRecord.Id = "Request" + (int)dataReader["CoverId"];
newRecord.OnClick = "switchToSelection(" + (int)dataReader["CoverId"] + ", " + this._selectedDate.Year + ", " + this._selectedDate.Month + ", " + this._selectedDate.Day + ", true)";
newRecord.CommitmentName = dataReader["CommitmentName"] as string;
record = newRecord;
}
}
}
else
{
Records.NoCoverRequired newRecord = new Records.NoCoverRequired();
newRecord.IsYeargroupAway = false;
record = newRecord;
}
UserManagement.StaffNameFormatter absenteeNameFormatter = new UserManagement.StaffNameFormatter();
absenteeNameFormatter.Forename = dataReader["AbsentForename"] as string;
absenteeNameFormatter.Surname = dataReader["AbsentSurname"] as string;
absenteeNameFormatter.HoldingName = dataReader["AbsentHoldingName"] as string;
record.AbsenteeName = absenteeNameFormatter;
record.AbsenteeNameToolTip = absenteeNameFormatter;
//record.AbsenteeName = Core.Utils.FormatStaffName(dataReader["AbsentForename"] as string, dataReader["AbsentSurname"] as string, dataReader["AbsentHoldingName"] as string, false, false, false);
//record.AbsenteeNameToolTip = Core.Utils.FormatStaffName(dataReader["AbsentForename"] as string, dataReader["AbsentSurname"] as string, dataReader["AbsentHoldingName"] as string, false, false, false);
record.Period = (int)dataReader["Period"];
recordCollection.Add(record.Record);
requestsCount++;
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("ArrangeRequestsCount"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["ArrangeRequestsCount"] = requestsCount;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("ArrangeRequestsCount", requestsCount);
}
this.Page.Contents = recordCollection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert a = new Core.Helpers.Elements.Alerts.Alert("NoRequests");
a.Colour = PleaseTakes.Core.Helpers.Elements.Alerts.Colours.Yellow;
a.NoScript = false;
a.ShowCloseBox = false;
a.StartHidden = false;
a.Message = new Core.Helpers.Constructor("/Alerts/Specific/Cover/Arrange/Selection/Requests/norequests.html").ToString();
this.Page.Contents = a.ToString();
}
}
}
else
{
Core.Helpers.Elements.Alerts.Alert alert = new Core.Helpers.Elements.Alerts.Alert("Error");
alert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
alert.NoScript = false;
alert.ShowCloseBox = false;
alert.StartHidden = false;
alert.Message = new Core.Helpers.Constructor("/Alerts/Ajax/error.html").ToString();
this.Page.Contents = alert.ToString();
}
}
protected override void GenerateOutput()
{
if (this.CheckInputValidity())
{
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this._timetableWeek);
paramBuilder.AddParameter(SqlDbType.Int, "@DayNo", (int)(this._selectedDate.DayOfWeek + 1));
paramBuilder.AddParameter(SqlDbType.Int, "@MaxPeriods", this._periods);
paramBuilder.AddParameter(SqlDbType.SmallDateTime, "@Date", this._selectedDate);
if (this.Path.HasNext())
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", this.Path.Next());
}
else
{
paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", "");
}
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Cover/Arrange/Attendance/Attendance/attendance.sql", paramBuilder.Parameters)) {
if (dataReader.HasRows)
{
Core.Helpers.Elements.RecordLists.Collection collection = new Core.Helpers.Elements.RecordLists.Collection();
collection.Id = "Attendance";
int recordCount = 0;
while (dataReader.Read())
{
Core.Helpers.Elements.RecordLists.Record record = new Core.Helpers.Elements.RecordLists.Record();
int staffId = (int)dataReader["StaffId"];
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = dataReader["Forename"] as string;
nameFormatter.Surname = dataReader["Surname"] as string;
nameFormatter.HoldingName = dataReader["HoldingName"] as string;
int attendanceRecord = (int)dataReader["AttendanceRecord"];
record.Id = "Staff" + staffId.ToString();
if (attendanceRecord > 0)
{
record.Colour = Core.Helpers.Elements.RecordLists.Colours.Red;
}
record.LeftSide.MainText = nameFormatter.ToString();
nameFormatter.IsToolTip = true;
record.LeftSide.SetImage("dude.png", nameFormatter.ToString());
record.OnClick = "getResponse('AttendanceStaff" + staffId + "', '?path=/cover/arrange/attendance/ajax/attendance/modify/" + this._selectedDate.Year.ToString() + "/" + this._selectedDate.Month.ToString() + "/" + this._selectedDate.Day.ToString() + "/" + staffId + "/', false, false, true); resetSearch('Periods');";
collection.Add(record);
recordCount++;
}
if (Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.ContainsKey("ArrangeAttendanceCount"))
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage["ArrangeAttendanceCount"] = recordCount;
}
else
{
Core.WebServer.PleaseTakes.Session.CurrentInstance.TemporaryStorage.Add("ArrangeAttendanceCount", recordCount);
}
this.Page.Contents = collection.ToString();
}
else
{
Core.Helpers.Elements.Alerts.Alert alert = new Core.Helpers.Elements.Alerts.Alert("NoResults");
alert.Colour = Core.Helpers.Elements.Alerts.Colours.Yellow;
alert.NoScript = false;
alert.ShowCloseBox = false;
alert.StartHidden = false;
alert.Message = new Core.Helpers.Constructor("/Alerts/Ajax/noresults.html").ToString();
this.Page.Contents = alert.ToString();
}
}
}
else
{
Core.Helpers.Elements.Alerts.Alert alert = new Core.Helpers.Elements.Alerts.Alert("Error");
alert.Colour = Core.Helpers.Elements.Alerts.Colours.Red;
alert.NoScript = false;
alert.ShowCloseBox = false;
alert.StartHidden = false;
alert.Message = new Core.Helpers.Constructor("/Alerts/Ajax/error.html").ToString();
this.Page.Contents = alert.ToString();
}
}
