public void InsertPerson()
{
var ops = new SqlOperations(TestCatalog, true);
Person p = new Person()
{
FirstName = "Virginia",
LastName = "Clime",
Gender = 2,
BirthDay = new DateTime(1920, 10, 20)
};
var success = ops.Add(p);
Assert.IsTrue(success, "Failed adding person");
if (success)
{
Person newPerson = PersonExists(p.Id);
newPerson.ShouldDeepEqual(p);
}
else
{
Assert.Fail("Added record failed");
}
}
public void InsertNewDataRowForPerson()
{
var ops = new SqlOperations(TestCatalog);
var dt = ops.ReadPeople();
DataRow row = dt.NewRow();
row["FirstName"] = "Karen";
row["LastName"] = "Payne";
row["Gender"] = 1;
row["BirthDay"] = new DateTime(1960, 8, 20);
Assert.IsTrue(ops.Add(row));
Assert.IsTrue(PersonExists(row.Field <string>("FirstName"), row.Field <string>("LastName")));
}
public void InsertPersonWithInvalidGender()
{
var ops = new SqlOperations(TestCatalog);
var badGenderId = ops.GenderIdentifiers.Max() + 10;
Person p = new Person()
{
FirstName = "Virginia",
LastName = "Clime",
Gender = badGenderId,
BirthDay = new DateTime(1920, 10, 20)
};
ops.Add(p);
Assert.IsTrue(ops.HasException);
}
