public void DeleteArchiveMessage(string UserId, string MessageId, string SocialGroup)
{
Domain.Myfashion.Domain.ArchiveMessage ApiobjArchiveMessage = new Domain.Myfashion.Domain.ArchiveMessage();
try
{
if (SocialGroup == "facebook")
{
FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository();
objFacebookMessageRepository.updateFacebookMessageArchiveStatus(MessageId, Guid.Parse(UserId));
//objFacebookMessageRepository.DeleteFacebookMessagebymessageid(Message, MessageId, Guid.Parse(UserId));
}
if (SocialGroup == "twitter")
{
TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository();
objTwitterMessageRepository.updateTwitterMessageArchiveStatus(MessageId, Guid.Parse(UserId));
//objTwitterMessageRepository.DeleteTwitterMessagebymessageid(Message, MessageId, Guid.Parse(UserId));
}
}
catch (Exception ex)
{
Console.Write(ex.StackTrace);
}
}
//Saving FacebookWall of user into database i.e. FacebookMessage table
public void getFacebookUserHome(dynamic data, dynamic profile)
{
FacebookMessage fbmsg = new FacebookMessage();
FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository();
string profileid = string.Empty;
User user = (User)HttpContext.Current.Session["LoggedUser"];
if (data != null)
{
int lstfbcount = 0;
foreach (dynamic result in data["data"])
{
string message = string.Empty;
string imgprof = "http://graph.facebook.com/" + result["from"]["id"] + "/picture?type=small";
fbmsg.EntryDate = DateTime.Now;
fbmsg.MessageId = result["id"].ToString();
fbmsg.FromId = result["from"]["id"].ToString();
fbmsg.FromName = result["from"]["name"].ToString();
fbmsg.FromProfileUrl = imgprof;
fbmsg.Id = Guid.NewGuid();
fbmsg.MessageDate = DateTime.Parse(result["created_time"].ToString());
fbmsg.UserId = user.Id;
try
{
fbmsg.Picture = result["picture"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
fbmsg.Picture = null;
}
try
{
if (result["message_tags"][0] != null)
{
if (result["to"] != null)
{
foreach (var item in result["to"]["data"])
{
if (result["from"] != null)
{
if (item["id"] != profile["id"])
{
if (result["from"]["id"] == profile["id"])
{
fbmsg.Type = "fb_tag";
}
else
{
fbmsg.Type = "fb_home";
}
}
else
{
fbmsg.Type = "fb_home";
}
}
}
}
else
{
fbmsg.Type = "fb_home";
}
}
else
{
fbmsg.Type = "fb_home";
}
}
catch (Exception ex)
{
fbmsg.Type = "fb_home";
Console.WriteLine(ex.StackTrace);
}
fbmsg.ProfileId = profile["id"].ToString();
fbmsg.FbComment = "http://graph.facebook.com/" + result["id"] + "/comments";
fbmsg.FbLike = "http://graph.facebook.com/" + result["id"] + "/likes";
if (lstfbcount < 25)
{
try
{
if (result["message"] != null)
{
message = result["message"];
lstfbcount++;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
try
{
if (result["description"] != null)
{
message = result["description"];
lstfbcount++;
}
}
catch (Exception exx)
{
try
{
Console.WriteLine(exx.StackTrace);
if (result["story"] != null)
{
message = result["story"];
lstfbcount++;
}
}
catch (Exception exxx)
{
Console.WriteLine(exxx.StackTrace);
message = string.Empty;
}
}
}
}
fbmsg.Message = message;
if (!fbmsgrepo.checkFacebookMessageExists(fbmsg.MessageId))
{
fbmsgrepo.addFacebookMessage(fbmsg);
}
}
}
}
public DataSet bindFeedsIntoDataTable(User user, string network)
{
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
if (!string.IsNullOrEmpty(network))
{
/*Facebook region*/
if (network == "facebook")
{
FacebookAccountRepository fbaccount = new FacebookAccountRepository();
FacebookMessageRepository fbmsg = new FacebookMessageRepository();
ArrayList alstfbaccount = fbaccount.getAllFacebookAccountsOfUser(user.Id);
foreach (FacebookAccount item in alstfbaccount)
{
List <FacebookMessage> lstfbmsg = fbmsg.getAllFacebookMessagesOfUser(user.Id, item.FbUserId);
foreach (FacebookMessage facebookmsg in lstfbmsg)
{
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 (network == "twitter")
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
TwitterFeedRepository twtfeedrepo = new TwitterFeedRepository();
ArrayList alsttwtaccount = twtaccountrepo.getAllTwitterAccountsOfUser(user.Id);
foreach (TwitterAccount item in alsttwtaccount)
{
List <TwitterFeed> lsttwtmsg = twtfeedrepo.getAllTwitterFeedOfUsers(user.Id, item.TwitterUserId);
foreach (TwitterFeed twtmsg in lsttwtmsg)
{
ds.Tables[0].Rows.Add(twtmsg.ProfileId, "twitter", twtmsg.FromId, twtmsg.FromScreenName, twtmsg.FromProfileUrl, twtmsg.FeedDate, twtmsg.Feed, "", "", twtmsg.MessageId, twtmsg.Type);
}
}
}
else if (network == "linkedin")
{
LinkedInAccountRepository liaccountrepo = new LinkedInAccountRepository();
LinkedInFeedRepository lifeedrepo = new LinkedInFeedRepository();
ArrayList alstliaccount = liaccountrepo.getAllLinkedinAccountsOfUser(user.Id);
foreach (LinkedInAccount item in alstliaccount)
{
List <LinkedInFeed> lsttwtmsg = lifeedrepo.getAllLinkedInFeedsOfUser(user.Id, item.LinkedinUserId);
foreach (LinkedInFeed limsg in lsttwtmsg)
{
ds.Tables[0].Rows.Add(limsg.ProfileId, "linkedin", limsg.FromId, limsg.FromName, limsg.FromPicUrl, limsg.FeedsDate, limsg.Feeds, "", "", "", limsg.Type);
}
}
}
else if (network == "instagram")
{
InstagramAccountRepository insAccRepo = new InstagramAccountRepository();
InstagramFeedRepository insFeedRepo = new InstagramFeedRepository();
ArrayList alstlistaccount = insAccRepo.getAllInstagramAccountsOfUser(user.Id);
foreach (InstagramAccount item in alstlistaccount)
{
List <InstagramFeed> lstFeeed = insFeedRepo.getAllInstagramFeedsOfUser(user.Id, item.InstagramId);
foreach (InstagramFeed insFeed in lstFeeed)
{
ds.Tables[0].Rows.Add(insFeed.InstagramId, "instagram", "", "", "", insFeed.FeedDate, insFeed.FeedImageUrl, "", "", insFeed.FeedId, "");
}
}
}
}
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);
}
public void getInboxMessages(dynamic data, dynamic profile, Guid userId)
{
FacebookMessage fbmsg = new FacebookMessage();
FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository();
string profileid = string.Empty;
User user = (User)HttpContext.Current.Session["LoggedUser"];
if (data != null)
{
int lstfbcount = 0;
foreach (dynamic result in data["data"])
{
try
{
foreach (dynamic message in result["comments"]["data"])
{
//Do want you want with the messages
fbmsg.MessageId = message["id"];
fbmsg.FromName = message["from"]["name"];
fbmsg.FromId = message["from"]["id"];
fbmsg.Message = message["message"];
fbmsg.MessageDate = DateTime.Parse(message["created_time"].ToString()); ;
fbmsg.FromProfileUrl = "http://graph.facebook.com/" + message["from"]["id"] + "/picture?type=small";
fbmsg.EntryDate = DateTime.Now;
fbmsg.Id = Guid.NewGuid();
fbmsg.ProfileId = profile["id"].ToString();
fbmsg.Type = "inbox_message";
fbmsg.UserId = userId;
if (!fbmsgrepo.checkFacebookMessageExists(fbmsg.MessageId))
{
fbmsgrepo.addFacebookMessage(fbmsg);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public List<FacebookMessage> getFacebookMessagesOfUser(Guid userid, string profileid)
{
FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository();
List<FacebookMessage> lstfbmsg = fbmsgrepo.getAllFacebookMessagesOfUser(userid, profileid);
return lstfbmsg;
}
//Saving FacebookWall of user into database i.e. FacebookMessage table
public void getFacebookUserHome(dynamic data, dynamic profile)
{
FacebookMessage fbmsg = new FacebookMessage();
FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository();
string profileid = string.Empty;
User user = (User)HttpContext.Current.Session["LoggedUser"];
if (data != null)
{
int lstfbcount = 0;
foreach (dynamic result in data["data"])
{
string message = string.Empty;
string imgprof = "http://graph.facebook.com/" + result["from"]["id"] + "/picture?type=small";
fbmsg.EntryDate = DateTime.Now;
fbmsg.MessageId = result["id"].ToString();
fbmsg.FromId = result["from"]["id"].ToString();
fbmsg.FromName = result["from"]["name"].ToString();
fbmsg.FromProfileUrl = imgprof;
fbmsg.Id = Guid.NewGuid();
fbmsg.MessageDate = DateTime.Parse(result["created_time"].ToString());
fbmsg.UserId = user.Id;
try
{
fbmsg.Picture = result["picture"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
fbmsg.Picture = null;
}
try
{
if (result["message_tags"][0] != null)
{
if (result["to"] != null)
{
foreach (var item in result["to"]["data"])
{
if (result["from"] != null)
{
if (item["id"] != profile["id"])
{
if (result["from"]["id"] == profile["id"])
{
fbmsg.Type = "fb_tag";
}
else
{
fbmsg.Type = "fb_home";
}
}
else
{
fbmsg.Type = "fb_home";
}
}
}
}
else
{
fbmsg.Type = "fb_home";
}
}
else
{
fbmsg.Type = "fb_home";
}
}
catch (Exception ex)
{
fbmsg.Type = "fb_home";
Console.WriteLine(ex.StackTrace);
}
fbmsg.ProfileId = profile["id"].ToString();
fbmsg.FbComment = "http://graph.facebook.com/" + result["id"] + "/comments";
fbmsg.FbLike = "http://graph.facebook.com/" + result["id"] + "/likes";
if (lstfbcount < 25)
{
try
{
if (result["message"] != null)
{
message = result["message"];
lstfbcount++;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
try
{
if (result["description"] != null)
{
message = result["description"];
lstfbcount++;
}
}
catch (Exception exx)
{
try
{
Console.WriteLine(exx.StackTrace);
if (result["story"] != null)
{
message = result["story"];
lstfbcount++;
}
}
catch (Exception exxx)
{
Console.WriteLine(exxx.StackTrace);
message = string.Empty;
}
}
}
}
fbmsg.Message = message;
if (!fbmsgrepo.checkFacebookMessageExists(fbmsg.MessageId))
{
fbmsgrepo.addFacebookMessage(fbmsg);
}
}
}
}
