public void ConfigureServices(IServiceCollection services)
{
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
var rssFeedsRepository = new RssFeedsRepository(Configuration["ConnectionString"]);
var rssFeedManager = new RssFeedManager(rssFeedsRepository);
services.AddSingleton(rssFeedManager);
}
public string TwitterComposeMessageRss(string message, string profileid, string userid)
{
string ret = "";
Domain.Socioboard.Domain.TwitterAccount objTwitterAccount = objTwitterAccountRepository.GetUserInformation(Guid.Parse(userid), profileid);
oAuthTwitter OAuthTwt = new oAuthTwitter();
OAuthTwt.AccessToken = objTwitterAccount.OAuthToken;
OAuthTwt.AccessTokenSecret = objTwitterAccount.OAuthSecret;
OAuthTwt.TwitterScreenName = objTwitterAccount.TwitterScreenName;
OAuthTwt.TwitterUserId = objTwitterAccount.TwitterUserId;
this.SetCofigDetailsForTwitter(OAuthTwt);
Tweet twt = new Tweet();
try
{
JArray post = twt.Post_Statuses_Update(OAuthTwt, message);
RssFeedsRepository objrssfeed = new RssFeedsRepository();
objrssfeed.updateFeedStatus(Guid.Parse(userid), message);
return ret = "Messages Posted Successfully";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return ret = "Message Could Not Posted";
}
}
public string FacebookComposeMessageRss(string message, string profileid, string userid, string title, string link)
{
string ret = "";
Domain.Socioboard.Domain.FacebookAccount objFacebookAccount = objFacebookAccountRepository.getFacebookAccountDetailsById(profileid, Guid.Parse(userid));
FacebookClient fb = new FacebookClient();
try
{
fb.AccessToken = objFacebookAccount.AccessToken;
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls;
var args = new Dictionary<string, object>();
args["message"] = message;
args["description"] = title;
args["link"] = link;
ret = fb.Post("v2.0/" + objFacebookAccount.FbUserId + "/feed", args).ToString();
RssFeedsRepository objrssfeed = new RssFeedsRepository();
objrssfeed.updateFeedStatus(Guid.Parse(userid), message);
return ret = "Messages Posted Successfully";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return ret = "Message Could Not Posted";
}
}
public RssFeedManager(RssFeedsRepository feedsRepository)
{
_feedsRepository = feedsRepository ?? throw new ArgumentNullException(nameof(feedsRepository));
}
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);
}
private void NewMethod(User user)
{
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
TeamRepository objTeamRepository = new TeamRepository();
GroupRepository objGroupRepository = new GroupRepository();
RssFeedsRepository rssFeedsRepo = new RssFeedsRepository();
List <RssFeeds> lstrssfeeds = rssFeedsRepo.getAllActiveRssFeeds(user.Id);
TwitterAccountRepository twtAccountRepo = new TwitterAccountRepository();
ArrayList arrTwtAcc = twtAccountRepo.getAllTwitterAccountsOfUser(user.Id);
//===================================================================================================================================
//====================================================================================================================================
if (lstrssfeeds != null)
{
if (lstrssfeeds.Count != 0)
{
//int rssCount = 0;
string rssData = string.Empty;
rssData += "<h2 class=\"league section-ttl rss_header\">Active RSS Feeds</h2>";
foreach (RssFeeds item in lstrssfeeds)
{
TwitterAccount twtAccount = twtAccountRepo.getUserInformation(item.ProfileScreenName, user.Id);
string picurl = string.Empty;
if (string.IsNullOrEmpty(twtAccount.ProfileUrl))
{
picurl = "../Contents/img/blank_img.png";
}
else
{
picurl = twtAccount.ProfileUrl;
}
rssData += " <section id=\"" + item.Id + "\" class=\"publishing\">" +
"<section class=\"twothird\">" +
"<article class=\"quarter\">" +
"<div href=\"#\" class=\"avatar_link view_profile\" title=\"\">" +
"<img title=\"" + item.ProfileScreenName + "\" src=\"" + picurl + "\" data-src=\"\" class=\"avatar sm\">" +
"<article class=\"rss_ava_icon\"><span title=\"Twitter\" class=\"icon twitter_16\"></span></article>" +
"</div>" +
"</article>" +
"<article class=\"threefourth\">" +
"<ul>" +
"<li>" + item.FeedUrl + "</li>" +
"<li>Prefix: </li>" +
"<li class=\"freq\" title=\"New items from this feed will be posted at most once every hour\">Max Frequency: " + item.Duration + "</li>" +
"</ul>" +
"</article>" +
"</section>" +
"<section class=\"third\">" +
"<ul class=\"rss_action_buttons\">" +
"<li onclick=\"pauseFunction('" + item.Id + "');\" class=\"\"><a id=\"pause_" + item.Id + "\" href=\"#\" title=\"Pause\" class=\"small_pause icon pause\"></a></li>" +
"<li onclick=\"deleteRssFunction('" + item.Id + "');\" class=\"show-on-hover\"><a id=\"delete_" + item.Id + "\" href=\"#\" title=\"Delete\" class=\"small_remove icon delete\"></a></li>" +
"</ul>" +
"</section>" +
"</section>";
}
rss.InnerHtml = rssData;
rss.Style.Add("display", "block");
rdata.Style.Add("display", "none");
}
}
try
{
if (Session["IncomingTasks"] != null)
{
//incom_tasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
//incomTasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
}
else
{
TaskRepository taskRepo = new TaskRepository();
ArrayList alst = taskRepo.getAllIncompleteTasksOfUser(user.Id, team.GroupId);
Session["IncomingTasks"] = alst.Count;
}
}
catch (Exception es)
{
logger.Error(es.StackTrace);
Console.WriteLine(es.StackTrace);
}
if (Session["CountMessages"] != null)
{
//incom_messages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
//incomMessages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
}
else
{
//incom_messages.InnerHtml = "0";
//incomMessages.InnerHtml = "0";
}
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
usernm.InnerHtml = "Hello, " + user.UserName + "";
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
usernm.InnerHtml = "Hello, " + user.UserName + "";
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
if (!string.IsNullOrEmpty(user.ProfileUrl))
{
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\"/></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\"/>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
else
{
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
try
{
GroupRepository grouprepo = new GroupRepository();
List <Groups> lstgroups = grouprepo.getAllGroups(user.Id);
string totgroups = string.Empty;
if (lstgroups.Count != 0)
{
foreach (Groups item in lstgroups)
{
totgroups += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\" id=\"group_" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"/>" + item.GroupName + "</a></li>";
}
inviteRedirect.InnerHtml = totgroups;
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
}
public string LinkedinComposeMessageRss(string message, string profileid, string userid)
{
string ret = "";
LinkedInAccount LinkedAccount;
string authLink = string.Empty;
LinkedInAccountRepository linkedinAccRepo = new LinkedInAccountRepository();
if (linkedinAccRepo.checkLinkedinUserExists(profileid, Guid.Parse(userid)))
{
LinkedAccount = linkedinAccRepo.getUserInformation(Guid.Parse(userid), profileid);
}
else
{
LinkedAccount = linkedinAccRepo.getUserInformation(profileid);
}
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = LinkedAccount.OAuthVerifier;
Linkedin_oauth.TokenSecret = LinkedAccount.OAuthSecret;
Linkedin_oauth.Token = LinkedAccount.OAuthToken;
Linkedin_oauth.Id = LinkedAccount.LinkedinUserId;
Linkedin_oauth.FirstName = LinkedAccount.LinkedinUserName;
SocialStream sociostream = new SocialStream();
try
{
ret = sociostream.SetStatusUpdate(Linkedin_oauth, message);
RssFeedsRepository objrssfeed = new RssFeedsRepository();
objrssfeed.updateFeedStatus(Guid.Parse(userid), message);
return ret = "Messages Posted Successfully";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return ret = "Message Could Not Posted";
}
}
