public List <CommentDto> GetCommentsWithUserInformation()
{
var result = new List <CommentDto>();
using (var context = new MyBlogDbContext())
{
result = context.Comments.Include(x => x.Post).Include(x => x.AspNetUsers).Select(item => new CommentDto()
{
//AspNetUsers=item.AspNetUsers, //TODO EKLENECEK:
//Post=item.Post,
CommentDate = item.CommentDate,
Content = item.Content,
Id = item.Id,
IsActive = item.IsActive,
UserCommentDto = new UserCommentDto()
{
CitizenshipNumber = item.AspNetUsers.CitizenshipNumber,
Email = item.AspNetUsers.Email,
FirstName = item.AspNetUsers.FirstName,
Id = item.AspNetUsers.Id
},
PostCommentDto = new PostCommentDto()
{
Id = item.Post.Id,
Title = item.Post.Title
}
}).ToList();
}
return(result);
}
public List <CommentDto> GetListWithUserInformation(Expression <Func <Comment, bool> > expression)
{
var result = new List <CommentDto>();
using (var context = new MyBlogDbContext())
{
result = context.Comments.Include(x => x.AspNetUsers).Select(item => new CommentDto()
{
CommentDate = item.CommentDate,
Content = item.Content,
Id = item.Id,
IsActive = item.IsActive,
PostId = item.PostId,
UserId = item.UserId,
UserCommentDto = new UserCommentDto()
{
Id = item.AspNetUsers.Id,
FirstName = item.AspNetUsers.FirstName,
Email = item.AspNetUsers.Email,
CitizenshipNumber = item.AspNetUsers.CitizenshipNumber
}
}).ToList();
}
return(result);
}
public List <PostDto> GetPostsWithUserInformation()
{
var result = new List <PostDto>();
using (var context = new MyBlogDbContext())
{
result = context.Posts.Include(y => y.Category).Include(x => x.AspNetUsers).Select(item => new PostDto {
CreationDate = item.CreationDate,
Content = item.Content,
Id = item.Id,
IsActive = item.IsActive,
Title = item.Title,
ReadCount = item.ReadCount,
Voting = item.Voting,
PostsUser = new PostsUserDto()
{
Id = item.AspNetUsers.Id,
UserName = item.AspNetUsers.UserName
},
Category = new CategoryDto()
{
CategoryName = item.Category.CategoryName,
Id = item.Category.Id,
ParentCategoryId = item.Category.ParentCategoryId
},
CategoryId = item.CategoryId,
}).ToList();
}
return(result);
}
public List <UserDto> GetUsersWithUserRoles()
{
var result = new List <UserDto>();
using (var context = new MyBlogDbContext())
{
}
return(result);
}
public List <Comment> GetListWithUserInformation(Expression <Func <Comment, bool> > expression)
{
var result = new List <Comment>();
using (var context = new MyBlogDbContext())
{
result = context.Comments.Include(x => x.AspNetUsers).Where(expression).Select(item => new Comment()
{
CommentDate = item.CommentDate,
Content = item.Content,
Id = item.Id,
IsActive = item.IsActive,
PostId = item.PostId,
AspNetUsers = item.AspNetUsers,
UserId = item.UserId
}).ToList();
}
return(result);
}