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;
}
