コード例 #1
0
        public void ReadAll_Create3Records_CountIs3()
        {
            //Assemble
            ClientModel clientModel1 = new ClientModel();

            clientModel1.name  = "Bob";
            clientModel1.phone = "07561 101169";
            clientModel1.email = "*****@*****.**";

            ClientModel clientModel2 = new ClientModel();

            clientModel2.name  = "Bob2";
            clientModel2.phone = "07561 101169";
            clientModel2.email = "*****@*****.**";

            ClientModel clientModel3 = new ClientModel();

            clientModel3.name  = "Bob3";
            clientModel3.phone = "07561 101169";
            clientModel3.email = "*****@*****.**";

            ClientTable clientTable = new ClientTable();
            int         expected    = 3;

            //Act
            int clientID1             = clientTable.create(clientModel1);
            int clientID2             = clientTable.create(clientModel2);
            int clientID3             = clientTable.create(clientModel3);
            List <ClientModel> actual = clientTable.readAll();

            //Assert
            Assert.AreEqual(expected, actual.Count);
        }
コード例 #2
0
        public void Update_CreatedUpdateAndRead1Record_UpdatedValues()
        {
            //Assemble
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "07561 101169";
            clientModel.email = "*****@*****.**";
            ClientTable clientTable = new ClientTable();
            int         clientID    = clientTable.create(clientModel);

            clientModel.id    = clientID;
            clientModel.name  = "Kate";
            clientModel.phone = "07561 101170";
            clientModel.email = "*****@*****.**";

            //Act
            clientTable.update(clientModel);
            ClientModel actual = clientTable.read(clientID);

            //Assert
            Assert.AreEqual(clientModel.name, actual.name);
            Assert.AreEqual(clientModel.phone, actual.phone);
            Assert.AreEqual(clientModel.email, actual.email);
        }
コード例 #3
0
        public void CreateEmailConstraint_EmailLengthTooShort_Exception()
        {
            //Assemble
            ClientTable clientTable = new ClientTable();
            ClientModel clientModel = new ClientModel();

            clientModel.displayName = "Barry Bonds";
            clientModel.phone       = "1234567890";
            clientModel.email       = "*****@*****.**";
            int expected = 1;
            int counter  = 0;

            //Act
            try
            {
                int id = clientTable.create(clientModel);
            }
            catch (Exception ex)
            {
                counter++;
            }

            //Assert
            Assert.AreEqual(expected, counter);
        }
コード例 #4
0
        public void CreatePhoneConstraint_PhoneLengthOk_NoException()
        {
            //Assemble
            ClientTable clientTable = new ClientTable();
            ClientModel clientModel = new ClientModel();

            clientModel.displayName = "Barry Bonds";
            clientModel.phone       = "1234567890";
            clientModel.email       = "*****@*****.**";
            int expected = 1;
            int counter  = 0;

            //Act
            try
            {
                int id = clientTable.create(clientModel);
                counter++;
            }
            catch (Exception ex)
            {
            }

            //Assert
            Assert.AreEqual(expected, counter);
        }
コード例 #5
0
        public void CreateEmailConstraint_EmailLengthOk_NoException()
        {
            //Assemble
            ClientTable clientTable = new ClientTable();
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "1234567890";
            clientModel.email = "*****@*****.**";
            int expected = 1;
            int counter  = 0;

            //Act
            try
            {
                int id = clientTable.create(clientModel);
                counter++;
            }
            catch (Exception ex)
            {
            }

            //Assert
            Assert.AreEqual(expected, counter);
        }
コード例 #6
0
        public void Setup()
        {
            new DataStoreTableHelper().clearAllTables();

            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "1234567890";
            clientModel.email = "*****@*****.**";

            ClientTable clientTable = new ClientTable();

            clientId = clientTable.create(clientModel);

            DogModel dogModel = new DogModel();

            dogModel.clientID = clientId;
            dogModel.name     = "Dog";
            dogModel.age      = 6;
            dogModel.breed    = "Terrier";
            dogModel.experienceOrQualification = false;

            DogTable dogTable = new DogTable();

            dogId = dogTable.create(dogModel);

            ProgramTypeModel programTypeModel = new ProgramTypeModel();

            programTypeModel.description = "Regular";

            ProgramTypeTable programTypeTable = new ProgramTypeTable();

            programTypeId = programTypeTable.create(programTypeModel);
        }
コード例 #7
0
        public void CreatePhoneConstraint_PhoneLengthTooShort_Exception()
        {
            //Assemble
            ClientTable clientTable = new ClientTable();
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "123456789";
            clientModel.email = "*****@*****.**";
            int expected = 1;
            int counter  = 0;

            //Act
            try
            {
                int id = clientTable.create(clientModel);
            }
            catch (Exception ex)
            {
                counter++;
            }

            //Assert
            Assert.AreEqual(expected, counter);
        }
コード例 #8
0
        public void CreateNameConstraint_NameLengthOk_NoException()
        {
            //Assemble
            ClientTable clientTable = new ClientTable();
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "07561 101169";
            clientModel.email = "*****@*****.**";
            int expected = 1;
            int counter  = 0;

            //Act
            try
            {
                int id = clientTable.create(clientModel);
                counter++;
            }
            catch (Exception ex)
            {
            }

            //Assert
            Assert.AreEqual(expected, counter);
        }
コード例 #9
0
        public void ReadAll_Create3Records_3DifferentRecords()
        {
            //Assemble
            ClientModel clientModel1 = new ClientModel();

            clientModel1.name  = "name1";
            clientModel1.phone = "07561 101169";
            clientModel1.email = "*****@*****.**";

            ClientModel clientModel2 = new ClientModel();

            clientModel2.name  = "name2";
            clientModel2.phone = "07561 101170";
            clientModel2.email = "*****@*****.**";

            ClientModel clientModel3 = new ClientModel();

            clientModel3.name  = "name3";
            clientModel3.phone = "07561 101171";
            clientModel3.email = "*****@*****.**";

            ClientTable clientTable = new ClientTable();

            //Act
            int clientID1             = clientTable.create(clientModel1);
            int clientID2             = clientTable.create(clientModel2);
            int clientID3             = clientTable.create(clientModel3);
            List <ClientModel> actual = clientTable.readAll();

            //Assert
            Assert.AreEqual(clientID1, clientID1);
            Assert.AreEqual(clientModel1.name, actual[0].name);
            Assert.AreEqual(clientModel1.phone, actual[0].phone);
            Assert.AreEqual(clientModel1.email, actual[0].email);

            Assert.AreEqual(clientID2, clientID2);
            Assert.AreEqual(clientModel2.name, actual[1].name);
            Assert.AreEqual(clientModel2.phone, actual[1].phone);
            Assert.AreEqual(clientModel2.email, actual[1].email);

            Assert.AreEqual(clientID3, clientID3);
            Assert.AreEqual(clientModel3.name, actual[2].name);
            Assert.AreEqual(clientModel3.phone, actual[2].phone);
            Assert.AreEqual(clientModel3.email, actual[2].email);
        }
コード例 #10
0
        public void Setup()
        {
            new DataStoreTableHelper().clearAllTables();

            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "1234567890";
            clientModel.email = "*****@*****.**";

            ClientTable clientTable = new ClientTable();

            clientId = clientTable.create(clientModel);

            DogModel dogModel = new DogModel();

            dogModel.clientID = clientId;
            dogModel.name     = "Dog";
            dogModel.age      = 6;
            dogModel.breed    = "Terrier";
            dogModel.experienceOrQualification = false;

            DogTable dogTable = new DogTable();

            dogId = dogTable.create(dogModel);

            ProgramTypeModel programTypeModel = new ProgramTypeModel();

            programTypeModel.description = "Regular";

            ProgramTypeTable programTypeTable = new ProgramTypeTable();

            programTypeId = programTypeTable.create(programTypeModel);

            ProgramCostModel programeCostModel = new ProgramCostModel();

            programeCostModel.depositAmount = 20.0;
            programeCostModel.sessionCost   = 20.0;
            programeCostModel.fullPaymentPercentageDiscount = 20;

            ProgramCostTable programCostTable = new ProgramCostTable();

            programeCostId = programCostTable.create(programeCostModel);

            ProgramModel programModel = new ProgramModel();

            programModel.programTypeId    = programTypeId;
            programModel.programCostId    = programeCostId;
            programModel.dogSpacesMaximum = 50;
            programModel.noOfClasses      = 50;

            ProgramTable programTable = new ProgramTable();

            programId = programTable.create(programModel);
        }
コード例 #11
0
        public void Setup()
        {
            new DataStoreTableHelper().clearAllTables();

            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "1234567890";
            clientModel.email = "*****@*****.**";

            ClientTable clientTable = new ClientTable();

            clientId = clientTable.create(clientModel);
        }
コード例 #12
0
        public void Count_Created1Record_1()
        {
            //Assemble
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "07561 101169";
            clientModel.email = "*****@*****.**";
            int         expected    = 1;
            ClientTable clientTable = new ClientTable();

            //Act
            int clientID = clientTable.create(clientModel);
            int actual   = clientTable.count();

            //Assert
            Assert.AreEqual(expected, actual);
        }
コード例 #13
0
        public void Create_ValidData_ClientIDReturned()
        {
            //Assemble
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "07561 101169";
            clientModel.email = "*****@*****.**";
            //If created will be greater than 0, but we don't know exactly what it will be because deleting all records doesnt set the ID counter back to 0
            int         notCreated  = 0;
            ClientTable clientTable = new ClientTable();

            //Act
            int actual = clientTable.create(clientModel);

            //Assert
            Assert.AreNotEqual(notCreated, actual);
        }
コード例 #14
0
        public void Read_CreatedAndRead1Record_CorrectValues()
        {
            //Assemble
            ClientModel clientModel = new ClientModel();

            clientModel.name  = "Bob";
            clientModel.phone = "07561 101169";
            clientModel.email = "*****@*****.**";
            ClientTable clientTable = new ClientTable();

            //Act
            int         clientID = clientTable.create(clientModel);
            ClientModel actual   = clientTable.read(clientID);

            //Assert
            Assert.AreEqual(clientModel.name, actual.name);
            Assert.AreEqual(clientModel.phone, actual.phone);
            Assert.AreEqual(clientModel.email, actual.email);
        }
コード例 #15
0
        public void Delete_CreatedDeleteAndCount1Record_0()
        {
            //Assemble
            ClientModel clientModel = new ClientModel();

            clientModel.displayName = "Barry Bonds";
            clientModel.phone       = "07561 101169";
            clientModel.email       = "*****@*****.**";
            int         expected    = 0;
            ClientTable clientTable = new ClientTable();
            int         clientID    = clientTable.create(clientModel);

            //Act
            clientTable.delete(clientID);
            int actual = clientTable.count();

            //Assert
            Assert.AreEqual(expected, actual);
        }
コード例 #16
0
        private static void populateDatabase()
        {
            //clear all the records in all the tables
            new DataStoreTableHelper().clearAllTables();

            //check the tables are empty
            consoleTableCounts();

            //Adding some records to it will be easier to create and update the screens

            //add Client records
            ClientTable clientTable = new ClientTable();

            ClientModel clientModelBob = new ClientModel();

            clientModelBob.forename    = "Bob";
            clientModelBob.surname     = "White";
            clientModelBob.phone       = "1234567890";
            clientModelBob.email       = "*****@*****.**";
            clientModelBob.displayName = clientModelBob.forename + " " + clientModelBob.surname;
            int clientIdBob = clientTable.create(clientModelBob);

            ClientModel clientModelKate = new ClientModel();

            clientModelKate.forename    = "Kate";
            clientModelKate.surname     = "Black";
            clientModelKate.phone       = "1234567890";
            clientModelKate.email       = "*****@*****.**";
            clientModelKate.displayName = clientModelKate.forename + " " + clientModelKate.surname;
            int clientIdKate = clientTable.create(clientModelKate);

            //add Dog records
            DogTable dogTable = new DogTable();

            DogModel dogModelBoxer = new DogModel();

            dogModelBoxer.name     = "Boxer";
            dogModelBoxer.clientID = clientIdBob;
            dogModelBoxer.age      = 7;
            dogModelBoxer.breed    = "Bulldog";
            int dogIdBoxer = dogTable.create(dogModelBoxer);

            DogModel dogModelTed = new DogModel();

            dogModelTed.name     = "Ted";
            dogModelTed.clientID = clientIdKate;
            dogModelTed.age      = 7;
            dogModelTed.breed    = "Shi Tzu";
            int dogIdTed = dogTable.create(dogModelTed);

            //add Staff records
            StaffTable staffTable = new StaffTable();

            StaffModel staffModelBob = new StaffModel();

            staffModelBob.name = "Bob";
            int staffIdBob = staffTable.create(staffModelBob);

            StaffModel staffModelKate = new StaffModel();

            staffModelKate.name = "Kate";
            int staffIdKate = staffTable.create(staffModelKate);


            //add ProgramVariety records
            ProgramVarietyTable programVarietyTable = new ProgramVarietyTable();

            ProgramVarietyModel programVarietyAdvanced = new ProgramVarietyModel();

            programVarietyAdvanced.name          = "Advanced";
            programVarietyAdvanced.depositAmount = 30.0;
            programVarietyAdvanced.fullPaymentPercentageDiscount = 0.0;
            programVarietyAdvanced.sessionCost      = 30.0;
            programVarietyAdvanced.noOfClasses      = 8;
            programVarietyAdvanced.dogSpacesMaximum = 8;
            int programCostId1 = programVarietyTable.create(programVarietyAdvanced);


            ProgramVarietyModel programVarietyRegular = new ProgramVarietyModel();

            programVarietyRegular.name          = "Regular";
            programVarietyRegular.depositAmount = 20.0;
            programVarietyRegular.fullPaymentPercentageDiscount = 10.0;
            programVarietyRegular.sessionCost      = 25.0;
            programVarietyRegular.noOfClasses      = 6;
            programVarietyRegular.dogSpacesMaximum = 10;
            int programCostId2 = programVarietyTable.create(programVarietyRegular);


            //add Program records
            ProgramTable programTable = new ProgramTable();

            ProgramModel programModel1 = new ProgramModel();

            programModel1.name             = "Regular AM";
            programModel1.programVarietyId = programCostId2;
            int programId1 = programTable.create(programModel1);

            ProgramModel programModel2 = new ProgramModel();

            programModel2.name             = "Regular PM";
            programModel2.programVarietyId = programCostId2;
            int programId2 = programTable.create(programModel2);

            ProgramModel programModel3 = new ProgramModel();

            programModel3.name             = "Advanced";
            programModel3.programVarietyId = programCostId1;
            int programId3 = programTable.create(programModel3);

            //add Enrollment records
            EnrollmentTable enrollmentTable = new EnrollmentTable();

            EnrollmentModel enrollmentModel1 = new EnrollmentModel();

            enrollmentModel1.name          = dogModelBoxer.name + " (owned by " + clientModelBob.displayName + ") in " + programModel1.name;
            enrollmentModel1.clientId      = clientIdBob;
            enrollmentModel1.dogId         = dogIdBoxer;
            enrollmentModel1.programId     = programId1;
            enrollmentModel1.paymentMethod = PaymentConstants.PAYMENT_IN_FULL;
            enrollmentModel1.joinDate      = DateTime.Now;
            enrollmentModel1.inviteIssued  = false;
            int enrollmentId1 = enrollmentTable.create(enrollmentModel1);


            EnrollmentModel enrollmentModel2 = new EnrollmentModel();

            enrollmentModel2.name          = dogModelTed.name + " (owned by " + clientModelKate.displayName + ") in " + programModel2.name;
            enrollmentModel2.clientId      = clientIdKate;
            enrollmentModel2.dogId         = dogIdTed;
            enrollmentModel2.programId     = programId2;
            enrollmentModel2.paymentMethod = PaymentConstants.PAYMENT_PER_CLASS;
            enrollmentModel2.joinDate      = DateTime.Now;
            enrollmentModel2.inviteIssued  = true;
            int enrollmentId2 = enrollmentTable.create(enrollmentModel2);


            //check the tables have records
            consoleTableCounts();
        }
コード例 #17
0
ファイル: Populate.cs プロジェクト: CMcCullough1003/SSD
        private void populateClient()
        {
            ClientTable clientTable = new ClientTable();

            clientModelBarry             = new ClientModel();
            clientModelBarry.forename    = "James";
            clientModelBarry.surname     = "Jones";
            clientModelBarry.phone       = "1234567890";
            clientModelBarry.email       = "*****@*****.**";
            clientModelBarry.displayName = clientModelBarry.forename + " " + clientModelBarry.surname;
            clientIdBarry = clientTable.create(clientModelBarry);

            clientModelJames             = new ClientModel();
            clientModelJames.forename    = "Barry";
            clientModelJames.surname     = "Bonds";
            clientModelJames.phone       = "1234567891";
            clientModelJames.email       = "*****@*****.**";
            clientModelJames.displayName = clientModelJames.forename + " " + clientModelJames.surname;
            clientIdJames = clientTable.create(clientModelJames);

            clientModelMark             = new ClientModel();
            clientModelMark.forename    = "Mark";
            clientModelMark.surname     = "Murray";
            clientModelMark.phone       = "1234567892";
            clientModelMark.email       = "*****@*****.**";
            clientModelMark.displayName = clientModelMark.forename + " " + clientModelMark.surname;
            clientIdMark = clientTable.create(clientModelMark);

            clientModelSam             = new ClientModel();
            clientModelSam.forename    = "Sam";
            clientModelSam.surname     = "Spud";
            clientModelSam.phone       = "1234567893";
            clientModelSam.email       = "*****@*****.**";
            clientModelSam.displayName = clientModelSam.forename + " " + clientModelSam.surname;
            clientIdSam = clientTable.create(clientModelSam);

            clientModelTed             = new ClientModel();
            clientModelTed.forename    = "Ted";
            clientModelTed.surname     = "Teddington";
            clientModelTed.phone       = "1234567894";
            clientModelTed.email       = "*****@*****.**";
            clientModelTed.displayName = clientModelTed.forename + " " + clientModelTed.surname;
            clientIdTed = clientTable.create(clientModelTed);

            clientModelJim             = new ClientModel();
            clientModelJim.forename    = "Jim";
            clientModelJim.surname     = "Jones";
            clientModelJim.phone       = "1234567895";
            clientModelJim.email       = "*****@*****.**";
            clientModelJim.displayName = clientModelJim.forename + " " + clientModelJim.surname;
            clientIdJim = clientTable.create(clientModelJim);

            clientModelRon             = new ClientModel();
            clientModelRon.forename    = "Ron";
            clientModelRon.surname     = "Ronalds";
            clientModelRon.phone       = "1234567896";
            clientModelRon.email       = "*****@*****.**";
            clientModelRon.displayName = clientModelRon.forename + " " + clientModelRon.surname;
            clientIdRon = clientTable.create(clientModelRon);

            clientModelSid             = new ClientModel();
            clientModelSid.forename    = "Sid";
            clientModelSid.surname     = "Siddle";
            clientModelSid.phone       = "1234567897";
            clientModelSid.email       = "*****@*****.**";
            clientModelSid.displayName = clientModelSid.forename + " " + clientModelSid.surname;
            clientIdSid = clientTable.create(clientModelSid);
        }
コード例 #18
0
        public void Setup()
        {
            new DataStoreTableHelper().clearAllTables();

            ClientModel clientModel = new ClientModel();

            clientModel.displayName = "Barry Bonds";
            clientModel.phone       = "1234567890";
            clientModel.email       = "*****@*****.**";

            ClientTable clientTable = new ClientTable();

            clientId = clientTable.create(clientModel);

            DogModel dogModel = new DogModel();

            dogModel.clientID = clientId;
            dogModel.name     = "Dog";
            dogModel.age      = 6;
            dogModel.breed    = "Terrier";
            dogModel.experienceOrQualification = false;

            DogTable dogTable = new DogTable();

            dogId = dogTable.create(dogModel);

            ProgramVarietyModel programeVarietyModel = new ProgramVarietyModel();

            programeVarietyModel.depositAmount = 20.0;
            programeVarietyModel.sessionCost   = 20.0;
            programeVarietyModel.fullPaymentPercentageDiscount = 20;
            programeVarietyModel.name             = "Regular";
            programeVarietyModel.dogSpacesMaximum = 50;
            programeVarietyModel.noOfClasses      = 50;

            ProgramVarietyTable programVarietyTable = new ProgramVarietyTable();

            programVarietyId = programVarietyTable.create(programeVarietyModel);

            ProgramModel programModel = new ProgramModel();

            programModel.programVarietyId = programVarietyId;


            ProgramTable programTable = new ProgramTable();

            programId = programTable.create(programModel);

            EnrollmentModel enrollmentModel = new EnrollmentModel();

            enrollmentModel.name          = "A";
            enrollmentModel.clientId      = clientId;
            enrollmentModel.dogId         = dogId;
            enrollmentModel.programId     = programId;
            enrollmentModel.paymentMethod = 1;
            enrollmentModel.joinDate      = new DateTime(2021, 01, 03);
            enrollmentModel.inviteIssued  = true;

            EnrollmentTable enrollmentTable = new EnrollmentTable();

            enrollmentId = enrollmentTable.create(enrollmentModel);
        }