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); }