public void LayDuLieuLenComboBox_DK_DAY(ComboBox cmb, string maday)
{
NguoiDungData hd = new NguoiDungData();
cmb.DataSource = hd.LayDSNguoiDung_DK_DAY(maday);
cmb.DisplayMember = "TENPHG";
cmb.ValueMember = "MAPHG";
}
public bool Update(NguoiDungInfo info, string newPassword)
{
if (this.m_Data == null)
{
this.m_Data = new NguoiDungData();
}
return(this.m_Data.Update(info.MaNguoiDung, newPassword));
}
public void LayDuLieuLenComboBox(ComboBoxEx cmb)
{
NguoiDungData hd = new NguoiDungData();
DataTable table = hd.LayDSNguoiDung();
cmb.DataSource = table;
cmb.DisplayMember = "TENPHG";
cmb.ValueMember = "MAPHG";
}
public void HienThiComboBox(ComboBox cmb)
{
if (this.Data == null)
{
this.Data = new NguoiDungData();
}
cmb.DataSource = this.Data.LayDS();
cmb.DisplayMember = "TenNguoiDung";
cmb.ValueMember = "MaNguoiDung";
}
public void HienThiDataGridViewComboBoxColumn(DataGridViewComboBoxColumn cmb)
{
if (this.Data == null)
{
this.Data = new NguoiDungData();
}
cmb.DataSource = this.Data.LayDS();
cmb.DisplayMember = "TenNguoiDung";
cmb.ValueMember = "MaNguoiDung";
cmb.DataPropertyName = "MaNguoiDung";
}
public void LayDuLieuLenComboBoxItem(ComboBoxItem cmb)
{
NguoiDungData hd = new NguoiDungData();
DataTable table = hd.LayDSNguoiDung();
foreach (DataRow row in table.Rows)
{
cmb.Items.Add(row["TenPHG"]);
}
//cmb.DisplayMember = "TENPHG";
//cmb.ValueMember = "MAPHG";
}
public int LayMaMax()
{
NguoiDungData data = new NguoiDungData();
DataTable table = data.LayMaMax();
try
{
int i = Convert.ToInt32(table.Rows[0][0].ToString());
return(++i);
}
catch (Exception e)
{
e.ToString();
return(1);
}
}
public void HienThiDS(DataGridView dgv, BindingNavigator bn, TextBox txtTenDangNhap, TextBox txtMatKhau, ComboBox cmbLoaiNguoiDung, TextBox txtTenNguoiDung, ComboBox cmbGiaoVien)
{
if (this.Data == null)
{
this.Data = new NguoiDungData();
}
BindingSource bs = new BindingSource();
bs.DataSource = this.Data.LayDS();
bn.BindingSource = bs;
dgv.DataSource = bs;
txtTenDangNhap.DataBindings.Add("Text", bs, "TenDangNhap");
txtMatKhau.DataBindings.Add("Text", bs, "MatKhau");
cmbLoaiNguoiDung.DataBindings.Add("SelectedValue", bs, "MaLoai");
txtTenNguoiDung.DataBindings.Add("Text", bs, "TenNguoiDung");
cmbGiaoVien.DataBindings.Add("SelectedValue", bs, "MaGiaoVien");
}
public NguoiDungInfo LayNguoiDung(string tendangnhap)
{
if (this.Data == null)
{
this.Data = new NguoiDungData();
}
DataTable tbl = this.Data.LayNguoiDung(tendangnhap);
if (tbl.Rows.Count >= 1)
{
DataRow row = tbl.Rows[0];
LoaiNguoiDungController LoaiNguoiDungCtrl = new LoaiNguoiDungController();
GiaoVienController GiaoVienCtrl = new GiaoVienController();
return(new NguoiDungInfo(int.Parse(row["MaNguoiDung"].ToString()), LoaiNguoiDungCtrl.LayTuMa(int.Parse(row["MaLoai"].ToString())), row["TenNguoiDung"].ToString(), row["TenDangNhap"].ToString(), row["MatKhau"].ToString(), GiaoVienCtrl.LayTuMa(row["MaGiaoVien"].ToString())));
}
else
{
return(null);
}
}
public void HienThi(ListView list)
{
NguoiDungData NguoiDung = new NguoiDungData();
list.Items.Clear();
DataTable table = NguoiDung.LayDSNguoiDung();
foreach (DataRow row in table.Rows)
{
NguoiDungInfo info = RowToInfo(row);
ListViewItem item = new ListViewItem();
item.Text = info.Ma.ToString();
item.SubItems.Add(info.HoTen);
item.SubItems.Add(info.Username);
item.SubItems.Add(info.Password);
item.SubItems.Add(info.Quyen.ToString());
item.Tag = info;
list.Items.Add(item);
}
//----------------
}
public bool Sua(NguoiDungInfo NguoiDung)
{
NguoiDungData data = new NguoiDungData();
return(data.Sua(NguoiDung));
}
public bool Them(NguoiDungInfo NguoiDung)
{
NguoiDungData data = new NguoiDungData();
return(data.Them(NguoiDung));
}
