public DalTopicTag Get(Expression<Func<DalTopicTag, bool>> filter)
{
var query = _dbSetTopicTags;
return filter != null
? query.Where(filter.TypeConvert<DalTopicTag, TopicTag>()).SingleOrDefault().ToDalTopicTag()
: default(DalTopicTag);
}
public DalPost Get(Expression<Func<DalPost, bool>> filter)
{
var query = _dbSetPosts.Include(p => p.MembershipUser);
return filter != null
? query.Where(filter.TypeConvert<DalPost, Post>()).SingleOrDefault().ToDalPost()
: default(DalPost);
}
public DalCategory Get(Expression<Func<DalCategory, bool>> filter)
{
var query = _dbSetCategories.Include(c=>c.Topics);
return filter != null
? query.Where(filter.TypeConvert<DalCategory, Category>()).SingleOrDefault().ToDalCategory()
: default(DalCategory);
}
public DalMembershipUser Get(Expression<Func<DalMembershipUser, bool>> filter)
{
var query = _dbSetUsers.Include(x=>x.MembershipRoles);
if (filter != null)
{
return query.Where(filter.TypeConvert<DalMembershipUser,MembershipUser>()).SingleOrDefault().ToDalUser();
}
return default(DalMembershipUser);
}
public DalMembershipRole Get(Expression<Func<DalMembershipRole, bool>> filter)
{
var query = _dbSetRoles;
if (filter != null)
{
return
query.Where(filter.TypeConvert<DalMembershipRole, MembershipRole>()).SingleOrDefault().ToDalRole();
}
return default(DalMembershipRole);
}
public IEnumerable<DalPost> GetMany(Expression<Func<DalPost, bool>> filter)
{
IQueryable<Post> query = _dbSetPosts.Include(p => p.MembershipUser);
if (filter == null)
{
return query.ToList().Select(user => user.ToDalPost());
}
return
query.Where(filter.TypeConvert<DalPost, Post>())
.ToList()
.Select(user => user.ToDalPost());
}
public IEnumerable<DalTopicTag> GetMany(Expression<Func<DalTopicTag, bool>> filter)
{
IQueryable<TopicTag> query = _dbSetTopicTags;
if (filter == null)
{
return query.ToList().Select(user => user.ToDalTopicTag());
}
return
query.Where(filter.TypeConvert<DalTopicTag, TopicTag>())
.ToList()
.Select(user => user.ToDalTopicTag());
}
public DalTopic Get(Expression<Func<DalTopic, bool>> filter)
{
var query = _dbSetTopics
.Include(t => t.Posts)
.Include(t => t.TopicTags)
.Include(t => t.MembershipUser);
if (filter != null)
{
var result =
query.Where(filter.TypeConvert<DalTopic, Topic>()).SingleOrDefault();
return result.ToDalTopic();
}
return default(DalTopic);
}
public IEnumerable<DalMembershipRole> GetMany(Expression<Func<DalMembershipRole, bool>> filter)
{
IQueryable<MembershipRole> query = _dbSetRoles;
if (filter == null)
{
return query.ToList().Select(user => user.ToDalRole());
}
return
query.Where(filter.TypeConvert<DalMembershipRole, MembershipRole>())
.ToList()
.Select(user => user.ToDalRole());
}
public IEnumerable<DalCategory> GetMany(Expression<Func<DalCategory, bool>> filter)
{
IQueryable<Category> query = _dbSetCategories.Include(c => c.Topics);
if (filter == null)
{
return query.ToList().Select(user => user.ToDalCategory());
}
return
query.Where(filter.TypeConvert<DalCategory, Category>())
.ToList()
.Select(user => user.ToDalCategory());
}
public IEnumerable<DalMembershipUser> GetMany(Expression<Func<DalMembershipUser, bool>> filter)
{
IQueryable<MembershipUser> query = _dbSetUsers.Include(x => x.MembershipRoles);
if (filter == null)
{
return query.ToList().Select(user => user.ToDalUser());
}
return query.Where(filter.TypeConvert<DalMembershipUser,MembershipUser>()).ToList().Select(user=>user.ToDalUser());
}
public IEnumerable<DalTopic> GetMany(Expression<Func<DalTopic, bool>> filter)
{
IQueryable<Topic> query = _dbSetTopics
.Include(t => t.Posts)
.Include(t => t.TopicTags)
.Include(t => t.MembershipUser);
if (filter == null)
{
return query.ToList().Select(user => user.ToDalTopic());
}
return
query.Where(filter.TypeConvert<DalTopic, Topic>())
.ToList()
.Select(user => user.ToDalTopic());
}