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