public override void ProcessMessage(BasicDeliverEventArgs message) { MssUpdateAlexaCompany mss = Newtonsoft.Json.JsonConvert.DeserializeObject <MssUpdateAlexaCompany>(UTF8Encoding.UTF8.GetString(message.Body)); var alexa = Common.GetRankAlexa(mss.Domain); string strQuery = @"update company set AlexaRank= 1 where id =1"; this._sqlDbProduct.RunQuery(strQuery, CommandType.Text, new SqlParameter[] { SqlDb.CreateParamteterSQL("@Id", mss.CompanyId, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("@AlexaRank", alexa.AlexaRank, SqlDbType.Int), }); Logger.Info(string.Format("{0} {1} \r\n", mss.Domain, alexa.AlexaRank, alexa.AlexaRankContries)); this.GetChannel().BasicAck(message.DeliveryTag, true); }
public override void ProcessMessage(BasicDeliverEventArgs message) { Thread.Sleep(2000); MssUpdateAlexaCompany mss = Newtonsoft.Json.JsonConvert.DeserializeObject <MssUpdateAlexaCompany>(UTF8Encoding.UTF8.GetString(message.Body)); var alexa = Common.GetRankAlexa(mss.Domain); if (alexa.AlexaRankContries > 0) { string strQuery = @" update Web set AlexaRank = @AlexaRank where id =@Id"; bool bOK = this._sqlDbProduct.RunQuery(strQuery, CommandType.Text, new SqlParameter[] { SqlDb.CreateParamteterSQL("@Id", mss.CompanyId, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("@AlexaRank", alexa.AlexaRankContries, SqlDbType.Int), }); Logger.Info(string.Format("{0} {1} {2} => {3} \r\n", mss.Domain, alexa.AlexaRank, alexa.AlexaRankContries, bOK)); } else { _log.InfoFormat("Fail alexa for {0}", mss.Domain); } this.GetChannel().BasicAck(message.DeliveryTag, true); }