protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
usersLogin = new UsersLogin();
teachers = new Teacher();
scDao = new SchoolDao();
string strTeacherLastName = txtLastName.Text;
string strTeacherFirstName = txtFirstName.Text;
string strTeacherDepartment = txtDepartament.Text;
string strUserEmail = inputEmail.Text;
string strPassword = inputPassword.Text;
teachers.TeacherLastName = strTeacherLastName;
teachers.TeacherFirstName = strTeacherFirstName;
teachers.TeacherDepartment = strTeacherDepartment;
usersLogin.UserEmail = strUserEmail;
usersLogin.UserPassword = scDao.CreatePasswordHash(strPassword);
scDao.InsetTeachers(teachers, usersLogin);
lblMsg.Text = "Teacher Inserted!";
btnInsert.Enabled = false;
}
catch (Exception ex)
{
lblMsg.Text=ex.Message.ToString();
}
}
public void InsetTeachers(Teacher teacher, UsersLogin usersLogin)
{
try{
OpenConnection();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "InsertTeacher";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@TeacherLastName", teacher.TeacherLastName);
cmd.Parameters.AddWithValue("@TeacherFirstName", teacher.TeacherFirstName);
cmd.Parameters.AddWithValue("@TeacherDepartment", teacher.TeacherDepartment);
cmd.Parameters.AddWithValue("@UserEmail", usersLogin.UserEmail);
cmd.Parameters.AddWithValue("@UserPassword", usersLogin.UserPassword);
cmd.ExecuteNonQuery();
}
catch (Exception){
throw;
}
finally {
ClosedConnection();
}
}
