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)); }
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 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)); }