Пример #1
0
        DataTable getPass()
        {
            DataTable dt = new DataTable();

            dt = lg.getAccountbyUser(GLOBAL.username);
            return(dt);
        }
Пример #2
0
        public void updateEmployee()
        {
            DataTable dt = new DataTable();

            dt = employee.getEmployeebyID(EMPLOYEEs.EmployeeID);
            lbIDEmployee.Text         = EMPLOYEEs.EmployeeID;
            txtFname.Text             = dt.Rows[0][3].ToString();
            txtLname.Text             = dt.Rows[0][4].ToString();
            txtIDCard.Text            = dt.Rows[0][10].ToString();
            dateTimePickerBdate.Value = Convert.ToDateTime(dt.Rows[0][5].ToString());
            txtPhone.Text             = dt.Rows[0][8].ToString();
            txtAddress.Text           = dt.Rows[0][6].ToString();
            txtSalary.Text            = dt.Rows[0][9].ToString();
            txtUsername.Text          = EMPLOYEEs.EmployeeID;
            DataTable data = log.getAccountbyUser(EMPLOYEEs.EmployeeID);

            txtPass.Text = data.Rows[0][1].ToString();
            string gr = dt.Rows[0][1].ToString();

            // MessageBox.Show(gr.ToString());
            if (gr == "01")
            {
                cbGroupName.Text = "Salesman";
                txtGroupID.Text  = "01";
            }
            else
            {
                txtGroupID.Text  = "02";
                cbGroupName.Text = "Personal Trainer";
            }
            gender = dt.Rows[0][7].ToString();
            if (gender == "Female")
            {
                radioFemaleEdit.Checked = true;
            }
            else
            {
                radioMaleEdit.Checked = true;
            }
            byte[] picPD;
            picPD = (byte[])dt.Rows[0][2];
            MemoryStream pic = new MemoryStream(picPD);

            this.picAvaEdit.Image = Image.FromStream(pic);
        }