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