public void Asset_Inventory_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
int countinventorydetails;
XmlNode compname = xmldoc.DocumentElement.SelectSingleNode("//Computer//Computer_name");
XmlNode domain = xmldoc.DocumentElement.SelectSingleNode("//Computer//Domain");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Inventory_mst objinventory = new Asset_Inventory_mst();
if (count1 == 0)
{
objinventory.Assetid = varassetid;
}
else
{
objinventory.Assetid = Assetid;
countinventorydetails = objinventory.Get_Inventory_By_Assetid_InventoryDate(Assetid, inventorydate2);
if (countinventorydetails != 0)
{
objinventory.delete_Existingdetails_From_Asset(Assetid, inventorydate2);
}
}
objinventory.Computername = compname.InnerText;
objinventory.Inventorydate = inventory_date.InnerText;
objinventory.Insert();
}
public void Asset_Inventory_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
int countinventorydetails;
XmlNode compname = xmldoc.DocumentElement.SelectSingleNode("//Computer//Computer_name");
XmlNode domain = xmldoc.DocumentElement.SelectSingleNode("//Computer//Domain");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Inventory_mst objinventory = new Asset_Inventory_mst();
if (count1 == 0)
{
objinventory.Assetid = varassetid;
}
else
{
objinventory.Assetid = Assetid;
countinventorydetails = objinventory.Get_Inventory_By_Assetid_InventoryDate(Assetid, inventorydate2);
if(countinventorydetails!=0)
{
objinventory.delete_Existingdetails_From_Asset(Assetid, inventorydate2);
}
}
objinventory.Computername = compname.InnerText;
objinventory.Inventorydate = inventory_date.InnerText;
objinventory.Insert();
}
public int Update_Asset_Inventory_mst_By_id(Asset_Inventory_mst objAssetInventory)
{
return (int)ExecuteNonQuery(Sp_Asset_Inventory_Update, new object[] { objAssetInventory.Assetid, objAssetInventory.Computername, objAssetInventory.Inventorydate });
}
public int Insert_Asset_Inventory_mst(Asset_Inventory_mst objinventoryAsset)
{
return (int)ExecuteNonQuery(sp_Asset_Inventory_Insert, new object[] { objinventoryAsset.Assetid, objinventoryAsset.Inventorydate, objinventoryAsset.Computername });
}
public object GenerateAssetinventory_mstObject(ref IDataReader returnData)
{
Asset_Inventory_mst obj = new Asset_Inventory_mst();
while (returnData.Read())
{
obj.Assetid = (int)returnData["assetid"];
obj.Computername = (string)returnData["ComputerName"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventorydate = inventorydatetime.ToString();
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateAssetInventory_mstCollection(ref IDataReader returnData)
{
BLLCollection<Asset_Inventory_mst> col = new BLLCollection<Asset_Inventory_mst>();
while (returnData.Read())
{
Asset_Inventory_mst obj = new Asset_Inventory_mst();
obj.Assetid = (int)returnData["assetid"];
obj.Computername = (string)returnData["ComputerName"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventorydate = inventorydatetime.ToString();
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
