public void Initialize()
{
testTransaction1 = new TransactionDto(24.99, true, "Amazon");
testTransaction2 = new TransactionDto(20.00, true, "Work");
testTransaction1.id = 1;
testTransaction2.id = 2;
testAccountHolder1 = new AccountHolderDto("Andy", "Laughlin");
testAccountHolder1.id = 12;
testAccount = new BankAccountDto("Andy Current Account", BankAccountType.IND_CURRENT_ACCOUNT);
testAccount.accountHolderId = testAccountHolder1.id;
testAccount.accountNumber = 12345678;
testAccount.sortCode = 123456;
testAccount.transactions.Add(testTransaction1);
testAccount.transactions.Add(testTransaction2);
testAccount.balance = 100.00;
}
public async Task <AccountHolderDto> GetUserInfoWithUserPlans(int userId, int programId)
{
using (var sqlConnection = await _databaseConnectionFactory.CreateConnectionAsync())
{
var userInfo = new AccountHolderDto();
using (var multi = sqlConnection.QueryMultipleAsync(SQLQueryConstants.GetMultipleQueryUserDetailNUserPlansQuery, new { UserId = userId, ProgramId = programId, PhotoTypeDetail = (int)PhotoEntityType.UserProfile }).Result)
{
try
{
userInfo = multi.Read <AccountHolderDto>().FirstOrDefault();
if (userInfo != null)
{
userInfo.ImageFileName = userInfo.UserImagePath;
userInfo.UserImagePath = await _photos.GetAWSBucketFilUrl(userInfo.UserImagePath, null);
}
var userPlans = multi.Read <int>().ToList();
if (userInfo != null)
{
userInfo.planIds = new List <PlanIdDto>();
foreach (var item in userPlans)
{
userInfo.planIds.Add(new PlanIdDto()
{
PlanId = item
});
}
}
return(userInfo);
}
catch (Exception)
{
throw;
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
}
}
}
public void initialize()
{
accountHolder1 = new AccountHolderDto("Andy", "Laughlin");
accountHolder1.id = 10;
}