public void getLastUsed_returnLastUsedDate()
{
var setlastUsedBool = cc.SetLastUsed(DateTime.Now.AddDays(-1));
var LastUsedVal = cc.GetLastUsed();
FieldInfo fi = typeof(CreditCard).GetField("_lastUsed", BindingFlags.Instance | BindingFlags.NonPublic);
var actual = fi.GetValue(cc);
Assert.IsTrue(setlastUsedBool);
Assert.That(actual, Is.EqualTo(LastUsedVal));
}
public async Task <ICreditCard> updateCreditCard(ICreditCard cc)
{
using (var conn = new SQLiteConnection(_connectionString))
{
conn.Open();
var sqlstr = @"UPDATE Creditcard set created = " + cc.GetCreated() +
"lastused = " + cc.GetLastUsed() +
"pin = " + cc.GetPinCode() +
"wrongpincodeattemps = " + cc.GetWrongPinCodeAttemps() +
"account = " + cc.GetAccount().GetId() +
"blocked = " + cc.IsBlocked() +
"WHERE id = " + cc.GetId() + ";";
var command = new SQLiteCommand(sqlstr, conn);
await command.ExecuteNonQueryAsync();
}
return(cc);
}
public async Task <ICreditCard> createCreditCard(ICreditCard cc)
{
using (var conn = new SQLiteConnection(_connectionString)){
conn.Open();
//newly created CCs with 0 wrongpinattemps and not blocked
var sqlstr = @"INSERT INTO Creditcard (created, lastused, pin, wrongpincodeattemps, account, blocked)
VALUES ('" + cc.GetCreated().ToLongDateString() + "','" + cc.GetLastUsed().ToLongDateString() + "'," + cc.GetPinCode() + ", 0," + cc.GetAccount().GetId() + ", 0);";
System.Console.WriteLine(sqlstr);
var command = new SQLiteCommand(sqlstr, conn);
await command.ExecuteNonQueryAsync();
}
return(cc);
}
