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(); } }