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