DataTable getPass() { DataTable dt = new DataTable(); dt = lg.getAccountbyUser(GLOBAL.username); return(dt); }
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); }