private bool CheckStaffId() {
int readAttempt;
if (this.Path.HasNext())
if (int.TryParse(this.Path.Next(), out readAttempt)) {
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.Int, "@StaffId", readAttempt);
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Staff/Modify/Teaching/existscheck.sql", paramBuilder.Parameters)) {
if (dataReader.HasRows) {
dataReader.Read();
this._staffId = (int)dataReader["StaffId"];
this._entitlement = (int)dataReader["Entitlement"];
this._name = new StaffNameFormatter();
this._name.Title = dataReader["Title"] as string;
this._name.Forename = dataReader["Forename"] as string;
this._name.Surname = dataReader["Surname"] as string;
this._name.HoldingName = dataReader["HoldingName"] as string;
this._hasAccount = (bool)dataReader["HasAccount"];
this._isAdmin = (bool)dataReader["IsAdmin"];
this._isActive = (bool)dataReader["IsActive"];
this._username = dataReader["Username"] as string;
return true;
}
}
}
return false;
}
private void PopulateNameFormatter()
{
this._name = new StaffNameFormatter();
this._name.Title = Core.WebServer.Request["Title"];
this._name.Forename = Core.WebServer.Request["Forename"];
this._name.Surname = Core.WebServer.Request["Surname"];
this._name.HoldingName = Core.WebServer.Request["HoldingName"];
}
private void PopulateName(SqlDataReader dataReader)
{
dataReader.NextResult();
if (dataReader.Read())
{
this._name = new StaffNameFormatter();
this._name.Forename = dataReader["Forename"] as string;
this._name.Surname = dataReader["Surname"] as string;
this._name.HoldingName = dataReader["HoldingName"] as string;
this._name.DisplayForenameFirst = true;
}
dataReader.NextResult();
dataReader.Read();
}
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()
{
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();
}
}
