private void FetchSMOInfo(SQLInformation.Data.ApplicationDataSet.InstancesRow instanceRow)
{
SQLInformation.ExpandMask.InstanceExpandSetting instanceExpandSetting = new SQLInformation.ExpandMask.InstanceExpandSetting(instanceRow.Server_ID);
SQLInformation.ExpandMask.JobServerExpandSetting jobServerExpandSetting = new SQLInformation.ExpandMask.JobServerExpandSetting(instanceRow.DefaultJobServerExpandMask);
SQLInformation.ExpandMask.DatabaseExpandSetting databaseExpandSetting = new SQLInformation.ExpandMask.DatabaseExpandSetting(instanceRow.DefaultDatabaseExpandMask);
SQLInformation.SMO.Instance.GetInfoFromSMO(instanceRow, instanceExpandSetting, jobServerExpandSetting, databaseExpandSetting);
}
private void Initialize_ExpandMasks()
{
instanceExpandSetting = new SQLInformation.ExpandMask.InstanceExpandSetting(0);
databaseExpandSetting = new SQLInformation.ExpandMask.DatabaseExpandSetting(0);
jobServerExpandSetting = new ExpandMask.JobServerExpandSetting(0);
cbe_IsMonitored.ItemsSource = SQLInformation.ExpandMask.InstanceExpandSetting.OptionValues;
cbe_DefaultDatabaseExpandMask.ItemsSource = SQLInformation.ExpandMask.DatabaseExpandSetting.OptionValues;
cbe_DefaultJobServerExpandMask.ItemsSource = SQLInformation.ExpandMask.JobServerExpandSetting.OptionValues;
}
private void tableView_FocusedRowChanged(object sender, DevExpress.Xpf.Grid.FocusedRowChangedEventArgs e)
{
var zz = (SQLInformation.Data.ApplicationDataSet.CrawlerExpandSettingsRow)((System.Data.DataRowView)e.NewRow).Row;
switch (zz.TargetObject)
{
case "Database":
SQLInformation.ExpandMask.DatabaseExpandSetting dbES = new SQLInformation.ExpandMask.DatabaseExpandSetting(zz.ExpandSetting);
lc_ExpandDatabaseCurrent.DataContext = dbES;
break;
case "Instance":
SQLInformation.ExpandMask.InstanceExpandSetting inES = new SQLInformation.ExpandMask.InstanceExpandSetting(zz.ExpandSetting);
lc_ExpandInstanceCurrent.DataContext = inES;
break;
case "JobServer":
SQLInformation.ExpandMask.JobServerExpandSetting jsES = new SQLInformation.ExpandMask.JobServerExpandSetting(zz.ExpandSetting);
lc_ExpandJobServerCurrent.DataContext = jsES;
break;
}
}
private void Initialize_ExpandMasks()
{
instanceExpandSetting = new SQLInformation.ExpandMask.InstanceExpandSetting(0);
cbe_DefaultInstanceExpandMask.ItemsSource = SQLInformation.ExpandMask.InstanceExpandSetting.OptionValues;
}