public int UpdateProductOfCompany(long companyId, string companyName, Tree <int, Region> regionTree = null) { if (regionTree == null) { regionTree = RegionBAL.GetRegionTree(ConnectionStringProducts); } // Get Company Address var companyAddressTableAdapter = new Company_AddressTableAdapter { Connection = { ConnectionString = ConnectionStringProducts } }; var companyAddressDataTable = companyAddressTableAdapter.GetData(companyId); //var companyRegions = new List<int>(); var companyProvins = new List <int>(); var companyDistricts = new List <int>(); for (var rowIndex = 0; rowIndex < companyAddressDataTable.Rows.Count; rowIndex++) { var branchDistrict = companyAddressDataTable.Rows[rowIndex]["RegionID"] == DBNull.Value ? -1 : (int)companyAddressDataTable.Rows[rowIndex]["RegionID"]; if (branchDistrict == -1 || companyDistricts.Contains(branchDistrict)) { continue; } companyDistricts.Add(branchDistrict); var branchProvinNode = regionTree.GetParentNode(branchDistrict); if (branchProvinNode != null && !companyProvins.Contains(branchProvinNode.ID)) { companyProvins.Add(branchProvinNode.ID); } } //var dtCompanyRegion = var dtProduct = new DBTool2.Product_SolrDataTable(); var adtProduct = new DBTool2TableAdapters.Product_SolrTableAdapter { Connection = { ConnectionString = ConnectionStringProducts } }; //this.Invoke((MethodInvoker)(() => // WriteLog(String.Format("Start download list products of company {0}", companyName)))); try { adtProduct.FillBy_Company(dtProduct, companyId); SolrDriver.DeleteByCompanyId(companyId); } catch (Exception ex) { return(-1); //this.Invoke((MethodInvoker)(() => //WriteLog(string.Format("Update Products Of Company {0}", companyId), ex))); } var solrProductItems = new List <SolrProductItem>(); var numProduct = dtProduct.Rows.Count; for (var index = 0; index < numProduct; index++) { var productRow = dtProduct.Rows[index]; try { var item = new SolrProductItem { Id = QT.Entities.Common.Obj2Int64(productRow["ID"]), Price = QT.Entities.Common.Obj2Int(productRow["Price"]), Warranty = QT.Entities.Common.Obj2Int(productRow["Warranty"]), Status = QT.Entities.Common.Obj2Int(productRow["Status"]), Company = QT.Entities.Common.Obj2Int64(productRow["Company"]), CompanyProvins = companyProvins, CompanyDistricts = companyDistricts, LastUpdate = QT.Entities.Common.ObjectToDataTime(productRow["LastUpdate"]), Summary = productRow["Summary"].ToString(), Description = "", ProductId = QT.Entities.Common.Obj2Int(productRow["ProductID"]), ProductType = 2, Name = productRow["Name"].ToString(), NameFT = productRow["NameFT"].ToString(), DetailUrl = productRow["DetailUrl"].ToString(), ImagePath = productRow["ImagePath"].ToString(), CategoryId = QT.Entities.Common.Obj2Int(productRow["CategoryID"]), ContentFT = productRow["ContentFT"] != DBNull.Value ? productRow["ContentFT"].ToString() : "c000", ViewCount = QT.Entities.Common.Obj2Int(productRow["ViewCount"]), AddPosition = QT.Entities.Common.Obj2Int(productRow["AddPosition"]), StringFilterFields = new Dictionary <string, object>(), DoubleFilterFields = new Dictionary <string, object>(), DateTimeFilterFields = new Dictionary <string, object>(), IntFilterFields = new Dictionary <string, object>() }; for (int exIndex = 1; exIndex <= 10; exIndex++) { string filterPropertyId = QT.Entities.Common.Obj2String(productRow["EX" + exIndex]); string filterPropertyValue = QT.Entities.Common.Obj2String(productRow["EXVALUE" + exIndex]); if (string.IsNullOrEmpty(filterPropertyId) || filterPropertyId.Equals("0") || string.IsNullOrEmpty(filterPropertyValue)) { continue; } try { if (filterPropertyValue.StartsWith("number:")) { if (filterPropertyValue.Equals("number:")) { continue; } double filterDoubleValue; string filterIDAndValue = filterPropertyValue.Substring(7); string filterValueID = filterIDAndValue.Substring(0, filterIDAndValue.IndexOf(":")); string filterValue = filterIDAndValue.Length > filterValueID.Length + 1 ? filterIDAndValue.Substring(filterValueID.Length + 1) : ""; var filterPropertyIdKey = SolrProductUtils.GetFilterIdKey(Int32.Parse(filterPropertyId)); if (item.IntFilterFields.ContainsKey(filterPropertyIdKey)) { continue; } int filterValueInt; if (!int.TryParse(filterValueID, out filterValueInt)) { continue; } item.IntFilterFields.Add(filterPropertyIdKey, filterValueID); if (Double.TryParse(filterValue, out filterDoubleValue)) { item.DoubleFilterFields.Add(filterPropertyId, filterDoubleValue); } } else { string filterValueID = filterPropertyValue.Substring(0, filterPropertyValue.IndexOf(":")); string filterValue = filterPropertyValue.Length > filterValueID.Length + 1 ? filterPropertyValue.Substring(filterValueID.Length + 1) : ""; var filterPropertyIdKey = SolrProductUtils.GetFilterIdKey(Int32.Parse(filterPropertyId)); if (item.IntFilterFields.ContainsKey(filterPropertyIdKey)) { continue; } int filterValueInt; if (!int.TryParse(filterValueID, out filterValueInt)) { continue; } item.IntFilterFields.Add(filterPropertyIdKey, filterValueID); item.StringFilterFields.Add(filterPropertyId, filterValue); } } catch (Exception ex) { throw; } } solrProductItems.Add(item); } catch (Exception oex) { return(-2); //Invoke((MethodInvoker)(() => WriteLog(string.Format("Update Products Of Company {0}", companyId), oex))); } if (index % 1000 == 0 || index == numProduct - 1) { try { SolrDriver.IndexItems(solrProductItems); solrProductItems.Clear(); var numUpdatedProducts = index; //Invoke((MethodInvoker)(() => WriteLog(String.Format("Updated solr {0}/{1} products", numUpdatedProducts, numProduct)))); } catch (Exception solrEx) { return(-3); //Invoke((MethodInvoker)(() => WriteLog(string.Format("Update Products Of Company {0}", companyId), solrEx))); } } } try { SolrDriver.IndexItems(solrProductItems); var adtCom = new DBToolTableAdapters.CompanyTableAdapter { Connection = { ConnectionString = ConnectionStringProducts } }; adtCom.UpdateQuery_LastUpdateSolr(DateTime.Now, companyId); adtCom.Dispose(); //this.Invoke((MethodInvoker)(() => // this.richTextBoxInfo.AppendText(String.Format("Update Finish Company {0} - {1} products", // companyName, numProduct)))); } catch (Exception ex) { return(-4); } dtProduct.Dispose(); adtProduct.Dispose(); return(dtProduct.Rows.Count); }
private void Run() { DBTableAdapters.CompanyTableAdapter companyTableAdapter = new CompanyTableAdapter(); companyTableAdapter.Connection.ConnectionString = _connectionString; DBTableAdapters.Company_AddressTableAdapter addressTableAdapter = new Company_AddressTableAdapter(); addressTableAdapter.Connection.ConnectionString = _connectionString; DB.CompanyDataTable companyDataTable = new DB.CompanyDataTable(); DataTable addressDataTable = new DataTable(); DataTable dtCompany = new DataTable(); dtCompany.Columns.Add("ID", typeof(string)); dtCompany.Columns.Add("Domain", typeof(string)); dtCompany.Columns.Add("Address", typeof(string)); dtCompany.Columns.Add("ThanhPho", typeof(string)); dtCompany.Columns.Add("Phone", typeof(string)); var listDomain = memoEdit1.Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries); int i = 0; foreach (var item in listDomain) { i++; this.Invoke(new Action(() => { rbError.AppendText(String.Format("{0}. {1}", i, item) + System.Environment.NewLine); })); companyDataTable.Clear(); addressDataTable.Clear(); long idCompany = Common.GetIDCompany(item); try { companyTableAdapter.FillBy_ID(companyDataTable, idCompany); } catch (Exception exception) { this.Invoke(new Action(() => { rbError.AppendText(String.Format("{0}. {1} Fill By ID error: {2}", i, item, exception) + System.Environment.NewLine); })); } if (companyDataTable.Rows.Count > 0) { DataRow dataRow = dtCompany.NewRow(); dataRow["ID"] = idCompany; dataRow["Domain"] = item; dataRow["Address"] = companyDataTable.Rows[0]["Address"]; dataRow["Phone"] = companyDataTable.Rows[0]["Phone"]; //try //{ // string querry = @"SELECT Distinct ThanhPho FROM Company_Address WHERE CompanyID =" + idCompany; // SqlDb sqldb = new SqlDb(_connectionString); // try // { // addressDataTable = sqldb.GetTblData(querry, CommandType.Text, null); // } // catch (Exception) // { // } // string thanhpho = ""; // for (int j = 0; j < addressDataTable.Rows.Count; j++) // { // if (addressDataTable.Rows[j]["ThanhPho"] != DBNull.Value) // { // thanhpho += addressDataTable.Rows[j]["ThanhPho"].ToString()+" , "; // } // } // dataRow["ThanhPho"] = thanhpho; //} //catch (Exception exception) //{ // this.Invoke(new Action(() => // { // rbError.AppendText(String.Format("{0}. {1} Get address error: {2}", i, item, exception)); // })); //} dtCompany.Rows.Add(dataRow); } else { this.Invoke(new Action(() => { rbError.AppendText(String.Format("{0}. {1} Khong ton tai trong SQL", i, item) + System.Environment.NewLine); })); } } this.Invoke(new Action(() => { gridControl1.DataSource = dtCompany; })); }