private void viewProfileFrm_Load(object sender, EventArgs e)
{
StudentDAOImpl student = new StudentDAOImpl();
Playground_frm loginForm = new Playground_frm();
loggedStudentID = loginForm.returnID();
MessageBox.Show(loggedStudentID.ToString() + " view");
forenameVal.Text = student.read(34).getForename();
surnameVal.Text = student.read(34).getSurname();
dobVal.Text = student.read(34).getDOB();
genderVal.Text = student.read(34).getGender();
studentNumVal.Text = student.read(34).getStudentNumber();
}
public School FindOne(int id)
{
OracleCommand command = new OracleCommand("Select * from Message where School.id=" + id + ")", Connection);
OracleDataReader reader;
reader = command.ExecuteReader();
reader.Read();
StudentDAOImpl studentDao = new StudentDAOImpl();
List<Message> list = new List<Message>();
School school = new School((int)reader.GetOracleNumber(0), reader.GetString(1), list);
return school;
}
private void remStudent()
{
string studentIDAsString = studIDTxt.Text;
int studentIDAsInt;
Boolean isConvertable = false;
isConvertable = Int32.TryParse(studentIDAsString, out studentIDAsInt);
if (isConvertable == false)
{
MessageBox.Show("Field/s entered incorrectly ");
}
StudentDAOImpl student = new StudentDAOImpl();
student.delete(studentIDAsInt);
MessageBox.Show("This Student has been removed");
}
//Author: Niall Stack
private void returnStudentValues()
{
string studentIDAsString = studIDTxt.Text;
string forename = forenameTxt.Text;
string surname = surnameTxt.Text;
string dob = dobTxt.Text;
string schoolIDAsString = SchoolIDTxt.Text;
string groupIDAsString = groupIDTxt.Text;
string gender = genderTxt.Text;
string pictureColAsString = imgTxt.Text.Trim();
string studentpassword = passwordTxt.Text;
string studentNumber = studNumTxt.Text.Trim();
string status = statusTxt.Text;
int studentIDAsInt;
int schoolIDAsInt;
int groupIDAsInt;
Byte[] pictureAsByte;
Boolean isConvertable = false;
isConvertable = Int32.TryParse(studentIDAsString, out studentIDAsInt);
isConvertable = Int32.TryParse(schoolIDAsString, out schoolIDAsInt);
isConvertable = Int32.TryParse(groupIDAsString, out groupIDAsInt);
pictureAsByte = System.Text.Encoding.UTF8.GetBytes(pictureColAsString);
if (isConvertable == false)
{
MessageBox.Show("Field/s entered incorrectly ");
}
StudentDAOImpl student = new StudentDAOImpl();
student.create(studentIDAsInt, forename, surname, dob, schoolIDAsInt, groupIDAsInt, gender, pictureAsByte, studentpassword, studentNumber, status);
}
public MessageDAO()
{
studentDao = new StudentDAOImpl();
connec = new OracleConnection("Data Source=cp3dbinstance.c4pxnpz4ojk8.us-east-1.rds.amazonaws.com:1521/cp3db;" + "User ID=sw4 ;Password=sw4");
}