public IEnumerable <DoorWindowSensorEntity> GetByDate(DateTime fromDate, DateTime toDate)
{
var command = this.SmartPlugConnection.Connection.CreateCommand();
List <DoorWindowSensorEntity> list = new List <DoorWindowSensorEntity>();
command.CommandText = selectByDateQueryString;
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@fromDate", fromDate);
command.Parameters.AddWithValue("@toDate", toDate);
using (NpgsqlDataReader r = command.ExecuteReader())
{
while (r.Read())
{
DoorWindowSensorEntity doorWindowSensorEntity = new DoorWindowSensorEntity
{
State = Convert.ToString(r["state"]),
Light = Convert.ToInt32(r["light"]),
CreatedAt = Convert.ToDateTime(r["created_at"])
};
list.Add(doorWindowSensorEntity);
}
}
return(list);
}
public void Insert(DoorWindowSensorEntity doorWindowSensorEntity)
{
var command = this.SmartPlugConnection.Connection.CreateCommand();
command.CommandText = insertQueryString;
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@state", doorWindowSensorEntity.State);
command.Parameters.AddWithValue("@light", doorWindowSensorEntity.Light);
command.Parameters.AddWithValue("@created_at", doorWindowSensorEntity.CreatedAt);
command.ExecuteNonQuery();
}
