public void Test_Update_Project()
        {
            var dao  = new CrProjectDao();
            var proj = new CrProject
            {
                ProjectName       = "Build Matts Barn",
                LocationName      = "Mason",
                OrganizationName  = "Crossroads",
                ProjectTypeName   = "Construction",
                DomainId          = 1,
                InitiativeId      = 1,
                ProjectStatusId   = 1,
                MinVol            = 2,
                MaxVol            = 5,
                AbsoluteMaxVol    = 1000,
                CheckInFloor      = "1",
                CheckInRoomNumber = "999",
                CheckInArea       = "Arg",
                Note1             = " Note 1",
                Note2             = "Note 2222",
                ParkingLocation   = "Park Loc",
                Address1          = "123 Main St.",
                City  = "Walton",
                State = "KY",
                Zip   = "90210"
            };


            var rc = dao.Update(proj);

            Assert.IsTrue(rc > 0);
        }
        public void Test_Insert_Project()
        {
            var dao  = new CrProjectDao();
            var proj = new CrProject
            {
                ProjectName      = "Build Something New",
                LocationName     = "Oakley",
                OrganizationName = "Crossroads",
                ProjectTypeName  = "Painting",
                DomainId         = 1,
                InitiativeId     = 1,
                ProjectStatusId  = 1,
                MinVol           = 2,
                MaxVol           = 5,
                AbsoluteMaxVol   = 7
            };

            proj.CheckInFloor      = "1";
            proj.CheckInRoomNumber = "200";
            proj.CheckInArea       = "Front of the room";
            proj.ParkingLocation   = "Down the road";
            proj.Note1             = "note number 1";
            proj.Note2             = "another note";

            proj.Address1 = "123 Main St";
            proj.City     = "Walton";
            proj.State    = "KY";
            proj.Zip      = "12345";


            var rc = dao.Insert(proj);

            Assert.IsTrue(rc > 0);
        }