Esempio n. 1
0
        public void CreateBlogPostDB()
        {
            var blogPost = new BlogPost()
            {
                BlogPostID = 0,
                Body = "",
                Categories = new List<Category>(),
                Category = new Category()
                {
                    CategoryID = 2,
                    CategoryName = "Daily Picks"
                },
                HashTag = new HashTag()
                {
                    HashTagID = 1,
                    HashTagName = "#savings"
                },
                HashTags = new List<HashTag>(),
                Mce = new TinyMceClass()
                {
                    Body = "Unit Testing for CreateBlogPost"
                },
                PostDate = DateTime.Today,
                Status = 2,
                tags = new List<string>()
                {
                    "#goodfood",
                    "#bestdeals"
                }
            };

            var repo = new MVCBlogRepo();

            repo.CreateBlogPostDB(blogPost);

            var cn = new SqlConnection(Settings.ConnectionString);

            var expected = cn.Query<int>("SELECT COUNT(BlogPostID) FROM BlogPosts").FirstOrDefault();

            Assert.AreEqual(expected, 9);
        }