public static int CountUserByQuery(UserQuery query)
{
using (var context = new Intern4jobEntities())
{
var repository = new UserRepository(context);
int count = repository.GetPageCount(item => _isMatch(item, query));
return count;
}
}
private static dynamic _orderByKey(User obj, UserQuery query)
{
if (string.IsNullOrEmpty(query.OrderByKey))
return obj.Id;
return obj.GetType().GetProperty(query.OrderByKey).GetValue(obj);
}
public static List<User> GetUserListByQuery(UserQuery query)
{
using (var context = new Intern4jobEntities())
{
var repository = new UserRepository(context);
List<User> users = repository.GetPageList(item => _isMatch(item, query), item => _orderByKey(item, query), query.OrderByValue, query.Offset, query.Limit);
return users;
}
}
public static bool _isMatch(User obj, UserQuery query)
{
if (!string.IsNullOrEmpty(query.IdEqual) && !string.Equals(obj.Id, query.IdEqual))
return false;
if (!string.IsNullOrEmpty(query.IdNotEqual) && string.Equals(obj.Id, query.IdNotEqual))
return false;
if (!string.IsNullOrEmpty(query.NameEqual) && !string.Equals(obj.Name, query.NameEqual))
return false;
if (!string.IsNullOrEmpty(query.NameNotEqual) && string.Equals(obj.Name, query.NameNotEqual))
return false;
if (!string.IsNullOrEmpty(query.NameLike) && !obj.Name.Contains(query.NameLike))
return false;
if (!string.IsNullOrEmpty(query.StatusEqual) && !string.Equals(obj.Status, query.StatusEqual))
return false;
if (!string.IsNullOrEmpty(query.StatusNotEqual) && string.Equals(obj.Status, query.StatusNotEqual))
return false;
if ((query.StatusIn != null) && (query.StatusIn.Select(item => string.Equals(item, obj.Status)) == null))
return false;
if ((query.StatusNotIn != null) && (query.StatusNotIn.Select(item => string.Equals(item, obj.Status)) != null))
return false;
return true;
}
public static User GetUserById(string id4query)
{
UserQuery query = new UserQuery() { IdEqual = id4query };
User userInDb = GetUserListByQuery(query).FirstOrDefault();
return userInDb;
}
