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);
}
public void CreateStaticPageDB()
{
var staticPage = new StaticPage()
{
Date = DateTime.Today,
Mce = new TinyMceClass()
{
Body = "Unit Test for CreateStaticPageDB method"
},
StaticPageID = 0,
Status = 2,
Title = "Testing",
UserID = "2598e14d-88d0-46a7-ace9-f323ffe89181"
};
var repo = new MVCBlogRepo();
repo.CreateStaticPageDB(staticPage);
var cn = new SqlConnection(Settings.ConnectionString);
var expected = cn.Query<int>("SELECT COUNT(StaticPageID) FROM StaticPages").FirstOrDefault();
Assert.AreEqual(expected, 6);
}
public void GetAllApprovedBlogPosts_CheckCount()
{
int expected;
using (var cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(BlogPostID) FROM BlogPosts WHERE [Status] = 1";
cmd.Connection = cn;
cn.Open();
expected = int.Parse(cmd.ExecuteScalar().ToString());
}
var repo = new MVCBlogRepo();
Assert.AreEqual(expected, repo.GetAllApprovedBlogPosts().Count());
}
public void GetAllHashTags_CheckCount()
{
int expected;
using (var cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(HashTagID) FROM HashTags";
cmd.Connection = cn;
cn.Open();
expected = int.Parse(cmd.ExecuteScalar().ToString());
}
var repo = new MVCBlogRepo();
Assert.AreEqual(expected, repo.GetAllHashTags().Count());
}
