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_OS_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode os_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Name"); XmlNode major_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Major_version"); XmlNode minor_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Minor_version"); XmlNode build_no = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Build_number"); XmlNode add_info = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Additional_information"); XmlNode user_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//User_name"); XmlNode reg_to = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_to"); XmlNode reg_org = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_organization"); XmlNode reg_code = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registration_code"); XmlNode localization = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Locale"); XmlNode product_key = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Product_key"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst(); objos.Add_info = add_info.InnerText; if (count1 == 0) { objos.Assetid = varassetid; } else { objos.Assetid = Assetid; } objos.Build_no = build_no.InnerText; objos.Inventory_date = inventorydate2; objos.Localization = localization.InnerText; objos.Major_version = major_version.InnerText; objos.Minor_version = minor_version.InnerText; objos.Os_name = os_name.InnerText; objos.Product_key = product_key.InnerText; objos.Reg_code = reg_code.InnerText; objos.Reg_org = reg_org.InnerText; objos.Reg_to = reg_to.InnerText; objos.User_name = user_name.InnerText; objos.Insert(); } catch (Exception ex) { ex.ToString(); } }
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 int Update_Asset_OperatingSystem_mst_By_id(Asset_OperatingSystem_mst objAssetOperatingSystem) { return (int)ExecuteNonQuery(Sp_Asset_OperatingSystem_Update, new object[] { objAssetOperatingSystem.Add_info, objAssetOperatingSystem.Assetid, objAssetOperatingSystem.Assetoperatingid, objAssetOperatingSystem.Build_no, objAssetOperatingSystem.Install_date, objAssetOperatingSystem.Inventory_date, objAssetOperatingSystem.Localization, objAssetOperatingSystem.Login_date, objAssetOperatingSystem.Major_version, objAssetOperatingSystem.Minor_version, objAssetOperatingSystem.Os_name, objAssetOperatingSystem.Product_key, objAssetOperatingSystem.Reg_code, objAssetOperatingSystem.Reg_org, objAssetOperatingSystem.Reg_to, objAssetOperatingSystem.User_name }); }
public object GenerateAssetOperatingSystem_mst_ByAssetidObject(ref IDataReader returnData) { Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst(); while (returnData.Read()) { obj.Assetid = (int)returnData["assetid"]; obj.Assetoperatingid = (int)returnData["assetoperatingid"]; obj.Add_info = (string)returnData["add_info"]; obj.Build_no = (string)returnData["build_no"]; obj.Localization = (string)returnData["localization"]; obj.Major_version = (string)returnData["major_version"]; obj.Minor_version = (string)returnData["minor_version"]; obj.Os_name = (string)returnData["os_name"]; obj.Product_key = (string)returnData["product_key"]; obj.Reg_code = (string)returnData["reg_code"]; obj.Reg_org = (string)returnData["reg_org"]; obj.Reg_to = (string)returnData["reg_to"]; obj.User_name = (string)returnData["user_name"]; } returnData.Close(); returnData.Dispose(); return obj; }
public object GenerateAssetOperatingSystem_mstObject(ref IDataReader returnData) { Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst(); while (returnData.Read()) { obj.Assetid = (int)returnData["assetid"]; obj.Assetoperatingid = (int)returnData["assetoperatingid"]; obj.Add_info = (string)returnData["add_info"]; DateTime inventorydatetime = new DateTime(); inventorydatetime = (DateTime)returnData["inventorydate"]; obj.Inventory_date = inventorydatetime.ToString(); obj.Build_no = (string)returnData["build_no"]; obj.Localization = (string)returnData["localization"]; obj.Major_version = (string)returnData["major_version"]; obj.Minor_version = (string)returnData["minor_version"]; obj.Os_name = (string)returnData["os_name"]; obj.Product_key = (string)returnData["product_key"]; obj.Reg_code = (string)returnData["reg_code"]; obj.Reg_org = (string)returnData["reg_org"]; obj.Reg_to = (string)returnData["reg_to"]; obj.User_name = (string)returnData["user_name"]; DateTime installdatetime = new DateTime(); installdatetime = (DateTime)returnData["install_date"]; obj.Install_date = installdatetime.ToString(); DateTime logindatetime = new DateTime(); logindatetime = (DateTime)returnData["login_date"]; obj.Login_date = logindatetime.ToString(); } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase GenerateAssetOperatingSystem_mstCollectionUsers(ref IDataReader returnData) { BLLCollection<Asset_OperatingSystem_mst> col = new BLLCollection<Asset_OperatingSystem_mst>(); while (returnData.Read()) { Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst(); if (returnData["user_name"] != "") { obj.User_name = (string)returnData["user_name"]; } col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }
public CollectionBase GenerateAssetOperatingSystem_mstCollection(ref IDataReader returnData) { BLLCollection<Asset_OperatingSystem_mst> col = new BLLCollection<Asset_OperatingSystem_mst>(); while (returnData.Read()) { Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst(); obj.Assetid = (int)returnData["assetid"]; obj.Assetoperatingid = (int)returnData["assetoperatingid"]; obj.Add_info = (string)returnData["add_info"]; DateTime inventorydatetime = new DateTime(); inventorydatetime = (DateTime)returnData["inventory_date"]; obj.Inventory_date = inventorydatetime.ToString(); obj.Build_no = (string)returnData["build_no"]; obj.Localization = (string)returnData["localization"]; obj.Major_version = (string)returnData["major_version"]; obj.Minor_version = (string)returnData["minor_version"]; obj.Os_name = (string)returnData["os_name"]; obj.Product_key = (string)returnData["product_key"]; obj.Reg_code = (string)returnData["reg_code"]; obj.Reg_org = (string)returnData["reg_org"]; obj.Reg_to = (string)returnData["reg_to"]; obj.User_name = (string)returnData["user_name"]; DateTime installdatetime = new DateTime(); if (returnData["install_date"] != DBNull.Value) { installdatetime = (DateTime)returnData["install_date"]; obj.Install_date = installdatetime.ToString(); } DateTime logindatetime = new DateTime(); if (returnData["login_date"] != DBNull.Value) { logindatetime = (DateTime)returnData["login_date"]; obj.Login_date = logindatetime.ToString(); } col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }