public void Asset_Network_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode adapter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter");
XmlNode protocol = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol");
XmlNode protocol_IP_Addresses_Address = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//IP_Addresses//Address//Address");
XmlNode protocol_Gateways = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//Gateways");
XmlNode Link_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Link_speed");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Network_mst objnetwork = new Asset_Network_mst();
objnetwork.Adapter_name = adapter.InnerText;
if (count1 == 0)
{
objnetwork.Assetid = varassetid;
}
else
{
objnetwork.Assetid = Assetid;
}
objnetwork.Gateway = protocol_Gateways.InnerText;
objnetwork.Inventory_date = inventorydate2;
objnetwork.Ip_address = protocol_IP_Addresses_Address.InnerText;
objnetwork.Link_speed = Link_speed.InnerText;
objnetwork.Protocol_name = protocol.InnerText;
objnetwork.Insert();
}
public int Update_Asset_Network_mst_By_id(Asset_Network_mst objAssetNetwork)
{
return (int)ExecuteNonQuery(Sp_Asset_Network_Update, new object[] { objAssetNetwork.Assetnetworkid, objAssetNetwork.Adapter_name, objAssetNetwork.Assetid, objAssetNetwork.Gateway, objAssetNetwork.Inventory_date, objAssetNetwork.Ip_address, objAssetNetwork.Link_speed, objAssetNetwork.Mac_address, objAssetNetwork.Mtu, objAssetNetwork.Protocol_name, objAssetNetwork.Subnet_mask, objAssetNetwork.Type });
}
public void Asset_Network_Info(XmlDocument xmldoc)
{
try
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode adapter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter");
XmlNode protocol = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol");
XmlNode protocol_IP_Addresses_Address = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//IP_Addresses//Address//Address");
XmlNode protocol_Gateways = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//Gateways");
XmlNode Link_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Link_speed");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Network_mst objnetwork = new Asset_Network_mst();
objnetwork.Adapter_name = adapter.InnerText;
if (count1 == 0)
{
objnetwork.Assetid = varassetid;
}
else
{
objnetwork.Assetid = Assetid;
}
objnetwork.Gateway = protocol_Gateways.InnerText;
objnetwork.Inventory_date = inventorydate2;
//change done by meenakshi
if (protocol_IP_Addresses_Address != null)
{
objnetwork.Ip_address = protocol_IP_Addresses_Address.InnerText;
}
if (Link_speed != null)
{
objnetwork.Link_speed = Link_speed.InnerText;
}
if (protocol != null)
{
objnetwork.Protocol_name = protocol.InnerText;
}
objnetwork.Insert();
}
catch (Exception ex)
{
ex.ToString();
}
}
public object GenerateAssetNetwork_mstObject(ref IDataReader returnData)
{
Asset_Network_mst obj = new Asset_Network_mst();
while (returnData.Read())
{
obj.Assetid = (int)returnData["assetid"];
obj.Assetnetworkid = (int)returnData["assetnetworkid"];
obj.Adapter_name = (string)returnData["adapter_name"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Gateway = (string)returnData["gateway"];
obj.Ip_address = (string)returnData["ip_address"];
obj.Link_speed = (string)returnData["link_speed"];
obj.Mac_address = (string)returnData["mac_address"];
obj.Mtu = (string)returnData["mtu"];
obj.Protocol_name = (string)returnData["protocol_name"];
obj.Subnet_mask = (string)returnData["subnet_mask"];
obj.Type = (string)returnData["type"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
