public static List <NhanVienDTO> LayToanBoNhanVien()
{
List <NhanVienDTO> lst = new List <NhanVienDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaNhanVien", CommandType.StoredProcedure);
NhanVienDTO nv = null;
while ((r.Read()))
{
nv = new NhanVienDTO();
nv.MaNhanVien = Convert.ToInt32(r[0]);
nv.HoTen = r[1].ToString();
nv.ChucVu = r[2].ToString();
nv.DiaChi = r[3].ToString();
nv.Email = r[4].ToString();
nv.DienThoai = r[5].ToString();
nv.DiDong = r[6].ToString();
// kiểm tra xem có dữ liệu không?
if (r[7].ToString() != null)
{
nv.BoPhan = Convert.ToInt32(r[7]);
}
if (r[8].ToString() != null)
{
nv.QuanLy = Convert.ToInt32(r[8]);
}
nv.ConQuanLy = Convert.ToBoolean(r[9]);
lst.Add(nv);
}
p.Disconnect();
return(lst);
}
public static List <HangHoaDTO> _LayTatCaHangHoa()
{
List <HangHoaDTO> lst = new List <HangHoaDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("LayTatCaHangHoa", CommandType.StoredProcedure);
HangHoaDTO hh = null;
while ((r.Read()))
{
hh = new HangHoaDTO();
hh.MaHangHoa = Convert.ToInt32(r[0]);
hh.TenHangHoa = r[1].ToString();
hh.LoaiHangHoa = Convert.ToInt32(r[2]);
hh.KhoMacDinh = Convert.ToInt32(r[3]);
hh.PhanLoai = Convert.ToInt32(r[4]);
hh.DonVi = Convert.ToInt32(r[5]);
hh.XuatXu = r[6].ToString();
hh.TonKhoToiThieu = Convert.ToInt32(r[7]);
hh.TonKho = Convert.ToInt32(r[8]);
hh.NhaCungCap = Convert.ToInt32(r[9]);
hh.GiaMua = Convert.ToDouble(r[10]);
hh.GiaBan = Convert.ToDouble(r[11]);
hh.ConQuanLy = Convert.ToBoolean(r[12]);
lst.Add(hh);
}
p.Disconnect();
return(lst);
}
public static List <BoPhanDTO> LayToanBoBoPhan()
{
List <BoPhanDTO> lst = new List <BoPhanDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaBoPhan", CommandType.StoredProcedure);
BoPhanDTO bp;
while (r.Read())
{
bp = new BoPhanDTO();
bp.MaBoPhan = Convert.ToInt32(r[0]);
bp.TenBoPhan = r[1].ToString();
bp.GhiChu = r[2].ToString();
bp.ConQuanLy = Convert.ToBoolean(r[3]);
lst.Add(bp);
}
p.Disconnect();
return(lst);
}
public static HangHoaDTO LayThongTinHangHoaCanMuaTheoMa(int MaHangHoa)
{
HangHoaDTO hh = new HangHoaDTO();
DataProvider p = new DataProvider();
p.Connect();
SqlParameter p1 = new SqlParameter("@MaHangHoa", SqlDbType.Int)
{
Value = MaHangHoa
};
SqlDataReader r = p.GetReader("sp_LayThongTinHangHoaCanMuaTheoMa", CommandType.StoredProcedure, p1);
while ((r.Read()))
{
hh.MaHangHoa = Convert.ToInt32(r[0]);
hh.TenHangHoa = r[1].ToString();
hh.DonVi = Convert.ToInt32(r[2]);
hh.GiaMua = float.Parse(r[3].ToString());
}
p.Disconnect();
return(hh);
}
public static List <TaiKhoan_DTO> LayHetNguoiDung()
{
List <TaiKhoan_DTO> lst = new List <TaiKhoan_DTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayHetNguoiDung", CommandType.StoredProcedure);
TaiKhoan_DTO nd = null;
while ((r.Read()))
{
nd = new TaiKhoan_DTO();
nd.MaNguoiDung = Convert.ToInt32(r[0]);
nd.Ten = r[1].ToString();
nd.TaiKhoan = r[2].ToString();
nd.MatKhau = r[3].ToString();
nd.XacNhan = r[4].ToString();
nd.MaVaiTro = Convert.ToInt32(r[5]);
nd.GhiChu = r[6].ToString();
lst.Add(nd);
}
p.Disconnect();
return(lst);
}
public static List <KhoHangDTO> LayDanhSachKhoHang()
{
List <KhoHangDTO> lst = new List <KhoHangDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaKhoHang", CommandType.StoredProcedure);
KhoHangDTO kh = null;
while ((r.Read()))
{
kh = new KhoHangDTO();
kh.MaKho = Convert.ToInt32(r[0]);
kh.TenKho = r[1].ToString();
kh.NVQuanLy = Convert.ToInt32(r[2]);
kh.NguoiLienHe = r[3].ToString();
kh.DiaChi = r[4].ToString();
kh.DienThoai = r[5].ToString();
kh.Fax = r[6].ToString();
kh.Email = r[7].ToString();
kh.DienGiai = r[8].ToString();
kh.ConQuanLy = Convert.ToBoolean(r[9]);
lst.Add(kh);
}
p.Disconnect();
return(lst);
}
public static VaiTroDTO LayVaiTroTheoTaiKhoan(string TaiKhoan)
{
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayVaiTroTheoTaiKhoan", CommandType.StoredProcedure, new SqlParameter("@TaiKhoan", SqlDbType.VarChar, 50)
{
Value = TaiKhoan
});
VaiTroDTO vt = new VaiTroDTO();
while ((r.Read()))
{
vt.MaVaiTro = Convert.ToInt32(r[0]);
vt.Ten = r[1].ToString();
vt.PhanQuyen = Convert.ToBoolean(r[2]);
vt.DoiMatKhau = Convert.ToBoolean(r[3]);
vt.NhatKyHeThong = Convert.ToBoolean(r[4]);
vt.SaoLuu = Convert.ToBoolean(r[5]);
vt.PhucHoi = Convert.ToBoolean(r[6]);
vt.KhuVuc = Convert.ToBoolean(r[7]);
vt.KhachHang = Convert.ToBoolean(r[8]);
vt.NhaCungCap = Convert.ToBoolean(r[9]);
vt.KhoHang = Convert.ToBoolean(r[10]);
vt.DonViTinh = Convert.ToBoolean(r[11]);
vt.NhomHang = Convert.ToBoolean(r[12]);
vt.HangHoa = Convert.ToBoolean(r[13]);
vt.TyGia = Convert.ToBoolean(r[14]);
vt.BoPhan = Convert.ToBoolean(r[15]);
vt.NhanVien = Convert.ToBoolean(r[16]);
vt.MuaHang = Convert.ToBoolean(r[17]);
vt.BanHang = Convert.ToBoolean(r[18]);
vt.TonKho = Convert.ToBoolean(r[19]);
vt.ChuyenKho = Convert.ToBoolean(r[20]);
vt.ThuTien = Convert.ToBoolean(r[21]);
vt.TraTien = Convert.ToBoolean(r[22]);
vt.BaoCaoKhoHang = Convert.ToBoolean(r[23]);
vt.BaoCaoBanHang = Convert.ToBoolean(r[24]);
}
p.Disconnect();
return(vt);
}
public static List <VaiTroDTO> LayHetVaiTro()
{
List <VaiTroDTO> lst = new List <VaiTroDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayHetVaiTro", CommandType.StoredProcedure);
VaiTroDTO vt = null;
while ((r.Read()))
{
vt = new VaiTroDTO();
vt.MaVaiTro = Convert.ToInt32(r[0]);
vt.Ten = r[1].ToString();
vt.PhanQuyen = Convert.ToBoolean(r[2]);
vt.DoiMatKhau = Convert.ToBoolean(r[3]);
vt.NhatKyHeThong = Convert.ToBoolean(r[4]);
vt.SaoLuu = Convert.ToBoolean(r[5]);
vt.PhucHoi = Convert.ToBoolean(r[6]);
vt.KhuVuc = Convert.ToBoolean(r[7]);
vt.KhachHang = Convert.ToBoolean(r[8]);
vt.NhaCungCap = Convert.ToBoolean(r[9]);
vt.KhoHang = Convert.ToBoolean(r[10]);
vt.DonViTinh = Convert.ToBoolean(r[11]);
vt.NhomHang = Convert.ToBoolean(r[12]);
vt.HangHoa = Convert.ToBoolean(r[13]);
vt.TyGia = Convert.ToBoolean(r[14]);
vt.BoPhan = Convert.ToBoolean(r[15]);
vt.NhanVien = Convert.ToBoolean(r[16]);
vt.MuaHang = Convert.ToBoolean(r[17]);
vt.BanHang = Convert.ToBoolean(r[18]);
vt.TonKho = Convert.ToBoolean(r[19]);
vt.ChuyenKho = Convert.ToBoolean(r[20]);
vt.ThuTien = Convert.ToBoolean(r[21]);
vt.TraTien = Convert.ToBoolean(r[22]);
vt.BaoCaoKhoHang = Convert.ToBoolean(r[23]);
vt.BaoCaoBanHang = Convert.ToBoolean(r[24]);
lst.Add(vt);
}
p.Disconnect();
return(lst);
}
public static List <LoaiHangDTO> LayTatCaLoaiHangHoa()
{
List <LoaiHangDTO> lst = new List <LoaiHangDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaLoaiHang", CommandType.StoredProcedure);
LoaiHangDTO hh = null;
while ((r.Read()))
{
hh = new LoaiHangDTO();
hh.MaLoaiHH = Convert.ToInt32(r[0]);
hh.TenLoaiHH = r[1].ToString();
lst.Add(hh);
}
p.Disconnect();
return(lst);
}
public static List <TyGiaDTO> LoadTatCaTyGia()
{
List <TyGiaDTO> ltg = new List <TyGiaDTO>();
TyGiaDTO tg = null;
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaTyGia", CommandType.StoredProcedure);
while (r.Read())
{
tg = new TyGiaDTO();
tg.MaTyGia = Convert.ToInt32(r[0]);
tg.TenTyGia = r[1].ToString();
tg.TyGiaQuyDoi = Convert.ToDouble(r[2]);
tg.ConQuanLy = Convert.ToBoolean(r[3]);
ltg.Add(tg);
}
p.Disconnect();
return(ltg);
}
public static List <NhomHangDTO> LoadNhomHang()
{
List <NhomHangDTO> lnh = new List <NhomHangDTO>();
NhomHangDTO nh = default(NhomHangDTO);
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaNhomHang", CommandType.StoredProcedure);
while (r.Read())
{
nh = new NhomHangDTO();
nh.MaNhomHang = Convert.ToInt32(r[0]);
nh.TenNhomHang = Convert.ToString(r[1].ToString());
nh.GhiChu = Convert.ToString(r[2].ToString());
nh.ConQuanLy = Convert.ToBoolean(r[3]);
lnh.Add(nh);
}
p.Disconnect();
return(lnh);
}
public static List <Log_DTO> LoadNhatKyHoatDong()
{
DataProvider p = new DataProvider();
p.Connect();
List <Log_DTO> lnk = new List <Log_DTO>();
Log_DTO nk = null;
SqlDataReader r = p.GetReader("sp_LoadLog", CommandType.StoredProcedure);
while (r.Read())
{
nk = new Log_DTO();
nk.Ma = Convert.ToInt32(r[0]);
nk.TenND = r[1].ToString();
nk.ChucNang = r[2].ToString();
nk.HanhDong = r[3].ToString();
nk.ThoiGian = r[4].ToString();
lnk.Add(nk);
}
p.Disconnect();
return(lnk);
}
public static List <NhaCungCapDTO> LayDanhSachNhaCungCap()
{
List <NhaCungCapDTO> lst = new List <NhaCungCapDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayDuLieuNhaCungCap", CommandType.StoredProcedure);
NhaCungCapDTO ncc = null;
while ((r.Read()))
{
ncc = new NhaCungCapDTO();
ncc.MaNhaCungCap = Convert.ToInt32(r[0]);
ncc.TenNhaPhanPhoi = r[1].ToString();
ncc.DiaChi = r[2].ToString();
ncc.MaSoThue = r[3].ToString();
ncc.SoDiDong = r[4].ToString();
ncc.SoDienThoaiBan = r[5].ToString();
ncc.Email = r[6].ToString();
ncc.Fax = r[7].ToString();
ncc.Website = r[8].ToString();
ncc.SoTaiKhoan = r[9].ToString();
ncc.NganHang = r[10].ToString();
ncc.GioiHanNo = Convert.ToDouble(r[11]);
ncc.ChietKhau = Convert.ToDouble(r[12]);
ncc.NguoiLienHe = r[13].ToString();
ncc.ChucVu = r[14].ToString();
ncc.NoHienTai = Convert.ToDouble(r[15]);
ncc.KhuVuc = Convert.ToInt32(r[16]);
ncc.ConQuanLy = Convert.ToBoolean(r[17]);
lst.Add(ncc);
}
p.Disconnect();
return(lst);
}
public static List <DonViTinhDTO> LayToanBoDonVi()
{
List <DonViTinhDTO> lst = new List <DonViTinhDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaDonVi", CommandType.StoredProcedure);
DonViTinhDTO dv = null;
while ((r.Read()))
{
dv = new DonViTinhDTO();
dv.MaDV = Convert.ToInt32(r[0]);
dv.TenDonVi = r[1].ToString();
dv.GhiChu = r[2].ToString();
dv.ConQuanLy = Convert.ToBoolean(r[3]);
lst.Add(dv);
}
p.Disconnect();
return(lst);
}
public static List <KhachHangDTO> LayDanhSachKhachHang()
{
List <KhachHangDTO> lKH = new List <KhachHangDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader dr = p.GetReader("sp_ChonKhachHang", CommandType.StoredProcedure);
KhachHangDTO kh = null;
while (dr.Read())
{
kh = new KhachHangDTO();
kh.MaKH = Convert.ToInt32(dr[0]);
kh.HoTen = dr[1].ToString().TrimEnd();
kh.DiaChi = dr[2].ToString().TrimEnd();
kh.MaSoThue = dr[3].ToString().TrimEnd();
kh.SoDiDong = dr[4].ToString().TrimEnd();
kh.SoDienThoaiBan = dr[5].ToString().TrimEnd();
kh.Email = dr[6].ToString().TrimEnd();
kh.Fax = dr[7].ToString().TrimEnd();
kh.Website = dr[8].ToString().TrimEnd();
kh.SoTaiKhoan = dr[9].ToString().TrimEnd();
kh.NganHang = dr[10].ToString().TrimEnd();
kh.GioiHanNo = Convert.ToDouble(dr[11]);
kh.ChietKhau = Convert.ToDouble(dr[12]);
kh.NguoiLienHe = dr[13].ToString().TrimEnd();
kh.NoHienTai = Convert.ToDouble(dr[14]);
kh.NickYahoo = dr[15].ToString().TrimEnd();
kh.LoaiKhachHang = Convert.ToInt32(dr[16]);
kh.KhuVuc = Convert.ToInt32(dr[17]);
kh.NickSkype = dr[18].ToString().TrimEnd();
kh.ConQuanLy = Convert.ToBoolean(dr[19]);
lKH.Add(kh);
}
p.Disconnect();
return(lKH);
}
public static List <KhuVucDTO> LayToanBoKhuVuc()
{
List <KhuVucDTO> lst = new List <KhuVucDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("sp_LayTatCaKhuVuc", CommandType.StoredProcedure);
KhuVucDTO kv = null;
while ((r.Read()))
{
kv = new KhuVucDTO();
kv.MaKhuVuc = Convert.ToInt32(r[0]);
kv.TenKhuVuc = r[1].ToString();
kv.GhiChu = r[2].ToString();
kv.ConQuanLy = Convert.ToBoolean(r[3]);
lst.Add(kv);
}
p.Disconnect();
return(lst);
}