public List <Groupprofiles> GetGroupProfiles(long groupId)
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Groupprofiles> getGroupProfiles = dbr.Find <Domain.Socioboard.Models.Groupprofiles>(t => t.groupId == groupId).ToList();
return(getGroupProfiles);
}
public static List <User> GetAllUsers()
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.User> Users = dbr.Find <Domain.Socioboard.Models.User>(t => t.ActivationStatus == 0).ToList();
return(Users);
}
public List <User> getUsersById(long UserId, string access_token)
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.User> getallgroups = dbr.Find <Domain.Socioboard.Models.User>(t => t.Id == UserId).ToList();
return(getallgroups);
}
public List <Instagramaccounts> UserInformation(Int64 adminid)
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Instagramaccounts> getallinstaprofiles = dbr.Find <Domain.Socioboard.Models.Instagramaccounts>(t => t.UserId == adminid).ToList();
return(getallinstaprofiles);
}
public List <Facebookaccounts> getFacebookpageAccountDetailsById(Int64 adminid)
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Facebookaccounts> getallfbprofiles = dbr.Find <Domain.Socioboard.Models.Facebookaccounts>(t => t.UserId == adminid && t.FbProfileType == Domain.Socioboard.Enum.FbProfileType.FacebookPage).ToList();
return(getallfbprofiles);
}
public List <TwitterAccount> GetTwitterFollowers(long adminId, long userId, string days)
{
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.TwitterAccount> TwitterFollowerCount = dbr.Find <Domain.Socioboard.Models.TwitterAccount>(t => t.userId == adminId).ToList();
return(TwitterFollowerCount);
}
public static List <User> subscriptionstatus()
{
// DateTime dateTime = DateTime.UtcNow.Date.AddDays(-7);
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.User> lstLogintime = dbr.Find <Domain.Socioboard.Models.User>(t => t.dailyGrpReportsSummery == true).ToList();
return(lstLogintime);
}
public List <Groups> GetAllGroupsSkip(int skip)
{
DateTime dateTime = DateTime.UtcNow;
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Groups> getallgroups = dbr.FindWithRange <Domain.Socioboard.Models.Groups>(t => t.createdDate.Date <= dateTime.Date, skip, 5000).ToList();
return(getallgroups);
}
public List <Groups> GetAllGroups()
{
DateTime dateTime = DateTime.UtcNow;
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Groups> getallgroups = dbr.Find <Domain.Socioboard.Models.Groups>(t => t.createdDate.Date <= dateTime.Date && t.id >= 1 && t.id <= 100).ToList();
return(getallgroups);
}
public static List <User> Inactiveuser()
{
DateTime dateTime = DateTime.UtcNow.Date.AddDays(-7);
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.User> lstLogintime = dbr.Find <Domain.Socioboard.Models.User>(t => t.LastLoginTime <= dateTime).ToList();
return(lstLogintime);
}
public static List <NewsLetter> GetAllnewsletter()
{
DateTime dateTime = DateTime.UtcNow.Date;
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.NewsLetter> _news = dbr.Find <Domain.Socioboard.Models.NewsLetter>(t => t.ExpiryDate.Date >= dateTime).ToList();
return(_news);
}
public static List <User> GetAllbeforeExpiredUser()
{
DateTime dateTime = DateTime.UtcNow.Date.AddDays(7);
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.User> lstEmail = dbr.Find <Domain.Socioboard.Models.User>(t => t.ExpiryDate.Date == dateTime.Date).ToList();
return(lstEmail);
}
public List <Groupmembers> Getgroupmembersbyid(Int64 id)
{
DateTime dateTime = DateTime.UtcNow;
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.Groupmembers> getallgroups = dbr.Find <Domain.Socioboard.Models.Groupmembers>(t => t.groupid == id).ToList();
return(getallgroups);
}
public List <TwitterAccount> GetTwitterAccountDetailsById(Int64 adminid)
{
DateTime dateTime = DateTime.UtcNow.Date;
SocioBoardMailSenderServices.Helper.DatabaseRepository dbr = new SocioBoardMailSenderServices.Helper.DatabaseRepository();
List <Domain.Socioboard.Models.TwitterAccount> getalltwtprofiles = dbr.Find <Domain.Socioboard.Models.TwitterAccount>(t => t.userId == adminid).ToList();
return(getalltwtprofiles);
}