public void Asset_Logical_Drive_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode Drive_letter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_letter");
XmlNode Drive_type = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_type");
XmlNode File_system_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//File_system_name");
XmlNode Free_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Free_bytes");
XmlNode Total_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Total_bytes");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_LogicalDrive_mst objlogical = new Asset_LogicalDrive_mst();
if (count1 == 0)
{
objlogical.Assetid = varassetid;
}
else
{
objlogical.Assetid = Assetid;
}
objlogical.Drive_letter = Drive_letter.InnerText;
objlogical.Drive_type = Drive_type.InnerText;
objlogical.File_system_name = File_system_name.InnerText;
objlogical.Free_bytes = Free_bytes.InnerText;
objlogical.Inventory_date = inventorydate2;
objlogical.Total_bytes = Total_bytes.InnerText;
objlogical.Insert();
}
public void Asset_Logical_Drive_Info(XmlDocument xmldoc)
{
try
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode Drive_letter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_letter");
XmlNode Drive_type = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_type");
XmlNode File_system_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//File_system_name");
XmlNode Free_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Free_bytes");
XmlNode Total_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Total_bytes");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_LogicalDrive_mst objlogical = new Asset_LogicalDrive_mst();
if (count1 == 0)
{
objlogical.Assetid = varassetid;
}
else
{
objlogical.Assetid = Assetid;
}
objlogical.Drive_letter = Drive_letter.InnerText;
objlogical.Drive_type = Drive_type.InnerText;
objlogical.File_system_name = File_system_name.InnerText;
objlogical.Free_bytes = Free_bytes.InnerText;
objlogical.Inventory_date = inventorydate2;
objlogical.Total_bytes = Total_bytes.InnerText;
objlogical.Insert();
}
catch (Exception ex)
{
ex.ToString();
}
}
public object GenerateAssetLogicalDrive_mstObject(ref IDataReader returnData)
{
Asset_LogicalDrive_mst obj = new Asset_LogicalDrive_mst();
while (returnData.Read())
{
obj.Assetid = (int)returnData["assetid"];
obj.Assetlogicaldriveid = (int)returnData["assetlogicaldriveid"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Drive_letter = (string)returnData["drive_letter"];
obj.Drive_type = (string)returnData["drive_type"];
obj.File_system_name = (string)returnData["file_system_name"];
obj.Free_bytes = (string)returnData["free_bytes"];
obj.Total_bytes = (string)returnData["total_bytes"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public int Update_Asset_LogicalDrive_mst_By_id(Asset_LogicalDrive_mst objAssetlogicaldrive)
{
return (int)ExecuteNonQuery(Sp_Asset_LogicalDrive_Update, new object[] { objAssetlogicaldrive.Assetlogicaldriveid, objAssetlogicaldrive.Assetid, objAssetlogicaldrive.Drive_letter, objAssetlogicaldrive.Drive_type, objAssetlogicaldrive.File_system_name, objAssetlogicaldrive.Free_bytes, objAssetlogicaldrive.Inventory_date, objAssetlogicaldrive.Total_bytes });
}
public CollectionBase GenerateAssetLogicalDrive_mstCollection(ref IDataReader returnData)
{
BLLCollection<Asset_LogicalDrive_mst> col = new BLLCollection<Asset_LogicalDrive_mst>();
while (returnData.Read())
{
Asset_LogicalDrive_mst obj = new Asset_LogicalDrive_mst();
obj.Assetid = (int)returnData["assetid"];
obj.Assetlogicaldriveid = (int)returnData["assetlogicaldriveid"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Drive_letter = (string)returnData["drive_letter"];
obj.Drive_type = (string)returnData["drive_type"];
obj.File_system_name = (string)returnData["file_system_name"];
obj.Free_bytes = (string)returnData["free_bytes"];
obj.Total_bytes = (string)returnData["total_bytes"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
