public static CategoryInfo CopyCategoryToBO(SqlDataReader rdr)
{
//CAT_ID, CAT_NAME, CAT_STATUS, CAT_MODERATION, CAT_SUBSCRIPTION, CAT_ORDER
CategoryInfo category = new CategoryInfo
{
Id = rdr.GetInt32(0),
Name = rdr.SafeGetString(1),
Status = rdr.GetInt16(2),
ModerationLevel = rdr.SafeGetInt32(3),
SubscriptionLevel = rdr.SafeGetInt32(4),
Order = rdr.GetInt32(5)
};
return category;
}
public static ForumInfo CopyForumToBO(SqlDataReader rdr)
{
//"F.FORUM_ID,F.CAT_ID,F.F_STATUS,F.F_SUBJECT,F.F_URL,F.F_TOPICS" +
//",F.F_COUNT,F.F_LAST_POST,F.F_PRIVATEFORUMS,F.F_TYPE,F.F_LAST_POST_AUTHOR,F.F_A_TOPICS,F.F_A_COUNT,F.F_MODERATION" +
//",F.F_SUBSCRIPTION,F.F_ORDER, F.F_COUNT_M_POSTS,F.F_LAST_POST_TOPIC_ID,F.F_LAST_POST_REPLY_ID,F.F_POLLS,F.F_DESCRIPTION" +
//",F.F_L_ARCHIVE,F.F_ARCHIVE_SCHED,T.T_SUBJECT,M.M_NAME ";
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.GetSnitzDate(7),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastArchived = rdr.GetSnitzDate(21),
ArchiveFrequency = rdr.SafeGetInt32(22),
LastPostSubject = rdr.SafeGetString(23),
LastPostAuthorName = rdr.SafeGetString(24)
};
return forum;
}
public static ForumInfo CopyForumToBO(SqlDataReader rdr)
{
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.SafeGetString(7).ToDateTime(),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastPostSubject = rdr.SafeGetString(21),
LastPostAuthorName = rdr.SafeGetString(22)
};
//if (forum.LastPostAuthorId != null)
//{
// var author = new PostAuthor().GetAuthor(forum.LastPostAuthorId.Value);
// forum.LastPostAuthor = author;
//}
return forum;
}
public static MemberInfo CopyMemberToBO(SqlDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo
{
Id = rdr.GetInt32(0),
Status = rdr.GetInt16(1),
Username = rdr.GetString(2),
NTUsername = rdr.SafeGetString(3),
Email = rdr.SafeGetString(4),
Country = rdr.SafeGetString(5),
HomePage = rdr.SafeGetString(6),
Signature = rdr.SafeGetString(7),
MemberLevel = rdr.GetInt16(8),
AIM = rdr.SafeGetString(9),
Yahoo = rdr.SafeGetString(10),
ICQ = rdr.SafeGetString(11),
MSN = rdr.SafeGetString(12),
PostCount = rdr.SafeGetInt32(13) ?? 0,
MemberSince = rdr.SafeGetString(14).ToDateTime().Value,
LastVisitDate = rdr.SafeGetString(15).ToDateTime(),
LastPostDate = rdr.SafeGetString(16).ToDateTime(),
Title = rdr.SafeGetString(17), //MemberTitle(rdr.SafeGetString(17)),
AllowSubscriptions = (rdr["M_SUBSCRIPTION"] as int?) == 1,
HideEmail = (rdr["M_HIDE_EMAIL"] as int?) == 1,
ReceiveEmails = (rdr["M_RECEIVE_EMAIL"] as int?) == 1,
MembersIP = rdr.SafeGetString(21),
ViewSignatures = (rdr["M_VIEW_SIG"] as int?) == 1,
UseSignature = (rdr["M_SIG_DEFAULT"] as int?) == 1,
Voted = (rdr["M_VOTED"] as int?) == 1,
AllowEmail = (rdr["M_ALLOWEMAIL"] as int?) == 1,
Avatar = rdr.SafeGetString(26),
Theme = rdr.SafeGetString(27),
TimeOffset = rdr.GetInt32(28),
DateOfBirth = rdr.SafeGetString(29)
};
}
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 TopicInfo CopyTopicToBO(SqlDataReader rdr)
{
TopicInfo topic;
try
{
topic = new TopicInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
Status = rdr.GetInt16(3),
Subject = rdr.SafeGetString(4),
AuthorId = rdr.GetInt32(5),
ReplyCount = rdr.GetInt32(6),
Views = rdr.GetInt32(7),
LastPostDate = rdr.SafeGetString(8).ToDateTime(),
Date = rdr.SafeGetString(9).ToDateTime().Value,
PosterIp = rdr.SafeGetString(10),
LastPostAuthorId = rdr.SafeGetInt32(11),
IsSticky = rdr.GetInt16(12) == 1,
LastEditDate = rdr.SafeGetString(13).ToDateTime(),
LastEditedById = rdr.SafeGetInt32(14),
UseSignatures = rdr.GetInt16(15) == 1,
LastReplyId = rdr.SafeGetInt32(16),
UnModeratedReplies = rdr.GetInt32(17),
Message = rdr.SafeGetString(18)
};
if (rdr.FieldCount > 19)
{
topic.LastPostAuthorName = rdr.SafeGetString(19);
topic.AuthorName = rdr.SafeGetString(20);
topic.EditorName = rdr.SafeGetString(21);
if (rdr.FieldCount > 22)
{
topic.AuthorViewSig = rdr.GetInt16(22) == 1;
topic.AuthorSignature = rdr.SafeGetString(23);
}
}
}
catch (System.Exception)
{
return null;
}
return topic;
}
public static SearchResult CopySearchResultToBO(SqlDataReader rdr, ref int rowcount)
{
SearchResult result = new SearchResult()
{
CategoryStatus = rdr.GetInt16(1),
CategorySubscriptionLevel = rdr.GetInt32(2),
CategoryTitle = rdr.SafeGetString(3),
ForumSubject = rdr.SafeGetString(4),
ForumSubscriptionLevel = rdr.GetInt32(5),
ForumStatus = rdr.GetInt16(6),
ForumAccessType = rdr.GetInt32(7),
ForumPassword = rdr.SafeGetString(8),
CatId = rdr.GetInt32(9),
ForumId = rdr.GetInt32(10),
Id = rdr.GetInt32(11),
AuthorId = rdr.GetInt32(12),
Subject = rdr.SafeGetString(13),
Status = rdr.GetInt16(14),
LastPostDate = rdr.GetSnitzDate(15),
LastPostAuthorId = rdr.SafeGetInt32(16),
LastReplyId = rdr.SafeGetInt32(17),
ReplyCount = rdr.GetInt32(18),
UnModeratedReplies = rdr.GetInt32(19),
Views = rdr.GetInt32(20),
AuthorName = rdr.SafeGetString(22),
LastPostAuthorName = rdr.SafeGetString(23)
};
rowcount = rdr.GetInt32(24);
return result;
}
public static ReplyInfo CopyReplyToBO(SqlDataReader rdr)
{
ReplyInfo reply = new ReplyInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
TopicId = rdr.GetInt32(3),
AuthorId = rdr.GetInt32(4),
Date = rdr.GetString(5).ToDateTime().Value,
PosterIp = rdr.SafeGetString(6),
Status = rdr.GetInt16(7),
LastEditDate = rdr.SafeGetString(8).ToDateTime(),
LastEditedById = rdr.SafeGetInt32(9),
UseSignatures = rdr.GetInt16(10) == 1,
Message = rdr.SafeGetString(11)
};
if (rdr.FieldCount > 12)
{
reply.AuthorName = rdr.SafeGetString(12);
reply.EditorName = rdr.SafeGetString(13);
reply.AuthorViewSig = rdr.GetInt16(14) == 1;
reply.AuthorSignature = rdr.SafeGetString(15);
}
return reply;
}
private EventInfo CopyEventToBO(SqlDataReader rdr)
{
//Id,Title,Type,Audience,Author,EventDate,Description
EventInfo forumevent = new EventInfo
{
Id = rdr.GetInt32(0),
Title = rdr.SafeGetString(1),
Type = rdr.GetInt32(2),
Audience = rdr.SafeGetString(3),
MemberId = rdr.GetInt32(4),
Date = rdr.GetSnitzDate(5).Value,
Description = rdr.SafeGetString(6),
RecurringFrequency = (RecurringFrequencies) rdr.SafeGetInt32(7)
};
var mem = new Member();
forumevent.Author = new AuthorInfo(mem.GetById(forumevent.MemberId));
return forumevent;
}
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;
}
