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