public void BindGrid()
{
DataTable dtTable = new DataTable();
dtTable = CreateDataTable();
Asset_mst objAsset = new Asset_mst();
BLLCollection<Asset_mst> colAsset = new BLLCollection<Asset_mst>();
colAsset = objAsset.Get_All();
foreach (Asset_mst obj in colAsset)
{
DataRow row;
row = dtTable.NewRow();
row["computername"] = Convert.ToString(obj.Computername);
assetid = Convert.ToInt16(obj.Assetid);
Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
objos = objos.Get_By_Assetid(assetid);
row["osname"] = Convert.ToString(objos.Os_name);
row["username"] = Convert.ToString(objos.User_name);
row["productkey"] = Convert.ToString(objos.Product_key);
Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
objproduct = objproduct.Get_By_Assetid(assetid);
row["productname"] = Convert.ToString(objproduct.Product_name);
row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
row["serialno"] = Convert.ToString(objproduct.Serial_number);
Asset_Processor_mst objprocessor = new Asset_Processor_mst();
objprocessor = objprocessor.Get_By_Assetid(assetid);
row["processorname"] = Convert.ToString(objprocessor.Processor_name);
Asset_Memory_mst objmemory = new Asset_Memory_mst();
objmemory = objmemory.Get_By_Assetid(assetid);
row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
dtTable.Rows.Add(row);
}
dtgrid.DataSource = dtTable;
dtgrid.DataBind();
}
public void Asset_Memory_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode physical_mem = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Physical_memory");
XmlNode virtual_mem = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Virtual_memory");
XmlNode page_file = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Page_file_size");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Memory_mst objmemory = new Asset_Memory_mst();
if (count1 == 0)
{
objmemory.Assetid = varassetid;
}
else
{
objmemory.Assetid = Assetid;
}
objmemory.Inventory_date = inventorydate2;
objmemory.Page_file = page_file.InnerText;
if (Convert.ToDecimal(physical_mem.InnerText) >= 1073741824)
{
decimal physicalmem = Convert.ToDecimal(physical_mem.InnerText) / 1073741824;
//objmemory.Physical_mem = physicalmem.ToString() + " GB";
objmemory.Physical_mem = String.Format("{0:0.00}", physicalmem) + " GB";
}
else
{
decimal physicalmem = Convert.ToDecimal(physical_mem.InnerText) / 1048576;
//objmemory.Physical_mem = physicalmem.ToString() + " MB";
objmemory.Physical_mem = String.Format("{0:0.00}", physicalmem) + " MB";
}
// objmemory.Physical_mem = physical_mem.InnerText;
if (Convert.ToDecimal(virtual_mem.InnerText) >= 1073741824)
{
decimal virtualmem = Convert.ToDecimal(virtual_mem.InnerText) / 1073741824;
objmemory.Virtual_mem = String.Format("{0:0.00}", virtualmem) + " GB";
}
else
{
decimal virtualmem = Convert.ToDecimal(virtual_mem.InnerText) / 1048576;
objmemory.Virtual_mem = String.Format("{0:0.00}", virtualmem) + " MB";
}
// objmemory.Virtual_mem = virtual_mem.InnerText;
objmemory.Insert();
}
public void BindGrid()
{
DataTable dtTable = new DataTable();
dtTable = CreateDataTable();
Asset_mst objAsset = new Asset_mst();
BLLCollection <Asset_mst> colAsset = new BLLCollection <Asset_mst>();
colAsset = objAsset.Get_All();
foreach (Asset_mst obj in colAsset)
{
DataRow row;
row = dtTable.NewRow();
row["computername"] = Convert.ToString(obj.Computername);
assetid = Convert.ToInt32(obj.Assetid);
Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
objos = objos.Get_By_Assetid(assetid);
row["osname"] = Convert.ToString(objos.Os_name);
row["username"] = Convert.ToString(objos.User_name);
row["productkey"] = Convert.ToString(objos.Product_key);
Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
objproduct = objproduct.Get_By_Assetid(assetid);
row["productname"] = Convert.ToString(objproduct.Product_name);
row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
row["serialno"] = Convert.ToString(objproduct.Serial_number);
Asset_Processor_mst objprocessor = new Asset_Processor_mst();
objprocessor = objprocessor.Get_By_Assetid(assetid);
row["processorname"] = Convert.ToString(objprocessor.Processor_name);
Asset_Memory_mst objmemory = new Asset_Memory_mst();
objmemory = objmemory.Get_By_Assetid(assetid);
row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
dtTable.Rows.Add(row);
}
dtgrid.DataSource = dtTable;
dtgrid.DataBind();
}
public void Asset_Memory_Info(XmlDocument xmldoc)
{
try
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode physical_mem = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Physical_memory");
XmlNode virtual_mem = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Virtual_memory");
XmlNode page_file = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Memory//Page_file_size");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_Memory_mst objmemory = new Asset_Memory_mst();
if (count1 == 0)
{
objmemory.Assetid = varassetid;
}
else
{
objmemory.Assetid = Assetid;
}
objmemory.Inventory_date = inventorydate2;
objmemory.Page_file = page_file.InnerText;
if (physical_mem.InnerText != "")
{
if (Convert.ToDecimal(physical_mem.InnerText) >= 1073741824)
{
decimal physicalmem = Convert.ToDecimal(physical_mem.InnerText) / 1073741824;
//objmemory.Physical_mem = physicalmem.ToString() + " GB";
objmemory.Physical_mem = String.Format("{0:0.00}", physicalmem) + " GB";
}
else
{
decimal physicalmem = Convert.ToDecimal(physical_mem.InnerText) / 1048576;
//objmemory.Physical_mem = physicalmem.ToString() + " MB";
objmemory.Physical_mem = String.Format("{0:0.00}", physicalmem) + " MB";
}
}
// objmemory.Physical_mem = physical_mem.InnerText;
if (virtual_mem.InnerText != "")
{
if (Convert.ToDecimal(virtual_mem.InnerText) >= 1073741824)
{
decimal virtualmem = Convert.ToDecimal(virtual_mem.InnerText) / 1073741824;
objmemory.Virtual_mem = String.Format("{0:0.00}", virtualmem) + " GB";
}
else
{
decimal virtualmem = Convert.ToDecimal(virtual_mem.InnerText) / 1048576;
objmemory.Virtual_mem = String.Format("{0:0.00}", virtualmem) + " MB";
}
}
// objmemory.Virtual_mem = virtual_mem.InnerText;
objmemory.Insert();
}
catch (Exception ex)
{
ex.ToString();
}
}
public int Update_Asset_Memory_mst_By_id(Asset_Memory_mst objAssetMemory)
{
return (int)ExecuteNonQuery(Sp_Asset_Memory_Update, new object[] { objAssetMemory.Assetmemoryid, objAssetMemory.Assetid, objAssetMemory.Inventory_date, objAssetMemory.Page_file, objAssetMemory.Physical_mem, objAssetMemory.Virtual_mem });
}
public int Insert_Asset_Memory_mst(Asset_Memory_mst objAssetMemory)
{
return (int)ExecuteNonQuery(sp_Asset_Memory_Insert, new object[] { objAssetMemory.Assetmemoryid, objAssetMemory.Assetid, objAssetMemory.Inventory_date, objAssetMemory.Page_file, objAssetMemory.Physical_mem, objAssetMemory.Virtual_mem });
}
public object GenerateAssetMemory_mstObject(ref IDataReader returnData)
{
Asset_Memory_mst obj = new Asset_Memory_mst();
while (returnData.Read())
{
obj.Assetid = (int)returnData["assetid"];
obj.Assetmemoryid = (int)returnData["assetmemoryid"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Page_file = (string)returnData["page_file"];
obj.Physical_mem = (string)returnData["physical_mem"];
obj.Virtual_mem = (string)returnData["virtual_mem"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateAssetMemory_mstCollection(ref IDataReader returnData)
{
BLLCollection<Asset_Memory_mst> col = new BLLCollection<Asset_Memory_mst>();
while (returnData.Read())
{
Asset_Memory_mst obj = new Asset_Memory_mst();
obj.Assetid = (int)returnData["assetid"];
obj.Assetmemoryid = (int)returnData["assetmemoryid"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Page_file = (string)returnData["page_file"];
obj.Physical_mem = (string)returnData["physical_mem"];
obj.Virtual_mem = (string)returnData["virtual_mem"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
