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