예제 #1
0
        public void DBSalespersonTest_Get_invalidID()
        {
            DBSalesperson dBSalesperson = new DBSalesperson();
            const int     id            = -1;

            var result = dBSalesperson.Get(id);
        }
        public District DeleteSecondaryFromDistrict(int districtId, int personId)
        {
            var faulted = new District();

            try
            {
                DBSalesperson personDb = new DBSalesperson();
                var           person   = personDb.Get(personId);
                var           district = db.Get(districtId);
                db.DeleteSecondary(person, district);
                return(new District()
                {
                    IsFaulted = false
                });
            }
            catch (DataLayerArgumentException e)
            {
                faulted.IsFaulted = true;
                faulted.DataLayerArgumentException = e.Message;
            }
            catch (DataLayerException e)
            {
                faulted.IsFaulted          = true;
                faulted.DataLayerException = e.Message;
            }
            return(faulted);
        }
예제 #3
0
        public void DBSalespersonTest_GetAll()
        {
            DBSalesperson dbconn = new DBSalesperson();

            IEnumerable <Salesperson> result = dbconn.GetAll();

            Assert.AreNotEqual(0, result.ToList().Count);
        }
예제 #4
0
        public void DBSalespersonTest_Update_Fail_Name()
        {
            DBSalesperson db     = new DBSalesperson();
            var           person = db.Get(4);

            person.Name = String.Empty;

            db.Update(person);
        }
예제 #5
0
        public void DBSalespersonTest_Update_Fail_ID()
        {
            DBSalesperson db     = new DBSalesperson();
            var           person = db.Get(3);

            person.Id = -2;

            db.Update(person);
        }
예제 #6
0
        public void DBSalespersonTest_Update_Fail_LastName()
        {
            DBSalesperson db     = new DBSalesperson();
            var           person = db.Get(3);

            person.LastName = null;

            db.Update(person);
        }
예제 #7
0
        public void DBSalespersonTest_Delete_Fail_ID()
        {
            DBSalesperson dBSalesperson = new DBSalesperson();
            Salesperson   person        = new Salesperson()
            {
                Name = "Definitely A", LastName = "Not Existing Person", Id = -1
            };

            dBSalesperson.Delete(person.Id);
        }
예제 #8
0
        public void DBSalespersonTest_Persist()
        {
            DBSalesperson dBSalesperson = new DBSalesperson();
            Salesperson   person        = new Salesperson()
            {
                Name = "Test", LastName = "Object"
            };

            dBSalesperson.Persist(person);
        }
예제 #9
0
        public void DBSalespersonTest_Get_valid()
        {
            DBSalesperson dBSalesperson = new DBSalesperson();
            const int     id            = 1;
            const string  EXPECTED      = "Mike";

            var result = dBSalesperson.Get(id);

            Assert.AreEqual(EXPECTED, result.Name);
        }
예제 #10
0
        public void DBSalespersonTest_Persist_Delete()
        {
            DBSalesperson dBSalesperson = new DBSalesperson();
            Salesperson   person        = new Salesperson()
            {
                Name = "Test", LastName = "Object"
            };

            dBSalesperson.Persist(person);

            Salesperson salesman = dBSalesperson.GetAll().SingleOrDefault(x =>
            {
                return(x.Name.Equals("Test") && x.LastName.Equals("Object"));
            });

            dBSalesperson.Delete(salesman.Id);
        }
예제 #11
0
        public void DBSalespersonTest_Update()
        {
            DBSalesperson db      = new DBSalesperson();
            var           person  = db.Get(3);
            string        nameOld = person.Name;
            string        nameNew = "Jason";

            person.Name = nameNew;

            db.Update(person);
            person = null;

            person = db.Get(3);

            Assert.AreEqual(nameNew, person.Name);

            //cleanup
            person.Name = nameOld;
            db.Update(person);
        }
 public SalespersonController()
 {
     db = new DBSalesperson();
 }