public void BindGrid()
{
DataTable dtTable = new DataTable();
dtTable = CreateDataTable();
Asset_mst objAsset = new Asset_mst();
BLLCollection<Asset_mst> colAsset = new BLLCollection<Asset_mst>();
colAsset = objAsset.Get_All();
foreach (Asset_mst obj in colAsset)
{
DataRow row;
row = dtTable.NewRow();
row["computername"] = Convert.ToString(obj.Computername);
assetid = Convert.ToInt16(obj.Assetid);
Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
objos = objos.Get_By_Assetid(assetid);
row["osname"] = Convert.ToString(objos.Os_name);
row["username"] = Convert.ToString(objos.User_name);
row["productkey"] = Convert.ToString(objos.Product_key);
Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
objproduct = objproduct.Get_By_Assetid(assetid);
row["productname"] = Convert.ToString(objproduct.Product_name);
row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
row["serialno"] = Convert.ToString(objproduct.Serial_number);
Asset_Processor_mst objprocessor = new Asset_Processor_mst();
objprocessor = objprocessor.Get_By_Assetid(assetid);
row["processorname"] = Convert.ToString(objprocessor.Processor_name);
Asset_Memory_mst objmemory = new Asset_Memory_mst();
objmemory = objmemory.Get_By_Assetid(assetid);
row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
dtTable.Rows.Add(row);
}
dtgrid.DataSource = dtTable;
dtgrid.DataBind();
}
public void Asset_Product_Info(XmlDocument xmldoc)
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode product_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Name");
XmlNode product_manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Manufacturer");
XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Serial_number");
XmlNode UUID = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//UUID");
XmlNode SKU_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//SKU_number");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_ProductInfo_mst objprodinfo = new Asset_ProductInfo_mst();
if (count1 == 0)
{
objprodinfo.Assetid = varassetid;
}
else
{
objprodinfo.Assetid = Assetid;
}
objprodinfo.Inventory_date = inventorydate2;
objprodinfo.Product_manufacturer = product_manufacturer.InnerText;
objprodinfo.Product_name = product_name.InnerText;
objprodinfo.Serial_number = Serial_number.InnerText;
objprodinfo.Sku_no = SKU_number.InnerText;
objprodinfo.Uuid = UUID.InnerText;
objprodinfo.Insert();
}
public void BindGrid()
{
DataTable dtTable = new DataTable();
dtTable = CreateDataTable();
Asset_mst objAsset = new Asset_mst();
BLLCollection <Asset_mst> colAsset = new BLLCollection <Asset_mst>();
colAsset = objAsset.Get_All();
foreach (Asset_mst obj in colAsset)
{
DataRow row;
row = dtTable.NewRow();
row["computername"] = Convert.ToString(obj.Computername);
assetid = Convert.ToInt32(obj.Assetid);
Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
objos = objos.Get_By_Assetid(assetid);
row["osname"] = Convert.ToString(objos.Os_name);
row["username"] = Convert.ToString(objos.User_name);
row["productkey"] = Convert.ToString(objos.Product_key);
Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
objproduct = objproduct.Get_By_Assetid(assetid);
row["productname"] = Convert.ToString(objproduct.Product_name);
row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
row["serialno"] = Convert.ToString(objproduct.Serial_number);
Asset_Processor_mst objprocessor = new Asset_Processor_mst();
objprocessor = objprocessor.Get_By_Assetid(assetid);
row["processorname"] = Convert.ToString(objprocessor.Processor_name);
Asset_Memory_mst objmemory = new Asset_Memory_mst();
objmemory = objmemory.Get_By_Assetid(assetid);
row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
dtTable.Rows.Add(row);
}
dtgrid.DataSource = dtTable;
dtgrid.DataBind();
}
public void Asset_Product_Info(XmlDocument xmldoc)
{
try
{
XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
inventorydate2 = inventory_date.InnerText;
XmlNode product_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Name");
XmlNode product_manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Manufacturer");
XmlNode Serial_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//Serial_number");
XmlNode UUID = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//UUID");
XmlNode SKU_number = xmldoc.DocumentElement.SelectSingleNode("//Computer//Hardware//Product_details//SKU_number");
Asset_mst objAsset = new Asset_mst();
int varassetid = objAsset.Get_Current_Assetid();
Asset_ProductInfo_mst objprodinfo = new Asset_ProductInfo_mst();
if (count1 == 0)
{
objprodinfo.Assetid = varassetid;
}
else
{
objprodinfo.Assetid = Assetid;
}
objprodinfo.Inventory_date = inventorydate2;
objprodinfo.Product_manufacturer = product_manufacturer.InnerText;
objprodinfo.Product_name = product_name.InnerText;
objprodinfo.Serial_number = Serial_number.InnerText;
objprodinfo.Sku_no = SKU_number.InnerText;
objprodinfo.Uuid = UUID.InnerText;
objprodinfo.Insert();
}
catch (Exception ex)
{
ex.ToString();
}
}
public int Update_Asset_ProductInfo_mst_By_id(Asset_ProductInfo_mst objAssetProductInfo)
{
return (int)ExecuteNonQuery(Sp_Asset_ProductInfo_Update, new object[] { objAssetProductInfo.Assetproductinfoid, objAssetProductInfo.Assetid, objAssetProductInfo.Inventory_date, objAssetProductInfo.Product_name, objAssetProductInfo.Product_manufacturer, objAssetProductInfo.Serial_number, objAssetProductInfo.Uuid, objAssetProductInfo.Sku_no });
}
public object GenerateAssetProductInfo_mst_ByAssetidObject(ref IDataReader returnData)
{
Asset_ProductInfo_mst obj = new Asset_ProductInfo_mst();
while (returnData.Read())
{
obj.Assetid = (int)returnData["assetid"];
obj.Assetproductinfoid = (int)returnData["assetproductinfoid"];
//DateTime inventorydatetime = new DateTime();
//inventorydatetime = (DateTime)returnData["inventorydate"];
//obj.Inventory_date = inventorydatetime.ToString();
obj.Product_manufacturer = (string)returnData["product_manufacturer"];
obj.Product_name = (string)returnData["product_name"];
obj.Serial_number = (string)returnData["serial_number"];
obj.Sku_no = (string)returnData["sku_no"];
obj.Uuid = (string)returnData["uuid"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateAssetProductInfo_mstCollection(ref IDataReader returnData)
{
BLLCollection<Asset_ProductInfo_mst> col = new BLLCollection<Asset_ProductInfo_mst>();
while (returnData.Read())
{
Asset_ProductInfo_mst obj = new Asset_ProductInfo_mst();
obj.Assetid = (int)returnData["assetid"];
obj.Assetproductinfoid = (int)returnData["assetproductinfoid"];
DateTime inventorydatetime = new DateTime();
inventorydatetime = (DateTime)returnData["inventorydate"];
obj.Inventory_date = inventorydatetime.ToString();
obj.Product_manufacturer = (string)returnData["product_manufacturer"];
obj.Product_name = (string)returnData["product_name"];
obj.Serial_number = (string)returnData["serial_number"];
obj.Sku_no = (string)returnData["sku_no"];
obj.Uuid = (string)returnData["uuid"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
