public List <NhanVien> layDanhSachNhanVien()
{
List <NhanVien> ds = new List <NhanVien>();
string query = "select * from NhanVien";
DataTable table = docDuLieu(query);
//Mot lan nua Kiem tra xem id co ton tai hay khong de cho chac chan
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
int id = (int)row[0];
string hoTen = Convert.ToString(row[1]);
string n = Convert.ToString(row[2]);
DateTime namSinh = DateTime.Parse(n);
bool gioiTinh = Convert.ToString(row[3]) == "Nam"?true:false;
string queQuan = Convert.ToString(row[4]);
string sdt = Convert.ToString(row[5]);
int idTaiKhoan = (int)row[6];
string tenChucVu = Convert.ToString(row[7]);
NhanVien nv = new NhanVien(id, hoTen, namSinh, queQuan, sdt, gioiTinh, idTaiKhoan, tenChucVu);
nv.QuyenHanNhanVien = QuyenHanDAO.LayDanhSachPhanQuyen(nv.IdNhanVien);
ds.Add(nv);
}
return(ds);
}
public NhanVien layMotNhanVien(int idDangNhap)
{
NhanVien nv = new NhanVien();
string query = "select * from NhanVien where taiKhoanID = " + idDangNhap;
DataTable table = docDuLieu(query);
//Mot lan nua Kiem tra xem id co ton tai hay khong de cho chac chan
if (table == null || table.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
int id = (int)row["maNhanVien"];
string hoTen = Convert.ToString(row["hoTen"]);
DateTime namSinh = Convert.ToDateTime(row["namSinh"]);
string queQuan = Convert.ToString(row["queQuan"]);
string sdt = Convert.ToString(row["SDT"]);
bool gioiTinh = Convert.ToBoolean(row["gioiTinh"]);
int idTaiKhoan = (int)row["taiKhoanID"];
string tenChucVu = Convert.ToString(row["tenChucVu"]);
nv = new NhanVien(id, hoTen, namSinh, queQuan, sdt, gioiTinh, idTaiKhoan, tenChucVu);
nv.QuyenHanNhanVien = QuyenHanDAO.LayDanhSachPhanQuyen(nv.IdNhanVien);
}
return(nv);
}