public void PostsByCategory_Should_Return_Related_Posts() { var posts = new List<Post>(); var cats = new List<Category>(); var rel = new List<Categories_Post>(); var post = new Post(); post.PostID = 1; post.Title = "Tagged Post"; posts.Add(post); var cat = new Category(); cat.CategoryID = 1; cat.Description = "category"; cats.Add(cat); var cp = new Categories_Post(); cp.PostID = 1; cp.CategoryID = 1; rel.Add(cp); //setup SubSonic Post.Setup(posts); Category.Setup(cats); Categories_Post.Setup(rel); var result = Post.PostsByCategory("category"); Assert.Equal(1, result.Count()); }
static void ImportCategories() { Write("Deleting Categories"); //delete existing Category.Delete(x => x.CategoryID > 0); //pull the WP tags var query = from t in wp_term.All() join tt in wp_term_taxonomy.All() on t.term_id equals tt.term_id where tt.taxonomy == "category" select t; foreach (var term in query) { //add the tag to the DB Write("Adding category " + term); var c = new Category(); c.Description = term.name; c.Slug = term.slug; c.Add(); } Write("Finished importing categories **************************"); }
/// <summary> /// pulls the data for use on the home page /// </summary> /// <returns></returns> public PostViewModel GetHomePage() { var totalPosts = _repo.All<Post>().Count(); var totalComments = _repo.All<Comment>().Count(); var featured=(from p in _repo.All<Post>() where p.PublishedAt <= DateTime.Now && p.Status==PostStatus.Published select p); var subsonicCategory=new Category("SubSonic"); var subsonic = _repo.GetAssociated<Category, Post>(subsonicCategory); var opinionCat = new Category("Opinion"); var opinion = _repo.GetAssociated<Category, Post>(opinionCat); var recentComments = (from c in _repo.All<Comment>() orderby c.CreatedAt descending where c.Status==CommentStatus.Approved select c); return new PostViewModel(totalPosts, totalComments, featured, subsonic, opinion, recentComments); }
public static void Setup(int testItems) { SetTestRepo(); for(int i=0;i<testItems;i++){ Category item=new Category(); _testRepo._items.Add(item); } }
public static void Setup(Category item) { SetTestRepo(); _testRepo._items.Add(item); }