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