/*================================================================================================================================== * 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)); }