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 assignButton_Click(object sender, EventArgs e)
{
try
{
TeacherCourse aTeacherCourse = new TeacherCourse();
TeacherManager aTeacherManager = new TeacherManager();
aTeacherCourse.CourseId = Convert.ToInt16(courseTitleDropDownList.Text);
aTeacherCourse.DepartmentId = Convert.ToInt16(departmentDropDownList.Text);
aTeacherCourse.TeacherId = teacherDropDownList.Text;
aTeacherCourse.AssignDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
aTeacherCourse.Status = 0;
float credit = float.Parse(creditTextBox.Value);
string msg = aTeacherManager.SaveTeacerCourse(aTeacherCourse, credit);
if (msg == "Saved")
{
msgLabel.ForeColor = Color.Green;
msgLabel.Text = msg;
GetTeacherAssignCredit();
}
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";
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;
}
}
private void GetTeachers()
{
try
{
int departmentId = Convert.ToInt16(departmentDropDownList.Text);
List<Teacher> teahers = new List<Teacher>();
TeacherManager aTeacherManager = new TeacherManager();
teahers = aTeacherManager.GetAllTeachers(departmentId);
teacherDropDownList.DataSource = teahers;
teacherDropDownList.DataBind();
GetTeacherAssignCredit();
}
catch (Exception exception)
{
throw exception;
}
}
private void GetTeacherAssignCredit()
{
try
{
Teacher aTeacher = new Teacher();
aTeacher.ADepartment = new Department();
aTeacher.ADepartment.DepartmentId = Convert.ToInt16(departmentDropDownList.Text);
aTeacher.TeacherId = teacherDropDownList.Text;
TeacherManager aTeacherManager = new TeacherManager();
aTeacher = aTeacherManager.GetTeacherCreditInfo(aTeacher);
assignCreditTextBox.Text = aTeacher.AssignCredit.ToString();
remainingCreditTextBox.Value = aTeacher.RemaningCredit.ToString();
}
catch (Exception exception)
{
throw exception;
}
}
