public questStatus Read(DatabaseId databaseId, out DatabaseEditorViewModel databaseEditorViewModel) { // Initialize questStatus status = null; databaseEditorViewModel = null; // Read Quest.Functional.MasterPricing.Database database = null; DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession); status = databasesMgr.Read(databaseId, out database); if (!questStatusDef.IsSuccess(status)) { return(status); } // Transfer model. databaseEditorViewModel = new DatabaseEditorViewModel(this.UserSession); BufferMgr.TransferBuffer(database, databaseEditorViewModel); return(new questStatus(Severity.Success)); }
public ActionResult Cancel(DatabaseEditorViewModel editorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("LogOperation failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(editorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("Authorize failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Direct user to list *---------------------------------------------------------------------------------------------------------------------------------*/ return(RedirectToAction("Index", "Databases", PropagateQueryString(Request))); }
public ActionResult Database(TablesetEditorViewModel viewModel) { questStatus status = null; TablesetsListViewModel tablesetsListViewModel = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { tablesetsListViewModel = new TablesetsListViewModel(this.UserSession, viewModel); tablesetsListViewModel.questStatus = status; return(View("Index", viewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(viewModel._ctx); if (!questStatusDef.IsSuccess(status)) { tablesetsListViewModel = new TablesetsListViewModel(this.UserSession, viewModel); tablesetsListViewModel.questStatus = status; return(View("Index", viewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Read tableset for the database Id *---------------------------------------------------------------------------------------------------------------------------------*/ TablesetId tablesetId = new TablesetId(viewModel.Id); TablesetEditorViewModel tablesetEditorViewModel = null; TablesetEditorModeler tablesetEditorModeler = new TablesetEditorModeler(this.Request, this.UserSession); status = tablesetEditorModeler.Read(tablesetId, out tablesetEditorViewModel); if (!questStatusDef.IsSuccess(status)) { tablesetsListViewModel = new TablesetsListViewModel(this.UserSession, viewModel); tablesetsListViewModel.questStatus = status; return(View("Index", viewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseEditorViewModel databaseEditorViewModel = new DatabaseEditorViewModel(this.UserSession, viewModel); databaseEditorViewModel.Id = tablesetEditorViewModel.DatabaseId; databaseEditorViewModel.questStatus = new questStatus(Severity.Warning); return(View("~/Areas/Setup/Views/Database/Index.cshtml", databaseEditorViewModel)); }
public questStatus RefreshSchema(DatabaseEditorViewModel databaseEditorViewModel) { // Initialize questStatus status = null; // Refresh schema DatabaseId databaseId = new DatabaseId(databaseEditorViewModel.Id); DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession); status = databaseMgr.RefreshSchema(databaseId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public ActionResult Index(DatabaseEditorViewModel databaseEditorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(View("Index", databaseEditorViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(databaseEditorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(View("Index", databaseEditorViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Read the database info. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseId databaseId = new DatabaseId(databaseEditorViewModel.Id); DatabaseBaseViewModel databaseBaseViewModel = null; DatabaseBaseModeler databaseBaseModeler = new DatabaseBaseModeler(this.Request, this.UserSession); status = databaseBaseModeler.GetDatabase(databaseId, out databaseBaseViewModel); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(View("Index", databaseEditorViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ Quest.MasterPricing.Database.Models.TablesListViewModel tablesListViewModel = new Quest.MasterPricing.Database.Models.TablesListViewModel(this.UserSession, databaseEditorViewModel); tablesListViewModel.DatabaseId = databaseBaseViewModel.Id; tablesListViewModel.Database = databaseBaseViewModel; return(View(tablesListViewModel)); }
public ActionResult Entities(DatabaseEditorViewModel editorViewModel) { questStatus status = null; UserMessageModeler userMessageModeler = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(editorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Perform operation. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseId databaseId = new DatabaseId(editorViewModel.Id); List <BootstrapTreenodeViewModel> dbTableNodeList = null; List <BootstrapTreenodeViewModel> dbViewNodeList = null; TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, editorViewModel); status = tablesetConfigurationModeler.GetDatabaseEntities(databaseId, out dbTableNodeList, out dbViewNodeList); if (!questStatusDef.IsSuccess(status)) { userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return result. *---------------------------------------------------------------------------------------------------------------------------------*/ status = new questStatus(Severity.Success); return(Json(new { Tables = dbTableNodeList, Views = dbViewNodeList }, JsonRequestBehavior.AllowGet)); }
public ActionResult Read(DatabaseEditorViewModel editorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("LogOperation failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(editorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("Authorize failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Perform operation. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseId databaseId = new DatabaseId(editorViewModel.Id); DatabaseEditorViewModel databaseEditorViewModel = null; DatabaseEditorModeler databaseEditorModeler = new Modelers.DatabaseEditorModeler(this.Request, this.UserSession); status = databaseEditorModeler.Read(databaseId, out databaseEditorViewModel); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(editorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return result. *---------------------------------------------------------------------------------------------------------------------------------*/ status = new questStatus(Severity.Success); databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); }
public ActionResult Save(DatabaseEditorViewModel databaseEditorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(databaseEditorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Perform operation. *---------------------------------------------------------------------------------------------------------------------------------*/ bool bInitialCreation = databaseEditorViewModel.Id < BaseId.VALID_ID ? true : false; DatabaseEditorModeler databaseEditorModeler = new DatabaseEditorModeler(this.Request, this.UserSession); status = databaseEditorModeler.Save(databaseEditorViewModel); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return result. *---------------------------------------------------------------------------------------------------------------------------------*/ status = new questStatus(Severity.Success, "Database successfully" + (bInitialCreation ? " created" : " updated")); databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); }
public ActionResult RefreshSchema(DatabaseEditorViewModel databaseEditorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(databaseEditorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Perform operation. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseEditorModeler databaseEditorModeler = new DatabaseEditorModeler(this.Request, this.UserSession); status = databaseEditorModeler.RefreshSchema(databaseEditorViewModel); if (!questStatusDef.IsSuccess(status)) { databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return result. *---------------------------------------------------------------------------------------------------------------------------------*/ status = new questStatus(Severity.Success, "Database schema successfully refreshed"); databaseEditorViewModel.questStatus = status; return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet)); }
/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ #region CRUD //---------------------------------------------------------------------------------------------------------------------------------- // CRUD //---------------------------------------------------------------------------------------------------------------------------------- public questStatus Save(DatabaseEditorViewModel databaseEditorViewModel) { // Initialize questStatus status = null; // Transfer model Quest.Functional.MasterPricing.Database database = new Quest.Functional.MasterPricing.Database(); BufferMgr.TransferBuffer(databaseEditorViewModel, database); // Determine if this is a create or update DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession); if (databaseEditorViewModel.Id < BaseId.VALID_ID) { // Create DatabaseId databaseId = null; status = databaseMgr.Create(database, out databaseId); if (!questStatusDef.IsSuccess(status)) { if (databaseId != null && databaseId.Id >= BaseId.VALID_ID) { databaseEditorViewModel.Id = databaseId.Id; } FormatErrorMessage(status, databaseEditorViewModel); return(status); } databaseEditorViewModel.Id = databaseId.Id; } else { // Update status = databaseMgr.Update(database); if (!questStatusDef.IsSuccess(status)) { FormatErrorMessage(status, databaseEditorViewModel); return(status); } } return(new questStatus(Severity.Success)); }
public ActionResult Index(DatabaseEditorViewModel databaseEditorViewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("LogOperation failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(databaseEditorViewModel._ctx); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("Authorize failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ DatabaseEditorViewModel databaseEditorViewModel2 = new DatabaseEditorViewModel(this.UserSession, databaseEditorViewModel); databaseEditorViewModel2.Id = databaseEditorViewModel.Id; if (databaseEditorViewModel.Id >= BaseId.VALID_ID) { databaseEditorViewModel2.questStatus = new questStatus(Severity.Warning); } else { databaseEditorViewModel2.questStatus = new questStatus(Severity.Success); } return(View(databaseEditorViewModel2)); }