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