private bool HasState()
{
string fromForm = Core.WebServer.Request["State"];
if (string.IsNullOrEmpty(fromForm))
{
return(false);
}
switch (fromForm)
{
case "Unavailable":
this._state = TimetableStates.Unavailable;
break;
case "Free":
this._state = TimetableStates.Free;
break;
case "Teaching":
this._state = TimetableStates.Teaching;
break;
case "Busy":
this._state = TimetableStates.Busy;
break;
}
return(true);
}
protected override void InitialChecks()
{
if (this.HasStaffId() && this.HasWeekNo() && this.HasDayNo() && this.HasPeriod())
{
this.HasAlertMessage();
Core.Helpers.Database.ParameterBuilder paramBuilder = new Core.Helpers.Database.ParameterBuilder();
paramBuilder.AddParameter(SqlDbType.Int, "@StaffId", this._staffId);
paramBuilder.AddParameter(SqlDbType.Int, "@WeekNo", this._weekNo);
paramBuilder.AddParameter(SqlDbType.Int, "@DayNo", this._dayNo);
paramBuilder.AddParameter(SqlDbType.Int, "@Period", this._period);
using (SqlDataReader dataReader = Core.Helpers.Database.Provider.ExecuteReader("/Sql/Specific/Staff/Modify/Teaching/period.sql", paramBuilder.Parameters)) {
dataReader.Read();
if (((int)dataReader["Status"]).Equals(1))
{
this.PopulateName(dataReader);
switch ((int)dataReader["PeriodStatus"])
{
case 0:
this._state = TimetableStates.Unavailable;
break;
case 1:
this._state = TimetableStates.Free;
break;
case 2:
if (((int)dataReader["PeriodType"]).Equals(2))
{
this._state = TimetableStates.Busy;
}
else
{
this._state = TimetableStates.Teaching;
this._isUnique = (bool)dataReader["IsUnique"];
this._yeargroupId = dataReader["YeargroupId"] as int?;
this._yeargroupName = dataReader["YeargroupName"] as string;
this._roomId = dataReader["RoomId"] as int?;
this._roomName = dataReader["RoomName"] as string;
this._subjectId = dataReader["SubjectId"] as int?;
this._subjectName = dataReader["SubjectName"] as string;
this._qualificationName = dataReader["QualificationName"] as string;
this._subjectQualificationId = dataReader["SubjectQualificationId"] as int?;
this._classId = dataReader["ClassId"] as int?;
this._className = dataReader["ClassName"] as string;
}
this._commitmentName = dataReader["CommitmentName"] as string;
break;
}
}
else
{
Core.WebServer.PleaseTakes.Redirect("/staff/inputteaching/#Teaching");
}
}
}
else
{
Core.WebServer.PleaseTakes.Redirect("/staff/inputteaching/#Teaching");
}
}