public void VerifyDepartment()
        {
            Random random = new Random();

            IDepartment department = BusinessObjectInitializer.CreateDepartment();

            department.Name       = DATestUtils.GenerateString(30, true, false);
            department.IdFunction = random.Next(1, 5);
            department.Rank       = random.Next(100000, 200000);

            int newId = InsertDepartmentTest(department);

            Assert.Greater(newId, 0);

            int rowsAffected = UpdateDepartmentTest(department);

            Assert.AreEqual(1, rowsAffected);

            DataTable resultTable = SelectDepartmentTest(department).Tables[0];

            //Verifies that the table contains the correct column names and order
            StringCollection columns = new StringCollection();

            columns.AddRange(new string[] { "Name",
                                            "FunctionName",
                                            "Rank",
                                            "Id",
                                            "IdFunction", });

            DATestUtils.CheckTableStructure(resultTable, columns);

            int rowCount = DeleteDepartmentTest(department);

            Assert.AreEqual(1, rowCount);
        }