Esempio n. 1
0
        private bool InsertSQlRootProduct(ref RootProductSql rootProductSql, RootProductsTableAdapter rootAdapter)
        {
            bool isUpdateSolr = false;

            try
            {
                DBIndi.RootProductsDataTable rootTable = new DBIndi.RootProductsDataTable();
                rootAdapter.FillBy_Id(rootTable, rootProductSql.RootId);
                if (rootTable.Rows.Count > 0)
                {
                    bool isActive = Common.Obj2Bool(rootTable.Rows[0]["IsActive"]);
                    if (isActive)
                    {
                        var listProductIdOld =
                            rootTable.Rows[0]["LocalPath"].ToString()
                            .Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
                            .ToList();
                        foreach (var item in rootProductSql.ProductIdList)
                        {
                            if (!listProductIdOld.Contains(item.ToString()))
                            {
                                listProductIdOld.Add(item.ToString());
                            }
                        }
                        rootProductSql.ProductIdListString = string.Join(",", listProductIdOld);
                        rootProductSql.Name       = rootTable.Rows[0]["Name"].ToString();
                        rootProductSql.LocalPath  = rootTable.Rows[0]["LocalPath"].ToString();
                        rootProductSql.CategoryId = Common.Obj2Int(rootTable.Rows[0]["CategoryId"]);
                        //Update SQL
                        rootAdapter.UpdateIfIsActive(rootProductSql.MinPrice, rootProductSql.NumMerchant,
                                                     rootProductSql.ProductIdListString, rootProductSql.Image, rootProductSql.RootId);
                        isUpdateSolr = true;
                    }
                    else
                    {
                        rootAdapter.UpdateQuery(rootProductSql.Name, rootProductSql.WebsiteId,
                                                rootProductSql.MinPrice, rootProductSql.NumMerchant, rootProductSql.LocalPath,
                                                rootProductSql.ProductIdListString, rootProductSql.Image, rootProductSql.CategoryId,
                                                rootProductSql.Image, false, rootProductSql.RootId);
                    }
                }
                else
                {
                    rootAdapter.Insert(rootProductSql.RootId, rootProductSql.Name, rootProductSql.WebsiteId,
                                       rootProductSql.MinPrice, rootProductSql.NumMerchant, rootProductSql.LocalPath,
                                       rootProductSql.ProductIdListString, rootProductSql.Image, rootProductSql.CategoryId,
                                       rootProductSql.Image, false);
                    Log.Info("insert success" + rootProductSql.RootId);
                }
            }
            catch (Exception ex)
            {
                Log.Error(string.Format("Insert SQL error with Id ={0} , Name = {1} {2}", rootProductSql.RootId,
                                        rootProductSql.Name, ex.Message + ex.StackTrace));
            }
            return(isUpdateSolr);
        }
Esempio n. 2
0
        private void RootProductAnalyzed(byte[] rootProductByte)
        {
            var jsonListProduct = UtilZipFile.Unzip(rootProductByte);
            var result          = JsonConvert.DeserializeObject <List <RootProductAnalyzedObject> >(jsonListProduct);
            var dataNameCode    = new Dictionary <long, List <RootProductAnalyzedObject> >();

            foreach (var rootItem in result)
            {
                if (dataNameCode.ContainsKey(rootItem.RootProductId))
                {
                    dataNameCode[rootItem.RootProductId].Add(rootItem);
                }
                else
                {
                    dataNameCode.Add(rootItem.RootProductId, new List <RootProductAnalyzedObject>()
                    {
                        rootItem
                    });
                }
            }
            var rootAdapter = new RootProductsTableAdapter();

            rootAdapter.Connection.ConnectionString = _connectionStringIndi;

            var solrRootProductClient =
                SolrRootProductClient.GetClient(SolrClientManager.GetSolrClient("solrRootProducts"));

            DBProductTableAdapters.ProductTableAdapter productAdapter = new ProductTableAdapter();
            productAdapter.Connection.ConnectionString = _connectionProduct;
            foreach (var rootItem in dataNameCode)
            {
                try
                {
                    var rootProductSql = new RootProductSql()
                    {
                        RootId      = rootItem.Key,
                        Name        = rootItem.Value[0].Name,
                        WebsiteId   = rootItem.Value[0].WebsiteId,
                        NumMerchant = rootItem.Value.Count,
                        CategoryId  = rootItem.Value[0].CategoryId
                    };
                    rootProductSql.LocalPath =
                        Websosanh.Core.Common.BAL.UrlUtilities.GetRootProductLocalPath(rootProductSql.RootId,
                                                                                       rootProductSql.Name);
                    long minprice = 0;
                    rootProductSql.ProductIdList = new List <long>();
                    var imagePath = "";
                    foreach (var item in rootItem.Value)
                    {
                        rootProductSql.ProductIdList.Add(item.Id);
                        if (!(minprice > 0 && minprice < item.Price))
                        {
                            minprice = item.Price;
                        }
                        if (string.IsNullOrEmpty(imagePath))
                        {
                            imagePath = GetImagePath(item.Id, productAdapter);
                        }
                    }
                    rootProductSql.MinPrice = minprice;
                    rootProductSql.Image    = imagePath;

                    rootProductSql.ProductIdListString = rootProductSql.GetProductIdListString();
                    if (InsertSQlRootProduct(ref rootProductSql, rootAdapter))
                    {
                        InsertSolrRootProduct(rootProductSql, solrRootProductClient);
                    }
                }
                catch (Exception exception)
                {
                    Log.Error(exception);
                }
            }
        }