public Tenant GetTenantByUsername(string username)
{
var tenants = AdoHelper.ExecCachedListProc <Tenant>("sp_admin_tenants_select", false);
var tenant = (from x in tenants where x.UserName.Equals(username) select x).FirstOrDefault();
return(tenant);
}
private List <LogSystem> GetAllItems()
{
return(AdoHelper.ExecCachedListProc <LogSystem>("sp_cms_LogSystem_select", true));
}
private List <SysVar> GetAllItems()
{
return(AdoHelper.ExecCachedListProc <SysVar>("sp_cms_SysVar_select", true));
}
private List <SubscriptionStatus> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <SubscriptionStatus>("sp_cms_subscription_statuses_select", force));
}
private List <User> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <User>("sp_admin_users_select", force));
}
private List <SharedContent> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <SharedContent>("sp_cms_shared_content_select", force));
}
private List <Group> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <Group>("sp_admin_groups_select", force));
}
private List <ContentTemplate> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <ContentTemplate>("sp_cms_content_templates_select", force));
}
private List <SubscriptionConfiguration> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <SubscriptionConfiguration>("sp_cms_subscriptions_config_select", force));
}
private List <Country> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <Country>("sp_cms_countries_select", force));
}
private List <MediaItem> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <MediaItem>("sp_cms_media_items_select", force, true, OverwriteResult));
}
private List <MediaType> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <MediaType>("sp_cms_media_types_select", force));
}
private List <Tenant> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <Tenant>("sp_admin_tenants_select", force));
}
private List <GlobalConfiguration> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <GlobalConfiguration>("sp_cms_global_configuration_select", force));
}
private List <ConfigEvent> GetAllItems()
{
return(AdoHelper.ExecCachedListProc <ConfigEvent>("sp_cms_config_events_select", true));
}
private List <AdminPage> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <AdminPage>("sp_admin_pages_select", force, false));
}
private List <NewsComment> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <NewsComment>("sp_cms_news_comments_select", force));
}
private List <MediaGallery> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <MediaGallery>("sp_cms_media_galleries_select", force));
}
private List <TransactionLog> GetAllItems()
{
return(AdoHelper.ExecCachedListProc <TransactionLog>("sp_cms_TransactionLog_select", true));
}
private List <SingleNews> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <SingleNews>("sp_cms_news_select", force));
}
private List <NewsCategory> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <NewsCategory>("sp_cms_news_categories_select", force));
}
private List <PageLanguage> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <PageLanguage>("sp_cms_pages_languages_select", force));
}
private List <NewsConfiguration> GetAllItems(bool force = false)
{
return(AdoHelper.ExecCachedListProc <NewsConfiguration>("sp_cms_news_config_select", force));
}