public void update()
{
int verzijaBaze = SqlCeUtilities.getDatabaseVersionNumber();
if (verzijaBaze == Program.VERZIJA_PROGRAMA)
{
return;
}
if (verzijaBaze > Program.VERZIJA_PROGRAMA)
{
throw new Exception("Greska u programu. Verzija baze je veca od verzije programa.");
}
int staraVerzijaBaze = verzijaBaze;
bool converted = false;
if (verzijaBaze == -1 /*baza ne postoji*/)
{
SqlCeUtilities.ExecuteScript(ConfigurationParameters.DatabaseFile, ConfigurationParameters.Password,
"Soko.Update.DatabaseUpdate_version1.txt", true);
SqlCeUtilities.updateDatabaseVersionNumber(1);
verzijaBaze = 1;
converted = true;
}
if (verzijaBaze == 1 && Program.VERZIJA_PROGRAMA > 1)
{
SqlCeUtilities.ExecuteScript(ConfigurationParameters.DatabaseFile, ConfigurationParameters.Password,
"Soko.Update.DatabaseUpdate_version2.txt", true);
SqlCeUtilities.updateDatabaseVersionNumber(2);
UpdateDolazakNaTreningMesecni();
verzijaBaze = 2;
converted = true;
}
if (verzijaBaze == 2 && Program.VERZIJA_PROGRAMA > 2)
{
SqlCeUtilities.updateDatabaseVersionNumber(3);
UpdateDolazakNaTreningMesecniJedanDnevniTrening();
verzijaBaze = 3;
converted = true;
}
if (converted)
{
string msg = String.Format("Baza podataka je konvertovana iz verzije {0} u verziju {1}.", staraVerzijaBaze,
verzijaBaze);
MessageBox.Show(msg, "Bilten");
if (File.Exists("NHibernateConfig"))
{
File.Delete("NHibernateConfig");
}
}
}
public void TestFixtureSetUp()
{
// Export schema from BiltenPodaci.sdf using the ExportSqlCe.exe tool.
string schemaFile = "BiltenPodaciScript.sql";
ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.FileName = @"..\..\..\..\Bilten\Libs\ExportSqlCe.exe";
startInfo.Arguments =
String.Format("\"Data Source=..\\..\\..\\Bilten\\bin\\Debug\\BiltenPodaci.sdf\" {0} schemaonly",
schemaFile);
var process = Process.Start(startInfo);
process.WaitForExit();
// Create database using the schema script, or (if database exists) delete data.
string databaseFile = "BiltenPodaci.sdf";
bool createdNew = SqlCeUtilities.CreateDatabase(databaseFile, "", false);
if (createdNew)
{
// Kreiraj semu
SqlCeUtilities.ExecuteScript(databaseFile, "", Path.GetFullPath(schemaFile), false);
}
else
{
// Brisi podatke
SqlCeUtilities.ExecuteScript(databaseFile, "", Path.GetFullPath(@"..\..\BiltenPodaciDelete.sql"), false);
}
// Create configuration and build session factory.
_configuration = new Configuration();
_configuration.Configure();
_configuration.AddAssembly(typeof(Klub).Assembly);
_sessionFactory = _configuration.BuildSessionFactory();
}
static void Main(string[] args)
{
try
{
int verzijaBaze = SqlCeUtilities.getDatabaseVersionNumber();
if (verzijaBaze != VERZIJA_PROGRAMA)
{
if (verzijaBaze == 0)
{
string msg = "Bazu podataka je nemoguce konvertovati da radi sa trenutnom verzijom programa.";
MessageBox.Show(msg, "Registracija");
return;
}
if (verzijaBaze > VERZIJA_PROGRAMA)
{
string msg = "Greska u programu. Verzija baze je veca od verzije programa.";
MessageBox.Show(msg, "Registracija");
return;
}
bool converted = false;
if (verzijaBaze == 1 && VERZIJA_PROGRAMA > 1)
{
SqlCeUtilities.ExecuteScript(ConfigurationParameters.DatabaseFile, "",
"Registracija.Update.DatabaseUpdate_version2.sql", true);
verzijaBaze = 2;
converted = true;
}
if (converted)
{
string msg = String.Format("Baza podataka je konvertovana u verziju {0}.", verzijaBaze);
MessageBox.Show(msg, "Bilten");
if (File.Exists("NHibernateConfig"))
{
File.Delete("NHibernateConfig");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
Language.SetKeyboardLanguage(Language.acKeyboardLanguage.hklSerbianLatin);
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("sr-Latn-CS");
// ili
// Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("sr-Cyrl-CS");
//Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture;
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
// Kreiranje prazne baze
//new SqlCeUtilities().CreateDatabase(@"..\..\clanovi_podaci2.sdf", "sdv");
//new DatabaseUpdater().updateDatabase();
//MainForm mainForm = new MainForm();
//Application.Run(mainForm);
SingleInstanceApplication.Application.Run(args);
}