public DateTime DateTimeJoined { get; set; } // the datetime they were first seen at the nspot
public static List<NSpotMemberWS> PopulateNSpotMember(IDataReader dr)
{
List<NSpotMemberWS> arr = new List<NSpotMemberWS>();
while (dr.Read())
{
NSpotMemberWS nsMember = new NSpotMemberWS();
nsMember.WebMemberID = (string)dr["WebMemberID"];
nsMember.Nickname = (string)dr["Nickname"];
nsMember.ProfilePhotoURL = WebNSpot.RootURL + (string)dr["ProfilePhotoURL"];
nsMember.DateTimeJoined = (DateTime)dr["DateTimeJoined"];
arr.Add(nsMember);
}
return arr;
}
} // the datetime they were first seen at the nspot
public static List <NSpotMemberWS> PopulateNSpotMember(IDataReader dr)
{
List <NSpotMemberWS> arr = new List <NSpotMemberWS>();
while (dr.Read())
{
NSpotMemberWS nsMember = new NSpotMemberWS();
nsMember.WebMemberID = (string)dr["WebMemberID"];
nsMember.Nickname = (string)dr["Nickname"];
nsMember.ProfilePhotoURL = WebNSpot.RootURL + (string)dr["ProfilePhotoURL"];
nsMember.DateTimeJoined = (DateTime)dr["DateTimeJoined"];
arr.Add(nsMember);
}
return(arr);
}
/// <summary>
/// Gets all the Members in the for the NSpot
/// </summary>
public static NSpotMemberWS[] GetNSpotMemberByNSpotID(int NSpotID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetNSpotMemberByNSpotID");
db.AddInParameter(dbCommand, "NSpotID", DbType.Int32, NSpotID);
List <NSpotMemberWS> arr = null;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
arr = NSpotMemberWS.PopulateNSpotMember(dr);
dr.Close();
}
// Create the object array from the datareader
return(arr.ToArray());
}