public ActionResult Index(BaseUserSessionViewModel baseUserSessionViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
baseUserSessionViewModel.questStatus = status;
return(View("Index", baseUserSessionViewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(baseUserSessionViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
baseUserSessionViewModel.questStatus = status;
return(View("Index", baseUserSessionViewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return view.
*---------------------------------------------------------------------------------------------------------------------------------*/
TablesetsListViewModel tablesetsListViewModel = new TablesetsListViewModel(this.UserSession, baseUserSessionViewModel);
return(View(tablesetsListViewModel));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region CRUD
//----------------------------------------------------------------------------------------------------------------------------------
// CRUD
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(out TablesetsListViewModel tablesetsListViewModel)
{
// Initialize
questStatus status = null;
tablesetsListViewModel = null;
// Get query options from query string
QueryOptions queryOptions = null;
BaseListModeler baseListModeler = new BaseListModeler(this.HttpRequestBase, new UserSession());
status = baseListModeler.ParsePagingOptions(this.HttpRequestBase, out queryOptions);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Set up query options.
// TEMPORARY: OPTIMIZE THIS
List <SearchField> searchFieldList = new List <SearchField>();
SearchOptions searchOptions = new SearchOptions();
searchOptions.SearchFieldList = searchFieldList;
queryOptions.SearchOptions = searchOptions;
// List
status = List(queryOptions, out tablesetsListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(out TablesetsListViewModel tablesetsListViewModel)
{
// Initialize
questStatus status = null;
tablesetsListViewModel = null;
// Get query options from query string
QueryOptions queryOptions = null;
BaseListModeler baseListModeler = new BaseListModeler(this.HttpRequestBase, new UserSession());
status = baseListModeler.ParsePagingOptions(this.HttpRequestBase, out queryOptions);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// List
status = List(queryOptions, out tablesetsListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public ActionResult List(TablesetsListViewModel tablesetsListViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
tablesetsListViewModel.questStatus = status;
return(Json(tablesetsListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(tablesetsListViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
tablesetsListViewModel.questStatus = status;
return(Json(tablesetsListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Get list of items.
*---------------------------------------------------------------------------------------------------------------------------------*/
TablesetsListViewModel tablesetsListViewModelNEW = null;
TablesetsListModeler tablesetsListModeler = new TablesetsListModeler(this.Request, this.UserSession);
status = tablesetsListModeler.List(out tablesetsListViewModelNEW);
if (!questStatusDef.IsSuccess(status))
{
tablesetsListViewModel.questStatus = status;
return(Json(tablesetsListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result view model or as Excel
*---------------------------------------------------------------------------------------------------------------------------------*/
if (tablesetsListViewModel.bExportToExcel)
{
string filename = "TablesetsLog_" + DateTime.Now.ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "atachment;filename=" + filename + ".xls");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
writeTsv(tablesetsListViewModelNEW, Response.Output);
Response.Flush();
Response.End();
return(new EmptyResult());
}
else
{
status = new questStatus(Severity.Success);
tablesetsListViewModelNEW.questStatus = status;
return(Json(tablesetsListViewModelNEW, JsonRequestBehavior.AllowGet));
}
}
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 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 ActionResult Next(TablesetsListViewModel requisitionListViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
requisitionListViewModel.questStatus = status;
return(Json(requisitionListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(requisitionListViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
requisitionListViewModel.questStatus = status;
return(Json(requisitionListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Get list of items.
*---------------------------------------------------------------------------------------------------------------------------------*/
// TODO.
TablesetsListViewModel tablesetsListViewModelNEW = null;
TablesetsListModeler tablesetsListModeler = new TablesetsListModeler(this.Request, this.UserSession);
status = tablesetsListModeler.List(out tablesetsListViewModelNEW);
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
requisitionListViewModel.questStatus = status;
return(Json(requisitionListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return view
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success);
tablesetsListViewModelNEW.questStatus = status;
return(Json(tablesetsListViewModelNEW, JsonRequestBehavior.AllowGet));
}
//----------------------------------------------------------------------------------------------------------------------------------
// Options
//----------------------------------------------------------------------------------------------------------------------------------
#endregion
#region Validations
//----------------------------------------------------------------------------------------------------------------------------------
// Validations
//----------------------------------------------------------------------------------------------------------------------------------
#endregion
#region Commands
//----------------------------------------------------------------------------------------------------------------------------------
// Commands
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus Clear(TablesetsListViewModel tablesetsListViewModel)
{
// Initialize
questStatus status = null;
TablesetLogsMgr tablesetLogsMgr = new TablesetLogsMgr(this.UserSession);
status = tablesetLogsMgr.Clear();
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public ActionResult Configuration(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 configuration.
*---------------------------------------------------------------------------------------------------------------------------------*/
TablesetConfigurationViewModel tablesetConfigurationViewModel = null;
TablesetId tablesetId = new TablesetId(viewModel.Id);
TablesetConfigurationModeler tablesetConfigurationModeler = new TablesetConfigurationModeler(this.Request, this.UserSession, viewModel);
status = tablesetConfigurationModeler.Read(tablesetId, out tablesetConfigurationViewModel);
if (!questStatusDef.IsSuccess(status))
{
tablesetsListViewModel = new TablesetsListViewModel(this.UserSession, viewModel);
tablesetsListViewModel.questStatus = status;
return(View("Index", viewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return view.
*---------------------------------------------------------------------------------------------------------------------------------*/
return(View("~/Areas/Setup/Views/TablesetConfiguration/Index.cshtml", tablesetConfigurationViewModel));
}
public ActionResult Clear(TablesetsListViewModel 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.
*---------------------------------------------------------------------------------------------------------------------------------*/
TablesetsListModeler tablesetsListModeler = new TablesetsListModeler(this.Request, this.UserSession);
status = tablesetsListModeler.Clear(viewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Tableset log successfully cleared");
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
public questStatus List(QueryOptions queryOptions, out TablesetsListViewModel tablesetsListViewModel)
{
// Initialize
questStatus status = null;
tablesetsListViewModel = null;
// List
QueryResponse queryResponse = null;
List <Quest.Functional.Logging.TablesetLog> tablesetLogList = null;
TablesetLogsMgr tablesetLogsMgr = new TablesetLogsMgr(this.UserSession);
status = tablesetLogsMgr.List(queryOptions, out tablesetLogList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort
tablesetLogList.Sort(delegate(Quest.Functional.Logging.TablesetLog i1, Quest.Functional.Logging.TablesetLog i2) { return(i2.Created.CompareTo(i1.Created)); });
// Transfer model.
// TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsViewModel.
tablesetsListViewModel = new TablesetsListViewModel(this.UserSession);
QueryResponseViewModel queryResponseViewModel = null;
status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetsListViewModel.QueryResponse = queryResponseViewModel;
foreach (Quest.Functional.Logging.TablesetLog tablesetLog in tablesetLogList)
{
TablesetLineItemViewModel tablesetLineItemViewModel = new TablesetLineItemViewModel();
BufferMgr.TransferBuffer(tablesetLog, tablesetLineItemViewModel);
tablesetsListViewModel.Items.Add(tablesetLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public questStatus Page(out TablesetsListViewModel tablesetsListViewModel)
{
// Initialize
questStatus status = null;
tablesetsListViewModel = null;
// Set up query options.
// TEMPORARY: OPTIMIZE THIS
List <SearchField> searchFieldList = new List <SearchField>();
SearchOptions searchOptions = new SearchOptions();
searchOptions.SearchFieldList = searchFieldList;
QueryOptions queryOptions = new QueryOptions(100, 1);
queryOptions.SearchOptions = searchOptions;
QueryResponse queryResponse = null;
// List
List <Quest.Functional.Logging.TablesetLog> tablesetLogList = null;
TablesetLogsMgr tablesetLogsMgr = new TablesetLogsMgr(this.UserSession);
status = tablesetLogsMgr.List(queryOptions, out tablesetLogList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
tablesetsListViewModel = new TablesetsListViewModel(this.UserSession);
foreach (Quest.Functional.Logging.TablesetLog tablesetLog in tablesetLogList)
{
TablesetLineItemViewModel tablesetLineItemViewModel = new TablesetLineItemViewModel();
BufferMgr.TransferBuffer(tablesetLog, tablesetLineItemViewModel);
tablesetsListViewModel.Items.Add(tablesetLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Private Methods
*=================================================================================================================================*/
#region Export Routines
//----------------------------------------------------------------------------------------------------------------------------------
// Export Routines
//----------------------------------------------------------------------------------------------------------------------------------
private void writeTsv(TablesetsListViewModel tablesetsListViewModel, TextWriter output)
{
PropertyInfo[] propertyInfos = typeof(TablesetLineItemViewModel).GetProperties();
foreach (PropertyInfo pi in propertyInfos)
{
output.Write(pi.Name); // header
output.Write("\t");
}
output.WriteLine();
foreach (TablesetLineItemViewModel lineItem in tablesetsListViewModel.Items)
{
foreach (PropertyInfo pi in propertyInfos)
{
object _value = pi.GetValue(lineItem);
string value = _value == null ? "(null)" : _value.ToString().Replace("\t", " ").Replace("\r", " ").Replace("\n", " ");
output.Write(value);
output.Write("\t");
}
output.WriteLine();
}
}
