Esempio n. 1
0
        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);
            }
        }
Esempio n. 2
0
        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);
            }
        }