public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } DdsEnvironment = await _context.DdsEnvironment.FirstOrDefaultAsync(m => m.Id == id); if (DdsEnvironment == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } DdsEnvironment = await _context.DdsEnvironment.FindAsync(id); if (DdsEnvironment != null) { _context.DdsEnvironment.Remove(DdsEnvironment); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public void SyncRestore(string database, DdsEnvironment environment, string scriptsFolder) { }
public void AfterRefresh(string database, DdsEnvironment environment, string scriptsFolder) { }
public static void Initialize(SqlPackManContext context) { //ENVIRONMENTS if (!context.DdsEnvironment.Any()) { var environments = new DdsEnvironment[] { new DdsEnvironment { Name = "DEV", Server = "(localdb)\\mssqllocaldb", SchemaPath = "G:\\RedGate\\DBSource" }, new DdsEnvironment { Name = "QA", Server = "(localdb)\\mssqllocaldb", SchemaPath = "G:\\RedGate\\DBSource" }, new DdsEnvironment { Name = "STAG", Server = "(localdb)\\mssqllocaldb", SchemaPath = "G:\\RedGate\\DBSource" }, new DdsEnvironment { Name = "PROD", Server = "(localdb)\\mssqllocaldb", SchemaPath = "G:\\RedGate\\DBSource" } }; foreach (DdsEnvironment env in environments) { context.Add(env); } context.SaveChanges(); } //DbObjectTypes if (!context.DbObject.Any()) { } if (!context.Package.Any()) { //Packages var packages = new Package[] { new Package { DbName = "DB1", Description = "Test Package for DB1 Feature1", Name = "Feature1", Version = 1, MaxEnvironmentId = 4 }, new Package { DbName = "DB1", Description = "Test Package for DB1 Feature2", Name = "Feature2", Version = 1, MaxEnvironmentId = 4 }, new Package { DbName = "DB1", Description = "Test Package for DB1 Feature3", Name = "Feature3", Version = 1, MaxEnvironmentId = 4 }, }; foreach (Package pkg in packages) { context.Add(pkg); } context.SaveChanges(); } //DbObjects if (!context.DbObject.Any()) { var dbObjects = new DbObject[] { new DbObject { PackageId = 3, ObjectName = "Table1", DbObjectType = DbObjectType.Table, Status = Status.Development, Tags = new HashSet <string> { "Form1,Report1" } }, new DbObject { PackageId = 4, ObjectName = "Table2", DbObjectType = DbObjectType.Table, Status = Status.Development, Tags = new HashSet <string> { "Form2,Report2" } }, new DbObject { PackageId = 5, ObjectName = "Table3", DbObjectType = DbObjectType.Table, Status = Status.Development, Tags = new HashSet <string> { "Form3,Report3" } }, new DbObject { PackageId = 3, ObjectName = "View1", DbObjectType = DbObjectType.View, Status = Status.Development, Tags = new HashSet <string> { "Form1,Report1" } }, new DbObject { PackageId = 4, ObjectName = "View2", DbObjectType = DbObjectType.View, Status = Status.Development, Tags = new HashSet <string> { "Form2,Report2" } }, new DbObject { PackageId = 5, ObjectName = "View3", DbObjectType = DbObjectType.View, Status = Status.Development, Tags = new HashSet <string> { "Form3,Report3" } }, }; foreach (DbObject dbo in dbObjects) { context.Add(dbo); } context.SaveChanges(); } }