public ActionResult GetProductById(int ProductID)
        {
            var mgKeyword = new KeywordMongo();
            var product   = mgKeyword.GetProductMongoById(ProductID);

            return(Json(new { product = product }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult UpdateProductMongo(int startId, int endId)
        {
            var mg     = new KeywordMongo();
            var result = mg.UpdateMongoProduct(startId, endId);

            return(Json(new
            {
                result = result// mg.Result.Where(m=>m.IsResult == true && m.Comment == "save").ToList()
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult testmongo()
        {
            var mg = new KeywordMongo();


            return(Json(new
            {
                result = true// mg.Result.Where(m=>m.IsResult == true && m.Comment == "save").ToList()
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult productviewcount(int ProductID)
        {
            var isresult = false;

            try
            {
                var mg = new KeywordMongo();
                isresult = mg.UpdateProductViewCount(ProductID);
            }
            catch (Exception ex)
            {
                isresult = false;
                CreateLogFiles(ex);
            }
            return(Json(isresult, JsonRequestBehavior.AllowGet));
        }
        public ActionResult RemoveProductKeywordMongo(int ProductID)
        {
            var mgKeyword = new KeywordMongo();
            var result    = false;

            try
            {
                result = mgKeyword.RemoveProductKeywordMongo(ProductID);
            }
            catch (Exception ex)
            {
                result = false;
                throw;
            }
            return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetProductMongo(int startId, int endId)
        {
            var mgKeyword = new KeywordMongo();
            var sv        = new ProductService();
            var sql       = @" Select * from view_ProductMobileApp
       where (IsDelete = 0 AND RowFlag IN (4,5,6) AND CompRowFlag IN (2,4)
      AND CompIsDelete = 0) AND ( IsShow = 1 AND IsJunk = 0 ) AND ( productid >= " + startId + " AND productid <= " + endId + " )";
            var data      = new List <view_ProductMobileApp>();

            data = sv.qDB.ExecuteQuery <view_ProductMobileApp>(sql).ToList();
            var keywords = mgKeyword.SaveKeywordMongo(data);

            return(Json(new
            {
                keywords = keywords
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult SearchProduct(
            int?Sort         = 1,
            int PIndex       = 1, int PSize      = 20,
            string searchKey = "", int?BizTypeID = 0,
            int CateLevel    = 0, int CategoryID = 0,
            int?Complevel    = 0, int ProvinceID = 0)
        {
            var mgKeyword = new KeywordMongo();
            var keywords  = mgKeyword.SearchProductMongo(Sort, PIndex, PSize, searchKey, BizTypeID, CateLevel, CategoryID, Complevel, ProvinceID);
            var products  = new List <view_ProductMobileApp>();

            foreach (var item in keywords)
            {
                Mapper.CreateMap <Models.tbProduct, view_ProductMobileApp>();
                view_ProductMobileApp model = Mapper.Map <Models.tbProduct, view_ProductMobileApp>(item);
                products.Add(model);
            }

            return(Json(new { totalrow = mgKeyword.TotalRow, products = products }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult ReplaceSearchKey(string search)
        {
            var mg = new KeywordMongo();

            return(Json(mg.ReplaceSearchKey(search), JsonRequestBehavior.AllowGet));
        }