private bool OpenDataSourceEditor(DataSourceWrapper dsw) { IDataErrorInfo dataErrorInfo = dsw; UICommand okCommand = new UICommand { Caption = "OK", IsCancel = false, IsDefault = true, Command = new DelegateCommand <CancelEventArgs>( delegate(CancelEventArgs x) { }, delegate(CancelEventArgs x) { return(string.IsNullOrEmpty(dataErrorInfo.Error)); } ) }; UICommand cancelCommand = new UICommand { Id = MessageBoxResult.Cancel, Caption = "Cancel", IsCancel = true, IsDefault = false }; UICommand result = EditDataSourceDialogService.ShowDialog( dialogCommands: new List <UICommand> { okCommand, cancelCommand }, title: "Edit Data Source", viewModel: new object[] { dsw, DataConnections }); bool acceptChanges = result == okCommand; return(acceptChanges); }
public static DataSourceWrapper Create() { DataSourceWrapper dsw = ViewModelSource.Create(() => new DataSourceWrapper()); dsw.Queries = new ObservableCollection <QueryWrapper>(); return(dsw); }
private void CreateGSP() { Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters(@"|DataDirectory|\AppData\gsp.mdb", "", ""); ConnectionWrapper cw = InitConnection("GSPConnection", connectionParameters); DataSourceWrapper dsw = DataSourceWrapper.Create(); dsw.Name = "GSP"; dsw.Connection = cw; this.DataSources.Add(dsw); }
void WizardDialog_EndEditing(object sender, CustomClosingEventArgs e) { this.Close(); if (e.CloseMode == CloseMode.Apply) { DataSourceWrapper dsw = WizardDataModel.SelectedDataSource; SqlDataSource ds = WizardDataModel.CreateDataSource(); string queryName = WizardDataModel.SelectedDataSource.SelectedQuery.Name; OnEndWizard(new CustomClosingEventArgs(ds, queryName, e.CloseMode)); } else { OnEndWizard(new CustomClosingEventArgs(CloseMode.Cancel)); } }
public void EditDataSource() { DataSourceWrapper dsw = SelectedDataSource; IEditableObject editableObject = dsw; editableObject.BeginEdit(); bool acceptChanges = OpenDataSourceEditor(dsw); if (acceptChanges) { dsw.DoEndEdit(); } else { dsw.DoCancelEdit(); } }
private void CreateDepartmentsWorks() { Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters(@"|DataDirectory|\AppData\Departments.mdb", "", ""); ConnectionWrapper cw = InitConnection("DepartmentsConnection", connectionParameters); DataSourceWrapper dsw = DataSourceWrapper.Create(); dsw.Name = "Departments"; dsw.Connection = cw; QueryWrapper qwSalesPerson = QueryWrapper.Create(); qwSalesPerson.OwnerDataSource = dsw; qwSalesPerson.Name = "Departments"; qwSalesPerson.Sql = "select * from Departments"; dsw.Queries.Add(qwSalesPerson); this.DataSources.Add(dsw); }
private void CreateNorthwind() { DataConnectionParametersBase connectionParameters = new Access97ConnectionParameters(@"|DataDirectory|\AppData\nwind.mdb", "", ""); ConnectionWrapper cw = InitConnection("NorthwindConnection", connectionParameters); DataSourceWrapper dsw = DataSourceWrapper.Create(); dsw.Name = "Northwind"; dsw.Connection = cw; QueryWrapper qwCategories = QueryWrapper.Create(); qwCategories.OwnerDataSource = dsw; qwCategories.Name = "Categories"; qwCategories.Sql = "select * from Categories"; dsw.Queries.Add(qwCategories); QueryWrapper qwProducts = QueryWrapper.Create(); qwProducts.OwnerDataSource = dsw; qwProducts.Name = "Products"; qwProducts.Sql = "select * from Products"; dsw.Queries.Add(qwProducts); this.DataSources.Add(dsw); }