public void GetUserActivities(string GpUserId, string acces_token, Guid UserId)
{
ActivitiesController obj = new ActivitiesController();
GooglePlusActivitiesRepository objgpActRepo = new GooglePlusActivitiesRepository();
GooglePlusActivities objgpAct = new GooglePlusActivities();
JArray objActivity = obj.GetActivitiesList(GpUserId, acces_token);
foreach (var itemActivity in objActivity)
{
foreach (var itemAct in itemActivity["items"])
{
objgpAct.ActivityId = itemAct["id"].ToString();
objgpAct.ActivityUrl = itemAct["url"].ToString();
objgpAct.Content = itemAct["object"]["content"].ToString();
objgpAct.EntryDate = DateTime.Now;
objgpAct.FromId = itemAct["actor"]["id"].ToString();
objgpAct.FromProfileImage = itemAct["actor"]["image"]["url"].ToString();
objgpAct.FromUserName = itemAct["actor"]["displayName"].ToString();
objgpAct.GpUserId = GpUserId;
objgpAct.Id = Guid.NewGuid();
objgpAct.PlusonersCount = int.Parse(itemAct["object"]["plusoners"]["totalItems"].ToString());
objgpAct.RepliesCount = int.Parse(itemAct["object"]["replies"]["totalItems"].ToString());
objgpAct.ResharersCount = int.Parse(itemAct["object"]["resharers"]["totalItems"].ToString());
objgpAct.PublishedDate = itemAct["published"].ToString();
objgpAct.Title = itemActivity["title"].ToString();
objgpAct.UserId = UserId;
if (!objgpActRepo.checkgoogleplusActivityExists(itemAct["id"].ToString(), UserId))
{
objgpActRepo.addgoogleplusActivity(objgpAct);
}
else
{
objgpActRepo.updategoogleplusActivity(objgpAct);
}
}
}
}
public DataSet bindMessagesIntoDataTable(Guid id)
{
//SocialProfilesRepository socioprofrepo = new SocialProfilesRepository();
//List<SocialProfile> alstprofiles = socioprofrepo.getAllSocialProfilesOfUser(user.Id);
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
List <TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(id);
// DataTableGenerator datatablegenerepo = new DataTableGenerator();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
// DataSet ds = datatablegenerepo.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
List <FacebookFeed> alstfeedfb = fbfeedRepo.getUnreadMessages(item.ProfileId);
foreach (FacebookFeed facebookmsg in alstfeedfb)
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
}
else if (item.ProfileType == "twitter")
{
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
List <TwitterMessage> lstmsgtwtuser = twtmsgrepo.getUnreadMessages(item.ProfileId);
foreach (TwitterMessage lst in lstmsgtwtuser)
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
}
else if (item.ProfileType == "googleplus")
{
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
//FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedrepo.getAllReadFacebookFeeds(user.Id, item.ProfileId);
//foreach (FacebookFeed facebookmsg in alstfbmsgs)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type,facebookmsg.ReadStatus);
//}
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
//TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwtuser = twtmsgrepo.getAllReadMessagesOfUser(user.Id, item.ProfileId);
//foreach (TwitterMessage lst in lstmsgtwtuser)
//{
// ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type,lst.ReadStatus);
//}
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
//GooglePlusActivitiesRepository objActRepo = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggauser = objActRepo.getAllgoogleplusActivityOfUser(user.Id, item.ProfileId);
//foreach (GooglePlusActivities lst in lstmsggauser)
//{
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
//}
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository();
List <FacebookFeed> alstfbmsgs = fbfeedRepository.getAllReadFbFeeds(facebookid);
try
{
foreach (FacebookFeed facebookmsg in alstfbmsgs)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
TwitterMessageRepository twtmsgRepository = new TwitterMessageRepository();
List <TwitterMessage> lstmsgtwt = twtmsgRepository.getAlltwtMessagesOfUser(twitterid);
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
List <GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
try
{
foreach (GooglePlusActivities lst in lstmsggpl)
{
try
{
ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(ds);
}
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);
}