public IActionResult GetUserGroupData(long userId, string groupId) { var dbr = new DatabaseRepository(_logger, _appEnv); var _GetUserGroupData = new GetUserGroupData(); var lstgroup = new List <Groups>(); var lstgrpmember = new List <Groupmembers>(); lstgrpmember = dbr.Find <Groupmembers>(t => t.userId == userId && t.memberStatus == Domain.Socioboard.Enum.GroupMemberStatus.Accepted).ToList(); var lstgrpId = lstgrpmember.Select(t => t.groupid).ToArray(); lstgroup = dbr.Find <Groups>(t => lstgrpId.Contains(t.id)).ToList(); var lstgrpProfiles = new List <Groupprofiles>(); if (string.IsNullOrEmpty(groupId)) { var lstStr = lstgroup.Select(t => t.id).ToArray(); lstgrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(lstStr[0], _redisCache, dbr); } else { lstgrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(Convert.ToInt32(groupId), _redisCache, dbr); } var myProfiles = lstgrpProfiles.GroupBy(o => o.groupId).ToDictionary(g => g.Key, g => g.ToList()); _GetUserGroupData.lstgroup = lstgroup; _GetUserGroupData.myProfiles = myProfiles; return(Ok(_GetUserGroupData)); }
public IActionResult GetYoutubeAccount(string code, long groupId, long userId) { try { var lstYoutubeProfiles = new List <YoutubeProfiles>(); var dbr = new DatabaseRepository(_logger, _appEnv); lstYoutubeProfiles = GoogleHelper.GetYoutubeAccount(code, _appSettings, dbr); var lstGrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr); lstGrpProfiles = lstGrpProfiles.Where(t => t.profileType == SocialProfileType.YouTube).ToList(); var lstStr = lstGrpProfiles.Select(t => t.profileId).ToArray(); if (lstStr.Length > 0) { lstYoutubeProfiles.Where(t => lstStr.Contains(t.YtChannelId)).Select(s => { s.connected = 1; return(s); }).ToList(); } return(Ok(lstYoutubeProfiles)); } catch (Exception ex) { _logger.LogError("GetGetYoutubeAccount" + ex.StackTrace); _logger.LogError("GetGetYoutubeAccount" + ex.Message); return(Ok(new List <YoutubeProfiles>())); } }
public IActionResult GetAllGAProfiles(long groupId) { var lstGoogleAnalyticsAccount = new List <GoogleAnalyticsAccount>(); try { var dbr = new DatabaseRepository(_logger, _appEnv); var lstGrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr); foreach (var item in lstGrpProfiles.Where(t => t.profileType == SocialProfileType.GoogleAnalytics)) { var gAAcc = GplusRepository.getGAAccount(item.profileId, _redisCache, dbr); if (gAAcc != null) { lstGoogleAnalyticsAccount.Add(gAAcc); } } } catch (Exception e) { Console.WriteLine(e); } return(Ok(lstGoogleAnalyticsAccount)); }
public IActionResult GetGplusProfilesOnly(long groupId) { var lstGplusAcc = new List <Googleplusaccounts>(); try { var dbr = new DatabaseRepository(_logger, _appEnv); var lstGrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr) .Where(t => t.profileType == SocialProfileType.GPlus); lstGplusAcc.AddRange( from item in lstGrpProfiles select GplusRepository.getGPlusAccount(item.profileId, _redisCache, dbr) into gPlusAcc let userdata = dbr.Single <User>(t => t.Id == gPlusAcc.UserId) where gPlusAcc != null && userdata.EmailId != gPlusAcc.EmailId select gPlusAcc); return(Ok(lstGplusAcc)); } catch (Exception) { return(Ok(lstGplusAcc)); } }
public IActionResult GetPrimaryGoogleAcc(long userId, long groupId) { var userGplusAcc = new Googleplusaccounts(); try { var dbr = new DatabaseRepository(_logger, _appEnv); var lstGrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr); lstGrpProfiles = lstGrpProfiles.Where(t => t.profileType == SocialProfileType.GPlus).ToList(); foreach (var item in lstGrpProfiles) { var gPlusAcc = GplusRepository.getGPlusAccount(item.profileId, _redisCache, dbr); var userdata = dbr.Single <User>(t => t.Id == gPlusAcc.UserId); if (gPlusAcc != null && userdata.EmailId == gPlusAcc.EmailId) { userGplusAcc = gPlusAcc; } } } catch (Exception e) { Console.WriteLine(e); } return(Ok(userGplusAcc)); }
public IActionResult getProfilesAvailableToConnect(long groupId, long userId) { var dbr = new DatabaseRepository(_logger, _appEnv); var lstGroupProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr); var lstGroups = GroupsRepository.GetAllGroupsofUser(userId, _redisCache, dbr); long defaultGroupId = lstGroups.FirstOrDefault(t => t.groupName.Equals(Domain.Socioboard.Consatants.SocioboardConsts.DefaultGroupName)).id; List <Domain.Socioboard.Models.Groupprofiles> defalutGroupProfiles = GroupProfilesRepository.GetAllGroupProfiles(defaultGroupId, _redisCache, dbr); return(Ok(defalutGroupProfiles.Where(t => !lstGroupProfiles.Any(x => x.profileId.Equals(t.profileId))))); }
public IActionResult GetAllYTChannelsSB(long groupId) { var dbr = new DatabaseRepository(_logger, _appEnv); var lstGrpProfiles = GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr); var lstYoutubeChannel = new List <YoutubeChannel>(); foreach (var item in lstGrpProfiles.Where(t => t.profileType == SocialProfileType.YouTube)) { var YTChnl = GplusRepository.getYTChannel(item.profileId, _redisCache, dbr); if (YTChnl != null) { lstYoutubeChannel.Add(YTChnl); } } return(Ok(lstYoutubeChannel)); }
public IActionResult GetAllGroupProfiles(long groupId) { DatabaseRepository dbr = new DatabaseRepository(_logger, _appEnv); return(Ok(GroupProfilesRepository.GetAllGroupProfiles(groupId, _redisCache, dbr))); }