internal override void GetVersion()
{
var storedProcedures = Directory.GetFiles("./../../../DataBaseAccess/Source/", "sp_*.sql");
String createDbScript = File.ReadAllText("./../../../DataBaseAccess/Source/CreateDataBase.sql");
using (SqlConnection conn = CDbConnection.GetServerConnection())
{
try
{
conn.Open();
SqlCommand cmd0 = new SqlCommand("CREATE DATABASE ONLOOKER", conn);
cmd0.ExecuteNonQuery();
cmd0.Dispose();
SqlCommand cmd = new SqlCommand(createDbScript, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
foreach (var sqlScriptFile in storedProcedures)
{
String sqlExpression = File.ReadAllText(sqlScriptFile);
SqlCommand cmd2 = new SqlCommand(sqlExpression, conn);
cmd2.ExecuteNonQuery();
cmd2.Dispose();
}
}
catch (Exception e)
{
//SLogger.Log.Fatal("Unexpected termination: " + e.Message);
throw new Exception("Unhendled exception" + e.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
InsertDefaultValues();
}
}
