public void SetTwitterDataByIds(List <string> twitterIds)
{
logger.Info("/-----Twitter Service Save Timelines In Ids Start-----/");
int savedCount = 0;
UserTimelineParameters parameters = new UserTimelineParameters()
{
IncludeRTS = false,
MaximumNumberOfTweetsToRetrieve = 100,
ExcludeReplies = true
};
try
{
if (twitterIds.Count > 0)
{
foreach (string twitterId in twitterIds)
{
var tweets = User.GetUserFromScreenName(twitterId).GetUserTimeline(parameters);
foreach (var tweet in tweets)
{
/*
* [Column("TWITTER_ID")]
* [Column("ACCOUNT_NAME")]
* [Column("TWEET_TEXT")]
* [Column("HASHTAGS")]
* [Column("RETWEET_CNT")]
* [Column("URL")]
*/
TwitterT entity = new TwitterT()
{
TwitterId = tweet.IdStr,
TweetText = tweet.FullText,
hashTags = string.Join(" ", tweet.Hashtags),
AccountName = tweet.CreatedBy.Name,
RetweetCount = tweet.RetweetCount,
Url = tweet.Url
};
twitterRepository.InsertTwitterData(entity);
savedCount++;
}
}
}
logger.Info("/-----Twitter Service Save Timelines In Ids End! Saved Count : " + savedCount + " -----/");
logger.Info("/-----Twitter Data Save End-----/");
}
catch (Exception e)
{
logger.Error(e, "Twitter Service Error");
}
}
public int InsertTwitterData(TwitterT twitterData)
{
string sql = SQLHelper.GetSqlByMethodName(MethodBase.GetCurrentMethod().Name);
var parameters = new
{
TWITTER_ID = twitterData.TwitterId,
ACCOUNT_NAME = twitterData.AccountName,
TWEET_TEXT = twitterData.TweetText,
HASHTAGS = twitterData.hashTags,
RETWEET_CNT = twitterData.RetweetCount,
URL = twitterData.Url
};
return(Connection.Execute(sql, parameters));
}
