public ActionResult InstallDatabase()
{
try
{
var connectionString = MyTasks.Infrastructure.Configuration.Application.ConnectionString;
DatabaseInstallerByObject.BuildDatabase(DatabaseInstallerByObject.ReadKeyFromPosition.Prefix, connectionString);
TempData["InstallResult"] = new UpdateResult()
{
IsSucceed = true,
ResultMessage = Desktop.DatabaseInstalled
};
MvcApplication.ApplicationSettings =
ApplicationSettingContainer.Create(unitOfWork.ApplicationSettingsRepository.All().ToList());
return(RedirectToAction("FirstInstall"));
}
catch (DatabaseInstallerException dbException)
{
TempData["InstallResult"] = new UpdateResult()
{
IsSucceed = false,
ResultMessage = Desktop.DatabaseInstallError + ":" + dbException.Message
};
return(RedirectToAction("FirstInstall"));
}
}
public ActionResult UpdateDatabase()
{
try
{
var connectionString = MyTasks.Infrastructure.Configuration.Application.ConnectionString;
DatabaseInstallerByObject.BuildDatabase(DatabaseInstallerByObject.ReadKeyFromPosition.Prefix, connectionString);
TempData["UpdateResult"] = new UpdateResult()
{
IsSucceed = true,
ResultMessage = Desktop.DatabaseUpdated
};
MvcApplication.ApplicationSettings = ApplicationSettingContainer.Create(unitOfWork.ApplicationSettingsRepository.All().ToList());
return(RedirectToAction("Index"));
}
catch (DatabaseInstallerException dbException)
{
TempData["UpdateResult"] = new UpdateResult()
{
IsSucceed = false,
ResultMessage = Desktop.DbUpdateError + ":" + dbException.Message
};
Elmah.ErrorLog.GetDefault(System.Web.HttpContext.Current).Log(new Elmah.Error(dbException));
return(RedirectToAction("Index"));
}
}
private void SetApplicationSettings()
{
try
{
ApplicationSettings = ApplicationSettingContainer.Create(unitOfWork.ApplicationSettingsRepository.All().ToList());
}
catch (Exception e)
{
//do nothing because database is not created yet
}
}
public ActionResult CreateInstallDatabase()
{
try
{
var rootConnectionString = MyTasks.Infrastructure.Configuration.Application.RootConnectionString;
var connectionString = MyTasks.Infrastructure.Configuration.Application.ConnectionString;
var databaseIsNotInstalled = !DatabaseInstallerByObject.IsDatabasseInstalled(rootConnectionString, connectionString);
if (databaseIsNotInstalled)
{
DatabaseInstallerByObject.CreateAndBuildDatabase(rootConnectionString, connectionString);
TempData["InstallResult"] = new UpdateResult()
{
IsSucceed = true,
ResultMessage = Desktop.DatabaseInstalled
};
MvcApplication.ApplicationSettings =
ApplicationSettingContainer.Create(unitOfWork.ApplicationSettingsRepository.All().ToList());
return(RedirectToAction("FirstInstall"));
}
else
{
TempData["InstallResult"] = new UpdateResult()
{
IsSucceed = false,
ResultMessage = Desktop.DatabaseAlreadyInstalled
};
return(RedirectToAction("FirstInstall"));
}
}
catch (DatabaseInstallerException dbException)
{
TempData["InstallResult"] = new UpdateResult()
{
IsSucceed = false,
ResultMessage = Desktop.DatabaseInstallError + ":" + dbException.Message
};
return(RedirectToAction("FirstInstall"));
}
}
public ActionResult EditAppSetting([Bind(Include = "SettingId,ConfigurationKey,ConfigurationValue,DefaultValue,Description")] ApplicationSettings setting)
{
if (setting == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var appSettingToUpdate = unitOfWork.ApplicationSettingsRepository.FindById(setting.SettingId);
try
{
unitOfWork.ApplicationSettingsRepository.UpdateSetting(setting.ConfigurationKey, setting.ConfigurationValue);
unitOfWork.SaveChanges();
MvcApplication.ApplicationSettings = ApplicationSettingContainer.Create(unitOfWork.ApplicationSettingsRepository.All().ToList());
return(RedirectToAction("Index"));
}
catch (Exception /* dex */)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
}
return(View(appSettingToUpdate));
}
