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