public SearchAllUserRoleOutput SearchAllUserRole(SearchAllUserRoleInput input)
{
//var all = from u in _userRepository.GetAll()
// join r in _roleRepository.GetAll() on u.id equals r.userId;
// NorthwindDataContext db = new NorthwindDataContext();
var list = new List <UserRoleDto>();
list = (from u in _userRepository.GetAll()
join r in _roleRepository.GetAll() on u.Id equals r.userId
// where u.username.Contains(input.UserName) || r.rolename.Contains(input.RoleName)
select new UserRoleDto
{
UserName = u.username,
RoleName = r.rolename
}).ToList();
if (!string.IsNullOrEmpty(input.UserName) && input.UserName != null)
{
list = (list.Where(q => q.UserName.Contains(input.UserName))).ToList();
}
if (!string.IsNullOrEmpty(input.RoleName) && input.RoleName != null)
{
list = (list.Where(q => q.RoleName.Contains(input.RoleName))).ToList();
}
return(new SearchAllUserRoleOutput {
UserRole = list
});
}
public SearchAllUserRoleOutput SearchAllUserRole(SearchAllUserRoleInput input)
{
SearchAllUserRoleOutput s = _IUserRoleService.SearchAllUserRole(input);
return(s);
}
