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