public async void Task3_Post_NewCode_FindName()
        {
            //Arrange
            _context    = new SDCContext(dbContextOptions);
            _controller = new CodeListsController(_context);
            var category = new CodeList()
            {
                CategoryId = 1,
                CodeId     = 6,
                CodeName   = "NewPickle"
            };

            //Act
            var result = await _controller.PostCodeList(category);

            //Assert
            var okResult  = result.Should().BeOfType <CreatedAtActionResult>().Subject;
            var resClient = okResult.Value.Should().BeAssignableTo <CodeList>().Subject;

            resClient.CodeName.Should().Be("NewPickle");

            //delete JayNew
            int categoryId   = _context.CodeList.FirstOrDefault(p => p.CodeName == "NewPickle").CategoryId;
            int codeId       = _context.CodeList.FirstOrDefault(p => p.CodeName == "NewPickle").CodeId;
            var resultDelete = await _controller.DeleteCodeList(categoryId, codeId);
        }
        private async void Task5_Delete_Code_OkResult()
        {
            //Arrange
            _context    = new SDCContext(dbContextOptions);
            _controller = new CodeListsController(_context);
            var code = new CodeList()
            {
                CategoryId = 1,
                CodeId     = 10,
                CodeName   = "New and Del Pickle",
            };

            //Act
            var resultCreate = await _controller.PostCodeList(code);

            var okResult      = resultCreate.Should().BeOfType <CreatedAtActionResult>().Subject;
            var resClient     = okResult.Value.Should().BeAssignableTo <CodeList>().Subject;
            int delcategoryId = resClient.CategoryId;
            int delcodeId     = resClient.CodeId;

            var result = await _controller.DeleteCodeList(delcategoryId, delcodeId);

            //Assert
            Assert.IsType <OkObjectResult>(result);
        }
        public async void Task2_GetById_Return_NotFoundResult()
        {
            //Arrange
            var categoryId = 32;
            var codeId     = 32;

            _context    = new SDCContext(dbContextOptions);
            _controller = new CodeListsController(_context);

            //Act
            var result = await _controller.GetCodeList(categoryId, codeId);

            //Assert
            Assert.IsType <NotFoundResult>(result);
        }
        public async void Task4_Put_Update_Code_NoContentResult()
        {
            //Arrange
            _context    = new SDCContext(dbContextOptions);
            _controller = new CodeListsController(_context);
            var categoryId = 1;
            var codeId     = 7;

            //Act
            var code = new CodeList()
            {
                CategoryId = categoryId,
                CodeId     = codeId,
                CodeName   = "Update Pickle"
            };
            var updatedData = await _controller.PutCodeList(categoryId, codeId, code);

            //Assert
            Assert.IsType <NoContentResult>(updatedData);
        }