public ActionResult Index(DraftPostVM model) { var blogPost = new BlogPost(); blogPost = model.NewPost; blogPost.PostContent = model.HtmlContent; if (model.NewPost.Status == null) { blogPost.Status = new Status() { StatusID = 1 }; } else { blogPost.Status.StatusID = model.NewPost.Status.StatusID; } var ops = OperationsFactory.CreateBlogPostOps(); var categoryOps = OperationsFactory.CreateCategoryOps(); ops.SaveBlogPost(blogPost); categoryOps.SaveBlogPostCategory(model.SelectedCategoryIds,blogPost); return RedirectToAction("Index","Home"); }
public void SaveBlogPostHashtags(List<int> hashtagIds, BlogPost blog) { var ops = OperationsFactory.CreateBlogPostOps(); var list = ops.GetAllBlogPosts(); var lastPost = list.FirstOrDefault(x => x.PostTitle == blog.PostTitle); if (lastPost != null) _repo.SaveBlogPostHashtags(hashtagIds, lastPost.BlogPostID); }
public ActionResult Create(BlogPost blog) { try { // TODO: Add insert logic here return RedirectToAction("Index"); } catch { return View(); } }
public void SaveBlogPostDbTest() { var ops = OperationsFactory.CreateBlogPostOps(); BlogPost blog = new BlogPost() { DateOfPost = DateTime.Now, PostContent = "<p>Hello Lovely</p>", PostTitle = "Blog One", Status = new Status() { StatusID = 1 } }; ops.SaveBlogPost(blog); var list = ops.GetAllBlogPosts(); Assert.AreEqual(1,list.Count); }
public void SaveBlogPostDBTest() { var repo = new BlogPostRepo(); BlogPost blog = new BlogPost() { PostContent = "<p>Hello Everyone</p>", PostTitle = "Blog More", Status = new Status(){StatusID = 1}, //UserID = "f319beb5-8a14-40c1-9cb5-0d6c92571ae4", DateOfPost = DateTime.Now }; repo.SaveBlogPost(blog); var list = repo.GetAllBlogPosts(); Assert.AreEqual(6,list.Count); Assert.AreEqual("Blog One", list.FirstOrDefault(x=>x.BlogPostID == 1).PostTitle); }
public void EditBlogPost(BlogPost blog) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand( "UPDATE [dbo].[BlogPost]" + "SET [PostContent] = @PostContent," + "[StatusID] = @StatusId," + "[DateOfPost] = @DateOfPost," + "[PostTitle] = @PostTitle" + "WHERE [BlogPostID] = @BlogPostId)"); cmd.Parameters.AddWithValue("@PostContent", blog.PostContent); cmd.Parameters.AddWithValue("@StatusId", blog.Status); cmd.Parameters.AddWithValue("@DateOfPost", blog.DateOfPost); cmd.Parameters.AddWithValue("@PostTitle", blog.PostTitle); cn.Open(); cmd.ExecuteNonQuery(); } }
public List<BlogPost> GetAllBlogPosts() { var blogPosts = new List<BlogPost>(); using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand("Select b.UserID, b.PostContent,b.StatusID,s.StatusType, b.DateOfPost, b.PostTitle, b.BlogPostID from Blogpost b inner join [Status] s on b.StatusID= s.StatusID order by b.DateOfPost desc", cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var blog = new BlogPost() { Status = new Status(), User = new User() }; blog.User.UserId = dr.GetString(0); blog.PostContent = dr.GetString(1); blog.Status.StatusID = dr.GetInt32(2); blog.Status.StatusType = dr.GetString(3); blog.DateOfPost = dr.GetDateTime(4); blog.PostTitle = dr.GetString(5); blog.BlogPostID = dr.GetInt32(6); blogPosts.Add(blog); } } } var repo = new UserRepo(); foreach (var blog in blogPosts) { var id = blog.User.UserId; blog.User = repo.GetUserById(id); blog.User.UserId = id; } return blogPosts; }
public ActionResult Edit(int id, EditPostVM model) { try { var blogPost = new BlogPost(); blogPost = model.EditPost; blogPost.BlogPostID = id; blogPost.PostContent = model.HtmlContent; if (model.EditPost.Status == null) { blogPost.Status = new Status() { StatusID = 1 }; } else { blogPost.Status.StatusID = model.EditPost.Status.StatusID; } var ops = OperationsFactory.CreateBlogPostOps(); var categoryOps = OperationsFactory.CreateCategoryOps(); ops.SaveBlogPost(blogPost); categoryOps.SaveBlogPostCategory(model.SelectedCategoryIds, blogPost); return RedirectToAction("Index", "ContentManager"); } catch { return RedirectToAction("Index", "ContentManager"); } }
public ActionResult Edit(int id, BlogPost blog) { try { // TODO: Add update logic here return RedirectToAction("Index"); } catch { return View(); } }
public void SaveBlogPost(BlogPost blog) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("@UserId", blog.User.UserId); p.Add("@PostContent", blog.PostContent); p.Add("@StatusID", blog.Status.StatusID); p.Add("@DateOfPost", blog.DateOfPost); p.Add("@PostTittle", blog.PostTitle); if (blog.BlogPostID > 0) { p.Add("@BlogPostId", blog.BlogPostID); cn.Execute("UpdateBlogPost", p, commandType: CommandType.StoredProcedure); } else { cn.Query("SubmitNewBlogPost", p, commandType: CommandType.StoredProcedure); } } }
public void SaveBlogPost(BlogPost blog) { }
public BlogPost GetBlogPostById(int blogPostId) { //var singleBlogPost = new BlogPost(); var blogPosts = new List<BlogPost>(); using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand("Select b.UserID, b.PostContent,b.StatusID,s.StatusType, b.DateOfPost, b.PostTitle, b.BlogPostID from Blogpost b inner join [Status] s on b.StatusID= s.StatusID order by b.DateOfPost desc", cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var blog = new BlogPost() { Status = new Status(), User = new User() }; blog.User.UserId = dr.GetString(0); blog.PostContent = dr.GetString(1); blog.Status.StatusID = dr.GetInt32(2); blog.Status.StatusType = dr.GetString(3); blog.DateOfPost = dr.GetDateTime(4); blog.PostTitle = dr.GetString(5); blog.BlogPostID = dr.GetInt32(6); blogPosts.Add(blog); } } } //var repo = new UserRepo(); //foreach (var blog in blogPosts) //{ // var id = blog.User.UserId; // blog.User = repo.GetUserById(id); // blog.User.UserId = id; //} //singleBlogPost = blogPosts.FirstOrDefault(bp => bp.BlogPostID == blogPostId); //return singleBlogPost; return null; }
public BlogPost GetBlogPostById(int blogPostId) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand("Select b.UserID, b.PostContent,b.StatusID,s.StatusType, b.DateOfPost, b.PostTitle, b.BlogPostID from Blogpost b inner join [Status] s on b.StatusID= s.StatusID where b.BlogPostID = BlogPostID order by b.DateOfPost desc", cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var blog = new BlogPost() { Status = new Status(), User = new User() }; blog.User.UserId = dr.GetString(0); blog.PostContent = dr.GetString(1); blog.Status.StatusID = dr.GetInt32(2); blog.Status.StatusType = dr.GetString(3); blog.DateOfPost = dr.GetDateTime(4); blog.PostTitle = dr.GetString(5); blog.BlogPostID = dr.GetInt32(6); return blog; } } } //var repo = new UserRepo(); //{ // var id = blog.User.UserId; // blog.User = repo.GetUserById(id); // blog.User.UserId = id; //} return null; }
public void SaveBlogPost(BlogPost blog) { if (blog.DateOfPost > new DateTime(01 / 01 / 2000)) _repo.SaveBlogPost(blog); }
public void EditBlogPost(BlogPost blog) { _repo.EditBlogPost(blog); }
public List<BlogPost> ListAllBlogsInCategoryByCategoryId(int categoryId) { var blogPosts = new List<BlogPost>(); using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand("select bp.UserID, bp.PostContent,bp.StatusID, s.StatusType,bp.DateOfPost,bp.PostTitle,bp.BlogPostID,u.UserName, u.FirstName,u.LastName from BlogPost bp inner join PostCategories pc on bp.BlogPostID = pc.BlogPostID inner join CategoryOfPost cp on cp.CategoryID = pc.CategoryID inner join AspNetUsers u on u.Id = bp.UserID inner join [Status] s on s.StatusID = bp.StatusID where pc.CategoryID =@catId order by bp.DateOfPost desc", cn); cmd.Parameters.AddWithValue("@catId", categoryId); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var blog = new BlogPost() { Status = new Status(), User = new User() }; blog.User.UserId = dr.GetString(0); blog.PostContent = dr.GetString(1); blog.Status.StatusID = dr.GetInt32(2); blog.Status.StatusType = dr.GetString(3); blog.DateOfPost = dr.GetDateTime(4); blog.PostTitle = dr.GetString(5); blog.BlogPostID = dr.GetInt32(6); blog.User.UserName = dr.GetString(7); blog.User.FirstName = dr.GetString(8); blog.User.LastName = dr.GetString(9); blogPosts.Add(blog); } } } return blogPosts; }
public void EditBlogPost(BlogPost blog) { throw new NotImplementedException(); }