private TestSprocGenerator.Business.SingleTable.Bo.EmailAddress GetEmailAddress(Guid emailAddressID)
{
TestSprocGenerator.Business.SingleTable.Bo.EmailAddress foundEmailAddress = null;
//get the user by username first then we can figure out if the password is ok
TestSprocGenerator.Business.SingleTable.Bo.EmailAddress emailCriteria =
new TestSprocGenerator.Business.SingleTable.Bo.EmailAddress(_smoSettings[CONNECTION_STRING_NAME])
{
EmailAddressID = emailAddressID
};
TestSprocGenerator.Business.SingleTable.Bo.List.EmailAddress searchReturned =
new TestSprocGenerator.Business.SingleTable.Bo.List.EmailAddress(_smoSettings[CONNECTION_STRING_NAME]);
searchReturned.FillByCriteriaExact(emailCriteria);
if (searchReturned != null && searchReturned.Count > 0)
{
//there should only be one
if (searchReturned.Count == 1)
{
foundEmailAddress = (TestSprocGenerator.Business.SingleTable.Bo.EmailAddress)searchReturned[0];
}
else
{
throw new ApplicationException("There should only be one email address with this profile, but there is more than one, contact administrator");
}
}
return(foundEmailAddress);
}
private TestSprocGenerator.Business.SingleTable.Bo.Account GetAccountByEmailAddress(string email)
{
TestSprocGenerator.Business.SingleTable.Bo.Account foundAccount = null;
TestSprocGenerator.Business.SingleTable.Bo.EmailAddress foundEmailAddress = null;
TestSprocGenerator.Business.SingleTable.Bo.EmailAddress emailAddressSearchCriteria =
new TestSprocGenerator.Business.SingleTable.Bo.EmailAddress(_smoSettings[CONNECTION_STRING_NAME])
{
EmailAddress_Property = email
};
TestSprocGenerator.Business.SingleTable.Bo.List.EmailAddress emailAddressSearchReturned =
new TestSprocGenerator.Business.SingleTable.Bo.List.EmailAddress(_smoSettings[CONNECTION_STRING_NAME]);
emailAddressSearchReturned.FillByCriteriaExact(emailAddressSearchCriteria);
if (emailAddressSearchReturned != null && emailAddressSearchReturned.Count > 0)
{
if (emailAddressSearchReturned.Count == 1)
{
foundEmailAddress = (TestSprocGenerator.Business.SingleTable.Bo.EmailAddress)emailAddressSearchReturned[0];
TestSprocGenerator.Business.SingleTable.Bo.Profile_EmailAddress foundProfileEmail =
GetProfileEmailByEmailID(foundEmailAddress.EmailAddressID);
if (foundProfileEmail != null)
{
TestSprocGenerator.Business.SingleTable.Bo.Profile_Account foundProfileAccount =
GetProfileAccountByProfileID(foundProfileEmail.ProfileID);
if (foundProfileAccount != null)
{
foundAccount = GetAccountAccountByAccountID(foundProfileAccount.AccountID);
if (foundAccount == null)
{
throw new ApplicationException("Account not found");
}
}
else
{
throw new ApplicationException("Profile_Account not found");
}
}
else
{
throw new ApplicationException("Profile_Email record not found");
}
}
else
{
throw new ApplicationException("There should only be one Profile for this Account, but there is more than one, contact administrator");
}
}
return(foundAccount);
}