public ActionResult DeletePost(Post post)
{
//if (ModelState.IsValid)
{
var manager = new AdminManager();
manager.DeletePost(post);
}
return RedirectToAction("Index", "Home");
}
public ActionResult EditPost(Post post)
{
//if (ModelState.IsValid)
{
var manager = new AdminManager();
post.PostDate = DateTime.Now;
post.PostCategory.CategoryName = manager.GetCategoryByID(post.PostCategory.CategoryID).CategoryName;
manager.EditPost(post);
}
return RedirectToAction("Index", "Home");
}
public ActionResult CreatePost(Post post)
{
var manager = new AdminManager();
var postCount = manager.GetAllPosts().Count;
post.PostCategory.CategoryName = manager.GetCategoryByID(post.PostCategory.CategoryID).CategoryName;
post.PostDate = DateTime.Now;
post.Status = ApprovalStatus.Pending;
if (postCount == 0)
{
post.PostID = 1;
}
else
post.PostID = manager.GetAllPosts().Count + 1;
manager.AddPost(post);
return RedirectToAction("SubordinateIndex", "Subordinate");
}
public void EditPost(Post post)
{
post.User = new User();
using (SqlConnection cn = new SqlConnection(_connectionString))
{
var p = new DynamicParameters();
p.Add("PostID", post.PostID);
p.Add("UserID", post.User.UserID);
p.Add("CategoryID", post.PostCategory.CategoryID);
p.Add("PostTitle", post.PostTitle);
p.Add("PostSubTitle", post.PostSubtitle);
p.Add("PostBody", post.PostBody);
p.Add("PostStatus", post.Status);
p.Add("PostDate", post.PostDate.ToShortDateString());
cn.Execute("UpdateBlogPost", p,
commandType: CommandType.StoredProcedure);
}
}
public void AddPost(Post post)
{
var taglist = new List<Tag>();
var posttags = post.placeholderText;
if (GetAllPosts().Count != 0)
{
post.PostID = GetAllPosts().LastOrDefault().PostID + 1;
}
else
{
post.PostID = 1;
}
if (post.placeholderText != null)
{
taglist = _postRepo.AddTagToPost(posttags, post.PostID);
post.PostTags = taglist;
}
post.PostDate = DateTime.Now;
_postRepo.AddPost(post);
}
public void CanAddPost()
{
var manager = new AdminManager();
var postCount = manager.GetAllPosts().Count;
var toAdd = new Post();
toAdd.PostCategory = new Category();
toAdd.PostID = postCount + 1;
toAdd.PostTitle = "Test Title";
toAdd.PostBody = "Post body";
toAdd.PostCategory.CategoryID = 1;
toAdd.Status = ApprovalStatus.Approved;
toAdd.PostDate = DateTime.Now;
toAdd.PostTags = new List<Tag>();
toAdd.User = new User();
manager.AddPost(toAdd);
var manager2 = new AdminManager();
var postCount2 = manager2.GetAllPosts().Count;
Assert.AreEqual(postCount + 1, postCount2);
}
public void EditPost(Post post)
{
var taglist = new List<Tag>();
var posttags = post.placeholderText;
_tagRepo.DeletePostTagsById(post.PostID);
if (posttags != null)
{
taglist = _postRepo.AddTagToPost(posttags, post.PostID);
}
_postRepo.EditPost(post);
}
public void DenyPost(Post post)
{
post.Status = ApprovalStatus.Denied;
}
public void DeletePost(Post post)
{
_postRepo.DeletePost(post.PostID);
_tagRepo.DeletePostTagsById(post.PostID);
}
public void ApprovePost(Post post)
{
post.Status = ApprovalStatus.Approved;
}
public void AddPost(Post post)
{
_posts.Add(post);
}
public void EditPost(Post post)
{
var selectedPost = _posts.FirstOrDefault(p => p.PostID == post.PostID);
selectedPost.PostID = post.PostID;
selectedPost.User = post.User;
selectedPost.PostTitle = post.PostTitle;
selectedPost.PostBody = post.PostBody;
selectedPost.PostCategory = post.PostCategory;
selectedPost.Status = post.Status;
//selectedPost.PostTags = post.PostTags;
selectedPost.PostDate = DateTime.Now;
selectedPost.placeholderText = post.placeholderText;
}
public Post PopulateFromDataReader(SqlDataReader dr)
{
string statusCheck;
Post post = new Post();
post.PostCategory = new Category();
post.PostID = (int) dr["PostID"];
post.PostTitle = dr["PostTitle"].ToString();
post.PostCategory.CategoryID = (int) dr["CategoryID"];
post.PostBody = dr["PostBody"].ToString();
post.PostDate = (DateTime) dr["PostDate"];
// post.Status = Enum.Parse(typeof(ApprovalStatus), dr["PostStatus"]);
statusCheck = dr["PostStatus"].ToString();
post.Status = (ApprovalStatus)Enum.Parse(typeof(ApprovalStatus), statusCheck);
return post;
}
public Post GetPostById(int id)
{
var tagRepo = new TagRepo();
var catRepo = new CategoryRepo();
var post = new Post();
using (SqlConnection cn = new SqlConnection(_connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT * From Post p INNER JOIN Categories c ON p.CategoryID = c.CategoryID WHERE p.PostID ="+id;
cmd.Connection = cn;
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
post = (PopulateFromDataReader(dr));
}
}
// Get Tags for post and populate string placeholder
post.PostTags = tagRepo.GetTagsByPostId(post.PostID);
string tags = "";
foreach (var tag in post.PostTags)
{
tags += tag.TagName + ",";
}
if (tags.Length > 0)
{
post.placeholderText = tags.Substring(0, tags.Length - 1);
}
post.PostCategory = catRepo.GetCategoryByID(post.PostCategory.CategoryID);
return post;
}
