public static CategoryInfo CopyCategoryToBO(OleDbDataReader 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(OleDbDataReader 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;
}
private EventInfo CopyEventToBO(OleDbDataReader 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(OleDbDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo();
member.Id = rdr.GetInt32(0);
member.Status = rdr.GetInt16(1);
member.Username = rdr.GetString(2);
member.NTUsername = rdr.SafeGetString(3);
member.Email = rdr.SafeGetString(4);
member.Country = rdr.SafeGetString(5);
member.HomePage = rdr.SafeGetString(6);
member.Signature = rdr.SafeGetString(7);
member.MemberLevel = rdr.GetInt16(8);
member.AIM = rdr.SafeGetString(9);
member.Yahoo = rdr.SafeGetString(10);
member.ICQ = rdr.SafeGetString(11);
member.Skype = rdr.SafeGetString(12);
member.PostCount = rdr.SafeGetInt32(13) ?? 0;
member.MemberSince = rdr.GetSnitzDate(14) == null ? DateTime.UtcNow : rdr.GetSnitzDate(14).Value;
member.LastVisitDate = rdr.GetSnitzDate(15);
member.LastPostDate = rdr.GetSnitzDate(16);
member.Title = rdr.SafeGetString(17); //member.MemberTitle(rdr.SafeGetString(17));
member.AllowSubscriptions = rdr.SafeGetInt16(18) == 1;
member.HideEmail = rdr.SafeGetInt16(19) == 1;
member.ReceiveEmails = rdr.SafeGetInt16(20) == 1;
member.MembersIP = rdr.SafeGetString(21);
member.ViewSignatures = rdr.SafeGetInt16(22) == 1;
member.UseSignature = rdr.SafeGetInt16(23) == 1;
member.Voted = rdr.SafeGetInt32(24) == 1;
member.AllowEmail = rdr.SafeGetInt16(25) == 1;
member.Avatar = rdr.SafeGetString(26);
member.Theme = rdr.SafeGetString(27);
member.TimeOffset = rdr.SafeGetDouble(28);
member.DateOfBirth = rdr.SafeGetString(29);
member.Age = rdr.SafeGetString(30);
member.Password = rdr.GetString(31);
member.ValidationKey = rdr.SafeGetString(32);
member.IsValid = rdr.SafeGetInt32(33) == 1;
member.LastUpdateDate = rdr.GetSnitzDate(34);
member.MaritalStatus = rdr.SafeGetString(35);
member.Firstname = rdr.SafeGetString(36);
member.Lastname = rdr.SafeGetString(37);
member.Occupation = rdr.SafeGetString(38);
member.Gender = rdr.SafeGetString(39);
member.Hobbies = rdr.SafeGetString(40);
member.LatestNews = rdr.SafeGetString(41);
member.FavouriteQuote = rdr.SafeGetString(42);
member.Biography = rdr.SafeGetString(43);
member.FavLink1 = rdr.SafeGetString(44);
member.FavLink2 = rdr.SafeGetString(45);
member.City = rdr.SafeGetString(46);
member.State = rdr.SafeGetString(47);
member.UseDaylightSaving = rdr.SafeGetInt16(48) == 1;
member.TimeZone = rdr.SafeGetString(49);
}
catch (Exception ex)
{
throw new Exception("Error copying reader to BO");
OleDbDataReader 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(OleDbDataReader 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.GetSnitzDate(8),
Date = rdr.GetSnitzDate(9).Value,
PosterIp = rdr.SafeGetString(10),
LastPostAuthorId = rdr.SafeGetInt32(11),
IsSticky = rdr.GetInt16(12) == 1,
LastEditDate = rdr.GetSnitzDate(13),
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.AuthorName = rdr.SafeGetString(19);
topic.LastPostAuthorName = rdr.SafeGetString(20);
topic.EditorName = rdr.SafeGetString(21);
if (rdr.FieldCount > 22)
{
topic.AuthorViewSig = rdr.GetInt16(22) == 1;
topic.AuthorSignature = rdr.SafeGetString(23);
}
}
}
catch (Exception)
{
return null;
}
return topic;
}
public static SearchResult CopySearchResultToBO(OleDbDataReader rdr, ref int rowcount)
{
SearchResult result = new SearchResult
{
CategoryStatus = rdr.GetInt16(0),
CategorySubscriptionLevel = rdr.GetInt32(1),
CategoryTitle = rdr.SafeGetString(2),
ForumSubject = rdr.SafeGetString(3),
ForumSubscriptionLevel = rdr.GetInt32(4),
ForumStatus = rdr.GetInt16(5),
ForumAccessType = rdr.GetInt32(6),
ForumPassword = rdr.SafeGetString(7),
CatId = rdr.GetInt32(8),
ForumId = rdr.GetInt32(9),
Id = rdr.GetInt32(10),
AuthorId = rdr.GetInt32(11),
Subject = rdr.SafeGetString(12),
Status = rdr.GetInt16(13),
LastPostDate = rdr.GetSnitzDate(14),
LastPostAuthorId = rdr.SafeGetInt32(15),
LastReplyId = rdr.SafeGetInt32(16),
ReplyCount = rdr.GetInt32(17),
UnModeratedReplies = rdr.GetInt32(18),
Views = rdr.GetInt32(19),
AuthorName = rdr.SafeGetString(21),
LastPostAuthorName = rdr.SafeGetString(22)
};
//rowcount = rdr.GetInt32(24);
return result;
}
public static ReplyInfo CopyReplyToBO(OleDbDataReader 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.GetSnitzDate(5).Value,
PosterIp = rdr.SafeGetString(6),
Status = rdr.GetInt16(7),
LastEditDate = rdr.GetSnitzDate(8),
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).Replace(">", "]").Replace("<", "[");
}
return reply;
}
