示例#1
0
        public QueryResult <UserListPaginationModel> Execute(UserListParameter parameters)
        {
            try
            {
                result.TotalCount = _userRepository.Find(n => n.FirstName.ToLower().Contains(parameters.SearchKey.ToLower())).Count();
                result.TotalPages = Math.Ceiling((double)result.TotalCount / parameters.PageSize);

                result.Data = _userRepository.All()
                              .Select(n => new UserListModel
                {
                    Id          = n.Id,
                    FirstName   = n.FirstName,
                    MiddleName  = n.MiddleName,
                    LastName    = n.LastName,
                    Email       = n.Email,
                    Mobile      = n.Mobile,
                    DateOfBirth = n.DateOfBirth != null ? n.DateOfBirth.Value.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture) : string.Empty,
                    RoleId      = n.RoleId,
                }).Skip((parameters.PageNumber - 1) * parameters.PageSize)
                              .Take(parameters.PageSize)
                              .ToList();

                return(new QueryResult <UserListPaginationModel>()
                {
                    Data = result,
                    IsExecuted = true,
                    Status = CommandQueryStatus.Executed,
                    Message = result.Data.Count != 0 ? "Query Executed Successfully" : "Records Not Found"
                });
            }
            catch (Exception ex)
            {
                return(new QueryResult <UserListPaginationModel>()
                {
                    Data = null,
                    IsExecuted = true,
                    Status = CommandQueryStatus.Failed,
                    ErrorMessage = ex.ToString(),
                    Message = "Error Occured While Processing Your Request"
                });
            }
        }
示例#2
0
        public QueryResultList <UserListModel> Execute(UserListParameter parameters)
        {
            try
            {
                var userName = LoginUserContext.UserName;
                var userId   = LoginUserContext.UserId;

                var result = _dbcontext.User.Select(n => new UserListModel
                {
                    Id          = n.Id,
                    FirstName   = n.FirstName,
                    MiddleName  = n.MiddleName,
                    LastName    = n.LastName,
                    Email       = n.Email,
                    Mobile      = n.Mobile,
                    DateOfBirth = n.DateOfBirth,
                    RoleId      = n.RoleId,
                }).ToList();

                return(new QueryResultList <UserListModel>()
                {
                    Data = result,
                    IsExecuted = true,
                    Status = CommandQueryStatus.Executed,
                    Message = result.Count != 0 ? "Query Executed Successfully" : "Records Not Found"
                });
            }
            catch (Exception ex)
            {
                return(new QueryResultList <UserListModel>()
                {
                    Data = null,
                    IsExecuted = true,
                    Status = CommandQueryStatus.Failed,
                    ErrorMessage = ex.ToString(),
                    Message = "Error Occured While Processing Your Request"
                });
            }
        }