private void btnOk_Click(object sender, EventArgs e)
{
SetWindowsStartUp(this.checkBox.Checked);
Configuration c = new Configuration(ConfigurationKey.DataMaintenanceDays, Convert.ToInt32(this.numericUpDown.Value));
ConfigurationHelper.SaveConfiguration(c);
c = new Configuration(ConfigurationKey.TasksLogDuration, Convert.ToInt32(this.trackBar.Value));
ConfigurationHelper.SaveConfiguration(c);
if (this.checkBox1.Checked)
c = new Configuration(ConfigurationKey.CheckForUpdates, 1);
else
c = new Configuration(ConfigurationKey.CheckForUpdates, 0);
ConfigurationHelper.SaveConfiguration(c);
if (this.checkBox2.Checked)
c = new Configuration(ConfigurationKey.PlaySoundOnReminder, 1);
else
c = new Configuration(ConfigurationKey.PlaySoundOnReminder, 0);
ConfigurationHelper.SaveConfiguration(c);
this.Close();
}
private static bool UpdateFromV_1_0_1ToV_1_0_2(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "1.0.1") == 0)
{
try
{
DbHelper.AddColumn("ApplicationsLog", "Caption", "VarChar(255)");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "1.0.2"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV00ToV09(Configuration oldVersion)
{
if (oldVersion == null)
{
try
{
DbHelper.ExecuteNonQuery("Delete from Configuration");
DbHelper.DeleteConstraint("Configuration", "PrimaryKey");
DbHelper.DeleteConstraint("Configuration", "Id");
DbHelper.DeleteColumn("Configuration", "Id");
DbHelper.DeleteColumn("Configuration", "ListValue");
DbHelper.AddPrimaryKey("Configuration", "KeyValue");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9"));
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataMaintenanceDays, 7));
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.TasksLogDuration, 10));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV_0_9_10_ToV_1_0_0(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.10") == 0)
{
try
{
DbHelper.AddColumn("Tasks", "Hidden", "Bit");
DbHelper.AddColumn("Tasks", "Priority", "Integer");
DbHelper.AddColumn("Tasks", "Notes", "VarChar(255)");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "1.0.0"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV_1_0_0ToV_1_0_1(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "1.0.0") == 0)
{
try
{
DbHelper.AddIndex("TasksLog", "InsertTime");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "1.0.1"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV099ToV0910(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.9") == 0)
{
try
{
DbHelper.AddColumn("Tasks", "Estimation", "Integer");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.10"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV09ToV091(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9") == 0)
{
try
{
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.CheckForUpdates, "1"));
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.1"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV096ToV97(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.6") == 0)
{
try
{
DbHelper.DeleteColumn("Tasks", "StartDate");
DbHelper.DeleteColumn("Tasks", "StopDate");
DbHelper.DeleteColumn("Tasks", "IsFinished");
DbHelper.DeleteColumn("Tasks", "TotalTime");
DbHelper.DeleteColumn("ApplicationsLog", "ProcessId");
DbHelper.DeleteColumn("ApplicationsLog", "Caption");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.7"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV097ToV098(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.7") == 0)
{
try
{
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.PlaySoundOnReminder, "1"));
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.8"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV095ToV96(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.5") == 0)
{
try
{
DataMaintenanceHelper.GroupLogs(true);
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.6"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV094ToV95(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.4") == 0)
{
try
{
DbHelper.AddColumn("Tasks", "IsActive", "Bit");
DbHelper.AddColumn("Tasks", "IconId", "Integer");
DbHelper.ExecuteNonQuery("Update Tasks Set IsActive = 1, IconId = " + IconsManager.DefaultTaskIconId);
Application.DoEvents();
DbHelper.ExecuteNonQuery(
"UPDATE Tasks INNER JOIN DefaultTasks ON Tasks.DefaultTaskId = DefaultTasks.Id SET Tasks.IsActive = DefaultTasks.IsActive, Tasks.IconId = DefaultTasks.Icon, Tasks.Description = DefaultTasks.Description");
Application.DoEvents();
DbHelper.DeleteTable("DefaultTasks");
Application.DoEvents();
DbHelper.DeleteConstraint("Tasks", "IsDefaultTask");
DbHelper.DeleteConstraint("Tasks", "DefaultTaskId");
DbHelper.DeleteColumn("Tasks", "IsDefaultTask");
DbHelper.DeleteColumn("Tasks", "DefaultTaskId");
Application.DoEvents();
DbHelper.ExecuteNonQuery("Delete from Tasks where Description = 'Idle'");
Application.DoEvents();
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.5"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV092ToV093(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.2") == 0)
{
try
{
DbHelper.AddColumn("DefaultTasks", "IsActive", "Bit");
DbHelper.AddColumn("DefaultTasks", "Icon", "Integer");
DbHelper.AddColumn("DefaultTasks", "Hidden", "Bit");
string updateQuery = "Update DefaultTasks Set IsActive = ?, Icon = ?, Hidden = ? Where Id = ?";
string[] parameterNames = new string[] {"IsActive", "Icon", "Hidden", "Id"};
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {false, 0, false, 1});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {false, 2, false, 2});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {false, 3, false, 3});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {true, 4, false, 4});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {true, 5, false, 5});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {false, 6, false, 6});
DbHelper.ExecuteNonQuery(updateQuery, parameterNames,
new object[] {true, 7, false, 7});
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.3"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
private static bool UpdateFromV091ToV092(Configuration oldVersion)
{
if (string.Compare(oldVersion.Value.ToString().Trim(), "0.9.1") == 0)
{
try
{
DbHelper.CreateTable("Addins");
DbHelper.AddColumn("Addins", "Path", "VarChar(255)");
ConfigurationHelper.SaveConfiguration(new Configuration(ConfigurationKey.DataBaseVersion, "0.9.2"));
return true;
}
catch (OleDbException ex)
{
Logger.WriteException(ex);
return false;
}
}
return false;
}
public static void SaveConfiguration(Configuration configuration)
{
switch (configuration.Key)
{
case ConfigurationKey.TasksLogDuration:
if (Convert.ToInt32(configuration.Value) < 1 ||
Convert.ToInt32(configuration.Value) > 60)
throw new ApplicationException("The log duration can't be less than 1 min. and more than 60 min.");
break;
case ConfigurationKey.DataMaintenanceDays:
if (Convert.ToInt32(configuration.Value) < 0)
throw new ApplicationException("Data maintenance days can't be less than 0.");
break;
}
if (GetConfiguration(configuration.Key) != null)
{
DbHelper.ExecuteNonQuery("UPDATE Configuration SET ConfigValue = ? WHERE KeyValue = " +
((int) configuration.Key).ToString(), new string[] {"ConfigValue"},
new object[] {configuration.Value});
}
else
{
DbHelper.ExecuteNonQuery("INSERT INTO Configuration (KeyValue, Description, ConfigValue) VALUES (?, ?, ?)",
new string[] {"KeyValue", "Description", "ConfigValue"},
new object[] {(int) configuration.Key, configuration.Key.ToString(), configuration.Value});
}
}
