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