public static List <FeedItem> PopulateObjectWithJoin(IDataReader dr, List <FeedItem> FeedItems)
{
ColumnFieldList list = new ColumnFieldList(dr);
FeedItem feedItem;
while (dr.Read())
{
feedItem = new FeedItem();
feedItem.Friend1FullName = string.Empty;
feedItem.Friend2FullName = string.Empty;
if (list.IsColumnPresent("FeedItemType"))
{
feedItem.FeedItemType = (FeedItemType)dr["FeedItemType"];
}
if (list.IsColumnPresent("Url"))
{
feedItem.MainWebID = (string)dr["Url"];
}
if (list.IsColumnPresent("Thumbnail"))
{
feedItem.Thumbnail = "http://www.next2friends.com/user/" + (string)dr["Thumbnail"];
}
if (list.IsColumnPresent("AskAFriendQuestion"))
{
feedItem.AskAFriendQuestion = (string)dr["AskAFriendQuestion"];
}
if (list.IsColumnPresent("Text"))
{
feedItem.Text = (string)dr["Text"];
}
if (list.IsColumnPresent("Title"))
{
feedItem.Title = (string)dr["Title"];
}
if (list.IsColumnPresent("FriendNickname1"))
{
feedItem.FriendNickname1 = (string)dr["FriendNickname1"];
}
if (list.IsColumnPresent("FriendNickname2"))
{
feedItem.FriendNickname2 = (string)dr["FriendNickname2"];
}
if (list.IsColumnPresent("FriendWebMemberID1"))
{
feedItem.FriendWebMemberID1 = (string)dr["FriendWebMemberID1"];
}
if (list.IsColumnPresent("FriendWebMemberID2"))
{
feedItem.FriendWebMemberID2 = (string)dr["FriendWebMemberID2"];
}
if (list.IsColumnPresent("WebPhotoCollectionID"))
{
feedItem.WebPhotoCollectionID = (string)dr["WebPhotoCollectionID"];
}
if (list.IsColumnPresent("WebPhotoID"))
{
feedItem.WebPhotoID = (string)dr["WebPhotoID"];
}
if (list.IsColumnPresent("DateTime"))
{
feedItem.DateTime = (DateTime)dr["DateTime"];
}
if (list.IsColumnPresent("Friend1FullName"))
{
feedItem.Friend1FullName = (string)dr["Friend1FullName"];
}
if (list.IsColumnPresent("Friend2FullName"))
{
feedItem.Friend2FullName = (string)dr["Friend2FullName"];
}
FeedItems.Add(feedItem);
}
return(FeedItems);
}
public static List<FeedItem> PopulateObjectWithJoin(IDataReader dr, List<FeedItem> FeedItems)
{
ColumnFieldList list = new ColumnFieldList(dr);
FeedItem feedItem;
while (dr.Read())
{
feedItem = new FeedItem();
feedItem.Friend1FullName = string.Empty;
feedItem.Friend2FullName = string.Empty;
if (list.IsColumnPresent("FeedItemType")) { feedItem.FeedItemType = (FeedItemType)dr["FeedItemType"]; }
if (list.IsColumnPresent("Url")) { feedItem.MainWebID = (string)dr["Url"]; }
if (list.IsColumnPresent("Thumbnail")) { feedItem.Thumbnail = "http://www.next2friends.com/user/"+(string)dr["Thumbnail"]; }
if (list.IsColumnPresent("AskAFriendQuestion")) { feedItem.AskAFriendQuestion = (string)dr["AskAFriendQuestion"]; }
if (list.IsColumnPresent("Text")) { feedItem.Text = (string)dr["Text"]; }
if (list.IsColumnPresent("Title")) { feedItem.Title = (string)dr["Title"]; }
if (list.IsColumnPresent("FriendNickname1")) { feedItem.FriendNickname1 = (string)dr["FriendNickname1"]; }
if (list.IsColumnPresent("FriendNickname2")) { feedItem.FriendNickname2 = (string)dr["FriendNickname2"]; }
if (list.IsColumnPresent("FriendWebMemberID1")) { feedItem.FriendWebMemberID1 = (string)dr["FriendWebMemberID1"]; }
if (list.IsColumnPresent("FriendWebMemberID2")) { feedItem.FriendWebMemberID2 = (string)dr["FriendWebMemberID2"]; }
if (list.IsColumnPresent("WebPhotoCollectionID")) { feedItem.WebPhotoCollectionID = (string)dr["WebPhotoCollectionID"]; }
if (list.IsColumnPresent("WebPhotoID")) { feedItem.WebPhotoID = (string)dr["WebPhotoID"]; }
if (list.IsColumnPresent("DateTime")) { feedItem.DateTime = (DateTime)dr["DateTime"]; }
if (list.IsColumnPresent("Friend1FullName")) { feedItem.Friend1FullName = (string)dr["Friend1FullName"]; }
if (list.IsColumnPresent("Friend2FullName")) { feedItem.Friend2FullName = (string)dr["Friend2FullName"]; }
FeedItems.Add(feedItem);
}
return FeedItems;
}
