public int SoTrangTimKiem(ThongTinTimKiem timkiem)
{
var query = db.Database.SqlQuery <int>("HopLong_LocKHTheoSale_Tongsotrang @sale, @macongty, @isadmin, @tukhoa", new SqlParameter("sale", timkiem.sales), new SqlParameter("macongty", timkiem.macongty), new SqlParameter("isadmin", timkiem.isadmin), new SqlParameter("tukhoa", timkiem.tukhoa));
int kq = query.FirstOrDefault();
return(kq);
}
public List <HopLong_PhanTrangKhachHang_Result> PhantrangKH(int page, ThongTinTimKiem timkiem)
{
var query = db.Database.SqlQuery <HopLong_PhanTrangKhachHang_Result>("HopLong_PhanTrangKhachHang @macongty, @sale, @isadmin, @sotrang,@tukhoa", new SqlParameter("macongty", timkiem.macongty), new SqlParameter("sale", timkiem.sales), new SqlParameter("isadmin", timkiem.isadmin), new SqlParameter("sotrang", page), new SqlParameter("tukhoa", timkiem.tukhoa));
var result = query.ToList();
return(result);
}
public List <HopLong_LocKHTheoSale_Result> LOC_KH(int page, ThongTinTimKiem timkiem)
{
var query = db.Database.SqlQuery <HopLong_LocKHTheoSale_Result>("HopLong_LocKHTheoSale @sale, @macongty, @isadmin, @tukhoa, @sotrang", new SqlParameter("sale", timkiem.sales), new SqlParameter("macongty", timkiem.macongty), new SqlParameter("isadmin", timkiem.isadmin), new SqlParameter("tukhoa", timkiem.tukhoa), new SqlParameter("sotrang", page));
var result = query.ToList();
return(result);
}
public string DemTongSoKH_HL(ThongTinTimKiem timkiem)
{
var query = db.Database.SqlQuery <int>("HopLong_LocKHTheoSale_Tongsotrang @sale, @macongty, @isadmin, @tukhoa", new SqlParameter("sale", timkiem.sales), new SqlParameter("macongty", timkiem.macongty), new SqlParameter("isadmin", timkiem.isadmin), new SqlParameter("tukhoa", timkiem.tukhoa));
var result = query.FirstOrDefault();
string kq = result.ToString();
return(kq);
}
public List <HopLong_TimKH_TheoEmail_Result> TimKhachTheoEmail(int page, ThongTinTimKiem timkiem)
{
var query = db.Database.SqlQuery <HopLong_TimKH_TheoEmail_Result>("HopLong_TimKH_TheoEmail @sale, @macongty, @isadmin, @tukhoa, @sotrang", new SqlParameter("sale", timkiem.sales), new SqlParameter("macongty", timkiem.macongty), new SqlParameter("isadmin", timkiem.isadmin), new SqlParameter("tukhoa", timkiem.tukhoa), new SqlParameter("sotrang", page));
var result = query.ToList();
var kq = result.Take(10).ToList();
return(kq);
}