public UserProfileNoId GetByUserId(int userId)
{
string procName = "dbo.UserProfiles_SelectByUserId";
UserProfileNoId aUserProfile = null;
_data.ExecuteCmd(procName, delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@UserId", userId);
}, delegate(IDataReader reader, short set)
{
aUserProfile = MapSingleUserProfileWithOutId(reader);
});
return(aUserProfile);
}
private static UserProfileNoId MapSingleUserProfileWithOutId(IDataReader reader)
{
UserProfileNoId aUserProfile = new UserProfileNoId();
int initialIndex = 0;
aUserProfile.UserProfileId = reader.GetSafeInt32(initialIndex++);
aUserProfile.UserId = reader.GetSafeInt32(initialIndex++);
aUserProfile.FirstName = reader.GetSafeString(initialIndex++);
aUserProfile.LastName = reader.GetSafeString(initialIndex++);
aUserProfile.Mi = reader.GetSafeString(initialIndex++);
aUserProfile.AvatarUrl = reader.GetSafeString(initialIndex++);
aUserProfile.DateCreated = reader.GetSafeDateTime(initialIndex++);
aUserProfile.DateModified = reader.GetSafeDateTime(initialIndex++);
aUserProfile.Email = reader.GetSafeString(initialIndex++);
return(aUserProfile);
}
