/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(out StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
storedProceduresListViewModel = 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 storedProceduresListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public ActionResult List(StoredProceduresListViewModel storedProceduresListViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(storedProceduresListViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Get list of items.
*---------------------------------------------------------------------------------------------------------------------------------*/
StoredProceduresListViewModel storedProceduresListViewModelNEW = null;
StoredProceduresListModeler storedProceduresListModeler = new StoredProceduresListModeler(this.Request, this.UserSession);
status = storedProceduresListModeler.List(out storedProceduresListViewModelNEW);
if (!questStatusDef.IsSuccess(status))
{
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result view model or as Excel
*---------------------------------------------------------------------------------------------------------------------------------*/
if (storedProceduresListViewModel.bExportToExcel)
{
string filename = "StoredProceduresLog_" + DateTime.Now.ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "atachment;filename=" + filename + ".xls");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
writeTsv(storedProceduresListViewModelNEW, Response.Output);
Response.Flush();
Response.End();
return(new EmptyResult());
}
else
{
status = new questStatus(Severity.Success);
storedProceduresListViewModelNEW.questStatus = status;
return(Json(storedProceduresListViewModelNEW, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Next(StoredProceduresListViewModel storedProceduresListViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(storedProceduresListViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Get list of items.
*---------------------------------------------------------------------------------------------------------------------------------*/
// TODO.
StoredProceduresListViewModel tablesetsListViewModelNEW = null;
StoredProceduresListModeler usersListModeler = new StoredProceduresListModeler(this.Request, this.UserSession);
status = usersListModeler.List(out tablesetsListViewModelNEW);
if (!questStatusDef.IsSuccess(status))
{
status = new questStatus(Severity.Success);
storedProceduresListViewModel.questStatus = status;
return(Json(storedProceduresListViewModel, 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(StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
StoredProcedureLogsMgr storedProcedureLogsMgr = new StoredProcedureLogsMgr(this.UserSession);
status = storedProcedureLogsMgr.Clear();
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public ActionResult Clear(StoredProceduresListViewModel 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.
*---------------------------------------------------------------------------------------------------------------------------------*/
StoredProceduresListModeler storedProceduresListModeler = new StoredProceduresListModeler(this.Request, this.UserSession);
status = storedProceduresListModeler.Clear(viewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "Stored Procedure log successfully cleared");
viewModel.questStatus = status;
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
public questStatus List(QueryOptions queryOptions, out StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
storedProceduresListViewModel = null;
// List
QueryResponse queryResponse = null;
List <Quest.Functional.Logging.StoredProcedureLog> storedProcedureLogList = null;
StoredProcedureLogsMgr storedProcedureLogsMgr = new StoredProcedureLogsMgr(this.UserSession);
status = storedProcedureLogsMgr.List(queryOptions, out storedProcedureLogList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort
storedProcedureLogList.Sort(delegate(Quest.Functional.Logging.StoredProcedureLog i1, Quest.Functional.Logging.StoredProcedureLog i2) { return(i2.Created.CompareTo(i1.Created)); });
// Transfer model.
// TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsViewModel.
storedProceduresListViewModel = new StoredProceduresListViewModel(this.UserSession);
QueryResponseViewModel queryResponseViewModel = null;
status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
storedProceduresListViewModel.QueryResponse = queryResponseViewModel;
foreach (Quest.Functional.Logging.StoredProcedureLog storedProcedureLog in storedProcedureLogList)
{
StoredProcedureLineItemViewModel storedProcedureLineItemViewModel = new StoredProcedureLineItemViewModel();
BufferMgr.TransferBuffer(storedProcedureLog, storedProcedureLineItemViewModel);
storedProceduresListViewModel.Items.Add(storedProcedureLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public questStatus Page(out StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
storedProceduresListViewModel = 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.StoredProcedureLog> storedProcedureLogList = null;
StoredProcedureLogsMgr storedProcedureLogsMgr = new StoredProcedureLogsMgr(this.UserSession);
status = storedProcedureLogsMgr.List(queryOptions, out storedProcedureLogList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
storedProceduresListViewModel = new StoredProceduresListViewModel(this.UserSession);
foreach (Quest.Functional.Logging.StoredProcedureLog storedProcedureLog in storedProcedureLogList)
{
StoredProcedureLineItemViewModel storedProcedureLineItemViewModel = new StoredProcedureLineItemViewModel();
BufferMgr.TransferBuffer(storedProcedureLog, storedProcedureLineItemViewModel);
storedProceduresListViewModel.Items.Add(storedProcedureLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Private Methods
*=================================================================================================================================*/
#region Export Routines
//----------------------------------------------------------------------------------------------------------------------------------
// Export Routines
//----------------------------------------------------------------------------------------------------------------------------------
private void writeTsv(StoredProceduresListViewModel storedProceduresListViewModel, TextWriter output)
{
PropertyInfo[] propertyInfos = typeof(StoredProcedureLineItemViewModel).GetProperties();
foreach (PropertyInfo pi in propertyInfos)
{
output.Write(pi.Name); // header
output.Write("\t");
}
output.WriteLine();
foreach (StoredProcedureLineItemViewModel lineItem in storedProceduresListViewModel.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();
}
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus GetParamerListInfo(ParameterListViewModel viewModel, out ParameterListViewModel parameterListViewModel)
{
// Initialize
questStatus status = null;
parameterListViewModel = null;
DatabaseId databaseId = new DatabaseId(viewModel.DatabaseId);
// Read the database
DatabaseBaseViewModel databaseBaseViewModel = null;
DatabaseBaseModeler databaseBaseModeler = new DatabaseBaseModeler(this.HttpRequestBase, this.UserSession);
status = databaseBaseModeler.GetDatabase(databaseId, out databaseBaseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read the stored procedure
StoredProceduresListViewModel storedProceduresListViewModel = null;
StoredProceduresListModeler storedProceduresListModeler = new StoredProceduresListModeler(this.HttpRequestBase, this.UserSession);
status = storedProceduresListModeler.List(databaseId, out storedProceduresListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get stored procedure info
StoredProcedureId storedProcedureId = new StoredProcedureId(viewModel.Id);
// Read the stored procedure info
StoredProcedure storedProcedure = null;
StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
status = storedProceduresMgr.Read(storedProcedureId, out storedProcedure);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get stored procedure parameters
viewModel.StoredProcedureId = viewModel.Id;
ParameterListViewModel _parameterListViewModel = null;
status = List(viewModel, out _parameterListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort by display order
// NOTE: ORDER IN DATABASE -SHOULD- BE ORDER IN SPROC.
// Transfer model.
parameterListViewModel = new ParameterListViewModel(this.UserSession, viewModel);
parameterListViewModel.DatabaseId = databaseId.Id;
parameterListViewModel.Database = databaseBaseViewModel;
foreach (StoredProcedureLineItemViewModel storedProcedureLineItemViewModel in storedProceduresListViewModel.Items)
{
OptionValuePair opv = new OptionValuePair();
opv.Id = storedProcedureLineItemViewModel.Id.ToString();
opv.Label = storedProcedureLineItemViewModel.Name;
parameterListViewModel.StoredProcedureOptions.Add(opv);
}
parameterListViewModel.ParentEntityType = viewModel.ParentEntityType;
parameterListViewModel.StoredProcedureId = viewModel.StoredProcedureId;
StoredProcedureViewModel storedProcedureViewModel = new StoredProcedureViewModel();
BufferMgr.TransferBuffer(storedProcedure, storedProcedureViewModel);
parameterListViewModel.StoredProcedure = storedProcedureViewModel;
parameterListViewModel.Items = _parameterListViewModel.Items;
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(DatabaseId databaseId, out StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
storedProceduresListViewModel = 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>();
SearchField searchField = new SearchField();
searchField.Name = "DatabaseId";
searchField.SearchOperation = SearchOperation.Equal;
searchField.Type = typeof(int);
searchField.Value = databaseId.Id.ToString();
searchFieldList.Add(searchField);
SearchOptions searchOptions = new SearchOptions();
searchOptions.SearchFieldList = searchFieldList;
queryOptions.SearchOptions = searchOptions;
QueryResponse queryResponse = null;
// Get Database storedProcedures
List <StoredProcedure> storedProceduresetList = null;
StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
status = storedProceduresMgr.List(queryOptions, out storedProceduresetList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort by name
storedProceduresetList.Sort(delegate(StoredProcedure i1, StoredProcedure i2) { return(i1.Name.CompareTo(i2.Name)); });
// Transfer model.
// TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsStoredProcedureModel.
storedProceduresListViewModel = new StoredProceduresListViewModel(this.UserSession);
QueryResponseViewModel queryResponseViewModel = null;
status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
storedProceduresListViewModel.QueryResponse = queryResponseViewModel;
foreach (Quest.Functional.MasterPricing.StoredProcedure storedProcedure in storedProceduresetList)
{
StoredProcedureLineItemViewModel storedProcedureLineItemViewModel = new StoredProcedureLineItemViewModel();
BufferMgr.TransferBuffer(storedProcedure, storedProcedureLineItemViewModel);
storedProceduresListViewModel.Items.Add(storedProcedureLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
