public ActionResult ExportRun(FilterRunViewModel viewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
FilterRunViewModel filterRunViewModel = null;
ResultsSet resultsSet = null;
FilterPanelModeler filterPanelModeler = new FilterPanelModeler(Request, this.UserSession, viewModel);
status = filterPanelModeler.Run(viewModel, out filterRunViewModel, out resultsSet);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result view model or as Excel
*---------------------------------------------------------------------------------------------------------------------------------*/
Response.ClearContent();
Response.AddHeader("content-disposition", "atachment;filename=" + filterRunViewModel.Name.Replace(" ", "_") + ".xls");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
WriteTsv(resultsSet, Response.Output);
Response.Flush();
Response.End();
return(new EmptyResult());
}
public ActionResult Run(FilterEditorViewModel viewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
RunFilterRequest runFilterRequest = new RunFilterRequest();
runFilterRequest.FilterId.Id = viewModel.FilterId;
runFilterRequest.RowLimit = viewModel._ResultsOptions.RowLimit;
runFilterRequest.ColLimit = viewModel._ResultsOptions.ColLimit;
FilterRunViewModel filterRunViewModel = null;
FilterPanelModeler filterPanelModeler = new FilterPanelModeler(Request, this.UserSession, viewModel);
status = filterPanelModeler.Run(runFilterRequest, out filterRunViewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Filter successfully run");
filterRunViewModel.questStatus = status;
return(Json(filterRunViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Copy(FilterCopyViewModel viewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
FilterCopyViewModel filterCopyViewModel = null;
FilterPanelModeler filterPanelModeler = new FilterPanelModeler(Request, this.UserSession, viewModel);
status = filterPanelModeler.Copy(viewModel, out filterCopyViewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Filter successfully copied. Click on the tableset again to load it.");
filterCopyViewModel.questStatus = status;
return(Json(filterCopyViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Run(FilterRunViewModel viewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
if (viewModel.Items.Count == 0)
{
string items = Request.Form["Items"].ToString();
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
List <FilterItemViewModel> itemsList = javaScriptSerializer.Deserialize <List <FilterItemViewModel> >(items);
viewModel.Items = itemsList;
string resultsOptions = Request.Form["_ResultsOptions"].ToString();
ResultsOptionsViewModel _ResultsOptions = javaScriptSerializer.Deserialize <ResultsOptionsViewModel>(resultsOptions);
viewModel._ResultsOptions = _ResultsOptions;
}
FilterRunViewModel filterRunViewModel = null;
ResultsSet resultsSet = null;
FilterPanelModeler filterPanelModeler = new FilterPanelModeler(Request, this.UserSession, viewModel);
status = filterPanelModeler.Run(viewModel, out filterRunViewModel, out resultsSet);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result view model or as Excel
*---------------------------------------------------------------------------------------------------------------------------------*/
if (viewModel.bExportToExcel)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "atachment;filename=" + filterRunViewModel.Name.Replace(" ", "_") + ".xls");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
WriteTsv(resultsSet, Response.Output);
Response.Flush();
Response.End();
return(new EmptyResult());
}
else
{
status = new questStatus(Severity.Success, "Filter successfully run");
filterRunViewModel.questStatus = status;
return(Json(filterRunViewModel, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(FilterPanelViewModel viewModel)
{
questStatus status = null;
JavaScriptSerializer javaScriptSerializer = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
bool bHaveEditor = false;
if (viewModel.Entities.Count == 0)
{
if (Request.Form["Entities"] != null)
{
string entities = Request.Form["Entities"].ToString();
javaScriptSerializer = javaScriptSerializer != null ? javaScriptSerializer : new JavaScriptSerializer();
List <BootstrapTreenodeViewModel> entitiesList = javaScriptSerializer.Deserialize <List <BootstrapTreenodeViewModel> >(entities);
viewModel.Entities = entitiesList;
}
if (Request.Form["Editor"] != null)
{
string editor = Request.Form["Editor"].ToString();
javaScriptSerializer = javaScriptSerializer != null ? javaScriptSerializer : new JavaScriptSerializer();
FilterEditorViewModel _editor = javaScriptSerializer.Deserialize <FilterEditorViewModel>(editor);
viewModel.Editor = _editor;
bHaveEditor = true;
}
}
if (viewModel.Items.Count == 0)
{
if (Request.Form["Items"] != null)
{
string items = Request.Form["Items"].ToString();
javaScriptSerializer = javaScriptSerializer != null ? javaScriptSerializer : new JavaScriptSerializer();
List <FilterItemViewModel> itemsList = javaScriptSerializer.Deserialize <List <FilterItemViewModel> >(items);
viewModel.Items = itemsList;
}
if (Request.Form["Editor"] != null)
{
if (!bHaveEditor)
{
string editor = Request.Form["Editor"].ToString();
javaScriptSerializer = javaScriptSerializer != null ? javaScriptSerializer : new JavaScriptSerializer();
FilterEditorViewModel _editor = javaScriptSerializer.Deserialize <FilterEditorViewModel>(editor);
viewModel.Editor = _editor;
}
}
}
FilterPanelModeler filterPanelModeler = new FilterPanelModeler(Request, this.UserSession, viewModel);
status = filterPanelModeler.Save(viewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Filter saved");
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}