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_Logical_Drive_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode Drive_letter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_letter"); XmlNode Drive_type = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_type"); XmlNode File_system_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//File_system_name"); XmlNode Free_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Free_bytes"); XmlNode Total_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Total_bytes"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_LogicalDrive_mst objlogical = new Asset_LogicalDrive_mst(); if (count1 == 0) { objlogical.Assetid = varassetid; } else { objlogical.Assetid = Assetid; } objlogical.Drive_letter = Drive_letter.InnerText; objlogical.Drive_type = Drive_type.InnerText; objlogical.File_system_name = File_system_name.InnerText; objlogical.Free_bytes = Free_bytes.InnerText; objlogical.Inventory_date = inventorydate2; objlogical.Total_bytes = Total_bytes.InnerText; objlogical.Insert(); }
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 Asset_Physical_Drive_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode physical_drives = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Capacity = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Capacity"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Manufacturer"); XmlNode physical_drives1 = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Product_version"); XmlNode Product_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Serial_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_PhysicalDrive_mst objphysical = new Asset_PhysicalDrive_mst(); if (count1 == 0) { objphysical.Assetid = varassetid; } else { objphysical.Assetid = Assetid; } objphysical.Capacity = Capacity.InnerText; objphysical.Drive_name = physical_drives.InnerText; objphysical.Inventory_date = inventorydate2; objphysical.Manufacturer = Manufacturer.InnerText; objphysical.Product_version = Product_version.InnerText; objphysical.Serial_number = Serial_number.InnerText; objphysical.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 void Asset_Network_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode adapter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter"); XmlNode protocol = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol"); XmlNode protocol_IP_Addresses_Address = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//IP_Addresses//Address//Address"); XmlNode protocol_Gateways = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//Gateways"); XmlNode Link_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Link_speed"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_Network_mst objnetwork = new Asset_Network_mst(); objnetwork.Adapter_name = adapter.InnerText; if (count1 == 0) { objnetwork.Assetid = varassetid; } else { objnetwork.Assetid = Assetid; } objnetwork.Gateway = protocol_Gateways.InnerText; objnetwork.Inventory_date = inventorydate2; objnetwork.Ip_address = protocol_IP_Addresses_Address.InnerText; objnetwork.Link_speed = Link_speed.InnerText; objnetwork.Protocol_name = protocol.InnerText; objnetwork.Insert(); }
public void Asset_Processor_Info(XmlDocument xmldoc) { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode Family = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Family"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Manufacturer"); XmlNode Max_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Max_speed"); XmlNode Model = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Model"); XmlNode processors = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Processor"); XmlNode Speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Speed"); XmlNode Stepping = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Stepping"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_Processor_mst objprocessor = new Asset_Processor_mst(); if (count1 == 0) { objprocessor.Assetid = varassetid; } else { objprocessor.Assetid = Assetid; } objprocessor.Family = Family.InnerText; objprocessor.Inventory_date = inventorydate2; objprocessor.Manufacturer = Manufacturer.InnerText; objprocessor.Max_speed = Max_speed.InnerText; objprocessor.Model = Model.InnerText; objprocessor.Processor_name = processors.InnerText; objprocessor.Speed = Speed.InnerText; objprocessor.Stepping = Stepping.InnerText; objprocessor.Insert(); }
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 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 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(); } }
protected void btnAdd_click(object sender, EventArgs e) {/////Add Exception handilng try catch change by vishal 21-05-2012 try { lblerrmsg.Text = ""; int varassetid, compcount; string comname, domain; //string PurchaseDate; comname = txtcomputername.Text.ToString(); domain = txtdomain.Text.ToString(); compcount = objasset.Get_ComputerName(comname, domain); if (compcount == 0) { //insert Deatils for Asset_mst objasset.Computername = txtcomputername.Text.ToString(); objasset.Domain = txtdomain.Text.ToString(); //Added by lalit objasset.TagNo = TxtTagNo.Text; objasset.PONo = TxtPONo.Text; //if (DdlOwner.SelectedItem.Text == "Other") //{ objasset.AssetOwner = TxtOtherOwner.Text; //} //else //{ // objasset.AssetOwner = DdlOwner.SelectedItem.Text; //} objasset.location = Txtlocation.Text; if (DdlStock.SelectedItem.Text == "NO") { objasset.IsInStock = false; } else if (DdlStock.SelectedItem.Text == "YES") { objasset.IsInStock = true; } //meenakshi objasset.CompanyCode = Txtcompanycode.Text; //if (Txtpurchasedate.Text.Trim() != "") //{ // objasset.PurchaseDate = DateTime.ParseExact(Txtpurchasedate.Text.Trim(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString(); // //objasset.PurchaseDate = ((DateTime)cmd10.ExecuteScalar().ToSting("MM/DD/YYYY")); // //string[] tempdate = Txtpurchasedate.Text.ToString().Split(("/").ToCharArray()); // //objasset.PurchaseDate = tempdate[2] + "-" + tempdate[1] + "-" + tempdate[0]; //} //else //{ // objasset.PurchaseDate = null; //} //objasset.PurchaseDate = Txtpurchasedate.Text.ToString(); string[] tempdate = Txtpurchasedate.Text.ToString().Split(("/").ToCharArray()); objasset.PurchaseDate = tempdate[2] + "-" + tempdate[1] + "-" + tempdate[0]; objasset.AssetCategory = Txtassetcategory.Text; objasset.Remarks = Txtremarks.Text; // objasset.AssetLocation = DdlAssetLocation.SelectedItem.Text; //end //objasset.Createdatetime = lbldate.Text.ToString(); objasset.Insert1(); //Details for ProductInfo_mst varassetid = objasset.Get_Current_Assetid(); objproinfo.Assetid = varassetid; objproinfo.Product_manufacturer = txtproductmanufacture.Text.ToString(); objproinfo.Product_name = txtproductname.Text.ToString(); objproinfo.Serial_number = txtproductsno.Text.ToString(); objproinfo.Sku_no = txtskuno.Text.ToString(); objproinfo.Uuid = txtuuid.Text.ToString(); //Details for Prcessor_mst objprocessor.Assetid = varassetid; objprocessor.Family = txtfamily.Text.ToString(); objprocessor.Manufacturer = txtprocmanufacturer.Text.ToString(); objprocessor.Max_speed = txtmaxspeed.Text.ToString(); objprocessor.Model = txtmodel.Text.ToString(); objprocessor.Processor_name = txtprocessorname.Text.ToString(); objprocessor.Speed = txtspeed.Text.ToString(); objprocessor.Stepping = txtstepping.Text.ToString(); //Details for Memory_mst objmemory.Assetid = varassetid; objmemory.Page_file = txtpagefile.Text.ToString(); objmemory.Physical_mem = txtphysicalmemory.Text.ToString(); objmemory.Virtual_mem = txtvirtualmemory.Text.ToString(); //Details for Network_mst objnetwork.Adapter_name = txtadaptername.Text.ToString(); objnetwork.Assetid = varassetid; objnetwork.Gateway = txtgateway.Text.ToString(); objnetwork.Ip_address = txtipaddress.Text.ToString(); objnetwork.Link_speed = txtlinkspeed.Text.ToString(); objnetwork.Mac_address = txtmacaddress.Text.ToString(); objnetwork.Mtu = txtmtu.Text.ToString(); objnetwork.Protocol_name = txtprotocol.Text.ToString(); objnetwork.Subnet_mask = txtsubnet.Text.ToString(); objnetwork.Type = txttype.Text.ToString(); // Details of Operating System objoperating.Add_info = txtaddinfo.Text.ToString(); objoperating.Assetid = varassetid; objoperating.Build_no = txtbuildno.Text.ToString(); objoperating.Localization = txtlocal.Text.ToString(); objoperating.Major_version = txtmajorversion.Text.ToString(); objoperating.Minor_version = txtminorversion.Text.ToString(); objoperating.Os_name = txtosname.Text.ToString(); objoperating.Product_key = txtprokey.Text.ToString(); objoperating.Reg_code = txtregcode.Text.ToString(); objoperating.Reg_org = txtregorg.Text.ToString(); objoperating.Reg_to = txtregto.Text.ToString(); objoperating.User_name = txtusername1.Text.ToString(); //Details of Physical Drive objphydrive.Assetid = varassetid; objphydrive.Capacity = txtcapacity.Text.ToString(); objphydrive.Drive_name = txtdrivename.Text.ToString(); objphydrive.Manufacturer = txtmanufacturer.Text.ToString(); objphydrive.Product_id = txtproductid.Text.ToString(); objphydrive.Product_version = txtproductversion.Text.ToString(); objphydrive.Serial_number = txtserialno.Text.ToString(); //Details of Logical Drive objlogicdrive.Assetid = varassetid; objlogicdrive.Drive_letter = txtdriveletter.Text.ToString(); objlogicdrive.Drive_type = txtdrivetype.Text.ToString(); objlogicdrive.File_system_name = txtfilesysname.Text.ToString(); objlogicdrive.Free_bytes = txtfreebytes.Text.ToString(); objlogicdrive.Total_bytes = txttotalbytes.Text.ToString(); //Details of Inventory objinventory.Assetid = varassetid; objinventory.Computername = txtcomputername.Text.ToString(); //Insert functions objproinfo.Insert1(); objprocessor.Insert1(); objmemory.Insert1(); objnetwork.Insert1(); objoperating.Insert1(); objphydrive.Insert1(); objlogicdrive.Insert1(); objinventory.Insert1(); #region Create XML File // Section for Create new XML file //string compane; //comname = txtcomputername.Text.ToString(); XmlTextWriter textWriter = new XmlTextWriter("C:\\Asset\\Data\\" + comname + ".xml", null); // Opens the document textWriter.WriteStartDocument(); textWriter.WriteStartElement("Computer"); textWriter.WriteStartElement("Computer_name"); textWriter.WriteString(txtcomputername.Text.ToString()); textWriter.WriteEndElement();//End Computer_name textWriter.WriteStartElement("Domain"); textWriter.WriteString(txtdomain.Text.ToString()); textWriter.WriteEndElement();//End Domain textWriter.WriteStartElement("Created_on"); textWriter.WriteString(DateTime.Now.ToString()); textWriter.WriteEndElement();//End CreatedOn //added by lalit textWriter.WriteStartElement("TagNo"); textWriter.WriteString(TxtTagNo.Text.ToString()); textWriter.WriteEndElement();//End Tagno textWriter.WriteStartElement("PONo"); textWriter.WriteString(TxtPONo.Text.ToString()); textWriter.WriteEndElement();//End PONo textWriter.WriteStartElement("AssetOwner"); //if (DdlOwner.SelectedItem.Text == "Other") //{ textWriter.WriteString(TxtOtherOwner.Text.ToString()); textWriter.WriteEndElement(); // } //else //{ // textWriter.WriteString(DdlOwner.SelectedItem.Text.Trim()); // textWriter.WriteEndElement(); //} //added by prachi textWriter.WriteStartElement("Location"); //if (DdlOwner.SelectedItem.Text == "Other") //{ textWriter.WriteString(Txtlocation.Text.ToString()); textWriter.WriteEndElement(); textWriter.WriteStartElement("IsInStock"); textWriter.WriteString(DdlStock.Text.ToString()); textWriter.WriteEndElement();//end // textWriter.WriteStartElement("AssetLocation"); // textWriter.WriteString(DdlAssetLocation.SelectedItem.Text); // textWriter.WriteEndElement();//End PONo //end lalit //meenakshi //textWriter.WriteStartElement("CompanyCode"); //textWriter.WriteString(Txtcompanycode.Text.ToString()); //textWriter.WriteEndElement(); //textWriter.WriteStartElement("PurchaseDate"); //textWriter.WriteString(Txtpurchasedate.Text.ToString()); //textWriter.WriteEndElement(); //textWriter.WriteStartElement("AssetCategory"); //textWriter.WriteString(Txtassetcategory.Text.ToString()); //textWriter.WriteEndElement(); //textWriter.WriteStartElement("Remarks"); //textWriter.WriteString(Txtremarks.Text.ToString()); //textWriter.WriteEndElement(); //end textWriter.WriteStartElement("Hardware"); textWriter.WriteStartElement("Product_details"); textWriter.WriteStartElement("Name"); textWriter.WriteString(txtproductname.Text.ToString()); textWriter.WriteEndElement();//End Name textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtproductmanufacture.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Serial_number"); textWriter.WriteString(txtproductsno.Text.ToString()); textWriter.WriteEndElement();//End Serial number textWriter.WriteStartElement("UUID"); textWriter.WriteString(txtuuid.Text.ToString()); textWriter.WriteEndElement();//End Uuid textWriter.WriteStartElement("SKU_number"); textWriter.WriteString(txtskuno.Text.ToString()); textWriter.WriteEndElement(); //End SKU Number textWriter.WriteEndElement(); //End Product Details textWriter.WriteStartElement("Processors"); textWriter.WriteStartElement("Family"); textWriter.WriteString(txtfamily.Text.ToString()); textWriter.WriteEndElement();//End Family textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtprocmanufacturer.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Max_speed"); textWriter.WriteString(txtmaxspeed.Text.ToString()); textWriter.WriteEndElement();//End Max Speed textWriter.WriteStartElement("Model"); textWriter.WriteString(txtmodel.Text.ToString()); textWriter.WriteEndElement();//End Model textWriter.WriteStartElement("Processor"); textWriter.WriteString(txtprocessorname.Text.ToString()); textWriter.WriteEndElement();//End Processor textWriter.WriteStartElement("Speed"); textWriter.WriteString(txtspeed.Text.ToString()); textWriter.WriteEndElement();//End Speed textWriter.WriteStartElement("Stepping"); textWriter.WriteString(txtstepping.Text.ToString()); textWriter.WriteEndElement(); //End Stepping textWriter.WriteEndElement(); //End Processors textWriter.WriteStartElement("Memory"); textWriter.WriteStartElement("Physical_memory"); textWriter.WriteString(txtphysicalmemory.Text.ToString()); textWriter.WriteEndElement();//End Physical Memory textWriter.WriteStartElement("Virtual_memory"); textWriter.WriteString(txtvirtualmemory.Text.ToString()); textWriter.WriteEndElement();//End Virtual Memory textWriter.WriteStartElement("Page_file_size"); textWriter.WriteString(txtpagefile.Text.ToString()); textWriter.WriteEndElement(); //End Page File Size textWriter.WriteEndElement(); //End Memory textWriter.WriteStartElement("Physical_drives"); textWriter.WriteStartElement("Drive"); textWriter.WriteString(txtdrivename.Text.ToString()); textWriter.WriteEndElement();//End Drive textWriter.WriteStartElement("Capacity"); textWriter.WriteString(txtcapacity.Text.ToString()); textWriter.WriteEndElement();//End Capacity textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtmanufacturer.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Serial_number"); textWriter.WriteString(txtserialno.Text.ToString()); textWriter.WriteEndElement(); //End Serial Number textWriter.WriteEndElement(); //Physical Drive textWriter.WriteStartElement("Logical_drives"); textWriter.WriteStartElement("Drive_letter"); textWriter.WriteString(txtdriveletter.Text.ToString()); textWriter.WriteEndElement();//End Drive Letter textWriter.WriteStartElement("Drive_type"); textWriter.WriteString(txtdrivetype.Text.ToString()); textWriter.WriteEndElement();//End Drive Type textWriter.WriteStartElement("File_system_name"); textWriter.WriteString(txtfilesysname.Text.ToString()); textWriter.WriteEndElement();//End File System Name textWriter.WriteStartElement("Free_bytes"); textWriter.WriteString(txtfreebytes.Text.ToString()); textWriter.WriteEndElement();//End Free Bytes textWriter.WriteStartElement("Total_bytes"); textWriter.WriteString(txttotalbytes.Text.ToString()); textWriter.WriteEndElement(); //End Total Bytes textWriter.WriteEndElement(); //Logical_drives textWriter.WriteEndElement(); //Hardware textWriter.WriteStartElement("General_info"); textWriter.WriteStartElement("Operating_system"); textWriter.WriteStartElement("Name"); textWriter.WriteString(txtosname.Text.ToString()); textWriter.WriteEndElement();//End Name textWriter.WriteStartElement("Major_version"); textWriter.WriteString(txtmajorversion.Text.ToString()); textWriter.WriteEndElement();//End Major Version textWriter.WriteStartElement("Minor_version"); textWriter.WriteString(txtminorversion.Text.ToString()); textWriter.WriteEndElement();//End Minor Version textWriter.WriteStartElement("Build_number"); textWriter.WriteString(txtbuildno.Text.ToString()); textWriter.WriteEndElement();//End Build Number textWriter.WriteStartElement("Additional_information"); textWriter.WriteString(txtaddinfo.Text.ToString()); textWriter.WriteEndElement();//End Additional Information textWriter.WriteStartElement("User_name"); textWriter.WriteString(txtusername1.Text.ToString()); textWriter.WriteEndElement();//End User Name textWriter.WriteStartElement("Registered_to"); textWriter.WriteString(txtregto.Text.ToString()); textWriter.WriteEndElement();//End Registerd To textWriter.WriteStartElement("Registered_organization"); textWriter.WriteString(txtregorg.Text.ToString()); textWriter.WriteEndElement();//End Registered Organization textWriter.WriteStartElement("Registration_code"); textWriter.WriteString(txtregcode.Text.ToString()); textWriter.WriteEndElement();//End Registration Code textWriter.WriteStartElement("Locale"); textWriter.WriteString(txtlocal.Text.ToString()); textWriter.WriteEndElement();//End Localization textWriter.WriteStartElement("Product_key"); textWriter.WriteString(txtprokey.Text.ToString()); textWriter.WriteEndElement(); //End Product Key textWriter.WriteEndElement(); //Operating System textWriter.WriteEndElement(); //General Info textWriter.WriteStartElement("Network_adapters"); textWriter.WriteStartElement("Adapter"); textWriter.WriteStartElement("Network_protocols"); textWriter.WriteStartElement("Protocol"); textWriter.WriteStartElement("IP_Addresses"); textWriter.WriteStartElement("Address"); textWriter.WriteString(txtipaddress.Text.ToString()); textWriter.WriteEndElement(); //Address textWriter.WriteEndElement(); //IP_Address textWriter.WriteStartElement("Gateways"); textWriter.WriteString(txtgateway.Text.ToString()); textWriter.WriteEndElement();//Gateways textWriter.WriteString(txtprotocol.Text.ToString()); textWriter.WriteEndElement(); //Protocol textWriter.WriteEndElement(); //Network_protocols textWriter.WriteString(txtadaptername.Text.ToString()); textWriter.WriteEndElement();//Adapter textWriter.WriteStartElement("Link_speed"); textWriter.WriteString(txtlinkspeed.Text.ToString()); textWriter.WriteEndElement(); //Link_speed textWriter.WriteEndElement(); //Network_adapters textWriter.WriteEndElement(); //Network_adapters textWriter.WriteEndDocument(); textWriter.Close(); // End Section #endregion //string nodename="Computer Name"; //XDocument xmldoc = XDocument.Load("C:\\Asset\\Asset.xml"); //xmldoc.Element("Computers").Add(new XElement(nodename, txtcomputername.Text)); //xmldoc.Save("C:\\Asset\\Asset.xml"); Response.Redirect("../Asset/ViewAssetDetails.aspx?" + comname + ""); //Clear(); //lblerrmsg.Text = "Insert Succussfully"; } else { txtcomputername.Text = ""; lblerrmsg.Text = "Computer Name Already Exist"; } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
public void Asset_Software(XmlDocument xmldoc) { try { int count; string compname1, domain1; XmlNode compname = xmldoc.DocumentElement.SelectSingleNode("//Computer//Computer_name"); XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode domain = xmldoc.DocumentElement.SelectSingleNode("//Computer//Domain"); compname1 = compname.InnerText; domain1 = domain.InnerText; Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); if (count1 == 0) { objsoftwaremst.Assetid = varassetid; } else { objsoftwaremst.Assetid = Assetid; } softwares = Softwares_info(xmldoc); for (int k = 0; k < flagsoftcount; k++) { software_name = softwares[k, 0]; software_manufacturer = softwares[k, 1]; install_directory = softwares[k, 2]; software_version = softwares[k, 3]; software_version_major = softwares[k, 4]; software_version_minor = softwares[k, 5]; installed_on = softwares[k, 6]; software_registered_to = softwares[k, 7]; software_registration_code = softwares[k, 8]; software_registered_organization = softwares[k, 9]; software_product_key = softwares[k, 10]; bool check_date = CheckDate(installed_on); if (!check_date) { installed_on = null; } objsoftwaremst.Inventorydate = inventorydate2; objsoftwaremst.Computername = compname1; objsoftwaremst.Domainname = domain1; objsoftwaremst.Software_name = software_name.Replace("?", " ").Trim(); objsoftwaremst.Software_manufacturer = software_manufacturer; objsoftwaremst.Install_directory = install_directory; objsoftwaremst.Software_version = software_version; objsoftwaremst.Software_version_major = software_version_major; objsoftwaremst.Software_version_minor = software_version_minor; objsoftwaremst.Software_registered_to = software_registered_to; objsoftwaremst.Software_registration_code = software_registration_code; objsoftwaremst.Software_registered_organization = software_registered_organization; objsoftwaremst.Software_product_key = software_product_key; objsoftwaremst.Installed_on = installed_on; objsoftwaremst.Insert(); } // objnetwork.Insert(); } catch (Exception ex) { ex.ToString(); } }
public void Asset_Processor_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode Family = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Family"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Manufacturer"); XmlNode Max_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Max_speed"); XmlNode Model = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Model"); XmlNode processors = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Processor"); XmlNode Speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Speed"); XmlNode Stepping = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Processors//Stepping"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_Processor_mst objprocessor = new Asset_Processor_mst(); if (count1 == 0) { objprocessor.Assetid = varassetid; } else { objprocessor.Assetid = Assetid; } objprocessor.Family = Family.InnerText; objprocessor.Inventory_date = inventorydate2; objprocessor.Manufacturer = Manufacturer.InnerText; objprocessor.Max_speed = Max_speed.InnerText; objprocessor.Model = Model.InnerText; objprocessor.Processor_name = processors.InnerText; objprocessor.Speed = Speed.InnerText; objprocessor.Stepping = Stepping.InnerText; objprocessor.Insert(); } catch (Exception ex) { ex.ToString(); } }
public void Asset_Physical_Drive_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode physical_drives = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Capacity = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Capacity"); XmlNode Manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Manufacturer"); XmlNode physical_drives1 = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Product_version"); XmlNode Product_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Drive"); XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Physical_drives//Serial_number"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_PhysicalDrive_mst objphysical = new Asset_PhysicalDrive_mst(); if (count1 == 0) { objphysical.Assetid = varassetid; } else { objphysical.Assetid = Assetid; } objphysical.Capacity = Capacity.InnerText; objphysical.Drive_name = physical_drives.InnerText; objphysical.Inventory_date = inventorydate2; objphysical.Manufacturer = Manufacturer.InnerText; objphysical.Product_version = Product_version.InnerText; objphysical.Serial_number = Serial_number.InnerText; objphysical.Insert(); } catch (Exception ex) { ex.ToString(); } }
public void Asset_Network_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode adapter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter"); XmlNode protocol = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol"); XmlNode protocol_IP_Addresses_Address = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//IP_Addresses//Address//Address"); XmlNode protocol_Gateways = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Adapter//Network_protocols//Protocol//Gateways"); XmlNode Link_speed = xmldoc.DocumentElement.SelectSingleNode("//Computer//Network_adapters//Link_speed"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_Network_mst objnetwork = new Asset_Network_mst(); objnetwork.Adapter_name = adapter.InnerText; if (count1 == 0) { objnetwork.Assetid = varassetid; } else { objnetwork.Assetid = Assetid; } objnetwork.Gateway = protocol_Gateways.InnerText; objnetwork.Inventory_date = inventorydate2; //change done by meenakshi if (protocol_IP_Addresses_Address != null) { objnetwork.Ip_address = protocol_IP_Addresses_Address.InnerText; } if (Link_speed != null) { objnetwork.Link_speed = Link_speed.InnerText; } if (protocol != null) { objnetwork.Protocol_name = protocol.InnerText; } objnetwork.Insert(); } catch (Exception ex) { ex.ToString(); } }
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 void Asset_Logical_Drive_Info(XmlDocument xmldoc) { try { XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode Drive_letter = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_letter"); XmlNode Drive_type = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Drive_type"); XmlNode File_system_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//File_system_name"); XmlNode Free_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Free_bytes"); XmlNode Total_bytes = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Logical_drives//Total_bytes"); Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); Asset_LogicalDrive_mst objlogical = new Asset_LogicalDrive_mst(); if (count1 == 0) { objlogical.Assetid = varassetid; } else { objlogical.Assetid = Assetid; } objlogical.Drive_letter = Drive_letter.InnerText; objlogical.Drive_type = Drive_type.InnerText; objlogical.File_system_name = File_system_name.InnerText; objlogical.Free_bytes = Free_bytes.InnerText; objlogical.Inventory_date = inventorydate2; objlogical.Total_bytes = Total_bytes.InnerText; objlogical.Insert(); } catch (Exception ex) { ex.ToString(); } }
public void Asset_Software(XmlDocument xmldoc) { try { int count; string compname1, domain1; XmlNode compname = xmldoc.DocumentElement.SelectSingleNode("//Computer//Computer_name"); XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on"); inventorydate2 = inventory_date.InnerText; XmlNode domain = xmldoc.DocumentElement.SelectSingleNode("//Computer//Domain"); compname1 = compname.InnerText; domain1 = domain.InnerText; Asset_mst objAsset = new Asset_mst(); int varassetid = objAsset.Get_Current_Assetid(); if (count1 == 0) { objsoftwaremst.Assetid = varassetid; } else { objsoftwaremst.Assetid = Assetid; } softwares = Softwares_info(xmldoc); for (int k = 0; k < flagsoftcount; k++) { software_name = softwares[k, 0]; software_manufacturer = softwares[k, 1]; install_directory = softwares[k, 2]; software_version = softwares[k, 3]; software_version_major = softwares[k, 4]; software_version_minor = softwares[k, 5]; installed_on = softwares[k, 6]; software_registered_to = softwares[k, 7]; software_registration_code = softwares[k, 8]; software_registered_organization = softwares[k, 9]; software_product_key = softwares[k, 10]; bool check_date = CheckDate(installed_on); if (!check_date) { installed_on = null; } objsoftwaremst.Inventorydate = inventorydate2; objsoftwaremst.Computername = compname1; objsoftwaremst.Domainname = domain1; objsoftwaremst.Software_name = software_name.Replace("?"," ").Trim(); objsoftwaremst.Software_manufacturer = software_manufacturer; objsoftwaremst.Install_directory = install_directory; objsoftwaremst.Software_version = software_version; objsoftwaremst.Software_version_major = software_version_major; objsoftwaremst.Software_version_minor = software_version_minor; objsoftwaremst.Software_registered_to = software_registered_to; objsoftwaremst.Software_registration_code = software_registration_code; objsoftwaremst.Software_registered_organization = software_registered_organization; objsoftwaremst.Software_product_key = software_product_key; objsoftwaremst.Installed_on = installed_on; objsoftwaremst.Insert(); } // objnetwork.Insert(); } catch (Exception ex) { ex.ToString(); } }
protected void btnAdd_click(object sender, EventArgs e) { lblerrmsg.Text = ""; int varassetid, compcount; string comname, domain; comname = txtcomputername.Text.ToString(); domain = txtdomain.Text.ToString(); compcount = objasset.Get_ComputerName(comname, domain); if (compcount == 0) { //insert Deatils for Asset_mst objasset.Computername = txtcomputername.Text.ToString(); objasset.Domain = txtdomain.Text.ToString(); //objasset.Createdatetime = lbldate.Text.ToString(); objasset.Insert1(); //Details for ProductInfo_mst varassetid = objasset.Get_Current_Assetid(); objproinfo.Assetid = varassetid; objproinfo.Product_manufacturer = txtprocmanufacturer.Text.ToString(); objproinfo.Product_name = txtproductname.Text.ToString(); objproinfo.Serial_number = txtproductsno.Text.ToString(); objproinfo.Sku_no = txtskuno.Text.ToString(); objproinfo.Uuid = txtuuid.Text.ToString(); //Details for Prcessor_mst objprocessor.Assetid = varassetid; objprocessor.Family = txtfamily.Text.ToString(); objprocessor.Manufacturer = txtprocmanufacturer.Text.ToString(); objprocessor.Max_speed = txtmaxspeed.Text.ToString(); objprocessor.Model = txtmodel.Text.ToString(); objprocessor.Processor_name = txtprocessorname.Text.ToString(); objprocessor.Speed = txtspeed.Text.ToString(); objprocessor.Stepping = txtstepping.Text.ToString(); //Details for Memory_mst objmemory.Assetid = varassetid; objmemory.Page_file = txtpagefile.Text.ToString(); objmemory.Physical_mem = txtphysicalmemory.Text.ToString(); objmemory.Virtual_mem = txtvirtualmemory.Text.ToString(); //Details for Network_mst objnetwork.Adapter_name = txtadaptername.Text.ToString(); objnetwork.Assetid = varassetid; objnetwork.Gateway = txtgateway.Text.ToString(); objnetwork.Ip_address = txtipaddress.Text.ToString(); objnetwork.Link_speed = txtlinkspeed.Text.ToString(); objnetwork.Mac_address = txtmacaddress.Text.ToString(); objnetwork.Mtu = txtmtu.Text.ToString(); objnetwork.Protocol_name = txtprotocol.Text.ToString(); objnetwork.Subnet_mask = txtsubnet.Text.ToString(); objnetwork.Type = txttype.Text.ToString(); // Details of Operating System objoperating.Add_info = txtaddinfo.Text.ToString(); objoperating.Assetid = varassetid; objoperating.Build_no = txtbuildno.Text.ToString(); objoperating.Localization = txtlocal.Text.ToString(); objoperating.Major_version = txtmajorversion.Text.ToString(); objoperating.Minor_version = txtminorversion.Text.ToString(); objoperating.Os_name = txtosname.Text.ToString(); objoperating.Product_key = txtprokey.Text.ToString(); objoperating.Reg_code = txtregcode.Text.ToString(); objoperating.Reg_org = txtregorg.Text.ToString(); objoperating.Reg_to = txtregto.Text.ToString(); objoperating.User_name = txtusername1.Text.ToString(); //Details of Physical Drive objphydrive.Assetid = varassetid; objphydrive.Capacity = txtcapacity.Text.ToString(); objphydrive.Drive_name = txtdrivename.Text.ToString(); objphydrive.Manufacturer = txtmanufacturer.Text.ToString(); objphydrive.Product_id = txtproductid.Text.ToString(); objphydrive.Product_version = txtproductversion.Text.ToString(); objphydrive.Serial_number = txtserialno.Text.ToString(); //Details of Logical Drive objlogicdrive.Assetid = varassetid; objlogicdrive.Drive_letter = txtdriveletter.Text.ToString(); objlogicdrive.Drive_type = txtdrivetype.Text.ToString(); objlogicdrive.File_system_name = txtfilesysname.Text.ToString(); objlogicdrive.Free_bytes = txtfreebytes.Text.ToString(); objlogicdrive.Total_bytes = txttotalbytes.Text.ToString(); //Details of Inventory objinventory.Assetid = varassetid; objinventory.Computername = txtcomputername.Text.ToString(); //Insert functions objproinfo.Insert1(); objprocessor.Insert1(); objmemory.Insert1(); objnetwork.Insert1(); objoperating.Insert1(); objphydrive.Insert1(); objlogicdrive.Insert1(); objinventory.Insert1(); #region Create XML File // Section for Create new XML file //string compane; //comname = txtcomputername.Text.ToString(); XmlTextWriter textWriter = new XmlTextWriter("C:\\Asset\\Data\\" + comname + ".xml", null); // Opens the document textWriter.WriteStartDocument(); textWriter.WriteStartElement("Computer"); textWriter.WriteStartElement("Computer_name"); textWriter.WriteString(txtcomputername.Text.ToString()); textWriter.WriteEndElement();//End Computer_name textWriter.WriteStartElement("Domain"); textWriter.WriteString(txtdomain.Text.ToString()); textWriter.WriteEndElement();//End Domain textWriter.WriteStartElement("Created_on"); textWriter.WriteString(DateTime.Now.ToString()); textWriter.WriteEndElement();//End CreatedOn textWriter.WriteStartElement("Hardware"); textWriter.WriteStartElement("Product_details"); textWriter.WriteStartElement("Name"); textWriter.WriteString(txtproductname.Text.ToString()); textWriter.WriteEndElement();//End Name textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtproductmanufacture.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Serial_number"); textWriter.WriteString(txtproductsno.Text.ToString()); textWriter.WriteEndElement();//End Serial number textWriter.WriteStartElement("UUID"); textWriter.WriteString(txtuuid.Text.ToString()); textWriter.WriteEndElement();//End Uuid textWriter.WriteStartElement("SKU_number"); textWriter.WriteString(txtskuno.Text.ToString()); textWriter.WriteEndElement(); //End SKU Number textWriter.WriteEndElement(); //End Product Details textWriter.WriteStartElement("Processors"); textWriter.WriteStartElement("Family"); textWriter.WriteString(txtfamily.Text.ToString()); textWriter.WriteEndElement();//End Family textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtprocmanufacturer.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Max_speed"); textWriter.WriteString(txtmaxspeed.Text.ToString()); textWriter.WriteEndElement();//End Max Speed textWriter.WriteStartElement("Model"); textWriter.WriteString(txtmodel.Text.ToString()); textWriter.WriteEndElement();//End Model textWriter.WriteStartElement("Processor"); textWriter.WriteString(txtprocessorname.Text.ToString()); textWriter.WriteEndElement();//End Processor textWriter.WriteStartElement("Speed"); textWriter.WriteString(txtspeed.Text.ToString()); textWriter.WriteEndElement();//End Speed textWriter.WriteStartElement("Stepping"); textWriter.WriteString(txtstepping.Text.ToString()); textWriter.WriteEndElement(); //End Stepping textWriter.WriteEndElement(); //End Processors textWriter.WriteStartElement("Memory"); textWriter.WriteStartElement("Physical_memory"); textWriter.WriteString(txtphysicalmemory.Text.ToString()); textWriter.WriteEndElement();//End Physical Memory textWriter.WriteStartElement("Virtual_memory"); textWriter.WriteString(txtvirtualmemory.Text.ToString()); textWriter.WriteEndElement();//End Virtual Memory textWriter.WriteStartElement("Page_file_size"); textWriter.WriteString(txtpagefile.Text.ToString()); textWriter.WriteEndElement(); //End Page File Size textWriter.WriteEndElement(); //End Memory textWriter.WriteStartElement("Physical_drives"); textWriter.WriteStartElement("Drive"); textWriter.WriteString(txtdrivename.Text.ToString()); textWriter.WriteEndElement();//End Drive textWriter.WriteStartElement("Capacity"); textWriter.WriteString(txtcapacity.Text.ToString()); textWriter.WriteEndElement();//End Capacity textWriter.WriteStartElement("Manufacturer"); textWriter.WriteString(txtmanufacturer.Text.ToString()); textWriter.WriteEndElement();//End Manufacturer textWriter.WriteStartElement("Serial_number"); textWriter.WriteString(txtserialno.Text.ToString()); textWriter.WriteEndElement(); //End Serial Number textWriter.WriteEndElement(); //Physical Drive textWriter.WriteStartElement("Logical_drives"); textWriter.WriteStartElement("Drive_letter"); textWriter.WriteString(txtdriveletter.Text.ToString()); textWriter.WriteEndElement();//End Drive Letter textWriter.WriteStartElement("Drive_type"); textWriter.WriteString(txtdrivetype.Text.ToString()); textWriter.WriteEndElement();//End Drive Type textWriter.WriteStartElement("File_system_name"); textWriter.WriteString(txtfilesysname.Text.ToString()); textWriter.WriteEndElement();//End File System Name textWriter.WriteStartElement("Free_bytes"); textWriter.WriteString(txtfreebytes.Text.ToString()); textWriter.WriteEndElement();//End Free Bytes textWriter.WriteStartElement("Total_bytes"); textWriter.WriteString(txttotalbytes.Text.ToString()); textWriter.WriteEndElement(); //End Total Bytes textWriter.WriteEndElement(); //Logical_drives textWriter.WriteEndElement(); //Hardware textWriter.WriteStartElement("General_info"); textWriter.WriteStartElement("Operating_system"); textWriter.WriteStartElement("Name"); textWriter.WriteString(txtosname.Text.ToString()); textWriter.WriteEndElement();//End Name textWriter.WriteStartElement("Major_version"); textWriter.WriteString(txtmajorversion.Text.ToString()); textWriter.WriteEndElement();//End Major Version textWriter.WriteStartElement("Minor_version"); textWriter.WriteString(txtminorversion.Text.ToString()); textWriter.WriteEndElement();//End Minor Version textWriter.WriteStartElement("Build_number"); textWriter.WriteString(txtbuildno.Text.ToString()); textWriter.WriteEndElement();//End Build Number textWriter.WriteStartElement("Additional_information"); textWriter.WriteString(txtaddinfo.Text.ToString()); textWriter.WriteEndElement();//End Additional Information textWriter.WriteStartElement("User_name"); textWriter.WriteString(txtusername1.Text.ToString()); textWriter.WriteEndElement();//End User Name textWriter.WriteStartElement("Registered_to"); textWriter.WriteString(txtregto.Text.ToString()); textWriter.WriteEndElement();//End Registerd To textWriter.WriteStartElement("Registered_organization"); textWriter.WriteString(txtregorg.Text.ToString()); textWriter.WriteEndElement();//End Registered Organization textWriter.WriteStartElement("Registration_code"); textWriter.WriteString(txtregcode.Text.ToString()); textWriter.WriteEndElement();//End Registration Code textWriter.WriteStartElement("Locale"); textWriter.WriteString(txtlocal.Text.ToString()); textWriter.WriteEndElement();//End Localization textWriter.WriteStartElement("Product_key"); textWriter.WriteString(txtprokey.Text.ToString()); textWriter.WriteEndElement(); //End Product Key textWriter.WriteEndElement(); //Operating System textWriter.WriteEndElement(); //General Info textWriter.WriteStartElement("Network_adapters"); textWriter.WriteStartElement("Adapter"); textWriter.WriteStartElement("Network_protocols"); textWriter.WriteStartElement("Protocol"); textWriter.WriteStartElement("IP_Addresses"); textWriter.WriteStartElement("Address"); textWriter.WriteString(txtipaddress.Text.ToString()); textWriter.WriteEndElement(); //Address textWriter.WriteEndElement(); //IP_Address textWriter.WriteStartElement("Gateways"); textWriter.WriteString(txtgateway.Text.ToString()); textWriter.WriteEndElement();//Gateways textWriter.WriteString(txtprotocol.Text.ToString()); textWriter.WriteEndElement(); //Protocol textWriter.WriteEndElement(); //Network_protocols textWriter.WriteString(txtadaptername.Text.ToString()); textWriter.WriteEndElement();//Adapter textWriter.WriteStartElement("Link_speed"); textWriter.WriteString(txtlinkspeed.Text.ToString()); textWriter.WriteEndElement(); //Link_speed textWriter.WriteEndElement(); //Network_adapters textWriter.WriteEndElement(); //Network_adapters textWriter.WriteEndDocument(); textWriter.Close(); // End Section #endregion //string nodename="Computer Name"; //XDocument xmldoc = XDocument.Load("C:\\Asset\\Asset.xml"); //xmldoc.Element("Computers").Add(new XElement(nodename, txtcomputername.Text)); //xmldoc.Save("C:\\Asset\\Asset.xml"); Response.Redirect("../Asset/ViewAssetDetails.aspx?" + comname + ""); //Clear(); //lblerrmsg.Text = "Insert Succussfully"; } else { txtcomputername.Text = ""; lblerrmsg.Text = "Computer Name Already Exist"; } }