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