private void originalloadTestConfigData() { ZoneGuardConfigContextFactory factory = new ZoneGuardConfigContextFactory(); Guid serverNodeGuid = new Guid("5c7a6580-45fc-4402-9ebe-07de9884f5b0"); using (ZoneGuardConfigContext context = factory.CreateDbContext()) { /* * NodeDAL node = null; * * if (!context.Node.Any()) * { * node = new NodeDAL { UniqueIdentifier = serverNodeGuid, Name = "Server" }; * context.Node.Add(node); * * context.SaveChanges(); * } * else * { * node = context.Node.Where<NodeDAL>(n => n.UniqueIdentifier == serverNodeGuid).FirstOrDefault<NodeDAL>(); * } * */ // Look for any students. SensorDAL thing = null; if (!context.Thing.Any()) { // ThingParameterDAL paramCategory = new ThingParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }; // ThingParameterDAL paramConfigClass = new ThingParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }; // ThingParameterDAL paramThingClass= new ThingParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }; List <SensorDAL> sensorsPerimeter = new List <SensorDAL>(); //List<String> sensorsPerimeter = new List<String>(); List <SensorDAL> sensorsHighRisk = new List <SensorDAL>(); String topicOffset = "test/"; SensorParameterDAL[] thingParameters; thing = new SensorDAL { Name = "OfficeWindow1", Description = "Window in Office", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "OfficeWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "officewindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * * Sensor 2 * * ************/ thing = new SensorDAL { Name = "LivingroomWindow1", Description = "First Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "LivingroomWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomwindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); thing = AddThing(context, "LivingroomWindow2", "Second Window in Livingroom", ThingType.Sensor, new Dictionary <string, string> { { "category", "sensor" }, { "config_class", "ConfigSensor" }, { "thing_class", "SensorMQTT" }, { "name", "LivingroomWindow2" }, { "topic", topicOffset + "livingroomwindow2/state" } }); sensorsPerimeter.Add(thing); /* * thing = new ThingDAL { Name = "LivingroomWindow2", Description = "Second Window in Livingroom", ThingType = ThingType.Sensor, Timestamp = DateTime.UtcNow }; * sensorsPerimeter.Add(thing); * thingParameters = new ThingParameterDAL[] * { * new ThingParameterDAL{Name="category", Value="sensor", Timestamp=DateTime.UtcNow}, * new ThingParameterDAL{Name="config_class", Value="ConfigSensor", Timestamp=DateTime.UtcNow }, * new ThingParameterDAL{Name="thing_class", Value="SensorMQTT", Timestamp=DateTime.UtcNow }, * new ThingParameterDAL{Name="name", Value = "LivingroomWindow2", Timestamp=DateTime.UtcNow }, * new ThingParameterDAL{Name="topic", Value = topicOffset + "livingroomwindow2/state", Timestamp=DateTime.UtcNow } * }; * DbInitializer.AddThing(context, thing, thingParameters); */ thing = new SensorDAL { Name = "LivingroomWindow3", Description = "Third Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "LivingroomWindow3", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomwindow3/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * * LivingroomDoor1 * * ************/ thing = new SensorDAL { Name = "LivingroomDoor1", Description = "Terracedoor in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "LivingroomDoor1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomdoor1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * * FrederikWindow1 * * ************/ thing = new SensorDAL { Name = "FrederikWindow1", Description = "Window (Frederik)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "FrederikWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "frederikwindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * CecilieWindow1 * ************/ thing = new SensorDAL { Name = "CecilieWindow1", Description = "Window (Cecilie)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "CecilieWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "ceciliewindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * SofieWindow1 * ************/ thing = new SensorDAL { Name = "SofieWindow1", Description = "Window (Sofie)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "SofieWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "sofiewindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * BedroomWindow1 * ************/ thing = new SensorDAL { Name = "BedroomWindow1", Description = "Window (Bedroom)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "BedroomWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "bedroomwindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * BackentranceWindow1 * ************/ thing = new SensorDAL { Name = "BackentranceWindow1", Description = "Window (Backentrance)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "BackentranceWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "backentrancewindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * BackentranceDoor1 * ************/ thing = new SensorDAL { Name = "BackentranceDoor1", Description = "Door (Backentrance)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); sensorsHighRisk.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "BackentranceDoor1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "backentrancedoor1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * BathroomWindow1 * ************/ thing = new SensorDAL { Name = "BathroomWindow1", Description = "Window (Bathroom)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "BathroomWindow1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "bathroomwindow1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); /* *********** * EntranceDoor1 * ************/ thing = new SensorDAL { Name = "EntranceDoor1", Description = "Window (Entrancedoor)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensorsPerimeter.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "name", Value = "EntranceDoor1", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "topic", Value = topicOffset + "frontentrancedoor1/state", Timestamp = DateTime.UtcNow } }; DbInitializer.AddThing(context, thing, thingParameters); AlarmZoneDAL alarmZonePerimeter = new AlarmZoneDAL { Name = "Perimeter", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow }; List <AlarmZoneThingDAL> alarmZoneSensors = new List <AlarmZoneThingDAL>(); foreach (SensorDAL sensor in sensorsPerimeter) { alarmZoneSensors.Add(new AlarmZoneThingDAL { Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow }); } ; DbInitializer.AddAlarmZone(context, alarmZonePerimeter, alarmZoneSensors.ToArray()); AlarmZoneDAL alarmZoneHighRisk = new AlarmZoneDAL { Name = "High Risk", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow }; alarmZoneSensors = new List <AlarmZoneThingDAL>(); foreach (SensorDAL sensor in sensorsHighRisk) { alarmZoneSensors.Add(new AlarmZoneThingDAL { Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow }); } ; DbInitializer.AddAlarmZone(context, alarmZoneHighRisk, alarmZoneSensors.ToArray()); } } }
private void InitializeConfigData_NA(ZoneGuardConfigContext context) { SensorDAL thing = null; if (!context.Sensor.Any()) { List <SensorDAL> sensors = new List <SensorDAL>(); String topicOffset = "test/"; SensorParameterDAL[] thingParameters; thing = new SensorDAL { Name = "OfficeWindow1", Description = "Window in Office", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensors.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "topic", Value = "test/officewindows1/state", Timestamp = DateTime.UtcNow } //new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} }; AddThing(context, thing, thingParameters); /* *********** * * Sensor 2 * * ************/ thing = new SensorDAL { Name = "LivingroomWindow1", Description = "First Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensors.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomwindows1/state", Timestamp = DateTime.UtcNow }, new SensorParameterDAL { Name = "a_value", Value = "Some value", Timestamp = DateTime.UtcNow } //new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} }; AddThing(context, thing, thingParameters); thing = new SensorDAL { Name = "Livingroom2", Description = "Second Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensors.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomwindows2/state", Timestamp = DateTime.UtcNow } //new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} }; AddThing(context, thing, thingParameters); thing = new SensorDAL { Name = "Livingroom3", Description = "Third Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow }; sensors.Add(thing); thingParameters = new SensorParameterDAL[] { new SensorParameterDAL { Name = "topic", Value = topicOffset + "livingroomwindows3/state", Timestamp = DateTime.UtcNow } //new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} }; AddThing(context, thing, thingParameters); AlarmZoneDAL alarmZone = null; alarmZone = new AlarmZoneDAL { Name = "Perimeter", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow }; List <AlarmZoneThingDAL> alarmZoneSensors = new List <AlarmZoneThingDAL>(); foreach (SensorDAL sensor in sensors) { alarmZoneSensors.Add(new AlarmZoneThingDAL { Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow }); } ; AddAlarmZone(context, alarmZone, alarmZoneSensors.ToArray()); } SensorStateLogDAL ssl = null; thing = context.Thing.Where(s => s.Id == 2).First <SensorDAL>(); ssl = new SensorStateLogDAL { Triggered = 1, Sensor = thing, CreatedTimestamp = DateTime.UtcNow.AddHours(-1) }; AddSensorStateLog(context, ssl); ssl = new SensorStateLogDAL { Triggered = 0, Sensor = thing, CreatedTimestamp = DateTime.UtcNow.AddHours(-1).AddMinutes(1) }; AddSensorStateLog(context, ssl); return; // DB has been seeded //} /* * * DETTE VIRKER * var things = new ConfigThing[] * { * new ConfigThing{Name="Sensor 1", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow}, * new ConfigThing{Name="Sensor 2", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow}, * new ConfigThing{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} * }; * foreach (ConfigThing s in things) * { * context.Thing.Add(s); * context.SaveChanges(); * int id = s.ID; * Console.WriteLine("Id is {0}", id); * } * context.SaveChanges(); * IEnumerable<ConfigThing> things1 = context.Thing.AsEnumerable<ConfigThing>(); * int count = things.Count<ConfigThing>(); */ /* * var things = new ConfigThingParameter[] * { * new ConfigThingParameter{ThingId=1, Name="Topic", Key="test/officewindow1/state", Timestamp=DateTime.UtcNow}, * new ConfigThing{Name="Sensor 2", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow}, * new ConfigThing{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow} * };Ø/ * * /* * * var courses = new Course[] * { * new Course{CourseID=1050,Title="Chemistry",Credits=3}, * new Course{CourseID=4022,Title="Microeconomics",Credits=3}, * new Course{CourseID=4041,Title="Macroeconomics",Credits=3}, * new Course{CourseID=1045,Title="Calculus",Credits=4}, * new Course{CourseID=3141,Title="Trigonometry",Credits=4}, * new Course{CourseID=2021,Title="Composition",Credits=3}, * new Course{CourseID=2042,Title="Literature",Credits=4} * }; * foreach (Course c in courses) * { * context.Course.Add(c); * } * context.SaveChanges(); * * var enrollments = new Enrollment[] * { * new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A}, * new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C}, * new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B}, * new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B}, * new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F}, * new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F}, * new Enrollment{StudentID=3,CourseID=1050}, * new Enrollment{StudentID=4,CourseID=1050}, * new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F}, * new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C}, * new Enrollment{StudentID=6,CourseID=1045}, * new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A}, * }; * foreach (Enrollment e in enrollments) * { * context.Enrollment.Add(e); * } * context.SaveChanges(); */ }