private void CreateMedia(IList <CompositeKeyEntity> compositeKeyEntities, IList <TypeIdIncludedEntity> typeIdIncludedEntities) { var nameIndex = 0; var items = compositeKeyEntities.Zip(typeIdIncludedEntities, (c, t) => new { CompositeKeyEntity = c, TypeIdIncludedEntity = t }); foreach (var item in items) { var film = new Film { Name = nameIndex.ToString("D2"), CreationDate = DateTime.UtcNow, UIndentifier = Guid.NewGuid(), CompositeKeyRef = item.CompositeKeyEntity, TypeIdIncludedRef = item.TypeIdIncludedEntity }; filmToComositeKeyMap.Add(film.Key, item.CompositeKeyEntity.Key); filmToIncludedTypeKeyMap.Add(film.Key, item.TypeIdIncludedEntity.Key); nameIndex++; } foreach (var item in items.Reverse()) { var dSensor = new DigitalSensor { Name = nameIndex.ToString("D2"), CreationDate = DateTime.UtcNow, UIndentifier = Guid.NewGuid(), CompositeKeyRef = item.CompositeKeyEntity, TypeIdIncludedRef = item.TypeIdIncludedEntity }; dSensorToComositeKeyMap.Add(dSensor.Key, item.CompositeKeyEntity.Key); dSensorToIncludedTypeKeyMap.Add(dSensor.Key, item.TypeIdIncludedEntity.Key); nameIndex++; } }
public int Delete(object obj) { DigitalSensor sensor = (DigitalSensor)obj; MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("@name", sensor.Name) }; string cmdText = "delete from digitalSensor where name=@name"; return(this.MySqlHelper.ExecuteNonQuery(cmdText, parms)); }
public int Add(object obj) { DigitalSensor sensor = (DigitalSensor)obj; MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("@name", sensor.Name), new MySqlParameter("@address", sensor.Address.ToString()), new MySqlParameter("@description", sensor.Description), new MySqlParameter("@aInterval", sensor.Interval) }; string cmdText = "insert into digitalSensor(name, address, description, aInterval) values(@name, @address, @description, @aInterval);"; return(MySqlHelper.ExecuteNonQuery(cmdText, parms)); }
public int Modify(object oldObj, object newObj) { DigitalSensor oldSensor = (DigitalSensor)oldObj; DigitalSensor newSensor = (DigitalSensor)newObj; MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("@name", oldSensor.Name), new MySqlParameter("@address", oldSensor.Address.ToString()), new MySqlParameter("@description", oldSensor.Description), new MySqlParameter("@interval", oldSensor.Interval) }; string cmdText = "update digitalSensor set address=@address,description=@description,aInterval=@interval where name = @name"; return(this.MySqlHelper.ExecuteNonQuery(cmdText, parms)); }
public static void Main() { var thdLed = new Thread(HandleLed); thdLed.Start(); var digitalSensor = new DigitalSensor { InputPin = Pins.GPIO_PIN_D12 }; var analogSensor = new AnalogSensor { InputPin = Pins.GPIO_PIN_A1, MinValue = 0.0, MaxValue = 3.3 }; var lowPort = new OutputPort(Pins.GPIO_PIN_A0, false); var highPort = new OutputPort(Pins.GPIO_PIN_A2, true); var ledActuator = new DigitalActuator { OutputPin = Pins.GPIO_PIN_D13 }; //need to create HTTP PUTs! var webServer = new HttpServer { RelayDomain = "gsiot-bcjp-yj88", RelaySecretKey = "HDMvyM11hAu6H6cxIaT50dL9ALWc81MYB8H/UFhV", RequestRouting = { { "GET /hello*", HandleHello }, //This accepts a lot of URLs { "GET /on", HandleOn }, { "GET /off", HandleOff }, { "POST /on", HandlePostOn }, { "POST /off", HandlePostOff }, { "GET /d12", new MeasuredVariable { FromSensor = digitalSensor.HandleGet }.HandleRequest }, { "GET /a1", new MeasuredVariable { FromSensor = analogSensor.HandleGet }.HandleRequest }, { "PUT /d13", new ManipulatedVariable { FromHttpRequest = CSharpRepresentation.TryDeserializeBool, ToActuator = ledActuator.HandlePut }.HandleRequest }, } }; webServer.Run(); }
protected override void PopulateData() { using (var session = Domain.OpenSession()) using (var transaction = session.OpenTransaction()) { _ = new Film(); _ = new Film(); _ = new Film(); _ = new Film(); _ = new DigitalSensor(); _ = new DigitalSensor(); _ = new DigitalSensor(); _ = new DigitalSensor(); _ = new DigitalSensor(); _ = new DigitalSensor(); transaction.Complete(); } }
public object GetObjById(string id) { DigitalSensor anaSensor = new DigitalSensor(); string cmdText = "select * from digitalSensor where name=@id"; MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("@id", id) }; MySqlDataReader reader = this.MySqlHelper.ExecuteReader(cmdText, parms); while (reader.Read()) { anaSensor.Name = reader[0].ToString().Trim(); anaSensor.Address = new SensorAddress(reader[1].ToString().Trim()); anaSensor.Description = reader[2].ToString(); anaSensor.Interval = int.Parse(reader[3].ToString().Trim()); } this.mySqlHelper.CloseConn(); return(anaSensor); }
public List <object> GetObjsBySQL(string strSQL, MySqlParameter[] parms) { List <object> objs = new List <object>(); MySqlDataReader reader = this.MySqlHelper.ExecuteReader(strSQL, parms); while (reader.Read()) { DigitalSensor anaSensor = new DigitalSensor(); anaSensor.Name = reader[0].ToString().Trim(); anaSensor.Address = new SensorAddress(reader[1].ToString().Trim()); anaSensor.Description = reader[2].ToString(); anaSensor.Interval = int.Parse(reader[3].ToString().Trim()); objs.Add(anaSensor); } this.mySqlHelper.CloseConn(); return(objs); }
public List <object> GetAllObjs() { List <object> objs = new List <object>(); string cmdText = "select * from digitalSensor"; MySqlParameter[] parms = new MySqlParameter[] { }; MySqlDataReader reader = this.MySqlHelper.ExecuteReader(cmdText, parms); while (reader.Read()) { DigitalSensor sensor = new DigitalSensor(); sensor.Name = reader[0].ToString().Trim(); sensor.Address = new SensorAddress(reader[1].ToString().Trim()); sensor.Description = reader[2].ToString().Trim(); sensor.Interval = int.Parse(reader[3].ToString().Trim()); objs.Add(sensor); } this.mySqlHelper.CloseConn(); return(objs); }
public void TestDigSensorBLL() { DigSensorBLL bll = new DigSensorBLL(new DigSensorDAL()); DigitalSensor sensor1 = new DigitalSensor("U2CCV004DM", "AA.BB", "description1", 61); DigitalSensor sensor2 = new DigitalSensor("U2CCV005DM", "AA.BB", "description1", 61); //bll.Add(sensor1); //bll.Add(sensor2); bll.Delete(sensor1); DigitalSensor sensor3 = new DigitalSensor("U2CCV002DM", "AA.BB.CC", "description1", 61); bll.Modify(sensor2, sensor3); DigitalSensor sensor4 = (DigitalSensor)bll.GetObjById("U2CCV002DM"); int ret = bll.ExcuteSqlStr("select * from digitalSensor"); List <object> list1 = bll.GetAllObjs(); List <object> list2 = bll.GetObjsBySQL("select * from digitalSensor", null); }