public void Test_PostRepository_FindAllOrderByWithoutPaging()
{
PostQueryRequest request = new PostQueryRequest();
request.TopicId = 1000;
request.CreationDateTimeParam.CreationDateTimeOperator = Operator.LessThanEqual;
request.CreationDateTimeParam.CreationDateTime = DateTimeUtils.ToDateTime("2015-1-22").Value;
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService <IRepositoryContext>())
{
IRepository <Post> postRepository = repositoryContext.GetRepository <Post>();
Expression <Func <Post, bool> > dateTimeExpression = (p) => true;
//DateTime dt = request.CreationDateTimeParam.CreationDateTime;
switch (request.CreationDateTimeParam.CreationDateTimeOperator)
{
case Operator.LessThanEqual:
dateTimeExpression = p => p.CreationDateTime <= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.GreaterThanEqual:
dateTimeExpression = p => p.CreationDateTime >= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.Equal:
dateTimeExpression = p => p.CreationDateTime.Equals(request.CreationDateTimeParam.CreationDateTime);
break;
}
QueryBuilder <Post> postQueryBuilder = new QueryBuilder <Post>();
//int topicId = request.TopicId;
postQueryBuilder.And(p => p.TopicId == request.TopicId).And(dateTimeExpression);
IEnumerable <Post> posts = postRepository.FindAll(postQueryBuilder.QueryPredicate);
IList <PostDataObject> postDataObjects = new List <PostDataObject>();
foreach (Post post in posts)
{
var postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
Assert.AreEqual(5, postDataObjects.Count);
}
}
public void Test_PostRepository_FindAllOrderByWithoutPaging()
{
PostQueryRequest request = new PostQueryRequest();
request.TopicId = 1000;
request.CreationDateTimeParam.CreationDateTimeOperator = Operator.LessThanEqual;
request.CreationDateTimeParam.CreationDateTime = DateTimeUtils.ToDateTime("2015-1-22").Value;
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService<IRepositoryContext>())
{
IRepository<Post> postRepository = repositoryContext.GetRepository<Post>();
Expression<Func<Post, bool>> dateTimeExpression = (p) => true;
//DateTime dt = request.CreationDateTimeParam.CreationDateTime;
switch (request.CreationDateTimeParam.CreationDateTimeOperator)
{
case Operator.LessThanEqual:
dateTimeExpression = p => p.CreationDateTime <= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.GreaterThanEqual:
dateTimeExpression = p => p.CreationDateTime >= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.Equal:
dateTimeExpression = p => p.CreationDateTime.Equals(request.CreationDateTimeParam.CreationDateTime);
break;
}
QueryBuilder<Post> postQueryBuilder = new QueryBuilder<Post>();
//int topicId = request.TopicId;
postQueryBuilder.And(p => p.TopicId == request.TopicId).And(dateTimeExpression);
IEnumerable<Post> posts = postRepository.FindAll(postQueryBuilder.QueryPredicate);
IList<PostDataObject> postDataObjects = new List<PostDataObject>();
foreach (Post post in posts)
{
var postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
Assert.AreEqual(5, postDataObjects.Count);
}
}
public IEnumerable <DataObjects.PostDataObject> GetPostsByQueryRequest(PostQueryRequest request)
{
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService <IRepositoryContext>())
{
IRepository <Post> postRepository = repositoryContext.GetRepository <Post>();
Expression <Func <Post, bool> > dateTimeExpression = (p) => true;
switch (request.CreationDateTimeParam.CreationDateTimeOperator)
{
case Operator.LessThanEqual:
dateTimeExpression = p => p.CreationDateTime <= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.GreaterThanEqual:
dateTimeExpression = p => p.CreationDateTime >= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.Equal:
default:
dateTimeExpression = p => p.CreationDateTime.Equals(request.CreationDateTimeParam.CreationDateTime);
break;
}
QueryBuilder <Post> postQueryBuilder = new QueryBuilder <Post>();
postQueryBuilder.And(p => p.TopicId == request.TopicId).And(dateTimeExpression);
IEnumerable <Post> posts = postRepository.FindAll(postQueryBuilder.QueryPredicate);
IList <PostDataObject> postDataObjects = new List <PostDataObject>();
foreach (Post post in posts)
{
var postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
return(postDataObjects);
}
}
public IEnumerable<PostDataObject> GetPostsByQueryRequest(PostQueryRequest request)
{
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService<IRepositoryContext>())
{
IRepository<Post> postRepository = repositoryContext.GetRepository<Post>();
Expression<Func<Post, bool>> dateTimeExpression = (p) => true;
switch (request.CreationDateTimeParam.CreationDateTimeOperator)
{
case Operator.LessThanEqual:
dateTimeExpression = p => p.CreationDateTime <= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.GreaterThanEqual:
dateTimeExpression = p => p.CreationDateTime >= request.CreationDateTimeParam.CreationDateTime;
break;
case Operator.Equal:
default:
dateTimeExpression = p => p.CreationDateTime.Equals(request.CreationDateTimeParam.CreationDateTime);
break;
}
QueryBuilder<Post> postQueryBuilder = new QueryBuilder<Post>();
postQueryBuilder.And(p => p.TopicId == request.TopicId).And(dateTimeExpression);
IEnumerable<Post> posts = postRepository.FindAll(postQueryBuilder.QueryPredicate);
IList<PostDataObject> postDataObjects = new List<PostDataObject>();
foreach (Post post in posts)
{
var postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
return postDataObjects;
}
}
public IEnumerable <PostDataObject> GetPosts()
{
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService <IRepositoryContext>())
{
IRepository <Post> postRepository = repositoryContext.GetRepository <Post>();
IEnumerable <Post> posts = postRepository.FindAll();
IList <PostDataObject> postDataObjects = new List <PostDataObject>();
foreach (Post post in posts)
{
PostDataObject postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
return(postDataObjects);
}
}
public IEnumerable<PostDataObject> GetPosts()
{
using (IRepositoryContext repositoryContext = ServiceLocator.Instance.GetService<IRepositoryContext>())
{
IRepository<Post> postRepository = repositoryContext.GetRepository<Post>();
IEnumerable<Post> posts = postRepository.FindAll();
IList<PostDataObject> postDataObjects = new List<PostDataObject>();
foreach (Post post in posts)
{
PostDataObject postDataObject = new PostDataObject();
postDataObject.MapFrom(post);
postDataObjects.Add(postDataObject);
}
return postDataObjects;
}
}
