public void GetApplicationsQueriesDatabaseForAllApplications()
{
ApplicationsService.GetApplications();
DatabaseAccessService.Received(1).ReadMultipleAsJSON(
"SELECT t.Id, UserName, Date, CardName FROM TransactionLog t LEFT JOIN CreditCards c ON t.CardId = c.Id"
);
}
public void FindCardQueriesTheDatabase()
{
CardService.FindCard(1);
DatabaseAccessService.Received(1).ReadAsJSON(
"SELECT * FROM CreditCards WHERE Id = @CardId",
Arg.Any <SqlParameter[]>()
);
}
public void MakeApplicationQueriesTheDatabaseForCards()
{
DatabaseAccessService.ReadAsJSON(Arg.Any <string>(), Arg.Any <SqlParameter[]>())
.Returns("{}");
ApplicationService.MakeApplication("Jim", DOB, 100);
DatabaseAccessService.Received(1).ReadAsJSON(FindApplicableCardQuery, Arg.Any <SqlParameter[]>());
}
