Beispiel #1
0
        public List <CommentDTO> GetComments()
        {
            List <CommentDTO> dtoList = new List <CommentDTO>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                var list = (from c in db.Comments.Where(x => x.isDeleted == false && x.isApproved == false)
                            join p in db.Posts on c.PostID equals p.ID
                            select new
                {
                    ID = c.ID,
                    PostID = p.ID,
                    PostTitle = p.Title,
                    Email = c.Email,
                    Content = c.CommentContent,
                    AddDate = c.AddDate,
                }).OrderByDescending(x => x.AddDate).ToList();

                foreach (var item in list)
                {
                    CommentDTO dto = new CommentDTO();
                    dto.ID             = item.ID;
                    dto.PostID         = item.PostID;
                    dto.PostTitle      = item.PostTitle;
                    dto.Email          = item.Email;
                    dto.CommentContent = item.Content;
                    dto.AddDate        = item.AddDate;
                    dtoList.Add(dto);
                }
            }
            return(dtoList);
        }
Beispiel #2
0
 public int GetMessageCount()
 {
     using (POSTDATAEntities db = new POSTDATAEntities())
     {
         return(db.Contacts.Where(x => x.isDeleted == false && x.isRead == false).Count());
     }
 }
Beispiel #3
0
        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);
        }
Beispiel #4
0
 public List <PostTag> GetPostTagsWithPostID(int postID)
 {
     using (POSTDATAEntities db = new POSTDATAEntities())
     {
         return(db.PostTags.Where(x => x.isDeleted == false && x.PostID == postID).ToList());
     }
 }
Beispiel #5
0
        public List <PostDTO> GetPosts()
        {
            List <PostDTO> dtoList = new List <PostDTO>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                var postList = (from p in db.Posts.Where(x => x.isDeleted == false)
                                join c in db.Categories on p.CategoryID equals c.ID
                                select new
                {
                    ID = p.ID,
                    Title = p.Title,
                    CategoryName = c.CategoryName,
                    AddDate = p.AddDate
                }).OrderByDescending(x => x.AddDate).ToList();

                foreach (var item in postList)
                {
                    PostDTO dto = new PostDTO();
                    dto.ID           = item.ID;
                    dto.Title        = item.Title;
                    dto.CategoryName = item.CategoryName;
                    dto.AddDate      = item.AddDate;
                    dtoList.Add(dto);
                }
            }
            return(dtoList);
        }
Beispiel #6
0
        public List <PostDTO> GetHotNews()
        {
            List <PostDTO> dtoList = new List <PostDTO>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                var postList = (from p in db.Posts.Where(x => x.isDeleted == false && x.Area1 == true)
                                select new
                {
                    ID = p.ID,
                    Title = p.Title,
                    CategoryName = p.Category.CateogryName,
                    AddDate = p.AddDate,
                    SeoLink = p.SeoLink
                }).OrderByDescending(x => x.AddDate).Take(8).ToList();
                foreach (var item in postList)
                {
                    PostDTO dto = new PostDTO();
                    dto.Title        = item.Title;
                    dto.ID           = item.ID;
                    dto.CategoryName = item.CategoryName;
                    dto.AddDate      = item.AddDate;
                    dto.SeoLink      = item.SeoLink;
                    dtoList.Add(dto);
                }
            }
            return(dtoList);
        }
Beispiel #7
0
 public int GetCommentCount()
 {
     using (POSTDATAEntities db = new POSTDATAEntities())
     {
         return(db.Comments.Where(x => x.isDeleted == false && x.isApproved == false).Count());
     }
 }
Beispiel #8
0
 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);
 }
Beispiel #10
0
        public List <PostTag> GetTagsByPostId(int iD)
        {
            List <PostTag> list = new List <PostTag>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                list = db.PostTags.Where(x => x.isDeleted == false && x.PostID == iD).ToList();
            }
            return(list);
        }
Beispiel #11
0
 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();
     }
 }
Beispiel #12
0
        public CountDTO GetAllCounts()
        {
            CountDTO dto = new CountDTO();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                dto.CommentCount = db.Comments.Where(x => x.isDeleted == false).Count();
                dto.MessageCount = db.Contacts.Where(x => x.isDeleted == false).Count();
                dto.PostCount    = db.Posts.Where(x => x.isDeleted == false).Count();
                dto.ViewCount    = db.Posts.Where(x => x.isDeleted == false).Sum(x => x.ViewCount);
            }
            return(dto);
        }
 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();
     }
 }
Beispiel #14
0
 public void AddComment(Comment comment)
 {
     try
     {
         using (POSTDATAEntities db = new POSTDATAEntities())
         {
             db.Comments.Add(comment);
             db.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #15
0
 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();
     }
 }
Beispiel #16
0
 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;
     }
 }
Beispiel #17
0
 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;
     }
 }
Beispiel #18
0
 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;
     }
 }
Beispiel #19
0
        public List <PostImageDTO> GetPostImagesWithPostID(int postID)
        {
            List <PostImageDTO> dtoList = new List <PostImageDTO>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                List <PostImage> list = db.PostImages.Where(x => x.isDeleted == false && x.PostID == postID).ToList();
                foreach (PostImage item in list)
                {
                    PostImageDTO dto = new PostImageDTO();
                    dto.ID        = item.ID;
                    dto.ImagePath = item.ImagePath;
                    dtoList.Add(dto);
                }
            }
            return(dtoList);
        }
Beispiel #20
0
        public List <PostImageDTO> GetPostImagesByPostId(int iD)
        {
            List <PostImageDTO> imageListDTO = new List <PostImageDTO>();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                List <PostImage> imageList = db.PostImages.Where(x => x.isDeleted == false && x.PostID == iD).ToList();

                foreach (var item in imageList)
                {
                    PostImageDTO dto = new PostImageDTO();
                    dto.ID        = item.ID;
                    dto.ImagePath = item.ImagePath;
                    imageListDTO.Add(dto);
                }
            }
            return(imageListDTO);
        }
Beispiel #21
0
 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;
     }
 }
Beispiel #22
0
 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();
     }
 }
Beispiel #23
0
 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;
     }
 }
Beispiel #24
0
        public PostDTO GetPostById(int iD)
        {
            PostDTO dto = new PostDTO();

            using (POSTDATAEntities db = new POSTDATAEntities())
            {
                Post post = db.Posts.First(x => x.ID == iD);
                dto.ID           = post.ID;
                dto.Title        = post.Title;
                dto.ShortContent = post.ShortContent;
                dto.PostContent  = post.PostContent;
                dto.LanguageName = post.LanguageName;
                dto.Notification = post.Notification;
                dto.SeoLink      = post.SeoLink;
                dto.Slider       = post.Slider;
                dto.Area1        = post.Area1;
                dto.Area2        = post.Area2;
                dto.Area3        = post.Area3;
                dto.CategoryID   = post.CategoryID;
            }
            return(dto);
        }
Beispiel #25
0
        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;
            }
        }