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