protected void buildingDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
List<Room> rooms = new List<Room>();
aScheduleManager = new ScheduleManager();
rooms = aScheduleManager.GetAllRooms(Convert.ToInt16(buildingDropDownList.Text));
roomDropDownList.DataSource = rooms;
roomDropDownList.DataBind();
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
protected void Page_Load(object sender, EventArgs e)
{
msgLabel.Text = "";
try
{
departmentDropDownList.DataTextField = "DepartmentCode";
departmentDropDownList.DataValueField = "departmentId";
semesterDropDownList.DataTextField = "SemesterName";
semesterDropDownList.DataValueField = "SemesterId";
dayDropDownList.DataTextField = "dayName";
dayDropDownList.DataValueField = "dayId";
buildingDropDownList.DataTextField = "buildingName";
buildingDropDownList.DataValueField = "buildingId";
courseDropDownList.DataTextField = "courseCode";
courseDropDownList.DataValueField = "courseId";
roomDropDownList.DataTextField = "roomName";
roomDropDownList.DataValueField = "roomId";
if (!IsPostBack)
{
List<Course> courses = new List<Course>();
List<Day> days = new List<Day>();
List<Department> departments = new List<Department>();
List<Semester> semester = new List<Semester>();
List<Building> buildings = new List<Building>();
aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
SemesterManager aSemesterManager = new SemesterManager();
semester = aSemesterManager.GetAllSemesters();
aScheduleManager = new ScheduleManager();
buildings = aScheduleManager.GetAllBuildings();
days = aScheduleManager.GetAllDays();
aCourseManager = new CourseManager();
courses = aCourseManager.GetAllCourses();
dayDropDownList.DataSource = days;
dayDropDownList.DataBind();
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
semesterDropDownList.DataSource = semester;
semesterDropDownList.DataBind();
buildingDropDownList.DataSource = buildings;
buildingDropDownList.DataBind();
courseDropDownList.DataSource = courses;
courseDropDownList.DataBind();
}
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = exception.Message;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if(!IsValid)
{return;}
try
{
Schedule aSchedule = new Schedule();
aScheduleManager = new ScheduleManager();
aSchedule.Scheduledate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
aSchedule.DepartmentId = Convert.ToInt16(departmentDropDownList.Text);
aSchedule.SemesterId = Convert.ToInt16(semesterDropDownList.Text);
aSchedule.CourseId = Convert.ToInt16(courseDropDownList.Text);
aSchedule.BuildingId = Convert.ToInt16(buildingDropDownList.Text);
aSchedule.RoomId = roomDropDownList.Text;
aSchedule.StartTime = float.Parse(startTimeDropDownList.Text);
aSchedule.EndingTime = float.Parse(endingTimeDropDownList.Text);
aSchedule.DayId = Convert.ToInt16(dayDropDownList.Text);
aSchedule.ScheduleStatus = 0;
string msg = aScheduleManager.SaveClassSchedule(aSchedule);
if (msg == "Saved")
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text = msg;
}
else
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = msg;
}
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
