public string GetAllTwitterStatsDetails(string Profileid, string userid, string days) { int dayscount = Convert.ToInt32(days); Guid Userid = Guid.Parse(userid); ArrayList arrTwtStats = new ArrayList(); TwitterDirectMessageRepository objTwitterDirectMessageRepository = new TwitterDirectMessageRepository(); ArrayList arrTwtBeforestats = new ArrayList(); dynamic _TwitterStatsReport_1 = null; dynamic _TwitterStatsReport_2 = null; Domain.Myfashion.Domain.TwitterStatsReport _TwitterStats = new Domain.Myfashion.Domain.TwitterStatsReport(); try { arrTwtStats = _TwitterStatsRepository.getTwitterStatsByIdDay(Profileid, Userid, dayscount); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { arrTwtBeforestats = _TwitterStatsRepository.getTwitterStatsByIdbeforeDay(Profileid, Userid, dayscount); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (arrTwtStats.Count != 0) { _TwitterStatsReport_1 = arrTwtStats[0]; if (arrTwtBeforestats.Count != 0) { _TwitterStatsReport_2 = arrTwtBeforestats[0]; _TwitterStats.FollowerCount = Math.Abs(_TwitterStatsReport_1[4] - _TwitterStatsReport_2[4]); _TwitterStats.FollowingCount = Math.Abs(_TwitterStatsReport_1[3] - _TwitterStatsReport_2[3]); //_TwitterStats.DMRecievedCount = Math.Abs(_TwitterStatsReport_1[5] - _TwitterStatsReport_2[5]); //_TwitterStats.DMSentCount = Math.Abs(_TwitterStatsReport_1[6] - _TwitterStatsReport_2[6]); _TwitterStats.DMRecievedCount = objTwitterDirectMessageRepository.GetDirrectMessageReceiveCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.DMSentCount = objTwitterDirectMessageRepository.GetDirrectMessageCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.Age1820 = _TwitterStatsReport_1[9] - _TwitterStatsReport_2[9]; _TwitterStats.Age2124 = _TwitterStatsReport_1[10] - _TwitterStatsReport_2[10]; _TwitterStats.Age2534 = _TwitterStatsReport_1[11] - _TwitterStatsReport_2[11]; _TwitterStats.Age3544 = _TwitterStatsReport_1[12] - _TwitterStatsReport_2[12]; _TwitterStats.Age4554 = _TwitterStatsReport_1[13] - _TwitterStatsReport_2[13]; _TwitterStats.Age5564 = _TwitterStatsReport_1[14] - _TwitterStatsReport_2[14]; _TwitterStats.Age65 = _TwitterStatsReport_1[15] - _TwitterStatsReport_2[15]; } else { _TwitterStats.FollowerCount = _TwitterStatsReport_1[4]; _TwitterStats.FollowingCount = _TwitterStatsReport_1[3]; //_TwitterStats.DMRecievedCount =_TwitterStatsReport_1[5]; //_TwitterStats.DMSentCount = _TwitterStatsReport_1[6]; _TwitterStats.DMRecievedCount = objTwitterDirectMessageRepository.GetDirrectMessageReceiveCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.DMSentCount = objTwitterDirectMessageRepository.GetDirrectMessageCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.Age1820 = _TwitterStatsReport_1[9]; _TwitterStats.Age2124 = _TwitterStatsReport_1[10]; _TwitterStats.Age2534 = _TwitterStatsReport_1[11]; _TwitterStats.Age3544 = _TwitterStatsReport_1[12]; _TwitterStats.Age4554 = _TwitterStatsReport_1[13]; _TwitterStats.Age5564 = _TwitterStatsReport_1[14]; _TwitterStats.Age65 = _TwitterStatsReport_1[15]; } } List <Domain.Myfashion.Domain.TwitterStatsReport> _lstTwitterStats = new List <Domain.Myfashion.Domain.TwitterStatsReport>(); string Engagement = Engagementreport(Profileid, Userid, dayscount); string influence = Influencereport(Profileid, Userid, dayscount); string datetime = DateTimereport(Profileid, Userid, dayscount); TwitterMessage _TwitterMessage = new TwitterMessage(); // string twtmention = _TwitterMessage.getTwtMention(Profileid, Userid, dayscount); //string twtretweet = _TwitterMessage.getRetweets(Profileid, Userid, dayscount); string twtmention = _TwitterMessage.GetMentionStatsCountByProfileIdAndUserId(Profileid, Userid, dayscount); string twtretweet = _TwitterMessage.GetRetweetStatsCountByProfileIdAndUserId(Profileid, Userid, dayscount); TwitterAccount _TwitterAccount = new TwitterAccount(); Domain.Myfashion.Domain.TwitterAccount obj = _TwitterAccount.AcccountDetails(Profileid, Userid); _TwitterStats.TwtProfImgUrl = obj.ProfileImageUrl; _TwitterStats.TwtUserName = obj.TwitterScreenName; _TwitterStats.days = dayscount; _TwitterStats.TwitterId = Profileid; _TwitterStats.Engagement = Engagement; _TwitterStats.Influence = influence; _TwitterStats.EntryDate = datetime; _TwitterStats.TwtRetweet = Convert.ToInt32(twtretweet); _TwitterStats.TwtMention = Convert.ToInt32(twtmention); _lstTwitterStats.Add(_TwitterStats); return(new JavaScriptSerializer().Serialize(_lstTwitterStats)); }
public string GetAllTwitterStatsDetails(string Profileid,string userid,string days) { int dayscount = Convert.ToInt32(days); Guid Userid=Guid.Parse(userid); ArrayList arrTwtStats = new ArrayList(); TwitterDirectMessageRepository objTwitterDirectMessageRepository = new TwitterDirectMessageRepository(); ArrayList arrTwtBeforestats = new ArrayList(); dynamic _TwitterStatsReport_1 =null; dynamic _TwitterStatsReport_2 = null; Domain.Myfashion.Domain.TwitterStatsReport _TwitterStats = new Domain.Myfashion.Domain.TwitterStatsReport(); try { arrTwtStats = _TwitterStatsRepository.getTwitterStatsByIdDay(Profileid, Userid, dayscount); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { arrTwtBeforestats = _TwitterStatsRepository.getTwitterStatsByIdbeforeDay(Profileid, Userid, dayscount); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (arrTwtStats.Count != 0) { _TwitterStatsReport_1 = arrTwtStats[0]; if (arrTwtBeforestats.Count != 0) { _TwitterStatsReport_2 = arrTwtBeforestats[0]; _TwitterStats.FollowerCount = Math.Abs(_TwitterStatsReport_1[4] - _TwitterStatsReport_2[4]); _TwitterStats.FollowingCount = Math.Abs(_TwitterStatsReport_1[3] - _TwitterStatsReport_2[3]); //_TwitterStats.DMRecievedCount = Math.Abs(_TwitterStatsReport_1[5] - _TwitterStatsReport_2[5]); //_TwitterStats.DMSentCount = Math.Abs(_TwitterStatsReport_1[6] - _TwitterStatsReport_2[6]); _TwitterStats.DMRecievedCount = objTwitterDirectMessageRepository.GetDirrectMessageReceiveCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.DMSentCount = objTwitterDirectMessageRepository.GetDirrectMessageCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.Age1820 = _TwitterStatsReport_1[9] - _TwitterStatsReport_2[9]; _TwitterStats.Age2124 = _TwitterStatsReport_1[10] - _TwitterStatsReport_2[10]; _TwitterStats.Age2534 = _TwitterStatsReport_1[11] - _TwitterStatsReport_2[11]; _TwitterStats.Age3544 = _TwitterStatsReport_1[12] - _TwitterStatsReport_2[12]; _TwitterStats.Age4554 = _TwitterStatsReport_1[13] - _TwitterStatsReport_2[13]; _TwitterStats.Age5564 = _TwitterStatsReport_1[14] - _TwitterStatsReport_2[14]; _TwitterStats.Age65 = _TwitterStatsReport_1[15] - _TwitterStatsReport_2[15]; } else { _TwitterStats.FollowerCount = _TwitterStatsReport_1[4] ; _TwitterStats.FollowingCount = _TwitterStatsReport_1[3] ; //_TwitterStats.DMRecievedCount =_TwitterStatsReport_1[5]; //_TwitterStats.DMSentCount = _TwitterStatsReport_1[6]; _TwitterStats.DMRecievedCount = objTwitterDirectMessageRepository.GetDirrectMessageReceiveCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.DMSentCount = objTwitterDirectMessageRepository.GetDirrectMessageCountByProfileIdAndUserId(Userid, Profileid, dayscount); _TwitterStats.Age1820 = _TwitterStatsReport_1[9]; _TwitterStats.Age2124 = _TwitterStatsReport_1[10]; _TwitterStats.Age2534 = _TwitterStatsReport_1[11]; _TwitterStats.Age3544 = _TwitterStatsReport_1[12]; _TwitterStats.Age4554 = _TwitterStatsReport_1[13]; _TwitterStats.Age5564 = _TwitterStatsReport_1[14]; _TwitterStats.Age65 = _TwitterStatsReport_1[15]; } } List<Domain.Myfashion.Domain.TwitterStatsReport> _lstTwitterStats = new List<Domain.Myfashion.Domain.TwitterStatsReport>(); string Engagement = Engagementreport(Profileid, Userid, dayscount); string influence = Influencereport(Profileid, Userid, dayscount); string datetime = DateTimereport(Profileid, Userid, dayscount); TwitterMessage _TwitterMessage = new TwitterMessage(); // string twtmention = _TwitterMessage.getTwtMention(Profileid, Userid, dayscount); //string twtretweet = _TwitterMessage.getRetweets(Profileid, Userid, dayscount); string twtmention = _TwitterMessage.GetMentionStatsCountByProfileIdAndUserId(Profileid, Userid, dayscount); string twtretweet = _TwitterMessage.GetRetweetStatsCountByProfileIdAndUserId(Profileid, Userid, dayscount); TwitterAccount _TwitterAccount = new TwitterAccount(); Domain.Myfashion.Domain.TwitterAccount obj = _TwitterAccount.AcccountDetails(Profileid,Userid); _TwitterStats.TwtProfImgUrl = obj.ProfileImageUrl; _TwitterStats.TwtUserName = obj.TwitterScreenName; _TwitterStats.days = dayscount; _TwitterStats.TwitterId = Profileid; _TwitterStats.Engagement = Engagement; _TwitterStats.Influence = influence; _TwitterStats.EntryDate = datetime; _TwitterStats.TwtRetweet = Convert.ToInt32(twtretweet); _TwitterStats.TwtMention = Convert.ToInt32(twtmention); _lstTwitterStats.Add(_TwitterStats); return new JavaScriptSerializer().Serialize(_lstTwitterStats); }
public string GetTeamMembeDetailsForGroupReport(string TeamId, string userid, string days) { string FacebookprofileId = string.Empty; string TwitterprofileId = string.Empty; string FacebookFanPageId = string.Empty; string profid = string.Empty; string FacebookInboxMessagecount = string.Empty; string TwitterInboxMessagecount = string.Empty; Domain.Myfashion.Domain.GroupStatDetails _GroupStatDetails = new Domain.Myfashion.Domain.GroupStatDetails(); Guid UserId = Guid.Parse(userid); try { List <FacebookAccount> _facebookAccount = new List <FacebookAccount>(); List <Domain.Myfashion.Domain.TeamMemberProfile> lstTeamMember = teammemberrepo.getAllTeamMemberProfilesOfTeam(Guid.Parse(TeamId)); // _GroupStatDetails.ProfilesByUser = lstTeamMember.Count(); foreach (Domain.Myfashion.Domain.TeamMemberProfile TeamMemberProfile in lstTeamMember) { #region MyRegion try { if (TeamMemberProfile.ProfileType == "facebook" || TeamMemberProfile.ProfileType == "twitter") { profid += TeamMemberProfile.ProfileId + ','; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { if (TeamMemberProfile.ProfileType == "facebook") { FacebookprofileId += TeamMemberProfile.ProfileId + ','; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { if (TeamMemberProfile.ProfileType == "twitter") { TwitterprofileId += TeamMemberProfile.ProfileId + ','; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { if (TeamMemberProfile.ProfileType == "facebook_page") { FacebookFanPageId += TeamMemberProfile.ProfileId + ','; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } #endregion } #region MyRegion try { profid = profid.Substring(0, profid.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { FacebookFanPageId = FacebookFanPageId.Substring(0, FacebookFanPageId.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); FacebookFanPageId = null; } try { TwitterprofileId = TwitterprofileId.Substring(0, TwitterprofileId.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); TwitterprofileId = null; } try { FacebookprofileId = FacebookprofileId.Substring(0, FacebookprofileId.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); FacebookprofileId = null; } #endregion #region Inboxmessagecount if (!string.IsNullOrEmpty(FacebookprofileId)) { try { FacebookMessage _FacebookMessage = new FacebookMessage(); FacebookInboxMessagecount = _FacebookMessage.GetAllInboxMessage(userid, FacebookprofileId, days); } catch (Exception ex) { FacebookInboxMessagecount = (0).ToString(); Console.WriteLine(ex.StackTrace); } } else { FacebookInboxMessagecount = (0).ToString(); } if (!string.IsNullOrEmpty(TwitterprofileId)) { try { TwitterFeed _TwitterFeed = new TwitterFeed(); TwitterInboxMessagecount = _TwitterFeed.TwitterInboxMessagecount(userid, TwitterprofileId, days); } catch (Exception ex) { TwitterInboxMessagecount = (0).ToString(); Console.WriteLine(ex.StackTrace); } } else { TwitterInboxMessagecount = (0).ToString(); } _GroupStatDetails.IncommingMessage = (Convert.ToInt32(FacebookInboxMessagecount) + Convert.ToInt32(TwitterInboxMessagecount)); #endregion #region sentmessage if (!string.IsNullOrEmpty(profid)) { try { ScheduledMessage _ScheduledMessage = new ScheduledMessage(); _GroupStatDetails.SentMessage = _ScheduledMessage.GetAllScheduledMessage(userid, profid, days); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); _GroupStatDetails.SentMessage = 0; } } #endregion #region twitterfolllower try { TwitterAccountFollowers _TwitterAccountFollowers = new TwitterAccountFollowers(); _GroupStatDetails.TwitterFollower = _TwitterAccountFollowers.FollowerCount(userid, TwitterprofileId, days); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); _GroupStatDetails.TwitterFollower = 0; } #endregion #region fancount try { FacebookFanPage _FacebookFanPage = new FacebookFanPage(); _GroupStatDetails.FacebookFan = _FacebookFanPage.FacebookFans(userid, FacebookFanPageId, days); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); _GroupStatDetails.FacebookFan = 0; } #endregion #region MentionRetweetDetails try { TwitterMessage _TwitterMessage = new TwitterMessage(); _GroupStatDetails.MentionGraph = string.Empty; string graphdetails = _TwitterMessage.GetAllRetweetMentionBydays(userid, TwitterprofileId, days); //string graphdetails = inboxmsgrepo.GetAllRetweetMentionBydays(userid, TwitterprofileId, days); string[] data = graphdetails.Split('@'); foreach (var item in data) { if (item.Contains("usrtwet^")) { _GroupStatDetails.UserTweetGraph = item.Replace("usrtwet^", ""); } else if (item.Contains("mention^")) { _GroupStatDetails.MentionGraph = item.Replace("mention^", ""); } else if (item.Contains("retwet^")) { _GroupStatDetails.RetweetGraph = item.Replace("retwet^", ""); } else if (item.Contains("metion")) { _GroupStatDetails.Mention = Convert.ToInt32(item.Replace("metion", "")); } else if (item.Contains("retwet")) { _GroupStatDetails.Retweet = Convert.ToInt32(item.Replace("retwet", "")); } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } #endregion try { ScheduledMessage _ScheduledMessage = new ScheduledMessage(); string details = _ScheduledMessage.GetAllScheduleMsgDetailsForReport(userid, TwitterprofileId, days); string[] data = details.Split('@'); foreach (var item in data) { if (item.Contains("plaintext_")) { _GroupStatDetails.PlainText = Convert.ToInt32(item.Replace("plaintext_", "")); } else { _GroupStatDetails.PhotoLink = Convert.ToInt32(item); } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return("Something Went Wrong"); } return(new JavaScriptSerializer().Serialize(_GroupStatDetails)); }