public NguoiDungDTO LayThongTinNguoiDungByMa(string tenDangNhap)
{
NguoiDungDTO nguoiDungDTO = new NguoiDungDTO();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "SELECT * FROM SysDanhMucNguoiDung WHERE MaNguoiDung = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNguoiDung", OleDbType.WChar).Value = tenDangNhap;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
nguoiDungDTO.Id = (int)dr["Id"];
nguoiDungDTO.MaNguoiDung = (string)dr["MaNguoiDung"];
nguoiDungDTO.TenNguoiDung = (string)dr["TenNguoiDung"];
nguoiDungDTO.MatKhau = (string)dr["MatKhau"];
nguoiDungDTO.VoHieu = (bool)dr["VoHieu"];
nguoiDungDTO.IdChucDanh = (int)dr["IdChucDanh"];
nguoiDungDTO.DiaChi = (string)dr["DiaChi"];
nguoiDungDTO.DienThoai = (string)dr["DienThoai"];
nguoiDungDTO.NgayBatDau = (DateTime)dr["NgayBatDau"];
nguoiDungDTO.NgayKetThuc = (DateTime)dr["NgayKetThuc"];
nguoiDungDTO.GhiChu = (string)dr["GhiChu"];
}
return nguoiDungDTO;
}
public BindingList<NguoiDungDTO> LayDanhSach()
{
BindingList<NguoiDungDTO> danhSach = new BindingList<NguoiDungDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From SysDanhMucNguoiDung";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
NguoiDungDTO itemDTO = new NguoiDungDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaNguoiDung = (string)dr["MaNguoiDung"];
itemDTO.TenNguoiDung = (string)dr["TenNguoiDung"];
itemDTO.MatKhau = (string)dr["MatKhau"];
itemDTO.VoHieu = (bool)dr["VoHieu"];
itemDTO.IdChucDanh = (int)dr["IdChucDanh"];
itemDTO.DiaChi = (string)dr["DiaChi"];
itemDTO.DienThoai = (string)dr["DienThoai"];
itemDTO.NgayBatDau = (DateTime)dr["NgayBatDau"];
itemDTO.NgayKetThuc = (DateTime)dr["NgayKetThuc"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return danhSach;
}
private void bbiDangNhapLai_ItemClick(object sender, ItemClickEventArgs e)
{
nguoiDungDTO = new NguoiDungDTO();
this.bsiTenNguoiDung.Caption = "";
this.ribbon.Visible = false;
xtraTabbedMdiManager.ClosePageButtonShowMode = ClosePageButtonShowMode.Default;
var form = new fDangNhap();
form.LoginEvent += form_LoginEvent;
form.thoatChuongTrinh += form_thoatChuongTrinh;
form.MdiParent = this;
form.Show();
}
public fThongTinCaNhan(NguoiDungDTO iNdDTO)
{
InitializeComponent();
nguoiDungDTO = iNdDTO;
}
void form_LoginEvent(string tenDangNhap)
{
this.ribbon.Visible = true;
NguoiDungBUS nguoiDungBUS = new NguoiDungBUS();
nguoiDungDTO = nguoiDungBUS.LayThongTinNguoiDungByMa(tenDangNhap);
this.bsiTenNguoiDung.Caption = nguoiDungDTO.TenNguoiDung.ToString();
}
public void Them(NguoiDungDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into SysDanhMucNguoiDung (MaNguoiDung, TenNguoiDung, MatKhau, VoHieu, IdChucDanh, DiaChi, DienThoai, NgayBatDau, NgayKetThuc, GhiChu) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNguoiDung", OleDbType.WChar).Value = itemDTO.MaNguoiDung;
cmd.Parameters.Add("@TenNguoiDung", OleDbType.WChar).Value = itemDTO.TenNguoiDung;
cmd.Parameters.Add("@MatKhau", OleDbType.WChar).Value = itemDTO.MatKhau;
cmd.Parameters.Add("@VoHieu", OleDbType.Boolean).Value = itemDTO.VoHieu;
cmd.Parameters.Add("@IdChucDanh", OleDbType.Numeric).Value = itemDTO.IdChucDanh;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@NgayBatDau", OleDbType.DBDate).Value = itemDTO.NgayBatDau;
cmd.Parameters.Add("@NgayKetThuc", OleDbType.DBDate).Value = itemDTO.NgayKetThuc;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Sua(NguoiDungDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update SysDanhMucNguoiDung Set MaNguoiDung = ?, TenNguoiDung = ?, MatKhau = ?, VoHieu = ?, IdChucDanh = ?, DiaChi = ?, DienThoai = ?, NgayBatDau = ?, NgayKetThuc = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNguoiDung", OleDbType.WChar).Value = itemDTO.MaNguoiDung;
cmd.Parameters.Add("@TenNguoiDung", OleDbType.WChar).Value = itemDTO.TenNguoiDung;
cmd.Parameters.Add("@MatKhau", OleDbType.WChar).Value = itemDTO.MatKhau;
cmd.Parameters.Add("@VoHieu", OleDbType.Boolean).Value = itemDTO.VoHieu;
cmd.Parameters.Add("@IdChucDanh", OleDbType.Numeric).Value = itemDTO.IdChucDanh;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@NgayBatDau", OleDbType.DBDate).Value = itemDTO.NgayBatDau;
cmd.Parameters.Add("@NgayKetThuc", OleDbType.DBDate).Value = itemDTO.NgayKetThuc;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}