public static MemberInfo CopyMemberToBO(SqlDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo
{
Id = rdr.GetInt32(0),
Status = rdr.SafeGetInt16(1),
Username = rdr.SafeGetString(2),
NTUsername = rdr.SafeGetString(3),
Email = rdr.SafeGetString(4),
Country = rdr.SafeGetString(5),
HomePage = rdr.SafeGetString(6),
Signature = rdr.SafeGetString(7),
MemberLevel = rdr.SafeGetInt16(8),
AIM = rdr.SafeGetString(9),
Yahoo = rdr.SafeGetString(10),
ICQ = rdr.SafeGetString(11),
Skype = rdr.SafeGetString(12),
PostCount = rdr.SafeGetInt32(13) ?? 0,
MemberSince = rdr.GetSnitzDate(14).Value,
LastVisitDate = rdr.GetSnitzDate(15),
LastPostDate = rdr.GetSnitzDate(16),
Title = rdr.SafeGetString(17), //MemberTitle(rdr.SafeGetString(17)),
AllowSubscriptions = rdr.SafeGetInt16(18) == 1,
HideEmail = rdr.SafeGetInt16(19) == 1,
ReceiveEmails = rdr.SafeGetInt16(20) == 1,
MembersIP = rdr.SafeGetString(21),
ViewSignatures = rdr.SafeGetInt16(22) == 1,
UseSignature = rdr.SafeGetInt16(23) == 1,
Voted = rdr.SafeGetInt16(24) == 1,
AllowEmail = rdr.SafeGetInt16(25) == 1,
Avatar = rdr.SafeGetString(26),
Theme = rdr.SafeGetString(27),
TimeOffset = rdr.SafeGetDouble(28),
DateOfBirth = rdr.SafeGetString(29),
Age = rdr.SafeGetString(30),
Password = rdr.GetString(31),
ValidationKey = rdr.SafeGetString(32),
IsValid = rdr.SafeGetInt16(33) == 1,
LastUpdateDate = rdr.GetSnitzDate(34),
MaritalStatus = rdr.SafeGetString(35),
Firstname = rdr.SafeGetString(36),
Lastname = rdr.SafeGetString(37),
Occupation = rdr.SafeGetString(38),
Gender = rdr.SafeGetString(39),
Hobbies = rdr.SafeGetString(40),
LatestNews = rdr.SafeGetString(41),
FavouriteQuote = rdr.SafeGetString(42),
Biography = rdr.SafeGetString(43),
FavLink1 = rdr.SafeGetString(44),
FavLink2 = rdr.SafeGetString(45),
City = rdr.SafeGetString(46),
State = rdr.SafeGetString(47),
UseDaylightSaving = rdr.SafeGetInt16(48) == 1,
TimeZone = rdr.SafeGetString(49)
};
}
catch(Exception ex)
{
//SqlDataReader rdrtest = rdr;
//string test = ex.Message;
}
string title = member.Title;
//member.Rank = new RankInfo(member.Username,ref title,member.PostCount);
member.Title = title;
return member;
}
public static PrivateMessageInfo CopyPrivateMessageToBO(SqlDataReader rdr)
{
PrivateMessageInfo pm = new PrivateMessageInfo
{
Id = rdr.GetInt32(0),
Subject = rdr.SafeGetString(1),
FromMemberId = rdr.GetInt32(2),
ToMemberId = rdr.GetInt32(3),
SentDate = rdr.SafeGetString(4),
Message = rdr.SafeGetString(5),
Count = rdr.SafeGetString(6),
Read = rdr.GetInt32(7),
//Mail = Convert.ToInt32(rdr.SafeGetString(8)),
OutBox = rdr.SafeGetInt16(9),
ToMemberName = rdr.SafeGetString(10),
FromMemberName = rdr.SafeGetString(11)
};
pm.Sent = pm.SentDate.ToDateTime();
return pm;
}
