private void SetGrid()
{
foreach (StaffMember staffMember in this._selectedStaff)
{
Row staffRow = this.Rows.AddAndReturn(this);
Cell nameCell = new Cell();
nameCell.Id = this.SetCellValue(this._genericCellsCollection.StaffName.Id, staffMember.Id, null);
nameCell.Type = CellTypes.HeaderSmall;
nameCell.Href = this.SetCellValue(this._genericCellsCollection.StaffName.Href, staffMember.Id, null);
nameCell.OnClick = this.SetCellValue(this._genericCellsCollection.StaffName.OnClick, staffMember.Id, null);
//nameCell.Value = Utils.FormatStaffName(staffMember.Forename, staffMember.Surname, staffMember.HoldingName, true, true, true);
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = staffMember.Forename;
nameFormatter.Surname = staffMember.Surname;
nameFormatter.HoldingName = staffMember.HoldingName;
nameFormatter.AbbreviateForename = true;
nameFormatter.DisplayForenameFirst = true;
nameFormatter.DisplaySmallHoldingName = true;
nameFormatter.IsToolTip = false;
nameCell.Value = nameFormatter.ToString();
nameCell.Parent = this;
staffRow.Add(nameCell);
for (int period = 1; period <= this._periods; period++)
{
try {
DataRow record = this._periodsTable.Select("StaffId = " + staffMember.Id + " AND Period = " + period)[0];
switch (record["Status"].ToString().ToLower())
{
case "unavailable":
staffRow.Add(this.CreateCell(SummaryCellTypes.Unavailable, staffMember.Id, period));
break;
case "absent":
staffRow.Add(this.CreateCell(SummaryCellTypes.Absent, staffMember.Id, period));
break;
case "presentisbusy":
staffRow.Add(this.CreateCell(SummaryCellTypes.PresentIsBusy, staffMember.Id, period));
break;
case "presentandfreeyeargroupaway":
staffRow.Add(this.CreateCell(SummaryCellTypes.PresentAndFreeYeargroupAway, staffMember.Id, period));
break;
}
}
catch (IndexOutOfRangeException) {
staffRow.Add(this.CreateCell(SummaryCellTypes.PresentAndFree, staffMember.Id, period));
}
}
}
}
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();
}
}
}
}
public StaffDetails()
{
this._name = new UserManagement.StaffNameFormatter();
this._name.AbbreviateForename = true;
this._name.DisplayForenameFirst = true;
}
protected override void GenerateOutput()
{
Core.Helpers.Elements.Ajax.Xml.Collection xmlCollection = new Core.Helpers.Elements.Ajax.Xml.Collection();
bool isInternalStaff;
int coverId;
int staffId;
if (this.CheckInputValidity() && this.IsInternalStaff(out isInternalStaff) && this.GetValue(out coverId) && this.GetValue(out staffId))
{
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;
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.Bit, "@IsInternalStaff", isInternalStaff);
paramBuilder.AddParameter(SqlDbType.Int, "@CoverId", coverId);
paramBuilder.AddParameter(SqlDbType.Int, "@StaffId", staffId);
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));
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Cover/Arrange/Selection/Selection/modify.sql", paramBuilder.Parameters)) {
dataReader.Read();
if ((bool)dataReader["Status"])
{
dataReader.NextResult();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Core.Helpers.Elements.Ajax.Xml.Element xmlElement = new Core.Helpers.Elements.Ajax.Xml.Element();
if ((bool)dataReader["IsRequest"])
{
Records.RequestBase record = new Records.RequestBase();
xmlElement.Id = "Request" + (int)dataReader["Id"];
if ((bool)dataReader["RequestHasCover"])
{
Records.CoverSelected newRecord = new Records.CoverSelected();
xmlElement.ClassName = "Green";
UserManagement.StaffNameFormatter staffAbsenteeNameFormatter = new UserManagement.StaffNameFormatter();
staffAbsenteeNameFormatter.Forename = dataReader["RequestAbsentForename"] as string;
staffAbsenteeNameFormatter.Surname = dataReader["RequestAbsentSurname"] as string;
staffAbsenteeNameFormatter.HoldingName = dataReader["RequestAbsentHoldingname"] as string;
newRecord.AbsenteeName = staffAbsenteeNameFormatter;
//newRecord.AbsenteeName = Core.Utils.FormatStaffName(dataReader["RequestAbsentForename"] as string, dataReader["RequestAbsentSurname"] as string, dataReader["RequestAbsentHoldingname"] as string, false, false, false);
newRecord.Period = (int)dataReader["RequestPeriod"];
newRecord.CommitmentName = dataReader["RequestCommitmentName"] as string;
newRecord.IsInternalCover = (bool)dataReader["IsInternalCover"];
UserManagement.StaffNameFormatter staffCoveringNameFormatter = new UserManagement.StaffNameFormatter();
staffCoveringNameFormatter.Forename = dataReader["RequestCoverForename"] as string;
staffCoveringNameFormatter.Surname = dataReader["RequestCoverSurname"] as string;
staffCoveringNameFormatter.HoldingName = dataReader["RequestCoverHoldingName"] as string;
newRecord.CoverStaffName = staffCoveringNameFormatter;
//newRecord.CoverStaffName = Core.Utils.FormatStaffName(dataReader["RequestCoverForename"] as string, dataReader["RequestCoverSurname"] as string, dataReader["RequestCoverHoldingName"] as string, false, false, false);
record = newRecord;
}
else
{
Records.NoCoverSelected newRecord = new Records.NoCoverSelected();
xmlElement.ClassName = "Red";
UserManagement.StaffNameFormatter absenteeNameFormatter = new UserManagement.StaffNameFormatter();
absenteeNameFormatter.Forename = dataReader["RequestAbsentForename"] as string;
absenteeNameFormatter.Surname = dataReader["RequestAbsentSurname"] as string;
absenteeNameFormatter.HoldingName = dataReader["RequestAbsentHoldingName"] as string;
newRecord.AbsenteeName = absenteeNameFormatter;
//newRecord.AbsenteeName = Core.Utils.FormatStaffName(dataReader["RequestAbsentForename"] as string, dataReader["RequestAbsentSurname"] as string, dataReader["RequestAbsentHoldingName"] as string, false, false, false);
newRecord.Period = (int)dataReader["RequestPeriod"];
newRecord.CommitmentName = dataReader["RequestCommitmentName"] as string;
record = newRecord;
}
xmlElement.InnerHtml = record.InnerHtml;
}
else
{
Records.Selection record = new Records.Selection();
int entitlement = (int)dataReader["SelectionEntitlement"];
xmlElement.Id = "Selection" + (int)dataReader["Id"];
record.IsInternal = isInternalStaff;
if (isInternalStaff)
{
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = dataReader["SelectionForename"] as string;
nameFormatter.Surname = dataReader["SelectionSurname"] as string;
nameFormatter.HoldingName = dataReader["SelectionHoldingName"] as string;
record.StaffName = nameFormatter;
}
else
{
UserManagement.StaffNameFormatter nameFormatter = new UserManagement.StaffNameFormatter();
nameFormatter.Forename = dataReader["SelectionForename"] as string;
nameFormatter.Surname = dataReader["SelectionSurname"] as string;
record.StaffName = nameFormatter;
}
if ((bool)dataReader["SelectionIsSelected"])
{
xmlElement.ClassName = "Green";
}
else
if (entitlement.Equals(0))
{
xmlElement.ClassName = "Red";
}
else
{
xmlElement.ClassName = "";
}
record.Entitlement = entitlement;
xmlElement.InnerHtml = record.InnerHtml;
}
xmlCollection.Add(xmlElement);
}
}
}
}
}
this.Page.Contents = xmlCollection.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();
}
}
