public static void LogApplicationRestart(bool checkPing, bool checkDbVersion)
{
if (checkPing)
{
if (!DataBaseService.PingDateBase())
{
return; // Fail connection to DB
}
}
if (checkDbVersion)
{
if (!DataBaseService.CheckDBVersion())
{
return; // Wrong version of DB
}
}
SQLDataAccess.ExecuteNonQuery("INSERT INTO [Internal].[AppRestartLog] ([RestartDate], [ServerName]) VALUES (@RestartDate, @ServerName);",
CommandType.Text,
new SqlParameter("@RestartDate", DateTime.Now),
new SqlParameter("@ServerName", Dns.GetHostName()));
SQLDataAccess.ExecuteNonQuery("DELETE FROM [Internal].[AppRestartLog] WHERE ID < (SELECT MAX(ID) - 300 FROM [Internal].[AppRestartLog]);", CommandType.Text);
}
