public static List<SubscriptionItem> GetSubscriptionMembersByMemberID(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetSubscriptionMembersByMemberID"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); List<SubscriptionItem> Subscribers = new List<SubscriptionItem>(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID while (dr.Read()) { SubscriptionItem item = new SubscriptionItem(); item.WebMemberID = (string)dr["WebMemberID"]; item.NickName = (string)dr["NickName"]; item.PhotoURL = "user/" + (string)dr["PhotoURL"]; item.LastOnline = (DateTime)dr["DTOnline"]; item.ISOCountry = (string)dr["ISOCountry"]; Subscribers.Add(item); } dr.Close(); } return Subscribers; }
public static List <SubscriptionItem> GetSubscriptionMembersByMemberID(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetSubscriptionMembersByMemberID"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); List <SubscriptionItem> Subscribers = new List <SubscriptionItem>(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID while (dr.Read()) { SubscriptionItem item = new SubscriptionItem(); item.WebMemberID = (string)dr["WebMemberID"]; item.NickName = (string)dr["NickName"]; item.PhotoURL = "user/" + (string)dr["PhotoURL"]; item.LastOnline = (DateTime)dr["DTOnline"]; item.ISOCountry = (string)dr["ISOCountry"]; Subscribers.Add(item); } dr.Close(); } return(Subscribers); }