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