public static List <LoaiNhanVienCNDTO> LayLoaiNhanVien()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayLoaiNhanVien";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//LoaiNhanVienDTO loaiNV = new LoaiNhanVienDTO();
int maLoaiNhanVien = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString());
string tenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString();
double luong = Int32.Parse(dt.Rows[i]["Luong"].ToString());
LoaiNhanVienCNDTO loaiNV = new LoaiNhanVienCNDTO(maLoaiNhanVien, tenLoaiNhanVien, luong);
list.Add(loaiNV);
//NhaHangDTO nhaHang = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai);
//list.Add(nhaHang);
}
}
return(list);
}
private void loadLoaiNhanVien()
{
m_cboxMaLoai.Items.Clear();
//m_cboxMaLoai.Items.Add("Chon Loại Nhân Viên");
LoaiNhanVienCNDTO lnv = new LoaiNhanVienCNDTO(0, "Tất cả", 0);
List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>();
list = LoaiNhanVienCNBUS.LayLoaiNhanVien();
list.Insert(0, lnv);
m_cboxMaLoai.ValueMember = "MaLoaiNhanVien";
m_cboxMaLoai.DisplayMember = "TenLoaiNhanVien";
m_cboxMaLoai.DataSource = list;
m_cboxMaLoai.SelectedIndex = 0;
}
