public static void TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row["GDID"] = new GDID(0, 234);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = true; //notice TRUE for both char and bool columns below
row["BOOL_BOOL"] = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980,12,1);
store.Insert( row );
var row2 = store.LoadOneRow(new Query("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(234, row2["GDID"]);
Assert.AreEqual("User1", row2["Screen_Name"]);
Assert.AreEqual("Some user 1", row2["String_Name"]);
Assert.AreEqual("Some user 2", row2["Char_Name"]);
Assert.AreEqual(true, row2["BOOL_Char"].AsBool());
Assert.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Assert.AreEqual(145670.23m, row2["Amount"]);
Assert.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row.GDID = new GDID(0, 234);
row.Screen_Name = "User1";
row.String_Name = "Some user 1";
row.Char_Name = "Some user 2";
row.Bool_Char = true; //notice TRUE for both char and bool columns below
row.Bool_Bool = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980,12,1);
row["Age"] = 145;
store.Insert( row );
var row2 = store.LoadRow(new Query<Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(new GDID(0,0,234), row2.GDID);
Assert.AreEqual("User1", row2.Screen_Name);
Assert.AreEqual("Some user 1", row2.String_Name);
Assert.AreEqual("Some user 2", row2.Char_Name);
Assert.AreEqual(true, row2.Bool_Char.Value);
Assert.AreEqual(true, row2.Bool_Bool.Value);
Assert.AreEqual(145670.23m, row2.Amount);
Assert.AreEqual(1980, row2.DOB.Value.Year);
Assert.AreEqual(145, row2.Age);
row.Age = null;
row.Bool_Bool = null;
row.DOB = null;
store.Update(row);
var row3 = store.LoadRow(new Query<Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.IsFalse(row3.Age.HasValue);
Assert.IsFalse(row3.Bool_Bool.HasValue);
Assert.IsFalse(row3.DOB.HasValue);
Assert.IsNull( row3["Age"].AsNullableInt());
Assert.IsNull( row3["DOB"].AsNullableDateTime());
Assert.IsNull( row3["Bool_Bool"].AsNullableBool());
}