public static List <KhachHangDTO> LayDanhSachKhachHang()
{
List <KhachHangDTO> lkh = new List <KhachHangDTO>();
try
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachKhachHang");
while (reader.Read())
{
KhachHangDTO kh = new KhachHangDTO();
kh.MaKH = reader.GetString(0);
kh.HoTen = reader.GetString(1);
kh.NgaySinh = reader.GetDateTime(2);
kh.Cmnd = reader.GetString(3);
kh.Sdt = reader.GetString(4);
kh.DiaChi = reader.GetString(5);
kh.NgayDK = reader.GetDateTime(6);
kh.Loai = reader.GetString(7);
kh.DoanhSo = (uint)reader.GetDecimal(8);
lkh.Add(kh);
}
reader.Close();
}
catch
{
}
return(lkh);
}
public static List <HoaDonDTO> LayDanhSachHoaDon()
{
List <HoaDonDTO> lhd = new List <HoaDonDTO>();
try
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachHoaDon");
while (reader.Read())
{
HoaDonDTO hd = new HoaDonDTO();
hd.SoHD = reader.GetInt32(0);
hd.MaKH = reader.GetString(1);
hd.MaNV = reader.GetString(2);
hd.NgayHoaDon = reader.GetDateTime(3);
hd.TriGia = (int)reader.GetDecimal(4);
lhd.Add(hd);
}
reader.Close();
}
catch
{
}
return(lhd);
}
public static List <string> LayDanhSachMaSP()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachMaSP");
List <string> dssp = new List <string>();
while (reader.Read())
{
string sp = reader.GetString(0);
dssp.Add(sp);
}
reader.Close();
return(dssp);
}
public static List <DanhMucDTO> LayDanhMuc()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachDanhMuc");
List <DanhMucDTO> danhmuc = new List <DanhMucDTO>();
while (reader.Read())
{
DanhMucDTO d = new DanhMucDTO();
d.MaDanhMuc = reader.GetString(0);
d.TenDanhMuc = reader.GetString(1);
danhmuc.Add(d);
}
reader.Close();
return(danhmuc);
}
public static List <TaiKhoanDTO> LayMaNVChuaTaoTK()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayMaNVChuaTaoTK");
List <TaiKhoanDTO> ltk = new List <TaiKhoanDTO>();
while (reader.Read())
{
TaiKhoanDTO tk = new TaiKhoanDTO();
tk.id = "1";
tk.pass = "******";
tk.manv = reader.GetString(0);
tk.chucvu = reader.GetString(1);
ltk.Add(tk);
}
reader.Close();
return(ltk);
}
public static List <TaiKhoanDTO> LayDanhSachTaiKhoan()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachTaiKhoan");
List <TaiKhoanDTO> ltk = new List <TaiKhoanDTO>();
while (reader.Read())
{
TaiKhoanDTO tk = new TaiKhoanDTO();
tk.id = reader.GetString(0);
tk.pass = reader.GetString(1);
tk.manv = reader.GetString(2);
tk.chucvu = reader.GetString(3);
ltk.Add(tk);
}
reader.Close();
return(ltk);
}
public static List <SanPhamDTO> LayDanhSachSanPham()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayToanBoSanPham");
List <SanPhamDTO> lsp = new List <SanPhamDTO>();
while (reader.Read())
{
SanPhamDTO sp = new SanPhamDTO();
sp.MaSP = reader.GetString(0);
sp.TenSP = reader.GetString(1);
sp.TenDanhMuc = reader.GetString(2);
sp.TenLoaiSP = reader.GetString(3);
sp.XuatXu = reader.GetString(4);
sp.DonViTinh = reader.GetString(5);
sp.GiaBan = (int)reader.GetDecimal(6);
sp.SoLuong = reader.GetInt32(7);
lsp.Add(sp);
}
reader.Close();
return(lsp);
}
public static List <NhanVienDTO> LayDanhSachNhanVien()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachNhanVien");
List <NhanVienDTO> lnv = new List <NhanVienDTO>();
while (reader.Read())
{
NhanVienDTO nv = new NhanVienDTO();
nv.MaNV = reader.GetString(0);
nv.HoTen = reader.GetString(1);
nv.NgaySinh = reader.GetDateTime(2);
nv.NgayVaoLam = reader.GetDateTime(3);
nv.SDT = reader.GetString(4);
nv.DiaChi = reader.GetString(5);
nv.ChucVu = reader.GetString(6);
nv.CMND = reader.GetString(7);
nv.Anh = (byte[])reader.GetValue(8);
lnv.Add(nv);
}
reader.Close();
return(lnv);
}
