public List<NhanVien> GetList()
{
List<NhanVien> list = new List<NhanVien>();
string sqlQuery = "select * from NhanVien";
reader = ExecuteReader(sqlQuery);
while (reader.Read())
{
NhanVien nhanVien = new NhanVien();
nhanVien.MaNV = reader["MaNV"].ToString();
nhanVien.HoTen = reader["HoTen"].ToString();
nhanVien.GioiTinh = reader["GioiTinh"].ToString();
nhanVien.CMND = reader["CMND"].ToString();
nhanVien.NgaySinh = (DateTime)reader["NgaySinh"];
nhanVien.DiaChi = reader["DiaChi"].ToString();
nhanVien.SDT = reader["SDT"].ToString();
nhanVien.TaiKhoan = reader["TaiKhoan"].ToString();
list.Add(nhanVien);
}
return list;
}
public void Update(NhanVien info)
{
string sqlQuery = "update NhanVien" +
" set HoTen='" + info.HoTen + "'," +
"GioiTinh='" + info.GioiTinh + "'" +
"CMND='" + info.CMND + "'" +
"NgaySinh='" + info.NgaySinh.ToShortDateString() + "'" +
"DiaChi='" + info.DiaChi + "'" +
"SDT='" + info.SDT + "'" +
"TaiKhoan='" + info.TaiKhoan + "'" +
"where MaNV='" + info.MaNV + "'";
ExecuteNonQuery(sqlQuery);
}
public void Insert(NhanVien info)
{
string sqlQuery = "insert into NhanVien values ('" +
info.MaNV + "',N'" +
info.HoTen + "',N'" +
info.GioiTinh + "','" +
info.CMND + "','" +
info.NgaySinh.ToShortDateString() + "',N'" +
info.DiaChi + "','" +
info.SDT + "','" +
info.TaiKhoan + "')";
ExecuteNonQuery(sqlQuery);
}
public void Update(NhanVien info)
{
data.Update(info);
}
public void Insert(NhanVien info)
{
data.Insert(info);
}
