public static List<FriendTag> PopulateFriendTagWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<FriendTag> arr = new List<FriendTag>();
FriendTag obj;
while (dr.Read())
{
obj = new FriendTag();
if (list.IsColumnPresent("MemberID")) { obj.MemberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("WebMemberID")) { obj.WebMemberID = (string)dr["WebMemberID"]; }
if (list.IsColumnPresent("CountryName")) { obj.CountryName = (string)dr["CountryName"]; }
if (list.IsColumnPresent("NickName")) { obj.NickName = (string)dr["NickName"]; }
if (list.IsColumnPresent("FirstName")) { obj.FirstName = (string)dr["FirstName"]; }
if (list.IsColumnPresent("LastName")) { obj.LastName = (string)dr["LastName"]; }
if (list.IsColumnPresent("ProfilePhotoURL")) { obj.ProfilePhotoURL = (string)dr["ProfilePhotoURL"]; }
if (list.IsColumnPresent("TaggedDT")) { obj.TaggedDT = (DateTime)dr["TaggedDT"]; }
if (list.IsColumnPresent("CreatedDT")) { obj._createdDT = (DateTime)dr["CreatedDT"]; }
arr.Add(obj);
}
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ChatMessages
/// </summary>
public static List<ChatMessage> PopulateObjectWithJoinCustom(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ChatMessage> arr = new List<ChatMessage>();
ChatMessage obj;
while (dr.Read())
{
obj = new ChatMessage();
if (list.IsColumnPresent("ChatMessageID")) { obj._chatMessageID = (int)dr["ChatMessageID"]; }
if (list.IsColumnPresent("ChatMessageWebID")) { obj._chatMessageWebID = (string)dr["ChatMessageWebID"]; }
if (list.IsColumnPresent("MemberIDFrom")) { obj._memberIDFrom = (int)dr["MemberIDFrom"]; }
if (list.IsColumnPresent("MemberIDTo")) { obj._memberIDTo = (int)dr["MemberIDTo"]; }
if (list.IsColumnPresent("Message")) { obj._message = (string)dr["Message"]; }
if (list.IsColumnPresent("Delivered")) { obj._delivered = (bool)dr["Delivered"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
if (list.IsColumnPresent("WebMemberIDFrom")) { obj.WebMemberIDFrom = (String)dr["WebMemberIDFrom"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ContentViews
/// </summary>
public static List<ContentView> PopulateContentViewObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ContentView> arr = new List<ContentView>();
ContentView obj;
while (dr.Read())
{
obj = new ContentView();
if (list.IsColumnPresent("WebMemberID")) { obj.WebMemberID = (string)dr["WebMemberID"]; }
if (list.IsColumnPresent("PhotoURL")) { obj.PhotoURL = (string)dr["PhotoURL"]; }
if (list.IsColumnPresent("NickName")) { obj.NickName = (string)dr["NickName"]; }
if (list.IsColumnPresent("FirstName")) { obj.FirstName = (string)dr["FirstName"]; }
if (list.IsColumnPresent("LastName")) { obj.LastName = (string)dr["LastName"]; }
if (list.IsColumnPresent("DTCreated")) { obj.DTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of PhotoCollections
/// </summary>
public static List <PhotoCollection> PopulatePhotoCollectionWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <PhotoCollection> arr = new List <PhotoCollection>();
PhotoCollection obj;
while (dr.Read())
{
obj = new PhotoCollection();
obj._photoCollectionID = (int)dr["PhotoCollectionID"];
obj._webPhotoCollectionID = (string)dr["WebPhotoCollectionID"];
obj._memberID = (int)dr["MemberID"];
obj._name = (string)dr["Name"];
obj._description = (string)dr["Description"];
obj._dTCreated = (DateTime)dr["DTCreated"];
if (list.IsColumnPresent("NumberOfPhotos"))
{
obj.NumberOfPhotos = (int)dr["NumberOfPhotos"];
}
if (list.IsColumnPresent("DefaultThumbnailURL"))
{
obj.DefaultThumbnailURL = (string)dr["DefaultThumbnailURL"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ChatOnlines
/// </summary>
public static List<ChatOnline> PopulateObjectWithJoinCustom(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ChatOnline> arr = new List<ChatOnline>();
ChatOnline obj;
while (dr.Read())
{
obj = new ChatOnline();
if (list.IsColumnPresent("ChatOnlineID")) { obj._chatOnlineID = (int)dr["ChatOnlineID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("LastCommDt")) { obj._lastCommDt = (DateTime)dr["LastCommDt"]; }
if (list.IsColumnPresent("Status")) { obj._status = (int)dr["Status"]; }
if (list.IsColumnPresent("NickName")) { obj.NickName = (string)dr["NickName"]; }
if (list.IsColumnPresent("FirstName")) { obj.FirstName = (string)dr["FirstName"]; }
if (list.IsColumnPresent("LastName")) { obj.LastName = (string)dr["LastName"]; }
if (list.IsColumnPresent("Email")) { obj.Email = (string)dr["Email"]; }
if (list.IsColumnPresent("WebMemberID")) { obj.WebMemberID = (string)dr["WebMemberID"]; }
if (list.IsColumnPresent("AvatorUrl")) { obj.AvatorUrl = (string)dr["AvatorUrl"]; }
if (list.IsColumnPresent("CustomMessage")) { obj.CustomMessage = (string)dr["CustomMessage"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
public static List <FriendTag> PopulateFriendTagWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <FriendTag> arr = new List <FriendTag>();
FriendTag obj;
while (dr.Read())
{
obj = new FriendTag();
if (list.IsColumnPresent("MemberID"))
{
obj.MemberID = (int)dr["MemberID"];
}
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("CountryName"))
{
obj.CountryName = (string)dr["CountryName"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("FirstName"))
{
obj.FirstName = (string)dr["FirstName"];
}
if (list.IsColumnPresent("LastName"))
{
obj.LastName = (string)dr["LastName"];
}
if (list.IsColumnPresent("ProfilePhotoURL"))
{
obj.ProfilePhotoURL = (string)dr["ProfilePhotoURL"];
}
if (list.IsColumnPresent("TaggedDT"))
{
obj.TaggedDT = (DateTime)dr["TaggedDT"];
}
if (list.IsColumnPresent("CreatedDT"))
{
obj._createdDT = (DateTime)dr["CreatedDT"];
}
arr.Add(obj);
}
return(arr);
}
//public static List<BlogComment> GetBlogCommentsByWebBlogEntryID(int BlogEntryID)
//{
// Database db = DatabaseFactory.CreateDatabase();
// DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBlogCommentByBlogEntryID");
// db.AddInParameter(dbCommand, "BlogEntryID", DbType.Int32, BlogEntryID);
// List<BlogComment> arr = null;
// // Populate the datareader
// using (IDataReader dr = db.ExecuteReader(dbCommand))
// {
// // Call the PopulateObject method passing the datareader to return the object array
// arr = Next2Friends.Data.BlogComment.PopulateBlogCommentWithJoin(dr);
// dr.Close();
// }
// return arr;
//}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of MemberComments
/// </summary>
public static List <MemberComment> PopulateMemberCommentWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <MemberComment> arr = new List <MemberComment>();
MemberComment obj;
while (dr.Read())
{
obj = new MemberComment();
if (list.IsColumnPresent("MemberCommentID"))
{
obj._memberCommentID = (int)dr["MemberCommentID"];
}
if (list.IsColumnPresent("MemberID"))
{
obj._memberID = (int)dr["MemberID"];
}
if (list.IsColumnPresent("MemberIDFrom"))
{
obj._memberIDFrom = (int)dr["MemberIDFrom"];
}
if (list.IsColumnPresent("Text"))
{
obj._text = (string)dr["Text"];
}
if (list.IsColumnPresent("DTCreated"))
{
obj._dTCreated = (DateTime)dr["DTCreated"];
}
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("PhotoUrl"))
{
obj.PhotoUrl = (string)dr["PhotoUrl"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ChatMessages
/// </summary>
public static List <ChatMessage> PopulateObjectWithJoinCustom(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <ChatMessage> arr = new List <ChatMessage>();
ChatMessage obj;
while (dr.Read())
{
obj = new ChatMessage();
if (list.IsColumnPresent("ChatMessageID"))
{
obj._chatMessageID = (int)dr["ChatMessageID"];
}
if (list.IsColumnPresent("ChatMessageWebID"))
{
obj._chatMessageWebID = (string)dr["ChatMessageWebID"];
}
if (list.IsColumnPresent("MemberIDFrom"))
{
obj._memberIDFrom = (int)dr["MemberIDFrom"];
}
if (list.IsColumnPresent("MemberIDTo"))
{
obj._memberIDTo = (int)dr["MemberIDTo"];
}
if (list.IsColumnPresent("Message"))
{
obj._message = (string)dr["Message"];
}
if (list.IsColumnPresent("Delivered"))
{
obj._delivered = (bool)dr["Delivered"];
}
if (list.IsColumnPresent("DTCreated"))
{
obj._dTCreated = (DateTime)dr["DTCreated"];
}
if (list.IsColumnPresent("WebMemberIDFrom"))
{
obj.WebMemberIDFrom = (String)dr["WebMemberIDFrom"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of AskAFriend. This function should be used internally only.
/// </summary>
public static List <AskAFriend> PopulateAskAFriendWithJoin(IDataReader dr)
{
List <AskAFriend> arr = new List <AskAFriend>();
ColumnFieldList list = new ColumnFieldList(dr);
AskAFriend AAF;
while (dr.Read())
{
AAF = new AskAFriend();
AAF._askAFriendID = (int)dr["AskAFriendID"];
AAF._memberID = (int)dr["MemberID"];
AAF._webAskAFriendID = (string)dr["WebAskAFriendID"];
AAF._numberOfPhotos = (int)dr["NumberOfPhotos"];
AAF._question = (string)dr["Question"];
AAF._responseType = (int)dr["ResponseType"];
AAF._duration = (int)dr["Duration"];
AAF._responseA = (string)dr["ResponseA"];
AAF._responseB = (string)dr["ResponseB"];
AAF._rejectScore = (int)dr["RejectScore"];
AAF._isPrivate = (bool)dr["IsPrivate"];
AAF._totalVotes = (int)dr["TotalVotes"];
AAF._active = (bool)dr["Active"];
AAF._wentLiveDT = (DateTime)dr["WentLiveDT"];
AAF._submittedDT = (DateTime)dr["SubmittedDT"];
AAF.DefaultImage = new ResourceFile();
AAF.DefaultImage.ResourceFileID = (int)dr["ResourceFileID"];
AAF.DefaultImage.WebResourceFileID = (string)dr["WebResourceFileID"];
AAF.DefaultImage.ResourceType = (int)dr["ResourceType"];
AAF.DefaultImage.StorageLocation = (int)dr["StorageLocation"];
AAF.DefaultImage.Server = (int)dr["Server"];
AAF.DefaultImage.Path = (string)dr["Path"];
AAF.DefaultImage.FileName = (string)dr["FileName"];
AAF.DefaultImage.CreatedDT = (DateTime)dr["CreatedDT"];
AAF.Member = new Member();
if (list.IsColumnPresent("Nickname"))
{
AAF.Member.NickName = (string)dr["Nickname"];
}
arr.Add(AAF);
}
dr.Close();
return(arr);
}
/// <summary>
/// Get an InviteClick by WebID
/// </summary>
/// <param name="WebInviteClickID">The WebID associated to the Click</param>
/// <returns>A Single InviteClick object</returns>
public static InviteClick GetInviteClickByWebInviteClickID(string WebInviteClickID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetInviteClickByInviteClickID");
db.AddInParameter(dbCommand, "WebInviteClickID", DbType.String, WebInviteClickID);
InviteClick inviteClick = null;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
inviteClick = new InviteClick();
if (list.IsColumnPresent("InviteClickID"))
{
inviteClick._inviteClickID = (int)dr["InviteClickID"];
}
if (list.IsColumnPresent("WebInviteClickID"))
{
inviteClick._webInviteClickID = (string)dr["WebInviteClickID"];
}
if (list.IsColumnPresent("ForwardURL"))
{
inviteClick._forwardURL = (string)dr["ForwardURL"];
}
if (list.IsColumnPresent("ContactImportID"))
{
inviteClick._contactImportID = (int)dr["ContactImportID"];
}
}
else
{
throw new ArgumentException(String.Format(Properties.Resources.Argument_InvalidWebInviteClickID, WebInviteClickID));
}
dr.Close();
}
return(inviteClick);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ContentViews
/// </summary>
public static List <ContentView> PopulateContentViewObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <ContentView> arr = new List <ContentView>();
ContentView obj;
while (dr.Read())
{
obj = new ContentView();
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("PhotoURL"))
{
obj.PhotoURL = (string)dr["PhotoURL"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("FirstName"))
{
obj.FirstName = (string)dr["FirstName"];
}
if (list.IsColumnPresent("LastName"))
{
obj.LastName = (string)dr["LastName"];
}
if (list.IsColumnPresent("DTCreated"))
{
obj.DTCreated = (DateTime)dr["DTCreated"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
///
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static AjaxComment[] PopulateAjaxComment(IDataReader dr)
{
List <AjaxComment> commentArr = new List <AjaxComment>();
AjaxComment ajaxComment;
ColumnFieldList list = new ColumnFieldList(dr);
while (dr.Read())
{
ajaxComment = new AjaxComment();
ajaxComment.WebMemberID = (string)dr["WebMemberID"];
ajaxComment.NickName = (string)dr["NickName"];
ajaxComment.PhotoUrl = ParallelServer.Get((string)dr["PhotoUrl"]) + "user/" + (string)dr["PhotoUrl"];
ajaxComment.Text = (string)dr["Text"];
ajaxComment.SentFromMobile = ((int)dr["SentFromMobile"]) == 1 ? true : false;
ajaxComment.DateTimePosted = TimeDistance.TimeAgo((DateTime)dr["DTCreated"]);
ajaxComment.DTCreated = (DateTime)dr["DTCreated"];
if (list.IsColumnPresent("WebCommentID"))
{
ajaxComment.WebCommentID = (string)dr["WebCommentID"];
}
if (list.IsColumnPresent("Path"))
{
ajaxComment.Path = (string)dr["Path"];
ajaxComment.Depth = GetDepth(ajaxComment.Path);
}
if (list.IsColumnPresent("IsDeleted"))
{
ajaxComment.IsDeleted = (bool)dr["IsDeleted"];
}
commentArr.Add(ajaxComment);
}
return(commentArr.ToArray());
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of FeaturedMembers
/// </summary>
public static List<FeaturedMember> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<FeaturedMember> arr = new List<FeaturedMember>();
FeaturedMember obj;
while (dr.Read())
{
obj = new FeaturedMember();
if (list.IsColumnPresent("FeaturedMemberID")) { obj._featuredMemberID = (int)dr["FeaturedMemberID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("Position")) { obj._position = (int)dr["Position"]; }
if (list.IsColumnPresent("IsDisplayed")) { obj._isDisplayed = (bool)dr["IsDisplayed"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Instanciates a EmailMessage object from the database via the EmailMessageID
/// </summary>
public EmailMessage(int EmailMessageID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetEmailMessageByEmailMessageID");
db.AddInParameter(dbCommand, "EmailMessageID", DbType.Int32, EmailMessageID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("EmailMessageID")) { this._emailMessageID = (int)dr["EmailMessageID"]; }
if (list.IsColumnPresent("WebEmailMessageID")) { this._webEmailMessageID = (string)dr["WebEmailMessageID"]; }
if (list.IsColumnPresent("ResourceFileID")) { this._resourceFileID = (int)dr["ResourceFileID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("EmailAddress")) { this._emailAddress = (string)dr["EmailAddress"]; }
if (list.IsColumnPresent("Text")) { this._text = (string)dr["Text"]; }
if (list.IsColumnPresent("IsRead")) { this._isRead = (bool)dr["IsRead"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no EmailMessage in the database with the ID " + EmailMessageID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a DeviceBlock object from the database via the DeviceBlockID
/// </summary>
public DeviceBlock(int DeviceBlockID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetDeviceBlockByDeviceBlockID");
db.AddInParameter(dbCommand, "DeviceBlockID", DbType.Int32, DeviceBlockID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("DeviceBlockID")) { this._deviceBlockID = (int)dr["DeviceBlockID"]; }
if (list.IsColumnPresent("DeviceTagID")) { this._deviceTagID = (string)dr["DeviceTagID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("BlockingMemberID")) { this._blockingMemberID = (int)dr["BlockingMemberID"]; }
if (list.IsColumnPresent("MACAddress")) { this._mACAddress = (string)dr["MACAddress"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no DeviceBlock in the database with the ID " + DeviceBlockID);
}
dr.Close();
}
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Dashboards
/// </summary>
public static List<Dashboard> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Dashboard> arr = new List<Dashboard>();
Dashboard obj;
while (dr.Read())
{
obj = new Dashboard();
if (list.IsColumnPresent("DashboardID")) { obj._dashboardID = (int)dr["DashboardID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("Inbox")) { obj._inbox = (int)dr["Inbox"]; }
if (list.IsColumnPresent("ProfileComment")) { obj._profileComment = (int)dr["ProfileComment"]; }
if (list.IsColumnPresent("FriendRequest")) { obj._friendRequest = (int)dr["FriendRequest"]; }
if (list.IsColumnPresent("FriendRequestAccept")) { obj._friendRequestAccept = (int)dr["FriendRequestAccept"]; }
if (list.IsColumnPresent("FriendRequestOutstanding")) { obj._friendRequestOutstanding = (int)dr["FriendRequestOutstanding"]; }
if (list.IsColumnPresent("NetworkNewVideo")) { obj._networkNewVideo = (int)dr["NetworkNewVideo"]; }
if (list.IsColumnPresent("NetworkNewGallery")) { obj._networkNewGallery = (int)dr["NetworkNewGallery"]; }
if (list.IsColumnPresent("NetworkUpdatedProfile")) { obj._networkUpdatedProfile = (int)dr["NetworkUpdatedProfile"]; }
if (list.IsColumnPresent("NetworkFavourite")) { obj._networkFavourite = (int)dr["NetworkFavourite"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ContentViews
/// </summary>
public static List<ContentView> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ContentView> arr = new List<ContentView>();
ContentView obj;
while (dr.Read())
{
obj = new ContentView();
if (list.IsColumnPresent("ContentViewID")) { obj._contentViewID = (int)dr["ContentViewID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("ObjectID")) { obj._objectID = (int)dr["ObjectID"]; }
if (list.IsColumnPresent("ObjectType")) { obj._objectType = (int)dr["ObjectType"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Photos
/// </summary>
public static List <Photo> PopulatePhotoWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <Photo> arr = new List <Photo>();
Photo obj;
while (dr.Read())
{
obj = new Photo();
obj._photoID = (int)dr["PhotoID"];
obj._webPhotoID = (string)dr["WebPhotoID"];
obj._photoCollectionID = (int)dr["PhotoCollectionID"];
obj._memberID = (int)dr["MemberID"];
obj._photoResourceFileID = (int)dr["PhotoResourceFileID"];
obj._thumbnailResourceFileID = (int)dr["ThumbnailResourceFileID"];
obj._width = (int)dr["Width"];
obj._height = (int)dr["Height"];
obj._totalVoteScore = (int)dr["TotalVoteScore"];
obj._numberOfViews = (int)dr["NumberOfViews"];
obj._numberOfComments = (int)dr["NumberOfComments"];
obj._active = (bool)dr["Active"];
obj._takenDT = (DateTime)dr["TakenDT"];
obj._createdDT = (DateTime)dr["CreatedDT"];
if (list.IsColumnPresent("Caption"))
{
obj.Caption = (string)dr["Caption"];
}
if (list.IsColumnPresent("Title"))
{
obj.Title = (string)dr["Title"];
}
if (list.IsColumnPresent("PhotoCollectionName"))
{
obj.PhotoCollectionName = (string)dr["PhotoCollectionName"];
}
if (list.IsColumnPresent("PhotoCollectionDescription"))
{
obj.PhotoCollectionDescription = (string)dr["PhotoCollectionDescription"];
}
if (list.IsColumnPresent("PhotoCollectionWebPhotoCollectionID"))
{
obj.WebPhotoCollectionID = (string)dr["PhotoCollectionWebPhotoCollectionID"];
}
obj.PhotoResourceFile = new ResourceFile();
if (list.IsColumnPresent("PhotoResourceFileResourceFileID"))
{
obj.PhotoResourceFile.ResourceFileID = (int)dr["PhotoResourceFileResourceFileID"];
}
if (list.IsColumnPresent("PhotoResourceFileWebResourceFileID"))
{
obj.PhotoResourceFile.WebResourceFileID = (string)dr["PhotoResourceFileWebResourceFileID"];
}
if (list.IsColumnPresent("PhotoResourceFileResourceType"))
{
obj.PhotoResourceFile.ResourceType = (int)dr["PhotoResourceFileResourceType"];
}
if (list.IsColumnPresent("PhotoResourceFileStorageLocation"))
{
obj.PhotoResourceFile.StorageLocation = (int)dr["PhotoResourceFileStorageLocation"];
}
if (list.IsColumnPresent("PhotoResourceFileServer"))
{
obj.PhotoResourceFile.Server = (int)dr["PhotoResourceFileServer"];
}
if (list.IsColumnPresent("PhotoResourceFilePath"))
{
obj.PhotoResourceFile.Path = (string)dr["PhotoResourceFilePath"];
}
if (list.IsColumnPresent("PhotoResourceFileFileName"))
{
obj.PhotoResourceFile.FileName = (string)dr["PhotoResourceFileFileName"];
}
if (list.IsColumnPresent("PhotoResourceFileCreatedDT"))
{
obj.PhotoResourceFile.CreatedDT = (DateTime)dr["PhotoResourceFileCreatedDT"];
}
obj.ThumbnailResourceFile = new ResourceFile();
if (list.IsColumnPresent("ThumbnailResourceFileResourceFileID"))
{
obj.ThumbnailResourceFile.ResourceFileID = (int)dr["ThumbnailResourceFileResourceFileID"];
}
if (list.IsColumnPresent("ThumbnailResourceFileWebResourceFileID"))
{
obj.ThumbnailResourceFile.WebResourceFileID = (string)dr["ThumbnailResourceFileWebResourceFileID"];
}
if (list.IsColumnPresent("ThumbnailResourceFileResourceType"))
{
obj.ThumbnailResourceFile.ResourceType = (int)dr["ThumbnailResourceFileResourceType"];
}
if (list.IsColumnPresent("ThumbnailResourceFileStorageLocation"))
{
obj.ThumbnailResourceFile.StorageLocation = (int)dr["ThumbnailResourceFileStorageLocation"];
}
if (list.IsColumnPresent("ThumbnailResourceFileServer"))
{
obj.ThumbnailResourceFile.Server = (int)dr["ThumbnailResourceFileServer"];
}
if (list.IsColumnPresent("ThumbnailResourceFilePath"))
{
obj.ThumbnailResourceFile.Path = (string)dr["ThumbnailResourceFilePath"];
}
if (list.IsColumnPresent("ThumbnailResourceFileFileName"))
{
obj.ThumbnailResourceFile.FileName = (string)dr["ThumbnailResourceFileFileName"];
}
if (list.IsColumnPresent("ThumbnailResourceFileCreatedDT"))
{
obj.ThumbnailResourceFile.CreatedDT = (DateTime)dr["ThumbnailResourceFileCreatedDT"];
}
obj.Member = new Member();
if (list.IsColumnPresent("MemberMemberID"))
{
obj.Member.MemberID = (int)dr["MemberMemberID"];
}
if (list.IsColumnPresent("MemberWebMemberID"))
{
obj.Member.WebMemberID = (string)dr["MemberWebMemberID"];
}
if (list.IsColumnPresent("MemberAdminStatusID"))
{
obj.Member.AdminStatusID = (int)dr["MemberAdminStatusID"];
}
if (list.IsColumnPresent("MemberNickName"))
{
obj.Member.NickName = (string)dr["MemberNickName"];
}
if (list.IsColumnPresent("MemberChannelID"))
{
obj.Member.ChannelID = (int)dr["MemberChannelID"];
}
if (list.IsColumnPresent("MemberPassword"))
{
obj.Member.Password = (string)dr["MemberPassword"];
}
if (list.IsColumnPresent("MemberEmail"))
{
obj.Member.Email = (string)dr["MemberEmail"];
}
if (list.IsColumnPresent("MemberGender"))
{
obj.Member.Gender = (int)dr["MemberGender"];
}
if (list.IsColumnPresent("MemberFirstName"))
{
obj.Member.FirstName = (string)dr["MemberFirstName"];
}
if (list.IsColumnPresent("MemberLastName"))
{
obj.Member.LastName = (string)dr["MemberLastName"];
}
if (list.IsColumnPresent("MemberProfilePhotoResourceFileID"))
{
obj.Member.ProfilePhotoResourceFileID = (int)dr["MemberProfilePhotoResourceFileID"];
}
if (list.IsColumnPresent("MemberDOB"))
{
obj.Member.DOB = (DateTime)dr["MemberDOB"];
}
if (list.IsColumnPresent("MemberISOCountry"))
{
obj.Member.ISOCountry = (string)dr["MemberISOCountry"];
}
if (list.IsColumnPresent("MemberZipPostcode"))
{
obj.Member.ZipPostcode = (string)dr["MemberZipPostcode"];
}
if (list.IsColumnPresent("MemberCreatedDT"))
{
obj.Member.CreatedDT = (DateTime)dr["MemberCreatedDT"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Comments
/// </summary>
public static List <Comment> PopulateCommentWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <Comment> arr = new List <Comment>();
Comment obj;
while (dr.Read())
{
obj = new Comment();
if (list.IsColumnPresent("CommentID"))
{
obj._commentID = (int)dr["CommentID"];
}
if (list.IsColumnPresent("WebCommentID"))
{
obj._webCommentID = (string)dr["WebCommentID"];
}
if (list.IsColumnPresent("ObjectID"))
{
obj._objectID = (int)dr["ObjectID"];
}
if (list.IsColumnPresent("MemberIDFrom"))
{
obj._memberIDFrom = (int)dr["MemberIDFrom"];
}
if (list.IsColumnPresent("InReplyToCommentID"))
{
obj._inReplyToCommentID = (int)dr["InReplyToCommentID"];
}
if (list.IsColumnPresent("Text"))
{
obj._text = (string)dr["Text"];
}
if (list.IsColumnPresent("IsDeleted"))
{
obj._isDeleted = (bool)dr["IsDeleted"];
}
if (list.IsColumnPresent("Path"))
{
obj._path = (string)dr["Path"];
}
if (list.IsColumnPresent("CommentType"))
{
obj._commentType = (int)dr["CommentType"];
}
if (list.IsColumnPresent("DTCreated"))
{
obj._dTCreated = (DateTime)dr["DTCreated"];
}
if (list.IsColumnPresent("ThreadNo"))
{
obj._threadNo = (int)dr["ThreadNo"];
}
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("PhotoUrl"))
{
obj.PhotoUrl = (string)dr["PhotoUrl"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of LiveBroadcasts
/// </summary>
public static List <LiveBroadcast> PopulateLiveBroadcastWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <LiveBroadcast> arr = new List <LiveBroadcast>();
LiveBroadcast obj;
while (dr.Read())
{
obj = new LiveBroadcast();
if (list.IsColumnPresent("LiveBroadcastID"))
{
obj._liveBroadcastID = (int)dr["LiveBroadcastID"];
}
if (list.IsColumnPresent("WebLiveBroadcastID"))
{
obj._webLiveBroadcastID = (string)dr["WebLiveBroadcastID"];
}
if (list.IsColumnPresent("ThumbnailResourceFileID"))
{
obj._thumbnailResourceFileID = (int)dr["ThumbnailResourceFileID"];
}
if (list.IsColumnPresent("MemberID"))
{
obj._memberID = (int)dr["MemberID"];
}
if (list.IsColumnPresent("BroadcastSource"))
{
obj._broadcastSource = (int)dr["BroadcastSource"];
}
if (list.IsColumnPresent("Title"))
{
obj._title = (string)dr["Title"];
}
if (list.IsColumnPresent("Description"))
{
obj._description = (string)dr["Description"];
}
if (list.IsColumnPresent("DTStart"))
{
obj._dTStart = (DateTime)dr["DTStart"];
}
if (list.IsColumnPresent("DTEnd"))
{
obj._dTEnd = (DateTime)dr["DTEnd"];
}
if (list.IsColumnPresent("Duration"))
{
obj._duration = (int)dr["Duration"];
}
if (list.IsColumnPresent("LiveNow"))
{
obj._liveNow = (bool)dr["LiveNow"];
}
if (list.IsColumnPresent("ThumbnailURL"))
{
obj.ThumbnailURL = (string)dr["ThumbnailURL"];
}
obj.Member = new Member();
if (list.IsColumnPresent("Nickname"))
{
obj.Member.NickName = (string)dr["Nickname"];
}
if (list.IsColumnPresent("ISOCountry"))
{
obj.Member.ISOCountry = (string)dr["ISOCountry"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Members
/// </summary>
public static List <Member> PopulateMemberWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <Member> arr = new List <Member>();
Member obj;
while (dr.Read())
{
obj = new Member();
obj._memberID = (int)dr["MemberID"];
obj._webMemberID = (string)dr["WebMemberID"];
obj._adminStatusID = (int)dr["AdminStatusID"];
obj._nickName = (string)dr["NickName"];
obj._channelID = (int)dr["ChannelID"];
obj._password = (string)dr["Password"];
obj._email = (string)dr["Email"];
obj._gender = (int)dr["Gender"];
obj._firstName = (string)dr["FirstName"];
obj._lastName = (string)dr["LastName"];
obj._profilePhotoResourceFileID = (int)dr["ProfilePhotoResourceFileID"];
obj._dOB = (DateTime)dr["DOB"];
obj._iSOCountry = (string)dr["ISOCountry"];
if (list.IsColumnPresent("ISOCode"))
{
obj.ISOCode = (string)dr["ISOCode"];
}
obj._zipPostcode = (string)dr["ZipPostcode"];
obj._createdDT = (DateTime)dr["CreatedDT"];
//obj._accountType = (int)dr["AccountType"];
if (list.IsColumnPresent("AccountType"))
{
obj._accountType = (int)dr["AccountType"];
}
if (list.IsColumnPresent("DTOnline"))
{
obj.LastOnline = (DateTime)dr["DTOnline"];
}
if (list.IsColumnPresent("IsFriend"))
{
obj.IsFriend = (bool)dr["IsFriend"];
}
obj.DefaultPhoto = new ResourceFile();
if (list.IsColumnPresent("DefaultPhotoResourceFileID"))
{
obj.DefaultPhoto.ResourceFileID = (int)dr["DefaultPhotoResourceFileID"];
}
if (list.IsColumnPresent("DefaultPhotoWebResourceFileID"))
{
obj.DefaultPhoto.WebResourceFileID = (string)dr["DefaultPhotoWebResourceFileID"];
}
if (list.IsColumnPresent("DefaultPhotoResourceType"))
{
obj.DefaultPhoto.ResourceType = (int)dr["DefaultPhotoResourceType"];
}
if (list.IsColumnPresent("DefaultPhotoStorageLocation"))
{
obj.DefaultPhoto.StorageLocation = (int)dr["DefaultPhotoStorageLocation"];
}
if (list.IsColumnPresent("DefaultPhotoServer"))
{
obj.DefaultPhoto.Server = (int)dr["DefaultPhotoServer"];
}
if (list.IsColumnPresent("DefaultPhotoPath"))
{
obj.DefaultPhoto.Path = (string)dr["DefaultPhotoPath"];
}
if (list.IsColumnPresent("DefaultPhotoFileName"))
{
obj.DefaultPhoto.FileName = (string)dr["DefaultPhotoFileName"];
}
if (list.IsColumnPresent("DefaultPhotoCreatedDT"))
{
obj.DefaultPhoto.CreatedDT = (DateTime)dr["DefaultPhotoCreatedDT"];
}
if (list.IsColumnPresent("DeviceID"))
{
obj.device = new List <Device>();
obj.device.Add(new Device());
}
if (list.IsColumnPresent("DeviceID"))
{
obj.device[0].DeviceID = (int)dr["DeviceID"];
}
if (list.IsColumnPresent("DeviceTagID"))
{
obj.device[0].DeviceTagID = (string)dr["DeviceTagID"];
}
if (list.IsColumnPresent("DeviceMemberID"))
{
obj.device[0].MemberID = (int)dr["DeviceMemberID"];
}
if (list.IsColumnPresent("DevicePrivateEncryptionKey"))
{
obj.device[0].PrivateEncryptionKey = (string)dr["DevicePrivateEncryptionKey"];
}
if (list.IsColumnPresent("DeviceCreatedDT"))
{
obj.device[0].CreatedDT = (DateTime)dr["DeviceCreatedDT"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ContentInvites
/// </summary>
public static List<ContentInvite> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ContentInvite> arr = new List<ContentInvite>();
ContentInvite obj;
while (dr.Read())
{
obj = new ContentInvite();
if (list.IsColumnPresent("ContentInviteID")) { obj._contentInviteID = (int)dr["ContentInviteID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("ObjectID")) { obj._objectID = (int)dr["ObjectID"]; }
if (list.IsColumnPresent("ObjectType")) { obj._objectType = (int)dr["ObjectType"]; }
if (list.IsColumnPresent("EmailAddress")) { obj._emailAddress = (string)dr["EmailAddress"]; }
if (list.IsColumnPresent("Link")) { obj._link = (string)dr["Link"]; }
if (list.IsColumnPresent("CustomMessage")) { obj._customMessage = (string)dr["CustomMessage"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of EmailMessages
/// </summary>
public static List<EmailMessage> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<EmailMessage> arr = new List<EmailMessage>();
EmailMessage obj;
while (dr.Read())
{
obj = new EmailMessage();
if (list.IsColumnPresent("EmailMessageID")) { obj._emailMessageID = (int)dr["EmailMessageID"]; }
if (list.IsColumnPresent("WebEmailMessageID")) { obj._webEmailMessageID = (string)dr["WebEmailMessageID"]; }
if (list.IsColumnPresent("ResourceFileID")) { obj._resourceFileID = (int)dr["ResourceFileID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("EmailAddress")) { obj._emailAddress = (string)dr["EmailAddress"]; }
if (list.IsColumnPresent("Text")) { obj._text = (string)dr["Text"]; }
if (list.IsColumnPresent("IsRead")) { obj._isRead = (bool)dr["IsRead"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Instanciates a ContentView object from the database via the ContentViewID
/// </summary>
public ContentView(int ContentViewID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetContentViewByContentViewID");
db.AddInParameter(dbCommand, "ContentViewID", DbType.Int32, ContentViewID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("ContentViewID")) { this._contentViewID = (int)dr["ContentViewID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("ObjectID")) { this._objectID = (int)dr["ObjectID"]; }
if (list.IsColumnPresent("ObjectType")) { this._objectType = (int)dr["ObjectType"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no ContentView in the database with the ID " + ContentViewID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a EmailReferral object from the database via the EmailReferralID
/// </summary>
public EmailReferral(int EmailReferralID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetEmailReferralByEmailReferralID");
db.AddInParameter(dbCommand, "EmailReferralID", DbType.Int32, EmailReferralID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("EmailReferralID")) { this._emailReferralID = (int)dr["EmailReferralID"]; }
if (list.IsColumnPresent("NewMemberID")) { this._newMemberID = (int)dr["NewMemberID"]; }
if (list.IsColumnPresent("Email")) { this._email = (string)dr["Email"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no EmailReferral in the database with the ID " + EmailReferralID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a Dashboard object from the database via the DashboardID
/// </summary>
public Dashboard(int DashboardID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetDashboardByDashboardID");
db.AddInParameter(dbCommand, "DashboardID", DbType.Int32, DashboardID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("DashboardID")) { this._dashboardID = (int)dr["DashboardID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("Inbox")) { this._inbox = (int)dr["Inbox"]; }
if (list.IsColumnPresent("ProfileComment")) { this._profileComment = (int)dr["ProfileComment"]; }
if (list.IsColumnPresent("FriendRequest")) { this._friendRequest = (int)dr["FriendRequest"]; }
if (list.IsColumnPresent("FriendRequestAccept")) { this._friendRequestAccept = (int)dr["FriendRequestAccept"]; }
if (list.IsColumnPresent("FriendRequestOutstanding")) { this._friendRequestOutstanding = (int)dr["FriendRequestOutstanding"]; }
if (list.IsColumnPresent("NetworkNewVideo")) { this._networkNewVideo = (int)dr["NetworkNewVideo"]; }
if (list.IsColumnPresent("NetworkNewGallery")) { this._networkNewGallery = (int)dr["NetworkNewGallery"]; }
if (list.IsColumnPresent("NetworkUpdatedProfile")) { this._networkUpdatedProfile = (int)dr["NetworkUpdatedProfile"]; }
if (list.IsColumnPresent("NetworkFavourite")) { this._networkFavourite = (int)dr["NetworkFavourite"]; }
}
else
{
throw new Exception("There is no Dashboard in the database with the ID " + DashboardID);
}
dr.Close();
}
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of EmailReferrals
/// </summary>
public static List<EmailReferral> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<EmailReferral> arr = new List<EmailReferral>();
EmailReferral obj;
while (dr.Read())
{
obj = new EmailReferral();
if (list.IsColumnPresent("EmailReferralID")) { obj._emailReferralID = (int)dr["EmailReferralID"]; }
if (list.IsColumnPresent("NewMemberID")) { obj._newMemberID = (int)dr["NewMemberID"]; }
if (list.IsColumnPresent("Email")) { obj._email = (string)dr["Email"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Devices
/// </summary>
public static List<Device> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Device> arr = new List<Device>();
Device obj;
while (dr.Read())
{
obj = new Device();
if (list.IsColumnPresent("DeviceID")) { obj._deviceID = (int)dr["DeviceID"]; }
if (list.IsColumnPresent("DeviceTagID")) { obj._deviceTagID = (string)dr["DeviceTagID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("PrivateEncryptionKey")) { obj._privateEncryptionKey = (string)dr["PrivateEncryptionKey"]; }
if (list.IsColumnPresent("CreatedDT")) { obj._createdDT = (DateTime)dr["CreatedDT"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of AdminStatuss
/// </summary>
public static List<AdminStatus> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<AdminStatus> arr = new List<AdminStatus>();
AdminStatus obj;
while (dr.Read())
{
obj = new AdminStatus();
if (list.IsColumnPresent("AdminStatusID")) { obj._adminStatusID = (int)dr["AdminStatusID"]; }
if (list.IsColumnPresent("Description")) { obj._description = (string)dr["Description"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of DeviceBlocks
/// </summary>
public static List<DeviceBlock> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<DeviceBlock> arr = new List<DeviceBlock>();
DeviceBlock obj;
while (dr.Read())
{
obj = new DeviceBlock();
if (list.IsColumnPresent("DeviceBlockID")) { obj._deviceBlockID = (int)dr["DeviceBlockID"]; }
if (list.IsColumnPresent("DeviceTagID")) { obj._deviceTagID = (string)dr["DeviceTagID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("BlockingMemberID")) { obj._blockingMemberID = (int)dr["BlockingMemberID"]; }
if (list.IsColumnPresent("MACAddress")) { obj._mACAddress = (string)dr["MACAddress"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of FeaturedChannels
/// </summary>
public static List<FeaturedChannel> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<FeaturedChannel> arr = new List<FeaturedChannel>();
FeaturedChannel obj;
while (dr.Read())
{
obj = new FeaturedChannel();
if (list.IsColumnPresent("FeaturedChannelID")) { obj._featuredChannelID = (int)dr["FeaturedChannelID"]; }
if (list.IsColumnPresent("Position")) { obj._position = (int)dr["Position"]; }
if (list.IsColumnPresent("ChannelID")) { obj._channelID = (int)dr["ChannelID"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of EmailMessages
/// </summary>
public static List<EmailMessage> PopulateObjectWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<EmailMessage> arr = new List<EmailMessage>();
EmailMessage obj;
while (dr.Read())
{
obj = new EmailMessage();
if (list.IsColumnPresent("EmailMessageID")) { obj._emailMessageID = (int)dr["EmailMessageID"]; }
if (list.IsColumnPresent("WebEmailMessageID")) { obj._webEmailMessageID = (string)dr["WebEmailMessageID"]; }
if (list.IsColumnPresent("ResourceFileID")) { obj._resourceFileID = (int)dr["ResourceFileID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("EmailAddress")) { obj._emailAddress = (string)dr["EmailAddress"]; }
if (list.IsColumnPresent("Text")) { obj._text = (string)dr["Text"]; }
if (list.IsColumnPresent("IsRead")) { obj._isRead = (bool)dr["IsRead"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
obj.VideoMessage = new ResourceFile();
if (list.IsColumnPresent("VideoMessageResourceFileID")) { obj.VideoMessage.ResourceFileID = (int)dr["VideoMessageResourceFileID"]; }
if (list.IsColumnPresent("VideoMessageWebResourceFileID")) { obj.VideoMessage.WebResourceFileID = (string)dr["VideoMessageWebResourceFileID"]; }
if (list.IsColumnPresent("VideoMessageResourceType")) { obj.VideoMessage.ResourceType = (int)dr["VideoMessageResourceType"]; }
if (list.IsColumnPresent("VideoMessageStorageLocation")) { obj.VideoMessage.StorageLocation = (int)dr["VideoMessageStorageLocation"]; }
if (list.IsColumnPresent("VideoMessageServer")) { obj.VideoMessage.Server = (int)dr["VideoMessageServer"]; }
if (list.IsColumnPresent("VideoMessagePath")) { obj.VideoMessage.Path = (string)dr["VideoMessagePath"]; }
if (list.IsColumnPresent("VideoMessageFileName")) { obj.VideoMessage.FileName = (string)dr["VideoMessageFileName"]; }
if (list.IsColumnPresent("VideoMessageCreatedDT")) { obj.VideoMessage.CreatedDT = (DateTime)dr["VideoMessageCreatedDT"]; }
obj.Member = new Member();
if (list.IsColumnPresent("MemberMemberID")) { obj.Member.MemberID = (int)dr["MemberMemberID"]; }
if (list.IsColumnPresent("MemberWebMemberID")) { obj.Member.WebMemberID = (string)dr["MemberWebMemberID"]; }
if (list.IsColumnPresent("MemberAdminStatusID")) { obj.Member.AdminStatusID = (int)dr["MemberAdminStatusID"]; }
if (list.IsColumnPresent("MemberNickName")) { obj.Member.NickName = (string)dr["MemberNickName"]; }
if (list.IsColumnPresent("MemberChannelID")) { obj.Member.ChannelID = (int)dr["MemberChannelID"]; }
if (list.IsColumnPresent("MemberPassword")) { obj.Member.Password = (string)dr["MemberPassword"]; }
if (list.IsColumnPresent("MemberEmail")) { obj.Member.Email = (string)dr["MemberEmail"]; }
if (list.IsColumnPresent("MemberGender")) { obj.Member.Gender = (int)dr["MemberGender"]; }
if (list.IsColumnPresent("MemberFirstName")) { obj.Member.FirstName = (string)dr["MemberFirstName"]; }
if (list.IsColumnPresent("MemberLastName")) { obj.Member.LastName = (string)dr["MemberLastName"]; }
if (list.IsColumnPresent("MemberProfilePhotoResourceFileID")) { obj.Member.ProfilePhotoResourceFileID = (int)dr["MemberProfilePhotoResourceFileID"]; }
if (list.IsColumnPresent("MemberDOB")) { obj.Member.DOB = (DateTime)dr["MemberDOB"]; }
if (list.IsColumnPresent("MemberISOCountry")) { obj.Member.ISOCountry = (string)dr["MemberISOCountry"]; }
if (list.IsColumnPresent("MemberAccountType")) { obj.Member.AccountType = (int)dr["MemberAccountType"]; }
if (list.IsColumnPresent("MemberZipPostcode")) { obj.Member.ZipPostcode = (string)dr["MemberZipPostcode"]; }
if (list.IsColumnPresent("MemberPhoneNumber")) { obj.Member.PhoneNumber = (string)dr["MemberPhoneNumber"]; }
if (list.IsColumnPresent("MemberMobilePhoneID")) { obj.Member.MobilePhoneID = (int)dr["MemberMobilePhoneID"]; }
if (list.IsColumnPresent("MemberIPLocationID")) { obj.Member.IPLocationID = (int)dr["MemberIPLocationID"]; }
if (list.IsColumnPresent("MemberCreatedDT")) { obj.Member.CreatedDT = (DateTime)dr["MemberCreatedDT"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ChatOnlines
/// </summary>
public static List <ChatOnline> PopulateObjectWithJoinCustom(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <ChatOnline> arr = new List <ChatOnline>();
ChatOnline obj;
while (dr.Read())
{
obj = new ChatOnline();
if (list.IsColumnPresent("ChatOnlineID"))
{
obj._chatOnlineID = (int)dr["ChatOnlineID"];
}
if (list.IsColumnPresent("MemberID"))
{
obj._memberID = (int)dr["MemberID"];
}
if (list.IsColumnPresent("LastCommDt"))
{
obj._lastCommDt = (DateTime)dr["LastCommDt"];
}
if (list.IsColumnPresent("Status"))
{
obj._status = (int)dr["Status"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("FirstName"))
{
obj.FirstName = (string)dr["FirstName"];
}
if (list.IsColumnPresent("LastName"))
{
obj.LastName = (string)dr["LastName"];
}
if (list.IsColumnPresent("Email"))
{
obj.Email = (string)dr["Email"];
}
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("AvatorUrl"))
{
obj.AvatorUrl = (string)dr["AvatorUrl"];
}
if (list.IsColumnPresent("CustomMessage"))
{
obj.CustomMessage = (string)dr["CustomMessage"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Instanciates a AdminStatus object from the database via the AdminStatusID
/// </summary>
public AdminStatus(int AdminStatusID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetAdminStatusByAdminStatusID");
db.AddInParameter(dbCommand, "AdminStatusID", DbType.Int32, AdminStatusID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("AdminStatusID")) { this._adminStatusID = (int)dr["AdminStatusID"]; }
if (list.IsColumnPresent("Description")) { this._description = (string)dr["Description"]; }
}
else
{
throw new Exception("There is no AdminStatus in the database with the ID " + AdminStatusID);
}
dr.Close();
}
}
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);
}
/// <summary>
/// Instanciates a Abuse object from the database via the AbuseID
/// </summary>
public Abuse(int AbuseID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetAbuseByAbuseID");
db.AddInParameter(dbCommand, "AbuseID", DbType.Int32, AbuseID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("AbuseID")) { this._abuseID = (int)dr["AbuseID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("ResourceFileID")) { this._resourceFileID = (string)dr["ResourceFileID"]; }
if (list.IsColumnPresent("URL")) { this._uRL = (string)dr["URL"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no Abuse in the database with the ID " + AbuseID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a Comment object from the database via the CommentID
/// </summary>
public Comment(int CommentID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetCommentByCommentID");
db.AddInParameter(dbCommand, "CommentID", DbType.Int32, CommentID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("CommentID")) { this._commentID = (int)dr["CommentID"]; }
if (list.IsColumnPresent("WebCommentID")) { this._webCommentID = (string)dr["WebCommentID"]; }
if (list.IsColumnPresent("ObjectID")) { this._objectID = (int)dr["ObjectID"]; }
if (list.IsColumnPresent("MemberIDFrom")) { this._memberIDFrom = (int)dr["MemberIDFrom"]; }
if (list.IsColumnPresent("InReplyToCommentID")) { this._inReplyToCommentID = (int)dr["InReplyToCommentID"]; }
if (list.IsColumnPresent("Text")) { this._text = (string)dr["Text"]; }
if (list.IsColumnPresent("IsDeleted")) { this._isDeleted = (bool)dr["IsDeleted"]; }
if (list.IsColumnPresent("Path")) { this._path = (string)dr["Path"]; }
if (list.IsColumnPresent("CommentType")) { this._commentType = (int)dr["CommentType"]; }
if (list.IsColumnPresent("ThreadNo")) { this._threadNo = (int)dr["ThreadNo"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
if (list.IsColumnPresent("SentFromMobile")) { this._sentFromMobile = (int)dr["SentFromMobile"]; }
}
else
{
throw new Exception("There is no Comment in the database with the ID " + CommentID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a FavouriteGroup object from the database via the FavouriteGroupID
/// </summary>
public FavouriteGroup(int FavouriteGroupID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFavouriteGroupByFavouriteGroupID");
db.AddInParameter(dbCommand, "FavouriteGroupID", DbType.Int32, FavouriteGroupID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("FavouriteGroupID")) { this._favouriteGroupID = (int)dr["FavouriteGroupID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("TheFavouriteGroupID")) { this._theFavouriteGroupID = (int)dr["TheFavouriteGroupID"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no FavouriteGroup in the database with the ID " + FavouriteGroupID);
}
dr.Close();
}
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Comments
/// </summary>
public static List<Comment> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Comment> arr = new List<Comment>();
Comment obj;
while (dr.Read())
{
obj = new Comment();
if (list.IsColumnPresent("CommentID")) { obj._commentID = (int)dr["CommentID"]; }
if (list.IsColumnPresent("WebCommentID")) { obj._webCommentID = (string)dr["WebCommentID"]; }
if (list.IsColumnPresent("ObjectID")) { obj._objectID = (int)dr["ObjectID"]; }
if (list.IsColumnPresent("MemberIDFrom")) { obj._memberIDFrom = (int)dr["MemberIDFrom"]; }
if (list.IsColumnPresent("InReplyToCommentID")) { obj._inReplyToCommentID = (int)dr["InReplyToCommentID"]; }
if (list.IsColumnPresent("Text")) { obj._text = (string)dr["Text"]; }
if (list.IsColumnPresent("IsDeleted")) { obj._isDeleted = (bool)dr["IsDeleted"]; }
if (list.IsColumnPresent("Path")) { obj._path = (string)dr["Path"]; }
if (list.IsColumnPresent("CommentType")) { obj._commentType = (int)dr["CommentType"]; }
if (list.IsColumnPresent("ThreadNo")) { obj._threadNo = (int)dr["ThreadNo"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
if (list.IsColumnPresent("SentFromMobile")) { obj._sentFromMobile = (int)dr["SentFromMobile"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of FavouriteMembers
/// </summary>
public static List<FavouriteMember> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<FavouriteMember> arr = new List<FavouriteMember>();
FavouriteMember obj;
while (dr.Read())
{
obj = new FavouriteMember();
if (list.IsColumnPresent("FavouriteMemberID")) { obj._favouriteMemberID = (int)dr["FavouriteMemberID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("TheFavouriteMemberID")) { obj._theFavouriteMemberID = (int)dr["TheFavouriteMemberID"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Instanciates a ContactImport object from the database via the ContactImportID
/// </summary>
public ContactImport(int ContactImportID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetContactImportByContactImportID");
db.AddInParameter(dbCommand, "ContactImportID", DbType.Int32, ContactImportID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("ContactImportID")) { this._contactImportID = (int)dr["ContactImportID"]; }
if (list.IsColumnPresent("ImporterMemberID")) { this._importerMemberID = (int)dr["ImporterMemberID"]; }
if (list.IsColumnPresent("Email")) { this._email = (string)dr["Email"]; }
if (list.IsColumnPresent("Name")) { this._name = (string)dr["Name"]; }
if (list.IsColumnPresent("InviteState")) { this._inviteState = (int)dr["InviteState"]; }
if (list.IsColumnPresent("FriendState")) { this._friendState = (int)dr["FriendState"]; }
if (list.IsColumnPresent("OpenedEmailInvite")) { this._openedEmailInvite = (bool)dr["OpenedEmailInvite"]; }
if (list.IsColumnPresent("ClickedEmailInvite")) { this._clickedEmailInvite = (bool)dr["ClickedEmailInvite"]; }
if (list.IsColumnPresent("JoinedFromInvite")) { this._joinedFromInvite = (bool)dr["JoinedFromInvite"]; }
if (list.IsColumnPresent("BecameMemberID")) { this._becameMemberID = (int)dr["BecameMemberID"]; }
if (list.IsColumnPresent("ImportToken")) { this._importToken = (string)dr["ImportToken"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no ContactImport in the database with the ID " + ContactImportID);
}
dr.Close();
}
}
/// <summary>
/// Instanciates a FeaturedMember object from the database via the FeaturedMemberID
/// </summary>
public FeaturedMember(int FeaturedMemberID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFeaturedMemberByFeaturedMemberID");
db.AddInParameter(dbCommand, "FeaturedMemberID", DbType.Int32, FeaturedMemberID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("FeaturedMemberID")) { this._featuredMemberID = (int)dr["FeaturedMemberID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("Position")) { this._position = (int)dr["Position"]; }
if (list.IsColumnPresent("IsDisplayed")) { this._isDisplayed = (bool)dr["IsDisplayed"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no FeaturedMember in the database with the ID " + FeaturedMemberID);
}
dr.Close();
}
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of ContactImports
/// </summary>
public static List<ContactImport> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<ContactImport> arr = new List<ContactImport>();
ContactImport obj;
while (dr.Read())
{
obj = new ContactImport();
if (list.IsColumnPresent("ContactImportID")) { obj._contactImportID = (int)dr["ContactImportID"]; }
if (list.IsColumnPresent("ImporterMemberID")) { obj._importerMemberID = (int)dr["ImporterMemberID"]; }
if (list.IsColumnPresent("Email")) { obj._email = (string)dr["Email"]; }
if (list.IsColumnPresent("Name")) { obj._name = (string)dr["Name"]; }
if (list.IsColumnPresent("InviteState")) { obj._inviteState = (int)dr["InviteState"]; }
if (list.IsColumnPresent("FriendState")) { obj._friendState = (int)dr["FriendState"]; }
if (list.IsColumnPresent("OpenedEmailInvite")) { obj._openedEmailInvite = (bool)dr["OpenedEmailInvite"]; }
if (list.IsColumnPresent("ClickedEmailInvite")) { obj._clickedEmailInvite = (bool)dr["ClickedEmailInvite"]; }
if (list.IsColumnPresent("JoinedFromInvite")) { obj._joinedFromInvite = (bool)dr["JoinedFromInvite"]; }
if (list.IsColumnPresent("BecameMemberID")) { obj._becameMemberID = (int)dr["BecameMemberID"]; }
if (list.IsColumnPresent("ImportToken")) { obj._importToken = (string)dr["ImportToken"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Instanciates a Feedback object from the database via the FeedbackID
/// </summary>
public Feedback(int FeedbackID)
{
db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFeedbackByFeedbackID");
db.AddInParameter(dbCommand, "FeedbackID", DbType.Int32, FeedbackID);
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
ColumnFieldList list = new ColumnFieldList(dr);
if (dr.Read())
{
if (list.IsColumnPresent("FeedbackID")) { this._feedbackID = (int)dr["FeedbackID"]; }
if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("Name")) { this._name = (string)dr["Name"]; }
if (list.IsColumnPresent("EmailAddress")) { this._emailAddress = (string)dr["EmailAddress"]; }
if (list.IsColumnPresent("Text")) { this._text = (string)dr["Text"]; }
if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; }
}
else
{
throw new Exception("There is no Feedback in the database with the ID " + FeedbackID);
}
dr.Close();
}
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of FriendRequests
/// </summary>
public static List <FriendRequest> PopulateFriendRequestWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <FriendRequest> arr = new List <FriendRequest>();
FriendRequest obj;
while (dr.Read())
{
obj = new FriendRequest();
obj._friendRequestID = (int)dr["FriendRequestID"];
obj._webFriendRequestID = (string)dr["WebFriendRequestID"];
obj._memberID = (int)dr["MemberID"];
obj._origin = (int)dr["Origin"];
obj._friendMemberID = (int)dr["FriendMemberID"];
obj._status = (int)dr["Status"];
obj._dTCreated = (DateTime)dr["DTCreated"];
obj.FriendMember = new Member();
if (list.IsColumnPresent("FriendMemberMemberID"))
{
obj.FriendMember.MemberID = (int)dr["FriendMemberMemberID"];
}
if (list.IsColumnPresent("FriendMemberWebMemberID"))
{
obj.FriendMember.WebMemberID = (string)dr["FriendMemberWebMemberID"];
}
if (list.IsColumnPresent("FriendMemberAdminStatusID"))
{
obj.FriendMember.AdminStatusID = (int)dr["FriendMemberAdminStatusID"];
}
if (list.IsColumnPresent("FriendMemberNickName"))
{
obj.FriendMember.NickName = (string)dr["FriendMemberNickName"];
}
if (list.IsColumnPresent("FriendMemberChannelID"))
{
obj.FriendMember.ChannelID = (int)dr["FriendMemberChannelID"];
}
if (list.IsColumnPresent("FriendMemberPassword"))
{
obj.FriendMember.Password = (string)dr["FriendMemberPassword"];
}
if (list.IsColumnPresent("FriendMemberEmail"))
{
obj.FriendMember.Email = (string)dr["FriendMemberEmail"];
}
if (list.IsColumnPresent("FriendMemberGender"))
{
obj.FriendMember.Gender = (int)dr["FriendMemberGender"];
}
if (list.IsColumnPresent("FriendMemberFirstName"))
{
obj.FriendMember.FirstName = (string)dr["FriendMemberFirstName"];
}
if (list.IsColumnPresent("FriendMemberLastName"))
{
obj.FriendMember.LastName = (string)dr["FriendMemberLastName"];
}
if (list.IsColumnPresent("FriendMemberProfilePhotoResourceFileID"))
{
obj.FriendMember.ProfilePhotoResourceFileID = (int)dr["FriendMemberProfilePhotoResourceFileID"];
}
if (list.IsColumnPresent("FriendMemberDOB"))
{
obj.FriendMember.DOB = (DateTime)dr["FriendMemberDOB"];
}
if (list.IsColumnPresent("FriendMemberISOCountry"))
{
obj.FriendMember.ISOCountry = (string)dr["FriendMemberISOCountry"];
}
if (list.IsColumnPresent("FriendMemberZipPostcode"))
{
obj.FriendMember.ZipPostcode = (string)dr["FriendMemberZipPostcode"];
}
if (list.IsColumnPresent("FriendMemberCreatedDT"))
{
obj.FriendMember.CreatedDT = (DateTime)dr["FriendMemberCreatedDT"];
}
if (list.IsColumnPresent("FriendMemberLastOnline"))
{
obj.FriendMember.LastOnline = (DateTime)dr["FriendMemberLastOnline"];
}
if (list.IsColumnPresent("PhotoURL"))
{
obj.PhotoURL = (string)dr["PhotoURL"];
}
arr.Add(obj);
}
return(arr);
}