/// <summary>
        /// Creates a BTBlock item int the database
        /// </summary>
        /// <param name="MemberID">The owner of the block item</param>
        /// <param name="BTBlockItem">The BTBlock object</param>
        public static void CreateBTBlockItems(int MemberID, MemberBlock[] BTBlockItems)
        {

            for (int i = 0; i < BTBlockItems.Length; i++)
            {
                BTBlockItems[i].MemberID = MemberID;
                BTBlockItems[i].Save();
            }
        }
        /// <summary>
        ///// obselete???????
        ///// </summary>
        ///// <param name="MemberID"></param>
        ///// <returns></returns>
        //public static MemberBlockItem[] GetMemberBTBlockList(string MemberID)
        //{
        //    Database db = DatabaseFactory.CreateDatabase();
        //    DbCommand dbCommand = db.GetStoredProcCommand("HG_GetMemberBTBlockList");
        //    db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID);

        //    List<MemberBlock> BTBlockList = new List<MemberBlock>();
        //    List<MemberBlockItem> BTBlockItems = new List<MemberBlockItem>();

        //    using (IDataReader dr = db.ExecuteReader(dbCommand))
        //    {
        //        BTBlockList = MemberBlock.PopulateObject(dr);
        //        dr.Close();
        //    }

        //    for (int i = 0; i < BTBlockList.Count; i++)
        //    {
        //        //BTBlockItems.

        //        MemberBlockItem blockItem = new MemberBlockItem();
        //        blockItem.MemberID = BTBlockList[i].MemberID;
        //        blockItem.BlockMemberID = BTBlockList[i].BlockMemberID;
        //        blockItem.DTCreated = BTBlockList[i].DTCreated.Ticks.ToString();

        //        BTBlockItems.Add(blockItem);
        //    }

        //    return BTBlockItems.ToArray();
        //}




        /// <summary>
        /// Deletes a BTBlock item from the database
        /// </summary>
        /// <param name="MemberID">The owner of the block item</param>
        /// <param name="BTBlockItem">The BTBlock object</param>
        public static void DeleteBTBlockItems(string MemberID, MemberBlock[] BTBlockItems)
        {
            Database db = DatabaseFactory.CreateDatabase();

            for (int i = 0; i < BTBlockItems.Length; i++)
            {
                
                DbCommand dbCommand = db.GetStoredProcCommand("HG_DeleteBTBlockItem");
                db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID);
                db.AddInParameter(dbCommand, "BTBlockID", DbType.Int32, BTBlockItems[i].MemberBlockID);

                db.ExecuteNonQuery(dbCommand);
            }
        }
        /// <summary>
        /// Takes an prepopulated IDataReader and creates an array of MemberBlocks
        /// </summary>
        public static List<MemberBlock> PopulateObject(IDataReader dr)
        {
            ColumnFieldList list = new ColumnFieldList(dr);

            List<MemberBlock> arr = new List<MemberBlock>();

            MemberBlock obj;

            while (dr.Read())
            {
                obj = new MemberBlock();
                if (list.IsColumnPresent("MemberBlockID")) { obj._memberBlockID = (int)dr["MemberBlockID"]; }
                if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
                if (list.IsColumnPresent("BlockMemberID")) { obj._blockMemberID = (int)dr["BlockMemberID"]; }
                if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }

                arr.Add(obj);
            }

            dr.Close();

            return arr;
        }