private void UpdateProfile_Load(object sender, EventArgs e)
{
Member updateMember = new Member();
updateMember = memberDAO.getMemberById(LoginPage.memId);
tbFirstname.Text = updateMember.Firstname;
tbLastname.Text = updateMember.Lastname;
tbAddress1.Text = updateMember.Address;
tbCity.Text = updateMember.City;
tbUser.Text = updateMember.Username;
tbPass.Text = updateMember.Password;
tbEmail.Text = updateMember.Email;
tbPicture.Text = updateMember.Picture;
pictureBox.Image = new Bitmap(updateMember.Picture);
}
public Member getMemberById(int id)
{
String oradb = "Data Source= cp3dbinstance.c4pxnpz4ojk8.us-east-1.rds.amazonaws.com:1521/cp3db;User Id=sw1;Password=CampBand4;";
OracleConnection conn = new OracleConnection(oradb);
Member thisMem = null;
try
{
OracleCommand cmd = new OracleCommand("SELECT * FROM MEMBERS WHERE MEMID = " + id + "", conn);
conn.Open();
OracleDataReader dr = cmd.ExecuteReader();
dr.Read();
String firstName = dr.GetString(1);
String lastName = dr.GetString(2);
String address = dr.GetString(3);
String city = dr.GetString(4);
String username = dr.GetString(5);
String password = dr.GetString(6);
String picture = dr.GetString(7);
String email = dr.GetString(8);
DateTime regdate = dr.GetDateTime(9);
thisMem = new Member(
id, firstName, lastName, address,
city, username, password, email,
regdate.ToString("dd-MMM-yyyy"), picture);
conn.Close();
return thisMem;
}
catch (OracleException ex)
{
MessageBox.Show("Something went wrong when accessing the database.");
MessageBox.Show("sql error");
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return null;
}
