示例#1
0
        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;
        }
示例#2
0
        }                                            // 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);
        }
示例#3
0
        /// <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());
        }