public ActionResult Index(FormCollection f)
{
var _role = new RoleRepo();
if (f["act"] == "del")
{
_repo.Remove(Utils.Split(f["id"]));
}
ViewBag.Roles = _role.List();
long _totalRows;
IMongoSortBy _sort = SortBy<User>.Descending(x => x.Created);
IMongoQuery _query = Query.Null;
if (f.Count > 0)
{
var _kwd = f["kwd"];
var _dir = f["dir"];
var _sortBy = f["sort"];
var _stt = f["stt"];
var _roleId = f["rid"];
var _queries =
MainDb.Map(
Query.And(Query<User>.GTE(x => x.Created, DateTime.Parse(f["from"])),
Query<User>.LTE(x => x.Created, DateTime.Parse(f["to"]))),
!string.IsNullOrWhiteSpace(_stt)
? Query<User>.EQ(x => x.Status, int.Parse(_stt))
: Query.Null,
!string.IsNullOrWhiteSpace(_roleId)
? Query<User>.EQ(x => x.RoleId, ObjectId.Parse(_roleId))
: Query.Null,
!string.IsNullOrWhiteSpace(_kwd)
? Query.Or(
Query<User>.Matches(x => x.UserName,
BsonRegularExpression.Create(new Regex(_kwd, RegexOptions.IgnoreCase))),
Query<User>.Matches(x => x.Address,
BsonRegularExpression.Create(new Regex(_kwd, RegexOptions.IgnoreCase))),
Query<User>.Matches(x => x.FullName,
BsonRegularExpression.Create(new Regex(_kwd, RegexOptions.IgnoreCase)))
)
: Query.Null);
if (_queries.Count > 0)
{
_query = Query.And(_queries);
}
_sort = _dir.ToLower() == "asc" ? SortBy.Ascending(_sortBy) : SortBy.Descending(_sortBy);
}
var _data = _repo.Search(_query, _sort, IWebContext.PageIndex, IWebContext.Configuration.PageSize, out _totalRows);
if (Request.IsAjaxRequest() && string.IsNullOrWhiteSpace(Request.QueryString["f"]))
{
return PartialView("List", _data);
}
return View(_data);
}
public ActionResult Role()
{
var _role = new RoleRepo();
var _data = _role.List();
return View(_data);
}