public IActionResult getInstagramFeeds(long boardId, int skip, int count) { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository boardrepo = new MongoRepository("MongoBoardInstagramFeeds", _appSettings); try { var builder = Builders <MongoBoardInstagramFeeds> .Sort; var sort = builder.Descending(t => t.Publishedtime); //var result = boardrepo.FindWithRange<MongoBoardInstagramFeeds>(t => t.Instagramaccountid.Equals(board.instagramHashTag),sort,skip, count).ConfigureAwait(false); var result = boardrepo.BoardFind <MongoBoardInstagramFeeds>(t => t.Instagramaccountid.Equals(board.instagramHashTag)).ConfigureAwait(false); var task = Task.Run(async() => { return(await result); }); IList <MongoBoardInstagramFeeds> objTwitterPagelist = task.Result; List <MongoBoardInstagramFeeds> objBoardGplusPagefeeds = objTwitterPagelist.OrderByDescending(t => t.Publishedtime).Skip(Convert.ToInt32(skip)).Take(Convert.ToInt32(count)).ToList(); return(Ok(objBoardGplusPagefeeds)); } catch (Exception ex) { _logger.LogError(ex.StackTrace); return(Ok("Something Went Wrong")); } }
public IActionResult getGplusfeeds(long boardId, string skip, string count) { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository boardrepo = new MongoRepository("MongoBoardGplusFeeds", _appSettings); try { //List<MongoBoardGplusFeeds> objBoardGplusPagefeeds = boardrepo.getBoardGplusfeedsbyrange(Guid.Parse(BoardGplusprofileId), Convert.ToInt32(_noOfDataToSkip), Convert.ToInt32(_noOfResultsFromTop)); var builder = Builders <MongoBoardGplusFeeds> .Sort; var sort = builder.Descending(t => t.Publishedtime); //var result = boardrepo.FindWithRange<MongoBoardGplusFeeds>(t => t.Gplusboardaccprofileid.Equals(board.gplusHashTag),sort,Convert.ToInt32(skip),Convert.ToInt32(count)).ConfigureAwait(false); var result = boardrepo.BoardFind <MongoBoardGplusFeeds>(t => t.Gplusboardaccprofileid.Equals(board.gplusHashTag)).ConfigureAwait(false); var task = Task.Run(async() => { return(await result); }); IList <MongoBoardGplusFeeds> objTwitterPagelist = task.Result; List <MongoBoardGplusFeeds> objBoardGplusPagefeeds = objTwitterPagelist.OrderByDescending(t => t.Publishedtime).Skip(Convert.ToInt32(skip)).Take(Convert.ToInt32(count)).ToList(); return(Ok(objBoardGplusPagefeeds)); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(Ok("Something Went Wrong")); } }
public async Task <IActionResult> getGplusfeeds(long boardId, int skip, int count) { try { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository mongorepo = new MongoRepository("MongoBoardGplusHashTag", _appSettings); MongoBoardGplusHashTag gplushashtag = await mongorepo.FindFirstOrDefault <MongoBoardGplusHashTag>(x => x.Boardid.Equals(board.boardId)).ConfigureAwait(false); List <MongoBoardGplusFeeds> GplusFeedsList = GplusRepository.AddBoardGplusTagFeeds(gplushashtag.Displayname, board.gplusHashTag, _appSettings, _logger); if (GplusFeedsList.Count == 0) { MongoRepository boardrepo = new MongoRepository("MongoBoardGplusFeeds", _appSettings); var builder = Builders <MongoBoardGplusFeeds> .Sort; var sort = builder.Descending(t => t.Publishedtime); IList <MongoBoardGplusFeeds> objTwitterPagelist = await boardrepo.FindWithRange <MongoBoardGplusFeeds>(t => t.Gplusboardaccprofileid.Equals(board.gplusHashTag) && t.Feedlink != null, sort, skip, count); List <MongoBoardGplusFeeds> lstBGFeeds = objTwitterPagelist.ToList(); foreach (var items_lstBGFeed in lstBGFeeds) { if (items_lstBGFeed.FromName.Any(c => char.IsSymbol(c)) || items_lstBGFeed.Title.Contains("¾")) { objTwitterPagelist.Remove(items_lstBGFeed); } } return(Ok(objTwitterPagelist)); } return(Ok(GplusFeedsList)); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(Ok("Something Went Wrong")); } }
public IActionResult getfacebookFeeds(long boardId, int skip, int count) { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository boardrepo = new MongoRepository("MongoBoardFbTrendingFeeds", _appSettings); try { //var result = boardrepo.Find<MongoBoardFbTrendingFeeds>(t => t.facebookprofileid.Equals(board.facebookHashTag)); //var task = Task.Run(async () => //{ // return await result; //}); //IList<MongoBoardFbTrendingFeeds> objTwitterPagelist = task.Result; //List<MongoBoardFbTrendingFeeds> objBoardGplusPagefeeds = objTwitterPagelist.OrderByDescending(t => t.publishedtime).Skip(Convert.ToInt32(skip)).Take(Convert.ToInt32(count)).ToList(); //return Ok(objBoardGplusPagefeeds); var builder = Builders <MongoBoardFbTrendingFeeds> .Sort; var sort = builder.Descending(t => t.publishedtime); var result = boardrepo.FindWithRange <MongoBoardFbTrendingFeeds>(t => t.facebookprofileid.Equals(board.facebookHashTag), sort, skip, count); var task = Task.Run(async() => { return(await result); }); IList <MongoBoardFbTrendingFeeds> objTwitterPagelist = task.Result; return(Ok(objTwitterPagelist)); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(Ok("Something Went Wrong")); } }
public async Task <IActionResult> getTwitterFeeds(long boardId, int skip, int count) { try { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository mongorepo = new MongoRepository("MongoBoardTwitterHashTag", _appSettings); MongoBoardTwitterHashTag twitterhashtag = await mongorepo.FindFirstOrDefault <MongoBoardTwitterHashTag>(x => x.Boardid.Equals(board.boardId)).ConfigureAwait(false); List <MongoBoardTwtFeeds> twtFeedsList = TwitterRepository.AddBoardTwitterHashTagFeeds(twitterhashtag.Screenname, board.twitterHashTag, null, _appSettings, _logger); if (twtFeedsList.Count == 0) { MongoRepository boardrepo = new MongoRepository("MongoBoardTwtFeeds", _appSettings); var builder = Builders <MongoBoardTwtFeeds> .Sort; var sort = builder.Descending(t => t.Publishedtime); IList <MongoBoardTwtFeeds> objTwitterPagelist = await boardrepo.FindWithRange <MongoBoardTwtFeeds>(t => t.Twitterprofileid.Equals(board.twitterHashTag) && t.Feedurl != null, sort, skip, count); return(Ok(objTwitterPagelist)); } return(Ok(twtFeedsList)); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(Ok("Something Went Wrong")); }
public string UpdateBoard(Domain.Socioboard.Models.MongoBoards boards) { try { DatabaseRepository dbr = new DatabaseRepository(); if (!string.IsNullOrEmpty(boards.twitterHashTag)) { TwitterRepository twtrepo = new TwitterRepository(); boards.twitterHashTag = twtrepo.AddTwitterHashTag(boards.twitterHashTag, boards.id.ToString()); } if (!string.IsNullOrEmpty(boards.instagramHashTag)) { InstagramRepository instRepo = new InstagramRepository(); boards.instagramHashTag = instRepo.AddInstagramHashTag(boards.instagramHashTag, boards.id.ToString()); } if (!string.IsNullOrEmpty(boards.gplusHashTag)) { GplusRepository gplusRepo = new GplusRepository(); boards.gplusHashTag = gplusRepo.AddGplusHashTag(boards.gplusHashTag, boards.id.ToString()); } dbr.Update <Domain.Socioboard.Models.MongoBoards>(boards); return("update"); } catch (Exception) { return("Issue in board updation"); } }
public IActionResult UndoDeleteBoard(string BoardId, long userId) { DatabaseRepository boardrepo = new DatabaseRepository(_logger, _env); List <Domain.Socioboard.Models.MongoBoards> boards = new List <Domain.Socioboard.Models.MongoBoards>(); try { boards = boardrepo.Find <Domain.Socioboard.Models.MongoBoards>(t => t.id.Equals(BoardId)).ToList(); } catch (Exception e) { } if (boards.Count() > 0) { Domain.Socioboard.Models.MongoBoards board = boards.First(); board.isActive = Domain.Socioboard.Enum.boardStatus.active; boardrepo.Update <Domain.Socioboard.Models.MongoBoards>(board); return(Ok("success")); } return(Ok("failed to update")); }
public IActionResult getTwitterFeeds(long boardId, int skip, int count) { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); Domain.Socioboard.Models.MongoBoards board = BoardMeRepository.getBoard(boardId, _redisCache, _appSettings, _logger, dbr); MongoRepository boardrepo = new MongoRepository("MongoBoardTwtFeeds", _appSettings); try { var result = boardrepo.Find <MongoBoardTwtFeeds>(t => t.Twitterprofileid.Equals(board.twitterHashTag)).ConfigureAwait(false); var task = Task.Run(async() => { return(await result); }); IList <MongoBoardTwtFeeds> objTwitterPagelist = task.Result; List <MongoBoardTwtFeeds> objBoardGplusPagefeeds = objTwitterPagelist.OrderByDescending(t => t.Publishedtime).Skip(Convert.ToInt32(skip)).Take(Convert.ToInt32(count)).ToList(); return(Ok(objBoardGplusPagefeeds)); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(Ok("Something Went Wrong")); } }
public async Task <string> AddFacebookrendingHashTagFeeds(string[] jsonObj, Helper.AppSettings settings) { DatabaseRepository dbr = new DatabaseRepository(_logger, _env); IList <Domain.Socioboard.Models.MongoBoards> boards = new List <Domain.Socioboard.Models.MongoBoards>(); string Id = Convert.ToString(Guid.NewGuid()); MongoRepository mongorepo = new MongoRepository("MongoBoardFbTrendingFeeds", settings); List <MongoBoardFbTrendingFeeds> twtFeedsList = new List <MongoBoardFbTrendingFeeds>(); string boardName = string.Empty; foreach (var item in jsonObj) { MongoBoardFbTrendingFeeds _MongoBoardFbTrendingFeeds = new MongoBoardFbTrendingFeeds(); string FromName = getBetween(item, "FromName", "FromPicUrl"); string FromPicUrl = getBetween(item, "FromPicUrl", "PostImageurl"); string PostImageurl = getBetween(item, "PostImageurl", "Text"); string Text = getBetween(item, "Text", "Title"); string Title = getBetween(item, "Title", "facebookprofileid"); string publishedtime = getBetween(item, "publishedtime", "posturl"); string posturl = getBetween(item, "posturl", "BoardName"); _MongoBoardFbTrendingFeeds.Id = ObjectId.GenerateNewId(); _MongoBoardFbTrendingFeeds.FromName = FromPicUrl.Replace("\":\"", "").Replace("\",\"", ""); _MongoBoardFbTrendingFeeds.FromPicUrl = FromName.Replace("\":\"", "").Replace("\",\"", ""); _MongoBoardFbTrendingFeeds.PostImageurl = PostImageurl.Replace("\":\"", "").Replace("\",\"", ""); _MongoBoardFbTrendingFeeds.Text = Text.Replace("\":\"", "").Replace("</p>\",\"", "").Replace("\",\"", "").Replace("&", "&"); _MongoBoardFbTrendingFeeds.Title = Title.Replace("\":\"", "").Replace("\",\"", ""); //_MongoBoardFbTrendingFeeds.facebookprofileid = data[5].Replace("[\"", "").Replace("\"", ""); _MongoBoardFbTrendingFeeds.facebookprofileid = Id; if (string.IsNullOrEmpty(boardName)) { boardName = getBetween(item, "BoardName", "\"}"); boardName = boardName.Replace("\":\"", "").Replace("\"", "").Replace("\",\"", ""); boards = dbr.Find <Domain.Socioboard.Models.MongoBoards>(t => t.boardName.Equals(boardName.ToLower())); if (boards.First().facebookHashTag != null) { return("Board already has FB feeds"); } } try { _MongoBoardFbTrendingFeeds.publishedtime = Convert.ToDouble(publishedtime.Replace("\":\"", "").Replace("\",\"", "")); } catch (Exception) { _MongoBoardFbTrendingFeeds.publishedtime = SBHelper.ConvertToUnixTimestamp(DateTime.UtcNow); } _MongoBoardFbTrendingFeeds.posturl = posturl.Replace("\":\"", "").Replace("\",\"", ""); _MongoBoardFbTrendingFeeds.Isvisible = true; try { var ret = mongorepo.Find <MongoBoardFbTrendingFeeds>(t => t.FromName == _MongoBoardFbTrendingFeeds.FromName && t.Text == _MongoBoardFbTrendingFeeds.Text); var task = Task.Run(async() => { return(await ret); }); int cont = task.Result.Count; if (cont < 1) { mongorepo.Add <MongoBoardFbTrendingFeeds>(_MongoBoardFbTrendingFeeds); } } catch (Exception ex) { } } try { boards = dbr.Find <Domain.Socioboard.Models.MongoBoards>(t => t.boardName.Equals(boardName.ToLower())); if (boards.First().facebookHashTag == null) { if (boards != null || boards.Count() != 0) { Domain.Socioboard.Models.MongoBoards board = dbr.Single <Domain.Socioboard.Models.MongoBoards>(t => t.boardName == boards.First().boardName); board.facebookHashTag = Id; dbr.Update <Domain.Socioboard.Models.MongoBoards>(board); return("successfulyy Updated Board."); } else { return("Board Not Found"); } } } catch (Exception e) { } return(""); }
public void GetLatestTrendsFromTwiter() { try { string homepageUrl = "https://twitter.com/"; string trendsUrl = "https://twitter.com/i/trends?k=0b49e0976b&pc=true&personalized=false&show_context=true&src=module&woeid=23424977"; string homePageResponse = getHtmlfromUrl(trendsUrl); try { string[] GetTrends = Regex.Split(homePageResponse, "data-trend-name="); GetTrends = GetTrends.Skip(1).ToArray(); foreach (string item in GetTrends) { try { string temptrend = string.Empty; string trend = getBetween(item, "\"", "\\\"").Replace("'", "'"); trend = Regex.Replace(trend, @"\\u[\d\w]{4}", String.Empty); trend = trend.Replace("#", ""); if (!string.IsNullOrEmpty(trend) && !trend.Contains("_") && !trend.Contains("__")) { if (trend.ToLower().Contains(" ")) { temptrend = trend.Replace(" ", "_"); } else if (trend.ToLower().Contains("/")) { temptrend = trend.Replace("/", "_"); } else if (trend.ToLower().Contains("'\'")) { temptrend = trend.Replace("'\'", "_"); } else { temptrend = trend.ToLower(); } //Trendingkeyword _Trendingkeyword = new Trendingkeyword(); //_Trendingkeyword.Id = ObjectId.GenerateNewId(); //_Trendingkeyword.strId = ObjectId.GenerateNewId().ToString(); //_Trendingkeyword.keyword = trend; //_Trendingkeyword.TrendingType = Domain.Socioboard.Enum.TrendingType.twitter; //_Trendingkeyword.trendingdate= SBHelper.ConvertToUnixTimestamp(DateTime.UtcNow); //MongoRepository mongorepo = new MongoRepository("Trendingkeyword"); //var ret=mongorepo.Find<Trendingkeyword>(t => t.keyword == trend && t.TrendingType==Domain.Socioboard.Enum.TrendingType.twitter); //var task = Task.Run(async () => //{ // return await ret; //}); //int count = task.Result.Count; //if(count<1) //{ // mongorepo.Add<Trendingkeyword>(_Trendingkeyword); // AddTwittertrendingHashTagFeeds(trend, _Trendingkeyword.strId, ""); //} DatabaseRepository dbr = new DatabaseRepository(); List <Domain.Socioboard.Models.MongoBoards> boards = new List <Domain.Socioboard.Models.MongoBoards>(); try { boards = dbr.Find <Domain.Socioboard.Models.MongoBoards>(t => t.boardName.Equals(trend.ToLower()) && t.isActive == Domain.Socioboard.Enum.boardStatus.active).ToList(); string Bid = string.Empty; if (boards == null || boards.Count() == 0) { //Bid = boards.First().boardId; Domain.Socioboard.Models.MongoBoards board = new Domain.Socioboard.Models.MongoBoards(); board.TempboardName = temptrend.ToLower(); board.isActive = Domain.Socioboard.Enum.boardStatus.active; board.boardName = trend.ToLower(); board.trendingtype = Domain.Socioboard.Enum.TrendingType.twitter; board.createDate = DateTime.UtcNow; board.boardId = Guid.NewGuid().ToString(); board.twitterHashTag = AddTwitterHashTag(trend, board.boardId); board.instagramHashTag = AddInstagramHashTag(trend, board.boardId); board.gplusHashTag = AddGplusHashTag(trend, board.boardId); dbr.Add <Domain.Socioboard.Models.MongoBoards>(board); string boardcreation = getHtmlfromUrl("https://api.socioboard.com/api/BoardMe/AddTOSiteMap?boardName=" + board.boardName); if (boardcreation.Contains("true")) { Console.WriteLine("created new sitemap for twitter trending keyword" + boardcreation); } Console.WriteLine("created new bord for twitter trending keyword" + board.boardName); } else { Bid = boards.First().boardId; Domain.Socioboard.Models.MongoBoards board = dbr.Single <Domain.Socioboard.Models.MongoBoards>(t => t.boardId == Bid); // board.TempboardName = temptrend; board.isActive = Domain.Socioboard.Enum.boardStatus.active; board.createDate = DateTime.UtcNow; //board.boardId = board.boardId; //board.facebookHashTag = AddFacebookHashTag(trds[0], trds[1], board.boardId, ref HttpHelper, ref facebookUser); //board.twitterHashTag = AddTwitterHashTag(trend, board.boardId); //board.instagramHashTag = AddInstagramHashTag(trend, board.boardId); //board.gplusHashTag = AddGplusHashTag(trend, board.boardId); dbr.Update <Domain.Socioboard.Models.MongoBoards>(board); string boardcreation = getHtmlfromUrl("https://api.socioboard.com/api/BoardMe/AddTOSiteMap?boardName=" + board.boardName); if (boardcreation.Contains("true")) { Console.WriteLine("created new sitemap for twitter trending keyword" + boardcreation); } Console.WriteLine("created new bord for twitter trending keyword" + board.boardName); } } catch (Exception e) { } } } catch (Exception ex) { } } } catch (Exception ex) { } } catch (Exception ex) { } }