Beispiel #1
0
        public List <VMActivityLog> GetActivityLogs(PageModel pageModel)
        {
            var data = (from activity in _context.ActivityLogs
                        join user in _context.UserMasters on activity.ActivityBy equals user.UserId
                        join role in _context.RoleMasters on user.Role equals role.RoleId
                        //where activity.ActivityBy > 0
                        select new
            {
                ActivityOn = activity.ActivityOn,
                ActivityByName = activity.ActivityBy,
                ActivityLogId = activity.ActivityLogId,
                ActivityTime = activity.ActivityTime,
                ActivityType = activity.ActivityType,
                ActivityFor = activity.ActivityFor
            }).ToList();
            int totalRecords = data.Count;

            var data2 = (from d in data
                         select new VMActivityLog
            {
                ActivityOn = (d.ActivityFor == "Role") ? _context.RoleMasters
                             .Where(x => x.RoleId == d.ActivityOn)
                             .Select(x => x.RoleName).FirstOrDefault()
                                                                    : _context.UserMasters
                             .Where(x => x.UserId == d.ActivityOn)
                             .Select(x => x.UserName).FirstOrDefault(),
                ActivityByName = _context.UserMasters.Where(x => x.UserId == d.ActivityByName)
                                 .Select(x => x.UserName).FirstOrDefault(),
                ActivityLogId = d.ActivityLogId,
                ActivityTime = d.ActivityTime,
                ActivityType = d.ActivityType,
                ActivityFor = d.ActivityFor,
                TotalRecords = totalRecords
            }).ToList();

            if (pageModel.SortOrder == "desc")
            {
                data2 = PagingUtils.OrderDesc <VMActivityLog>(data2.AsQueryable <VMActivityLog>(), pageModel).ToList();
            }
            else
            {
                data2 = PagingUtils.OrderAsc <VMActivityLog>(data2.AsQueryable <VMActivityLog>(), pageModel).ToList();
            }
            return(data2);
        }
        public List <VMRoleMaster> GetRoles(PageModel pageModel)
        {
            List <VMRoleMaster> data = new List <VMRoleMaster>();

            var data2        = _context.RoleMasters.ToList();
            int totalRecords = data.Count;

            data = (from d in data2
                    select new VMRoleMaster
            {
                RoleId = d.RoleId,
                RoleName = d.RoleName,
                TotalRecords = totalRecords
            }).ToList();
            if (pageModel.SortOrder == "desc")
            {
                data = PagingUtils.OrderDesc <VMRoleMaster>(data.AsQueryable <VMRoleMaster>(), pageModel).ToList();
            }
            else
            {
                data = PagingUtils.OrderAsc <VMRoleMaster>(data.AsQueryable <VMRoleMaster>(), pageModel).ToList();
            }
            return(data);
        }