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);
}