public void ValidateBoardEmployeeNumber_NotBoardDepartmentEmployeeNumberStartsWithBRD_Succeeds(string department)
        {
            var data = new[]
            {
                new FileData { Fieldname = "Dept", StringValue = department },
                new FileData { Fieldname = "EmployeeNumber", StringValue = "BRD12345678" }
            };

            Assert.DoesNotThrow(() => data.ValidateBoardEmployeeNumber());
        }
        public void ValidateBoardEmployeeNumber_EmployeeNumberIsMissing_Throws()
        {
            var data = new[]
            {
                new FileData { Fieldname = "Dept", StringValue = "Board" }
            };

            Assert.Throws<InvalidOperationException>(() => data.ValidateBoardEmployeeNumber());
        }
        public void ValidateBoardEmployeeNumber_BoardDepartmentEmployeeNumberNotStartsWithBRD_Throws(string employeeNumber)
        {
            var data = new[]
            {
                new FileData { Fieldname = "Dept", StringValue = "Board" },
                new FileData { Fieldname = "EmployeeNumber", StringValue = employeeNumber }
            };

            Assert.Throws<ArgumentException>(() => data.ValidateBoardEmployeeNumber());
        }
        public void ValidateBoardEmployeeNumber_DepartmentIsMissing_Throws()
        {
            var data = new[]
            {
                new FileData { Fieldname = "EmployeeNumber", StringValue = "FIN12345678" }
            };

            Assert.Throws<InvalidOperationException>(() => data.ValidateBoardEmployeeNumber());
        }