protected void DisplayComputerDetails(XmlDocument xmldoc)
    {
        //Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            XmlNode compname = xmldoc.DocumentElement.SelectSingleNode("//Computer//Computer_name");
            XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
            XmlNode domain = xmldoc.DocumentElement.SelectSingleNode("//Computer//Domain");

            //added by lalit
            //XmlNode TagNo = xmldoc.DocumentElement.SelectSingleNode("//Computer//TagNo");
            //XmlNode PONo = xmldoc.DocumentElement.SelectSingleNode("//Computer//PONo");
            //XmlNode AssetOwner = xmldoc.DocumentElement.SelectSingleNode("//Computer//AssetOwner");
            //XmlNode IsInStock = xmldoc.DocumentElement.SelectSingleNode("//Computer//IsInStock");
            //end

            ///add by Vishal 16-05-2012
            /////Get_AssetGet_By_id
            objasset = objasset.Get_By_id(Convert.ToInt32(lblAssetId.Text));
            string strTagNo = objasset.TagNo;
            string strPoNo = objasset.PONo;
            string strAssetOwner = objasset.AssetOwner;
            ///end///
            ///change done by meenakshi
            //string strCompanyCode = objasset.CompanyCode;
            //string strPurchaseDate = objasset.PurchaseDate;
            //string strAssetCategory = objasset.AssetCategory;
            //string strRemarks = objasset.Remarks;
            ///end///
            lblcomputername.Text = compname.InnerText;
            ///Comment by Vishal 17-05-2012
            // lblassetname.Text = compname.InnerText + "                            ";
            lblassetname.Text = compname.InnerText + "";
            lblassetid1.Text = lblAssetId.Text;
            lblcreateddate.Text = inventory_date.InnerText;
            ///Comment by Vishal 17-05-2012
            //lbllastinventory.Text = inventory_date.InnerText + "                                      ";
            lbllastinventory.Text = inventory_date.InnerText + "";
            lbldomain.Text = domain.InnerText;
            //if (TagNo != null)
            //{
            //    LblTageno.Text = TagNo.InnerText;
            //}
            //if (PONo != null)
            //{
            //    LblPONo.Text = PONo.InnerText;
            //}
            //if (AssetOwner != null)
            //{
            //    LblAssetOwner.Text = AssetOwner.InnerText;
            //}

            //else if (AssetOwner == null)
            //{
            //    objusertoasset = objusertoasset.Get_By_id(objasset.Assetid);
            //    if(objusertoasset!=null)
            //    {
            //       LblAssetOwner.Text = objusertoasset.AssetCompanyName;
            //    }
            //}
            //if (IsInStock != null)
            //{
            //    lblStock.Text = IsInStock.InnerText;
            //}
            ///add by Vishal

            if (strTagNo != "")
            {
                LblTageno.Text = strTagNo;
            }
            if (strPoNo != "")
            {
                LblPONo.Text = strPoNo;
            }
            if (strAssetOwner != "")
            {
                LblAssetOwner.Text = strAssetOwner;
            }

            else if (strAssetOwner == "")
            {
                objusertoasset = objusertoasset.Get_By_id(objasset.Assetid);
                if (objusertoasset != null)
                {
                    LblAssetOwner.Text = objusertoasset.AssetCompanyName;
                }
            }
            ///
            //if (IsInStock != null)
            //{
            //    lblStock.Text = IsInStock.InnerText;
            //}
            objasset = objasset.Get_Asset_By_Computername(lblcomputername.Text);
            if (objusertoasset != null)
            {
                LblAssetLocation.Text = objusertoasset.AssetLocation;
            }
            //add by meenakshi 22 june
            /////////////////////////////////////
            //if (strCompanyCode != "")
            //{
            //    LblCompanyCode.Text = strCompanyCode;
            //}
            //if (strPurchaseDate != "")
            //{
            //    LblPurchaseDate.Text = strCompanyCode;
            //}
            //if (strAssetCategory != "")
            //{
            //    LblAssetCategory.Text = strCompanyCode;
            //}
            //if (strRemarks != "")
            //{
            //    LblRemarks.Text = strCompanyCode;
            //}//////////////////////////////

            //end

        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }
 public int Update_UserToAssetMapping_By_id(UserToAssetMapping objUserToAssetMapping)
 {
     return (int)ExecuteNonQuery(Sp_UserToAssetMapping_Update, new object[] { objUserToAssetMapping.Userid, objUserToAssetMapping.Assetid });
 }
 public object GenerateUserToAssetMapping_mstObject(ref IDataReader returnData)
 {
     UserToAssetMapping obj = new UserToAssetMapping();
     while (returnData.Read())
     {
         obj.Assetid = (int)returnData["assetid"];
         obj.Userid = (int)returnData["userid"];
         if (returnData["assetlocation"] != DBNull.Value)
         {
             obj.AssetLocation = (string)returnData["assetlocation"];
         }
         if (returnData["companyname"] != DBNull.Value)
         {
             obj.AssetCompanyName = (string)returnData["companyname"];
         }
     }
     returnData.Close();
     returnData.Dispose();
     return obj;
 }
    public CollectionBase GenerateUserToAssetMapping_mstCollection(ref IDataReader returnData)
    {
        BLLCollection<UserToAssetMapping> col = new BLLCollection<UserToAssetMapping>();
        while (returnData.Read())
        {
            UserToAssetMapping obj = new UserToAssetMapping();

            obj.Assetid = (int)returnData["assetid"];
            obj.Userid = (int)returnData["userid"];
            if (returnData["assetlocation"] != DBNull.Value)
            {
                obj.AssetLocation = (string)returnData["assetlocation"];
            }
            if (returnData["companyname"] != DBNull.Value)
            {
                obj.AssetCompanyName = (string)returnData["companyname"];
            }
            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }
    public object GenerateUserToAssetMapping_mstObject(ref IDataReader returnData)
    {
        UserToAssetMapping obj = new UserToAssetMapping();
        while (returnData.Read())
        {
            obj.Assetid = (int)returnData["assetid"];
            obj.Userid = (int)returnData["userid"];

        }
        returnData.Close();
        returnData.Dispose();
        return obj;
    }
    public CollectionBase GenerateUserToAssetMapping_mstCollection(ref IDataReader returnData)
    {
        BLLCollection<UserToAssetMapping> col = new BLLCollection<UserToAssetMapping>();
        while (returnData.Read())
        {
            UserToAssetMapping obj = new UserToAssetMapping();

            obj.Assetid = (int)returnData["assetid"];
            obj.Userid = (int)returnData["userid"];
            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }