public void Start() { ProducerBasic producerDelImgImbo = new ProducerBasic(RabbitMQManager.GetRabbitMQServer(ConfigImbo.KeyRabbitMqTransferImbo), ConfigImbo.QueueDelImgImbo); _sqlDb.ProcessDataTableLarge( @" select replace(Domain, '.', '_') as Domain, id, LogoImageId from company where TotalProduct>0 order by id ", 10000, (row, iRow) => { string imgIdOld = Common.Obj2String(row["LogoImageId"]); long id = Common.Obj2Int64(row["Id"]); string domain = Common.Obj2String(row["Domain"]); string fullLinkLog = string.Format(@"http://img.websosanh.vn/merchant/{0}.png", domain); try { string imgIdNew = ImboImageService.PushFromUrl(ConfigImbo.PublicKey, ConfigImbo.PrivateKey, fullLinkLog, "logo", ConfigImbo.Host, ConfigImbo.Port); if (!string.IsNullOrEmpty(imgIdNew)) { if (!string.IsNullOrEmpty(imgIdOld)) { producerDelImgImbo.PublishString(imgIdOld); } bool bOK = this._sqlDb.RunQuery("Update Company Set LogoImageId = @LogoImageId Where Id = @Id", CommandType.Text, new SqlParameter[] { SqlDb.CreateParamteterSQL("Id", id, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("LogoImageId", imgIdNew, SqlDbType.NVarChar) }); } } catch (Exception ex) { _log.Error(ex); } _log.Info(string.Format("Uploaded {0} {1}", iRow, id)); return(true); }); }
internal void PushImbo(string mss) { try { JobPublishedWaitTrans job = JobPublishedWaitTrans.FromJson(mss); if (job != null) { string newId = ImboImageService.PushFromUrl(ConfigImbo.PublicKey, ConfigImbo.PrivateKey, job.Url, "review", ConfigImbo.Host, ConfigImbo.Port); sqlDb.RunQuery(@" Update [NewsPublished] Set ImageId = @ImageId Where News_ID = @News_ID ", CommandType.Text, new[] { SqlDb.CreateParamteterSQL("ImageId", newId, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("News_ID", job.Id, SqlDbType.BigInt), }); } } catch (Exception ex) { log.Error(ex); } }