public void Show(IWin32Window owner, Schema.Model.IOption filter)
{
SqlFilter = filter;
sqlOptionsFront1.Load(filter);
this.Show(owner);
}
public override void Load(Schema.Model.IOption option)
{
this.SQLOption = new SqlOption(option);
txtBlob.Text = SQLOption.Defaults.DefaultBlobValue;
txtDate.Text = SQLOption.Defaults.DefaultDateValue;
txtDefaultInteger.Text = SQLOption.Defaults.DefaultIntegerValue;
txtDefaultReal.Text = SQLOption.Defaults.DefaultRealValue;
txtNText.Text = SQLOption.Defaults.DefaultNTextValue;
txtText.Text = SQLOption.Defaults.DefaultTextValue;
txtVariant.Text = SQLOption.Defaults.DefaultVariantValue;
txtTime.Text = SQLOption.Defaults.DefaultTime;
txtXML.Text = SQLOption.Defaults.DefaultXml;
chkCompAssemblys.Checked = SQLOption.Ignore.FilterAssemblies;
chkCompCLRFunctions.Checked = SQLOption.Ignore.FilterCLRFunction;
chkCompCLRStore.Checked = SQLOption.Ignore.FilterCLRStoredProcedure;
chkCompCLRTrigger.Checked = SQLOption.Ignore.FilterCLRTrigger;
chkCompCLRUDT.Checked = SQLOption.Ignore.FilterCLRUDT;
chkConstraints.Checked = SQLOption.Ignore.FilterConstraint;
chkConstraintsPK.Checked = SQLOption.Ignore.FilterConstraintPK;
chkConstraintsFK.Checked = SQLOption.Ignore.FilterConstraintFK;
chkConstraintsUK.Checked = SQLOption.Ignore.FilterConstraintUK;
chkConstraintsCheck.Checked = SQLOption.Ignore.FilterConstraintCheck;
chkCompExtendedProperties.Checked = SQLOption.Ignore.FilterExtendedProperties;
chkCompFunciones.Checked = SQLOption.Ignore.FilterFunction;
chkIndex.Checked = SQLOption.Ignore.FilterIndex;
chkIndexFillFactor.Checked = SQLOption.Ignore.FilterIndexFillFactor;
chkIndexIncludeColumns.Checked = SQLOption.Ignore.FilterIndexIncludeColumns;
chkIndexFilter.Checked = SQLOption.Ignore.FilterIndexFilter;
chkFullText.Checked = SQLOption.Ignore.FilterFullText;
chkFullTextPath.Checked = SQLOption.Ignore.FilterFullTextPath;
chkCompSchemas.Checked = SQLOption.Ignore.FilterSchema;
chkCompStoredProcedure.Checked = SQLOption.Ignore.FilterStoredProcedure;
chkTableOption.Checked = SQLOption.Ignore.FilterTableOption;
chkTables.Checked = SQLOption.Ignore.FilterTable;
chkTablesColumnIdentity.Checked = SQLOption.Ignore.FilterColumnIdentity;
chkTablesColumnCollation.Checked = SQLOption.Ignore.FilterColumnCollation;
chkTableLockEscalation.Checked = SQLOption.Ignore.FilterTableLockEscalation;
chkTableChangeTracking.Checked = SQLOption.Ignore.FilterTableChangeTracking;
chkTablesColumnOrder.Checked = SQLOption.Ignore.FilterColumnOrder;
chkIgnoreNotForReplication.Checked = SQLOption.Ignore.FilterNotForReplication;
chkCompTriggersDDL.Checked = SQLOption.Ignore.FilterDDLTriggers;
chkCompTriggers.Checked = SQLOption.Ignore.FilterTrigger;
chkCompUDT.Checked = SQLOption.Ignore.FilterUserDataType;
chkCompVistas.Checked = SQLOption.Ignore.FilterView;
chkCompXMLSchemas.Checked = SQLOption.Ignore.FilterXMLSchema;
chkFileGroups.Checked = SQLOption.Ignore.FilterTableFileGroup;
chkCompUsers.Checked = SQLOption.Ignore.FilterUsers;
chkCompRoles.Checked = SQLOption.Ignore.FilterRoles;
chkCompRules.Checked = SQLOption.Ignore.FilterRules;
if (SQLOption.Script.AlterObjectOnSchemaBinding)
{
optScriptSchemaBindingAlter.Checked = true;
}
else
{
optScriptSchemaDrop.Checked = true;
}
if (SQLOption.Comparison.CaseSensityType == SqlOptionComparison.CaseSensityOptions.Automatic)
{
rdoCaseAutomatic.Checked = true;
}
if (SQLOption.Comparison.CaseSensityType == SqlOptionComparison.CaseSensityOptions.CaseInsensity)
{
rdoCaseInsensitive.Checked = true;
}
if (SQLOption.Comparison.CaseSensityType == SqlOptionComparison.CaseSensityOptions.CaseSensity)
{
rdoCaseSensitive.Checked = true;
}
if (SQLOption.Comparison.CaseSensityInCode == SqlOptionComparison.CaseSensityOptions.CaseInsensity)
{
rdoCaseInsensityInCode.Checked = true;
}
if (SQLOption.Comparison.CaseSensityInCode == SqlOptionComparison.CaseSensityOptions.CaseSensity)
{
rdoCaseSensityInCode.Checked = true;
}
chkIgnoreWhiteSpaceInCode.Checked = SQLOption.Comparison.IgnoreWhiteSpacesInCode;
chkReloadDB.Checked = SQLOption.Comparison.ReloadComparisonOnUpdate;
LoadFilters();
}
private void SqlOptionsFront1_OptionSaved(Schema.Model.IOption option)
{
OptionSaved?.Invoke(option);
}
