public Domain.Socioboard.Domain.TwitterFeed getTwitterFeed(string id)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get feeds of twitter account by profile id.
Domain.Socioboard.Domain.TwitterFeed lstmsg = session.CreateQuery("from TwitterFeed where Id = :id")
.SetParameter("id", id).UniqueResult <Domain.Socioboard.Domain.TwitterFeed>();
//List<TwitterFeed> lstmsg = new List<TwitterFeed>();
//foreach (TwitterFeed item in query.Enumerable<TwitterFeed>().OrderByDescending(x => x.FeedDate))
//{
// lstmsg.Add(item);
//}
return(lstmsg);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
// Edited by Antima[20/12/2014]
public Domain.Socioboard.Domain.TwitterFeed getTwitterFeedByProfileId(string ProfileId, string MessageId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get feeds of twitter account by profile id.
Domain.Socioboard.Domain.TwitterFeed msg = session.CreateQuery("from TwitterFeed where ProfileId = :ProfileId and MessageId =:MessageId")
.SetParameter("ProfileId", ProfileId)
.SetParameter("MessageId", MessageId).UniqueResult <Domain.Socioboard.Domain.TwitterFeed>();
return(msg);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <deleteTwitterFeed>
/// Delete Twitter Feed
/// </summary>
/// <param name="twtfeed">Set Values of twitter profile id and user id in a TwitterFeed Class Property and Pass the Object of TwitterFeed Class.(Domein.TwitterFeed)</param>
/// <returns>Return 1 for success and 0 for failure.(int) </returns>
public int deleteTwitterFeed(Domain.Socioboard.Domain.TwitterFeed twtfeed)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to delete feeds by profile id and user id.
NHibernate.IQuery query = session.CreateQuery("delete from TwitterFeed where ProfileId = :twtuserid and UserId = :userid")
.SetParameter("twtuserid", twtfeed.ProfileId)
.SetParameter("userid", twtfeed.UserId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
public ActionResult ShowTwtMailPopUp(string Id)
{
Api.TwitterFeed.TwitterFeed ApiobjTwitterFeed = new Api.TwitterFeed.TwitterFeed();
Domain.Socioboard.Domain.TwitterFeed twtfeed = (Domain.Socioboard.Domain.TwitterFeed)(new JavaScriptSerializer().Deserialize(ApiobjTwitterFeed.GetTwitterFeedById(Id), typeof(Domain.Socioboard.Domain.TwitterFeed)));
Dictionary <string, object> twtinfo = new Dictionary <string, object>();
twtinfo.Add("twt", twtfeed);
return(PartialView("_MailSendingPartial", twtinfo));
//return PartialView("_TwitterMailSendingPartial", twtfeed);
}
/// <addTwitterFeed>
/// Add Twitter Feed
/// </summary>
/// <param name="twtfeed">Set Values in a TwitterFeed Class Property and Pass the Object of TwitterFeed Class.(Domein.TwitterFeed)</param>
public void addTwitterFeed(Domain.Socioboard.Domain.TwitterFeed twtfeed)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to save data.
session.Save(twtfeed);
transaction.Commit();
} //End Transaction
} //End Session
}
// Edited by Antima[20/12/2014]
public DataSet bindMyTickets(Guid UserId)
{
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
Api.SentimentalAnalysis.SentimentalAnalysis ApiobjSentimentalAnalysis = new Api.SentimentalAnalysis.SentimentalAnalysis();
List <Domain.Socioboard.Domain.FeedSentimentalAnalysis> lstNegativeFeedsOfUser = new List <Domain.Socioboard.Domain.FeedSentimentalAnalysis>();
lstNegativeFeedsOfUser = (List <Domain.Socioboard.Domain.FeedSentimentalAnalysis>)(new JavaScriptSerializer().Deserialize(ApiobjSentimentalAnalysis.getNegativeFeedsOfUser(UserId.ToString()), typeof(List <Domain.Socioboard.Domain.FeedSentimentalAnalysis>)));
if (lstNegativeFeedsOfUser != null)
{
foreach (var item in lstNegativeFeedsOfUser)
{
string Network = item.Network;
if (Network == "facebook")
{
Api.FacebookFeed.FacebookFeed ApiobjFacebookFeed = new Api.FacebookFeed.FacebookFeed();
Domain.Socioboard.Domain.FacebookFeed facebookfeed = (Domain.Socioboard.Domain.FacebookFeed)(new JavaScriptSerializer().Deserialize(ApiobjFacebookFeed.getFacebookFeedByProfileId(item.ProfileId, item.FeedId), typeof(Domain.Socioboard.Domain.FacebookFeed)));
if (facebookfeed != null)
{
ds.Tables[0].Rows.Add(facebookfeed.ProfileId, "facebook", facebookfeed.FromId, facebookfeed.FromName, facebookfeed.FromProfileUrl, facebookfeed.FeedDate, facebookfeed.FeedDescription, facebookfeed.FbComment, facebookfeed.FbLike, facebookfeed.FeedId, facebookfeed.Type, "");
}
}
if (Network == "twitter")
{
Api.TwitterFeed.TwitterFeed ApiobjTwitterFeed = new Api.TwitterFeed.TwitterFeed();
Domain.Socioboard.Domain.TwitterFeed twtfeed = (Domain.Socioboard.Domain.TwitterFeed)(new JavaScriptSerializer().Deserialize(ApiobjTwitterFeed.getTwitterFeedByProfileId(item.ProfileId, item.FeedId), typeof(Domain.Socioboard.Domain.TwitterFeed)));
if (twtfeed != null)
{
ds.Tables[0].Rows.Add(twtfeed.ProfileId, item.Network, twtfeed.FromId, twtfeed.FromScreenName, twtfeed.FromProfileUrl, twtfeed.FeedDate, twtfeed.Feed, "", "", twtfeed.MessageId, twtfeed.Type, "");
}
}
}
}
return(ds);
}
public void getTwitterFeeds(string UserId, oAuthTwitter OAuth)
{
TwitterUser twtuser;
#region Add Twitter User Feed
twtuser = new TwitterUser();
try
{
JArray Home_Timeline = twtuser.GetStatuses_Home_Timeline(OAuth);
objTwitterFeed = new Domain.Socioboard.Domain.TwitterFeed();
foreach (var item in Home_Timeline)
{
objTwitterFeed.UserId = Guid.Parse(UserId);
objTwitterFeed.Type = "twt_feeds";
try
{
objTwitterFeed.Feed = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ScreenName = objTwitterAccount.TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ProfileId = objTwitterAccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FeedDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objTwitterFeed.EntryDate = DateTime.Now;
try
{
objTwitterFeed.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objTwitterFeedRepository.checkTwitterFeedExists(objTwitterFeed.MessageId))
{
try
{
objTwitterFeedRepository.addTwitterFeed(objTwitterFeed);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
// Edited by Antima[20/12/2014]
SentimentalAnalysis _SentimentalAnalysis = new SentimentalAnalysis();
FeedSentimentalAnalysisRepository _FeedSentimentalAnalysisRepository = new FeedSentimentalAnalysisRepository();
try
{
if (_FeedSentimentalAnalysisRepository.checkFeedExists(objTwitterFeed.ProfileId.ToString(), Guid.Parse(UserId), objTwitterFeed.Id.ToString()))
{
if (!string.IsNullOrEmpty(objTwitterFeed.Feed))
{
string Network = "twitter";
_SentimentalAnalysis.GetPostSentimentsFromUclassify(Guid.Parse(UserId), objTwitterFeed.ProfileId, objTwitterFeed.MessageId, objTwitterFeed.Feed, Network);
}
}
}
catch (Exception)
{
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error("twtuser.GetStatuses_Home_Timeline ex.StackTrace >> " + ex.StackTrace);
logger.Error("twtuser.GetStatuses_Home_Timeline ex.Message >> " + ex.Message);
}
#endregion
}
public void getUserFeed(oAuthTwitter OAuth, string TwitterScreenName, string TwitterUserId, Guid userId)
{
try
{
//User user = (User)Session["LoggedUser"];
TwitterUser twtuser = new TwitterUser();
JArray data = twtuser.GetStatuses_Home_Timeline(OAuth);
Domain.Socioboard.Domain.TwitterFeed objTwitterFeed;
TwitterFeedRepository twtmsgrepo = new TwitterFeedRepository();
//TwitterFeed twtmsg = new TwitterFeed();
foreach (var item in data)
{
objTwitterFeed = new Domain.Socioboard.Domain.TwitterFeed();
objTwitterFeed.UserId = userId;
objTwitterFeed.Type = "twt_feeds";
try
{
objTwitterFeed.Feed = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ScreenName = TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ProfileId = TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FeedDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objTwitterFeed.EntryDate = DateTime.Now;
try
{
objTwitterFeed.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
// Edited by Antima[20/12/2014]
SentimentalAnalysis _SentimentalAnalysis = new SentimentalAnalysis();
FeedSentimentalAnalysisRepository _FeedSentimentalAnalysisRepository = new FeedSentimentalAnalysisRepository();
try
{
if (_FeedSentimentalAnalysisRepository.checkFeedExists(objTwitterFeed.ProfileId.ToString(), userId, objTwitterFeed.Id.ToString()))
{
if (!string.IsNullOrEmpty(objTwitterFeed.Feed))
{
string Network = "twitter";
_SentimentalAnalysis.GetPostSentimentsFromUclassify(userId, objTwitterFeed.ProfileId, objTwitterFeed.MessageId, objTwitterFeed.Feed, Network);
}
}
}
catch (Exception)
{
}
if (!twtmsgrepo.checkTwitterFeedExists(objTwitterFeed.ProfileId, objTwitterFeed.UserId, objTwitterFeed.MessageId))
{
twtmsgrepo.addTwitterFeed(objTwitterFeed);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public int updateTwitterFeed(Domain.Socioboard.Domain.TwitterFeed twtfeed)
{
throw new NotImplementedException();
}
public string GetTicketsofGroup(string GroupId, string UserId)
{
string AssignedUser = string.Empty;
try
{
GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository();
FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository();
TwitterFeedRepository objTwitterFeedRepository = new TwitterFeedRepository();
List <Domain.Socioboard.Domain.FeedSentimentalAnalysis> lstNegativeFeedsOfUser = new List <Domain.Socioboard.Domain.FeedSentimentalAnalysis>();
List <Domain.Socioboard.Domain.GroupProfile> objGroupProfile = new List <Domain.Socioboard.Domain.GroupProfile>();
List <FBTwitterFeeds> objListFBTwitterFeeds = new List <FBTwitterFeeds>();
objGroupProfile = objGroupProfileRepository.getAllGroupProfiles(Guid.Parse(UserId), Guid.Parse(GroupId));
if (objGroupProfile.Count > 0)
{
lstNegativeFeedsOfUser = _FeedSentimentalAnalysisRepository.getAllNegativeFeedsOfUser(Guid.Parse(UserId));
}
else
{
lstNegativeFeedsOfUser = _FeedSentimentalAnalysisRepository.getNegativeFeedsOfUser(Guid.Parse(UserId));
}
if (lstNegativeFeedsOfUser != null)
{
foreach (var item in lstNegativeFeedsOfUser)
{
FBTwitterFeeds objFBTwitterFeeds = new FBTwitterFeeds();
UserRepository objUserRepository = new UserRepository();
Domain.Socioboard.Domain.User user = objUserRepository.getUsersById(item.AssigneUserId);
if (objGroupProfileRepository.checkProfileExistsingroup(Guid.Parse(GroupId), item.ProfileId))
{
string Network = item.Network;
if (Network == "facebook")
{
Domain.Socioboard.Domain.FacebookFeed facebookfeed = objFacebookFeedRepository.getFacebookFeedByProfileId(item.ProfileId, item.FeedId);
if (facebookfeed != null)
{
objFBTwitterFeeds.FacebookFeed = facebookfeed;
}
}
if (Network == "twitter")
{
Domain.Socioboard.Domain.TwitterFeed twtfeed = objTwitterFeedRepository.getTwitterFeedByProfileId(item.ProfileId, item.FeedId);
if (twtfeed != null)
{
objFBTwitterFeeds.TwitterFeed = twtfeed;
}
}
if (objFBTwitterFeeds.TwitterFeed != null)
{
try
{
objFBTwitterFeeds.TicketNo = item.TicketNo;
if (user != null)
{
objFBTwitterFeeds.AssignedUser = user.UserName;
}
else
{
objFBTwitterFeeds.AssignedUser = "";
}
objListFBTwitterFeeds.Add(objFBTwitterFeeds);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
if (objFBTwitterFeeds.FacebookFeed != null)
{
try
{
objFBTwitterFeeds.TicketNo = item.TicketNo;
if (user != null)
{
objFBTwitterFeeds.AssignedUser = user.UserName;
}
else
{
objFBTwitterFeeds.AssignedUser = "";
}
objListFBTwitterFeeds.Add(objFBTwitterFeeds);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
}
return(new JavaScriptSerializer().Serialize(objListFBTwitterFeeds));
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
logger.Error(ex.Message);
Console.WriteLine(ex.StackTrace);
return("SomethingWentWrong");
}
}
public string AddTwitterAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string requestToken, string requestSecret, string requestVerifier)
{
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls;
string ret = string.Empty;
Users userinfo = new Users();
oAuthTwitter OAuth = new oAuthTwitter(client_id, client_secret, redirect_uri);
OAuth.AccessToken = requestToken;
OAuth.AccessTokenSecret = requestVerifier;
OAuth.AccessTokenGet(requestToken, requestVerifier);
JArray profile = userinfo.Get_Users_LookUp_ByScreenName(OAuth, OAuth.TwitterScreenName);
if (profile!=null)
{
logger.Error("Twitter.asmx >> AddTwitterAccount >> Twitter profile : " + profile);
}
else
{
logger.Error("Twitter.asmx >> AddTwitterAccount >> NULL Twitter profile : " + profile);
}
objTwitterAccount = new Domain.Socioboard.Domain.TwitterAccount();
TwitterUser twtuser;
foreach (var item in profile)
{
#region Add Twitter Account
try
{
objTwitterAccount.FollowingCount = Convert.ToInt32(item["friends_count"].ToString());
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
try
{
objTwitterAccount.FollowersCount = Convert.ToInt32(item["followers_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objTwitterAccount.Id = Guid.NewGuid();
objTwitterAccount.IsActive = true;
objTwitterAccount.OAuthSecret = OAuth.AccessTokenSecret;
objTwitterAccount.OAuthToken = OAuth.AccessToken;
try
{
objTwitterAccount.ProfileImageUrl = item["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterAccount.ProfileUrl = string.Empty;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterAccount.TwitterUserId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception er)
{
try
{
objTwitterAccount.TwitterUserId = item["id"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
Console.WriteLine(er.StackTrace);
}
try
{
objTwitterAccount.TwitterScreenName = item["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
objTwitterAccount.UserId = Guid.Parse(UserId);
#endregion
if (!objTwitterAccountRepository.checkTwitterUserExists(objTwitterAccount.TwitterUserId, Guid.Parse(UserId)))
{
objTwitterAccountRepository.addTwitterkUser(objTwitterAccount);
#region Add TeamMemberProfile
Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
Domain.Socioboard.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Socioboard.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "twitter";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = objTwitterAccount.TwitterUserId;
objTeamMemberProfile.ProfileName = objTwitterAccount.TwitterScreenName;
objTeamMemberProfile.ProfilePicUrl = objTwitterAccount.ProfileImageUrl;
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
#endregion
#region SocialProfile
Domain.Socioboard.Domain.SocialProfile objSocialProfile = new Domain.Socioboard.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.ProfileType = "twitter";
objSocialProfile.ProfileId = objTwitterAccount.TwitterUserId;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
#endregion
#region Add Twitter Stats
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
objTwitterStats = new Domain.Socioboard.Domain.TwitterStats();
Random rNum = new Random();
objTwitterStats.Id = Guid.NewGuid();
objTwitterStats.TwitterId = objTwitterAccount.TwitterUserId;
objTwitterStats.UserId = Guid.Parse(UserId);
objTwitterStats.FollowingCount = objTwitterAccount.FollowingCount;
objTwitterStats.FollowerCount = objTwitterAccount.FollowersCount;
objTwitterStats.Age1820 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age2124 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age2534 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age3544 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age4554 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age5564 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.Age65 = rNum.Next(objTwitterAccount.FollowersCount);
objTwitterStats.EntryDate = DateTime.Now;
if (!objTwtstats.checkTwitterStatsExists(objTwitterAccount.TwitterUserId, Guid.Parse(UserId)))
{
objTwtstats.addTwitterStats(objTwitterStats);
}
#endregion
ret = "Account Added Successfully";
}
else
{
ret = "Account already Exist !";
}
}
#region Add Twitter Messages
twtuser = new TwitterUser();
try
{
TimeLine tl = new TimeLine();
JArray data = null;
try
{
data = tl.Get_Statuses_Mentions_Timeline(OAuth);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error("tl.Get_Statuses_Mentions_Timeline ex.StackTrace >> " + ex.StackTrace);
logger.Error("tl.Get_Statuses_Mentions_Timeline ex.Message >> " + ex.Message);
}
objTwitterMessage = new Domain.Socioboard.Domain.TwitterMessage();
foreach (var item in data)
{
objTwitterMessage.UserId = Guid.Parse(UserId);
objTwitterMessage.Type = "twt_mentions";
objTwitterMessage.Id = Guid.NewGuid();
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.TwitterMsg = item["text"].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);
}
try
{
objTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
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.InReplyToStatusUserId = item["in_reply_to_status_id_str"].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.ProfileId = objTwitterAccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.ScreenName = item["user"]["screen_name"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterMessage.EntryDate = DateTime.Now;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objTwitterMessageRepository.checkTwitterMessageExists(objTwitterMessage.MessageId))
{
objTwitterMessageRepository.addTwitterMessage(objTwitterMessage);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error("tl.Get_Statuses_Mentions_Timeline ex.StackTrace >> " + ex.StackTrace);
logger.Error("tl.Get_Statuses_Mentions_Timeline ex.Message >> " + ex.Message);
}
#endregion
#region Add User Retweet
twtuser = new TwitterUser();
try
{
JArray Retweet = null;
try
{
Retweet = twtuser.GetStatuses_Retweet_Of_Me(OAuth);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error("twtuser.GetStatuses_Retweet_Of_Me ex.StackTrace >> " + ex.StackTrace);
logger.Error("twtuser.GetStatuses_Retweet_Of_Me ex.Message >> " + ex.Message);
}
objTwitterMessage = new Domain.Socioboard.Domain.TwitterMessage();
foreach (var item in Retweet)
{
objTwitterMessage.UserId = Guid.Parse(UserId);
objTwitterMessage.Type = "twt_retweets";
objTwitterMessage.Id = Guid.NewGuid();
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.TwitterMsg = item["text"].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);
}
try
{
objTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
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.InReplyToStatusUserId = item["in_reply_to_status_id_str"].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.ProfileId = objTwitterAccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
} try
{
objTwitterMessage.EntryDate = DateTime.Now;
}
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_Retweet_Of_Me ex.StackTrace >> " + ex.StackTrace);
logger.Error("twtuser.GetStatuses_Retweet_Of_Me ex.Message >> " + ex.Message);
}
#endregion
#region Add User Tweets
try
{
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
#region Add Twitter User Feed
twtuser = new TwitterUser();
try
{
JArray Home_Timeline = twtuser.GetStatuses_Home_Timeline(OAuth);
objTwitterFeed = new Domain.Socioboard.Domain.TwitterFeed();
foreach (var item in Home_Timeline)
{
objTwitterFeed.UserId = Guid.Parse(UserId);
objTwitterFeed.Type = "twt_feeds";
try
{
objTwitterFeed.Feed = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ScreenName = objTwitterAccount.TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.ProfileId = objTwitterAccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FeedDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
<<<<<<< HEAD
try
{
objTwitterFeed.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objTwitterFeed.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
=======
try
{
objTwitterFeed.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
>>>>>>> e052534b7a2a3744cad9dddbc3c6acccf394ca7b
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
<<<<<<< HEAD
=======
objTwitterFeed.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
>>>>>>> e052534b7a2a3744cad9dddbc3c6acccf394ca7b
objTwitterFeed.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objTwitterFeed.EntryDate = DateTime.Now;
try
{
objTwitterFeed.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objTwitterFeedRepository.checkTwitterFeedExists(objTwitterFeed.MessageId))
{
try
{
objTwitterFeedRepository.addTwitterFeed(objTwitterFeed);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
// Edited by Antima[20/12/2014]
SentimentalAnalysis _SentimentalAnalysis = new SentimentalAnalysis();
FeedSentimentalAnalysisRepository _FeedSentimentalAnalysisRepository = new FeedSentimentalAnalysisRepository();
try
{
if (_FeedSentimentalAnalysisRepository.checkFeedExists(objTwitterFeed.ProfileId.ToString(), Guid.Parse(UserId), objTwitterFeed.Id.ToString()))
{
if (!string.IsNullOrEmpty(objTwitterFeed.Feed))
{
string Network = "twitter";
_SentimentalAnalysis.GetPostSentimentsFromUclassify(Guid.Parse(UserId), objTwitterFeed.ProfileId, objTwitterFeed.MessageId, objTwitterFeed.Feed, Network);
}
}
}
catch (Exception)
{
}
}
}
