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)); }