コード例 #1
0
        public void Save()
        {
            Task2 TempTask = new Task2();

            TempTask.Description = "This is a test";
            TempTask.DueDate     = new DateTime(1900, 1, 1);
            TempTask.Name        = "Test task";

            List <Task2> Tasks   = new List <Task2>();
            Task2        SubTask = new Task2();

            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();

            TestProject.Description = "This is a test project";
            TestProject.Name        = "Test Project";
            List <Task2> Tasks2 = new List <Task2>();

            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();
            using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("SELECT * FROM Project2_", CommandType.Text, "Data Source=localhost;Initial Catalog=ORMTestDatabase3;Integrated Security=SSPI;Pooling=false"))
            {
                Helper.ExecuteReader();
                if (Helper.Read())
                {
                    Assert.Equal("This is a test project", Helper.GetParameter <string>("Description_", ""));
                    Assert.Equal("Test Project", Helper.GetParameter <string>("Name_", ""));
                }
                else
                {
                    Assert.False(true, "Nothing was inserted");
                }
            }
            using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("SELECT * FROM Task2_", CommandType.Text, "Data Source=localhost;Initial Catalog=ORMTestDatabase3;Integrated Security=SSPI;Pooling=false"))
            {
                Helper.ExecuteReader();
                while (Helper.Read())
                {
                    Assert.Equal("This is a test", Helper.GetParameter <string>("Description_", ""));
                    Assert.Contains(Helper.GetParameter <string>("Name_", ""), new string[] { "Sub task 1", "Sub task 2", "Sub task 3", "Test task" });
                }
            }
        }
コード例 #2
0
        public void Any()
        {
            Task2 TempTask = new Task2();

            TempTask.Description = "This is a test";
            TempTask.DueDate     = new DateTime(1900, 1, 1);
            TempTask.Name        = "Test task";

            List <Task2> Tasks   = new List <Task2>();
            Task2        SubTask = new Task2();

            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();

            TestProject.Description = "This is a test project";
            TestProject.Name        = "Test Project";
            List <Task2> Tasks2 = new List <Task2>();

            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();

            Project2 TestObject = Project2.Any(new EqualParameter <long>(TestProject.ID, "ID_"));

            Assert.Equal(TestProject.Description, TestObject.Description);
            Assert.Equal(TestProject.Name, TestObject.Name);
            Assert.Equal(1, TestObject.Tasks.Count());
            Assert.Equal("Test task", TestObject.Tasks.First().Name);
            Assert.Equal("This is a test", TestObject.Tasks.First().Description);
            foreach (Task2 TestSubTask in TestObject.Tasks.First().SubTasks)
            {
                Assert.Equal(0, TestSubTask.SubTasks.Count());
                Assert.Contains(TestSubTask.Name, new string[] { "Sub task 1", "Sub task 2", "Sub task 3" });
                Assert.Equal("This is a test", TestSubTask.Description);
                Assert.Equal(new DateTime(1900, 1, 1), TestSubTask.DueDate);
            }
        }
コード例 #3
0
        public void All()
        {
            Task2 TempTask = new Task2();

            TempTask.Description = "This is a test";
            TempTask.DueDate     = new DateTime(1900, 1, 1);
            TempTask.Name        = "Test task";

            List <Task2> Tasks   = new List <Task2>();
            Task2        SubTask = new Task2();

            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask             = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate     = new DateTime(1900, 1, 1);
            SubTask.Name        = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();

            TestProject.Description = "This is a test project";
            TestProject.Name        = "Test Project";
            List <Task2> Tasks2 = new List <Task2>();

            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();

            IEnumerable <Task2> TestObject = Task2.All();

            foreach (Task2 TestTask in TestObject)
            {
                Assert.Contains(TestTask.Name, new string[] { "Sub task 1", "Sub task 2", "Sub task 3", "Test task" });
                Assert.Equal("This is a test", TestTask.Description);
                Assert.Equal(new DateTime(1900, 1, 1), TestTask.DueDate);
            }
        }
コード例 #4
0
        public void All()
        {
            Task2 TempTask = new Task2();
            TempTask.Description = "This is a test";
            TempTask.DueDate = new DateTime(1900, 1, 1);
            TempTask.Name = "Test task";

            List<Task2> Tasks = new List<Task2>();
            Task2 SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();
            TestProject.Description = "This is a test project";
            TestProject.Name = "Test Project";
            List<Task2> Tasks2 = new List<Task2>();
            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();

            IEnumerable<Task2> TestObject = Task2.All();
            foreach (Task2 TestTask in TestObject)
            {
                Assert.Contains(TestTask.Name, new string[] { "Sub task 1", "Sub task 2", "Sub task 3", "Test task" });
                Assert.Equal("This is a test", TestTask.Description);
                Assert.Equal(new DateTime(1900, 1, 1), TestTask.DueDate);
            }
        }
コード例 #5
0
        public void Update()
        {
            Task2 TempTask = new Task2();
            TempTask.Description = "This is a test";
            TempTask.DueDate = new DateTime(1900, 1, 1);
            TempTask.Name = "Test task";

            List<Task2> Tasks = new List<Task2>();
            Task2 SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();
            TestProject.Description = "This is a test project";
            TestProject.Name = "Test Project";
            List<Task2> Tasks2 = new List<Task2>();
            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();
            TestProject.Description = "Test description2";
            TestProject.Save();
            using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("SELECT * FROM Project2_", "Data Source=localhost;Initial Catalog=ORMTestDatabase3;Integrated Security=SSPI;Pooling=false", CommandType.Text))
            {
                Helper.ExecuteReader();
                if (Helper.Read())
                {
                    Assert.Equal("Test description2", Helper.GetParameter<string>("Description_", ""));
                    Assert.Equal("Test Project", Helper.GetParameter<string>("Name_", ""));
                }
                else
                {
                    Assert.False(true,"Nothing was inserted");
                }
            }
            using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("SELECT * FROM Task2_", "Data Source=localhost;Initial Catalog=ORMTestDatabase3;Integrated Security=SSPI;Pooling=false", CommandType.Text))
            {
                Helper.ExecuteReader();
                while (Helper.Read())
                {
                    Assert.Equal("This is a test", Helper.GetParameter<string>("Description_", ""));
                    Assert.Contains(Helper.GetParameter<string>("Name_", ""), new string[] { "Sub task 1", "Sub task 2", "Sub task 3", "Test task" });
                }
            }
        }
コード例 #6
0
        public void Any()
        {
            Task2 TempTask = new Task2();
            TempTask.Description = "This is a test";
            TempTask.DueDate = new DateTime(1900, 1, 1);
            TempTask.Name = "Test task";

            List<Task2> Tasks = new List<Task2>();
            Task2 SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 1";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 2";
            Tasks.Add(SubTask);
            SubTask = new Task2();
            SubTask.Description = "This is a test";
            SubTask.DueDate = new DateTime(1900, 1, 1);
            SubTask.Name = "Sub task 3";
            Tasks.Add(SubTask);

            TempTask.SubTasks = Tasks;
            Project2 TestProject = new Project2();
            TestProject.Description = "This is a test project";
            TestProject.Name = "Test Project";
            List<Task2> Tasks2 = new List<Task2>();
            Tasks2.Add(TempTask);
            TestProject.Tasks = Tasks2;
            TestProject.Save();

            Project2 TestObject = Project2.Any(new EqualParameter<long>(TestProject.ID, "ID_"));
            Assert.Equal(TestProject.Description, TestObject.Description);
            Assert.Equal(TestProject.Name, TestObject.Name);
            Assert.Equal(1, TestObject.Tasks.Count());
            Assert.Equal("Test task", TestObject.Tasks.First().Name);
            Assert.Equal("This is a test", TestObject.Tasks.First().Description);
            foreach (Task2 TestSubTask in TestObject.Tasks.First().SubTasks)
            {
                Assert.Equal(0, TestSubTask.SubTasks.Count());
                Assert.Contains(TestSubTask.Name, new string[] { "Sub task 1", "Sub task 2", "Sub task 3" });
                Assert.Equal("This is a test", TestSubTask.Description);
                Assert.Equal(new DateTime(1900, 1, 1), TestSubTask.DueDate);
            }
        }