/// <summary> /// Get all item without deleted /// </summary> /// <param name="userID">The user identifier</param> /// <returns>List<RoleModel></returns> public List <RoleModel> GetAll(Guid userID) { try { List <RoleModel> _return = new List <RoleModel>(); using (var _context = new TDHEntities()) { var _list = _context.PROC_SYS_ROLE_List(this.SessionID, userID).ToList(); foreach (var item in _list) { _return.Add(new RoleModel() { ID = (Guid)item.id, Name = item.name }); } } return(_return); } catch (Exception ex) { throw new ServiceException(FILE_NAME, MethodInfo.GetCurrentMethod().Name, userID, ex); } }
/// <summary> /// Get list data using jquery datatable /// </summary> /// <param name="request">Jquery datatable request</param> /// <param name="userID">User identifier</param> /// <returns><string, object></returns> public Dictionary <string, object> List(CustomDataTableRequestHelper request, Guid userID) { Dictionary <string, object> _return = new Dictionary <string, object>(); try { //Declare response data to json object DataTableResponse <RoleModel> _itemResponse = new DataTableResponse <RoleModel>(); //List of data List <RoleModel> _list = new List <RoleModel>(); using (var _context = new TDHEntities()) { var _lData = _context.PROC_SYS_ROLE_List(this.SessionID, userID).ToList(); _itemResponse.draw = request.draw; _itemResponse.recordsTotal = _lData.Count; //Search if (request.search != null && !string.IsNullOrWhiteSpace(request.search.Value)) { string searchValue = request.search.Value.ToLower(); _lData = _lData.Where(m => m.description.ToLower().Contains(searchValue) || m.name.ToLower().Contains(searchValue)).ToList(); } foreach (var item in _lData) { _list.Add(new RoleModel() { ID = (Guid)item.id, Name = item.name, Description = item.description, Publish = item.publish, Count = item.count, CountString = item.count.NumberToString() }); } _itemResponse.recordsFiltered = _list.Count; IOrderedEnumerable <RoleModel> _sortList = null; if (request.order != null) { foreach (var col in request.order) { switch (col.ColumnName) { case "Name": _sortList = _sortList == null?_list.Sort(col.Dir, m => m.Name) : _sortList.Sort(col.Dir, m => m.Name); break; case "Description": _sortList = _sortList == null?_list.Sort(col.Dir, m => m.Description) : _sortList.Sort(col.Dir, m => m.Description); break; } } _itemResponse.data = _sortList.Skip(request.start).Take(request.length).ToList(); } else { _itemResponse.data = _list.Skip(request.start).Take(request.length).ToList(); } _return.Add(DatatableCommonSetting.Response.DATA, _itemResponse); } _return.Add(DatatableCommonSetting.Response.STATUS, ResponseStatusCodeHelper.OK); } catch (Exception ex) { throw new ServiceException(FILE_NAME, MethodInfo.GetCurrentMethod().Name, userID, ex); } return(_return); }