public string getSentMsg(string profileId, int days) { string strArray = string.Empty; try { TwitterMessageRepository objtwttatsRepo = new TwitterMessageRepository(); // ArrayList alstTwt = objtwttatsRepo.gettwtFeedsStatsByProfileId(user.Id, profileId,days); ArrayList alstTwt = objtwttatsRepo.gettwtscheduledByProfileId(profileId, days); // strArray = "["; int cnt = 0; if (alstTwt.Count > 0) { for (int i = 0; i < alstTwt.Count; i++) { strArray = strArray + alstTwt[i].ToString(); cnt++; } } if (cnt < 7) { for (int j = 0; j < 7 - cnt; j++) { strArray = strArray + ",0"; } } // strArray += "]"; } catch (Exception Err) { Console.Write(Err.StackTrace); } return(strArray); }
public string GetTwitterMessages(string TwitterId) { TwitterMessageRepository twtMsgRepo = new TwitterMessageRepository(); List <TwitterMessage> lsttwtmsg = twtMsgRepo.getAllTwitterMessagesOfProfile(TwitterId); return(new JavaScriptSerializer().Serialize(lsttwtmsg)); }
public List <TwitterMessage> getTwitterMesssage(Guid userid, string profileid) { TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); List <TwitterMessage> lsttwtmsg = twtmsgrepo.getAllTwitterMessagesOfUser(userid, profileid); return(lsttwtmsg); }
public TwitterContextWrapper(TwitterContext context, ICache cache) { Context = context; Users = new TwitterUserRepository(context, cache); Statuses = new TwitterStatusRepository(context, cache); Friendships = new TwitterFriendshipRepository(context, cache); Streaming = new TwitterStreamingRepository(context, cache); Search = new TwitterSearchRepository(context, cache); Messages = new TwitterMessageRepository(context, cache); Favorites = new TwitterFavoritesRepository(context, cache); }
public string getTwtMention(string profileId, Guid userid, int days) { TwitterMessageRepository objretwt = new TwitterMessageRepository(); string count = string.Empty; try { ArrayList alstTwt = objretwt.getMentionStatsByProfileId(profileId, userid, days); count = alstTwt[0].ToString(); } catch (Exception Err) { Console.Write(Err.StackTrace); } return(count); }
public string GetMentionStatsCountByProfileIdAndUserId(string profileId, Guid userid, int days) { TwitterMessageRepository objretwt = new TwitterMessageRepository(); int count = 0; try { count = objretwt.GetMentionStatsCountByProfileIdAndUserId(userid, profileId, days); } catch (Exception Err) { count = 0; Console.Write(Err.StackTrace); } return(count.ToString()); }
public string MoveTwitterMessagesTOMOngo() { TwitterMessageRepository twtfeedrepo = new TwitterMessageRepository(); string output = string.Empty; bool exit = true; int skip = 0; MongoRepository mongorepo = new MongoRepository("TwitterMessage"); while (exit) { List <Domain.Socioboard.Domain.TwitterMessage> fbmsgs = twtfeedrepo.getAllTwitterMessagesMongo(skip); if (fbmsgs.Count() == 0) { exit = false; } foreach (var item in fbmsgs) { Domain.Socioboard.MongoDomain.TwitterMessage mfbmsg = new Domain.Socioboard.MongoDomain.TwitterMessage(); mfbmsg.Id = MongoDB.Bson.ObjectId.GenerateNewId(); // mfbmsg.EntryDate = item.EntryDate.ToString(); mfbmsg.FromId = item.FromId; mfbmsg.FromName = item.FromName; mfbmsg.FromProfileUrl = item.FromProfileUrl; mfbmsg.FromScreenName = item.FromScreenName; mfbmsg.MessageId = item.MessageId; mfbmsg.InReplyToStatusUserId = item.InReplyToStatusUserId; mfbmsg.MessageDate = item.MessageDate.ToString("yyyy/MM/dd HH:mm:ss"); mfbmsg.IsArchived = item.IsArchived; mfbmsg.ProfileId = item.ProfileId; mfbmsg.Type = item.Type; mfbmsg.ScreenName = item.ScreenName; mfbmsg.SourceUrl = item.SourceUrl; mfbmsg.ReadStatus = mfbmsg.ReadStatus; mfbmsg.ProfileType = item.ProfileType; mfbmsg.TwitterMsg = item.TwitterMsg; mongorepo.Add <Domain.Socioboard.MongoDomain.TwitterMessage>(mfbmsg); } skip = skip + 50; } return(output); }
public void DeleteArchiveMessage(string UserId, string ProfileId, string SocialGroup, string UserName, string MessageId, string Message, string CreatedDateTime, string ImgUrl) { Domain.Socioboard.Domain.ArchiveMessage ApiobjArchiveMessage = new Domain.Socioboard.Domain.ArchiveMessage(); try { if (SocialGroup == "facebook") { FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository(); objFacebookMessageRepository.DeleteFacebookMessagebymessageid(Message, MessageId, Guid.Parse(UserId)); } if (SocialGroup == "twitter") { TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository(); objTwitterMessageRepository.DeleteTwitterMessagebymessageid(Message, MessageId, Guid.Parse(UserId)); } } catch (Exception ex) { Console.Write(ex.StackTrace); } }
public void getTwitterStats(TwitterAccount twitterAccount) { TwitterStatsRepository objTwtstats = new TwitterStatsRepository(); TwitterMessageRepository objTweetMsgRepo = new TwitterMessageRepository(); TwitterStats objStats = new TwitterStats(); Random rNum = new Random(); objStats.Id = Guid.NewGuid(); objStats.TwitterId = twitterAccount.TwitterUserId; objStats.UserId = twitterAccount.UserId; objStats.FollowingCount = twitterAccount.FollowingCount; objStats.FollowerCount = twitterAccount.FollowersCount; objStats.Age1820 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2124 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2534 = rNum.Next(twitterAccount.FollowersCount); objStats.Age3544 = rNum.Next(twitterAccount.FollowersCount); objStats.Age4554 = rNum.Next(twitterAccount.FollowersCount); objStats.Age5564 = rNum.Next(twitterAccount.FollowersCount); objStats.Age65 = rNum.Next(twitterAccount.FollowersCount); int replies = objTweetMsgRepo.getRepliesCount(twitterAccount.UserId, twitterAccount.TwitterUserId); int retweets = objTweetMsgRepo.getRetweetCount(twitterAccount.UserId, twitterAccount.TwitterUserId); if (twitterAccount.FollowersCount != 0) { objStats.Engagement = (replies + retweets) / twitterAccount.FollowersCount; } else { objStats.Engagement = 0; } // objStats.Influence= // objStats.Engagement= objStats.EntryDate = DateTime.Now; if (!objTwtstats.checkTwitterStatsExists(twitterAccount.TwitterUserId, twitterAccount.UserId)) { objTwtstats.addTwitterStats(objStats); } }
public string getTwtMention(string profileId, int days) { TwitterMessageRepository objretwt = new TwitterMessageRepository(); string strArray = string.Empty; string str = string.Empty; try { int cnt = 0; ArrayList alstTwt = objretwt.getMentionStatsByProfileId(profileId, days); if (alstTwt != null) { // strArray = "["; for (int i = 0; i < alstTwt.Count; i++) { strArray = strArray + alstTwt[i].ToString() + ","; cnt++; } } if (cnt < 7) { for (int j = 0; j < 7 - cnt; j++) { //strArray = strArray + "0,"; str += "0,"; } } //strArray = strArray.Substring(0, strArray.Length - 1); strArray = str + strArray; strArray = strArray.Substring(0, strArray.Length - 1); } catch (Exception Err) { Console.Write(Err.StackTrace); } return(strArray); }
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); } }
public string getIncomingMsg(string profileId, int days) { string strArray = string.Empty; try { TwitterMessageRepository objtwttatsRepo = new TwitterMessageRepository(); ArrayList alstTwt = objtwttatsRepo.gettwtMessageStatsByProfileId(profileId, days); string str = string.Empty; // strArray = "["; int cnt = 0; if (alstTwt.Count > 0) { for (int i = 0; i < alstTwt.Count; i++) { strArray = strArray + alstTwt[i].ToString() + ","; cnt++; } } if (cnt < 7) { for (int j = 0; j < 7 - cnt; j++) { str = str + "0,"; } } strArray = str + strArray.Substring(0, strArray.Length - 1); // strArray += "]"; } catch (Exception Err) { Console.Write(Err.StackTrace); } return(strArray); }
public void getUserTweets(oAuthTwitter OAuth, string TwitterScreenName, string TwitterUserId, Guid userId) { try { TwitterUser twtuser = new TwitterUser(); JArray data = twtuser.GetStatuses_User_Timeline(OAuth); TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); TwitterMessage twtmsg = new TwitterMessage(); foreach (var item in data) { twtmsg.UserId = userId; twtmsg.Type = "twt_usertweets"; try { twtmsg.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.ScreenName = TwitterScreenName; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.ProfileId = TwitterUserId; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.MessageDate = SocioBoard.Helper.Extensions.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"')); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.Id = Guid.NewGuid(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } twtmsg.EntryDate = DateTime.Now; try { twtmsg.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (!twtmsgrepo.checkTwitterMessageExists(twtmsg.ProfileId, twtmsg.UserId, twtmsg.MessageId)) { twtmsgrepo.addTwitterMessage(twtmsg); } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }
protected void Page_Load(object sender, EventArgs e) { try { UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository(); UserRepository userrepo = new UserRepository(); Registration regObject = new Registration(); TeamRepository objTeamRepo = new TeamRepository(); NewsRepository objNewsRepo = new NewsRepository(); AdsRepository objAdsRepo = new AdsRepository(); UserActivation objUserActivation = new UserActivation(); UserActivationRepository objUserActivationRepository = new UserActivationRepository(); SocialProfilesRepository objSocioRepo = new SocialProfilesRepository(); GroupRepository objGroupRepository = new GroupRepository(); TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository(); Team team = new Team(); SocioBoard.Domain.User user = (User)Session["LoggedUser"]; try { if (Session["GroupName"] == null) { Groups objGroupDetails = objGroupRepository.getGroupDetail(user.Id); team = objTeamRepo.getAllDetails(objGroupDetails.Id, user.EmailId); Session["GroupName"] = team; } else { team = (SocioBoard.Domain.Team)Session["GroupName"]; } } catch (Exception ex) { logger.Error("Error: " + ex.Message); } Session["facebooktotalprofiles"] = null; if (user.Password == null) { Response.Redirect("/Pricing.aspx"); } #region Days remaining if (Session["days_remaining"] == null) { if (user.PaymentStatus == "unpaid" && user.AccountType != "Free") { int daysremaining = (user.ExpiryDate.Date - DateTime.Now.Date).Days; if (daysremaining < 0) { daysremaining = -1; } Session["days_remaining"] = daysremaining; //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('You are using '" + user.AccountType + "' account only '" + daysremaining + "' days is remaining !');", true); if (daysremaining <= -1) { } else if (daysremaining == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Your trial " + user.AccountType + " account will expire end of the day, please upgrade to paid plan.');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Your trial " + user.AccountType + " account will expire in " + daysremaining + " days, please upgrade to paid plan.');", true); } } } #endregion #region for You can use only 30 days as Unpaid User if (user.PaymentStatus.ToLower() == "unpaid" && user.AccountType != "Free") { if (!SBUtils.IsUserWorkingDaysValid(user.ExpiryDate)) { // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('You can use only 30 days as Unpaid User !');", true); Session["GreaterThan30Days"] = "GreaterThan30Days"; Response.Redirect("/Settings/Billing.aspx"); } } Session["GreaterThan30Days"] = null; #endregion if (!IsPostBack) { try { if (user == null) { Response.Redirect("Default.aspx"); } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.StackTrace); } try { objUserActivation = objUserActivationRepository.GetUserActivationStatus(user.Id.ToString()); } catch (Exception ex) { Session["objUserActivationException"] = "objUserActivationException"; Console.WriteLine(ex.Message); logger.Error(ex.StackTrace); } #region Count Used Accounts try { if (user.AccountType.ToString().ToLower() == AccountType.Deluxe.ToString().ToLower()) { tot_acc = 50; } else if (user.AccountType.ToString().ToLower() == AccountType.Standard.ToString().ToLower()) { tot_acc = 10; } else if (user.AccountType.ToString().ToLower() == AccountType.Premium.ToString().ToLower()) { tot_acc = 20; } else if (user.AccountType.ToString().ToLower() == AccountType.Free.ToString().ToLower()) { tot_acc = 5; } else if (user.AccountType.ToString().ToLower() == AccountType.SocioBasic.ToString().ToLower()) { tot_acc = 100; } else if (user.AccountType.ToString().ToLower() == AccountType.SocioStandard.ToString().ToLower()) { tot_acc = 200; } else if (user.AccountType.ToString().ToLower() == AccountType.SocioPremium.ToString().ToLower()) { tot_acc = 500; } else if (user.AccountType.ToString().ToLower() == AccountType.SocioDeluxe.ToString().ToLower()) { tot_acc = 1000; } profileCount = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count; Session["ProfileCount"] = profileCount; Session["TotalAccount"] = tot_acc; try { Groups lstDetail = objGroupRepository.getGroupName(team.GroupId); if (lstDetail.GroupName == "Socioboard") { usedAccount.InnerHtml = " using " + profileCount + " of " + tot_acc; } } catch (Exception ex) { logger.Error(ex.StackTrace); } } catch (Exception ex) { logger.Error(ex.StackTrace); } #endregion try { Groups lstDetails = objGroupRepository.getGroupName(team.GroupId); if (lstDetails.GroupName != "Socioboard") { expander.Attributes.CssStyle.Add("display", "none"); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } //this is used to check whether facebok account Already Exist if (Session["alreadyexist"] != null) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Profile is Already Added please add aother Account!');", true); Session["alreadyexist"] = null; } if (Session["alreadypageexist"] != null) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Page is Already Added please add aother Page!');", true); Session["alreadypageexist"] = null; } if (!string.IsNullOrEmpty(Request.QueryString["type"])) { try { userrepo.UpdateAccountType(user.Id, Request.QueryString["type"]); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); logger.Error(ex.StackTrace); } } //acrossProfile.InnerHtml = "Across " + user.UserName + "'s Twitter and Facebook accounts"; teamMem.InnerHtml = "managing " + user.UserName; try { News nws = objNewsRepo.getNewsForHome(); //divNews.InnerHtml = nws.NewsDetail; } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } try { ArrayList lstads = objAdsRepo.getAdsForHome(); if (lstads.Count < 1) { if (user.PaymentStatus.ToUpper() == "PAID") { bindads.InnerHtml = "<img src=\"../Contents/img/admin/ads.png\" alt=\"\" >"; } else { #region ADS Script bindads.InnerHtml = "<script async src=\"//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js\"></script>" + "<!-- socioboard -->" + "<ins class=\"adsbygoogle\"" + "style=\"display:inline-block;width:250px;height:250px\"" + "data-ad-client=\"ca-pub-7073257741073458\"" + "data-ad-slot=\"9533254693\"></ins>" + "<script>" + "(adsbygoogle = window.adsbygoogle || []).push({});" + "</script>"; #endregion } } foreach (var item in lstads) { Array temp = (Array)item; //imgAds.ImageUrl = temp.GetValue(2).ToString(); if (user.PaymentStatus.ToUpper() == "PAID") { bindads.InnerHtml = "<img src=\"" + temp.GetValue(2).ToString() + "\" alt=\"\" style=\"width:246px;height:331px\">"; } else { #region ADS Script bindads.InnerHtml = "<script async src=\"//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js\"></script>" + "<!-- socioboard -->" + "<ins class=\"adsbygoogle\"" + "style=\"display:inline-block;width:250px;height:250px\"" + "data-ad-client=\"ca-pub-7073257741073458\"" + "data-ad-slot=\"9533254693\"></ins>" + "<script>" + "(adsbygoogle = window.adsbygoogle || []).push({});" + "</script>"; #endregion } break; // ads.ImageUrl; } } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } #region Team Member Count try { GroupRepository grouprepo = new GroupRepository(); string groupsofhome = string.Empty; List <Groups> lstgroups = grouprepo.getAllGroups(user.Id); if (lstgroups.Count != 0) { foreach (Groups item in lstgroups) { groupsofhome += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"> " + item.GroupName + "</a></li>"; } getAllGroupsOnHome.InnerHtml = groupsofhome; } } catch (Exception ex) { logger.Error(ex.StackTrace); } #endregion try { string strTeam = string.Empty; List <Team> teams = objTeamRepo.getAllTeamsOfUser(user.Id, team.GroupId, user.EmailId); foreach (Team item in teams) { strTeam += "<div class=\"userpictiny\"><a target=\"_blank\" href=\"#\">" + "<img width=\"48\" height=\"48\" title=\"" + item.FirstName + "\" alt=\"\" src=\"../Contents/img/blank_img.png\">" + "</a></div>"; } team_member.InnerHtml = strTeam; } catch (Exception Err) { Console.Write(Err.StackTrace); } #region Add Fan Page try { if (Session["fbSocial"] != null) { if (Session["fbSocial"] == "p") { FacebookAccount objFacebookAccount = (FacebookAccount)Session["fbpagedetail"]; // string strpageUrl = "https://graph.facebook.com/" + objFacebookAccount.FacebookId + "/accounts"; // objFacebookUrlBuilder = (FacebookUrlBuilder)Session["FacebookInsightUser"]; // string strData = objAuthentication.RequestUrl(strpageUrl, objFacebookAccount.Token); // JObject output = objWebRequest.FacebookRequest(strData, "Get"); FacebookClient fb = new FacebookClient(); fb.AccessToken = objFacebookAccount.AccessToken; dynamic output = fb.Get("/me/accounts"); // JArray data = (JArray)output["data"]; DataTable dtFbPage = new DataTable(); dtFbPage.Columns.Add("Email"); dtFbPage.Columns.Add("PageId"); dtFbPage.Columns.Add("PageName"); dtFbPage.Columns.Add("status"); dtFbPage.Columns.Add("customer_id"); string strPageDiv = string.Empty; if (output != null) { foreach (var item in output["data"]) { if (item.category.ToString() != "Application") { strPageDiv += "<div><a id=\"A1\" onclick=\"getInsights('" + item["id"].ToString() + "','" + item["name"].ToString() + "')\"><span>" + item["name"].ToString() + "</span> </a></div>"; fbpage.InnerHtml = strPageDiv; } } } else { strPageDiv += "<div>No Pages Found</div>"; } Page.ClientScript.RegisterStartupScript(Page.GetType(), "my", " ShowDialogHome(false);", true); Session["fbSocial"] = null; } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.StackTrace); } #endregion #region InsightsData try { decimal malecount = 0, femalecount = 0, cnt = 0; FacebookStatsRepository objfbStatsRepo = new FacebookStatsRepository(); double daysSub = (DateTime.Now - user.CreateDate).TotalDays; int userdays; if (daysSub > 0 && daysSub <= 1) { userdays = 1; } else { userdays = (int)daysSub; } ArrayList arrFbStats = objfbStatsRepo.getAllFacebookStatsOfUser(user.Id, userdays); //ArrayList arrFbStats = objfbStatsRepo.getTotalFacebookStatsOfUser(user.Id); Random rNum = new Random(); foreach (var item in arrFbStats) { Array temp = (Array)item; cnt += int.Parse(temp.GetValue(3).ToString()) + int.Parse(temp.GetValue(4).ToString()); malecount += int.Parse(temp.GetValue(3).ToString()); femalecount += int.Parse(temp.GetValue(4).ToString()); } try { decimal mc = (malecount / cnt) * 100; male = Convert.ToInt16(mc); } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } try { decimal fc = (femalecount / cnt) * 100; female = Convert.ToInt16(fc); } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } int twtAccCount = objSocioRepo.getAllSocialProfilesTypeOfUser(user.Id, "twitter").Count; if (twtAccCount > 1) { twtmale = rNum.Next(100); twtfemale = 100 - twtmale; } else if (twtAccCount == 1) { twtmale = 100; twtfemale = 0; } Session["twtGender"] = twtmale + "," + twtfemale; } catch (Exception Err) { Console.Write(Err.Message.ToString()); logger.Error(Err.StackTrace); } //getgrphData(); // getNewFriends(7); // getNewFriends(); // getNewFollowers(); #endregion #region GetFollower try { String TwtProfileId = string.Empty; TwitterStatsRepository objtwtStatsRepo = new TwitterStatsRepository(); List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getTwtTeamMemberProfileData(team.Id); foreach (TeamMemberProfile item in objTeamMemberProfile) { TwtProfileId += item.ProfileId + ','; } TwtProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1); List <TwitterStats> arrTwtStats = objtwtStatsRepo.getAllAccountDetail(TwtProfileId); //strTwtArray = "["; int NewTweet_Count = 0; string TotalFollower = string.Empty; foreach (TwitterStats item in arrTwtStats) { NewTweet_Count += item.FollowerCount; } if (NewTweet_Count >= 100000) { TotalFollower = (System.Math.Round(((float)NewTweet_Count / 1000000), 2)) + "M"; } else if (NewTweet_Count > 1000 && NewTweet_Count < 100000) { TotalFollower = (System.Math.Round(((float)NewTweet_Count / 1000), 2)) + "K"; } else { TotalFollower = NewTweet_Count.ToString(); } spanNewTweets.InnerHtml = TotalFollower; } catch (Exception Err) { Console.Write(Err.Message.ToString()); logger.Error(Err.StackTrace); } #endregion #region GetFacebookFanPage try { String FbProfileId = string.Empty; FacebookStatsRepository objFacebookStatsRepository = new FacebookStatsRepository(); List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getTeamMemberProfileData(team.Id); foreach (TeamMemberProfile item in objTeamMemberProfile) { FbProfileId += item.ProfileId + ','; } FbProfileId = FbProfileId.Substring(0, FbProfileId.Length - 1); List <FacebookStats> arrFbStats = objFacebookStatsRepository.getAllAccountDetail(FbProfileId); //strTwtArray = "["; int NewFbFan_Count = 0; string TotalFriends = string.Empty; foreach (FacebookStats item in arrFbStats) { NewFbFan_Count += item.FanCount; } if (NewFbFan_Count >= 100000) { TotalFriends = (System.Math.Round(((float)NewFbFan_Count / 1000000), 2)) + "M"; } else if (NewFbFan_Count > 1000 && NewFbFan_Count < 100000) { TotalFriends = (System.Math.Round(((float)NewFbFan_Count / 1000), 2)) + "K"; } else { TotalFriends = NewFbFan_Count.ToString(); } spanFbFans.InnerHtml = TotalFriends; } catch (Exception Err) { Console.Write(Err.Message.ToString()); logger.Error(Err.StackTrace); } #endregion #region IncomingMessages try { FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository(); int fbmessagescout = fbFeedRepo.countUnreadMessages(user.Id); TwitterMessageRepository twtMsgRepo = new TwitterMessageRepository(); int twtcount = twtMsgRepo.getCountUnreadMessages(user.Id); Session["CountMessages"] = fbmessagescout + twtcount; } catch (Exception ex) { logger.Error(ex.StackTrace); } #endregion #region NewIncomingMessage try { String FbProfileId = string.Empty; String TwtProfileId = string.Empty; List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id); foreach (TeamMemberProfile item in objTeamMemberProfile) { try { if (item.ProfileType == "facebook") { FbProfileId += item.ProfileId + ','; } else if (item.ProfileType == "twitter") { TwtProfileId += item.ProfileId + ','; } } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } } try { FbProfileId = FbProfileId.Substring(0, FbProfileId.Length - 1); } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } try { TwtProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1); } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository(); List <FacebookFeed> alstfb = objFacebookFeedRepository.getAllFeedDetail(FbProfileId); // FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository(); TwitterMessageRepository objtwttatsRepo = new TwitterMessageRepository(); // List<FacebookMessage> alstfb = objFacebookMessageRepository.getAllMessageDetail(FbProfileId); List <TwitterMessage> alstTwt = objtwttatsRepo.getAlltwtMessages(TwtProfileId); int TotalFbMsgCount = 0; int TotalTwtMsgCount = 0; try { TotalFbMsgCount = alstfb.Count; } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } try { TotalTwtMsgCount = alstTwt.Count; } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } spanIncoming.InnerHtml = (TotalFbMsgCount + TotalTwtMsgCount).ToString(); string profileid = string.Empty; ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository(); foreach (TeamMemberProfile item in objTeamMemberProfile) { profileid += item.ProfileId + ','; } profileid = profileid.Substring(0, profileid.Length - 1); spanSent.InnerHtml = objScheduledMessageRepository.getAllSentMessageDetails(profileid).Count().ToString(); } catch (Exception Err) { Console.Write(Err.StackTrace); logger.Error(Err.StackTrace); } } #endregion } catch (Exception Err) { Console.Write(Err.StackTrace); } }
private void getUserTweets(string UserId, oAuthTwitter OAuth) { #region Add User Tweets try { TwitterUser twtuser =new TwitterUser(); JArray Timeline = twtuser.GetStatuses_User_Timeline(OAuth); TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); TwitterMessage twtmsg = new TwitterMessage(); foreach (var item in Timeline) { objTwitterMessage.UserId = Guid.Parse(UserId); objTwitterMessage.Type = "twt_usertweets"; try { objTwitterMessage.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.ScreenName = objTwitterAccount.TwitterScreenName; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.ProfileId = objTwitterAccount.TwitterUserId; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.MessageDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"')); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.Id = Guid.NewGuid(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { objTwitterMessage.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } objTwitterMessage.EntryDate = DateTime.Now; try { objTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (!objTwitterMessageRepository.checkTwitterMessageExists(objTwitterMessage.MessageId)) { objTwitterMessageRepository.addTwitterMessage(objTwitterMessage); } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); logger.Error("twtuser.GetStatuses_User_Timeline ex.StackTrace >> " + ex.StackTrace); logger.Error("twtuser.GetStatuses_User_Timeline ex.Message >> " + ex.Message); } #endregion }
public void getUserFeeds(string profileid) { TwitterUser twtuser = new TwitterUser(); User user = (User)HttpContext.Current.Session["LoggedUser"]; oAuthTwitter OAuth = new oAuthTwitter(); JArray data = twtuser.GetStatuses_User_Timeline(OAuth); TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); TwitterAccountRepository twtrepo = new TwitterAccountRepository(); TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, profileid); OAuth.CallBackUrl = ConfigurationManager.AppSettings["callbackurl"]; OAuth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"]; OAuth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"]; OAuth.TwitterScreenName = twtaccount.TwitterScreenName; OAuth.AccessTokenSecret = twtaccount.OAuthSecret; OAuth.AccessToken = twtaccount.OAuthToken; OAuth.ProfileImage = twtaccount.ProfileImageUrl; TwitterMessage twtmsg = new TwitterMessage(); foreach (var item in data) { twtmsg.UserId = user.Id; twtmsg.Type = "twt_usertweets"; try { twtmsg.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.ScreenName = twtaccount.TwitterScreenName; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.ProfileId = twtaccount.TwitterUserId; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.MessageDate = SocioBoard.Helper.Extensions.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"')); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.Id = Guid.NewGuid(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtmsg.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } twtmsg.EntryDate = DateTime.Now; try { twtmsg.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (!twtmsgrepo.checkTwitterMessageExists(twtmsg.MessageId)) { twtmsgrepo.addTwitterMessage(twtmsg); } } }
public void getgrphData(int days) { try { SocioBoard.Domain.User user = (User)Session["LoggedUser"]; FacebookAccountRepository objfb = new FacebookAccountRepository(); TwitterMessageRepository objtwttatsRepo = new TwitterMessageRepository(); ArrayList alstfb = objfb.getFbMessageStats(user.Id, days); ArrayList alstTwt = objtwttatsRepo.gettwtMessageStats(user.Id, days); strArray = "["; int _spanIncoming = 0; for (int i = 0; i < 7; i++) { string strTwtCnt = string.Empty; string strFbCnt = string.Empty; if (alstTwt.Count <= i) { strTwtCnt = "0"; } else { strTwtCnt = alstTwt[i].ToString(); } if (alstfb.Count <= i) { strFbCnt = "0"; } else { strFbCnt = alstfb[i].ToString(); } strArray = strArray + "[" + strFbCnt + "," + strTwtCnt + "],"; //spanIncoming.InnerHtml = (int.Parse(strTwtCnt) + int.Parse(strFbCnt)).ToString(); _spanIncoming = (int.Parse(strTwtCnt) + int.Parse(strFbCnt)); } spanIncoming.InnerHtml = _spanIncoming.ToString(); strArray = strArray.Substring(0, strArray.Length - 1) + "]"; ArrayList alstTwtFeed = objtwttatsRepo.gettwtFeedsStats(user.Id, days); ArrayList alstFBFeed = objfb.getFbFeedsStats(user.Id, days); strSentArray = "["; int _spanSent = 0; if (alstFBFeed.Count > 0 && alstTwtFeed.Count > 0) { int alstSentCount = 0; for (int i = 0; i < 7; i++) { string strTwtFeedCnt = string.Empty; string strFbFeedCnt = string.Empty; if (alstTwtFeed.Count <= i) { strTwtFeedCnt = "0"; } else { strTwtFeedCnt = alstTwtFeed[i].ToString(); } if (alstFBFeed.Count <= i) { strFbFeedCnt = "0"; } else { strFbFeedCnt = alstFBFeed[i].ToString(); } strSentArray = strSentArray + "[" + strFbFeedCnt + "," + strTwtFeedCnt + "],"; //spanSent.InnerHtml = (int.Parse(strFbFeedCnt) + int.Parse(strTwtFeedCnt)).ToString(); _spanSent = (int.Parse(strFbFeedCnt) + int.Parse(strTwtFeedCnt)); } spanSent.InnerHtml = (_spanSent).ToString(); } if (alstFBFeed.Count == 0 || alstTwtFeed.Count == 0) { for (int i = 0; i < 7; i++) { strSentArray += strSentArray + "[0,0],"; } } strSentArray = strSentArray.Substring(0, strSentArray.Length - 1) + "]"; TwitterStatsRepository objtwtStatsRepo = new TwitterStatsRepository(); ArrayList alstEng = objtwtStatsRepo.getAllTwitterStatsOfUser(user.Id, days); int ii = 1; strEng = "["; foreach (var item in alstEng) { Array temp = (Array)item; strEng = strEng + "{ x: new Date(2012, " + ii + ", " + ii + "), y:" + temp.GetValue(7) + "},"; ii++; } if (alstEng.Count == 0) { for (int i = 0; i < 10; i++) { strEng = strEng + "{ x: new Date(2012, " + ii + ", " + ii + "), y:0},"; } } strEng = strEng.Substring(0, strEng.Length - 1) + "]"; hmsgsent.InnerHtml = alstTwtFeed.Count.ToString(); hretweet.InnerHtml = objtwttatsRepo.getUserRetweetCount(user.Id).ToString(); } catch (Exception Err) { Response.Write(Err.StackTrace); } }
/// <summary> /// /// </summary> private void getTwitterUserProfile() { var requestToken = (String)Request.QueryString["oauth_token"]; var requestSecret = (String)Session["requestSecret"]; var requestVerifier = (String)Request.QueryString["oauth_verifier"]; OAuth.AccessToken = requestToken; OAuth.AccessTokenSecret = requestVerifier; OAuth.AccessTokenGet(requestToken, requestVerifier); JArray profile = userinfo.Get_Users_LookUp_ByScreenName(OAuth, OAuth.TwitterScreenName); User user = (User)Session["LoggedUser"]; SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository(); SocialProfile socioprofile = new SocialProfile(); #region for managing referrals ManageReferrals(OAuth); #endregion foreach (var item in profile) { try { twitterAccount.FollowingCount = Convert.ToInt32(item["friends_count"].ToString()); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twitterAccount.FollowersCount = Convert.ToInt32(item["followers_count"].ToString()); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } twitterAccount.Id = Guid.NewGuid(); twitterAccount.IsActive = true; twitterAccount.OAuthSecret = OAuth.AccessTokenSecret; twitterAccount.OAuthToken = OAuth.AccessToken; try { twitterAccount.ProfileImageUrl = item["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twitterAccount.ProfileUrl = string.Empty; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twitterAccount.TwitterUserId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception er) { try { twitterAccount.TwitterUserId = item["id"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception err) { Console.WriteLine(err.StackTrace); } Console.WriteLine(er.StackTrace); } try { twitterAccount.TwitterScreenName = item["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } twitterAccount.UserId = user.Id; socioprofile.Id = Guid.NewGuid(); socioprofile.ProfileDate = DateTime.Now; socioprofile.ProfileId = twitterAccount.TwitterUserId; socioprofile.ProfileType = "twitter"; socioprofile.UserId = user.Id; if (HttpContext.Current.Session["login"] != null) { if (HttpContext.Current.Session["login"].ToString().Equals("twitter")) { User usr = new User(); UserRepository userrepo = new UserRepository(); Registration regObject = new Registration(); usr.AccountType = "free"; usr.CreateDate = DateTime.Now; usr.ExpiryDate = DateTime.Now.AddMonths(1); usr.Id = Guid.NewGuid(); usr.UserName = twitterAccount.TwitterName; usr.Password = regObject.MD5Hash(twitterAccount.TwitterName); usr.EmailId = ""; usr.UserStatus = 1; if (!userrepo.IsUserExist(usr.EmailId)) { UserRepository.Add(usr); } } } TwitterStatsRepository objTwtstats = new TwitterStatsRepository(); TwitterStats objStats = new TwitterStats(); Random rNum = new Random(); objStats.Id = Guid.NewGuid(); objStats.TwitterId = twitterAccount.TwitterUserId; objStats.UserId = user.Id; objStats.FollowingCount = twitterAccount.FollowingCount; objStats.FollowerCount = twitterAccount.FollowersCount; objStats.Age1820 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2124 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2534 = rNum.Next(twitterAccount.FollowersCount); objStats.Age3544 = rNum.Next(twitterAccount.FollowersCount); objStats.Age4554 = rNum.Next(twitterAccount.FollowersCount); objStats.Age5564 = rNum.Next(twitterAccount.FollowersCount); objStats.Age65 = rNum.Next(twitterAccount.FollowersCount); objStats.EntryDate = DateTime.Now; if (!objTwtstats.checkTwitterStatsExists(twitterAccount.TwitterUserId, user.Id)) { objTwtstats.addTwitterStats(objStats); } if (!twtrepo.checkTwitterUserExists(twitterAccount.TwitterUserId, user.Id)) { twtrepo.addTwitterkUser(twitterAccount); if (!socioprofilerepo.checkUserProfileExist(socioprofile)) { socioprofilerepo.addNewProfileForUser(socioprofile); GroupRepository objGroupRepository = new GroupRepository(); SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)HttpContext.Current.Session["GroupName"]; Groups lstDetails = objGroupRepository.getGroupName(team.GroupId); if (lstDetails.GroupName == "Socioboard") { TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository(); TeamMemberProfile teammemberprofile = new TeamMemberProfile(); teammemberprofile.Id = Guid.NewGuid(); teammemberprofile.TeamId = team.Id; teammemberprofile.ProfileId = twitterAccount.TwitterUserId; teammemberprofile.ProfileType = "twitter"; teammemberprofile.StatusUpdateDate = DateTime.Now; objTeamMemberProfileRepository.addNewTeamMember(teammemberprofile); } } else { socioprofilerepo.updateSocialProfile(socioprofile); } } else { HttpContext.Current.Session["alreadyexist"] = twitterAccount; twtrepo.updateTwitterUser(twitterAccount); TwitterMessageRepository twtmsgreponew = new TwitterMessageRepository(); twtmsgreponew.updateScreenName(twitterAccount.TwitterUserId, twitterAccount.TwitterScreenName); if (!socioprofilerepo.checkUserProfileExist(socioprofile)) { socioprofilerepo.addNewProfileForUser(socioprofile); } else { socioprofilerepo.updateSocialProfile(socioprofile); } } if (Session["UserAndGroupsForTwitter"] != null) { if (Session["UserAndGroupsForTwitter"].ToString() == "twitter") { try { if (Session["GroupName"] != null) { Groups group = (Groups)Session["GroupName"]; GroupProfile groupprofile = new GroupProfile(); GroupProfileRepository groupprofilerepo = new GroupProfileRepository(); groupprofile.Id = Guid.NewGuid(); groupprofile.ProfileId = socioprofile.ProfileId; groupprofile.ProfileType = "twitter"; groupprofile.GroupOwnerId = user.Id; groupprofile.EntryDate = DateTime.Now; groupprofile.GroupId = group.Id; if (!groupprofilerepo.checkGroupProfileExists(user.Id, group.Id, groupprofile.ProfileId)) { groupprofilerepo.AddGroupProfile(groupprofile); } } } catch (Exception e) { Console.WriteLine(e.StackTrace); } } } } }
public void getUserTweets(oAuthTwitter OAuth, string TwitterScreenName, string TwitterUserId, Guid userId, Domain.Socioboard.Domain.TwitterAccount objTwitterAccount) { try { Users userinfo = new Users(); TwitterUser twtuser = new TwitterUser(); JArray data = twtuser.GetStatuses_User_Timeline(OAuth); TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository(); // TwitterMessage twtmsg = new TwitterMessage(); Domain.Socioboard.Domain.TwitterMessage ObjTwitterMessage = new Domain.Socioboard.Domain.TwitterMessage(); foreach (var item in data) { ObjTwitterMessage.UserId = userId; ObjTwitterMessage.Type = "twt_usertweets"; try { ObjTwitterMessage.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.ScreenName = TwitterScreenName; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.ProfileId = TwitterUserId; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.MessageDate = Utility.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"')); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.Id = Guid.NewGuid(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { ObjTwitterMessage.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } ObjTwitterMessage.EntryDate = DateTime.Now; try { ObjTwitterMessage.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"'); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } if (!twtmsgrepo.checkTwitterMessageExists(ObjTwitterMessage.ProfileId, ObjTwitterMessage.UserId, ObjTwitterMessage.MessageId)) { twtmsgrepo.addTwitterMessage(ObjTwitterMessage); } #region Add TwitterFollowerCount TwitterAccountFollowersRepository objTwitterAccountFollowersRepository = new TwitterAccountFollowersRepository(); Domain.Socioboard.Domain.TwitterAccountFollowers objTwitterAccountFollowers = new Domain.Socioboard.Domain.TwitterAccountFollowers(); objTwitterAccountFollowers.Id = Guid.NewGuid(); objTwitterAccountFollowers.UserId = userId; objTwitterAccountFollowers.EntryDate = DateTime.Now; objTwitterAccountFollowers.ProfileId = TwitterUserId; JArray profile = userinfo.Get_Users_LookUp_ByScreenName(OAuth, TwitterScreenName); foreach (var item_followerdata in profile) { try { objTwitterAccountFollowers.FollowingsCount = Convert.ToInt32(item_followerdata["friends_count"].ToString()); } catch (Exception ex) { logger.Error(ex.StackTrace); } try { objTwitterAccountFollowers.FollowersCount = Convert.ToInt32(item_followerdata["followers_count"].ToString()); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } objTwitterAccountFollowersRepository.addTwitterAccountFollower(objTwitterAccountFollowers); #endregion } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }
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 void getTwitterStats(Domain.Socioboard.Domain.TwitterAccount twitterAccount) { //TwitterStatsRepository objTwtstats = new TwitterStatsRepository(); TwitterStatsRepository objTwtstats = new TwitterStatsRepository(); TwitterMessageRepository objTweetMsgRepo = new TwitterMessageRepository(); //TwitterStats objStats = new TwitterStats(); Domain.Socioboard.Domain.TwitterStats objStats = new Domain.Socioboard.Domain.TwitterStats(); Random rNum = new Random(); objStats.Id = Guid.NewGuid(); objStats.TwitterId = twitterAccount.TwitterUserId; objStats.UserId = twitterAccount.UserId; objStats.FollowingCount = twitterAccount.FollowingCount; objStats.FollowerCount = twitterAccount.FollowersCount; objStats.Age1820 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2124 = rNum.Next(twitterAccount.FollowersCount); objStats.Age2534 = rNum.Next(twitterAccount.FollowersCount); objStats.Age3544 = rNum.Next(twitterAccount.FollowersCount); objStats.Age4554 = rNum.Next(twitterAccount.FollowersCount); objStats.Age5564 = rNum.Next(twitterAccount.FollowersCount); objStats.Age65 = rNum.Next(twitterAccount.FollowersCount); int replies = objTweetMsgRepo.getRepliesCount(twitterAccount.UserId, twitterAccount.TwitterUserId); int retweets = objTweetMsgRepo.getRetweetCount(twitterAccount.UserId, twitterAccount.TwitterUserId); if (twitterAccount.FollowersCount != 0) objStats.Engagement = (replies + retweets) / twitterAccount.FollowersCount; else objStats.Engagement = 0; objStats.EntryDate = DateTime.Now; if (!objTwtstats.checkTwitterStatsExists(twitterAccount.TwitterUserId, twitterAccount.UserId, objStats.FollowerCount, objStats.FollowingCount)) objTwtstats.addTwitterStats(objStats); }
public DataSet bindFeedMessageIntoDataTable(string[] profid) { string fbProfileid = string.Empty; string twtProfileid = string.Empty; string profilId = string.Empty; Messages mstable = new Messages(); DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable); try { foreach (var item in profid) { if (item.Contains("fb_")) { profilId = item.ToString().Split('_')[1]; fbProfileid += profilId + ','; } else if (item.Contains("twt_")) { profilId = item.ToString().Split('_')[1]; twtProfileid += profilId + ','; } else { try { } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } try { fbProfileid = fbProfileid.Substring(0, fbProfileid.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } try { twtProfileid = twtProfileid.Substring(0, twtProfileid.Length - 1); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository(); List <FacebookFeed> alstfbmsgs = fbfeedRepository.getAllFeedDetail(fbProfileid); 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.getAlltwtMessages(twtProfileid); 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); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(ds); }
protected void Page_Load(object sender, EventArgs e) { HttpContext.Current.Response.Cache.SetExpires(DateTime.UtcNow.AddDays(-1)); HttpContext.Current.Response.Cache.SetValidUntilExpires(false); HttpContext.Current.Response.Cache.SetRevalidation(HttpCacheRevalidation.AllCaches); HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); HttpContext.Current.Response.Cache.SetNoStore(); TeamRepository objTeamRepository = new TeamRepository(); GroupRepository objGroupRepository = new GroupRepository(); try { User user = (User)Session["LoggedUser"]; // SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"]; #region check user Activation UserRepository objUserRepository = new UserRepository(); try { if (user != null) { if (user.ActivationStatus == "0" || user.ActivationStatus == null) { actdiv.InnerHtml = "<marquee behavior=\"scroll\" direction=\"left\"><span >Your account is not yet activated.Check your E-mail to activate your account.</span><a id=\"resendmail\" uid=\"" + user.Id + "\" href=\"#\">Resend Mail</a></marquee>"; if (Request.QueryString["stat"] == "activate") { if (Request.QueryString["id"] != null) { //objUserActivation = objUserActivationRepository.GetUserActivationStatusbyid(Request.QueryString["id"].ToString()); if (user.Id.ToString() == Request.QueryString["id"].ToString()) { user.Id = user.Id; //Guid.Parse(Request.QueryString["id"]); //objUserActivation.UserId = Guid.Parse(Request.QueryString["id"]);// objUserActivation.UserId; user.ActivationStatus = "1"; //UserActivationRepository.Update(objUserActivation); int res = objUserRepository.UpdateActivationStatusByUserId(user); actdiv.Attributes.CssStyle.Add("display", "none"); Console.WriteLine("before"); #region to check/update user Reference Relation IsUserReferenceActivated(Request.QueryString["id"].ToString()); Console.WriteLine("after"); #endregion } else { Session["ActivationError"] = "Wrong Activation Link please contact Admin!"; //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Wrong Activation Link please contact Admin!');", true); //Response.Redirect("ActivationLink.aspx"); } } else { Session["ActivationError"] = "Wrong Activation Link please contact Admin!"; //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Wrong Activation Link please contact Admin!');", true); //Response.Redirect("ActivationLink.aspx"); } } else { // Response.Redirect("ActivationLink.aspx"); } } if (user.ActivationStatus == "1") { actdiv.Attributes.CssStyle.Add("display", "none"); } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.StackTrace); } #endregion if (!IsPostBack) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "my", " logout();", true); if (user == null) { Response.Redirect("/Default.aspx"); } else { #region for You can use only 30 days as Unpaid User if (user.PaymentStatus.ToLower() == "unpaid") { if (!SBUtils.IsUserWorkingDaysValid(user.ExpiryDate)) { // cmposecontainer.Attributes.Add("display", "none"); cmposecontainer.Attributes.CssStyle.Add("display", "none"); //topbtn.Attributes.CssStyle.Add("display", "none"); cmposecontainer.Attributes.CssStyle.Add("display", "none"); searchcontainer.Attributes.CssStyle.Add("display", "none"); } } #endregion 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; //incom_tasks.InnerHtml = Convert.ToString(alst.Count); //incomTasks.InnerHtml = Convert.ToString(alst.Count); } } catch (Exception es) { logger.Error(es.Message); Console.WriteLine(es.Message); } try { FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository(); int alstfeedfb = objFacebookFeedRepository.countUnreadMessages(user.Id); TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository(); int alstMsgtwt = objTwitterMessageRepository.getCountUnreadMessages(user.Id); incom_messages.InnerHtml = (alstfeedfb + alstMsgtwt).ToString(); 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"; } } catch (Exception sx) { logger.Error(sx.Message); Console.WriteLine(sx.Message); } //====================================================================================================== try { ArrayList totalAccuount = objTeamRepository.getAllAccountUser(user.EmailId, user.Id); if (totalAccuount.Count != 0) { string drodownselectedvalue = string.Empty; try { foreach (Guid item in totalAccuount) { Guid GroupIde = (Guid)item; List <Groups> GetData = objGroupRepository.getAllGroupsDetail(GroupIde); if (GetData.Count != 0) { string val = string.Empty; foreach (var items in GetData) { try { if (items.GroupName == "Socioboard") { drodownselectedvalue = items.Id.ToString(); } groupsselection.Items.Add(new ListItem((string)items.GroupName, items.Id.ToString())); } catch { } } } } if (Session["groupcheck"] == null) { int i = 0; groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByText("Socioboard")); //groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByValue("Socioboard")); //ListItem li = groupsselection.Items.FindByText(drodownselectedvalue); //li.Selected = true; Session["groupcheck"] = groupsselection.Items.FindByText("Socioboard").Value; } else { groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByValue((string)Session["groupcheck"])); //groupsselection.se.SelectedIndex = Session["groupcheck"]; } //if (Session["groupcheck"] == null) //{ // groupsselection.SelectedValue = (drodownselectedvalue); // Session["groupcheck"] = groupsselection.SelectedValue; //} //else //{ // groupsselection.SelectedIndex = Session["groupcheck"]; //} } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error("Error : " + ex.Message); logger.Error("Error : " + ex.StackTrace); } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error("Error : " + ex.Message); logger.Error("Error : " + ex.StackTrace); } //===================================================================================================================================== usernm.InnerHtml = "Hello, " + user.UserName + " "; if (!string.IsNullOrEmpty(user.ProfileUrl)) { // Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")"; //userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" /></a></a>"; userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" />"; userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" />"; //userinf.InnerHtml = Datetime; //{ //userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/></a></a>"; userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/>"; userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/>"; 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 { //Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")"; //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 + "\"/>"; userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/>"; //userinf.InnerHtml = Datetime; 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.getAllGroupsCompleteDetails(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; } if (user.AccountType == AccountType.Deluxe.ToString().ToLower()) { tot_acc = 10; } else if (user.AccountType == AccountType.Standard.ToString().ToLower()) { tot_acc = 20; } else if (user.AccountType == AccountType.Premium.ToString().ToLower()) { tot_acc = 50; } profileCount = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count; } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); } } } //Team lstDetails = objTeamRepository.getAllGroupsDetails(user.EmailId.ToString(), Guid.Parse(groupsselection.SelectedItem.Value)); //Session["GroupName"] = lstDetails; } catch (Exception ex) { logger.Error(ex.Message); Console.WriteLine(ex.Message); } }
public string DeleteAllUsersByCreateDate(string date) { int i = 0; int count = 0; UserRepository objUserRepository = new UserRepository(); List <User> lstuser = objUserRepository.GetAllUsersByCreateDate(date); ArchiveMessageRepository objArchiveMessageRepository = new ArchiveMessageRepository(); DiscoverySearchRepository objDiscoverySearchRepository = new DiscoverySearchRepository(); DraftsRepository objDraftsRepository = new DraftsRepository(); FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository(); FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository(); FacebookInsightPostStatsRepository objFacebookInsightPostStatsRepository = new FacebookInsightPostStatsRepository(); FacebookInsightStatsRepository objFacebookInsightStatsRepository = new FacebookInsightStatsRepository(); FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository(); FacebookStatsRepository objFacebookStatsRepository = new FacebookStatsRepository(); GoogleAnalyticsAccountRepository objGoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository(); GoogleAnalyticsStatsRepository objGoogleAnalyticsStatsRepository = new GoogleAnalyticsStatsRepository(); GooglePlusAccountRepository objGooglePlusAccountRepository = new GooglePlusAccountRepository(); GooglePlusActivitiesRepository objGooglePlusActivitiesRepository = new GooglePlusActivitiesRepository(); GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository(); GroupRepository objGroupRepository = new GroupRepository(); InstagramAccountRepository objInstagramAccountRepository = new InstagramAccountRepository(); InstagramCommentRepository objInstagramCommentRepository = new InstagramCommentRepository(); InstagramFeedRepository objInstagramFeedRepository = new InstagramFeedRepository(); LinkedInAccountRepository objLinkedInAccountRepository = new LinkedInAccountRepository(); LinkedInFeedRepository objLinkedInFeedRepository = new LinkedInFeedRepository(); LogRepository objLogRepository = new LogRepository(); RssFeedsRepository objRssFeedsRepository = new RssFeedsRepository(); RssReaderRepository objRssReaderRepository = new RssReaderRepository(); ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository(); SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository(); TaskCommentRepository objTaskCommentRepository = new TaskCommentRepository(); TaskRepository objTaskRepository = new TaskRepository(); TeamRepository objTeamRepository = new TeamRepository(); TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository(); TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository(); TwitterDirectMessageRepository objTwitterDirectMessageRepository = new TwitterDirectMessageRepository(); TwitterFeedRepository objTwitterFeedRepository = new TwitterFeedRepository(); TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository(); TwitterStatsRepository objTwitterStatsRepository = new TwitterStatsRepository(); UserActivationRepository objUserActivationRepository = new UserActivationRepository(); UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository(); count = lstuser.Count(); foreach (var item in lstuser) { i++; try { if (item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**") { } else { objArchiveMessageRepository.DeleteArchiveMessageByUserid(item.Id); objDiscoverySearchRepository.DeleteDiscoverySearchByUserid(item.Id); objDraftsRepository.DeleteDraftsByUserid(item.Id); objFacebookAccountRepository.DeleteFacebookAccountByUserid(item.Id); objFacebookFeedRepository.DeleteFacebookFeedByUserid(item.Id); objFacebookInsightPostStatsRepository.DeleteFacebookInsightPostStatsByUserid(item.Id); objFacebookInsightStatsRepository.DeleteFacebookInsightStatsByUserid(item.Id); objFacebookMessageRepository.DeleteFacebookMessageByUserid(item.Id); objFacebookStatsRepository.DeleteFacebookStatsByUserid(item.Id); objGoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(item.Id); objGoogleAnalyticsStatsRepository.DeleteGoogleAnalyticsStatsByUserid(item.Id); objGooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(item.Id); objGooglePlusActivitiesRepository.DeleteGooglePlusActivitiesByUserid(item.Id); objGroupProfileRepository.DeleteGroupProfileByUserid(item.Id); objGroupRepository.DeleteGroupsByUserid(item.Id); objInstagramAccountRepository.DeleteInstagramAccountByUserid(item.Id); objInstagramCommentRepository.DeleteInstagramCommentByUserid(item.Id); objInstagramFeedRepository.DeleteInstagramFeedByUserid(item.Id); objLinkedInAccountRepository.DeleteLinkedInAccountByUserid(item.Id); objLinkedInFeedRepository.DeleteLinkedInFeedByUserid(item.Id); objLogRepository.DeleteLogByUserid(item.Id); objRssFeedsRepository.DeleteRssFeedsByUserid(item.Id); objRssReaderRepository.DeleteRssReaderByUserid(item.Id); objScheduledMessageRepository.DeleteScheduledMessageByUserid(item.Id); objSocialProfilesRepository.DeleteSocialProfileByUserid(item.Id); objTaskCommentRepository.DeleteTaskCommentByUserid(item.Id); objTaskRepository.DeleteTasksByUserid(item.Id); objTeamRepository.DeleteTeamByUserid(item.Id); objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(item.Id); objTwitterAccountRepository.DeleteTwitterAccountByUserid(item.Id); objTwitterDirectMessageRepository.DeleteTwitterDirectMessagesByUserid(item.Id); objTwitterFeedRepository.DeleteTwitterFeedByUserid(item.Id); objTwitterMessageRepository.DeleteTwitterMessageByUserid(item.Id); objTwitterStatsRepository.DeleteTwitterStatsByUserid(item.Id); objUserActivationRepository.DeleteUserActivationByUserid(item.Id); objUserPackageRelationRepository.DeleteuserPackageRelationByUserid(item.Id); objUserRepository.DeleteUserByUserid(item.Id); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(i + " " + count); }