public void LoadAdminData(int pID) { pdl.LoadPersonData(pID); try { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "select p.* from permissions p where p.ID=(Select PID from admin where Aid=" + pID + ")"; ; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { adm.permissionObj.setApproved(reader["Approved"].ToString()); adm.permissionObj.setBlkdev(reader["Block"].ToString()); adm.permissionObj.setDeldev(reader["D_Developer"].ToString()); adm.permissionObj.setDeluser(reader["D_User"].ToString()); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void LoadPersonData() { try { pdb = new PersonDBLayer(); pdb.LoadPersonData(pID); txtEmailAcc.Text = pdb.perObj.getEmail(); txtNameAcc.Text = pdb.perObj.getName(); txtPasswordAcc.Text = pdb.perObj.getPswd(); txtCountryAcc.Text = pdb.perObj.getCountry(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }