/// <summary> Return current version of database. </summary>
public static bool TryGetCurrentDatabaseVersion(out Version version)
{
bool result = false;
version = new Version();
try
{
result = TryParseVersion(MyDataBase.GetDB().ExecuteQueryWithAnswer($"SELECT {db_field} FROM {db_table}"), out version);
}
catch { }
return(result);
}
/// <summary> Check connection string for correctness and require the user to enter the correct connection string if needed. </summary>
private static void CheckConnectionString()
{
string connectionString = Configuration.GetVariable("ConnectionString");
while (string.IsNullOrEmpty(connectionString) || !MyDataBase.GetDB().TestConnectionString(connectionString))
{
ConsoleUtility.WriteLine("Connection string not set or entered incorrectly.", TextColor);
ConsoleUtility.WriteLine(">>>Enter connection string:", TextColor);
connectionString = ConsoleUtility.ReadLine(TextColor);
Console.WriteLine();
}
Configuration.SetVariable("ConnectionString", connectionString);
}
/// <summary> Return current version of database. </summary>
public static bool TryGetCurrentDatabaseVersion(out double version)
{
bool isGetted = false;
version = -1;
try
{
version = double.Parse(MyDataBase.GetDB().ExecuteQueryWithAnswer("SELECT version FROM db_version"));
isGetted = true;
}
catch { }
return(isGetted);
}
private static void Main()
{
CheckConfigurationVariables();
// IT'S FOR TESTS
if (!MyDataBase.GetDB().IsExistringTable("db_version"))
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer("CREATE TABLE db_versions (verions INT)");
MyDataBase.GetDB().ExecuteQueryWithoutAnswer("INSERT INTO db_versions VALUES (1.2505)");
}
else
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer("UPDATE db_version SET version = 1.2505");
}
ShowMainMenu();
}
/// <summary> Check connection string for correctness and require the user to enter the correct connection string if needed. </summary>
public static bool CheckConnectionString(string connectionString)
{
return(string.IsNullOrEmpty(connectionString) || !MyDataBase.GetDB().TestConnectionString(connectionString));
}
/// <summary> Set database version. </summary>
public static void TrySetCurrentDatabaseVersion(Version version)
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer($"UPDATE {db_table} SET {db_field} = '{version.ToString()}'");
}