public void test_fetching_accounts()
{
var service = new AccountsService(_gateway);
var filter = new AccountsFilter
{
PageSize = 50,
PageNumber = 1,
EnabledFilter = true,
//NameFilter = ""
};
var accounts = service.GetAccounts(filter);
filter.CategoryFilter = AccountCategory.Asset;
var assetAccounts = service.GetAccounts(filter);
assetAccounts.Data.Accounts.Count.Should().BeGreaterThan(0);
assetAccounts.Data.Accounts.All(x => x.Category == AccountCategory.Asset).Should().BeTrue();
filter.CategoryFilter = null;
if (accounts.Links.Next != null)
{
filter.PageNumber += 1;
var nextPage = service.GetAccounts(filter);
}
accounts.Data.Accounts.Count.Should().BeGreaterThan(0);
var account = service.GetAccount(accounts.Data.Accounts[0].AccountNumber);
}
public AccountsResponse GetAccounts(AccountsFilter filter)
{
return(_gateway.Retrieve(client =>
{
var request = new RestRequest("accounts");
request.ApplyPaging(filter);
if (filter.EnabledFilter.HasValue)
{
request.AddQueryParameter("f_enabled", filter.EnabledFilter.Value ? "y" : "n");
}
if (!string.IsNullOrWhiteSpace(filter.NameFilter))
{
request.AddQueryParameter("f_name", filter.NameFilter);
}
if (filter.CategoryFilter.HasValue)
{
request.AddQueryParameter("f_type", filter.CategoryFilter.Value.ToString().ToLower());
}
return client.Get <AccountsResponse>(request);
}));
}
public static void ConvertToAccount(Contact contact, AccountsFilter param)
{
BusinessAccountMaint accountMaint = CreateInstance <BusinessAccountMaint>();
object cd = param.BAccountID;
accountMaint.BAccount.Cache.RaiseFieldUpdating <BAccount.acctCD>(null, ref cd);
BAccount account = new BAccount
{
AcctCD = (string)cd,
AcctName = param.AccountName,
Type = BAccountType.ProspectType,
ClassID = param.AccountClass,
ParentBAccountID = contact.ParentBAccountID
};
#region Set Contact and Address fields
CRContactClass cls = PXSelect <CRContactClass, Where <CRContactClass.classID, Equal <Current <Contact.classID> > > > .SelectSingleBound(accountMaint, new object[] { contact });
if (cls != null && cls.OwnerToBAccount == true)
{
account.WorkgroupID = contact.WorkgroupID;
account.OwnerID = contact.OwnerID;
}
try
{
object newValue = account.OwnerID;
accountMaint.BAccount.Cache.RaiseFieldVerifying <BAccount.ownerID>(account, ref newValue);
}
catch (PXSetPropertyException)
{
account.OwnerID = null;
}
account = accountMaint.BAccount.Insert(account);
accountMaint.Answers.CopyAllAttributes(account, contact);
Contact defContact = PXCache <Contact> .CreateCopy(PXSelect <Contact, Where <Contact.contactID, Equal <Current <BAccount.defContactID> > > > .SelectSingleBound(accountMaint, new object[] { account }));
var defContactNoteID = defContact.NoteID;
PXCache <Contact> .RestoreCopy(defContact, contact);
defContact.ContactType = ContactTypesAttribute.BAccountProperty;
defContact.FullName = account.AcctName;
defContact.ContactID = account.DefContactID;
defContact.BAccountID = account.BAccountID;
defContact.DuplicateStatus = DuplicateStatusAttribute.NotValidated;
defContact.DuplicateFound = false;
defContact.WorkgroupID = null;
defContact.OwnerID = null;
defContact.NoteID = defContactNoteID;
defContact = accountMaint.DefContact.Update(defContact);
Address contactAddress = PXSelect <Address, Where <Address.addressID, Equal <Required <Contact.defAddressID> > > > .Select(accountMaint, contact.DefAddressID);
if (contactAddress == null)
{
throw new PXException(Messages.DefAddressNotExists, contact.DisplayName);
}
contactAddress.BAccountID = account.BAccountID;
accountMaint.AddressCurrent.Cache.Clear();
defContact.DefAddressID = contactAddress.AddressID;
defContact = accountMaint.DefContact.Update(defContact);
contactAddress = accountMaint.AddressCurrent.Update(contactAddress);
account.DefAddressID = contactAddress.AddressID;
accountMaint.BAccount.Update(account);
contact.BAccountID = account.BAccountID;
contact.DuplicateStatus = DuplicateStatusAttribute.NotValidated;
contact.DuplicateFound = false;
if (contact.QualificationDate == null)
{
contact.QualificationDate = PXTimeZoneInfo.Now;
}
accountMaint.Contacts.Cache.SetStatus(contact, PXEntryStatus.Updated);
CR.Location location = accountMaint.DefLocation.Select();
location.DefAddressID = contactAddress.AddressID;
accountMaint.DefLocation.Update(location);
account.NoteID = PXNoteAttribute.GetNoteID <CRActivity.noteID>(accountMaint.CurrentBAccount.Cache, account);
foreach (CRPMTimeActivity a in PXSelect <CRPMTimeActivity, Where <CRPMTimeActivity.refNoteID, Equal <Required <Contact.noteID> > > > .Select(accountMaint, contact.NoteID))
{
a.BAccountID = account.BAccountID;
accountMaint.Activities.Cache.Update(a);
}
#endregion
// Copy Note text and Files references
CRSetup setup = PXSetupOptional <CRSetup> .Select(accountMaint);
PXNoteAttribute.CopyNoteAndFiles(accountMaint.Contacts.Cache, contact, accountMaint.CurrentBAccount.Cache, account, setup);
throw new PXRedirectRequiredException(accountMaint, "Business Account");
}