private ThemTaiKhoanNguoiDung LayThongTinYTa() { ThemTaiKhoanNguoiDung ttk1 = new ThemTaiKhoanNguoiDung(); ttk1.MaYTa = cboMaYTa.SelectedValue.ToString(); ttk1.HoYTa = txtHoYTa.Text; ttk1.TenYTa = txtTenYTa.Text; ttk1.MaNhomYT = cboMaNhomYT.SelectedValue.ToString(); ttk1.TenNhomYT = txtTenNhomYT.Text; ttk1.UsernameYT = txtTaiKhoanYT.Text; ttk1.PasswordYT = txtMatKhauYT.Text; return ttk1; }
//Ham lay thong tin tai khoan bac si private ThemTaiKhoanNguoiDung LayThongTinNhanVien() { ThemTaiKhoanNguoiDung ttk2 = new ThemTaiKhoanNguoiDung(); ttk2.MaNhanVien = cboMaNhanVien.SelectedValue.ToString(); ttk2.HoNhanVien = txtHoNhanVien.Text; ttk2.TenNhanVien = txtTenNhanVien.Text; ttk2.MaNhomNV = cboMaNhomNV.SelectedValue.ToString(); ttk2.TenNhomNV = txtTenNhomNV.Text; ttk2.UsernameNV = txtTaiKhoanNV.Text; ttk2.PasswordNV = txtMatKhauNV.Text; return ttk2; }
public bool ThemTaiKhoanYTa(ThemTaiKhoanNguoiDung TTK) { TTK.PasswordYT = Utilities.MaHoaMD5(TTK.PasswordYT); string sql = string.Format("Insert into USERS (STT, MaNhom, Username, Password, Ho, Ten, MaNguoiDung)" + "values('{0}', '{1}', '{2}', '{3}', N'{4}', N'{5}', '{6}')", "0", TTK.MaNhomYT, TTK.UsernameYT, TTK.PasswordYT, TTK.HoYTa, TTK.TenYTa, TTK.MaYTa); if (conData.ExcuteQuery(sql)) return true; return false; }
//Ham lay thong tin tai khoan bac si private ThemTaiKhoanNguoiDung LayThongTinBacSi() { ThemTaiKhoanNguoiDung ttk = new ThemTaiKhoanNguoiDung(); ttk.MaBacSi = cboMaBacSi.SelectedValue.ToString(); ttk.HoBacSi = txtHoBacSi.Text; ttk.TenBacSi = txtTenBacSi.Text; ttk.MaNhomBS = cboMaNhomBS.SelectedValue.ToString(); ttk.TenNhomBS = txtTenNhomBS.Text; ttk.UsernameBS = txtTaiKhoanBS.Text; ttk.PasswordBS = txtMatKhauBS.Text; return ttk; }
public bool SuaDoiTaiKhoanYTa(ThemTaiKhoanNguoiDung ttk) { ttk.PasswordYT = Utilities.MaHoaMD5(ttk.PasswordYT); string sql = string.Format("Update USERS set Username = '******', Password = '******', Ho = N'{2}', Ten = N'{3}'," + " MaNhom = '{4}' where MaNguoiDung = '{5}'", ttk.UsernameYT, ttk.PasswordYT, ttk.HoYTa, ttk.TenYTa, ttk.MaNhomYT, ttk.MaYTa); if (conData.ExcuteQuery(sql)) return true; return false; }