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_Product_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode product_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Name"); XmlNode product_manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Manufacturer"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Serial_number"); XmlNode UUID = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//UUID"); XmlNode SKU_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//SKU_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_ProductInfo_mst objprodinfo = new Asset_ProductInfo_mst(); if (count1 == 0) { objprodinfo.Assetid = varassetid; } else { objprodinfo.Assetid = Assetid; } objprodinfo.Inventory_date = inventorydate2; objprodinfo.Product_manufacturer = product_manufacturer.InnerText; objprodinfo.Product_name = product_name.InnerText; objprodinfo.Serial_number = Serial_number.InnerText; objprodinfo.Sku_no = SKU_number.InnerText; objprodinfo.Uuid = UUID.InnerText; objprodinfo.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_Product_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode product_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Name"); XmlNode product_manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Manufacturer"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Serial_number"); XmlNode UUID = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//UUID"); XmlNode SKU_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//SKU_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_ProductInfo_mst objprodinfo = new Asset_ProductInfo_mst(); if (count1 == 0) { objprodinfo.Assetid = varassetid; } else { objprodinfo.Assetid = Assetid; } objprodinfo.Inventory_date = inventorydate2; objprodinfo.Product_manufacturer = product_manufacturer.InnerText; objprodinfo.Product_name = product_name.InnerText; objprodinfo.Serial_number = Serial_number.InnerText; objprodinfo.Sku_no = SKU_number.InnerText; objprodinfo.Uuid = UUID.InnerText; objprodinfo.Insert(); } catch (Exception ex) { ex.ToString(); } }
public int Update_Asset_ProductInfo_mst_By_id(Asset_ProductInfo_mst objAssetProductInfo) { return (int)ExecuteNonQuery(Sp_Asset_ProductInfo_Update, new object[] { objAssetProductInfo.Assetproductinfoid, objAssetProductInfo.Assetid, objAssetProductInfo.Inventory_date, objAssetProductInfo.Product_name, objAssetProductInfo.Product_manufacturer, objAssetProductInfo.Serial_number, objAssetProductInfo.Uuid, objAssetProductInfo.Sku_no }); }
public object GenerateAssetProductInfo_mst_ByAssetidObject(ref IDataReader returnData) { Asset_ProductInfo_mst obj = new Asset_ProductInfo_mst(); while (returnData.Read()) { obj.Assetid = (int)returnData["assetid"]; obj.Assetproductinfoid = (int)returnData["assetproductinfoid"]; //DateTime inventorydatetime = new DateTime(); //inventorydatetime = (DateTime)returnData["inventorydate"]; //obj.Inventory_date = inventorydatetime.ToString(); obj.Product_manufacturer = (string)returnData["product_manufacturer"]; obj.Product_name = (string)returnData["product_name"]; obj.Serial_number = (string)returnData["serial_number"]; obj.Sku_no = (string)returnData["sku_no"]; obj.Uuid = (string)returnData["uuid"]; } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase GenerateAssetProductInfo_mstCollection(ref IDataReader returnData) { BLLCollection<Asset_ProductInfo_mst> col = new BLLCollection<Asset_ProductInfo_mst>(); while (returnData.Read()) { Asset_ProductInfo_mst obj = new Asset_ProductInfo_mst(); obj.Assetid = (int)returnData["assetid"]; obj.Assetproductinfoid = (int)returnData["assetproductinfoid"]; DateTime inventorydatetime = new DateTime(); inventorydatetime = (DateTime)returnData["inventorydate"]; obj.Inventory_date = inventorydatetime.ToString(); obj.Product_manufacturer = (string)returnData["product_manufacturer"]; obj.Product_name = (string)returnData["product_name"]; obj.Serial_number = (string)returnData["serial_number"]; obj.Sku_no = (string)returnData["sku_no"]; obj.Uuid = (string)returnData["uuid"]; col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }