public List <Blog> GetBlogsForIndexing(int PageNumber)
{
List <Blog> results = new List <Blog>();
using (SPKTDataContext dc = _conn.GetContext())
{
results = dc.Blogs.Skip(100 * (PageNumber - 1)).Take(100).ToList();
}
return(results);
}
public string fullname(Int32 AccounID)
{
string fullnames = "";
using (SPKTDataContext dc = conn.GetContext())
{
fullnames = (from a in dc.Accounts join b in dc.Profiles on a.AccountID equals b.AccountID where b.AccountID == AccounID select b.FullName).FirstOrDefault();
}
return(fullnames);
}
public MessageRecipient GetMessageRecipientByID(Int32 MessageRecipientID)
{
MessageRecipient result = null;
using (SPKTDataContext dc = conn.GetContext())
{
result = dc.MessageRecipients.Where(mr => mr.MessageRecipientID == MessageRecipientID).FirstOrDefault();
}
return(result);
}
public List <FriendInvitation> GetFriendInvitationsByAccountID(Int32 AccountID)
{
List <FriendInvitation> result = new List <FriendInvitation>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <FriendInvitation> friendInvitations = dc.FriendInvitations.Where(fi => fi.AccountID == AccountID);
result = friendInvitations.ToList();
}
return(result);
}
public List <LevelOfExperience> GetAllLevelOfExperiences()
{
List <LevelOfExperience> types = new List <LevelOfExperience>();
using (SPKTDataContext spktspktDC = conn.GetContext())
{
IEnumerable <LevelOfExperience> result = spktspktDC.LevelOfExperiences.OrderBy(l => l.SortOrder);
types = result.ToList();
}
return(types);
}
public Permission GetPermissionByID(int PermissionID)
{
Permission result;
using (SPKTDataContext spktDC = conn.GetContext())
{
result = spktDC.Permissions.Where(p => p.PermissionID == PermissionID).FirstOrDefault();
}
return(result);
}
public Friend GetFriendByID(Int32 FriendID)
{
Friend result;
using (SPKTDataContext dc = conn.GetContext())
{
result = dc.Friends.Where(f => f.FriendID == FriendID).FirstOrDefault();
}
return(result);
}
public BoardCategory GetCategoryByCategoryID(Int32 CategoryID)
{
BoardCategory result;
using (SPKTDataContext dc = _conn.GetContext())
{
BoardCategory bc = dc.BoardCategories.Where(c => c.CategoryID == CategoryID).FirstOrDefault();
result = bc;
}
return(result);
}
public List <BoardForum> GetForumsByCategoryID(Int32 CategoryID)
{
List <BoardForum> results;
using (SPKTDataContext dc = _conn.GetContext())
{
IEnumerable <BoardForum> forums = dc.BoardForums.Where(f => f.CategoryID == CategoryID);
results = forums.ToList();
}
return(results);
}
public BoardForum GetForumByID(Int32 ForumID)
{
BoardForum result;
using (SPKTDataContext dc = _conn.GetContext())
{
BoardForum forum = dc.BoardForums.Where(f => f.ForumID == ForumID).FirstOrDefault();
result = forum;
}
return(result);
}
public void AddPermission(Account account, Permission permission)
{
using (SPKTDataContext spktDC = conn.GetContext())
{
AccountPermission ap = new AccountPermission();
ap.AccountID = account.AccountID;
ap.PermissionID = permission.PermissionID;
spktDC.AccountPermissions.InsertOnSubmit(ap);
spktDC.SubmitChanges();
}
}
public MessageFolder GetMessageFolderByID(Int32 MessageFolderID)
{
MessageFolder result = null;
using (SPKTDataContext dc = conn.GetContext())
{
result = dc.MessageFolders.Where(mf => mf.MessageFolderID == MessageFolderID).FirstOrDefault();
}
return(result);
}
public List <MessageRecipient> GetMessageRecipientsByMessageID(Int32 MessageID)
{
List <MessageRecipient> result = new List <MessageRecipient>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <MessageRecipient> recipients = dc.MessageRecipients.Where(mr => mr.MessageID == MessageID);
result = recipients.ToList();
}
return(result);
}
public BoardPost GetPostByID(Int64 PostID)
{
BoardPost result = null;
using (SPKTDataContext dc = _conn.GetContext())
{
BoardPost post = dc.BoardPosts.Where(p => p.PostID == PostID).FirstOrDefault();
result = post;
}
return(result);
}
public Blog GetBlogByPageName(string PageName, Int32 AccountID)
{
Blog result = new Blog();
using (SPKTDataContext dc = _conn.GetContext())
{
result = dc.Blogs.Where(b => b.PageName == PageName && b.AccountID == AccountID).FirstOrDefault();
}
return(result);
}
public List <Group> GetGroupsOwnedByAccount(Int32 AccountID)
{
List <Group> result = new List <Group>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <Group> groups = dc.Groups.Where(g => g.AccountID == AccountID);
result = groups.ToList();
}
return(result);
}
public List <int> GetMemberAccountIDsByGroupID(Int32 GroupID)
{
List <int> result = new List <int>();
using (SPKTDataContext dc = conn.GetContext())
{
result = dc.GroupMembers.Where(gm => gm.IsApproved && gm.GroupID == GroupID).Select(gm => gm.AccountID).ToList();
result.Add(dc.Groups.Where(g => g.GroupID == GroupID).Select(gm => gm.AccountID).FirstOrDefault());
}
return(result);
}
public BoardForum GetForumByPageName(string PageName)
{
BoardForum result;
using (SPKTDataContext dc = _conn.GetContext())
{
BoardForum forum = dc.BoardForums.Where(f => f.PageName == PageName).FirstOrDefault();
result = forum;
}
return(result);
}
public void SaveGroupForum(GroupForum groupForum)
{
using (SPKTDataContext dc = conn.GetContext())
{
if (dc.GroupForums.Where(gf => gf.ForumID == groupForum.ForumID && gf.GroupID == groupForum.GroupID).FirstOrDefault() == null)
{
dc.GroupForums.InsertOnSubmit(groupForum);
dc.SubmitChanges();
}
}
}
public List <BoardForum> GetAllForums()
{
List <BoardForum> results;
using (SPKTDataContext dc = _conn.GetContext())
{
IEnumerable <BoardForum> forums = dc.BoardForums;
results = forums.ToList();
}
return(results);
}
public List <PrivacyFlagType> GetPrivacyFlagTypes()
{
List <PrivacyFlagType> result = new List <PrivacyFlagType>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <PrivacyFlagType> query = dc.PrivacyFlagTypes.OrderBy(pft => pft.SortOrder);
result = query.ToList();
}
return(result);
}
public List <BoardCategory> GetAllCategories()
{
List <BoardCategory> result;
using (SPKTDataContext dc = _conn.GetContext())
{
IEnumerable <BoardCategory> categories = dc.BoardCategories.Where(c => c.CategoryID != 8); //don't get the groups category
result = categories.ToList();
}
return(result);
}
public List <VisibilityLevel> GetVisibilityLevels()
{
List <VisibilityLevel> result = new List <VisibilityLevel>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <VisibilityLevel> query = dc.VisibilityLevels;
result = query.ToList();
}
return(result);
}
public Permission GetPermissionByName(string Name)
{
Permission result;
using (SPKTDataContext spktDC = conn.GetContext())
{
result = spktDC.Permissions.Where(p => p.Name == Name).FirstOrDefault();
}
return(result);
}
public List <PrivacyFlag> GetPrivacyFlagsByProfileID(Int32 ProfileID)
{
List <PrivacyFlag> result = new List <PrivacyFlag>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <PrivacyFlag> query = dc.PrivacyFlags.Where(pf => pf.ProfileID == ProfileID);
result = query.ToList();
}
return(result);
}
public void DeleteFile(File file)
{
using (SPKTDataContext dc = conn.GetContext())
{
Folder folder = dc.Folders.Where(f => f.FolderID == file.DefaultFolderID).FirstOrDefault();
DeleteFileFromFileSystem(folder, file);
dc.Files.Attach(file, true);
dc.Files.DeleteOnSubmit(file);
dc.SubmitChanges();
}
}
public List <Group> GetLatestGroups()
{
List <Group> results = new List <Group>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <Group> groups = dc.Groups.OrderByDescending(g => g.UpdateDate).Take(50);
results = groups.ToList();
}
return(results);
}
public void SaveGroupToGroupType(GroupToGroupType groupToGroupType)
{
using (SPKTDataContext dc = conn.GetContext())
{
if (dc.GroupToGroupTypes.Where(gt => gt.GroupID == groupToGroupType.GroupID && gt.GroupTypeID == groupToGroupType.GroupTypeID).FirstOrDefault() == null)
{
dc.GroupToGroupTypes.InsertOnSubmit(groupToGroupType);
dc.SubmitChanges();
}
}
}
public BoardPost GetPostByPageName(string PageName)
{
BoardPost result = null;
using (SPKTDataContext dc = _conn.GetContext())
{
BoardPost post = dc.BoardPosts.Where(p => p.PageName == PageName).FirstOrDefault();
result = post;
}
return(result);
}
public ProfileAttribute GetProfileAttributesByProfileIDAndTypeID(Int32 ProfileID, Int32 TypeID)
{
ProfileAttribute attribute;
using (SPKTDataContext spktDC = conn.GetContext())
{
attribute = (from t in spktDC.ProfileAttributes
where t.ProfileID == ProfileID && t.ProfileAttributeTypeID == TypeID
select t).FirstOrDefault();
}
return(attribute);
}
