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