public ActionResult Index()
{
ViewBag.CanMigrate = false;
if (_featureManager.GetEnabledFeatures().All(x => x.Id != "Orchard.Taxonomies"))
{
_orchardServices.Notifier.Warning(T("You need to enable Orchard.Taxonomies in order to migrate Contrib.Taxonomies to Orchard.Taxonomies."));
}
else
{
var flag = false;
_upgradeService.ExecuteReader("SELECT * FROM " + _upgradeService.GetPrefixedTableName("Orchard_Taxonomies_TermContentItem"), (reader, conn) => {
flag = true;
});
if (flag)
{
_orchardServices.Notifier.Warning(T("This migration step might have been done already."));
}
ViewBag.CanMigrate = true;
}
return(View());
}
public ActionResult Index()
{
var found = false;
var activityTable = _upgradeService.GetPrefixedTableName("Orchard_Workflows_ActivityRecord");
if (_upgradeService.TableExists(activityTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + activityTable + " WHERE Name = 'SendEmail'",
(reader, connection) => {
found = true;
});
if (!found)
{
_orchardServices.Notifier.Warning(T("This step is unnecessary as no Send Email activities were found."));
}
}
else
{
_orchardServices.Notifier.Warning(T("This step appears unnecessary since it appears Orchard Workflows is not enabled."));
}
return(View());
}
public int Create()
{
_upgradeService.ExecuteReader("SELECT * FROM " + _upgradeService.GetPrefixedTableName("Piedone_Combinator_CombinatorSettingsPartRecord"),
(reader, connection) =>
{
var part = _siteService.GetSiteSettings().As <CombinatorSettingsPart>();
part.CombinationExcludeRegex = reader["CombinationExcludeRegex"] as string;
part.CombineCdnResources = (bool)reader["CombineCdnResources"];
part.EnableForAdmin = (bool)reader["EnableForAdmin"];
part.MinifyResources = (bool)reader["MinifyResources"];
part.MinificationExcludeRegex = reader["MinificationExcludeRegex"] as string;
part.EmbedCssImages = (bool)reader["EmbedCssImages"];
part.EmbeddedImagesMaxSizeKB = (int)reader["EmbeddedImagesMaxSizeKB"];
part.EmbedCssImagesStylesheetExcludeRegex = reader["EmbedCssImagesStylesheetExcludeRegex"] as string;
part.GenerateImageSprites = (bool)reader["GenerateImageSprites"];
part.ResourceSetRegexes = reader["ResourceSetRegexes"] as string;
});
_upgradeService.ExecuteReader("DROP TABLE " + _upgradeService.GetPrefixedTableName("Piedone_Combinator_CombinatorSettingsPartRecord"), null);
return(1);
}
public ActionResult IndexPOST()
{
if (!_orchardServices.Authorizer.Authorize(StandardPermissions.SiteOwner, T("Not allowed to migrate Orchard.ContentPicker.")))
{
return(new HttpUnauthorizedResult());
}
try {
_upgradeService.ExecuteReader("DELETE FROM " + _upgradeService.GetPrefixedTableName("Orchard_ContentPicker_ContentMenuItemPartRecord"), null);
_upgradeService.CopyTable("Navigation_ContentMenuItemPartRecord", "Orchard_ContentPicker_ContentMenuItemPartRecord", new string[0]);
_orchardServices.Notifier.Information(T("Content Picker menu items were migrated successfully."));
}
catch (Exception e) {
Logger.Error(e, "Unexpected error while migrating to Orchard.ContentPicker. Please check the log.");
_orchardServices.Notifier.Error(T("Unexpected error while migrating to Orchard.ContentPicker. Please check the log."));
}
return(RedirectToAction("Index"));
}
// Migrating versioned SeoGlobalSettingsPartRecord entries to versioned infoset.
public int Create()
{
var tableName = _upgradeService.GetPrefixedTableName("Onestop_SEO_SeoGlobalSettingsPartRecord");
IEnumerable <ContentItem> allVersions = null;
if (_upgradeService.TableExists(tableName))
{
_upgradeService.ExecuteReader(string.Format("SELECT * FROM {0}", tableName),
(reader, connection) => {
if (allVersions == null)
{
allVersions = _contentManager.GetAllVersions((int)reader["ContentItemRecord_id"]);
}
var item = allVersions.FirstOrDefault(p => p.VersionRecord.Id == ConvertFromDBValue <int>(reader["Id"]));
if (item != null && item.Has <SeoGlobalSettingsPart>())
{
var part = item.As <SeoGlobalSettingsPart>();
part.HomeTitle = ConvertFromDBValue <string>(reader["HomeTitle"]);
part.HomeDescription = ConvertFromDBValue <string>(reader["HomeDescription"]);
part.HomeKeywords = ConvertFromDBValue <string>(reader["HomeKeywords"]);
part.SeoPatternsDefinition = ConvertFromDBValue <string>(reader["SeoPatternsDefinition"]);
part.SearchTitlePattern = ConvertFromDBValue <string>(reader["SearchTitlePattern"]);
part.EnableCanonicalUrls = ConvertFromDBValue <bool>(reader["EnableCanonicalUrls"]);
part.TitleOverrideMaxLength = ConvertFromDBValue <int>(reader["TitleOverrideMaxLength"]);
part.DescriptionOverrideMaxLength = ConvertFromDBValue <int>(reader["DescriptionOverrideMaxLength"]);
part.KeywordsOverrideMaxLength = ConvertFromDBValue <int>(reader["KeywordsOverrideMaxLength"]);
}
});
_upgradeService.ExecuteReader(string.Format("DROP TABLE {0}", tableName), null);
}
return(1);
}
public ActionResult IndexPost()
{
if (!_orchardServices.Authorizer.Authorize(StandardPermissions.SiteOwner))
{
throw new AuthenticationException("");
}
var site = _orchardServices.WorkContext.CurrentSite.As <SiteSettingsPart>();
#region SiteSettingsPartRecord
var siteTable = _upgradeService.GetPrefixedTableName("Settings_SiteSettingsPartRecord");
if (_upgradeService.TableExists(siteTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + siteTable,
(reader, connection) => {
site.HomePage = ConvertToString(reader["HomePage"]);
site.PageSize = (int)reader["PageSize"];
site.PageTitleSeparator = ConvertToString(reader["PageTitleSeparator"]);
site.ResourceDebugMode = (ResourceDebugMode)Enum.Parse(typeof(ResourceDebugMode), (string)reader["ResourceDebugMode"]);
site.SiteCulture = ConvertToString(reader["SiteCulture"]);
site.SiteName = ConvertToString(reader["SiteName"]);
site.SiteSalt = ConvertToString(reader["SiteSalt"]);
site.SiteTimeZone = ConvertToString(reader["SiteTimeZone"]);
site.SuperUser = ConvertToString(reader["SuperUser"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + siteTable, null);
_signals.Trigger("SiteCurrentTheme");
}
#endregion
#region SiteSettings2PartRecord
var site2Table = _upgradeService.GetPrefixedTableName("Settings_SiteSettings2PartRecord");
if (_upgradeService.TableExists(site2Table))
{
_upgradeService.ExecuteReader("SELECT * FROM " + site2Table,
(reader, connection) => {
site.BaseUrl = ConvertToString(reader["BaseUrl"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + site2Table, null);
}
#endregion
#region ThemeSiteSettingsPartRecord
var themesTable = _upgradeService.GetPrefixedTableName("Orchard_Themes_ThemeSiteSettingsPartRecord");
if (_upgradeService.TableExists(themesTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + themesTable,
(reader, connection) => site.As <InfosetPart>().Store("ThemeSiteSettingsPart", "CurrentThemeName", ConvertToString(reader["CurrentThemeName"])));
_upgradeService.ExecuteReader("DROP TABLE " + themesTable, null);
}
#endregion
#region AkismetSettingsPartRecord
var akismetTable = _upgradeService.GetPrefixedTableName("Orchard_AntiSpam_AkismetSettingsPartRecord");
if (_upgradeService.TableExists(akismetTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + akismetTable,
(reader, connection) => {
site.As <InfosetPart>().Store("AkismetSettingsPart", "TrustAuthenticatedUsers", (bool)reader["TrustAuthenticatedUsers"]);
site.As <InfosetPart>().Store("AkismetSettingsPart", "ApiKey", ConvertToString(reader["ApiKey"]));
});
_upgradeService.ExecuteReader("DROP TABLE " + akismetTable, null);
}
#endregion
#region ReCaptchaSettingsPartRecord
var reCaptchaTable = _upgradeService.GetPrefixedTableName("Orchard_AntiSpam_ReCaptchaSettingsPartRecord");
if (_upgradeService.TableExists(reCaptchaTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + reCaptchaTable,
(reader, connection) => {
site.As <InfosetPart>().Store("ReCaptchaSettingsPart", "PublicKey", ConvertToString(reader["PublicKey"]));
site.As <InfosetPart>().Store("ReCaptchaSettingsPart", "PrivateKey", ConvertToString(reader["PrivateKey"]));
site.As <InfosetPart>().Store("ReCaptchaSettingsPart", "TrustAuthenticatedUsers", (bool)reader["TrustAuthenticatedUsers"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + reCaptchaTable, null);
}
#endregion
#region TypePadSettingsPartRecord
var typePadTable = _upgradeService.GetPrefixedTableName("Orchard_AntiSpam_TypePadSettingsPartRecord");
if (_upgradeService.TableExists(typePadTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + typePadTable,
(reader, connection) => {
site.As <InfosetPart>().Store("TypePadSettingsPart", "ApiKey", ConvertToString(reader["ApiKey"]));
site.As <InfosetPart>().Store("TypePadSettingsPart", "TrustAuthenticatedUsers", (bool)reader["TrustAuthenticatedUsers"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + typePadTable, null);
}
#endregion
#region CacheSettingsPartRecord
var cacheTable = _upgradeService.GetPrefixedTableName("Orchard_OutputCache_CacheSettingsPartRecord");
if (_upgradeService.TableExists(cacheTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + cacheTable,
(reader, connection) => {
site.As <InfosetPart>().Store("CacheSettingsPart", "DefaultCacheDuration", (int)reader["DefaultCacheDuration"]);
site.As <InfosetPart>().Store("CacheSettingsPart", "DefaultMaxAge", (int)reader["DefaultMaxAge"]);
site.As <InfosetPart>().Store("CacheSettingsPart", "VaryQueryStringParameters", ConvertToString(reader["VaryQueryStringParameters"]));
site.As <InfosetPart>().Store("CacheSettingsPart", "VaryRequestHeaders", ConvertToString(reader["VaryRequestHeaders"]));
site.As <InfosetPart>().Store("CacheSettingsPart", "IgnoredUrls", ConvertToString(reader["IgnoredUrls"]));
site.As <InfosetPart>().Store("CacheSettingsPart", "ApplyCulture", (bool)reader["ApplyCulture"]);
site.As <InfosetPart>().Store("CacheSettingsPart", "DebugMode", (bool)reader["DebugMode"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + cacheTable, null);
}
#endregion
#region CommentSettingsPartRecord
var commentsTable = _upgradeService.GetPrefixedTableName("Orchard_Comments_CommentSettingsPartRecord");
if (_upgradeService.TableExists(commentsTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + commentsTable,
(reader, connection) => {
site.As <InfosetPart>().Store("CommentSettingsPart", "ModerateComments", (bool)reader["ModerateComments"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + commentsTable, null);
}
#endregion
#region MessageSettingsPartRecord
var messagesTable = _upgradeService.GetPrefixedTableName("Orchard_Messaging_MessageSettingsPartRecord");
if (_upgradeService.TableExists(messagesTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + messagesTable,
(reader, connection) => {
site.As <InfosetPart>().Store("MessageSettingsPart", "DefaultChannelService", reader["DefaultChannelService"] as string);
});
_upgradeService.ExecuteReader("DROP TABLE " + messagesTable, null);
}
#endregion
#region SearchSettingsPartRecord
var searchTable = _upgradeService.GetPrefixedTableName("Orchard_Search_SearchSettingsPartRecord");
if (_upgradeService.TableExists(searchTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + searchTable,
(reader, connection) => {
site.As <InfosetPart>().Store("SearchSettingsPart", "SearchedFields", ConvertToString(reader["SearchedFields"]));
site.As <InfosetPart>().Store("SearchSettingsPart", "FilterCulture", (bool)reader["FilterCulture"]);
site.As <InfosetPart>().Store("SearchSettingsPart", "SearchIndex", ConvertToString(reader["SearchIndex"]));
});
_upgradeService.ExecuteReader("DROP TABLE " + searchTable, null);
}
#endregion
#region RegistrationSettingsPartRecord
var registrationTable = _upgradeService.GetPrefixedTableName("Orchard_Users_RegistrationSettingsPartRecord");
if (_upgradeService.TableExists(registrationTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + registrationTable,
(reader, connection) => {
site.As <InfosetPart>().Store("RegistrationSettingsPart", "UsersCanRegister", (bool)reader["UsersCanRegister"]);
site.As <InfosetPart>().Store("RegistrationSettingsPart", "UsersMustValidateEmail", (bool)reader["UsersMustValidateEmail"]);
site.As <InfosetPart>().Store("RegistrationSettingsPart", "UsersCanRegister", (bool)reader["UsersCanRegister"]);
site.As <InfosetPart>().Store("RegistrationSettingsPart", "ValidateEmailRegisteredWebsite", ConvertToString(reader["ValidateEmailRegisteredWebsite"]));
site.As <InfosetPart>().Store("RegistrationSettingsPart", "ValidateEmailContactEmail", ConvertToString(reader["ValidateEmailContactEmail"]));
site.As <InfosetPart>().Store("RegistrationSettingsPart", "UsersAreModerated", (bool)reader["UsersAreModerated"]);
site.As <InfosetPart>().Store("RegistrationSettingsPart", "NotifyModeration", (bool)reader["NotifyModeration"]);
site.As <InfosetPart>().Store("RegistrationSettingsPart", "NotificationsRecipients", ConvertToBool(reader["NotificationsRecipients"]));
site.As <InfosetPart>().Store("RegistrationSettingsPart", "EnableLostPassword", (bool)reader["EnableLostPassword"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + registrationTable, null);
}
#endregion
#region SmtpSettingsPartRecord
var emailTable = _upgradeService.GetPrefixedTableName("Orchard_Email_SmtpSettingsPartRecord");
if (_upgradeService.TableExists(emailTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + emailTable,
(reader, connection) => {
site.As <InfosetPart>().Store("SmtpSettingsPart", "Address", ConvertToString(reader["Address"]));
site.As <InfosetPart>().Store("SmtpSettingsPart", "Host", ConvertToString(reader["Host"]));
site.As <InfosetPart>().Store("SmtpSettingsPart", "Port", (int)reader["Port"]);
site.As <InfosetPart>().Store("SmtpSettingsPart", "EnableSsl", (bool)reader["EnableSsl"]);
site.As <InfosetPart>().Store("SmtpSettingsPart", "RequireCredentials", (bool)reader["RequireCredentials"]);
site.As <InfosetPart>().Store("SmtpSettingsPart", "UserName", ConvertToString(reader["UserName"]));
site.As <InfosetPart>().Store("SmtpSettingsPart", "Password", ConvertToString(reader["Password"]));
});
_upgradeService.ExecuteReader("DROP TABLE " + emailTable, null);
}
#endregion
#region WarmupSettingsPartRecord
var warmupTable = _upgradeService.GetPrefixedTableName("Orchard_Warmup_WarmupSettingsPartRecord");
if (_upgradeService.TableExists(warmupTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + warmupTable,
(reader, connection) => {
site.As <InfosetPart>().Store("WarmupSettingsPart", "Urls", ConvertToString(reader["Urls"]));
site.As <InfosetPart>().Store("WarmupSettingsPart", "Scheduled", (bool)reader["Scheduled"]);
site.As <InfosetPart>().Store("WarmupSettingsPart", "Delay", (int)reader["Delay"]);
site.As <InfosetPart>().Store("WarmupSettingsPart", "OnPublish", (bool)reader["OnPublish"]);
});
_upgradeService.ExecuteReader("DROP TABLE " + warmupTable, null);
}
#endregion
#region BlogPartRecord
var blogTable = _upgradeService.GetPrefixedTableName("Orchard_Blogs_BlogPartRecord");
if (_upgradeService.TableExists(blogTable))
{
_upgradeService.ExecuteReader("SELECT * FROM " + blogTable,
(reader, connection) => {
site.As <InfosetPart>().Store("BlogPart", "Description", ConvertToString(reader["Description"]));
});
_upgradeService.ExecuteReader("DROP TABLE " + blogTable, null);
}
#endregion
_orchardServices.Notifier.Information(T("Site Settings migrated successfully"));
return(View());
}
