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