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 Delete(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");
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
DatabaseId databaseId = new DatabaseId(databaseEditorViewModel.Id);
DatabaseEditorModeler databaseEditorModeler = new DatabaseEditorModeler(this.Request, this.UserSession);
status = databaseEditorModeler.Delete(databaseId);
if (!questStatusDef.IsSuccess(status))
{
databaseEditorViewModel.questStatus = status;
return(Json(databaseEditorViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Database successfully deleted");
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 ActionResult DatabaseIdOptions()
{
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();
if (!questStatusDef.IsSuccess(status))
{
UserMessageModeler userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler.UserMessage, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
List <OptionValuePair> optionValuePairList = null;
DatabaseEditorModeler databaseEditorModeler = new DatabaseEditorModeler(this.Request, this.UserSession);
status = databaseEditorModeler.GetDatabaseOptions(out optionValuePairList);
if (!questStatusDef.IsSuccess(status))
{
UserMessageModeler userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler.UserMessage, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Respond
*---------------------------------------------------------------------------------------------------------------------------------*/
return(Json(optionValuePairList, JsonRequestBehavior.AllowGet));
}
