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); }