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);
}
}
}