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