public void getTwitterStats(Domain.Socioboard.Domain.TwitterAccount twitterAccount)
{
//TwitterStatsRepository objTwtstats = new TwitterStatsRepository();
TwitterStatsRepository objTwtstats = new TwitterStatsRepository();
TwitterMessageRepository objTweetMsgRepo = new TwitterMessageRepository();
//TwitterStats objStats = new TwitterStats();
Domain.Socioboard.Domain.TwitterStats objStats = new Domain.Socioboard.Domain.TwitterStats();
Random rNum = new Random();
objStats.Id = Guid.NewGuid();
objStats.TwitterId = twitterAccount.TwitterUserId;
objStats.UserId = twitterAccount.UserId;
objStats.FollowingCount = twitterAccount.FollowingCount;
objStats.FollowerCount = twitterAccount.FollowersCount;
objStats.Age1820 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age2124 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age2534 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age3544 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age4554 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age5564 = rNum.Next(twitterAccount.FollowersCount);
objStats.Age65 = rNum.Next(twitterAccount.FollowersCount);
int replies = objTweetMsgRepo.getRepliesCount(twitterAccount.UserId, twitterAccount.TwitterUserId);
int retweets = objTweetMsgRepo.getRetweetCount(twitterAccount.UserId, twitterAccount.TwitterUserId);
if (twitterAccount.FollowersCount != 0)
objStats.Engagement = (replies + retweets) / twitterAccount.FollowersCount;
else
objStats.Engagement = 0;
objStats.EntryDate = DateTime.Now;
if (!objTwtstats.checkTwitterStatsExists(twitterAccount.TwitterUserId, twitterAccount.UserId, objStats.FollowerCount, objStats.FollowingCount))
objTwtstats.addTwitterStats(objStats);
}
private void getUserTweets(string UserId, oAuthTwitter OAuth)
{
#region Add User Tweets
try
{
TwitterUser twtuser =new TwitterUser();
JArray Timeline = twtuser.GetStatuses_User_Timeline(OAuth);
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
TwitterMessage twtmsg = new TwitterMessage();
foreach (var item in Timeline)
{
objTwitterMessage.UserId = Guid.Parse(UserId);
objTwitterMessage.Type = "twt_usertweets";
try
{
objTwitterMessage.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.ScreenName = objTwitterAccount.TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.ProfileId = objTwitterAccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.MessageDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objTwitterMessage.EntryDate = DateTime.Now;
try
{
objTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objTwitterMessageRepository.checkTwitterMessageExists(objTwitterMessage.MessageId))
{
objTwitterMessageRepository.addTwitterMessage(objTwitterMessage);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error("twtuser.GetStatuses_User_Timeline ex.StackTrace >> " + ex.StackTrace);
logger.Error("twtuser.GetStatuses_User_Timeline ex.Message >> " + ex.Message);
}
#endregion
}
public void getUserTweets(oAuthTwitter OAuth, string TwitterScreenName, string TwitterUserId, Guid userId, Domain.Socioboard.Domain.TwitterAccount objTwitterAccount)
{
try
{
Users userinfo = new Users();
TwitterUser twtuser = new TwitterUser();
JArray data = twtuser.GetStatuses_User_Timeline(OAuth);
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
// TwitterMessage twtmsg = new TwitterMessage();
Domain.Socioboard.Domain.TwitterMessage ObjTwitterMessage = new Domain.Socioboard.Domain.TwitterMessage();
foreach (var item in data)
{
ObjTwitterMessage.UserId = userId;
ObjTwitterMessage.Type = "twt_usertweets";
try
{
ObjTwitterMessage.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.ScreenName = TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.ProfileId = TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.MessageDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
ObjTwitterMessage.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
ObjTwitterMessage.EntryDate = DateTime.Now;
try
{
ObjTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!twtmsgrepo.checkTwitterMessageExists(ObjTwitterMessage.ProfileId, ObjTwitterMessage.UserId, ObjTwitterMessage.MessageId))
{
twtmsgrepo.addTwitterMessage(ObjTwitterMessage);
}
#region Add TwitterFollowerCount
TwitterAccountFollowersRepository objTwitterAccountFollowersRepository = new TwitterAccountFollowersRepository();
Domain.Socioboard.Domain.TwitterAccountFollowers objTwitterAccountFollowers = new Domain.Socioboard.Domain.TwitterAccountFollowers();
objTwitterAccountFollowers.Id = Guid.NewGuid();
objTwitterAccountFollowers.UserId = userId;
objTwitterAccountFollowers.EntryDate = DateTime.Now;
objTwitterAccountFollowers.ProfileId = TwitterUserId;
JArray profile = userinfo.Get_Users_LookUp_ByScreenName(OAuth, TwitterScreenName);
foreach (var item_followerdata in profile)
{
try
{
objTwitterAccountFollowers.FollowingsCount = Convert.ToInt32(item_followerdata["friends_count"].ToString());
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
try
{
objTwitterAccountFollowers.FollowersCount = Convert.ToInt32(item_followerdata["followers_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
objTwitterAccountFollowersRepository.addTwitterAccountFollower(objTwitterAccountFollowers);
#endregion
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
