예제 #1
0
        public List<ProductMobileModel> GetSuggestProduct(string username)
        {
            try
            {
                var productModel = (from p in context.Products
                                    from h in context.HistoryDetails
                                    where h.ProductId == p.Id && h.History.Username.Equals(username)
                                    group h by p into productMostBuyGroup
                                    select new ProductMostBuy
                                    {
                                        Product = productMostBuyGroup.Key,
                                        numberOfBuy = productMostBuyGroup.Count()
                                    }).Where(x => x.numberOfBuy >= 5).OrderByDescending(o => o.numberOfBuy).Take(5);

                var result = new List<ProductMobileModel>();
                foreach (ProductMostBuy pmb in productModel)
                {
                    var product = (from p in context.ProductAttributes
                                   where p.ProductId == pmb.Product.Id
                                   group p by p.ProductId into grp
                                   select grp.OrderByDescending(o => o.LastUpdatedTime).FirstOrDefault()).FirstOrDefault();
                    DateTime? lastUpdateTime = product.LastUpdatedTime;
                    string lastUpdateTimeFormat = String.Format("{0:MM-dd-yyyy}", lastUpdateTime);
                    var info = new ProductMobileModel
                    {
                        ProductId = product.ProductId.ToString(),
                        Name = product.Product.Name,
                        MinPrice = product.MinPrice.ToString(),
                        MaxPrice = product.MaxPrice.ToString(),
                        LastUpdateTime = lastUpdateTimeFormat
                    };
                    result.Add(info);
                }
                return result;
            }
            catch
            {
                return null;
            }
        }
예제 #2
0
        public List<ProductMobileModel> Search(string keyword)
        {
            //search product by dictionary
            var dictionaries = context.Dictionaries.Include(i => i.Product).Where(p => p.Name.Contains(keyword)).OrderBy(p => p.Name).ToList();

            var result = new List<ProductMobileModel>();
            foreach (Dictionary dictionary in dictionaries)
            {
                List<int?> minPrice = dictionary.Product.ProductAttributes
                    .OrderByDescending(x => x.LastUpdatedTime)
                    .Select(x => x.MinPrice)
                    .ToList();
                List<int?> maxPrice = dictionary.Product.ProductAttributes
                    .OrderByDescending(x => x.LastUpdatedTime)
                    .Select(x => x.MaxPrice)
                    .ToList();
                var productName = context.Products.Where(p => p.Id == dictionary.ProductId).Select(p => p.Name).FirstOrDefault();
                if (!result.Any(p => p.Name == productName))
                {
                    var info = new ProductMobileModel
                    {
                        ProductId = dictionary.ProductId.ToString(),
                        Name = productName,
                        MinPrice = minPrice[0].ToString(),
                        MaxPrice = maxPrice[0].ToString()
                    };
                    result.Add(info);
                }

            }
            // result.OrderBy(p => p.Name);

            return result;
        }
예제 #3
0
        public List<ProductMobileModel> GetProduct()
        {
            var products = context.Products.Include(i => i.ProductAttributes).ToList();
            var result = new List<ProductMobileModel>();
            foreach (Product product in products)
            {
                List<int?> minPrice = product.ProductAttributes
                    .OrderByDescending(x => x.LastUpdatedTime)
                    .Select(x => x.MinPrice)
                    .ToList();
                List<int?> maxPrice = product.ProductAttributes
                    .OrderByDescending(x => x.LastUpdatedTime)
                    .Select(x => x.MaxPrice)
                    .ToList();

                DateTime? lastUpdateTime = product.ProductAttributes
                    .OrderByDescending(x => x.LastUpdatedTime)
                    .Select(x => x.LastUpdatedTime).FirstOrDefault();
                string lastUpdateTimeFormat = String.Format("{0:MM-dd-yyyy}", lastUpdateTime);
                var proAtt = context.ProductAttributes.Where(p => p.ProductId == product.Id).OrderByDescending(x => x.LastUpdatedTime).FirstOrDefault();
                if (proAtt != null)
                {
                    var info = new ProductMobileModel
                    {
                        ProductId = product.Id.ToString(),
                        Name = product.Name,
                        MinPrice = minPrice[0].ToString(),
                        MaxPrice = maxPrice[0].ToString(),
                        LastUpdateTime = lastUpdateTimeFormat
                    };
                    result.Add(info);
                }
            }
            return result;
        }