public PerGroupCollection(clsConfig.GroupUpdateRuleCollection groups) { // Loop through each group and add to the list and the dictionaries. This is the only way items can be created. foreach (clsConfig.GroupUpdateRule ur in groups) { this.List.Add(new PerGroupInformation(ur)); } }
// Class initialisation. List of groups is also to be passed public UnapprovedUpdates(clsConfig configobject, clsConfig.GroupUpdateRuleCollection showgroups) { // Store the config object for use cfg = configobject; // Store the groups to be managed, sorting them by display order groups = showgroups; groups.SortByDisplayOrder(); }
public UnapprovedUpdate(clsConfig.GroupUpdateRuleCollection groups, string updateid, string title, string description, string kbarticle, DateTime arrivaldate) { _groups = new PerGroupCollection(groups); _updateid = updateid; _title = title; _description = description; _kbarticle = kbarticle; _arrivaldate = arrivaldate; }
public DataTable GetUnapprovedUpdatesNew() { if (CheckDBConnection()) { // Inject the right parameters into the Unapproved Updates query clsConfig.GroupUpdateRuleCollection ur = cfg.GroupUpdateRules; string[] parameters = new string[ur.Count]; cmdUnapprovedUpdates.Parameters.Clear(); // Build list of parameters for (int i = 0; i < ur.Count; i++) { parameters[i] = string.Format("@Group{0}", i); } // Set SQL query cmdUnapprovedUpdates.CommandText = string.Format(strUnapprovedUpdates, string.Join(", ", parameters)); // Build parameters for (int i = 0; i < ur.Count; i++) { cmdUnapprovedUpdates.Parameters.Add(parameters[i], SqlDbType.NVarChar); cmdUnapprovedUpdates.Parameters[parameters[i]].Value = ur[i].computergroup.Name; } // Associate with SQL query cmdUnapprovedUpdates.Connection = sql; // Run query and return results cmdUnapprovedUpdates.ExecuteNonQuery(); SqlDataReader r = cmdUnapprovedUpdates.ExecuteReader(); DataTable t = new DataTable(); // Load the data table t.Load(r); r.Close(); return(t); } // DB Connection not OK - return a null table return(null); }
public frmGroupUpdateRules(clsConfig cfgobject, clsWSUS wsusobject) { // Let the user know something is happening Cursor.Current = Cursors.WaitCursor; InitializeComponent(); cfg = cfgobject; wsus = wsusobject; // Get list of computer groups and sort it. gc = wsus.ComputerGroups; groupnames = new List <string>(); foreach (IComputerTargetGroup tg in gc) { groupnames.Add(tg.Name); } groupnames.Sort(); // Read existing group rules grouprules = cfg.GroupUpdateRules; // Update treeview with existing rules UpdateGroupUpdateRules(); // Set default display order (maximum + 1) numDisplayOrder.Value = grouprules.MaxDisplayOrder + 1; // Set this window to be marginly less wide than the current monitor Rectangle scr = Screen.FromControl(this).Bounds; // Make this window 20 pixels narrower than the current screen and centre it this.Left = 10; this.Width = scr.Width - 20; // Note the current height of the form - this will be the minimum height of the form minheight = this.Height; // Finished - reset cursor to normal Cursor.Current = Cursors.Arrow; }
public frmGroupUpdateRules(clsConfig cfgobject, clsWSUS wsusobject) { // Let the user know something is happening Cursor.Current = Cursors.WaitCursor; InitializeComponent(); cfg = cfgobject; wsus = wsusobject; // Get list of computer groups and sort it. gc = wsus.ComputerGroups; groupnames = new List<string>(); foreach (IComputerTargetGroup tg in gc) groupnames.Add(tg.Name); groupnames.Sort(); // Read existing group rules grouprules = cfg.GroupUpdateRules; // Update treeview with existing rules UpdateGroupUpdateRules(); // Set default display order (maximum + 1) numDisplayOrder.Value = grouprules.MaxDisplayOrder + 1; // Set this window to be marginly less wide than the current monitor Rectangle scr = Screen.FromControl(this).Bounds; // Make this window 20 pixels narrower than the current screen and centre it this.Left = 10; this.Width = scr.Width - 20; // Note the current height of the form - this will be the minimum height of the form minheight = this.Height; // Finished - reset cursor to normal Cursor.Current = Cursors.Arrow; }
// Class initialisation. List of groups is also to be passed public UnapprovedUpdates(clsConfig configobject, clsConfig.GroupUpdateRuleCollection showgroups) { // Store the config object for use cfg = configobject; // Store the groups to be managed, sorting them by display order groups = showgroups; groups.SortByDisplayOrder(); }