public ActionResult StoredProcedures() { var categories = _context.ufnGetAllCategories(); var customer = _context.ufnGetCustomerInformation(1); var model = new StoredProcedureViewModel { Categories = categories.ToList(), Customer = customer.FirstOrDefault() }; return(View(model)); }
/*================================================================================================================================== * 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)); }
private StoredProcedureEditorWindow(EditingInfo editingInfo) { InitializeComponent(); DataContext = new StoredProcedureViewModel(editingInfo, (ConnectionViewModel)ConnectionControl.DataContext); }