/// <summary>
/// Upgrades a database schema from Merchello version 1.0.1.4 (second relase) to Merchello version 1.1.0
/// </summary>
public void UpgradeTargetVersionOneOneZero()
{
// add the notification tables
DatabaseSchemaHelper.InitializeDatabaseSchema(_database, CreateOneOneZeroTables.OrderedTables, "1.1.0 upgrade");
// Add the ShipDateColumn to the merchShipment table
_database.Execute("ALTER TABLE merchShipment ADD shippedDate datetime NOT NULL DEFAULT GETDATE()");
// Insert new TypeField Data
var gwp = new GatewayProviderTypeField();
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = gwp.Notification.TypeKey, Alias = gwp.Notification.Alias, Name = gwp.Notification.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
var entity = new EntityTypeField();
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Customer.TypeKey, Alias = entity.Customer.Alias, Name = entity.Customer.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.GatewayProvider.TypeKey, Alias = entity.GatewayProvider.Alias, Name = entity.GatewayProvider.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Invoice.TypeKey, Alias = entity.Invoice.Alias, Name = entity.Invoice.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.ItemCache.TypeKey, Alias = entity.ItemCache.Alias, Name = entity.ItemCache.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Order.TypeKey, Alias = entity.Order.Alias, Name = entity.Order.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Payment.TypeKey, Alias = entity.Payment.Alias, Name = entity.Payment.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Product.TypeKey, Alias = entity.Product.Alias, Name = entity.Product.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Shipment.TypeKey, Alias = entity.Shipment.Alias, Name = entity.Shipment.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.Warehouse.TypeKey, Alias = entity.Warehouse.Alias, Name = entity.Warehouse.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
_database.Insert("merchTypeField", "Key", new TypeFieldDto()
{
Key = entity.WarehouseCatalog.TypeKey, Alias = entity.WarehouseCatalog.Alias, Name = entity.WarehouseCatalog.Name, UpdateDate = DateTime.Now, CreateDate = DateTime.Now
});
}
/// <summary>
/// Adds the merchProductCollection table to the database.
/// </summary>
public override void Up()
{
var database = ApplicationContext.Current.DatabaseContext.Database;
if (!database.TableExist("merchEntityCollection"))
{
DatabaseSchemaHelper.InitializeDatabaseSchema(database, OrderedTables, "Merchello 1.11.0 upgrade");
}
}
/// <summary>
/// Creates the ProductVariant2DetachedContentType table
/// </summary>
public override void Up()
{
var database = ApplicationContext.Current.DatabaseContext.Database;
if (!database.TableExist("merchProductVariantDetachedContent"))
{
DatabaseSchemaHelper.InitializeDatabaseSchema(database, OrderedTables, "Merchello 1.11.0 upgrade");
}
}
/// <summary>
/// Initialize the database by creating the umbraco db schema
/// </summary>
public void InitializeDatabaseSchema()
{
var e = new DatabaseCreationEventArgs();
FireBeforeCreation(e);
if (!e.Cancel)
{
DatabaseSchemaHelper.InitializeDatabaseSchema(_database, OrderedTables, MerchelloVersion.Current.ToString());
}
FireAfterCreation(e);
}
/// <summary>
/// Adds the merchDetatchedPublishedContentType table to the database
/// </summary>
public override void Up()
{
var database = ApplicationContext.Current.DatabaseContext.Database;
if (!database.TableExist("merchDetachedContentType"))
{
DatabaseSchemaHelper.InitializeDatabaseSchema(database, OrderedTables, "Merchello 1.11.0 upgrade");
var entity = new EntityTypeField();
database.Insert(
"merchDetachedContentType",
"Key",
new DetachedContentTypeDto()
{
Key = Constants.DefaultKeys.DetachedPublishedContentType.DefaultProductVariantDetachedPublishedContentTypeKey,
Name = "No Extended Content",
EntityTfKey = entity.Product.TypeKey,
ContentTypeId = null,
UpdateDate = DateTime.Now,
CreateDate = DateTime.Now
});
}
}
/// <summary>
/// The up.
/// </summary>
public override void Up()
{
var database = ApplicationContext.Current.DatabaseContext.Database;
DatabaseSchemaHelper.InitializeDatabaseSchema(database, OrderedTables, "1.9.0 upgrade");
}