public string Get() { string AuthorizedName; SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_publisher_assertions_get"); sp.Parameters.Add("@PUID", SqlDbType.NVarChar, UDDI.Constants.Lengths.UserID); sp.Parameters.Add("@authorizedName", SqlDbType.NVarChar, UDDI.Constants.Lengths.AuthorizedName, ParameterDirection.Output); sp.Parameters.SetString("@PUID", Context.User.ID); SqlDataReaderAccessor reader = sp.ExecuteReader(); try { while (reader.Read()) { Add( reader.GetGuidString("fromKey"), reader.GetGuidString("toKey"), reader.GetGuidString("keyName"), reader.GetGuidString("keyValue"), reader.GetKeyFromGuid("tModelKey")); } } finally { reader.Close(); } AuthorizedName = sp.Parameters.GetString("@authorizedName"); return(AuthorizedName); }
public void Get(string fromKey, string toKey) { SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor(); sp.ProcedureName = "net_businessEntity_assertions_get"; sp.Parameters.Add("@fromKey", SqlDbType.UniqueIdentifier); sp.Parameters.Add("@toKey", SqlDbType.UniqueIdentifier); sp.Parameters.Add("@completionStatus", SqlDbType.Int); sp.Parameters.SetGuidFromString("@fromKey", fromKey); sp.Parameters.SetGuidFromString("@toKey", toKey); sp.Parameters.SetInt("@completionStatus", (int)CompletionStatusType.Complete); SqlDataReaderAccessor reader = sp.ExecuteReader(); try { while (reader.Read()) { KeyedReferences.Add( reader.GetString("keyName"), reader.GetString("keyValue"), reader.GetKeyFromGuid("tModelKey")); } } finally { reader.Close(); } }
public void Read(SqlDataReaderAccessor reader) { while (reader.Read()) { Add(reader.GetString("keyName"), reader.GetString("keyValue"), reader.GetKeyFromGuid("tModelKey")); } }
public ArrayList Read(SqlDataReaderAccessor reader) { ArrayList addressIDs = new ArrayList(); if (1 == Context.ApiVersionMajor) { while (reader.Read()) { addressIDs.Add(reader.GetLong("addressID")); Add(reader.GetString("sortCode"), reader.GetString("useType")); } } else { while (reader.Read()) { addressIDs.Add(reader.GetLong("addressID")); Add(reader.GetString("sortCode"), reader.GetString("useType"), reader.GetKeyFromGuid("tModelKey")); } } return(addressIDs); }
public void Get(string parentKey, EntityType parentType, KeyedReferenceType keyedReferenceType) { Debug.Enter(); SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor(); switch (parentType) { case EntityType.BusinessEntity: if (KeyedReferenceType.CategoryBag == keyedReferenceType) { sp.ProcedureName = "net_businessEntity_categoryBag_get"; } else { sp.ProcedureName = "net_businessEntity_identifierBag_get"; } sp.Parameters.Add("@businessKey", SqlDbType.UniqueIdentifier); sp.Parameters.SetGuidFromString("@businessKey", parentKey); break; case EntityType.BusinessService: Debug.Assert( KeyedReferenceType.CategoryBag == keyedReferenceType, "Unexpected keyed reference type '" + keyedReferenceType.ToString() + "' for parent entity type '" + parentType.ToString() + "'"); sp.ProcedureName = "net_businessService_categoryBag_get"; sp.Parameters.Add("@serviceKey", SqlDbType.UniqueIdentifier); sp.Parameters.SetGuidFromString("@serviceKey", parentKey); break; case EntityType.TModel: if (KeyedReferenceType.CategoryBag == keyedReferenceType) { sp.ProcedureName = "net_tModel_categoryBag_get"; } else { sp.ProcedureName = "net_tModel_identifierBag_get"; } sp.Parameters.Add("@tModelKey", SqlDbType.UniqueIdentifier); sp.Parameters.SetGuidFromKey("@tModelKey", parentKey); break; default: throw new UDDIException(ErrorType.E_fatalError, "UDDI_ERROR_UNEXPECTED_PARENT_ENTITY_TYPE", parentType.ToString()); } SqlDataReaderAccessor reader = sp.ExecuteReader(); try { Read(reader); #if never while (reader.Read()) { Add( reader.GetString("keyName"), reader.GetString("keyValue"), reader.GetKeyFromGuid("tModelKey")); } #endif } finally { reader.Close(); } Debug.Leave(); }
public void Get(long contactID) { ArrayList addressIDs = new ArrayList(); SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_contact_addresses_get"); sp.Parameters.Add("@contactID", SqlDbType.BigInt); sp.Parameters.SetLong("@contactID", contactID); SqlDataReaderAccessor reader = sp.ExecuteReader(); try { addressIDs = Read(reader); } finally { reader.Close(); } Populate(addressIDs); #if never ArrayList addressIDs = new ArrayList(); SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor(); sp.ProcedureName = "net_contact_addresses_get"; sp.Parameters.Add("@contactID", SqlDbType.BigInt); sp.Parameters.SetLong("@contactID", contactID); SqlDataReaderAccessor reader = sp.ExecuteReader(); try { if (1 == Context.ApiVersionMajor) { while (reader.Read()) { addressIDs.Add(reader.GetLong("addressID")); Add(reader.GetString("sortCode"), reader.GetString("useType")); } } else { while (reader.Read()) { addressIDs.Add(reader.GetLong("addressID")); Add(reader.GetString("sortCode"), reader.GetString("useType"), reader.GetKeyFromGuid("tModelKey")); } } } finally { reader.Close(); } // // Retrieve the addressLines for this address // int index = 0; foreach (Address address in this) { address.Get((long)addressIDs[index]); index++; } #endif }
public void Get(CompletionStatusType completionStatus) { SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_publisher_assertionStatus_get"); sp.Parameters.Add("@PUID", SqlDbType.NVarChar, UDDI.Constants.Lengths.UserID); sp.Parameters.SetString("@PUID", Context.User.ID); if (CompletionStatusType.Uninitialized != completionStatus) { // // If the completion status was not specified get all // of the assertions by not specifying a completionStatus value // in the stored procedure. // sp.Parameters.Add("@completionStatus", SqlDbType.Int); sp.Parameters.SetInt("@completionStatus", (int)completionStatus); } SqlDataReaderAccessor reader = sp.ExecuteReader(); try { while (reader.Read()) { KeyedReference keyedReference = new KeyedReference( reader.GetString("keyName"), reader.GetString("keyValue"), reader.GetKeyFromGuid("tModelKey")); CompletionStatusType status = (CompletionStatusType)reader.GetInt("flag"); string fromKey = reader.GetGuidString("fromKey"); string toKey = reader.GetGuidString("toKey"); int ownerFlag = reader.GetInt("ownerFlag"); KeysOwned keysOwned = new KeysOwned(); if (0x02 == (ownerFlag & 0x02)) { keysOwned.FromKey = fromKey; } if (0x01 == (ownerFlag & 0x01)) { keysOwned.ToKey = toKey; } this.Add( new AssertionStatusItem( status, fromKey, toKey, keyedReference, keysOwned)); } } finally { reader.Close(); } }