public static int GetTaxonomyID(string tModelKey)
{
int taxonomyID;
Debug.Enter();
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "UI_getTaxonomies";
sp.Parameters.Add("@tModelKey", SqlDbType.UniqueIdentifier);
sp.Parameters.SetGuidFromKey("@tModelKey", tModelKey);
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
if (reader.Read())
{
taxonomyID = reader.GetInt("taxonomyID");
}
else
{
taxonomyID = -1;
}
}
finally
{
reader.Close();
}
Debug.Leave();
return(taxonomyID);
}
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 static string BusinessName(string businessKey)
{
string name = null;
Debug.Enter();
SqlCommand cmd = new SqlCommand("net_businessEntity_names_get", ConnectionManager.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = ConnectionManager.GetTransaction();
cmd.Parameters.Add(new SqlParameter("@businessKey", SqlDbType.UniqueIdentifier)).Direction = ParameterDirection.Input;
SqlParameterAccessor paramacc = new SqlParameterAccessor(cmd.Parameters);
paramacc.SetGuidFromString("@businessKey", businessKey);
SqlDataReaderAccessor reader = new SqlDataReaderAccessor(cmd.ExecuteReader());
try
{
if (reader.Read())
{
name = reader.GetString("name");
}
}
finally
{
reader.Close();
}
Debug.Leave();
return(name);
}
public HighWaterMarkDetail Get()
{
HighWaterMarkDetail detail = new HighWaterMarkDetail();
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_highWaterMarks_get";
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
while (reader.Read())
{
detail.HighWaterMarks.Add(
reader.GetString("operatorKey"),
reader.GetLong("USN"));
}
}
finally
{
reader.Close();
}
return(detail);
}
public void Get(long contactID)
{
//
// Create a command object to invoke the stored procedure net_get_contacts
//
SqlStoredProcedureAccessor cmd = new SqlStoredProcedureAccessor("net_contact_emails_get");
//
// Add parameters and set values
//
cmd.Parameters.Add("@contactID", SqlDbType.BigInt, ParameterDirection.Input);
cmd.Parameters.SetLong("@contactID", contactID);
//
// Run the stored procedure
//
SqlDataReaderAccessor reader = cmd.ExecuteReader();
try
{
#if never
while (reader.Read())
{
//
// Construct a new Email from the data in this row
//
this.Add(dracc.GetString(EmailIndex), dracc.GetString(UseTypeIndex));
}
#endif
}
finally
{
reader.Close();
}
}
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 Get()
{
Debug.Enter();
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_operator_get";
sp.Parameters.Add("@operatorKey", SqlDbType.UniqueIdentifier);
sp.Parameters.SetGuidFromString("@operatorKey", OperatorNodeID);
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
if (reader.Read())
{
OperatorStatus = (OperatorStatus)reader.GetShort("operatorStatusID");
Name = reader.GetString("name");
SoapReplicationURL = reader.GetString("soapReplicationURL");
CertIssuerName = reader.GetString("certIssuer");
CertSubjectName = reader.GetString("certSubject");
Certificate = reader.GetBinary("certificate");
}
}
finally
{
reader.Close();
}
Debug.Leave();
}
public void GetForCurrentPublisher()
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_publisher_businessInfos_get");
sp.Parameters.Add("@PUID", SqlDbType.NVarChar, UDDI.Constants.Lengths.UserID);
sp.Parameters.SetString("@PUID", Context.User.ID);
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
while (reader.Read())
{
Add(reader.GetGuidString("businessKey"));
}
}
finally
{
reader.Close();
}
foreach (BusinessInfo businessInfo in this)
{
businessInfo.Get(true);
}
}
public void Get(long addressID)
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_address_addressLines_get";
sp.Parameters.Add("@addressID", SqlDbType.BigInt);
sp.Parameters.SetLong("@addressID", addressID);
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
while (reader.Read())
{
Add(
reader.GetString("addressLine"),
reader.GetString("keyName"),
reader.GetString("keyValue"));
}
}
finally
{
reader.Close();
}
}
static ArrayList GetBusinessEntities()
{
ArrayList businessKeyList = new ArrayList();
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_find_businessKeysWithDiscoveryURLs";
SqlDataReaderAccessor reader = sp.ExecuteReader();
ArrayList businessEntities = new ArrayList();
try
{
while (reader.Read())
{
BusinessEntity businessEntity = new BusinessEntity(reader.GetGuidString(0));
businessEntities.Add(businessEntity);
}
}
finally
{
reader.Close();
}
return(businessEntities);
}
public void Read(SqlDataReaderAccessor reader)
{
while (reader.Read())
{
Add(reader.GetString("isoLangCode"),
reader.GetString("description"));
}
}
public void Read(SqlDataReaderAccessor reader)
{
while (reader.Read())
{
Add(reader.GetString("keyName"),
reader.GetString("keyValue"),
reader.GetKeyFromGuid("tModelKey"));
}
}
public void Read(SqlDataReaderAccessor reader)
{
//
// Get the keys of the services for this business ID
//
while (reader.Read())
{
Add(reader.GetGuidString(0));
}
}
public void Read(SqlDataReaderAccessor reader)
{
const int UseTypeIndex = 0;
const int EmailIndex = 1;
while (reader.Read())
{
//
// Construct a new Email from the data in this row
//
this.Add(reader.GetString(EmailIndex), reader.GetString(UseTypeIndex));
}
}
public void Get()
{
Debug.Enter();
//
// Retrieve the taxonomy
//
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_taxonomy_get");
sp.Parameters.Add("@tModelKey", SqlDbType.UniqueIdentifier);
sp.Parameters.Add("@flag", SqlDbType.Int, ParameterDirection.InputOutput);
sp.Parameters.SetGuidFromKey("@tModelKey", tModelKey);
sp.Parameters.SetNull("@flag");
sp.ExecuteScalar();
//
// Set the flag value
//
CategorizationSchemeFlag = sp.Parameters.GetInt("@flag");
//
// Retrieve the taxonomy values
//
CategoryValues.Clear();
SqlStoredProcedureAccessor sp2 = new SqlStoredProcedureAccessor("net_taxonomyValues_get");
sp2.Parameters.Add("@tModelKey", SqlDbType.UniqueIdentifier);
sp2.Parameters.SetGuidFromKey("@tModelKey", tModelKey);
SqlDataReaderAccessor reader = sp2.ExecuteReader();
try
{
while (reader.Read())
{
CategoryValues.Add(reader.GetString("keyName"), reader.GetString("keyValue"), reader.GetString("parentKeyValue"), ((reader.GetInt("valid") == 1) ? true : false));
}
}
finally
{
reader.Close();
}
Debug.Leave();
}
public void Get(RelationshipQualifier[] relations)
{
if (null != KeyValue)
{
//
// The request can ask for Root stuff with just the TModelKey
//
SqlDataReader rdr = GetValues(RelationType.Current);
try
{
SqlDataReaderAccessor dracc = new SqlDataReaderAccessor(rdr);
if (rdr.Read())
{
this.KeyName = dracc.GetString(KeyNameIndex);
this.IsValid = (1 == dracc.GetInt(IsValidIndex));
}
else
{
throw new UDDIException(UDDI.ErrorType.E_invalidValue, "UDDI_ERROR_INVALIDVALUE_VALUENOTFOUND");
}
}
finally
{
rdr.Close();
}
}
if (null != relations)
{
foreach (RelationshipQualifier rq in relations)
{
switch (rq)
{
case RelationshipQualifier.root:
GetRoots();
break;
case RelationshipQualifier.child:
GetChildren();
break;
case RelationshipQualifier.parent:
GetParents();
break;
}
}
}
}
public void Get()
{
Debug.Enter();
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "UI_getPublisher";
sp.Parameters.Add("@PUID", SqlDbType.NVarChar, UDDI.Constants.Lengths.UserID);
sp.Parameters.SetString("@PUID", Puid);
SqlDataReaderAccessor reader = sp.ExecuteReader();
Exists = false;
try
{
if (reader.Read())
{
int flag;
IsoLangCode = reader.GetString(1);
Name = reader.GetString(2);
Email = reader.GetString(3);
Phone = reader.GetString(4);
CompanyName = reader.GetString(5);
AltPhone = reader.GetString(6);
AddressLine1 = reader.GetString(7);
AddressLine2 = reader.GetString(8);
City = reader.GetString(9);
StateProvince = reader.GetString(10);
PostalCode = reader.GetString(11);
Country = reader.GetString(12);
flag = reader.GetInt(13);
SecurityToken = reader.GetGuidString(14);
TrackPassport = (0x00 == (flag & 0x02));
Validated = (0x01 == (flag & 0x01));
Exists = true;
}
}
finally
{
reader.Close();
}
Debug.Leave();
}
public static SqlDataReaderAccessor RetrieveResults(int maxRows)
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_find_changeRecords_commit";
sp.Parameters.Add("@contextID", SqlDbType.UniqueIdentifier);
sp.Parameters.Add("@responseLimitCount", SqlDbType.Int);
sp.Parameters.SetGuid("@contextID", Context.ContextID);
sp.Parameters.SetInt("@responseLimitCount", maxRows);
SqlDataReaderAccessor reader = sp.ExecuteReader();
return(reader);
}
public void Read(SqlDataReaderAccessor reader)
{
const int UseTypeIndex = 0;
const int PhoneIndex = 1;
//
// Phones for this contact will be contained in the resultset
//
while (reader.Read())
{
//
// construct a new contact from the data in this row, fully populate contact and add to collection
//
this.Add(reader.GetString(PhoneIndex), reader.GetString(UseTypeIndex));
}
}
public void Read(SqlDataReaderAccessor reader)
{
if (1 == Context.ApiVersionMajor)
{
if (reader.Read())
{
Add(null, reader.GetString("name"));
}
}
else
{
while (reader.Read())
{
Add(reader.GetString("isoLangCode"), reader.GetString("name"));
}
}
}
public void Get(bool activeOperatorsOnly)
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_operators_get";
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
this.Clear();
while (reader.Read())
{
OperatorStatus operatorStatus = (OperatorStatus)reader.GetShort("operatorStatusID");
string name = reader.GetString("name");
if (!activeOperatorsOnly ||
OperatorStatus.New == operatorStatus ||
OperatorStatus.Normal == operatorStatus)
{
this.Add(
reader.GetGuidString("operatorKey"),
operatorStatus,
name,
reader.GetString("soapReplicationURL"));
}
else
{
Debug.Write(
SeverityType.Info,
CategoryType.Replication,
String.Format(
"Removing operator '{0}' with status '{1}' from list of replication operators",
name,
operatorStatus.ToString()));
}
}
}
finally
{
reader.Close();
}
}
public void Read(SqlDataReaderAccessor reader)
{
const int UseTypeIndex = 0;
const int UrlIndex = 1;
//
// The discoveryUrls will be contained in the result set
//
while (reader.Read())
{
string useType = reader.GetString(UseTypeIndex);
if (null == useType)
{
useType = "";
}
Add(reader.GetString(UrlIndex), useType);
}
}
/// ****************************************************************
/// public Get
/// ----------------------------------------------------------------
/// <summary>
/// Populates the collection with all binding templates related to
/// the specified service.
/// </summary>
/// ----------------------------------------------------------------
/// <param name="serviceKey">
/// Key of the parent service. A Guid formatted as a string.
/// </param>
/// ----------------------------------------------------------------
/// <returns>
///
/// </returns>
/// ----------------------------------------------------------------
/// <remarks>
///
/// </remarks>
/// ****************************************************************
///
public void Get(string serviceKey)
{
//
// Get all the bindings associated with the specified service
//
SqlStoredProcedureAccessor cmd = new SqlStoredProcedureAccessor("net_businessService_bindingTemplates_get");
cmd.Parameters.Add("@serviceKey", SqlDbType.UniqueIdentifier, ParameterDirection.Input);
cmd.Parameters.SetGuidFromString("@serviceKey", serviceKey);
SqlDataReaderAccessor reader = cmd.ExecuteReader();
try
{
Read(reader);
#if never
//
// Get the keys of the services for this business ID
//
while (rdr.Read())
{
Add(rdr.GetGuid(0).ToString());
}
#endif
}
finally
{
reader.Close();
}
Populate();
#if never
//
// Populate each binding
//
foreach (BindingTemplate bt in this)
{
bt.Get();
}
#endif
}
public ArrayList Read(SqlDataReaderAccessor reader)
{
const int ContactIdIndex = 0;
const int UseTypeIndex = 1;
const int PersonNameIndex = 2;
ArrayList contactIds = new ArrayList();
//
// The contacts will be contained in the result set
//
while (reader.Read())
{
//
// construct a new contact from the data in this row, fully populate contact and add to collection
//
contactIds.Add(reader.GetInt(ContactIdIndex));
Add(new Contact(reader.GetString(PersonNameIndex), reader.GetString(UseTypeIndex)));
}
return(contactIds);
}
public void GetParents()
{
Parents = new CategoryValueCollection();
SqlDataReader rdr = GetValues(RelationType.Parent);
try
{
SqlDataReaderAccessor dracc = new SqlDataReaderAccessor(rdr);
while (rdr.Read())
{
Parents.Add(dracc.GetString(KeyNameIndex),
dracc.GetString(KeyValueIndex),
dracc.GetString(ParentKeyValueIndex),
(1 == dracc.GetInt(IsValidIndex)));
}
}
finally
{
rdr.Close();
}
}
public void Get(long contactID)
{
//
// Create a command object to invoke the stored procedure net_get_contacts
//
SqlStoredProcedureAccessor cmd = new SqlStoredProcedureAccessor("net_contact_phones_get");
//
// Add parameters and set values
//
cmd.Parameters.Add("@contactID", SqlDbType.BigInt, ParameterDirection.Input);
cmd.Parameters.SetLong("@contactID", contactID);
//
// Run the stored procedure
//
SqlDataReaderAccessor reader = cmd.ExecuteReader();
try
{
Read(reader);
#if never
//
// Phones for this contact will be contained in the resultset
//
while (rdr.Read())
{
//
// construct a new contact from the data in this row, fully populate contact and add to collection
//
this.Add(dracc.GetString(PhoneIndex), dracc.GetString(UseTypeIndex));
}
#endif
}
finally
{
reader.Close();
}
}
public void Get(long addressID)
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
sp.ProcedureName = "net_address_addressLines_get";
sp.Parameters.Add("@addressID", SqlDbType.BigInt);
sp.Parameters.SetLong("@addressID", addressID);
//
// Run the stored procedure
//
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
if (1 == Context.ApiVersionMajor)
{
while (reader.Read())
{
AddressLines.Add(reader.GetString("addressLine"));
}
}
else
{
while (reader.Read())
{
AddressLines.Add(
reader.GetString("addressLine"),
reader.GetString("keyName"),
reader.GetString("keyValue"));
}
}
}
finally
{
reader.Close();
}
}
/// <summary>
/// Use this function to populate a ResultsList instance with raw values from the database.
/// The results from the database must be returned in the following order:
///
/// businessName
/// businessKey
/// serviceName
/// serviceKey
///
/// ParseResults will use indexes to read these values from the SqlDataReaderAccessor so this
/// order must be maintained from the database.
/// </summary>
/// <param name="values">Reader returned from the database.</param>
/// <returns></returns>
public int ParseResults(SqlDataReaderAccessor values)
{
results = new ArrayList();
string currentBusinessName = null;
string lastBusinessName = null;
BusinessResultInfo businessInfo = new BusinessResultInfo();
while (values.Read())
{
currentBusinessName = values.GetString(0);
ServiceResultInfo serviceInfo = new ServiceResultInfo();
serviceInfo.serviceName = values.GetString(2);
serviceInfo.serviceKey = values.GetString(3);
if (null != lastBusinessName && false == lastBusinessName.Equals(currentBusinessName))
{
results.Add(businessInfo);
businessInfo = new BusinessResultInfo();
}
businessInfo.businessName = currentBusinessName;
businessInfo.serviceResultInfos.Add(serviceInfo);
lastBusinessName = currentBusinessName;
}
//
// Add our last one.
//
if (businessInfo.serviceResultInfos.Count > 0)
{
results.Add(businessInfo);
}
return(results.Count);
}
public void Get(string parentKey, EntityType parentType)
{
SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor();
switch (parentType)
{
case EntityType.BusinessEntity:
sp.ProcedureName = "net_businessEntity_names_get";
sp.Parameters.Add("@businessKey", SqlDbType.UniqueIdentifier);
sp.Parameters.SetGuidFromString("@businessKey", parentKey);
break;
case EntityType.BusinessService:
sp.ProcedureName = "net_businessService_names_get";
sp.Parameters.Add("@serviceKey", SqlDbType.UniqueIdentifier);
sp.Parameters.SetGuidFromString("@serviceKey", parentKey);
break;
default:
// throw new UDDIException( ErrorType.E_fatalError, "Unexpected parent entity type '" + parentType.ToString() + "'" );
throw new UDDIException(ErrorType.E_fatalError, "UDDI_ERROR_UNEXPECTED_PARENT_ENTITY_TYPE", parentType.ToString());
}
SqlDataReaderAccessor reader = sp.ExecuteReader();
try
{
Read(reader);
}
finally
{
reader.Close();
}
}
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);
}
