public void Asset_Physical_Drive_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode physical_drives = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Capacity = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Capacity"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Manufacturer"); XmlNode physical_drives1 = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Product_version"); XmlNode Product_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Serial_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_PhysicalDrive_mst objphysical = new Asset_PhysicalDrive_mst(); if (count1 == 0) { objphysical.Assetid = varassetid; } else { objphysical.Assetid = Assetid; } objphysical.Capacity = Capacity.InnerText; objphysical.Drive_name = physical_drives.InnerText; objphysical.Inventory_date = inventorydate2; objphysical.Manufacturer = Manufacturer.InnerText; objphysical.Product_version = Product_version.InnerText; objphysical.Serial_number = Serial_number.InnerText; objphysical.Insert(); }
public void Asset_Physical_Drive_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode physical_drives = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Capacity = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Capacity"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Manufacturer"); XmlNode physical_drives1 = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Product_version"); XmlNode Product_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Serial_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_PhysicalDrive_mst objphysical = new Asset_PhysicalDrive_mst(); if (count1 == 0) { objphysical.Assetid = varassetid; } else { objphysical.Assetid = Assetid; } objphysical.Capacity = Capacity.InnerText; objphysical.Drive_name = physical_drives.InnerText; objphysical.Inventory_date = inventorydate2; objphysical.Manufacturer = Manufacturer.InnerText; objphysical.Product_version = Product_version.InnerText; objphysical.Serial_number = Serial_number.InnerText; objphysical.Insert(); } catch (Exception ex) { ex.ToString(); } }
public object GenerateAssetPhysicalDrive_mstObject(ref IDataReader returnData) { Asset_PhysicalDrive_mst obj = new Asset_PhysicalDrive_mst(); while (returnData.Read()) { obj.Assetid = (int)returnData["assetid"]; obj.Assetphysicaldriveid = (int)returnData["assetphysicaldriveid"]; DateTime inventorydatetime = new DateTime(); inventorydatetime = (DateTime)returnData["inventorydate"]; obj.Inventory_date = inventorydatetime.ToString(); obj.Capacity = (string)returnData["capacity"]; obj.Drive_name = (string)returnData["drive_name"]; obj.Manufacturer = (string)returnData["manufacturer"]; obj.Product_id = (string)returnData["product_id"]; obj.Product_version = (string)returnData["product_version"]; obj.Serial_number = (string)returnData["serial_number"]; } returnData.Close(); returnData.Dispose(); return obj; }
public int Update_Asset_PhysicalDrive_mst_By_id(Asset_PhysicalDrive_mst objAssetPhysicalDrive) { return (int)ExecuteNonQuery(Sp_Asset_PhysicalDrive_Update, new object[] { objAssetPhysicalDrive.Assetid, objAssetPhysicalDrive.Assetphysicaldriveid, objAssetPhysicalDrive.Capacity, objAssetPhysicalDrive.Drive_name, objAssetPhysicalDrive.Inventory_date, objAssetPhysicalDrive.Manufacturer, objAssetPhysicalDrive.Product_id, objAssetPhysicalDrive.Product_version, objAssetPhysicalDrive.Serial_number }); }
public CollectionBase GenerateAssetPhysicalDrive_mstCollection(ref IDataReader returnData) { BLLCollection<Asset_PhysicalDrive_mst> col = new BLLCollection<Asset_PhysicalDrive_mst>(); while (returnData.Read()) { Asset_PhysicalDrive_mst obj = new Asset_PhysicalDrive_mst(); obj.Assetid = (int)returnData["assetid"]; obj.Assetphysicaldriveid = (int)returnData["assetphysicaldriveid"]; DateTime inventorydatetime = new DateTime(); inventorydatetime = (DateTime)returnData["inventorydate"]; obj.Inventory_date = inventorydatetime.ToString(); obj.Capacity = (string)returnData["capacity"]; obj.Drive_name = (string)returnData["drive_name"]; obj.Manufacturer = (string)returnData["manufacturer"]; obj.Product_id = (string)returnData["product_id"]; obj.Product_version = (string)returnData["product_version"]; obj.Serial_number = (string)returnData["serial_number"]; col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }