public static void AddPost(myFaceLib.Models.Post p, int publisherid, string imgdirpath) { if (p != null) { using (var db = new myFaceDAL.Entities()) { myFaceDAL.Post dbp = new myFaceDAL.Post() { postText = p.textcontent, postHeader = p.postheader, publisherId = publisherid, dislikeCount = p.dislikecount, likeCount = p.likecount, originalPostId = p.parentid, }; if (p.parentid == 0) { dbp.originalPostId = null; } db.Posts.Add(dbp); db.SaveChanges(); if (!string.IsNullOrEmpty(p.imagefname)) { AddImage(imgdirpath, p.imagefname, db.Posts.Count() == 0 ? 1:db.Posts.Count()); } db.SaveChanges(); } } else { return; } }
public static void UpdatePost(Models.Post p, string imgdirpath) { if (p != null) { using (var db = new myFaceDAL.Entities()) { myFaceDAL.Post dbpost = new myFaceDAL.Post() { postText = p.textcontent, postHeader = p.postheader, postId = p.id, publisherId = p.publisherid, dislikeCount = p.dislikecount, likeCount = p.likecount, originalPostId = p.parentid, }; var postp = db.Posts.Where(x => x.postId == dbpost.postId).First(); postp.postText = dbpost.postText; postp.postHeader = dbpost.postHeader; postp.likeCount = dbpost.likeCount; postp.dislikeCount = dbpost.dislikeCount; if (p.parentid == 0) { postp.originalPostId = null; } db.SaveChanges(); if (!string.IsNullOrEmpty(imgdirpath) && p.imagefname != db.Images.Where(x => x.postid == dbpost.postId).First().filename) { AddImage(imgdirpath, p.imagefname, postp.postId); } else { UpdateImage(db.Images.Where(x => x.postid == dbpost.postId).First().Id, p.imagefname, imgdirpath); } db.SaveChanges(); } } else { return; } }