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