private async void CheckMySqlConnectionAsync()
{
_uiHandler.ShowTab("overviewTabPage");
_uiHandler.UpdateLog("Checking mySQL connection...");
MySqlConnectionSettings myConnSettings = _uiHandler.GetMySqlSettings();
using (MySqlDbManager dbManager = new MySqlDbManager(myConnSettings))
{
_uiHandler.UpdateLog("Estabilishing mySQL connection...");
BoxedData startConnData = await dbManager.StartConnectionTaskStart();
bool startConnSuccess = (bool)startConnData.Data;
_uiHandler.UpdateLog(startConnSuccess ? "Connection started!" : "Connection starting failed!");
if (!String.IsNullOrEmpty(startConnData.Msg))
{
_uiHandler.UpdateLog(startConnData.Msg);
}
BoxedData checkConnData = await dbManager.CheckConnectionTaskStart();
bool checkConnSuccess = (bool)checkConnData.Data;
_uiHandler.UpdateLog(checkConnSuccess ? "Connection successfully estabilished!" : "Connection not estabilished!");
if (!String.IsNullOrEmpty(checkConnData.Msg))
{
_uiHandler.UpdateLog(checkConnData.Msg);
}
BoxedData closeConnData = await dbManager.CloseConnectionTaskStart();
bool closeConnSuccess = (bool)closeConnData.Data;
_uiHandler.UpdateLog(closeConnSuccess ? "Connection closed!" : "Cannot close current connection!");
if (!String.IsNullOrEmpty(closeConnData.Msg))
{
_uiHandler.UpdateLog(closeConnData.Msg);
}
}
}