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);
}