private void SetTimetable() { Database.ParameterBuilder paramBuilder = new Database.ParameterBuilder(); paramBuilder.AddParameter(SqlDbType.Int, "@StaffId", this._staffId); paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this.WeekNo); paramBuilder.AddParameter(SqlDbType.Bit, "@CurrentSession", true); using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Elements/Datagrids/Timetables/stafftimetable.sql", paramBuilder.Parameters)) { dataReader.Read(); this._databaseResponse = (int)dataReader["Status"]; dataReader.NextResult(); this._periodsTable = Database.Provider.GetDataTable(dataReader); this.SetCells(); } }
private bool GetData() { Database.ParameterBuilder paramBuilder = new 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 (string.IsNullOrEmpty(this._searchTerm)) { paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", ""); } else { paramBuilder.AddParameter(SqlDbType.VarChar, "@SearchTerm", this._searchTerm); } using (SqlDataReader dataReader = Database.Provider.ExecuteReader("/Sql/Elements/Datagrids/Summary/results.sql", paramBuilder.Parameters)) { if (dataReader.HasRows) { this._selectedStaff = new SelectedStaff(); while (dataReader.Read()) { StaffMember staffMember = new StaffMember(); staffMember.Id = (int)dataReader["StaffId"]; staffMember.Forename = dataReader["Forename"] as string; staffMember.Surname = dataReader["Surname"] as string; staffMember.HoldingName = dataReader["HoldingName"] as string; this._selectedStaff.Add(staffMember); this._searchCount++; } dataReader.NextResult(); this._periodsTable = Database.Provider.GetDataTable(dataReader); return(true); } else { return(false); } } }