public User GetUserById(int UserId)
{
var user = (from u in _ctx.User where u.Id == UserId select MapperUser.Map(u)).FirstOrDefault();
var role = (from r in _ctx.AppRole join u in _ctx.User on r.Id equals u.IdRole where u.Id == UserId select MapperRole.Map(r)).FirstOrDefault();
user.Role = role;
return(user);
}
public void GivenMapper_WhenFromUserToDto_ThenReturningUserDTO()
{
//Given
MapperUser mapperUser = new MapperUser();
//When
var testUser = mapperUser.FromUserToUserDTOWithoutId(new User());
UserDTOWithoutIdentificationNumber user1 = new UserDTOWithoutIdentificationNumber();
//then
Assert.IsType(user1.GetType(), testUser);
}
public async Task <IEnumerable <UserDTO> > GetAllUsers()
{
try
{
List <User> users = await _userService.GetAllUsers().ToListAsync();
return(MapperUser.MapFromEntitiyToDTO(users));
}
catch (Exception ex)
{
throw new Exception("User.GetAllUsers", ex);
}
}
public async Task <int> AddUser(UserDTO userDTO)
{
try
{
User user = MapperUser.MapFromDToEntitiy(userDTO);
_userService.Add(user);
int result = await _uwo.CommitChanges();
List <User> lstUser = await _userService.GetAllUsers().ToListAsync();
return(result > 0 ? lstUser.OrderBy(u => u.Id).Last().Id : 0);
}
catch (Exception ex)
{
throw new Exception("User.AddUser", ex);
}
}
public async Task <UserDTO> GetById(int id)
{
try
{
List <User> lstUser = await _userService.GetAllUsers().ToListAsync();
User user = lstUser.FirstOrDefault(u => u.Id.Equals(id));
return(MapperUser.MapFromEntitiyToDTO(new List <User>()
{
user
}).FirstOrDefault());
}
catch (Exception ex)
{
throw new Exception("User.GetById", ex);
}
}
public async Task <UserDTO> UpdateUser(UserDTO userDTO)
{
try
{
User user = MapperUser.MapFromDToEntitiy(userDTO);
_userService.Update(user);
await _uwo.CommitChanges();
List <User> lstUser = await _userService.GetAllUsers().ToListAsync();
user = lstUser.FirstOrDefault(u => u.Id.Equals(userDTO.UserId));
return(MapperUser.MapFromEntitiyToDTO(new List <User>()
{
user
}).FirstOrDefault());
}
catch (Exception ex)
{
throw new Exception("User.UpdateUser", ex);
}
}
/// <summary>
/// Modifica una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a modificar</param>
/// <returns>Número de User modificados</returns>
public virtual int ActualizarUser(Entities.User source)
{
return(_RepositoryUser.UpdateUser(MapperUser.MapTo(source)));
}
/// <summary>
/// Modifica una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a modificar</param>
/// <returns>Número de User modificados</returns>
public virtual async Task <int> ActualizarUserAsync(Entities.User source)
{
return(await _RepositoryUser.UpdateUserAsync(MapperUser.MapTo(source)));
}
/// <summary>
/// Borra una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a borrar</param>
/// <returns>Número de User borrados</returns>
public virtual async Task <int> BorrarUserAsync(Entities.User source)
{
return(await _RepositoryUser.DeleteUserAsync(MapperUser.MapTo(source)));
}
/// <summary>
/// Crea una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a crear</param>
/// <returns>User creado</returns>
public virtual async Task <Entities.User> CrearUserAsync(Entities.User source)
{
return(MapperUser.MapToRelated(await _RepositoryUser.CreateUserAsync(MapperUser.MapTo(source))));
}
/// <summary>
/// Obtener un User por su clave primaria
/// </summary>
/// <param name="id">Id</param>
/// <returns>User seleccionado por su clave primaria</returns>
public Entities.User ObtenerUserPorClavePrimaria(int id)
{
return(MapperUser.MapTo(_RepositoryUser.GetUserByPrimaryKey(id)));
}
/// <summary>
/// Obtener un User por su clave primaria
/// </summary>
/// <param name="id">Id</param>
/// <returns>User seleccionado por su clave primaria</returns>
public async Task <Entities.User> ObtenerUserPorClavePrimariaAsync(int id)
{
return(MapperUser.MapTo(await _RepositoryUser.GetUserByPrimaryKeyAsync(id)));
}
/// <summary>
/// Metodo para obtener todos los User asincronamente
/// </summary>
/// <returns>IQueryable con todos los User</returns>
public async Task <IEnumerable <Entities.User> > ObtenerUserAsync()
{
return((await _RepositoryUser.GetUser().ToListAsync()).Select(x => MapperUser.MapTo(x)));
}
/// <summary>
/// Metodo para obtener todos los User
/// </summary>
/// <returns>IQueryable con todos los User</returns>
public IEnumerable <Entities.User> ObtenerUser()
{
return(_RepositoryUser.GetUser().ToList().Select(x => MapperUser.MapTo(x)));
}
/// <summary>
/// Borra una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a borrar</param>
/// <returns>Número de User borrados</returns>
public virtual int BorrarUser(Entities.User source)
{
return(_RepositoryUser.DeleteUser(MapperUser.MapTo(source)));
}
/// <summary>
/// Crea una instancia de User en la base de datos
/// </summary>
/// <param name="source">User a crear</param>
/// <returns>User creado</returns>
public virtual Entities.User CrearUser(Entities.User source)
{
return(MapperUser.MapToRelated(_RepositoryUser.CreateUser(MapperUser.MapTo(source))));
}
public List <User> GetListUser(int GroupId)
{
return((from ug in _ctx.UserGroup where ug.IdGroup == GroupId select MapperUser.Map(ug.User)).ToList());
}
