public void TestContacts()
{
var contacts = ContactActiveRecordSet.GetContactsByAhsId("6036343", "FNSP");
Assert.IsTrue(contacts.Count == 2, contacts.LastError);
foreach (ContactActiveRecord contact in contacts)
{
Console.WriteLine("Contact: {0} Title: {1}", contact.ContactName, contact.Title);
}
}
/// <summary>
/// Gets the contacts by ahs id.
/// </summary>
/// <param name="ahsId">The ahs id.</param>
/// <param name="instance">The instance.</param>
/// <returns></returns>
static public ContactActiveRecordSet GetContactsByAhsId(string ahsId, string instance)
{
var contacts = new ContactActiveRecordSet
{
Instance = instance,
Query =
"select * from CONTACT where CONTACT_ID IN (select CONTACT_ID from AHS_CONTACT where ACCNT_HRCY_STEP_ID = :ahsId)"
};
contacts.AddParameter("ahsId", ahsId);
contacts.Execute();
return(contacts);
}