public DataSet LayHoaDonDichVu()
{
return(db.ExecuteQueryDataSet(
"select * from HoaDonDichVu ", CommandType.Text, null));
}
public DataSet LayTaiKhoan()
{
return(db.ExecuteQueryDataSet(
"select * from TaiKhoan", CommandType.Text, null));
}
public DataSet LayPhongChieu()
{
return(db.ExecuteQueryDataSet(
"select * from PhongChieu", CommandType.Text, null));
}
//
//
public DataSet SelectNhanVien()
{
return(db.ExecuteQueryDataSet("spViewNhanVien", CommandType.StoredProcedure, null));
}
public DataSet SelectLoaiSP()
{
return(db.ExecuteQueryDataSet("spViewLoaiSP", CommandType.StoredProcedure, null));
}
public DataSet getNXB()
{
return(dal.ExecuteQueryDataSet("select * from NXB", CommandType.Text, null));
}
public DataSet getTheLoai()
{
return(dal.ExecuteQueryDataSet("select * from TheLoai", CommandType.Text, null));
}
//
//
public DataSet SelectSanPham()
{
return(db.ExecuteQueryDataSet("spViewSanPham", CommandType.StoredProcedure, null));
}
//
//
public DataSet SelectTaiKhoan()
{
return(db.ExecuteQueryDataSet("spViewTaiKhoan", CommandType.StoredProcedure, null));
}
public DataSet getHoaDonNhap()
{
return(dal.ExecuteQueryDataSet("select * from HoaDonNhap", CommandType.Text, null));
}
//
//
public DataSet SelectKhachHang()
{
return(db.ExecuteQueryDataSet("spViewKhachHang", CommandType.StoredProcedure, null));
}
public DataSet DangNhap(ref string err, string MaNV, string MatKhau)
{
//Lấy ra được một bảng gồm các cột MaNV, MatKhau, HoNV, TenNV, Quyen, TinhTrang
return(dal.ExecuteQueryDataSet("select NV.MaNV, MatKhau, HoNV, TenNV, Quyen, NV.TinhTrang from NhanVien NV, (select * from TaiKhoan where MaNV ='" + MaNV + "' and MatKhau = '" + MatKhau + "') as TK where NV.MaNV = TK.MaNV", CommandType.Text, null));
}
public DataSet LayNhanVien()
{
return(db.ExecuteQueryDataSet(
"select * from NhanVien", CommandType.Text, null));
}
public DataSet LayLoaiVe()
{
return(db.ExecuteQueryDataSet(
"select * from LoaiVe", CommandType.Text, null));
}