public IEnumerable <IClientAccount> AvailableAccounts(int reservationId, ActivityAccountType activityAccountType)
{
using (var conn = CreateConnection())
using (var cmd = CreateCommand(conn, "sselScheduler.dbo.procReservationSelect"))
{
AddParameter(cmd, "Action", "AvailableAccounts", DbType.String);
AddParameter(cmd, "ReservationID", reservationId, DbType.Int32);
AddParameter(cmd, "ActivityAccountType", (int)activityAccountType, DbType.Int32);
var dt = FillDataTable(cmd);
var result = AutoMap <ClientAccount>(dt);
return(result);
}
}
/// <summary>
/// Loads Reservation Billing Account Dropdownlist
/// </summary>
public bool LoadAccounts(List <IClientAccount> accts, ActivityAccountType acctType, IClient client, IEnumerable <Invitee> invitees, string username)
{
bool mustAddInvitee = false;
//IList<ClientAccountItem> activeAccounts = new List<ClientAccountItem>();
IEnumerable <IClientAccount> activeAccounts = new List <IClientAccount>();
if (acctType == ActivityAccountType.Reserver || acctType == ActivityAccountType.Both)
{
/// Loads reserver's accounts
activeAccounts = Provider.Data.Client.GetActiveClientAccounts(username);
}
if (acctType == ActivityAccountType.Invitee || acctType == ActivityAccountType.Both)
{
// Loads each of the invitee's accounts
if (invitees != null)
{
var invited = invitees.Where(x => !x.Removed).ToList();
if (invited.Count > 0)
{
var inviteeClientIds = invited.Select(x => x.InviteeID).ToArray();
activeAccounts = Provider.Data.Client.GetActiveClientAccounts(inviteeClientIds);
}
else
{
mustAddInvitee = true;
}
}
}
var orderedAccts = ClientPreferenceUtility.OrderListByUserPreference(client, activeAccounts, x => x.AccountID, x => x.AccountName);
accts.AddRange(orderedAccts);
return(mustAddInvitee);
}
public IEnumerable <IClientAccount> AvailableAccounts(int reservationId, ActivityAccountType accountType)
{
throw new NotImplementedException();
}
