public List <BaseUsersDto> GetAll()
{
// AutoMapper.Mapper.CreateMap<Address, AddressDto>();
// var BaseUsersDtoList = Mapper.Map<List<BaseUsers>, List<BaseUsersDto>>(_usersRepository.GetList());
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT a.*,b.RoleId FROM dbo.BaseUsers a LEFT JOIN dbo.BaseUserRoleMap b ON a.id=b.UserId");
var BaseUsersDtoList = _usersRepository.Query <BaseUsersDto>(strSql.ToString()).ToList();
return(BaseUsersDtoList);
}
public UserInfoDto GetDto(int Id)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM [dbo].[v_UserInfo] WHERE Id=@Id ");
return(_repository.Query <UserInfoDto>(strSql.ToString(), new { Id = Id }).FirstOrDefault());
}
catch (Exception e)
{
return(null);
//Console.WriteLine(e);
//throw;
}
}
