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