public List <GroupType> GetAllGroupTypes() { List <GroupType> result = new List <GroupType>(); using (SPKTDataContext dc = conn.GetContext()) { result = dc.GroupTypes.OrderBy(gt => gt.Name).ToList(); } return(result); }
public StatusUpdate GetStatusUpdateByID(Int32 StatusUpdateID) { StatusUpdate result; using (SPKTDataContext dc = conn.GetContext()) { result = dc.StatusUpdates.Where(su => su.StatusUpdateID == StatusUpdateID).FirstOrDefault(); } return(result); }
public Comment GetCommentByID(long CommentID) { Comment result = null; using (SPKTDataContext dc = conn.GetContext()) { result = dc.Comments.Where(c => c.CommentID == CommentID).FirstOrDefault(); } return(result); }
public int GetGroupIdByForumID(int ForumID) { int result = 0; using (SPKTDataContext dc = conn.GetContext()) { result = dc.GroupForums.Where(gf => gf.ForumID == ForumID).Select(gf => gf.GroupID).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 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 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 <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 MessageFolder GetMessageFolderByID(Int32 MessageFolderID) { MessageFolder result = null; using (SPKTDataContext dc = conn.GetContext()) { result = dc.MessageFolders.Where(mf => mf.MessageFolderID == MessageFolderID).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 <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 List <Alert> GetAlertsByAccountID(Int32 AccountID) { List <Alert> result = new List <Alert>(); using (SPKTDataContext spktDC = conn.GetContext()) { IEnumerable <Alert> alerts = (from a in spktDC.Alerts where a.AccountID == AccountID orderby a.CreateDate descending select a).Take(20); result = alerts.ToList(); } return(result); }
public List <Notification> GetNotificationByAccountID(int AccountID, int n) { List <Notification> result = new List <Notification>(); using (SPKTDataContext spktDC = conn.GetContext()) { IEnumerable <Notification> notify = (from a in spktDC.Notifications where a.AccountID == AccountID orderby a.CreateDate descending select a).Take(n); result = notify.ToList(); } return(result); }
public List <ContentFilter> GetContentFilters() { List <ContentFilter> filters = new List <ContentFilter>(); using (SPKTDataContext dc = _conn.GetContext()) { filters = dc.ContentFilters.ToList(); } return(filters); }
public List <Permission> GetPermissionsByAccountID(int AccountID) { List <Permission> returnPermissions = new List <Permission>(); using (SPKTDataContext spktDC = conn.GetContext()) { var permissions = from p in spktDC.Permissions join ap in spktDC.AccountPermissions on p.PermissionID equals ap.PermissionID join a in spktDC.Accounts on ap.AccountID equals a.AccountID where a.AccountID == AccountID select p; foreach (Permission permission in permissions) { returnPermissions.Add(permission); } } return(returnPermissions); }
public int GetParameterByName(string Name) { ParameterInt parameterInt; using (SPKTDataContext spktDC = conn.GetContext()) { parameterInt = (from a in spktDC.ParameterInts where a.ParameterName == Name select a).FirstOrDefault(); } return(parameterInt.ParameterContent); }
public void SaveGroupTypesForGroup(List <long> SelectedGroupTypeIDs, int GroupID) { using (SPKTDataContext dc = conn.GetContext()) { //get a list of current selections List <long> currentTypes = dc.GroupToGroupTypes.Where(gt => gt.GroupID == GroupID).Select(gt => gt.GroupTypeID).ToList(); //make a list of items to delete List <long> itemsToDelete = currentTypes.Where(ct => !SelectedGroupTypeIDs.Contains(ct)).ToList(); //make a list of items to insert List <long> itemsToInsert = SelectedGroupTypeIDs.Where(s => !currentTypes.Contains(s)).ToList(); //delete grouptogrouptypes dc.GroupToGroupTypes.DeleteAllOnSubmit( dc.GroupToGroupTypes.Where(g => itemsToDelete.Contains(g.GroupTypeID) && g.GroupID == GroupID)); //create the actual objects to insert List <GroupToGroupType> typesToInsert = new List <GroupToGroupType>(); foreach (long l in itemsToInsert) { GroupToGroupType g = new GroupToGroupType() { GroupID = GroupID, GroupTypeID = l }; typesToInsert.Add(g); } //do the insert if (typesToInsert.Count > 0) { dc.GroupToGroupTypes.InsertAllOnSubmit(typesToInsert); } dc.SubmitChanges(); } }
public ProfileAttributeType GetProfileAttributeTypeByID(Int32 profileAttributeTypeID) { ProfileAttributeType result; using (SPKTDataContext spktspktDC = conn.GetContext()) { result = spktspktDC.ProfileAttributeTypes.Where(pat => pat.ProfileAttributeTypeID == profileAttributeTypeID).FirstOrDefault(); } return(result); }
public BoardForum GetForumByGroupID(Int32 GroupID) { BoardForum result; using (SPKTDataContext dc = _conn.GetContext()) { BoardForum forum = (from f in dc.BoardForums join gf in dc.GroupForums on f.ForumID equals gf.ForumID where gf.GroupID == GroupID select f).FirstOrDefault(); result = forum; } return(result); }
public bool CheckPostPageNameIsUnique(string PageName) { bool result; using (SPKTDataContext dc = _conn.GetContext()) { BoardPost bp = dc.BoardPosts.Where(p => p.PageName == PageName).FirstOrDefault(); if (bp != null) { result = false; } else { result = true; } } 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 File GetFileByID(Int64 FileID) { File file; using (SPKTDataContext dc = conn.GetContext()) { file = dc.Files.Where(f => f.FileID == FileID).FirstOrDefault(); if (file != null) { var fileType = dc.FileTypes.Where(ft => ft.FileTypeID == file.FileTypeID).FirstOrDefault(); file.Extension = fileType.Name; } } return(file); }
public Message GetMessageByID(int MessageID) { Message ms = null; using (SPKTDataContext spktDC = conn.GetContext()) { ms = (from a in spktDC.Messages where a.MessageID == MessageID select a).FirstOrDefault(); } return(ms); }
public Profile GetProfileByAccountID(int AccountID) { Profile profile; using (SPKTDataContext spktDC = conn.GetContext()) { profile = (from p in spktDC.Profiles where p.AccountID == AccountID select p).FirstOrDefault(); } return(profile); }
public Account GetAccountByID(int AccountID) { Account account = null; using (SPKTDataContext spktDC = conn.GetContext()) { account = (from a in spktDC.Accounts where a.AccountID == AccountID select a).FirstOrDefault(); } return(account); }
public Group GetGroupByForumID(int ForumID) { Group result = null; using (SPKTDataContext dc = conn.GetContext()) { result = (from g in dc.Groups join f in dc.GroupForums on g.GroupID equals f.GroupID where f.ForumID == ForumID select g).FirstOrDefault(); } return(result); }
public List <Folder> GetFoldersByAccountID(Int32 AccountID) { List <Folder> result = new List <Folder>(); string cache_key = "GetFoldersByAccountID_" + AccountID.ToString(); Stopwatch sw = new Stopwatch(); if (_cache.Exists(cache_key)) { sw.Reset(); sw.Start(); //TODO: bo tam de bien dich // result = XMLService.Deserialize<List<Folder>>(_cache.Get(cache_key).ToString()); sw.Stop(); //46ms from cache } else { sw.Reset(); sw.Start(); using (SPKTDataContext dc = conn.GetContext()) { var account = dc.Accounts.Where(a => a.AccountID == AccountID).FirstOrDefault(); IEnumerable <Folder> folders = (from f in dc.Folders where f.AccountID == AccountID orderby f.CreateDate descending select f); foreach (Folder folder in folders) { var fullPath = (from f in dc.Files join ft in dc.FileTypes on f.FileTypeID equals ft.FileTypeID where f.DefaultFolderID == folder.FolderID select new { FullPathToCoverImage = f.CreateDate.Year.ToString() + f.CreateDate.Month.ToString() + "/" + f.FileSystemName + "__S." + ft.Name }).FirstOrDefault(); if (fullPath != null) { folder.FullPathToCoverImage = fullPath.FullPathToCoverImage; } else { folder.FullPathToCoverImage = "default.jpg"; } if (account != null) { folder.Username = account.UserName; } } result = folders.ToList(); } sw.Stop(); //190ms from db //TODO: tam bo de compile //_cache.Set(cache_key, XMLService.Serialize(result)); } 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); }