public List <PostImageDTO> DeletePost(int ID)
{
List <PostImageDTO> dtoList = new List <PostImageDTO>();
using (POSTDATAEntities db = new POSTDATAEntities())
{
Post post = db.Posts.First(x => x.ID == ID);
post.isDeleted = true;
post.DeletedDate = DateTime.Now;
post.LastUpdateDate = DateTime.Now;
post.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
List <PostImage> imageList = db.PostImages.Where(x => x.PostID == ID).ToList();
foreach (PostImage item in imageList)
{
PostImageDTO dto = new PostImageDTO();
dto.ImagePath = item.ImagePath;
item.isDeleted = true;
item.DeletedDate = DateTime.Now;
item.LastUpdateDate = DateTime.Now;
item.LastUpdateUserID = UserStatic.UserID;
dtoList.Add(dto);
}
db.SaveChanges();
}
return(dtoList);
}
public int AddTag(PostTag item)
{
using (POSTDATAEntities db = new POSTDATAEntities()) // Close the connection to speed up the project
{
db.PostTags.Add(item);
db.SaveChanges();
}
return(item.ID);
}
public int AddTag(PostTag item)
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
db.PostTags.Add(item);
db.SaveChanges();
}
return(item.ID);
}
public void DeleteComment(int ID)
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
Comment comment = db.Comments.First(x => x.ID == ID);
comment.isDeleted = true;
comment.DeletedDate = DateTime.Now;
comment.LastUpdateDate = DateTime.Now;
comment.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
}
}
public void ApproveComment(int ID)
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
Comment cmt = db.Comments.First(x => x.ID == ID);
cmt.isApproved = true;
cmt.ApproveUserID = UserStatic.UserID;
cmt.ApproveDate = DateTime.Now;
cmt.LastUpdateDate = DateTime.Now;
cmt.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
}
}
public List <PostImageDTO> DeletePost(int iD)
{
try
{
List <PostImageDTO> imageListDTO = new List <PostImageDTO>();
using (POSTDATAEntities db = new POSTDATAEntities())
{
Post post = db.Posts.First(x => x.ID == iD);
post.isDeleted = true;
post.DeletedDate = DateTime.Now;
post.LastUpdateDate = DateTime.Now;
post.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
List <PostImage> imageList = db.PostImages.Where(x => x.PostID == iD).ToList();
foreach (var item in imageList)
{
PostImageDTO dto = new PostImageDTO();
dto.ImagePath = item.ImagePath;
item.isDeleted = true;
item.DeletedDate = DateTime.Now;
item.LastUpdateDate = DateTime.Now;
item.LastUpdateUserID = UserStatic.UserID;
imageListDTO.Add(dto);
}
db.SaveChanges();
}
return(imageListDTO);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTags(int PostID)
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
List <PostTag> tagList = db.PostTags.Where(x => x.isDeleted == false && x.PostID == PostID).ToList();
foreach (var item in tagList)
{
item.isDeleted = true;
item.DeletedDate = DateTime.Now;
item.LastUpdateDate = DateTime.Now;
item.LastUpdateUserID = UserStatic.UserID;
}
db.SaveChanges();
}
}
public void AddComment(Comment comment)
{
try
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
db.Comments.Add(comment);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int AddTag(PostTag tag)
{
try
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
db.PostTags.Add(tag);
db.SaveChanges();
}
return(tag.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddImage(PostImage image)
{
try
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
db.PostImages.Add(image);
db.SaveChanges();
}
return(image.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddPost(Post post)
{
try
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
db.Posts.Add(post);
db.SaveChanges();
}
return(post.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteComment(int iD)
{
try
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
Comment comment = db.Comments.First(x => x.ID == iD);
comment.isDeleted = true;
comment.DeletedDate = DateTime.Now;
comment.LastUpdateDate = DateTime.Now;
comment.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePost(PostDTO model)
{
using (POSTDATAEntities db = new POSTDATAEntities())
{
Post post = db.Posts.First(x => x.ID == model.ID);
post.Title = model.Title;
post.Area1 = model.Area1;
post.Area2 = model.Area2;
post.Area3 = model.Area3;
post.CategoryID = model.CategoryID;
post.LanguageName = model.LanguageName;
post.LastUpdateDate = DateTime.Now;
post.LastUpdateUserID = UserStatic.UserID;
post.Notification = model.Notification;
post.PostContent = model.PostContent;
post.SeoLink = model.SeoLink;
post.ShortContent = model.ShortContent;
post.Slider = model.Slider;
db.SaveChanges();
}
}
public string DeletePostImage(int ID)
{
try
{
string imagePath = "";
using (POSTDATAEntities db = new POSTDATAEntities())
{
PostImage img = db.PostImages.First(x => x.ID == ID);
imagePath = img.ImagePath;
img.isDeleted = true;
img.DeletedDate = DateTime.Now;
img.LastUpdateDate = DateTime.Now;
img.LastUpdateUserID = UserStatic.UserID;
db.SaveChanges();
}
return(imagePath);
}
catch (Exception ex)
{
throw ex;
}
}
