public void TestCRUD() { m1 = new Member( list.Id, "John Doe", "*****@*****.**" ); // insert m1.Persist(); Assert.AreEqual( m1.Name, "John Doe", "The object was not properly inserted!" ); Assert.AreEqual( m1.Address, "*****@*****.**", "The object was not properly inserted!" ); // select m2 = Member.Retrieve( m1.Id ); // verify select/insert Assert.IsTrue( m2.Id != 0, "The object could not be retrieved from the database!" ); Assert.AreEqual( m1.Id, m2.Id, "The object could not be retrieved from the database!" ); Assert.AreEqual( "John Doe", m2.Name, "The object was not properly retrieved on construction!" ); Assert.AreEqual( "*****@*****.**", m2.Address, "The object was not properly retrieved on construction!" ); // update m2.Name = "Jane Doe"; m2.Address = "*****@*****.**"; m2.Persist(); // verify update m1 = Member.Retrieve( m2.Id ); Assert.AreEqual( m2.Name, m1.Name, "Name not updated!" ); Assert.AreEqual( m2.Address, m1.Address, "SenderAddress not updated!" ); // delete m2.Remove(); // verify delete by counting the number of rows SqlBuilder sb = new SqlBuilder( StatementType.Count, typeof(Member) ); sb.AddConstraint( Operator.Equals, "Id", m1.Id ); SqlResult sr = Broker.Execute( sb.GetStatement( true ) ); Assert.AreEqual( 0, sr.Count, "Object not removed" ); }
public void TestRegexBad() { // test that a `bad` email address throws an exception m1 = new Member(list.Id, "John Doe", "john-doe.com"); // insert m1.Persist(); }
public void TestRegexBad() { // test that a `bad` email address throws an exception m1 = new Member( list.Id, "John Doe", "john-doe.com" ); // insert m1.Persist(); }
public void TestRequiredBad() { // test that an empty email address throws an exception m1 = new Member(list.Id, string.Empty, "*****@*****.**"); // insert m1.Persist(); }
public void TestCRUD() { m1 = new Member(list.Id, "John Doe", "*****@*****.**"); // insert m1.Persist(); Assert.AreEqual(m1.Name, "John Doe", "The object was not properly inserted!"); Assert.AreEqual(m1.Address, "*****@*****.**", "The object was not properly inserted!"); // select m2 = Member.Retrieve(m1.Id); // verify select/insert Assert.IsTrue(m2.Id != 0, "The object could not be retrieved from the database!"); Assert.AreEqual(m1.Id, m2.Id, "The object could not be retrieved from the database!"); Assert.AreEqual("John Doe", m2.Name, "The object was not properly retrieved on construction!"); Assert.AreEqual("*****@*****.**", m2.Address, "The object was not properly retrieved on construction!"); // update m2.Name = "Jane Doe"; m2.Address = "*****@*****.**"; m2.Persist(); // verify update m1 = Member.Retrieve(m2.Id); Assert.AreEqual(m2.Name, m1.Name, "Name not updated!"); Assert.AreEqual(m2.Address, m1.Address, "SenderAddress not updated!"); // delete m2.Remove(); // verify delete by counting the number of rows SqlBuilder sb = new SqlBuilder(StatementType.Count, typeof(Member)); sb.AddConstraint(Operator.Equals, "Id", m1.Id); SqlResult sr = Broker.Execute(sb.GetStatement(true)); Assert.AreEqual(0, sr.Count, "Object not removed"); }
public void TestDateRangeGood() { m1 = new MemberValidation(0, 1, "John Doe", "*****@*****.**"); // insert - no exception because default dates are inside valid range m1.Persist(); // clean up m1.Remove(); }
public void TestRequiredBadButAllowNull() { // test that an empty email address throws an exception m1 = new Member(list.Id, null, "*****@*****.**"); // insert m1.Persist(); // delete m1.Remove(); }
public void CustomValidatorGood() { // no exception because listid > id m1 = new MemberValidation(0, 1, "John Doe", "*****@*****.**"); // insert m1.Persist(); // clean up m1.Remove(); }
public void CustomValidatorBad() { // exception because listid < id m1 = new MemberValidation(1, 0, "John Doe", "*****@*****.**"); // insert m1.Persist(); // clean up (not executed unless Persist erroneously succeeds) m1.Remove(); }
public void TestRegexGoodData() { // test that a `good` email address can be entered in the database m1 = new Member( list.Id, "John Doe", "*****@*****.**" ); // insert m1.Persist(); Assert.AreEqual( m1.Name, "John Doe", "The object was not properly inserted!" ); Assert.AreEqual( m1.Address, "*****@*****.**", "The object was not properly inserted!" ); // delete m1.Remove(); }
public void TestRequiredGood() { // test that an email address (required field) entered passes validation m1 = new Member(list.Id, "John Doe", "*****@*****.**"); // insert m1.Persist(); Assert.AreEqual(m1.Name, "John Doe", "The object was not properly inserted!"); Assert.AreEqual(m1.Address, "*****@*****.**", "The object was not properly inserted!"); // delete m1.Remove(); }
public void TestRegexGoodData() { // test that a `good` email address can be entered in the database m1 = new Member(list.Id, "John Doe", "*****@*****.**"); // insert m1.Persist(); Assert.AreEqual(m1.Name, "John Doe", "The object was not properly inserted!"); Assert.AreEqual(m1.Address, "*****@*****.**", "The object was not properly inserted!"); // delete m1.Remove(); }
public void TestRequiredGood() { // test that an email address (required field) entered passes validation m1 = new Member( list.Id, "John Doe", "*****@*****.**" ); // insert m1.Persist(); Assert.AreEqual( m1.Name, "John Doe", "The object was not properly inserted!" ); Assert.AreEqual( m1.Address, "*****@*****.**", "The object was not properly inserted!" ); // delete m1.Remove(); }
public void TestRequiredBad() { // test that an empty email address throws an exception m1 = new Member( list.Id, string.Empty, "*****@*****.**" ); // insert m1.Persist(); }
public void TestRequiredBadButAllowNull() { // test that an empty email address throws an exception m1 = new Member( list.Id, null, "*****@*****.**" ); // insert m1.Persist(); // delete m1.Remove(); }
public void TestDateRangeGood() { m1 = new MemberValidation( 0, 1, "John Doe", "*****@*****.**" ); // insert - no exception because default dates are inside valid range m1.Persist(); // clean up m1.Remove(); }
public void CustomValidatorGood() { // no exception because listid > id m1 = new MemberValidation( 0, 1, "John Doe", "*****@*****.**" ); // insert m1.Persist(); // clean up m1.Remove(); }
public void CustomValidatorBad() { // exception because listid < id m1 = new MemberValidation( 1, 0, "John Doe", "*****@*****.**" ); // insert m1.Persist(); // clean up (not executed unless Persist erroneously succeeds) m1.Remove(); }