public IEnumerable <UserDto> GetAll()
{
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = new SqlCommand(@"
SELECT [Id],
[FirstName],
[LastName]
FROM [TravelMapAppDb].[dbo].[Users]");
var allUsers = sqlConnection.Query <UserEntity>(query.CommandText, query.ToDynamicParameters()).ToList();
return(allUsers.Select(user => UserTransformator.Map(user)));
}
}
public UserDto Get(int id)
{
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = new SqlCommand(@"
SELECT [Id],
[FirstName],
[LastName]
FROM [TravelMapAppDb].[dbo].[Users]
WHERE @Id = Id");
query.Parameters.AddWithValue("Id", id);
var user = sqlConnection.QueryFirstOrDefault <UserEntity>(query.CommandText, query.ToDynamicParameters());
return(UserTransformator.Map(user));
}
}
public int Add(UserDto user)
{
var userToAdd = new UserDto
{
Id = _allUsers.Max(x => x.Id) + 1,
FirstName = user.FirstName,
LastName = user.LastName,
VisitedCountries = user.VisitedCountries.Select(y => new TravelDestinationDto
{
CountryId = y.CountryId,
Name = y.Name
}).ToList()
};
_allUsers.Add(UserTransformator.Map(userToAdd));
return(userToAdd.Id);
}
public void Edit(UserDto user)
{
var originalUser = _allUsers.Find(x => x.Id == user.Id);
UserTransformator.Map(originalUser);
}
public UserDto Get(int id)
{
var user = _allUsers.SingleOrDefault(x => x.Id == id);
return(UserTransformator.Map(user));
}
public IEnumerable <UserDto> GetAll()
{
return(_allUsers.Select((userDto) => UserTransformator.Map(userDto)));
}