public static bool AddFriend(string WebMemberID, string TargetEmail)
{
ChatInbox inbox = GetInbox(WebMemberID);
Next2Friends.Data.Member targetMember = Next2Friends.Data.Member.GetMemberByEmail(TargetEmail);
if (targetMember == null)
{
return(false);
}
Next2Friends.Data.Friend f = new Next2Friends.Data.Friend();
f.MemberID1 = inbox.MemberID;
f.MemberID2 = targetMember.MemberID;
f.Save();
return(true);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Friends
/// </summary>
public static List<Friend> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Friend> arr = new List<Friend>();
Friend obj;
while (dr.Read())
{
obj = new Friend();
if (list.IsColumnPresent("FriendID")) { obj._friendID = (int)dr["FriendID"]; }
if (list.IsColumnPresent("MemberID1")) { obj._memberID1 = (int)dr["MemberID1"]; }
if (list.IsColumnPresent("MemberID2")) { obj._memberID2 = (int)dr["MemberID2"]; }
if (list.IsColumnPresent("UnFriendedMemberID")) { obj._unFriendedMemberID = (int)dr["UnFriendedMemberID"]; }
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 Friends
/// </summary>
public static List<Friend> PopulateObjectWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Friend> arr = new List<Friend>();
Friend obj;
while (dr.Read())
{
obj = new Friend();
if (list.IsColumnPresent("FriendID")) { obj._friendID = (int)dr["FriendID"]; }
if (list.IsColumnPresent("MemberID1")) { obj._memberID1 = (int)dr["MemberID1"]; }
if (list.IsColumnPresent("MemberID2")) { obj._memberID2 = (int)dr["MemberID2"]; }
if (list.IsColumnPresent("UnFriendedMemberID")) { obj._unFriendedMemberID = (int)dr["UnFriendedMemberID"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
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;
}
public static bool AddFriend(string WebMemberID, string TargetEmail)
{
ChatInbox inbox = GetInbox(WebMemberID);
Next2Friends.Data.Member targetMember = Next2Friends.Data.Member.GetMemberByEmail(TargetEmail);
if (targetMember == null)
return false;
Next2Friends.Data.Friend f = new Next2Friends.Data.Friend();
f.MemberID1 = inbox.MemberID;
f.MemberID2 = targetMember.MemberID;
f.Save();
return true;
}
