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[]>()); }