public class ClientServices : IClientServices
    {
        private IDataProvider _dataProvider;

        public ClientServices(IDataProvider dataProvider)
        {
            _dataProvider = dataProvider;
        }

        public Clients GetByClientId(int clientId)
        {
            Clients model = null;

            _dataProvider.ExecuteCmd("dbo.ClientProfiles_SelectBy_ClientId", inputParamMapper: delegate (SqlParameterCollection parms)
            {
                parms.AddWithValue("@ClientId", clientId);
            }, singleRecordMapper: delegate (IDataReader reader, short set)
            {
                model = MapClients(reader);
            });

            return model;
        }

        private static Clients MapClients(IDataReader reader)
        {
            Clients model = new Clients();
            int index = 0;

            model.Id = reader.GetSafeInt32(index++);
            model.ClientId = reader.GetSafeInt32(index++);
            model.FirstName = reader.GetSafeString(index++);
            model.LastName = reader.GetSafeString(index++);
            model.Bio = reader.GetSafeString(index++);
            model.AvatarUrl = reader.GetSafeString(index++);
            model.Age = reader.GetSafeInt32(index++);
            model.KnownLocations = reader.GetSafeString(index++);
            model.DateAdded = reader.GetSafeDateTime(index++);
            model.DateModified = reader.GetSafeDateTime(index++);
            model.Gender = reader.GetSafeString(index++);
            model.Latitude = reader.GetSafeDouble(index++);
            model.Longitude = reader.GetSafeDouble(index);

            return model;
        }
    }
}