//var groups = scenario.ScenarioGroups; //var sc = scenario.Scenarios; //DateTime now = DateTime.UtcNow; // try // { // AddGroups1(groups, now); //scenario.SaveChanges(); // AddGroups2(groups, now); //scenario.SaveChanges(); // //AddScenarios(sc, now); // } // catch (DbEntityValidationException dbEx) // { // foreach (var validationErrors in dbEx.EntityValidationErrors) // { // Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", validationErrors.Entry.Entity.GetType().Name, validationErrors.Entry.State); // foreach (var validationError in validationErrors.ValidationErrors) // { // Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // } // } // } // Console.WriteLine("*****Scenario Group List*****"); // foreach (ScenarioGroup item in groups) // { // Console.WriteLine(item.ScenarioGroupID); // foreach (ScenarioGroupDetail item2 in item.ScenarioGroupDetails) // { // Console.WriteLine(item2.ScenarioGroupDetailID + " " + item2.Name); // } // } static void AddGroups1(DbSet<ScenarioGroup> root, DateTime now) { ScenarioGroup sg = new ScenarioGroup(); sg.StartTime = now.AddDays(-100); sg.EndTime = DateTime.MaxValue; sg.CreatedBy = "me"; sg.CreatedAt = now; root.Add(sg); ScenarioGroupDetail sgd = new ScenarioGroupDetail(); sgd.Name = "Test 2-1"; sgd.StartTime = now.AddDays(-100); sgd.EndTime = now.AddDays(-50); sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-50); //sgd.ScenarioGroup = sg; sg.ScenarioGroupDetails.Add(sgd); sgd = new ScenarioGroupDetail(); sgd.Name = "Test 2-2"; sgd.StartTime = now.AddDays(-50); sgd.EndTime = now.AddDays(-20); sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-20); //sgd.ScenarioGroup = sg; sg.ScenarioGroupDetails.Add(sgd); sgd = new ScenarioGroupDetail(); sgd.Name = "Test 2-3"; sgd.StartTime = now.AddDays(-20); sgd.EndTime = DateTime.MaxValue; sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-20); //sgd.ScenarioGroup = sg; sg.ScenarioGroupDetails.Add(sgd); }
static void AddGroups2(DbSet<ScenarioGroup> root, DateTime now) { ScenarioGroup sg1 = root.Find(2); ScenarioGroup sg = new ScenarioGroup(); sg.StartTime = now.AddDays(-80); sg.EndTime = DateTime.MaxValue; sg.CreatedBy = "me"; sg.CreatedAt = now; root.Add(sg); ScenarioGroupDetail sgd = new ScenarioGroupDetail(); sgd.Name = "Test-Child-2"; sgd.StartTime = now.AddDays(-80); sgd.EndTime = now.AddDays(-40); sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-40); sg.ScenarioGroupDetails.Add(sgd); sgd = new ScenarioGroupDetail(); sgd.Name = "Test-Child-2"; sgd.StartTime = now.AddDays(-40); sgd.EndTime = now.AddDays(-20); sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-20); sg.ScenarioGroupDetails.Add(sgd); sgd = new ScenarioGroupDetail(); sgd.Name = "Test-Child-2"; sgd.StartTime = now.AddDays(-20); sgd.EndTime = DateTime.MaxValue; sgd.CreatedBy = "me"; sgd.CreatedAt = now.AddDays(-20); sg.ScenarioGroupDetails.Add(sgd); }
//static void AddGroups3(DbSet<ScenarioGroup> root, DateTime now) //{ // ScenarioGroup sg = new ScenarioGroup(); // sg.Name = "Test-Child2"; // sg.ScenarioGroupID = 2; // sg.ScenarioGroupParentID = 1; // sg.StartTime = now.AddDays(-80); // sg.EndTime = DateTime.MaxValue; // sg.CreatedBy = "me"; // sg.TimeStamp = now.AddDays(-80); // root.Add(sg); //} static void AddScenarios(DbSet<ScenarioGroup> setScenarioGroup, DbSet<Scenario> setScenario, DateTime now) { ScenarioGroup sg = new ScenarioGroup(); sg.StartTime = now.AddDays(-80); sg.EndTime = DateTime.MaxValue; sg.CreatedBy = "me"; sg.CreatedAt = now; setScenarioGroup.Add(sg); ScenarioGroupDetail sgd = new ScenarioGroupDetail(); sgd.Name = "Test-Child-2"; sgd.StartTime = now.AddDays(-80); sgd.EndTime = DateTime.MaxValue; sgd.CreatedBy = "me"; sgd.CreatedAt = now; sg.ScenarioGroupDetails.Add(sgd); Scenario s = new Scenario(); s.StartTime = now.AddDays(-80); s.EndTime = DateTime.MaxValue; s.CreatedBy = "me"; s.CreatedAt = now; setScenario.Add(s); ScenarioDetail sd = new ScenarioDetail(); sd.Name = "Scenario A"; sd.StartTime = now.AddDays(-80); sd.EndTime = DateTime.MaxValue; sd.CreatedBy = "me"; sd.CreatedAt = now; s.ScenarioDetails.Add(sd); Scenario s2 = new Scenario(); s.StartTime = now.AddDays(-80); s.EndTime = DateTime.MaxValue; s.CreatedBy = "me"; s.CreatedAt = now; setScenario.Add(s2); ScenarioDetail sd2 = new ScenarioDetail(); sd.Name = "Derive from A"; sd.StartTime = now.AddDays(-80); sd.EndTime = DateTime.MaxValue; sd.CreatedBy = "me"; sd.CreatedAt = now; s2.ScenarioDetails.Add(sd2); s.DerivedScenarios.Add(s2); }