public static void QueryInsertQuery_TypedRow(ICRUDDataStore store)
{
var query = new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff")
};
var result = store.Load(query);
Assert.AreEqual(1, result.Count);
var rowset = result[0];
Assert.AreEqual(0, rowset.Count);
var row = new Patient();
row.SSN = "999-88-9012";
row.First_Name = "Jack";
row.Last_Name = "Kozloff";
row.DOB = new DateTime(1980, 1, 12);
Assert.IsNull(row.Validate());
store.Insert(row);
result = store.Load(query);
Assert.AreEqual(1, result.Count);
rowset = result[0];
Assert.AreEqual(1, rowset.Count);
Assert.IsInstanceOf <Patient>(rowset[0]);
Assert.AreEqual("Jack", rowset[0]["First_Name"]);
}
public static void QueryInsertQuery_DynamicRow(ICRUDDataStore store)
{
var query = new Query <DynamicRow>("CRUD.Patient.List")
{
new Query.Param("LN", "%ruman")
};
var result = store.Load(query);
Assert.AreEqual(1, result.Count);
var rowset = result[0];
Assert.AreEqual(0, rowset.Count);
var row = new Patient();
row.SSN = "999-88-9012";
row.First_Name = "Mans";
row.Last_Name = "Skolopendruman";
row.DOB = new DateTime(1970, 1, 12);
Assert.IsNull(row.Validate());
store.Insert(row);
var row2 = store.LoadRow(query);
Assert.IsNotNull(row2);
Assert.IsInstanceOf <DynamicRow>(row2);
Assert.AreEqual("Mans", row2["First_Name"]);
}
public static void QueryInsertQuery_TypedRow(ICRUDDataStore store)
{
var query = new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff") };
var result = store.Load( query );
Assert.AreEqual(1, result.Count);
var rowset = result[0];
Assert.AreEqual(0, rowset.Count);
var row = new Patient();
row.SSN = "999-88-9012";
row.First_Name = "Jack";
row.Last_Name = "Kozloff";
row.DOB = new DateTime(1980, 1, 12);
Assert.IsNull( row.Validate());
store.Insert(row);
result = store.Load( query );
Assert.AreEqual(1, result.Count);
rowset = result[0];
Assert.AreEqual(1, rowset.Count);
Assert.IsInstanceOf<Patient>( rowset[0] );
Assert.AreEqual("Jack", rowset[0]["First_Name"]);
}
public static void QueryInsertQuery_DynamicRow(ICRUDDataStore store)
{
var query = new Query<DynamicRow>("CRUD.Patient.List") { new Query.Param("LN", "%ruman") };
var result = store.Load( query );
Assert.AreEqual(1, result.Count);
var rowset = result[0];
Assert.AreEqual(0, rowset.Count);
var row = new Patient();
row.SSN = "999-88-9012";
row.First_Name = "Mans";
row.Last_Name = "Skolopendruman";
row.DOB = new DateTime(1970, 1, 12);
Assert.IsNull( row.Validate());
store.Insert(row);
var row2 = store.LoadRow( query );
Assert.IsNotNull(row2);
Assert.IsInstanceOf<DynamicRow>( row2 );
Assert.AreEqual("Mans", row2["First_Name"]);
}
