public ActionResult Cancel(DataMgrTablesetViewModel viewModel) { questStatus status = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("LogOperation failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(viewModel._ctx); if (!questStatusDef.IsSuccess(status)) { // TODO throw new Exception("Authorize failed"); } /*---------------------------------------------------------------------------------------------------------------------------------- * Direct user to list *---------------------------------------------------------------------------------------------------------------------------------*/ return(RedirectToAction("Index", "DataMgr", PropagateQueryString(Request))); }
public ActionResult Entities(DataMgrTablesetViewModel viewModel) { questStatus status = null; DataMgrTablesetViewModel dataMgrTablesetViewModel = null; UserMessageModeler userMessageModeler = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(viewModel._ctx); if (!questStatusDef.IsSuccess(status)) { userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Redirect to Tablesets if no tablesetId specified. *---------------------------------------------------------------------------------------------------------------------------------*/ if (viewModel.Id < BaseId.VALID_ID) { status = new questStatus(Severity.Error, "Invalid Id value. Must be 1 or greater."); userMessageModeler = new UserMessageModeler(status); return(Json(userMessageModeler, JsonRequestBehavior.AllowGet)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Read tableset data management info. *---------------------------------------------------------------------------------------------------------------------------------*/ TablesetId tablesetId = new TablesetId(viewModel.Id); TablesetDataModeler tablesetDataModeler = new TablesetDataModeler(this.Request, this.UserSession, viewModel); status = tablesetDataModeler.Read(tablesetId, out dataMgrTablesetViewModel); if (!questStatusDef.IsSuccess(status)) { dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, viewModel); dataMgrTablesetViewModel.questStatus = status; return(View(dataMgrTablesetViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ status = new questStatus(Severity.Success); dataMgrTablesetViewModel.questStatus = status; return(Json(dataMgrTablesetViewModel, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(DataMgrTablesetViewModel viewModel) { questStatus status = null; DataMgrTablesetViewModel dataMgrTablesetViewModel = null; /*---------------------------------------------------------------------------------------------------------------------------------- * Log Operation *---------------------------------------------------------------------------------------------------------------------------------*/ status = LogOperation(); if (!questStatusDef.IsSuccess(status)) { dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, viewModel); dataMgrTablesetViewModel.questStatus = status; return(View(dataMgrTablesetViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Authorize *---------------------------------------------------------------------------------------------------------------------------------*/ status = Authorize(viewModel._ctx); if (!questStatusDef.IsSuccess(status)) { dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, viewModel); dataMgrTablesetViewModel.questStatus = status; return(View(dataMgrTablesetViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Redirect to Tablesets if no tablesetId specified. *---------------------------------------------------------------------------------------------------------------------------------*/ if (viewModel.Id < BaseId.VALID_ID) { return(RedirectToAction("Index", "DataMgr", PropagateQueryString(Request))); } /*---------------------------------------------------------------------------------------------------------------------------------- * Read tableset data management info. *---------------------------------------------------------------------------------------------------------------------------------*/ TablesetId tablesetId = new TablesetId(viewModel.Id); TablesetDataModeler tablesetDataModeler = new TablesetDataModeler(this.Request, this.UserSession, viewModel); status = tablesetDataModeler.Read(tablesetId, out dataMgrTablesetViewModel); if (!questStatusDef.IsSuccess(status)) { dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, viewModel); dataMgrTablesetViewModel.questStatus = status; return(View(dataMgrTablesetViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ return(View(dataMgrTablesetViewModel)); }
public ActionResult Filters(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 data management info. *---------------------------------------------------------------------------------------------------------------------------------*/ DataMgrBaseViewModel dataMgrBaseViewModel = new DataMgrBaseViewModel(this.UserSession); BufferMgr.TransferBuffer(viewModel, dataMgrBaseViewModel); TablesetId tablesetId = new TablesetId(viewModel.Id); DataMgrTablesetViewModel dataMgrTablesetViewModel = null; TablesetDataModeler tablesetDataModeler = new TablesetDataModeler(this.Request, this.UserSession, dataMgrBaseViewModel); status = tablesetDataModeler.Read(tablesetId, out dataMgrTablesetViewModel); if (!questStatusDef.IsSuccess(status)) { dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, viewModel); dataMgrTablesetViewModel.questStatus = status; return(View(dataMgrTablesetViewModel)); } /*---------------------------------------------------------------------------------------------------------------------------------- * Return view. *---------------------------------------------------------------------------------------------------------------------------------*/ return(View("~/Areas/DataMgr/Views/Tableset/Index.cshtml", dataMgrTablesetViewModel)); }
/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus Read(TablesetId tablesetId, out DataMgrTablesetViewModel dataMgrTablesetViewModel) { // Initialize questStatus status = null; dataMgrTablesetViewModel = null; // Read tableset data management. TablesetDataManagement tablesetDataManagement = null; TablesetMgr tablesetMgr = new TablesetMgr(this.UserSession); status = tablesetMgr.ReadTablesetDataManagement(tablesetId, out tablesetDataManagement); if (!questStatusDef.IsSuccess(status)) { return(status); } // List lookups DatabaseId databaseId = new DatabaseId(tablesetDataManagement.TablesetConfiguration.Database.Id); List <BootstrapTreenodeViewModel> lookupNodeList = null; status = ListLookups(databaseId, out lookupNodeList); if (!questStatusDef.IsSuccess(status)) { return(status); } // List TypeLists List <BootstrapTreenodeViewModel> typeListNodeList = null; status = ListTypeLists(databaseId, out typeListNodeList); if (!questStatusDef.IsSuccess(status)) { return(status); } // Load all folders FolderId folderId = null; List <FilterFolder> filterFolderList = null; FilterFoldersMgr filterFoldersMgr = new FilterFoldersMgr(this.UserSession); status = filterFoldersMgr.Load(folderId, out filterFolderList); if (!questStatusDef.IsSuccess(status)) { return(status); } // Build model dataMgrTablesetViewModel = new DataMgrTablesetViewModel(this.UserSession, this._dataMgrBaseViewModel); dataMgrTablesetViewModel.TablesetId = tablesetId.Id; BufferMgr.TransferBuffer(tablesetDataManagement.TablesetConfiguration.Tableset, dataMgrTablesetViewModel.Tableset); if (dataMgrTablesetViewModel.Tableset.Summary == null) { dataMgrTablesetViewModel.Tableset.Summary = ""; } dataMgrTablesetViewModel.Tableset.LastRefresh = ""; dataMgrTablesetViewModel.Tableset.LastRefresh = tablesetDataManagement.TablesetConfiguration.Tableset.LastRefresh.HasValue ? tablesetDataManagement.TablesetConfiguration.Tableset.LastRefresh.Value.ToString("MM/dd/yyyy HH:mm:ss") : ""; foreach (TablesetTable tablesetTable in tablesetDataManagement.TablesetConfiguration.TablesetTables) { tablesetTable.bColumnsSelectable = false; BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null; status = FormatBootstrapTreeviewNode(tablesetTable, out bootstrapTreenodeViewModel); if (!questStatusDef.IsSuccess(status)) { return(status); } dataMgrTablesetViewModel.TableList.Add(bootstrapTreenodeViewModel); } foreach (TablesetView tablesetView in tablesetDataManagement.TablesetConfiguration.TablesetViews) { BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null; status = FormatBootstrapTreeviewNode(tablesetView, out bootstrapTreenodeViewModel); if (!questStatusDef.IsSuccess(status)) { return(status); } dataMgrTablesetViewModel.ViewList.Add(bootstrapTreenodeViewModel); } dataMgrTablesetViewModel.Lookups = lookupNodeList; dataMgrTablesetViewModel.TypeLists = typeListNodeList; foreach (FilterFolder filterFolder in filterFolderList) { BootstrapTreenodeViewModel bootstrapTreenodeViewModel = null; status = FormatBootstrapTreeviewNode(filterFolder, out bootstrapTreenodeViewModel); if (!questStatusDef.IsSuccess(status)) { return(status); } dataMgrTablesetViewModel.Folders.Add(bootstrapTreenodeViewModel); } return(new questStatus(Severity.Success)); }