public void ProcessRequest() { SocialProfilesRepository socio = new SocialProfilesRepository(); List<SocialProfile> alstsocioprofiles = new List<SocialProfile>(); if (!string.IsNullOrEmpty(Request.QueryString["op"])) { SocioBoard.Domain.User user = (SocioBoard.Domain.User)Session["LoggedUser"]; if (Request.QueryString["op"] == "social_connectivity") { alstsocioprofiles = socio.getAllSocialProfilesOfUser(user.Id); string profiles = string.Empty; profiles += "<ul class=\"rsidebar-profile\">"; foreach (SocialProfile item in alstsocioprofiles) { try { if (item.ProfileType == "facebook") { try { FacebookAccountRepository facerepo = new FacebookAccountRepository(); FacebookAccount faceaccount = facerepo.getFacebookAccountDetailsById(item.ProfileId, user.Id); if (faceaccount != null) { if (item.ProfileStatus == 2) { profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onclick=\"confirmDel('" + item.ProfileId + "','" + faceaccount.Type + "','fb');\"></div><a href=\"http://www.facebook.com/" + faceaccount.FbUserId + "\" target=\"_blank\"><img src=\"../Contents/img/remove.png\" height=\"48\" width=\"48\" alt=\"\" title=\"Access token expire Please remove your account and add again\" /></a>" + "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/rmeove.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } else { profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onclick=\"confirmDel('" + item.ProfileId + "','" + faceaccount.Type + "','fb');\"></div><a href=\"http://www.facebook.com/" + faceaccount.FbUserId + "\" target=\"_blank\"><img src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" height=\"48\" width=\"48\" alt=\"\" title=\"" + faceaccount.FbUserName + "\" /></a>" + "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/fb_icon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "twitter") { try { TwitterAccountRepository twtrepo = new TwitterAccountRepository(); SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, item.ProfileId); if (twtaccount != null) { profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','twt','twt')\"></div><a href=\"http://twitter.com/" + twtaccount.TwitterScreenName + "\" target=\"_blank\"><img src=\"" + twtaccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + twtaccount.TwitterScreenName + "\" /></a>" + "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/twticon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "linkedin") { try { LinkedInAccountRepository liRepo = new LinkedInAccountRepository(); string access = string.Empty, tokenSecrate = string.Empty, LdprofileName = string.Empty, LdPreofilePic = string.Empty; LinkedInAccount liaccount = liRepo.getUserInformation(user.Id, item.ProfileId); if (liaccount != null) { if (!string.IsNullOrEmpty(liaccount.ProfileImageUrl)) { LdPreofilePic = liaccount.ProfileImageUrl; } else { LdPreofilePic = "../../Contents/img/blank_img.png"; } profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','linkedin')\"></div><a href=\"" + liaccount.ProfileUrl + "\" target=\"_blank\"><img src=\"" + LdPreofilePic + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + liaccount.LinkedinUserName + "\" /></a>" + "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "instagram") { try { InstagramAccountRepository objInsAccRepo = new InstagramAccountRepository(); InstagramAccount objInsAcc = objInsAccRepo.getInstagramAccountDetailsById(item.ProfileId, user.Id); string accessToken = string.Empty; if (objInsAcc != null) { profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','instagram')\"></div><a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><img src=\"" + objInsAcc.ProfileUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objInsAcc.InsUserName + "\" /></a>" + "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/instagram_24X24.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "googleplus") { try { //GooglePlusAccountRepository objgpAccRepo = new GooglePlusAccountRepository(); //GooglePlusAccount objgpAcc = objgpAccRepo.getGooglePlusAccountDetailsById(item.ProfileId, user.Id); //string accessToken = string.Empty; //profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','googleplus')\"></div><a href=\"http://plus.google.com/" + item.ProfileId + "\" target=\"_blank\"><img src=\"" + objgpAcc.GpProfileImage + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objgpAcc.GpUserName + "\" /></a>" + // "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/google_plus.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "googleanalytics") { try { //GoogleAnalyticsAccountRepository objgaAccRepo = new GoogleAnalyticsAccountRepository(); //GoogleAnalyticsAccount objgaAcc = objgaAccRepo.getGoogelAnalyticsAccountHomeDetailsById(user.Id,item.ProfileId); //string accessToken = string.Empty; //profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','googleanalytics')\"></div><a href=\"http://plus.google.com/" + item.ProfileId + "\" target=\"_blank\"><img src=\"../Contents/img/google_analytics.png\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objgaAcc.GaAccountName + "\" /></a>" + // "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>"; } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } } catch (Exception ex) { logger.Error(ex.Message); } } profiles += "</ul>"; Response.Write(profiles); } else if (Request.QueryString["op"] == "woodrafts") { string message = string.Empty; try { DraftsRepository draftsRepository = new DraftsRepository(); List<Drafts> lstDrafts = draftsRepository.getAllDrafts(user.Id); string profurl = string.Empty; if (string.IsNullOrEmpty(user.ProfileUrl)) { profurl = "../Contents/img/blank_img.png"; } else { profurl = user.ProfileUrl; } if (lstDrafts.Count != 0) { foreach (Drafts item in lstDrafts) { try { message += "<section class=\"section\" style=\"width:648px;\">" + "<div class=\"js-task-cont read\"><section class=\"task-owner\">" + "<img width=\"32\" height=\"32\" border=\"0\" class=\"avatar\" src=\"../Contents/img/task_pin.png\">" + "</section><section class=\"task-activity third\" style=\"width: 19.6%;\"><p>" + user.UserName + "</p><div>" + item.CreatedDate + " </div><p>" + //"</p></section><section style=\"margin-right: 6px; height: auto; width: 35%;\" class=\"task-message font-13 third\"><a onclick=\"writemessage(this.innerHTML);\" class=\"tip_left\">" + item.Message + "</a></section>" + "</p></section><section style=\"margin-right: 6px; height: auto; width: 31%;\" class=\"task-message font-13 third\"><span class=\"tip_left\">" + gethtmlfromstring(item.Message) + "</span></section>" + "<div class=\"userpictiny\" style=\"height:70px; margin-top: 0;\"><img alt=\"\" src=\"" + profurl + "\" />" + "</div>" + "<a class=\"small_remove icon publish_delete\" href=\"#\" style=\"top: 7px; float: right; margin-top: 13px; margin-right: 10px;\" title=\"Delete\" onclick=\"deleteDraftMessage('" + item.Id + "')\"></a>" + "<section style=\"margin-top: 18px; width: 45px; margin-right: 17px;\" class=\"task-status\"><div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\" href=\"#nogo\">" + "<span onclick=\"editDraftsMessage('" + item.Id + "','" + item.Message + "');\" class=\"ui-sproutmenu-status\">" + "<img class=\"edit_button\" src=\"../Contents/img/icon_edit.png\" alt=\"\" />" + "</span>" + "</a></div></section></div></section>"; } catch (Exception ex) { logger.Error(ex.Message); } } } else { message += "<div style=\"margin-left: 2%; margin-top: 3%;\">No Messages in Drafts</div>"; } } catch (Exception ex) { logger.Error(ex.Message); } Response.Write(message); } else if (Request.QueryString["op"] == "savedrafts") { try { string message = Request.QueryString["message"]; message = Request.Form["messagee"]; Drafts d = new Drafts(); d.CreatedDate = DateTime.Now; d.Message = message; d.ModifiedDate = DateTime.Now; d.UserId = user.Id; d.Id = Guid.NewGuid(); DraftsRepository dRepo = new DraftsRepository(); if (!dRepo.IsDraftsMessageExist(user.Id, message)) { dRepo.AddDrafts(d); } } catch (Exception ex) { logger.Error(ex.Message); } Response.Write("added successfully"); } else if (Request.QueryString["op"] == "midsnaps") { try { Random rNum = new Random(); string loadtype = Request.QueryString["loadtype"]; string midsnaps = string.Empty; if (loadtype == "load") profilelimit = 0; if (profilelimit != -1) { ArrayList alst = socio.getLimitProfilesOfUser(user.Id, profilelimit); if (alst.Count == 0) profilelimit = -1; else if (profilelimit == 0) //profilelimit += 2; profilelimit += 6; else profilelimit += 6; midsnaps += "<div class=\"row-fluid\" >"; if (loadtype == "load") { AdsRepository objAdsRepo = new AdsRepository(); ArrayList lstads = objAdsRepo.getAdsForHome(); int i = 0; if (lstads.Count <= 1) { if (user.PaymentStatus.ToUpper() == "PAID") { midsnaps += ""; } } else { foreach (var item in lstads) { Array temp = (Array)item; i++; if (temp != null) { if (i == 2) { if (user.AccountType == "Paid") { midsnaps += "<div class=\"span4 rounder recpro\"><button data-dismiss=\"alert\" class=\"close pull-right\" type=\"button\">×</button>" + "<a href=\"#\"><img src=\"" + temp.GetValue(2).ToString() + "\" alt=\"\" style=\"width:246px;height:331px\"></a></div>"; } } } } } } foreach (SocialProfile item in alst) { if (item.ProfileType == "facebook") { try { FacebookAccountRepository fbrepo = new FacebookAccountRepository(); FacebookFeedRepository facefeedrepo = new FacebookFeedRepository(); List<FacebookFeed> fbmsgs = facefeedrepo.getAllFacebookUserFeeds(item.ProfileId); FacebookAccount fbaccount = fbrepo.getFacebookAccountDetailsById(item.ProfileId, user.Id); midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" + "<div onclick=\"detailsdiscoveryfacebook('" + fbaccount.FbUserId + "');\" class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + fbaccount.FbUserName + "\" alt=\"\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\"\">" + "<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/fb_icon.png\" width=\"16\" height=\"16\"></a></div>" + "<div onclick=\"detailsdiscoveryfacebook('" + fbaccount.FbUserId + "');\" class=\"useraccname\">" + getsortpofilename(fbaccount.FbUserName) + "</div><div class=\"usercounter\">" + "<div class=\"userfoll\">" + fbaccount.Friends; if (fbaccount.Type == "page") { midsnaps += "<span><b style=\"font-size: 13px;\">Fans</b></span>"; } else { midsnaps += "<span><b style=\"font-size: 13px;\">Friends</b></span>"; } midsnaps += "</div>" + "<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. Post <br> Per Day</span></div></div><h5>Recent message</h5></div>" + "<div class=\"concoteng\"> <ul class=\"mess\">"; if (fbmsgs.Count != 0) { int msgcount = 0; foreach (FacebookFeed child in fbmsgs) { string mess = string.Empty; if (msgcount < 2) { if (child.FeedDescription.Length > 40) { mess = child.FeedDescription.Substring(0, 39); mess = mess + "..........."; } else { mess = child.FeedDescription; } mess = mess.PadLeft(15); midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"http://graph.facebook.com/" + child.FromId + "/picture?type=small\"></div>" + "<div class=\"messtext\">" + mess + "</div></li>"; } else { break; } msgcount++; } } else { midsnaps += "<strong>No messages were found within the past few days.</strong> \"Messages will be displayed once there is activity in this date range.\""; } midsnaps += "</ul></div></div>"; } catch (Exception ex) { logger.Error(ex.Message); } } if (item.ProfileType == "googleplus") { } else if (item.ProfileType == "twitter") { TwitterAccountRepository twtrepo = new TwitterAccountRepository(); SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, item.ProfileId); TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); List<TwitterMessage> lsttwtmsgs = twtmsgrepo.getAllTwitterMessagesOfProfile(item.ProfileId); int tweetcount = 0; midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" + "<div onclick=\"detailsdiscoverytwitter('" + item.ProfileId + "');\" class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + twtaccount.TwitterScreenName + "\" alt=\"\" src=\"" + twtaccount.ProfileImageUrl + "\">" + "<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/twticon.png\" width=\"16\" height=\"16\"></a></div>" + "<div onclick=\"detailsdiscoverytwitter('" + twtaccount.TwitterScreenName + "');\" class=\"useraccname\">" +getsortpofilename( twtaccount.TwitterScreenName) + "</div><div class=\"usercounter\">" + "<div class=\"userfoll\">" + twtaccount.FollowersCount + "<span><b style=\"font-size: 13px;\">Followers</b></span></div>" + "<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. tweet <br> Per Day</span></div></div><h5>Recent message</h5></div>" + "<div class=\"concoteng\"> <ul class=\"mess\">"; try { if (lsttwtmsgs.Count == 0) { midsnaps += "<strong>No messages were found within the past few days.</strong> \"Messages will be displayed once there is activity in this date range.\""; } else { foreach (TwitterMessage msg in lsttwtmsgs) { if (tweetcount < 2) { try { string ms = string.Empty; if (msg.TwitterMsg.Length > 20) { ms = msg.TwitterMsg.Substring(0, 20) + "..."; } else { ms = msg.TwitterMsg; } ms = ms.PadLeft(15); midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"" + msg.FromProfileUrl + "\"></div>" + "<div class=\"messtext\">" + ms + "</div></li>"; } catch (Exception ex) { Console.WriteLine(ex.Message); } } else { break; } tweetcount++; } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } midsnaps += "</ul></div></div>"; } else if (item.ProfileType == "linkedin") { try { string access = string.Empty, tokenSecrate = string.Empty, LdprofileName = string.Empty, LdPreofilePic = string.Empty; LinkedInAccountRepository objLiRepo = new LinkedInAccountRepository(); LinkedInFeedRepository objliFeedRepo = new LinkedInFeedRepository(); LinkedInAccount liAccount = objLiRepo.getUserInformation(user.Id, item.ProfileId); LinkedInFeedRepository lifeedrepo = new LinkedInFeedRepository(); List<LinkedInFeed> alstliaccount = lifeedrepo.getAllLinkedInFeedsOfProfile(item.ProfileId); if (liAccount != null) { LdprofileName = liAccount.LinkedinUserName; LdPreofilePic = liAccount.ProfileImageUrl; } if (string.IsNullOrEmpty(LdPreofilePic)) { LdPreofilePic = "../../Contents/img/blank_img.png"; } int linkedinConcount = 0; try { linkedinConcount = liAccount.Connections; } catch (Exception ex) { Console.WriteLine(ex.Message); } midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" + "<div class=\"userpictiny\"><a target=\"_blank\" href=\"" + liAccount.ProfileUrl + "\"><img width=\"56\" height=\"56\" title=\"" + LdprofileName + "\" alt=\"\" src=\"" + LdPreofilePic + "\"></a>" + "<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\"></a></div>" + "<div class=\"useraccname\">" +getsortpofilename(LdprofileName) + "</div><div class=\"usercounter\">" + "<div class=\"userfoll\">" + linkedinConcount + "<span>Connections</span></div>" + "<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. Post <br> Per Day</span></div></div><h5>Recent message</h5></div>" + "<div class=\"concoteng\"> <ul class=\"mess\">"; int link = 0; if (alstliaccount.Count == 0) { midsnaps += "<strong>No messages were found within the past 14 days.</strong> \"Messages will be displayed once there is activity in this date range.\""; } else { try { foreach (LinkedInFeed liFeed in alstliaccount) { try { if (link < 2) { string ms = string.Empty; if (liFeed.Feeds.Length > 20) { ms = liFeed.Feeds.Substring(0, 20) + "..."; } else { ms = liFeed.Feeds; } ms = ms.PadLeft(15); midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"" + liFeed.FromPicUrl + "\"></div>" + "<div class=\"messtext\">" + ms + "</div></li>"; link++; } else { break; } } catch (Exception ex) { logger.Error(ex.Message); } } } catch (Exception ex) { logger.Error(ex.Message); } } midsnaps += "</ul></div></div>"; } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "instagram") { try { InstagramAccountRepository objInsAccRepo = new InstagramAccountRepository(); InstagramAccount objInsAcc = objInsAccRepo.getInstagramAccountDetailsById(item.ProfileId, user.Id); midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" + "<a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><div class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + objInsAcc.InsUserName + "\" alt=\"\" src=\"" + objInsAcc.ProfileUrl + "\"></a>" + "<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/instagram_24X24.png\" width=\"16\" height=\"16\"></a></div>" + "<a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><div class=\"useraccname\">" + getsortpofilename(objInsAcc.InsUserName) + "</div></a></div>" + "<div class=\"concoteng\"><div class=\"pillow_fade\">" + " <div class=\"fb_notifications\">" + "<ul class=\"user-stats\"> " + "<li><div class=\"photo_stat\"> photos</div> <div class=\"number-stat\">" + objInsAcc.TotalImages + "</div></li>" + "<li><div class=\"photo_stat\">following</div><div class=\"number-stat\">" + objInsAcc.Followers + "</div></li>" + "<li><div class=\"photo_stat\">followers</div><div class=\"number-stat\">" + objInsAcc.FollowedBy + "</div></li>" + "</ul></div></div></div></div>"; } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (item.ProfileType == "googleanalytics") { } } midsnaps += "</div>"; Response.Write(midsnaps); } } catch (Exception ex) { logger.Error(ex.Message); } } else if (Request.QueryString["op"] == "accountdelete") { Session["facebooktotalprofiles"] = null; SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository(); string Profiletype = Request.QueryString["profile"]; string profileid = Request.QueryString["profileid"]; if (Profiletype == "fb") { try { FacebookAccountRepository fbrepo = new FacebookAccountRepository(); int delacc = fbrepo.deleteFacebookUser(profileid, user.Id); if (delacc > 0) { socioprofilerepo.deleteProfile(user.Id, profileid); List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid); if (lstsocioprofile.Count >= 0) { FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository(); fbmsgrepo.deleteAllMessagesOfUser(profileid, user.Id); FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository(); fbfeedrepo.deleteAllFeedsOfUser(profileid, user.Id); FacebookStatsRepository fbstatsrepo = new FacebookStatsRepository(); fbstatsrepo.deleteFacebookStats(profileid, user.Id); FacebookInsightStatsRepository fbInsightStats = new FacebookInsightStatsRepository(); fbInsightStats.deleteFacebookInsightStats(profileid, user.Id); } else { FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository(); fbmsgrepo.deleteAllMessagesOfUser(profileid, user.Id); FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository(); fbfeedrepo.deleteAllFeedsOfUser(profileid, user.Id); FacebookStatsRepository fbstatsrepo = new FacebookStatsRepository(); fbstatsrepo.deleteFacebookStats(profileid, user.Id); FacebookInsightStatsRepository fbInsightStats = new FacebookInsightStatsRepository(); fbInsightStats.deleteFacebookInsightStats(profileid, user.Id); } } } catch (Exception exx) { Console.WriteLine(exx.Message); logger.Error(exx.Message); } } else if (Profiletype == "twt") { try { TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository(); int deltwtacc = twtaccountrepo.deleteTwitterUser(user.Id, profileid); if (deltwtacc > 0) { socioprofilerepo.deleteProfile(user.Id, profileid); List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid); if (lstsocioprofile.Count >= 0) { TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); int d = twtmsgrepo.deleteTwitterMessage(profileid, user.Id); TwitterFeedRepository twtfeedrepo = new TwitterFeedRepository(); int s = twtfeedrepo.deleteTwitterFeed(profileid, user.Id); TwitterStatsRepository twtstatsrepo = new TwitterStatsRepository(); int a = twtstatsrepo.deleteTwitterStats(user.Id, profileid); TwitterDirectMessageRepository twtdirectmsgrepo = new TwitterDirectMessageRepository(); int f = twtdirectmsgrepo.deleteDirectMessage(user.Id, profileid); } } } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); } } else if (Profiletype == "linkedin") { try { LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository(); int dellinacc = linkedaccrepo.deleteLinkedinUser(profileid, user.Id); if (dellinacc > 0) { socioprofilerepo.deleteProfile(user.Id, profileid); List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid); if (lstsocioprofile.Count >= 0) { LinkedInFeedRepository linkedfeedrepo = new LinkedInFeedRepository(); int s = linkedfeedrepo.deleteAllFeedsOfUser(profileid, user.Id); } } } catch (Exception ex) { logger.Error(ex.Message); } } else if (Profiletype == "instagram") { try { InstagramAccountRepository insaccrepo = new InstagramAccountRepository(); int insacc = insaccrepo.deleteInstagramUser(profileid, user.Id); if (insacc > 0) { socioprofilerepo.deleteProfile(user.Id, profileid); List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid); if (lstsocioprofile.Count >= 0) { } } } catch (Exception ex) { logger.Error(ex.Message); } } else if (Profiletype == "googleplus") { try { GooglePlusAccountRepository googleplusaccrepo = new GooglePlusAccountRepository(); int gplusacc = googleplusaccrepo.deleteGooglePlusUser(profileid, user.Id); if (gplusacc > 0) { socioprofilerepo.deleteProfile(user.Id, profileid); List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid); if (lstsocioprofile.Count >= 0) { } } } catch (Exception ex) { logger.Error(ex.Message); } } string profiles = string.Empty; profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">"; /*facebook users binding*/ FacebookAccountRepository fbprepo = new FacebookAccountRepository(); ArrayList lstfbaccounts = fbprepo.getFacebookAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>"; if (lstfbaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (FacebookAccount fbacc in lstfbaccounts) { profiles += "<li id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>"; } } profiles += "</ul> </div>"; /*twitter users binding*/ TwitterAccountRepository twtpaccountrepo = new TwitterAccountRepository(); ArrayList alsttwtaccounts = twtpaccountrepo.getAllTwitterAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>"; if (alsttwtaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (SocioBoard.Domain.TwitterAccount item in alsttwtaccounts) { profiles += "<li id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>"; } } profiles += "</ul> </div>"; /*linkedinuserbinding*/ LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository(); ArrayList alstlinkacc = linkaccountrepo.getAllLinkedinAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>"; if (alstlinkacc.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (LinkedInAccount item in alstlinkacc) { string profileurl = string.Empty; if (!string.IsNullOrEmpty(item.ProfileImageUrl)) { profileurl = item.ProfileImageUrl; } else { profileurl = "../../Contents/img/blank_img.png"; } profiles += "<li id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>"; } } profiles += "</ul> </div>"; Response.Write(RemainingAccount(user)); } else if (Request.QueryString["op"] == "MasterCompose") { string profiles = string.Empty; if (Session["profilesforcomposemessage"] == null) { profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">"; /*facebook users binding*/ FacebookAccountRepository fbrepo = new FacebookAccountRepository(); ArrayList lstfbaccounts = fbrepo.getFacebookAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>"; if (lstfbaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (FacebookAccount fbacc in lstfbaccounts) { if (fbacc.IsActive != 2) { profiles += "<li nwtk='fb' class=\"getAllNetworkProfile\" id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>"; } } } profiles += "</ul> </div>"; /*twitter users binding*/ TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository(); ArrayList alsttwtaccounts = twtaccountrepo.getAllTwitterAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>"; if (alsttwtaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (SocioBoard.Domain.TwitterAccount item in alsttwtaccounts) { profiles += "<li nwtk='twt' class=\"getAllNetworkProfile\" id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>"; } } profiles += "</ul> </div>"; /*linkedinuserbinding*/ LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository(); ArrayList alstlinkacc = linkaccountrepo.getAllLinkedinAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>"; if (alstlinkacc.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (LinkedInAccount item in alstlinkacc) { string profileurl = string.Empty; if (!string.IsNullOrEmpty(item.ProfileImageUrl)) { profileurl = item.ProfileImageUrl; } else { profileurl = "../../Contents/img/blank_img.png"; } profiles += "<li nwtk='lin' class=\"getAllNetworkProfile\" id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>"; } } profiles += "</ul> </div>"; Session["profilesforcomposemessage"] = profiles; } else { profiles = (string)Session["profilesforcomposemessage"]; } Response.Write(profiles); } else if (Request.QueryString["op"] == "MasterComposesc") { string profiles = string.Empty; if (Session["profilesforcomposemessage"] == null) { profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">"; /*facebook users binding*/ FacebookAccountRepository fbrepo = new FacebookAccountRepository(); ArrayList lstfbaccounts = fbrepo.getFacebookAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>"; if (lstfbaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (FacebookAccount fbacc in lstfbaccounts) { profiles += "<li nwtk='fb' class=\"getAllNetworkProfile\" id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>"; } } profiles += "</ul> </div>"; /*twitter users binding*/ TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository(); ArrayList alsttwtaccounts = twtaccountrepo.getAllTwitterAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>"; if (alsttwtaccounts.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (SocioBoard.Domain.TwitterAccount item in alsttwtaccounts) { profiles += "<li nwtk='twt' class=\"getAllNetworkProfile\" id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>"; } } profiles += "</ul> </div>"; /*linkedinuserbinding*/ LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository(); ArrayList alstlinkacc = linkaccountrepo.getAllLinkedinAccountsOfUser(user.Id); profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>"; if (alstlinkacc.Count == 0) { profiles += "<li>No Records Found</li>"; } else { foreach (LinkedInAccount item in alstlinkacc) { string profileurl = string.Empty; if (!string.IsNullOrEmpty(item.ProfileImageUrl)) { profileurl = item.ProfileImageUrl; } else { profileurl = "../../Contents/img/blank_img.png"; } profiles += "<li nwtk='lin' class=\"getAllNetworkProfile\" id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>"; } } profiles += "</ul> </div>"; Session["profilesforcomposemessage"] = profiles; } else { profiles = (string)Session["profilesforcomposemessage"]; } Response.Write(profiles); } else if (Request.QueryString["op"] == "sendmessage") { string messagecount = string.Empty; string message = Request.QueryString["message"]; //message = Request.Form["massagee"]; var userid = Request.QueryString["userid[]"].Split(','); //var userid = Request.Form["userid[]"].Split(','); var files = Request.Files.Count; var fi = Request.Files["file"]; string file = string.Empty; try { if (Request.Files.Count > 0) { if (fi != null) { var path = Server.MapPath("~/Contents/img/upload"); file = path + "/" + fi.FileName; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } fi.SaveAs(file); } } } catch (Exception ex) { logger.Error(ex.Message); } foreach (var item in userid) { string[] networkingwithid = item.Split('_'); if (networkingwithid[0] == "fb") { try { FacebookAccountRepository fbaccountrepo = new FacebookAccountRepository(); FacebookAccount fbaccount = fbaccountrepo.getFacebookAccountDetailsById(networkingwithid[1], user.Id); var args = new Dictionary<string, object>(); args["message"] = message; // args["message"] = "Abhay"+i.ToString(); if (Request.Files.Count > 0) { string strPathAndQuery = HttpContext.Current.Request.Url.PathAndQuery; string strUrl = HttpContext.Current.Request.Url.AbsoluteUri.Replace(strPathAndQuery, "/"); string filepath = strUrl + "/Contents/img/upload/" + fi.FileName; args["picture"] = filepath; } FacebookClient fc = new FacebookClient(fbaccount.AccessToken); string facebookpost = string.Empty; if (fbaccount.Type == "page") { facebookpost = fc.Post("/" + fbaccount.FbUserId + "/feed", args).ToString(); } else { facebookpost = fc.Post("/me/feed", args).ToString(); } if (facebookpost.ToString() != string.Empty) { Response.Write("Succesfully posted"); } else { Response.Write("Not posted"); } } catch (Exception ex) { FacebookAccount objFacebookAccount = new FacebookAccount(); FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository(); objFacebookAccount.FbUserId=networkingwithid[1]; objFacebookAccount.UserId=user.Id; objFacebookAccount.IsActive=2; objFacebookAccountRepository.updateFacebookUserStatus(objFacebookAccount); SocialProfile objSocialProfile = new SocialProfile(); SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository(); logger.Error(ex.Message); string errormsg =ex.Message; if(errormsg.Contains("access token")) { objSocialProfile.UserId = user.Id; objSocialProfile.ProfileId = networkingwithid[1]; objSocialProfile.ProfileStatus = 2; objSocialProfilesRepository.updateSocialProfileStatus(objSocialProfile); Response.Write(ex.Message); } Console.WriteLine(ex.Message); } } else if (networkingwithid[0] == "twt") { try { TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository(); SocioBoard.Domain.TwitterAccount twtaccount = twtaccountrepo.getUserInformation(user.Id, networkingwithid[1]); TwitterHelper twthelper = new TwitterHelper(); oAuthTwitter OAuthTwt = new oAuthTwitter(); OAuthTwt.AccessToken = twtaccount.OAuthToken; OAuthTwt.AccessTokenSecret = twtaccount.OAuthSecret; OAuthTwt.TwitterScreenName = twtaccount.TwitterScreenName; OAuthTwt.TwitterUserId = twtaccount.TwitterUserId; twthelper.SetCofigDetailsForTwitter(OAuthTwt); #region For Testing // For Testing //OAuthTwt.ConsumerKey = "udiFfPxtCcwXWl05wTgx6w"; //OAuthTwt.ConsumerKeySecret = "jutnq6N32Rb7cgbDSgfsrUVgRQKMbUB34yuvAfCqTI"; //OAuthTwt.AccessToken = "1453351098-Lz4H7cHKp26pXarF6l9zEwdiHDnwH7D0H4zteH3"; //OAuthTwt.AccessTokenSecret = "dGBPxR9wxhQMioIcj5P4Wemxo5EZIZ8wlvDz7i39lSNFg"; //OAuthTwt.TwitterScreenName = ""; //OAuthTwt.TwitterUserId = ""; #endregion Tweet twt = new Tweet(); if (Request.Files.Count > 0) { PhotoUpload ph = new PhotoUpload(); //ph.Tweet(file, message, OAuthTwt); string res = string.Empty; ph.NewTweet(file, message, OAuthTwt, ref res); // for testing Response.Write(res); Console.WriteLine(res); } else { JArray post = twt.Post_Statuses_Update(OAuthTwt, message); } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } else if (networkingwithid[0] == "lin") { try { LinkedInAccountRepository linkedinaccrepo = new LinkedInAccountRepository(); LinkedInAccount linkedaccount = linkedinaccrepo.getUserInformation(user.Id, networkingwithid[1]); 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(); string res = sociostream.SetStatusUpdate(Linkedin_oauth, message); } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } } string profiletype=""; if(networkingwithid[0] == "fb") { profiletype="facebook"; } else if(networkingwithid[0] == "twt") { profiletype="twitter"; } else if(networkingwithid[0] == "lin") { profiletype="linkedin"; } ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository(); ScheduledMessage objScheduledMessage = new ScheduledMessage(); objScheduledMessage.ShareMessage = message; objScheduledMessage.ClientTime = DateTime.Now; objScheduledMessage.ScheduleTime = DateTime.Now; objScheduledMessage.CreateTime = DateTime.Now; objScheduledMessage.Status = true; objScheduledMessage.UserId = user.Id; objScheduledMessage.ProfileType = profiletype; objScheduledMessage.ProfileId = networkingwithid[1]; objScheduledMessageRepository.addNewMessage(objScheduledMessage); messagecount = objScheduledMessageRepository.getAllSentMessagesOfUser(user.Id).Count().ToString(); } // = objScheduledMessageRepository.getAllSentMessagesOfUser(user.Id).Count().ToString(); Response.Write("~"+messagecount); } else if (Request.QueryString["op"] == "wooqueue_messages") { ScheduledMessageRepository schmsgrepo = new ScheduledMessageRepository(); } else if (Request.QueryString["op"] == "schedulemessage") { var userid = Request.QueryString["users[]"].Split(','); var datearr = Request.QueryString["datearr[]"].Split(','); string message = Request.QueryString["message"]; message = Request.Form["messagee"]; ScheduledMessageRepository schmsgrepo = new ScheduledMessageRepository(); string time = Request.QueryString["time"]; string clienttime = Request.QueryString["clittime"]; foreach (var item in userid) { if (!string.IsNullOrEmpty(item.ToString())) { foreach (var child in datearr) { ScheduledMessage schmessage = new ScheduledMessage(); string[] networkingwithid = item.Split('_'); if (networkingwithid[0] == "fbscheduler") { schmessage.CreateTime = DateTime.Now; schmessage.ProfileType = "facebook"; schmessage.ProfileId = networkingwithid[1]; schmessage.Id = Guid.NewGuid(); schmessage.PicUrl = string.Empty; schmessage.ClientTime = Convert.ToDateTime(clienttime); string servertime = this.CompareDateWithclient(clienttime, child + " " + time); schmessage.ScheduleTime = Convert.ToDateTime(servertime); schmessage.ShareMessage = message; schmessage.UserId = user.Id; schmessage.Status = false; } else if (networkingwithid[0] == "twtscheduler") { schmessage.CreateTime = DateTime.Now; schmessage.ProfileType = "twitter"; schmessage.ProfileId = networkingwithid[1]; schmessage.Id = Guid.NewGuid(); schmessage.PicUrl = string.Empty; schmessage.ClientTime = Convert.ToDateTime(clienttime); string servertime = this.CompareDateWithServer(clienttime, child + " " + time); schmessage.ScheduleTime = Convert.ToDateTime(servertime); schmessage.ShareMessage = message; schmessage.UserId = user.Id; schmessage.Status = false; } else if (networkingwithid[0] == "linscheduler") { schmessage.ClientTime = Convert.ToDateTime(clienttime); schmessage.CreateTime = DateTime.Now; schmessage.ProfileType = "linkedin"; schmessage.ProfileId = networkingwithid[1]; schmessage.Id = Guid.NewGuid(); schmessage.PicUrl = string.Empty; string servertime = this.CompareDateWithServer(clienttime, child + " " + time); schmessage.ScheduleTime = Convert.ToDateTime(servertime); schmessage.ShareMessage = message; schmessage.UserId = user.Id; schmessage.Status = false; } if (!string.IsNullOrEmpty(message)) { if (!schmsgrepo.checkMessageExistsAtTime(user.Id, schmessage.ShareMessage, schmessage.ScheduleTime, schmessage.ProfileId)) { schmsgrepo.addNewMessage(schmessage); } } } } } } else if (Request.QueryString["op"] == "insight") { string check = ""; FacebookAccount objFacebookAccount = (FacebookAccount)Session["fbpagedetail"]; FacebookHelper objFbHelper = new FacebookHelper(); SocialProfile socioprofile = new SocialProfile(); SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository(); FacebookAccountRepository fbrepo = new FacebookAccountRepository(); FacebookClient fbClient = new FacebookClient(objFacebookAccount.AccessToken); int fancountPage = 0; dynamic fancount = fbClient.Get("fql", new { q = " SELECT fan_count FROM page WHERE page_id =" + Request["id"].ToString() }); foreach (var friend in fancount.data) { fancountPage = Convert.ToInt32(friend.fan_count); } objFacebookAccount.Friends = Convert.ToInt32(fancountPage); objFacebookAccount.FbUserId = Request["id"].ToString(); objFacebookAccount.FbUserName = Request["name"].ToString(); objFacebookAccount.Type = "page"; objFacebookAccount.UserId = user.Id; socioprofile.Id = Guid.NewGuid(); socioprofile.ProfileDate = DateTime.Now; socioprofile.ProfileId = Request["id"].ToString(); socioprofile.ProfileStatus = 1; socioprofile.ProfileType = "facebook"; socioprofile.UserId = user.Id; if (!fbrepo.checkFacebookUserExists(objFacebookAccount.FbUserId, user.Id)) { fbrepo.addFacebookUser(objFacebookAccount); if (!socioprofilerepo.checkUserProfileExist(socioprofile)) { socioprofilerepo.addNewProfileForUser(socioprofile); } else { socioprofilerepo.updateSocialProfile(socioprofile); } } else { check = "exist"; Session["alreadypageexist"] = objFacebookAccount; fbrepo.updateFacebookUser(objFacebookAccount); if (!socioprofilerepo.checkUserProfileExist(socioprofile)) { socioprofilerepo.addNewProfileForUser(socioprofile); } else { socioprofilerepo.updateSocialProfile(socioprofile); } Response.Write("<script>alert(\"This Page is Already Added please add another Page!\");</script>"); } //get facebookpagefeeds fbClient = new FacebookClient(objFacebookAccount.AccessToken); FacebookHelper fbhelper = new FacebookHelper(); FacebookInsightStatsHelper fbiHelper = new FacebookInsightStatsHelper(); var feeds = fbClient.Get("/" + Request["id"].ToString() + "/feed"); fbiHelper.getPageImpresion(Request["id"].ToString(), user.Id, 15); fbiHelper.getFanPageLikesByGenderAge(Request["id"].ToString(), user.Id, 15); fbiHelper.getLocation(Request["id"].ToString(), user.Id, 15); // fbiHelper.getFanPost("459630637383010", user.Id, 10); dynamic profile = fbClient.Get(Request["id"].ToString()); fbhelper.getFacebookUserFeeds(feeds, profile); //end facebookpagefeeds Session["fbSocial"] = null; Response.Write(RemainingAccount(user)); } else if (Request.QueryString["op"] == "countmessages") { try { int val = 0; /*facebook*/ FacebookAccountRepository fbAccoutsRepo = new FacebookAccountRepository(); ArrayList lstfacebookAccounts = fbAccoutsRepo.getAllFacebookAccountsOfUser(user.Id); foreach (FacebookAccount item in lstfacebookAccounts) { try { FacebookClient fb = new FacebookClient(item.AccessToken); dynamic unreadcount = fb.Get("fql", new { q = "SELECT unread_count FROM mailbox_folder WHERE folder_id = 0 AND viewer_id = " + item.FbUserId + "" }); foreach (var chile in unreadcount.data) { var count = chile.unread_count; int countable = Convert.ToInt32(count.ToString()); val = val + countable; } } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); } } /*Twitter*/ Session["CountMessages"] = val; Response.Write(val); } catch (Exception ex) { Console.WriteLine(ex.Message); } } else if (Request.QueryString["op"] == "recentfollowers") { string recentfollowers = string.Empty; #region RecentFollowers Users twtUsers = new Users(); TwitterAccountRepository twtAccRepo = new TwitterAccountRepository(); ArrayList lstAccRepo = twtAccRepo.getAllTwitterAccountsOfUser(user.Id); oAuthTwitter oauth = null; foreach (TwitterAccount itemTwt in lstAccRepo) { oauth = new oAuthTwitter(); oauth.AccessToken = itemTwt.OAuthToken; oauth.AccessTokenSecret = itemTwt.OAuthSecret; oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"]; oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"]; oauth.TwitterScreenName = itemTwt.TwitterScreenName; oauth.TwitterUserId = itemTwt.TwitterUserId; JArray jarresponse = twtUsers.Get_Followers_ById(oauth, itemTwt.TwitterUserId); foreach (var item in jarresponse) { int resposecount = 0; if (item["ids"] != null) { foreach (var child in item["ids"]) { if (resposecount < 2) { JArray userprofile = twtUsers.Get_Users_LookUp(oauth, child.ToString()); foreach (var items in userprofile) { resposecount++; try { recentfollowers += "<li><a href=\"https://twitter.com/" + items["screen_name"] + "\" target=\"_blank\"><img style=\"border:3px solid #FCFCFC;\" title=\"" + items["name"] + "\" width=\"48\" height=\"48\" alt=\"\" src=\"" + items["profile_image_url"] + "\"></a></li>"; } catch (Exception ex) { Console.WriteLine(ex.Message); } } } } } } } Response.Write(recentfollowers); #endregion } else if (Request.QueryString["op"] == "removefollowers") { string removeid = Request.QueryString["removeid"]; string userid = Request.QueryString["userid"]; Friendship friendship = new Friendship(); oAuthTwitter oauth = new oAuthTwitter(); TwitterAccountRepository twtaccrepo = new TwitterAccountRepository(); TwitterAccount twtAccount = twtaccrepo.getUserInformation(user.Id, userid); oauth.TwitterUserId = twtAccount.TwitterUserId; oauth.TwitterScreenName = twtAccount.TwitterScreenName; oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"]; oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"]; oauth.AccessToken = twtAccount.OAuthToken; oauth.AccessTokenSecret = twtAccount.OAuthSecret; JArray responseremove = friendship.Post_Friendship_Destroy(oauth, removeid); } //for Deleting socialqueue Message else if (Request.QueryString["op"] == "deletequeuemsg") { try { string res = string.Empty; string messageId = Request.QueryString["messageid"].ToString(); Guid userid = user.Id; ScheduledMessageRepository obj = new ScheduledMessageRepository(); bool check = obj.deleteScheduleMessage(userid, messageId); if (check == true) { res = "success"; } else { } } catch (Exception ex) { logger.Error(ex.Message); } } //for Editing socialqueue Message else if (Request.QueryString["op"] == "Editqueuemsg") { try { string messageId = Request.QueryString["messageid"].ToString(); string newstr = Request.QueryString["newstr"]; Guid userid = user.Id; DateTime dt = DateTime.Now; ScheduledMessageRepository obj = new ScheduledMessageRepository(); obj.UpdateScheduleMessage(userid, messageId, newstr, dt); } catch (Exception ex) { logger.Error(ex.Message); } } else if (Request.QueryString["op"] == "wooqueuemessages") { ScheduledMessageRepository schmsgRepo = new ScheduledMessageRepository(); List<ScheduledMessage> lstschMsg = schmsgRepo.getAllMessagesOfUser(user.Id); string schmessages = string.Empty; string profurl = string.Empty; if (string.IsNullOrEmpty(user.ProfileUrl)) { profurl = "../Contents/img/blank_img.png"; } else { // profurl = "../Contents/img/blank_img.png"; profurl = user.ProfileUrl; } if (lstschMsg.Count != 0) { foreach (ScheduledMessage item in lstschMsg) try { { schmessages += "<section class=\"section\"><div class=\"js-task-cont read\">" + "<section class=\"task-owner\">" + "<img width=\"32\" height=\"32\" border=\"0\" src=\"" + profurl + "\" class=\"avatar\">" + "</section>" + "<section class=\"task-activity third\">" + "<p>" + user.UserName + "</p>" + "<div>" + CompareDateWithServerNew(item.ClientTime, item.CreateTime, item.ScheduleTime) + "</div>" + "<input type=\"hidden\" value=\"#\" id=\"hdntaskid_1\">" + "<p></p>" + "</section>" + "<section class=\"task-message font-13 third\" style=\"height: auto; width: 20%; margin-right: 9px;\"><a id=\"edit_" + item.Id + "\" onclick=\"Editqueue('" + item.Id + "','" + item.ShareMessage + "','" + item.ProfileType + "');\" class=\"tip_left\">" + gethtmlfromstring(item.ShareMessage) + "</a></section>"; if (item.ProfileType == "facebook") { schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" + "<img width=\"48\" height=\"48\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" alt=\"\">" + "<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" + "<img alt=\"\" src=\"../Contents/img/facebook.png\" style=\"height: 16px;width: 16x;\"></a></div>"; } else if (item.ProfileType == "twitter") { TwitterAccountRepository twtAccRepo = new TwitterAccountRepository(); TwitterAccount twtAccount = twtAccRepo.getUserInformation(user.Id, item.ProfileId); if (twtAccount != null) { schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" + "<img width=\"48\" height=\"48\" src=\"" + twtAccount.ProfileImageUrl + "\" alt=\"\">" + "<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" + "<img alt=\"\" src=\"../Contents/img/twitter.png\" style=\"height: 16px;width: 16x;\"></a></div>"; } } else if (item.ProfileType == "linkedin") { LinkedInAccountRepository linkAccRepo = new LinkedInAccountRepository(); LinkedInAccount linkedAccount = linkAccRepo.getUserInformation(user.Id, item.ProfileId); if (linkedAccount != null) { schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" + "<img width=\"48\" height=\"48\" src=\"" + linkedAccount.ProfileImageUrl + "\" alt=\"\">" + "<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" + "<img alt=\"\" src=\"../Contents/img/link.png\" style=\"height: 16px;width: 16x;\"></a></div>"; } } string status = (item.Status == true) ? "Completed" : "Pending"; schmessages += "<section class=\"task-status\" style=\"width:34px;\"><div class=\"ui_light floating task_status_change\">" + //"<a href=\"#nogo\" class=\"ui-sproutmenu\"><span class=\"ui-sproutmenu-status\"><img title=\"Edit Status\" onclick=\"PerformClick(this.id)\" src=\"../Contents/img/icon_edit.png\" class=\"edit_button\" id=\"img_" + item.Id + "_" + item.Status + "\"></span></a></div></section>" + "<a class=\"ui-sproutmenu\"><span class=\"ui-sproutmenu-status\"><img title=\"Edit Status\" onclick=\"PerformClick(this.id)\" src=\"../Contents/img/icon_edit.png\" class=\"edit_button\" id=\"img_" + item.Id + "_" + item.Status + "\"></span></a></div></section>" + "<section class=\"task-status\" style=\"width: 150px; margin-right: 45px;\">" + "<div class=\"ui_light floating task_status_change\">" + "<span class=\"ui-sproutmenu-status\">" + status + "</span>" + "</div>" + "</section>" + "<section class=\"task-status\" style=\"width: 65px; margin-right: 39px;\">" + "<div class=\"ui_light floating task_status_change\">" + "<span class=\"ui-sproutmenu-status\"><img title=\"Delete\" onclick=\"deletequeue(this.id)\" style=\"width:33px;cursor:pointer;margin-left:60px;margin-top:-10px;\" img src=\"../Contents/img/deleteimage.png\" img id=\"" + item.Id + "\"></span>" + "</div>" + "</section>" + "</div></section>"; } } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); Response.Write(schmessages); } } else { schmessages = "<section class=\"section\"><div class=\"js-task-cont read\"><section class=\"task-owner\">" + "<img width=\"32\" height=\"32\" border=\"0\" class=\"avatar\" src=\"" + profurl + "\">" + "</section><section class=\"task-activity third\"><p>" + user.UserName + "</p><div></div><p></p></section><section style=\"margin-right: 6px; width: 31%; height: auto;\" class=\"task-message font-13 third\">" + "<a class=\"tip_left\">No Scheduled Messages</a></section><section style=\"width:113px;\" class=\"task-status\"><span class=\"ficon task_active\"></span>" + //"<div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\" href=\"#nogo\">" + "<div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\">" + "<span class=\"ui-sproutmenu-status\"></span></a></div></section></div></section>"; } Response.Write(schmessages); } else if (Request.QueryString["op"] == "drafts_messages") { } else if (Request.QueryString["op"] == "updatequeue") { updatequeue(Request.QueryString["id"], Request.QueryString["status"]); } else if (Request.QueryString["op"] == "messagechk") { SocioBoard.Domain.Messages mstable = new SocioBoard.Domain.Messages(); string[] types = Request.QueryString["type[]"].Split(','); DataSet ds = (DataSet)Session["MessageDataTable"]; DataSet dss = DataTableGenerator.CreateDataSetForTable(mstable); DataTable dtt = dss.Tables[0]; DataView dv = new DataView(dtt); AjaxMessage ajxfed = new AjaxMessage(); string message = string.Empty; foreach (var item in types) { try { DataRow[] foundRows = ds.Tables[0].Select("Type = '" + item + "'"); foreach (var child in foundRows) { dtt.ImportRow(child); } } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); } } message = ajxfed.BindData(dtt); Response.Write(message); } } }