private void MainPage_Loaded(object sender, RoutedEventArgs e)
{
using (var database = new SensorDbContext())
{
Sensors.ItemsSource = database.Sensors.ToList();
}
}
public ValuesController(IMqttClient mqttClient, IMqttClientOptions clientOptions, SensorDbContext sensorDbContext, ILogger <ValuesController> logger)
{
_mqttClient = mqttClient;
_clientOptions = clientOptions;
_logger = logger;
_sensorDbContext = sensorDbContext;
}
private void Add_Click(object sender, RoutedEventArgs e)
{
using (var database = new SensorDbContext())
{
var sensor = new Sensor
{
SensorId = Guid.NewGuid(),
Location = $"Room{DateTime.Now}"
};
database.Sensors.Add(sensor);
database.SaveChanges();
Sensors.ItemsSource = database.Sensors.ToList();
}
}
public ActionResult Index(int?page)
{
var db = new SensorDbContext();
// pagedList の使い方
// http://seven1st.com/archives/89
int pageNumber = page ?? 1;
if (pageNumber < 1)
{
pageNumber = 1;
}
int pageSize = 20;
var SensorTagPages = db.SensorTags
.OrderBy(s => s.EventProcessedTime)
.ToPagedList(pageNumber, pageSize);
return(View(SensorTagPages));
}
/// <summary>
/// 単一アプリケーション オブジェクトを初期化します。これは、実行される作成したコードの
///最初の行であるため、main() または WinMain() と論理的に等価です。
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
// Before running the app for the first time, follow these steps:
// 1- Build -> Build the Project
// 2- Tools –> NuGet Package Manager –> Package Manager Console
// 3- Run "Add-Migration MyFirstMigration" to scaffold a migration to create the initial set of tables for your model
// See here for more information https://docs.efproject.net/en/latest/platforms/uwp/getting-started.html#create-your-database
using (var database = new SensorDbContext())
{
database.Database.Migrate();
}
}
public CoffeeRepository(SensorDbContext sensorDbContext) : base(sensorDbContext)
{
}
public AirQualityRepository(SensorDbContext sensorDbContext) : base(sensorDbContext)
{
}
public RestRoomRepository(SensorDbContext sensorDbContext) : base(sensorDbContext)
{
}
public InclsController(SensorDbContext context)
{
_context = context;
}
public GapsController(SensorDbContext context)
{
_context = context;
}
public BaseRepository(SensorDbContext sensorDbContext)
{
this.sensorDbContext = sensorDbContext;
}
