public ActionResult Index(TablesetEditorViewModel editorViewModel)
        {
            questStatus status = null;
            TablesetConfigurationViewModel tablesetConfigurationViewModel = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                tablesetConfigurationViewModel             = new TablesetConfigurationViewModel(this.UserSession, editorViewModel);
                tablesetConfigurationViewModel.questStatus = status;
                return(View(tablesetConfigurationViewModel));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(editorViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                tablesetConfigurationViewModel             = new TablesetConfigurationViewModel(this.UserSession, editorViewModel);
                tablesetConfigurationViewModel.questStatus = status;
                return(View(tablesetConfigurationViewModel));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Read tableset configuration.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetId tablesetId = new TablesetId(editorViewModel.Id);
            TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, editorViewModel);

            status = tablesetConfigurationModeler.Read(tablesetId, out tablesetConfigurationViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                if (tablesetConfigurationViewModel == null)
                {
                    tablesetConfigurationViewModel = new TablesetConfigurationViewModel(this.UserSession, editorViewModel);
                }
                tablesetConfigurationViewModel.questStatus = status;
                return(View(tablesetConfigurationViewModel));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return view.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            return(View(tablesetConfigurationViewModel));
        }
Exemple #2
0
        public ActionResult Configuration(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 configuration.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetConfigurationViewModel tablesetConfigurationViewModel = null;
            TablesetId tablesetId = new TablesetId(viewModel.Id);
            TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, viewModel);

            status = tablesetConfigurationModeler.Read(tablesetId, out tablesetConfigurationViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                tablesetsListViewModel             = new TablesetsListViewModel(this.UserSession, viewModel);
                tablesetsListViewModel.questStatus = status;
                return(View("Index", viewModel));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return view.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            return(View("~/Areas/Setup/Views/TablesetConfiguration/Index.cshtml", tablesetConfigurationViewModel));
        }
        public ActionResult Read(TablesetConfigurationViewModel 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.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetId tablesetId = new TablesetId(editorViewModel.Id >= BaseId.VALID_ID ? editorViewModel.Id : editorViewModel.TablesetId);
            TablesetConfigurationViewModel tablesetConfigurationViewModel = null;
            TablesetConfigurationModeler   tablesetConfigurationModeler   = new TablesetConfigurationModeler(this.Request, this.UserSession, editorViewModel);

            status = tablesetConfigurationModeler.Read(tablesetId, out tablesetConfigurationViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                userMessageModeler = new UserMessageModeler(status);
                return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return result.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = new questStatus(Severity.Success);
            tablesetConfigurationViewModel.questStatus = status;
            return(Json(tablesetConfigurationViewModel, JsonRequestBehavior.AllowGet));
        }
        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 Delete(TablesetEditorViewModel tablesetEditorViewModel)
        {
            questStatus status = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                // TODO
                throw new Exception("LogOperation failed");
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(tablesetEditorViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                // TODO
                throw new Exception("Authorize failed");
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Perform operation.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetId tablesetId = new TablesetId(tablesetEditorViewModel.Id);
            TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, tablesetEditorViewModel);

            status = tablesetConfigurationModeler.Delete(tablesetId);
            if (!questStatusDef.IsSuccess(status))
            {
                tablesetEditorViewModel.questStatus = status;
                return(Json(tablesetEditorViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return result.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = new questStatus(Severity.Success, "Tableset configuration successfully deleted");
            tablesetEditorViewModel.questStatus = status;
            return(Json(tablesetEditorViewModel, JsonRequestBehavior.AllowGet));
        }
        public JsonResult Save(TablesetConfigurationViewModel editorViewModel)
        {
            questStatus status = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                editorViewModel.questStatus = status;
                return(Json(editorViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(editorViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                editorViewModel.questStatus = status;
                return(Json(editorViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Perform operation.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, editorViewModel);

            status = tablesetConfigurationModeler.Save(editorViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                editorViewModel.questStatus = status;
                return(Json(editorViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return result.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = new questStatus(Severity.Success, "Tableset configuration successfully saved");
            editorViewModel.questStatus = status;
            return(Json(editorViewModel, JsonRequestBehavior.AllowGet));
        }
        public ActionResult Configuration(TablesetEditorViewModel editorViewModel)
        {
            questStatus status = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                UserMessageModeler userMessageModeler = new UserMessageModeler(status);
                return(Json(userMessageModeler.UserMessage, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(editorViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                UserMessageModeler userMessageModeler = new UserMessageModeler(status);
                return(Json(userMessageModeler.UserMessage, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Read tableset configuration.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            TablesetId tablesetId = new TablesetId(editorViewModel.Id);
            TablesetConfigurationViewModel tablesetConfigurationViewModel = null;
            TablesetConfigurationModeler   tablesetConfigurationModeler   = new TablesetConfigurationModeler(this.Request, this.UserSession, editorViewModel);

            status = tablesetConfigurationModeler.Read(tablesetId, out tablesetConfigurationViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                UserMessageModeler userMessageModeler = new UserMessageModeler(status);
                return(Json(userMessageModeler.UserMessage, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return view.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            return(View(tablesetConfigurationViewModel));
        }