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;
}
}
