/// <summary>
/// Add this group to the database (only applicable to user locations)
/// </summary>
/// <returns></returns>
public int Add()
{
// If this Location already exists then call the update instead
if (_groupID != 0)
{
return(Update(null));
}
// If we have not specified a parent but do have a full name then we have a problem in that we
// do not necessarily have a parent location in the database and in any case we do not know the ID
// of our parent so should look for it now...
if ((ParentID == 0) && (_fullname.Contains(@"\")))
{
_groupID = ValidateParentPath(_fullname);
}
else
{
// Add the location to the database
LocationsDAO lwDataAccess = new LocationsDAO();
int groupID = lwDataAccess.GroupAdd(this);
if (groupID != 0)
{
AuditChanges(null);
_groupID = groupID;
}
}
return(0);
}
/// <summary>
/// Update this Group defininition in the database
/// </summary>
/// <returns></returns>
public int Update(AssetGroup oldgroup)
{
LocationsDAO lwDataAccess = new LocationsDAO();
if (this._groupID == 0)
{
Add();
}
else
{
lwDataAccess.GroupAdd(this);
AuditChanges(oldgroup);
}
return(0);
}
public void NetworkDiscoveryCompleteHandler(object sender, DataEventArgs <List <string[]> > e)
{
try
{
LocationsDAO lwDataAccess = new LocationsDAO();
string macAddress = String.Empty;
string vendor = String.Empty;
string ipAddress = String.Empty;
// We need to get the root item as all of the domains need to be parented to this
DataTable table = lwDataAccess.GetGroups(new AssetGroup(AssetGroup.GROUPTYPE.domain));
AssetGroup rootGroup = new AssetGroup(table.Rows[0], AssetGroup.GROUPTYPE.domain);
// Get the child domains - as domains are single level we do not need to recurse
rootGroup.Populate(false, false, true);
// We'll loop through the domains first and add then to the database recovering their ids so that
// we only have to do this once.
for (int i = 0; i < e.Data.Count; i++)
{
string assetName = e.Data[i][0];
string groupName = e.Data[i][1];
// Does this domain already exist?
AssetGroup childGroup = rootGroup.IsChildGroup(groupName);
// No - add it as a new group both to the database and to the parent
if (childGroup == null)
{
childGroup = new AssetGroup(AssetGroup.GROUPTYPE.domain);
childGroup.Name = groupName;
childGroup.ParentID = rootGroup.GroupID;
childGroup.GroupID = lwDataAccess.GroupAdd(childGroup);
rootGroup.Groups.Add(childGroup);
}
try
{
// Recover the IP address for the asset
ipAddress = Utility.GetIpAddress(assetName);
// try to get the MAC address and vendor from IP
IPAddress hostIPAddress = IPAddress.Parse(ipAddress);
byte[] ab = new byte[6];
int len = ab.Length;
int r = SendARP((int)hostIPAddress.Address, 0, ab, ref len);
macAddress = BitConverter.ToString(ab, 0, 6);
}
catch (Exception ex)
{
// if we hit an invalid IP error here we can just log and carry on
log.Error(String.Format("Error {0} with IP address [{1}]", ex.Message, ipAddress));
}
if (macAddress != String.Empty)
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(System.IO.Path.Combine(Application.StartupPath, "oui.txt")))
{
string line;
while ((line = sr.ReadLine()) != null)
{
if (line.StartsWith(macAddress.Substring(0, 8)))
{
if (line.Substring(18).ToUpper().StartsWith("APPLE"))
{
vendor = line.Substring(18);
}
break;
}
}
}
}
// Now that we have the ID of the group (even if we just added the group) we can now
// add the asset to the database also.
Asset newAsset = new Asset();
newAsset.Name = assetName;
newAsset.MACAddress = macAddress.Replace('-', ':');
newAsset.Make = vendor;
AssetList assetList = new AssetList(new AssetDAO().GetAssets(0, AssetGroup.GROUPTYPE.userlocation, false), true);
bool bUpdateAsset = true;
foreach (Asset existingAsset in assetList)
{
if (assetName == existingAsset.Name)
{
// this asset already exists - only need to check if domain or IP have changed
// if they have, send it away to be updated
if (existingAsset.IPAddress != ipAddress || existingAsset.DomainID != childGroup.GroupID)
{
newAsset = existingAsset;
newAsset.IPAddress = newAsset.IPAddress != ipAddress ? ipAddress : newAsset.IPAddress;
newAsset.DomainID = newAsset.DomainID != childGroup.GroupID ? childGroup.GroupID : newAsset.DomainID;
}
else
{
// asset exists, nothing has changed so don't process
bUpdateAsset = false;
}
break;
}
}
if (bUpdateAsset)
{
newAsset.DomainID = childGroup.GroupID;
newAsset.IPAddress = ipAddress;
// Add the asset
newAsset.Add();
}
// Does this asset already exist?
//if (rootGroup.FindAsset(assetName) == null)
//{
// newAsset.DomainID = childGroup.GroupID;
// newAsset.IPAddress = ipAddress;
// // Add the asset
// newAsset.Add();
//}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
//WorkItem.ExplorerView.RefreshView();
//WorkItem.TabView.RefreshView();
}
/// <summary>
/// Called as want to exit from this form potentially saving the definition or updating
/// an existing entry
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bnOK_Click(object sender, EventArgs e)
{
if (tbChild.Text == "")
{
MessageBox.Show("You must enter a name for this new Location");
DialogResult = DialogResult.None;
return;
}
// If we are creating a new Location then we must ensure that we have specified a
// name which does not already exist for the parent
if (_parentLocation != null)
{
AssetGroup existingLocation = _parentLocation.IsChildGroup(tbChild.Text);
if (existingLocation != null)
{
// OK this named location exists - is it the same location though
if (existingLocation.GroupID != _location.GroupID)
{
MessageBox.Show("The Location " + tbChild.Text + " already exists at this level. Please enter a different name for this new Location", "Duplicate Name");
DialogResult = DialogResult.None;
return;
}
}
}
// OK all valid so add this new entry (or update it if already exists)
LocationsDAO lwDataAccess = new LocationsDAO();
_location.Name = tbChild.Text;
// Set the parent name noting that this is the same as our name if we are at the top of the
// tree and have no parent
if (_parentLocation == null)
{
_location.FullName = _location.Name;
}
else
{
_location.FullName = _parentLocation.FullName + @"\" + _location.Name;
}
// Create '|' delimited strings for the starting and ending IP addresses
string startIP = "";
string endIP = "";
foreach (UltraListViewItem item in ulvTcpRanges.Items)
{
if (startIP != "")
{
startIP += "|";
}
if (endIP != "")
{
endIP += "|";
}
startIP += item.Text;
endIP += item.SubItems[0].Text;
}
_location.StartIP = startIP;
_location.EndIP = endIP;
// Add or replace the location
_location.GroupID = lwDataAccess.GroupAdd(_location);
}
public void InsertComputer(string assetName, string groupName, string ipAddress, string macAddress)
{
LocationsDAO lwDataAccess = new LocationsDAO();
SettingsDAO lSettingsDao = new SettingsDAO();
// We need to get the root item as all of the domains need to be parented to this
System.Data.DataTable table = lwDataAccess.GetGroups(new AssetGroup(AssetGroup.GROUPTYPE.domain));
AssetGroup rootGroup = new AssetGroup(table.Rows[0], AssetGroup.GROUPTYPE.domain);
// Get the child domains - as domains are single level we do not need to recurse
rootGroup.Populate(false, false, true);
// We'll loop through the domains first and add then to the database recovering their ids so that
// we only have to do this once.
// Does this domain already exist?
AssetGroup childGroup;
lock (this)
{
childGroup = rootGroup.IsChildGroup(groupName);
// No - add it as a new group both to the database and to the parent
if (childGroup == null)
{
childGroup = new AssetGroup(AssetGroup.GROUPTYPE.domain);
childGroup.Name = groupName;
childGroup.ParentID = rootGroup.GroupID;
childGroup.GroupID = lwDataAccess.GroupAdd(childGroup);
rootGroup.Groups.Add(childGroup);
}
}
string vendor = String.Empty;
try
{
if (macAddress != String.Empty)
{
//
// CMD IMPORTANT UNCOMMENT THESE LINES
// using (System.IO.StreamReader sr = new System.IO.StreamReader(System.IO.Path.Combine(Application.StartupPath, "oui.txt")))
// {
// string line;
// while ((line = sr.ReadLine()) != null)
// {
// if (line.StartsWith(macAddress.Substring(0, 8)))
// {
// if (line.Substring(18).ToUpper().StartsWith("APPLE"))
// {
// vendor = line.Substring(18);
// break;
// }
// }
// }
// }
}
}
catch (FormatException)
{
}
// Now that we have the ID of the group (even if we just added the group) we can now
// add the asset to the database also.
Asset newAsset = new Asset();
newAsset.Name = assetName;
newAsset.MACAddress = macAddress.Replace('-', ':');
newAsset.Make = vendor;
if (vendor.ToUpper().StartsWith("APPLE"))
{
// add as an Apple Device
assetTypes.Populate();
AssetType parentAssetType = assetTypes.FindByName("Apple Devices");
if (parentAssetType == null)
{
// Now create a child of this asset type
parentAssetType = new AssetType();
parentAssetType.Name = "Apple Devices";
parentAssetType.Auditable = false;
parentAssetType.Icon = "apple.png";
parentAssetType.ParentID = 0;
parentAssetType.Add();
// Update the internal list
assetTypes.Add(parentAssetType);
}
assetTypes.Populate();
parentAssetType = assetTypes.FindByName("Apple Devices");
AssetType childAssetType = assetTypes.FindByName("Apple Device");
if (childAssetType == null)
{
// Now create a child of this asset type
childAssetType = new AssetType();
childAssetType.Name = "Apple Device";
childAssetType.Auditable = false;
childAssetType.Icon = parentAssetType.Icon;
childAssetType.ParentID = parentAssetType.AssetTypeID;
childAssetType.Add();
// Update the internal list
assetTypes.Add(childAssetType);
}
assetTypes.Populate();
childAssetType = assetTypes.FindByName("Apple Device");
newAsset.AssetTypeID = childAssetType.AssetTypeID;
}
AssetList assetList = new AssetList(new AssetDAO().GetAssets(0, AssetGroup.GROUPTYPE.userlocation, false), true);
bool bUpdateAsset = true;
bool bSNMPAsset = false;
bool bExistingAuditedAsset = false;
foreach (Asset existingAsset in assetList)
{
if ((existingAsset.AgentVersion == "SNMP") && (existingAsset.IPAddress == ipAddress))
{
bSNMPAsset = true;
break;
}
if ((assetName == existingAsset.Name) && (groupName == existingAsset.Domain))
{
// this asset already exists - only need to check if domain or IP have changed
// if they have, send it away to be updated
if (existingAsset.IPAddress != ipAddress || existingAsset.DomainID != childGroup.GroupID)
{
newAsset = existingAsset;
newAsset.IPAddress = newAsset.IPAddress != ipAddress ? ipAddress : newAsset.IPAddress;
newAsset.DomainID = newAsset.DomainID != childGroup.GroupID ? childGroup.GroupID : newAsset.DomainID;
}
else
{
// asset exists, nothing has changed so don't process
bUpdateAsset = false;
}
break;
}
if (!bSNMPAsset && existingAsset.IPAddress == ipAddress && existingAsset.Domain != newAsset.Domain)
{
bExistingAuditedAsset = true;
//check for any asset name change if so update asset with audittrail entry
if (existingAsset.Name != assetName)
{
string strOldValue = existingAsset.Name;
newAsset = existingAsset;
newAsset.Name = assetName;
newAsset.Update();
AuditTrailDAO objAuditTrailDAO = new AuditTrailDAO();
// Build a blank AuditTrailEntry
AuditTrailEntry ate = CreateAteForAssetNameChange(newAsset);
ate.Key = ate.Key + "|" + "Computer Name";
ate.OldValue = strOldValue;
ate.NewValue = assetName;
objAuditTrailDAO.AuditTrailAdd(ate);
}
}
}
if (bUpdateAsset && !bSNMPAsset && !bExistingAuditedAsset)
{
newAsset.Domain = childGroup.Name;
newAsset.DomainID = childGroup.GroupID;
newAsset.IPAddress = ipAddress;
// Add the asset
newAsset.Add();
if (lSettingsDao.GetSettingAsBoolean("AutoScanNetwork", false) && lSettingsDao.GetSettingAsBoolean("AutoScanDeployAgent", false))
{
string scannerPath = System.IO.Path.Combine(Application.StartupPath, "scanners") + "\\auditagent\\default.xml";
System.IO.File.Copy(scannerPath, "AuditAgent\\AuditAgent.xml", true);
Operation newOperation = new Operation(newAsset.AssetID, Operation.OPERATION.deployagent);
newOperation.Add();
}
}
if (!bSNMPAsset)
{
Interlocked.Increment(ref _foundCounter);
FireNetworkDiscoveryUpdate(new DiscoveryUpdateEventArgs(_foundCounter.ToString(), "Computer", _maximumCount, 0));
}
}