public static void DeleteLocalAddressRange(int rangeId) { CheckAccess(); using (DbTransaction tran = DbTransaction.Begin()) { DbActiveDirectory.LocalAddressRangeDelete(rangeId); tran.Commit(); } }
private static ArrayList GetLocalAddressesList() { ArrayList list = new ArrayList(); using (IDataReader reader = DbActiveDirectory.LocalAddressRangeGetList()) { while (reader.Read()) { list.Add(new IPAddressRange((int)reader["RangeId"], reader["StartAddress"].ToString(), reader["EndAddress"].ToString())); } } return(list); }
public static void UpdateLocalAddressRange(int rangeId, string startAddress, string endAddress) { CheckAccess(); // Validate range IPAddressRange range = new IPAddressRange(rangeId, startAddress, endAddress); // Update range using (DbTransaction tran = DbTransaction.Begin()) { DbActiveDirectory.LocalAddressRangeUpdate(rangeId, startAddress, endAddress); tran.Commit(); } }
public static int AddLocalAddressRange(string startAddress, string endAddress) { CheckAccess(); int id; // Validate range IPAddressRange range = new IPAddressRange(startAddress, endAddress); // Add range using (DbTransaction tran = DbTransaction.Begin()) { id = DbActiveDirectory.LocalAddressRangeAdd(startAddress, endAddress); tran.Commit(); } return(id); }
public static void UpdateLocalAddressRanges(DataTable items) { CheckAccess(); ArrayList oldItems = GetLocalAddressesList(); ArrayList add = new ArrayList(); ArrayList del = new ArrayList(); foreach (DataRow row in items.Rows) { IPAddressRange item = new IPAddressRange((string)row["StartAddress"], (string)row["EndAddress"]); if (oldItems.Contains(item)) { oldItems.Remove(item); } else { add.Add(item); } } del.AddRange(oldItems); using (DbTransaction tran = DbTransaction.Begin()) { foreach (IPAddressRange range in add) { DbActiveDirectory.LocalAddressRangeAdd(range.StartAddress.ToString(), range.EndAddress.ToString()); } foreach (IPAddressRange range in del) { DbActiveDirectory.LocalAddressRangeDelete(range.ID); } tran.Commit(); } }
// Public #region GetLocalAddressRanges() public static IDataReader GetLocalAddressRanges() { CheckAccess(); return(DbActiveDirectory.LocalAddressRangeGetList()); }