public static void UpdateSortOrder(ListEntryInfo listEntryInfo)
{
using (VanjaroRepo db = new VanjaroRepo())
{
db.Execute("UPDATE " + Core.Data.Scripts.CommonScript.TablePrefix + "LISTS SET SORTORDER=@0 WHERE ENTRYID=@1 AND LISTNAME=@2", listEntryInfo.SortOrder, listEntryInfo.EntryID, listEntryInfo.ListName);
}
}
internal static void MigrateToVanjaro(PortalSettings PortalSettings)
{
TabInfo Tab = TabController.Instance.GetTab(PortalSettings.ActiveTab.TabID, PortalSettings.Current.PortalId);
if (Tab != null && Tab.TabID > 0)
{
try
{
Tab.SkinSrc = "[g]skins/vanjaro/base.ascx";
Tab.ContainerSrc = "[g]containers/vanjaro/base.ascx";
using (VanjaroRepo db = new VanjaroRepo())
{
db.Execute(PortalScript.UpdateTabContainerSrc(PortalSettings.Current.PortalId, Tab.TabID));
}
//Clear Cache for all TabModules
foreach (ModuleInfo tabModule in ModuleController.Instance.GetTabModules(Tab.TabID).Values)
{
DataCache.RemoveCache(string.Format(DataCache.SingleTabModuleCacheKey, tabModule.TabModuleID));
}
DataCache.ClearModuleCache(Tab.TabID);
TabController.Instance.UpdateTab(Tab);
}
catch (Exception)
{
}
}
}
internal static void AddUpdateProperty(List <Localization> Localizations)
{
VanjaroRepo db = VanjaroRepo.GetInstance();
using (Transaction scope = db.GetTransaction())
{
try
{
foreach (Localization localization in Localizations)
{
if (localization.LocalizationID > 0)
{
localization.Update();
}
else
{
localization.Insert();
}
}
scope.Complete();
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
}
}
public static void DeleteDefaultMemberProfileProperties()
{
try
{
using (VanjaroRepo vrepo = new VanjaroRepo())
{
vrepo.Execute("Delete from ProfilePropertyDefinition Where PortalID Is NUll AND PropertyName !=@0", "PreferredTimeZone");
}
}
catch (Exception) { }
}
private static void UpdatePortalSettings(List <StringValue> SettingNameValue, int PortalID, int UserID)
{
string query = string.Empty;
foreach (StringValue setting in SettingNameValue)
{
query += PortalScript.UpdatePortalSettings(setting.Text, setting.Value, PortalID, UserID);
}
using (VanjaroRepo db = new VanjaroRepo())
{
db.Execute(query);
}
}
internal static List <WorkflowPermissionInfo> GetPermissionByCode(string Code)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Workflow + "GetPermissionByCode", Code);
List <WorkflowPermissionInfo> _WorkflowStatePermInfo = CacheFactory.Get(CacheKey) as List <WorkflowPermissionInfo>;
if (_WorkflowStatePermInfo == null)
{
using (VanjaroRepo db = new VanjaroRepo())
{
_WorkflowStatePermInfo = db.Query <WorkflowPermissionInfo>("SELECT p.* FROM " + Data.Scripts.CommonScript.DnnTablePrefix + "Permission AS p WHERE p.PermissionCode = @0", Code).ToList();
}
CacheFactory.Set(CacheKey, _WorkflowStatePermInfo);
}
return(_WorkflowStatePermInfo);
}
public static void SoftDeleteModule(int PortalId, string ModuleFriendlyName)
{
try
{
using (VanjaroRepo vrepo = new VanjaroRepo())
{
ModuleDefinitionInfo moduleDefinitionInfo = ModuleDefinitionController.GetModuleDefinitionByFriendlyName(ModuleFriendlyName);
System.Collections.Generic.List <ModuleSettings> moduleInfo = vrepo.Fetch <ModuleSettings>("Select T.PortalID,Tabm.TabID,Tabm.ModuleID,Tabm.PaneName,Tabm.IsDeleted from TabModules Tabm inner join Tabs T On Tabm.TabID = t.TabID Where PortalID=@0 AND ModuleTitle= @1", PortalId, ModuleFriendlyName);
foreach (ModuleSettings ModuleSettings in moduleInfo)
{
ModuleController.Instance.DeleteTabModule(ModuleSettings.TabID, ModuleSettings.ModuleID, true);
}
}
}
catch (Exception) { }
}
internal static string GetHTMLText(ModuleInfo m)
{
string HtmlContent = string.Empty;
Sql sql = new Sql();
sql.Append("SELECT TOP 1 * FROM " + Core.Data.Scripts.CommonScript.TablePrefix + "HtmlText WHERE ModuleID=@0 ORDER BY [Version] DESC", m.ModuleID);
using (VanjaroRepo db = new VanjaroRepo())
{
dynamic data = db.Fetch <dynamic>(sql).FirstOrDefault();
if (data != null && data.Content != null)
{
HtmlContent = data.Content;
}
}
return(HtmlContent);
}
internal static List <StringValue> GetStatesforReview(int PortalID, int UserID)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Workflow + "GetStatesforReview" + "PortalID", UserID, PortalID);
List <StringValue> result = CacheFactory.Get(CacheKey) as List <StringValue>;
if (result == null)
{
Sql Query = WorkflowScript.GetStatesforPendingReview(PortalID, UserID);
using (VanjaroRepo db = new VanjaroRepo())
{
result = db.Fetch <StringValue>(Query).ToList();
}
CacheFactory.Set(CacheKey, result);
}
return(result);
}
internal static List <WorkflowPage> GetReviewPagesbyUserID(int UserID, int Page, int PageSize, int StateID)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Workflow + "GetReviewPagesbyUserID", UserID, Page, PageSize, StateID);
List <WorkflowPage> Pages = CacheFactory.Get(CacheKey) as List <WorkflowPage>;
if (Pages == null)
{
Sql Query = WorkflowScript.GetPagesByUserID(UserID, Page, PageSize, StateID);
using (VanjaroRepo db = new VanjaroRepo())
{
Pages = db.Fetch <WorkflowPage>(Query).ToList();
}
CacheFactory.Set(CacheKey, Pages);
}
return(Pages);
}
internal static List <Pages> GetAllPublishedPages(int portalID, string Locale)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Page, portalID, "AllPublishedPages", Locale);
List <Pages> pages = CacheFactory.Get(CacheKey);
if (pages == null || pages.Count == 0)
{
Sql Query = PageScript.GetAllPublishedPages(portalID, Locale);
using (VanjaroRepo db = new VanjaroRepo())
{
pages = db.Fetch <Pages>(Query).ToList();
}
CacheFactory.Set(CacheKey, pages);
}
return(pages);
}
internal static int GetReviewPagesCountByUserID(int UserID, int Page, int PageSize, int StateID)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Workflow + "GetReviewPagesCountByUserID", UserID, Page, PageSize, StateID);
int? Count = CacheFactory.Get(CacheKey);
if (Count == null)
{
Count = 0;
Sql Query = WorkflowScript.GetPagesCountByUserID(UserID, StateID);
using (VanjaroRepo db = new VanjaroRepo())
{
Count = db.Fetch <int>(Query).FirstOrDefault();
}
CacheFactory.Set(CacheKey, Count);
}
return(Count.Value);
}
internal static List <WorkflowPage> GetPagesbyUserID(int PortalID, int UserID)
{
string CacheKey = CacheFactory.GetCacheKey(CacheFactory.Keys.Workflow + "GetPagesbyUserID" + "PortalID", UserID, PortalID);
List <WorkflowPage> WorkflowPages = CacheFactory.Get(CacheKey) as List <WorkflowPage>;
if (WorkflowPages == null)
{
Sql Query = WorkflowScript.GetPagesByUserID(PortalID, UserID);
using (VanjaroRepo db = new VanjaroRepo())
{
WorkflowPages = db.Fetch <WorkflowPage>(Query).ToList();
}
CacheFactory.Set(CacheKey, WorkflowPages);
}
return(WorkflowPages);
}
public static void AddUpdateLoginModule(int TabID, int PortalId)
{
try
{
using (VanjaroRepo vrepo = new VanjaroRepo())
{
LoginModule loginModule = null;
ModuleDefinitionInfo moduleDefinitionInfo = ModuleDefinitionController.GetModuleDefinitionByFriendlyName(Components.Constants.AccountLogin);
System.Collections.Generic.List <LoginModule> moduleInfo = vrepo.Fetch <LoginModule>("Select T.PortalID,Tabm.TabID,Tabm.ModuleID,Tabm.PaneName,Tabm.IsDeleted from TabModules Tabm inner join Tabs T On Tabm.TabID = t.TabID Where PortalID=@0 AND ModuleTitle= @1", PortalId, Components.Constants.AccountLogin);
foreach (LoginModule d in moduleInfo)
{
loginModule = d;
}
if (loginModule == null)
{
ModuleInfo module = new ModuleInfo
{
PortalID = PortalId,
TabID = TabID,
ModuleOrder = 1,
ModuleTitle = moduleDefinitionInfo.FriendlyName,
PaneName = "ContentPane",
ModuleDefID = moduleDefinitionInfo.ModuleDefID,
CacheTime = moduleDefinitionInfo.DefaultCacheTime,
InheritViewPermissions = true,
AllTabs = false
};
int ModuleID = ModuleController.Instance.AddModule(module);
ModuleController.Instance.DeleteTabModule(TabID, ModuleID, true);
}
else
{
ModuleController.Instance.MoveModule(loginModule.ModuleID, loginModule.TabID, TabID, loginModule.PaneName);
if (!loginModule.IsDeleted)
{
ModuleController.Instance.DeleteTabModule(TabID, loginModule.ModuleID, true);
}
}
}
}
catch (Exception exc) { Exceptions.LogException(exc); }
}
