protected void Page_Load(object sender, EventArgs e)
{
msgLabel.Text = "";
departments = new List<Department>();
DepartmentManager aDepartmentManager = new DepartmentManager();
if (!IsPostBack)
{
try
{
departments = aDepartmentManager.GetAllDepartments();
departmentGridView.DataSource = departments;
departmentGridView.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
{
List<Department> departments = new List<Department>();
List<Semester> semester = new List<Semester>();
departmentDropDownList.DataTextField = "DepartmentCode";
departmentDropDownList.DataValueField = "departmentId";
semesterDropDownList.DataTextField = "SemesterName";
semesterDropDownList.DataValueField = "SemesterId";
aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
SemesterManager aSemesterManager = new SemesterManager();
semester = aSemesterManager.GetAllSemesters();
if (!IsPostBack)
{
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
semesterDropDownList.DataSource = semester;
semesterDropDownList.DataBind();
}
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = exception.Message;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
try
{
Course aCourse = new Course();
aCourse.CourseCode = codeTextBox.Value;
aCourse.CourseName = titleTextBox.Value;
aCourse.Credit = Convert.ToDouble(creditTextBox.Value);
aCourse.Description = descriptionTextBox.Value;
aCourse.CourseStatus = 0;
aDepartmentManager = new DepartmentManager();
aCourse.ADepartment = aDepartmentManager.GetDepartment(Convert.ToInt16(departmentDropDownList.Text));
SemesterManager aSemesterManager = new SemesterManager();
aCourse.ASemester = aSemesterManager.GetSemester(Convert.ToInt16(semesterDropDownList.Text));
CourseManager aCourseManager = new CourseManager();
string msg = aCourseManager.SaveCourse(aCourse);
if (msg == "Saved")
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text = msg;
ClearAllTextBoxes();
}
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;
}
}
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;
}
if (codeTextBox.Value.Length < 3)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Department Code Must be Three Character";
return;
}
DepartmentManager aDepartmentManager = new DepartmentManager();
try
{
aDepartment = new Department();
aDepartment.DepartmentCode = codeTextBox.Value;
aDepartment.DepartmentName = nameTextBox.Value;
string msg = aDepartmentManager.SaveDepartment(aDepartment);
if (msg == "Saved")
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text = msg;
ClearAllTextBoxses();
}
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;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if(!IsValid)
{
return;
}
try
{
aTeacherManager = new TeacherManager();
Teacher aTeacher = new Teacher();
aTeacher.Name = nameTextBox.Value;
aTeacher.Address = addressTextBox.Value;
aTeacher.Email = emailTextBox.Value;
aTeacher.ContactNo = contactNoTextBox.Value;
aTeacher.AssignCredit = Convert.ToDouble(assignCreditTextBox.Value);
DesignationManager aDesignationManager = new DesignationManager();
aTeacher.ADesignation = aDesignationManager.GetDesignation(Convert.ToInt16(designationDropDownList.Text));
DepartmentManager aDepartmentManager = new DepartmentManager();
aTeacher.ADepartment = aDepartmentManager.GetDepartment(Convert.ToInt16(departmentDropDownList.Text));
string teacherId = aTeacherManager.GetTeacherId(Convert.ToInt16(departmentDropDownList.Text));
aTeacher.TeacherId = aTeacher.ADepartment.DepartmentCode.ToString() + "-" + teacherId + contactNoTextBox.Value;
string msg = aTeacherManager.SaveTeacher(aTeacher);
if (msg == aTeacher.TeacherId)
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text =aTeacher.Name+" your Id is :"+ msg;
ClearAllTextBoxes();
}
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
msgLabel.Text = "";
try
{
departmentDropDownList.DataTextField = "DepartmentCode";
departmentDropDownList.DataValueField = "departmentId";
semesterDropDownList.DataTextField = "SemesterName";
semesterDropDownList.DataValueField = "SemesterId";
if (!IsPostBack)
{
List<Department> departments = new List<Department>();
List<Semester> semester = new List<Semester>();
aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
SemesterManager aSemesterManager = new SemesterManager();
semester = aSemesterManager.GetAllSemesters();
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
semesterDropDownList.DataSource = semester;
semesterDropDownList.DataBind();
GetAllUnscheduleCourses();
}
}
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
{
List<Course> courses = new List<Course>();
List<Department> departments = new List<Department>();
departmentDropDownList.DataTextField = "DepartmentCode";
departmentDropDownList.DataValueField = "departmentId";
courseDropDownList.DataTextField = "courseCode";
courseDropDownList.DataValueField = "courseId";
if (!IsPostBack)
{
aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
aCourseManager = new CourseManager();
courses = aCourseManager.GetAllCourses();
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
courseDropDownList.DataSource = courses;
courseDropDownList.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";
designationDropDownList.DataTextField = "DesignationName";
designationDropDownList.DataValueField = "Id";
if (!IsPostBack)
{
DepartmentManager aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
DesignationManager aDesignationManager = new DesignationManager();
aTeacherManager = new TeacherManager();
designation = aDesignationManager.GetAllDesignations();
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
designationDropDownList.DataSource = designation;
designationDropDownList.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";
examSelectDropDownList.DataTextField = "ExaminationType";
examSelectDropDownList.DataValueField = "ExaminationId";
if (!IsPostBack)
{
aStudent = new Student();
ViewState["RegistationNo"] = "";
ViewState["Certificates"] = certificates;
Session["aStudent"] = aStudent;
DepartmentManager aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
ExaminationManager anExaminationManager = new ExaminationManager();
examinations = anExaminationManager.GetAllExaminations();
examSelectDropDownList.DataSource = examinations;
examSelectDropDownList.DataBind();
departmentDropDownList.DataSource = departments;
departmentDropDownList.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;
}
}
