public HistoryController()
{
string cs = ConfigurationManager.ConnectionStrings["GatewayDbConnection"].ConnectionString;
historyDb = new SensorsHistoryRepositoryDapper(cs);
gatewayDb = new GatewayRepositoryDapper(cs);
}
public static void ConnectToDB()
{
//connecting to DB
if (!dataBaseEnabled) return;
OnDebugStateMessage("DATABASE: Connecting... ");
if (dataBaseConnectionString == null)
{
OnDebugStateMessage("DATABASE: Connection failed. Set ConnectionString in appsettings.json file.");
return;
}
gatewayDb = new GatewayRepositoryDapper(dataBaseConnectionString);
historyDb = new SensorsHistoryRepositoryDapper(dataBaseConnectionString);
sensorsTasksDb = new SensorsTasksRepositoryDapper(dataBaseConnectionString);
sensorsLinksDb = new SensorsLinksRepositoryDapper(dataBaseConnectionString);
//todo logicalNodesRepository = new logicalNodesRepositoryDapper(dataBaseConnectionString);
gatewayDb.SetWriteInterval(dataBaseWriteInterval);
gatewayDb.ShowDebugInConsole(dataBaseDebugState);
gatewayDb.SetStoreTxRxMessages(dataBaseWriteTxRxMessages);
gatewayDb.ConnectToGateway(gateway);
historyDb.SetWriteInterval(dataBaseWriteInterval);
historyDb.ConnectToGateway(gateway);
OnDebugStateMessage("DATABASE: Connected");
}
public NodeController()
{
gatewayDb = SerialController.gatewayDb;
historyDb = SerialController.historyDb;
}
public async static Task ConnectToSensorsHistoryDb()
{
//connecting to DB
bool connected = false;
if (Convert.ToBoolean(ConfigurationManager.AppSettings["UseDB"]))
{
Console.WriteLine("Connecting to sensors history database... ");
string connectionString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
historyDb = new SensorsHistoryRepositoryDapper(connectionString);
while (!connected)
{
historyDb.ConnectToGateway(gateway);
connected = (historyDb.IsDbExist());
if (!connected) await Task.Delay(5000);
}
}
}
