///////////////////////////
// Lấy danh sách KHÁCH HÀNG
///////////////////////////
public List <Customer> GetCustomer(string sql)
{
List <Customer> list = new List <Customer>();
string MaKH, HoTen, NgaySinh, GioiTinh, DiaChi;
int SDT;
dp.Connect();
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
MaKH = dr.GetString(0);
HoTen = dr.GetString(1);
NgaySinh = dr.GetString(2);
GioiTinh = dr.GetString(3);
SDT = dr.GetInt32(4);
DiaChi = dr.GetString(5);
Customer cus = new Customer(MaKH, HoTen, NgaySinh, GioiTinh, SDT, DiaChi);
list.Add(cus);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dp.Disconnect();
}
}
public static List <ChiTietPhieuXuatDTO> SelectChiTietPhieuXuatAll()
{
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatAll");
List <ChiTietPhieuXuatDTO> listChiTietPhieuXuatDTO = new List <ChiTietPhieuXuatDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO();
chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString();
chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString());
chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString());
chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString());
chiTietPhieuXuatDTO.ThanhTien = Int32.Parse(dataRow["ThanhTien"].ToString());
listChiTietPhieuXuatDTO.Add(chiTietPhieuXuatDTO);
}
}
else
{
listChiTietPhieuXuatDTO = null;
}
return(listChiTietPhieuXuatDTO);
}
public static ChiTietPhieuXuatDTO SelectChiTietPhieuXuatById(string MaChiTietPhieuXuat)
{
List <SqlParameter> sqlParamas = new List <SqlParameter>();
sqlParamas.Add(new SqlParameter("@MaChiTietPhieuXuat", MaChiTietPhieuXuat));
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatById", sqlParamas);
ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO();
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.Rows[0];
chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString();
chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString());
chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString());
chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString());
}
else
{
chiTietPhieuXuatDTO = null;
}
return(chiTietPhieuXuatDTO);
}
public static ThanhVienDTO SelectThanhVienById(string MaThanhVien)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaThanhVien", MaThanhVien));
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectThanhVienById", sqlParams);
ThanhVienDTO tvDTO = new ThanhVienDTO();
//List<ThanhVienDTO> lsttvDTO = new List<ThanhVienDTO>();
if (dataTable.Rows.Count > 0)
{
DataRow dtRow = dataTable.Rows[0];
tvDTO.MaThanhVien = dtRow["MaThanhVien"].ToString();
tvDTO.TenThanhVien = dtRow["TenThanhVien"].ToString();
tvDTO.CV = int.Parse(dtRow["CV"].ToString());
tvDTO.DiaChi = dtRow["DiaChi"].ToString();
tvDTO.TienNo = float.Parse(dtRow["TienNo"].ToString());
//lsttvDTO.Add(tvDTO);
}
else
{
tvDTO = null;
}
return(tvDTO);
}
public static List <ChiTietPhieuXuatDTO> SelectChiTietPhieuXuatByMaPhieuXuat(string MaPhieuXuat)
{
List <SqlParameter> sqlParamas = new List <SqlParameter>();
sqlParamas.Add(new SqlParameter("@MaPhieuXuat", MaPhieuXuat));
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatByMaPhieuXuat", sqlParamas);
List <ChiTietPhieuXuatDTO> listChiTietPhieuXuatDTO = new List <ChiTietPhieuXuatDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO();
chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString();
chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString();
chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString());
chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString());
chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString());
chiTietPhieuXuatDTO.ThanhTien = Int32.Parse(dataRow["ThanhTien"].ToString());
listChiTietPhieuXuatDTO.Add(chiTietPhieuXuatDTO);
}
}
else
{
listChiTietPhieuXuatDTO = null;
}
return(listChiTietPhieuXuatDTO);
}
public static PhieuXuatDTO SelectPhieuXuatById(string MaPhieuXuat)
{
List <SqlParameter> sqlParamas = new List <SqlParameter>();
sqlParamas.Add(new SqlParameter("@MaPhieuXuat", MaPhieuXuat));
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuXuatById", sqlParamas);
PhieuXuatDTO phieuXuatDTO = new PhieuXuatDTO();
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.Rows[0];
phieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString();
phieuXuatDTO.NgayBan = DateTime.Parse(dataRow["NgayBan"].ToString());
phieuXuatDTO.MaThanhVien = dataRow["MaThanhVien"].ToString();
phieuXuatDTO.MaNhanVien = dataRow["MaNhanVien"].ToString();
phieuXuatDTO.TenKhachHang = dataRow["TenKhachHang"].ToString();
phieuXuatDTO.DiaChi = dataRow["DiaChi"].ToString();
phieuXuatDTO.MaLoaiPhieuXuat = dataRow["MaLoaiPhieuXuat"].ToString();
}
else
{
phieuXuatDTO = null;
}
return(phieuXuatDTO);
}
public static List <ThanhVienDTO> SelectThanhVienAll()
{
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectThanhVienAll");
List <ThanhVienDTO> lsttvDTO = new List <ThanhVienDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dtRow in dataTable.Rows)
{
ThanhVienDTO tvDTO = new ThanhVienDTO();
tvDTO.MaThanhVien = dtRow["MaThanhVien"].ToString();
tvDTO.TenThanhVien = dtRow["TenThanhVien"].ToString();
tvDTO.CV = int.Parse(dtRow["CV"].ToString());
tvDTO.DiaChi = dtRow["DiaChi"].ToString();
tvDTO.TienNo = float.Parse(dtRow["TienNo"].ToString());
lsttvDTO.Add(tvDTO);
}
}
else
{
lsttvDTO = null;
}
return(lsttvDTO);
}
public List <MatHang> LoadData()
{
try
{
dp.Connect();
string sqlstr = "SELECT * FROM MatHang";
List <MatHang> list = new List <MatHang>();
SqlDataReader dr = dp.ExecuteReader(sqlstr);
//List<MatHang> list = new List<MatHang>();
while (dr.Read())
{
string maMatHang = dr.GetString(0);
string tenMatHang = dr.GetString(1);
string maNhaCungCap = dr.GetString(2);
string tenNhaCungCap = dr.GetString(3);
int donGia = dr.GetInt32(4);
int giaBan = dr.GetInt32(5);
string maLoaiTien = dr.GetString(6);
int namSanXuat = dr.GetInt32(7);
MatHang N = new MatHang(maMatHang, tenMatHang, maNhaCungCap, tenNhaCungCap, donGia, giaBan, maLoaiTien, namSanXuat);
list.Add(N);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dp.Disconnect();
}
}
public static List <PhieuXuatDTO> SelectPhieuXuatAll()
{
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuXuatAll");
List <PhieuXuatDTO> listPhieuXuatDTO = new List <PhieuXuatDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
PhieuXuatDTO phieuXuatDTO = new PhieuXuatDTO();
phieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString();
phieuXuatDTO.NgayBan = DateTime.Parse(dataRow["NgayBan"].ToString());
phieuXuatDTO.MaThanhVien = dataRow["MaThanhVien"].ToString();
phieuXuatDTO.MaNhanVien = dataRow["MaNhanVien"].ToString();
phieuXuatDTO.TenKhachHang = dataRow["TenKhachHang"].ToString();
phieuXuatDTO.DiaChi = dataRow["DiaChi"].ToString();
phieuXuatDTO.MaLoaiPhieuXuat = dataRow["MaLoaiPhieuXuat"].ToString();
listPhieuXuatDTO.Add(phieuXuatDTO);
}
}
else
{
listPhieuXuatDTO = null;
}
return(listPhieuXuatDTO);
}
public static List <ChiTietPhieuNhapDTO> SelectChiTietPhieuNhapByMaPhieuNhap(string maPhieuNhap)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaPhieuNhap", maPhieuNhap));
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuNhapByMaPhieuNhap", sqlParams);
List <ChiTietPhieuNhapDTO> listChiTietPhieuNhapDTO = new List <ChiTietPhieuNhapDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
ChiTietPhieuNhapDTO chiTietPhieuNhapDTO = new ChiTietPhieuNhapDTO();
chiTietPhieuNhapDTO.MaChiTietPhieuNhap = dataRow["MaChiTietPhieuNhap"].ToString();
chiTietPhieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString();
chiTietPhieuNhapDTO.MaSanPham = dataRow["MaSanPham"].ToString();
chiTietPhieuNhapDTO.SLNhan = Int32.Parse(dataRow["SLNhan"].ToString());
chiTietPhieuNhapDTO.GhiChu = dataRow["GhiChu"].ToString();
listChiTietPhieuNhapDTO.Add(chiTietPhieuNhapDTO);
}
}
else
{
listChiTietPhieuNhapDTO = null;
}
return(listChiTietPhieuNhapDTO);
}
public static DonHangDTO SearchDonHangById(string maDonHang)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaDonHang", maDonHang));
DataTable dataTable = DataProvider.ExecuteReader("usp_SearchDonHangById", sqlParams);
DonHangDTO donHangDTO = new DonHangDTO();
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.Rows[0];
donHangDTO.MaDonHang = dataRow["MaDonHang"].ToString();
donHangDTO.NgayLap = DateTime.Parse(dataRow["NgayLap"].ToString());
donHangDTO.MaNhanVien = dataRow["MaNhanVien"].ToString();
donHangDTO.ThanhTien = float.Parse(dataRow["ThanhTien"].ToString());
donHangDTO.TrangThai = dataRow["TrangThai"].ToString();
}
else
{
donHangDTO = null;
}
return(donHangDTO);
}
public static ChiTietPhieuNhapDTO SelectChiTietPhieuNhapById(string maChiTietPhieuNhap)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaChiTietPhieuNhap", maChiTietPhieuNhap));
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuNhapById", sqlParams);
ChiTietPhieuNhapDTO chiTietPhieuNhapDTO = new ChiTietPhieuNhapDTO();
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.Rows[0];
chiTietPhieuNhapDTO.MaChiTietPhieuNhap = dataRow["MaChiTietPhieuNhap"].ToString();
chiTietPhieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString();
chiTietPhieuNhapDTO.MaSanPham = dataRow["MaSanPham"].ToString();
chiTietPhieuNhapDTO.SLNhan = Int32.Parse(dataRow["SLNhan"].ToString());
chiTietPhieuNhapDTO.GhiChu = dataRow["GhiChu"].ToString();
}
else
{
chiTietPhieuNhapDTO = null;
}
return(chiTietPhieuNhapDTO);
}
public static SanPhamDTO SelectSanPhamById(string MaSanPham)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaSanPham", MaSanPham));
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectSanPhamById", sqlParams);
SanPhamDTO spDTO = new SanPhamDTO();
if (dataTable.Rows.Count > 0)
{
DataRow dtRow = dataTable.Rows[0];
//List<SanPhamDTO> lstspDTO = new List<SanPhamDTO>();
spDTO.MaSanPham = dtRow["MaSanPham"].ToString();
spDTO.TenSanPham = dtRow["TenSanPham"].ToString();
spDTO.CV = int.Parse(dtRow["CV"].ToString());
spDTO.DonGia = float.Parse(dtRow["DonGia"].ToString());
spDTO.DonGiaTV = float.Parse(dtRow["DonGiaTV"].ToString());
spDTO.SoLuongTon = int.Parse(dtRow["SoLuongTon"].ToString());
spDTO.MaLoaiSanPham = dtRow["MaLoaiSanPham"].ToString();
//select sp.MaSanPham, sp.TenSanPham, sp.CV, sp.DonGia, sp.DonGiaTV, sp.SoLuongTon, sp.MaLoaiSanPham
// lstspDTO.Add(spDTO);
}
else
{
spDTO = null;
}
return(spDTO);
}
public static List <SanPhamDTO> SelectSanPhamAll()
{
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectSanPhamAll");
List <SanPhamDTO> lstspDTO = new List <SanPhamDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dtRow in dataTable.Rows)
{
SanPhamDTO spDTO = new SanPhamDTO();
spDTO.MaSanPham = dtRow["MaSanPham"].ToString();
spDTO.TenSanPham = dtRow["TenSanPham"].ToString();
spDTO.CV = int.Parse(dtRow["CV"].ToString());
spDTO.DonGia = float.Parse(dtRow["DonGia"].ToString());
spDTO.DonGiaTV = float.Parse(dtRow["DonGiaTV"].ToString());
spDTO.SoLuongTon = int.Parse(dtRow["SoLuongTon"].ToString());
spDTO.MaLoaiSanPham = dtRow["MaLoaiSanPham"].ToString();
//select sp.MaSanPham, sp.TenSanPham, sp.CV, sp.DonGia, sp.DonGiaTV, sp.SoLuongTon, sp.MaLoaiSanPham
lstspDTO.Add(spDTO);
}
}
else
{
lstspDTO = null;
}
return(lstspDTO);
}
public List <Nhanvien> LoadData()
{
try
{
dp.Connect();
string sqlstr = "SELECT * FROM NhanVien";
List <Nhanvien> list = new List <Nhanvien>();
SqlDataReader dr = dp.ExecuteReader(sqlstr);
//List<Nhanvien> list = new List<Nhanvien>();
while (dr.Read())
{
string maNV = dr.GetString(0);
string hoTen = dr.GetString(1);
string tenQuayGiaoDich = dr.GetString(2);
string diaChi = dr.GetString(3);
string soDienThoai = dr.GetString(4);
Nhanvien N = new Nhanvien(maNV, hoTen, tenQuayGiaoDich, diaChi, soDienThoai);
list.Add(N);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dp.Disconnect();
}
}
///////////////////////////
// Lấy danh sách Ghế
///////////////////////////
public List <Seat> GetSeat(string sql)
{
List <Seat> list = new List <Seat>();
string MaVe, Loai, HangGhe;
bool TinhTrang;
int Gia;
dp.Connect();
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
MaVe = dr.GetString(0);
Loai = dr.GetString(1);
HangGhe = dr.GetString(2);
Gia = dr.GetInt32(3);
TinhTrang = dr.GetBoolean(4);
Seat seat = new Seat(MaVe, Loai, HangGhe, Gia, TinhTrang);
list.Add(seat);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dp.Disconnect();
}
}
public List <DTOCTHoaDon> GetCTHD(string sql)
{
dp.connect();
List <DTOCTHoaDon> list = new List <DTOCTHoaDon>();
{
string m, ms;
int sl, dg, tt;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
m = dr.GetString(0);
ms = dr.GetString(1);
sl = dr.GetInt32(2);
dg = dr.GetInt32(3);
tt = dr.GetInt32(4);
DTOCTHoaDon cthd = new DTOCTHoaDon(m, ms, sl, dg, tt);
list.Add(cthd);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
public List <DTOHoaDon> GetHD(string sql)
{
dp.connect();
List <DTOHoaDon> list = new List <DTOHoaDon>();
{
string mh, mk, mn;
DateTime nx; int tt;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
mh = dr.GetString(0);
mk = dr.GetString(1);
nx = dr.GetDateTime(2);
tt = dr.GetInt32(3);
mn = dr.GetString(4);
DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mn);
list.Add(hd);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
public List <DTO_Customer> GetCustomer()
{
List <DTO_Customer> list = new List <DTO_Customer>();
int makh;
string hokh, tenkh, sdt, gioitinh, diachithuongtru, email;
DateTime ngaysinh;
try
{
string sql = "SELECT * FROM KhachHang";
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
makh = dr.GetInt32(0);
hokh = dr.GetString(1);
tenkh = dr.GetString(2);
gioitinh = dr.GetString(3);
sdt = dr.GetString(4);
ngaysinh = dr.GetDateTime(5);
diachithuongtru = dr.GetString(6);
email = dr.GetString(7);
DTO_Customer emp = new DTO_Customer(makh, hokh, tenkh, gioitinh, sdt, ngaysinh, diachithuongtru, email);
list.Add(emp);
}
return(list);
}
catch (SqlException ex)
{
throw ex;
}
}
public static HoaDon GetLastBill(int maBan)
{
provider = new DataProvider();
provider.Connect();
string cmdStr = "Execute proc_GetLastBill " + maBan;
SqlDataReader reader = provider.ExecuteReader(cmdStr);
HoaDon bill = new HoaDon();
if (reader.Read())
{
bill.MaHoaDon = reader.GetInt32(0);
bill.MaBan = reader.GetInt32(1);
bill.MaNhanVien = reader.GetInt32(2);
if (!reader.IsDBNull(3))
{
bill.ThoiGianLap = reader.GetDateTime(3);
}
bill.TongTien = reader.GetInt32(4);
}
provider.Disconnect();
return(bill);
}
public static List <HoaDon> LoadAll(int pageNumber, int billsPerPage)
{
provider = new DataProvider();
provider.Connect();
string cmdStr = "Execute proc_LoadAllBills " + pageNumber + ", " + billsPerPage;
SqlDataReader reader = provider.ExecuteReader(cmdStr);
List <HoaDon> billList = new List <HoaDon>();
while (reader.Read())
{
int maHoaDon = reader.GetInt32(0);
int maBan = reader.GetInt32(1);
int maNhanVen = reader.GetInt32(2);
DateTime?thoiGianLap;
if (!reader.IsDBNull(3))
{
thoiGianLap = reader.GetDateTime(3);
}
else
{
thoiGianLap = null;
}
int tongTien = reader.GetInt32(4);
billList.Add(new HoaDon(maHoaDon, maBan, maNhanVen, thoiGianLap, tongTien));
}
provider.Disconnect();
return(billList);
}
public static List <ChiTietDonHangDTO> SelectChiTietDonHangByMaDonHang(string MaDonHang)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@MaDonHang", MaDonHang));
DataTable dataTable = new DataTable();
dataTable = DataProvider.ExecuteReader("usp_SelectChiTietDonHangByMaDonHang", sqlParams);
List <ChiTietDonHangDTO> lstctdhDTO = new List <ChiTietDonHangDTO>();
if (dataTable.Rows.Count > 0)
{
//<ChiTietDonHangDTO> lstctdhDTO = new List<ChiTietDonHangDTO>();
foreach (DataRow dtRow in dataTable.Rows)
{
ChiTietDonHangDTO ctdhDTO = new ChiTietDonHangDTO();
ctdhDTO.MaChiTietDonHang = dtRow["MaChiTietDonHang"].ToString();
ctdhDTO.MaDonHang = dtRow["MaDonHang"].ToString();
ctdhDTO.MaSanPham = dtRow["MaSanPham"].ToString();
ctdhDTO.CV = int.Parse(dtRow["CV"].ToString());
ctdhDTO.SoLuong = int.Parse(dtRow["SoLuong"].ToString());
ctdhDTO.DonGia = float.Parse(dtRow["DonGia"].ToString());
ctdhDTO.ThanhTien = float.Parse(dtRow["ThanhTien"].ToString());
ctdhDTO.SLDaNhan = int.Parse(dtRow["SLDaNhan"].ToString());
lstctdhDTO.Add(ctdhDTO);
//select ct.MaChiTietDonHang, ct.MaDonHang, ct.MaSanPham, ct.CV, ct.SoLuong, ct.DonGia, ct.ThanhTien
}
}
else
{
lstctdhDTO = null;
}
return(lstctdhDTO);
}
public static HoaDon GetBill(int maHoaDon)
{
provider = new DataProvider();
provider.Connect();
string cmdStr = "Execute proc_GetBill " + maHoaDon;
SqlDataReader reader = provider.ExecuteReader(cmdStr);
HoaDon bill = null;
if (reader.Read())
{
DateTime?thoiGianLap;
if (!reader.IsDBNull(3))
{
thoiGianLap = reader.GetDateTime(3);
}
else
{
thoiGianLap = null;
}
bill = new HoaDon
{
MaHoaDon = reader.GetInt32(0),
MaBan = reader.GetInt32(1),
MaNhanVien = reader.GetInt32(2),
ThoiGianLap = thoiGianLap,
TongTien = reader.GetInt32(4)
};
}
provider.Disconnect();
return(bill);
}
public static List <PhieuNhapDTO> SelectPhieuNhapByMaDonHang(string MaDonHang)
{
List <SqlParameter> sqlParamas = new List <SqlParameter>();
sqlParamas.Add(new SqlParameter("@MaDonHang", MaDonHang));
DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuNhapByMaDonHang", sqlParamas);
List <PhieuNhapDTO> listPhieuNhapDTO = new List <PhieuNhapDTO>();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dataTable.Rows)
{
PhieuNhapDTO phieuNhapDTO = new PhieuNhapDTO();
phieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString();
phieuNhapDTO.MaDonHang = dataRow["MaDonHang"].ToString();
phieuNhapDTO.NgayNhan = DateTime.Parse(dataRow["NgayNhan"].ToString());
phieuNhapDTO.MaNhanVien = dataRow["MaNhanVien"].ToString();
listPhieuNhapDTO.Add(phieuNhapDTO);
}
}
else
{
listPhieuNhapDTO = null;
}
return(listPhieuNhapDTO);
}
public List <DTOChiTietThue> GetCTT(string sql)
{
dp.connect();
List <DTOChiTietThue> list = new List <DTOChiTietThue>();
{
string map, makh;
DateTime nt, ndk, ntr;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
map = dr.GetString(0);
makh = dr.GetString(1);
nt = dr.GetDateTime(2);
ndk = dr.GetDateTime(3);
ntr = dr.GetDateTime(4);
DTOChiTietThue ctt = new DTOChiTietThue(map, makh, nt, ndk, ntr);
list.Add(ctt);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
}
}
public List <DTOKhachHang> GetKH(string sql)
{
dp.connect();
List <DTOKhachHang> list = new List <DTOKhachHang>();
{
string ma, ho, ten, cmnd, dc, sdt;
DateTime ngaysinh;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
ma = dr.GetString(0);
ho = dr.GetString(1);
ten = dr.GetString(2);
ngaysinh = dr.GetDateTime(3);
cmnd = dr.GetString(4);
dc = dr.GetString(5);
sdt = dr.GetString(6);
//fax = dr.GetString(7);
DTOKhachHang kh = new DTOKhachHang(ma, ho, ten, ngaysinh, cmnd, dc, sdt);
list.Add(kh);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
public List <DTONhanVien> GetNV(string sql)
{
dp.connect();
List <DTONhanVien> list = new List <DTONhanVien>();
{
string ma, ho, ten, cmnd, dc, sdt, gt, bc;
DateTime ngaysinh;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
ma = dr.GetString(0);
ho = dr.GetString(1);
ten = dr.GetString(2);
ngaysinh = dr.GetDateTime(3);
gt = dr.GetString(4);
cmnd = dr.GetString(5);
dc = dr.GetString(7);
sdt = dr.GetString(6);
bc = dr.GetString(8);
DTONhanVien nv = new DTONhanVien(ma, ho, ten, ngaysinh, gt, cmnd, sdt, dc, bc);
list.Add(nv);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
public static NhanVien GetEmployee(int maNhanVien)
{
provider = new DataProvider();
provider.Connect();
string cmdStr = "Execute proc_GetEmployee " + maNhanVien;
SqlDataReader reader = provider.ExecuteReader(cmdStr);
NhanVien employee = new NhanVien();
if (reader.Read())
{
employee.MaNhanVien = reader.GetInt32(0);
employee.HoTen = reader.GetString(1);
employee.NgaySinh = reader.GetDateTime(2);
employee.GioiTinh = reader.GetString(3);
employee.DiaChi = reader.GetString(4);
employee.SoDienThoai = reader.GetString(5);
employee.NgayVaoLam = reader.GetDateTime(6);
employee.ChucVu = reader.GetString(7);
employee.Luong = reader.GetInt32(8);
}
provider.Disconnect();
return(employee);
}
public static List <ThucDon> LoadAll(string tenMon = "")
{
provider = new DataProvider();
provider.Connect();
string cmdStr;
if (tenMon == string.Empty)
{
cmdStr = "Execute proc_LoadAllDishes";
}
else
{
cmdStr = "Execute proc_LoadAllDishesWithName N'" + tenMon + "'";
}
SqlDataReader reader = provider.ExecuteReader(cmdStr);
List <ThucDon> list = new List <ThucDon>();
while (reader.Read())
{
list.Add(new ThucDon(reader.GetString(0), reader.GetInt32(1), reader.GetString(2)));
}
provider.Disconnect();
return(list);
}
public decimal GETMONEY(int ID)
{
try
{
string sql = "select * from dbo.MonNuoc where MaMonNuoc = " + ID;
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
return(dr.GetDecimal(dr.GetOrdinal("GiaTien")));
}
}
catch
{
}
return(0);
}
