/// <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);
}
