public string getDirectMessageSent(string profileId, int days) { TwitterDirectMessageRepository objtwtdm = new TwitterDirectMessageRepository(); string strArray = string.Empty; try { int cnt = 0; ArrayList alstTwt = objtwtdm.gettwtDMSendStatsByProfileId(profileId, days); string str = string.Empty; if (alstTwt != null) { // strArray = "["; for (int i = 0; i < alstTwt.Count; i++) { strArray = strArray + alstTwt[i].ToString() + ","; cnt++; } } if (cnt < 7) { for (int j = 0; j < 7 - cnt; j++) { str = str + "0,"; } } strArray = str + strArray.Substring(0, strArray.Length - 1); } catch (Exception Err) { Console.Write(Err.StackTrace); } return(strArray); }
public DataSet bindSentMessagesToDataTable(User user, string network) { SocialProfilesRepository socioprofrepo = new SocialProfilesRepository(); List <SocialProfile> alstprofiles = socioprofrepo.getAllSocialProfilesOfUser(user.Id); Messages mstable = new Messages(); DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable); foreach (SocialProfile item in alstprofiles) { if (item.ProfileType == "facebook") { FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository(); List <FacebookMessage> alstfbmsgs = fbmsgrepo.getAllSentMessages(item.ProfileId); if (alstfbmsgs != null) { if (alstfbmsgs.Count != 0) { foreach (FacebookMessage facebookmsg in alstfbmsgs) { ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.MessageDate, facebookmsg.Message, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.MessageId, facebookmsg.Type); } } } } else if (item.ProfileType == "twitter") { TwitterDirectMessageRepository twtmsgrepo = new TwitterDirectMessageRepository(); List <TwitterDirectMessages> lstmsgtwtuser = twtmsgrepo.getAllDirectMessagesById(item.ProfileId); foreach (TwitterDirectMessages lst in lstmsgtwtuser) { ds.Tables[0].Rows.Add(lst.SenderId, "twitter", lst.SenderId, lst.SenderScreenName, lst.SenderProfileUrl, lst.CreatedDate, lst.Message, "", "", lst.MessageId, lst.Type); } } else if (item.ProfileType == "googleplus") { } } return(ds); }
public void getPageConversations(string UserId, FacebookClient fb, dynamic profile) { try { TwitterDirectMessageRepository _TwitterDirectMessageRepository = new TwitterDirectMessageRepository(); Domain.Socioboard.Domain.TwitterDirectMessages _TwitterDirectMessages; dynamic data = fb.Get("v2.0/me/conversations"); foreach (var item in data["data"]) { foreach (var msg_item in item["messages"]["data"]) { _TwitterDirectMessages = new Domain.Socioboard.Domain.TwitterDirectMessages(); _TwitterDirectMessages.UserId = Guid.Parse(UserId); _TwitterDirectMessages.EntryDate = DateTime.Now; try { _TwitterDirectMessages.MessageId = msg_item["id"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.CreatedDate = Convert.ToDateTime(msg_item["created_time"].ToString()); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.SenderId = msg_item["from"]["id"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.SenderScreenName = msg_item["from"]["name"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.SenderProfileUrl = "http://graph.facebook.com/" + _TwitterDirectMessages.SenderId + "/picture?type=small"; } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.RecipientId = msg_item["to"]["data"][0]["id"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.RecipientScreenName = msg_item["to"]["data"][0]["name"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.RecipientProfileUrl = "http://graph.facebook.com/" + _TwitterDirectMessages.RecipientId + "/picture?type=small"; } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.Message = msg_item["message"].ToString(); if (string.IsNullOrEmpty(_TwitterDirectMessages.Message)) { if ((msg_item["attachments"]["data"][0]["mime_type"].ToString()).Contains("image")) { _TwitterDirectMessages.Image = msg_item["attachments"]["data"][0]["image_data"]["url"].ToString(); } else { _TwitterDirectMessages.Message = msg_item["attachments"]["data"][0]["name"].ToString(); } } } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } try { _TwitterDirectMessages.Image = msg_item["shares"]["data"][0]["link"].ToString(); } catch (Exception ex) { logger.Error("Facebook.asmx = > getPageConversations = > " + ex.Message); } if (_TwitterDirectMessages.SenderId == profile["id"].ToString()) { _TwitterDirectMessages.Type = "fb_sent"; } else { _TwitterDirectMessages.Type = "fb_received"; } if (!_TwitterDirectMessageRepository.checkExistsDirectMessages(Guid.Parse(UserId), _TwitterDirectMessages.MessageId)) { _TwitterDirectMessageRepository.addNewDirectMessage(_TwitterDirectMessages); } else { _TwitterDirectMessageRepository.updateImage(_TwitterDirectMessages); } } } } catch (Exception ex) { logger.Error("getPageConversations = > " + ex.Message); } }
public string DeleteAllUsersByCreateDate(string date) { int i = 0; int count = 0; UserRepository objUserRepository = new UserRepository(); List <User> lstuser = objUserRepository.GetAllUsersByCreateDate(date); ArchiveMessageRepository objArchiveMessageRepository = new ArchiveMessageRepository(); DiscoverySearchRepository objDiscoverySearchRepository = new DiscoverySearchRepository(); DraftsRepository objDraftsRepository = new DraftsRepository(); FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository(); FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository(); FacebookInsightPostStatsRepository objFacebookInsightPostStatsRepository = new FacebookInsightPostStatsRepository(); FacebookInsightStatsRepository objFacebookInsightStatsRepository = new FacebookInsightStatsRepository(); FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository(); FacebookStatsRepository objFacebookStatsRepository = new FacebookStatsRepository(); GoogleAnalyticsAccountRepository objGoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository(); GoogleAnalyticsStatsRepository objGoogleAnalyticsStatsRepository = new GoogleAnalyticsStatsRepository(); GooglePlusAccountRepository objGooglePlusAccountRepository = new GooglePlusAccountRepository(); GooglePlusActivitiesRepository objGooglePlusActivitiesRepository = new GooglePlusActivitiesRepository(); GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository(); GroupRepository objGroupRepository = new GroupRepository(); InstagramAccountRepository objInstagramAccountRepository = new InstagramAccountRepository(); InstagramCommentRepository objInstagramCommentRepository = new InstagramCommentRepository(); InstagramFeedRepository objInstagramFeedRepository = new InstagramFeedRepository(); LinkedInAccountRepository objLinkedInAccountRepository = new LinkedInAccountRepository(); LinkedInFeedRepository objLinkedInFeedRepository = new LinkedInFeedRepository(); LogRepository objLogRepository = new LogRepository(); RssFeedsRepository objRssFeedsRepository = new RssFeedsRepository(); RssReaderRepository objRssReaderRepository = new RssReaderRepository(); ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository(); SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository(); TaskCommentRepository objTaskCommentRepository = new TaskCommentRepository(); TaskRepository objTaskRepository = new TaskRepository(); TeamRepository objTeamRepository = new TeamRepository(); TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository(); TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository(); TwitterDirectMessageRepository objTwitterDirectMessageRepository = new TwitterDirectMessageRepository(); TwitterFeedRepository objTwitterFeedRepository = new TwitterFeedRepository(); TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository(); TwitterStatsRepository objTwitterStatsRepository = new TwitterStatsRepository(); UserActivationRepository objUserActivationRepository = new UserActivationRepository(); UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository(); count = lstuser.Count(); foreach (var item in lstuser) { i++; try { if (item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**") { } else { objArchiveMessageRepository.DeleteArchiveMessageByUserid(item.Id); objDiscoverySearchRepository.DeleteDiscoverySearchByUserid(item.Id); objDraftsRepository.DeleteDraftsByUserid(item.Id); objFacebookAccountRepository.DeleteFacebookAccountByUserid(item.Id); objFacebookFeedRepository.DeleteFacebookFeedByUserid(item.Id); objFacebookInsightPostStatsRepository.DeleteFacebookInsightPostStatsByUserid(item.Id); objFacebookInsightStatsRepository.DeleteFacebookInsightStatsByUserid(item.Id); objFacebookMessageRepository.DeleteFacebookMessageByUserid(item.Id); objFacebookStatsRepository.DeleteFacebookStatsByUserid(item.Id); objGoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(item.Id); objGoogleAnalyticsStatsRepository.DeleteGoogleAnalyticsStatsByUserid(item.Id); objGooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(item.Id); objGooglePlusActivitiesRepository.DeleteGooglePlusActivitiesByUserid(item.Id); objGroupProfileRepository.DeleteGroupProfileByUserid(item.Id); objGroupRepository.DeleteGroupsByUserid(item.Id); objInstagramAccountRepository.DeleteInstagramAccountByUserid(item.Id); objInstagramCommentRepository.DeleteInstagramCommentByUserid(item.Id); objInstagramFeedRepository.DeleteInstagramFeedByUserid(item.Id); objLinkedInAccountRepository.DeleteLinkedInAccountByUserid(item.Id); objLinkedInFeedRepository.DeleteLinkedInFeedByUserid(item.Id); objLogRepository.DeleteLogByUserid(item.Id); objRssFeedsRepository.DeleteRssFeedsByUserid(item.Id); objRssReaderRepository.DeleteRssReaderByUserid(item.Id); objScheduledMessageRepository.DeleteScheduledMessageByUserid(item.Id); objSocialProfilesRepository.DeleteSocialProfileByUserid(item.Id); objTaskCommentRepository.DeleteTaskCommentByUserid(item.Id); objTaskRepository.DeleteTasksByUserid(item.Id); objTeamRepository.DeleteTeamByUserid(item.Id); objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(item.Id); objTwitterAccountRepository.DeleteTwitterAccountByUserid(item.Id); objTwitterDirectMessageRepository.DeleteTwitterDirectMessagesByUserid(item.Id); objTwitterFeedRepository.DeleteTwitterFeedByUserid(item.Id); objTwitterMessageRepository.DeleteTwitterMessageByUserid(item.Id); objTwitterStatsRepository.DeleteTwitterStatsByUserid(item.Id); objUserActivationRepository.DeleteUserActivationByUserid(item.Id); objUserPackageRelationRepository.DeleteuserPackageRelationByUserid(item.Id); objUserRepository.DeleteUserByUserid(item.Id); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(i + " " + count); }
public void getSentDirectMessages(oAuthTwitter OAuth, TwitterAccount twitterAccount, Guid userid) { TwitterUser twtuser = new TwitterUser(); JArray data = twtuser.GetDirect_Messages_Sent(OAuth, 20); TwitterDirectMessageRepository twtmsgrepo = new TwitterDirectMessageRepository(); TwitterDirectMessages twtmsg = new TwitterDirectMessages(); foreach (var item in data) { twtmsg.UserId = userid; twtmsg.Type = "twt_directmessages_sent"; twtmsg.Id = Guid.NewGuid(); try { twtmsg.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.CreatedDate = SocioBoard.Helper.Extensions.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"')); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.Message = item["text"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.RecipientId = item["recipient"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.RecipientScreenName = item["recipient"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.RecipientProfileUrl = item["recipient"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.SenderId = item["sender"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.SenderScreenName = item["sender"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.SenderProfileUrl = item["sender"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.EntryDate = DateTime.Now; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (!twtmsgrepo.checkExistsDirectMessages(twtmsg.MessageId)) { twtmsgrepo.addNewDirectMessage(twtmsg); } } }