private string ShowSqlEditor(IWindowsFormsEditorService wfes, SreDataSourceProperty dsProperty) { frmConfigSql configSql = new frmConfigSql(dsProperty.Id, true, "Push Sql Configuration"); if ((dsProperty.PusherTypeFullName != null) && (dsProperty.PusherTypeFullName.Contains("|"))) { string[] strInfo = dsProperty.PusherTypeFullName.Split("|".ToCharArray()); configSql.pullSqlConfiguration1.ConnectionStringKeyNameDesign = strInfo[0]; configSql.pullSqlConfiguration1.ConnectionStringKeyName = strInfo[1]; configSql.pullSqlConfiguration1.UpdateQuery = strInfo[2]; } if (configSql.ShowDialog() == System.Windows.Forms.DialogResult.OK) { dsProperty.PusherTypeFullName = string.Format("{0}|{1}|{2}", configSql.pullSqlConfiguration1.ConnectionStringKeyNameDesign, configSql.pullSqlConfiguration1.ConnectionStringKeyName, configSql.pullSqlConfiguration1.UpdateQuery); return(dsProperty.PusherTypeFullName); } return(string.Empty); }
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value) { IWindowsFormsEditorService wfes = provider.GetService(typeof(IWindowsFormsEditorService)) as IWindowsFormsEditorService; SreDataSourceProperty dsProperty = context.Instance as SreDataSourceProperty; if (wfes != null) { switch (dsProperty.DataFeederType) { case DataFeederTypes.PullSql: frmConfigSql configPullSql = new frmConfigSql(dsProperty.Id); wfes.ShowDialog(configPullSql); break; default: DataFormatTypes selType = dsProperty.DataFormatType; if ((selType == DataFormatTypes.Xml) || (selType == DataFormatTypes.Zipped)) { selType = DataFormatTypes.Delimited; //to prevent showing xml/zip UI when clicked from this button. } frmConfig configUI = new frmConfig(true, dsProperty.Id, dsProperty.DataFeederType, selType); IdpeKey key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.FtpRemoteLocation.ToString()); configUI.FtpRemoteLocation = key != null ? key.Value : string.Empty; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalLocation.ToString()); key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.FtpUserName.ToString()); configUI.FtpUserName = key != null ? key.Value : string.Empty; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.FtpPassword.ToString()); configUI.FtpPassword = key != null ? key.Value : string.Empty; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.FtpWatchInterval.ToString()); configUI.Interval = int.Parse(key != null ? key.Value : "2"); key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.WatchFilter.ToString()); configUI.WatchFilter = key != null ? key.Value : "All(No Filter)"; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.FileInterfaceName.ToString()); if (key != null) { configUI.InterfaceName = key.Value; } key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.IsFirstRowHeader.ToString()); if (key != null) { configUI.IsFirstRowIsHeader = key.Value.ParseBool(); } key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalFileSystemFoldersOverriden.ToString()); configUI.LocalFileSystemFoldersOverriden = key != null?key.Value.ParseBool() : false; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalFileSystemFolderArchiveAuto.ToString()); configUI.LocalFileSystemFolderArchiveAuto = key != null?key.Value.ParseBool() : false; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalFileSystemFolderPull.ToString()); configUI.LocalFileSystemFolderPullFolder = key != null ? key.Value : string.Empty; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalFileSystemFolderArchive.ToString()); configUI.LocalFileSystemFolderArchiveFolder = key != null ? key.Value : string.Empty; key = dsProperty.DataSourceKeys.GetKey(IdpeKeyTypes.LocalFileSystemFolderOutput.ToString()); configUI.LocalFileSystemFolderOutputFolder = key != null ? key.Value : string.Empty; wfes.ShowDialog(configUI); //this.DataSourceKeys = _Manager.GetKeys(DataSource.Id); break; } } return(value); }