public static int CreateFavorite(UserContent userContent)
{
var provider = SueetieDataProvider.LoadProvider();
var favoriteID = provider.CreateFavorite(userContent);
ClearFavoriteContentListCache(userContent.UserID);
return(favoriteID);
}
public static int CreateUpdateSueetieBlogPost(SueetieBlogPost sueetieBlogPost)
{
var provider = SueetieDataProvider.LoadProvider();
var contentId = provider.CreateUpdateSueetieBlogPost(sueetieBlogPost);
ClearBlogPostListCache(sueetieBlogPost);
return(contentId);
}
public static int AddForumTopic(SueetieForumContent sueetieForumContent)
{
var provider = SueetieDataProvider.LoadProvider();
var contentId = provider.AddForumTopic(sueetieForumContent);
ClearForumTopicListCache(sueetieForumContent);
return(contentId);
}
public static UserContent DeleteFavorite(UserContent userContent)
{
var provider = SueetieDataProvider.LoadProvider();
var _userContent = provider.DeleteFavorite(userContent);
ClearFavoriteContentListCache(userContent.UserID);
return(_userContent);
}
public static void CreatePageRule(string urlExcerpt, string urlFinal, string pageTitle, string isEqual)
{
var provider = SueetieDataProvider.LoadProvider();
provider.CreatePageRule(new PageRule {
UrlExcerpt = urlExcerpt, UrlFinal = urlFinal, PageTitle = pageTitle, IsEqual = isEqual.ToBoolean()
});
SueetieCache.Current.Remove(PageRuleListCacheKey());
}
public static void EnterContentPageTags(SueetieTagEntry sueetieTagEntry)
{
var provider = SueetieDataProvider.LoadProvider();
provider.EnterContentPageTags(sueetieTagEntry);
ClearSueetieContentPageListCache(GetSueetieContentPage(sueetieTagEntry.ItemID).ContentPageGroupID);
ClearSueetieContentPageListCache(-1);
}
public static List <SueetieBlogComment> GetSueetieBlogCommentList(ContentQuery contentQuery)
{
var provider = SueetieDataProvider.LoadProvider();
var key = BlogCommentListCacheKey(contentQuery);
var cachedSueetieBlogComments = SueetieCache.Current[key] as List <SueetieBlogComment>;
if (cachedSueetieBlogComments != null)
{
if (contentQuery.NumRecords > 0)
{
return(cachedSueetieBlogComments.Take(contentQuery.NumRecords).ToList());
}
return(cachedSueetieBlogComments.ToList());
}
var sueetieBlogComments = from p in provider.GetSueetieBlogCommentList(contentQuery)
select p;
if (contentQuery.GroupID > -1)
{
sueetieBlogComments = from g in sueetieBlogComments where g.GroupID == contentQuery.GroupID select g;
}
if (contentQuery.ApplicationID > 0)
{
sueetieBlogComments = from a in sueetieBlogComments where a.ApplicationID == contentQuery.ApplicationID select a;
}
if (contentQuery.UserID > 0)
{
sueetieBlogComments = from u in sueetieBlogComments where u.UserID == contentQuery.UserID select u;
}
if (contentQuery.IsRestricted)
{
sueetieBlogComments = from r in sueetieBlogComments where r.IsRestricted == false select r;
}
if (contentQuery.NumRecords > 0)
{
sueetieBlogComments = from n in sueetieBlogComments.Take(contentQuery.NumRecords) select n;
}
if (contentQuery.CacheMinutes > 0)
{
SueetieCache.Current.InsertMinutes(key, sueetieBlogComments.ToList(), contentQuery.CacheMinutes);
}
else
{
SueetieCache.Current.InsertMax(key, sueetieBlogComments.ToList());
}
return(sueetieBlogComments.ToList());
}
public static void DeleteSueetieRole(string rolename)
{
var dp = SueetieDataProvider.LoadProvider();
var wasDeleted = dp.DeleteSueetieRole(rolename);
if (wasDeleted)
{
Roles.DeleteRole(rolename);
ClearRolesListCache();
}
}
public static SueetieWikiMessage GetSueetieWikiMessage(string messageQueryID)
{
var _sueetieWikiMessage = GetSueetieWikiMessageList().Find(m => m.MessageQueryID == messageQueryID);
if (_sueetieWikiMessage == null)
{
var provider = SueetieDataProvider.LoadProvider();
_sueetieWikiMessage = provider.GetSueetieWikiMessage(messageQueryID);
}
return(_sueetieWikiMessage);
}
public static SueetieUser GetSueetieUserFromForumId(int forumUserId)
{
var sueetieUser = SueetieUsers.GetSueetieUserList(SueetieUserType.RegisteredUser).Find(u => u.ForumUserID == forumUserId);
if (sueetieUser == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieUser = provider.GetSueetieUserFromForumID(forumUserId);
}
return(sueetieUser);
}
public static void PerformRequestLogInsert(SueetieRequest sueetieRequest)
{
try
{
var provider = SueetieDataProvider.LoadProvider();
provider.AddSueetieRequest(sueetieRequest);
}
catch (Exception ex)
{
SueetieLogs.LogException("Analytics Logging Error: " + HttpContext.Current.Request.RawUrl + " : " + ex.Message + " STACK TRACE: " + ex.StackTrace);
}
}
public static SueetieForumTopic GetSueetieForumTopic(int topicId)
{
var content = new SueetieForumContent
{
TopicID = topicId,
ApplicationID = 2,
ContentTypeID = (int)SueetieContentType.ForumTopic
};
var provider = SueetieDataProvider.LoadProvider();
return(provider.GetSueetieForumTopic(content));
}
public static void UpdateUserLogCategory(bool isDisplayed, bool isSyndicated, int userLogCategoryId)
{
var userLogCategory = new UserLogCategory
{
UserLogCategoryID = userLogCategoryId,
IsDisplayed = isDisplayed,
IsSyndicated = isSyndicated
};
var provider = SueetieDataProvider.LoadProvider();
provider.UpdateUserLogCategory(userLogCategory);
}
public static void AdminUpdateSueetieMediaAlbum(int albumId, int contentTypeId, int contentId)
{
var sueetieMediaAlbum = new SueetieMediaAlbum
{
AlbumID = albumId,
ContentTypeID = contentTypeId,
ContentID = contentId
};
var provider = SueetieDataProvider.LoadProvider();
provider.AdminUpdateSueetieMediaAlbum(sueetieMediaAlbum);
}
public static List <SueetieContentPart> GetSueetieContentPartList(int pageId)
{
var key = SueetieContentPartListCacheKey(pageId);
var sueetieContentParts = SueetieCache.Current[key] as List <SueetieContentPart>;
if (sueetieContentParts == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieContentParts = provider.GetSueetieContentPartList(pageId);
SueetieCache.Current.Insert(key, sueetieContentParts);
}
return(sueetieContentParts);
}
public static SueetieUserProfile GetSueetieUserProfile(int userID)
{
var userProfileCacheKey = UserProfileCacheKey(userID);
var sueetieUserProfile = SueetieCache.Current[userProfileCacheKey] as SueetieUserProfile;
if (sueetieUserProfile == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieUserProfile = provider.GetSueetieUserProfile(userID);
SueetieCache.Current.InsertMinutes(userProfileCacheKey, sueetieUserProfile, 5);
}
return(sueetieUserProfile);
}
public static List <ContentTypeDescription> GetAlbumContentTypeDescriptionList()
{
var key = AlbumContentTypeDescriptionCacheKey();
var albumContentTypeDescriptionList = SueetieCache.Current[key] as List <ContentTypeDescription>;
if (albumContentTypeDescriptionList == null)
{
var provider = SueetieDataProvider.LoadProvider();
albumContentTypeDescriptionList = provider.GetAlbumContentTypeDescriptionList();
SueetieCache.Current.Insert(key, albumContentTypeDescriptionList);
}
return(albumContentTypeDescriptionList);
}
public static SueetieContentPage GetSueetieContentPage(int pageId)
{
var key = SueetieContentPageCacheKey(pageId);
var sueetieContentPage = SueetieCache.Current[key] as SueetieContentPage;
if (sueetieContentPage == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieContentPage = provider.GetSueetieContentPage(pageId);
SueetieCache.Current.Insert(key, sueetieContentPage);
}
return(sueetieContentPage);
}
public static List <SueetieBlog> GetSueetieBlogList(ApplicationQuery applicationQuery)
{
var provider = SueetieDataProvider.LoadProvider();
var key = BlogListCacheKey(applicationQuery);
var cachedSueetieBlogs = SueetieCache.Current[key] as List <SueetieBlog>;
if (cachedSueetieBlogs != null)
{
if (applicationQuery.NumRecords > 0)
{
return(cachedSueetieBlogs.Take(applicationQuery.NumRecords).ToList());
}
return(cachedSueetieBlogs.ToList());
}
var sueetieBlogs = from p in provider.GetSueetieBlogList(applicationQuery)
select p;
if (applicationQuery.GroupID > -1)
{
sueetieBlogs = from g in sueetieBlogs where g.GroupID == applicationQuery.GroupID select g;
}
if (applicationQuery.CategoryID > 0)
{
sueetieBlogs = from a in sueetieBlogs where a.CategoryID == applicationQuery.CategoryID select a;
}
if (applicationQuery.IsRestricted)
{
sueetieBlogs = from r in sueetieBlogs where r.BlogAccessRole == null select r;
}
if (applicationQuery.CacheMinutes > 0)
{
SueetieCache.Current.InsertMinutes(key, sueetieBlogs.ToList(), applicationQuery.CacheMinutes);
}
else
{
SueetieCache.Current.InsertMax(key, sueetieBlogs.ToList());
}
if (applicationQuery.NumRecords > 0)
{
return(sueetieBlogs.Take(applicationQuery.NumRecords).ToList());
}
return(sueetieBlogs.ToList());
}
public static List <SueetieWikiMessage> GetSueetieWikiMessageList()
{
var key = SueetieWikiMessageListCacheKey();
var sueetieWikiMessages = SueetieCache.Current[key] as List <SueetieWikiMessage>;
if (sueetieWikiMessages == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieWikiMessages = provider.GetSueetieWikiMessageList();
SueetieCache.Current.Insert(key, sueetieWikiMessages);
}
return(sueetieWikiMessages);
}
public static SueetieContentPart GetSueetieContentPart(string contentName)
{
var key = ContentPartCacheKey(contentName);
var sueetieContentPart = SueetieCache.Current[key] as SueetieContentPart;
if (sueetieContentPart == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieContentPart = provider.GetSueetieContentPart(contentName);
SueetieCache.Current.Add(key, sueetieContentPart, null, DateTime.Now.AddMinutes(1), Cache.NoSlidingExpiration, CacheItemPriority.Normal, null);
}
return(sueetieContentPart);
}
public static void UpdateSueetieUserAvatar(SueetieUserAvatar sueetieUserAvatar)
{
var provider = SueetieDataProvider.LoadProvider();
provider.UpdateSueetieUserAvatar(sueetieUserAvatar);
var cookie = HttpContext.Current.Request.Cookies["SueetieUserProfile"];
if (cookie != null)
{
cookie["AvatarRoot"] = sueetieUserAvatar.UserID.ToString();
HttpContext.Current.Response.Cookies.Add(cookie);
}
}
public static void CreateUserLogCategory(int catId, string catCode, string catDesc, bool isDisplayed, bool isSyndicated)
{
var userLogCategory = new UserLogCategory
{
UserLogCategoryID = catId,
UserLogCategoryCode = catCode,
UserLogCategoryDescription = catDesc,
IsDisplayed = isDisplayed,
IsSyndicated = isSyndicated
};
var provider = SueetieDataProvider.LoadProvider();
provider.CreateUserLogCategory(userLogCategory);
}
public static void DeleteAvatar(int _userID)
{
var provider = SueetieDataProvider.LoadProvider();
provider.DeleteAvatar(_userID);
var cookie = HttpContext.Current.Request.Cookies["SueetieUserProfile"];
if (cookie != null)
{
cookie["AvatarRoot"] = "0";
HttpContext.Current.Response.Cookies.Add(cookie);
}
}
public static void UpdateSueetieRole(bool isGroupAdminRole, bool isGroupUserRole, bool isBlogOwnerRole, string RoleName)
{
var provider = SueetieDataProvider.LoadProvider();
var _role = new SueetieRole
{
RoleName = RoleName,
IsGroupUserRole = isGroupUserRole,
IsGroupAdminRole = isGroupAdminRole,
IsBlogOwnerRole = isBlogOwnerRole
};
provider.UpdateSueetieRole(_role);
ClearRolesListCache();
}
public static List <SueetieTag> GetSueetieTagCloudList(SueetieTagQuery sueetieTagQuery)
{
var key = SueetieTagCloudListCacheKey(sueetieTagQuery.ApplicationTypeID);
var sueetieTags = SueetieCache.Current[key] as List <SueetieTag>;
if (sueetieTags == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieTags = provider.GetSueetieTagCloudList(sueetieTagQuery);
SueetieCache.Current.InsertMinutes(key, sueetieTags, 10);
}
return(sueetieTags);
}
public static List <PageRule> GetPageRuleList()
{
var key = PageRuleListCacheKey();
var pageRules = SueetieCache.Current[key] as List <PageRule>;
if (pageRules == null)
{
var provider = SueetieDataProvider.LoadProvider();
pageRules = provider.GetPageRuleList();
SueetieCache.Current.Insert(key, pageRules);
}
return(pageRules);
}
//private static readonly Regex FILTEREDURL_REGEX = new Regex(GetFilteredUrlList().Aggregate((i, j) => i + "|" + j), RegexOptions.IgnoreCase | RegexOptions.Compiled);
public static List <string> GetFilteredUrlList()
{
var provider = SueetieDataProvider.LoadProvider();
var key = FilteredUrlListCacheKey();
var filteredUrls = SueetieCache.Current[key] as List <string>;
if (filteredUrls == null)
{
filteredUrls = provider.GetFilteredUrlList();
SueetieCache.Current.Insert(key, filteredUrls);
}
return(filteredUrls);
}
public static List <SueetieApplication> GetSueetieApplicationsList()
{
var key = SueetieApplicationListCacheKey();
var sueetieApplications = SueetieCache.Current[key] as List <SueetieApplication>;
if (sueetieApplications == null)
{
var provider = SueetieDataProvider.LoadProvider();
sueetieApplications = provider.GetSueetieApplicationList();
SueetieCache.Current.InsertMax(key, sueetieApplications);
}
return(sueetieApplications);
}
public static List <CrawlerAgent> GetCrawlerAgentList()
{
var key = CrawlerAgentListCacheKey();
var crawlerAgents = SueetieCache.Current[key] as List <CrawlerAgent>;
if (crawlerAgents == null)
{
var provider = SueetieDataProvider.LoadProvider();
crawlerAgents = provider.GetCrawlerAgentList();
SueetieCache.Current.Insert(key, crawlerAgents);
}
return(crawlerAgents);
}
