//constructor for the class
        public clsCopyCollection()
        {
            //var for the index
            Int32 Index = 0;
            //var to store the record count
            Int32 RecordCount = 0;
            //object for data connection
            clsDataConnection DB = new clsDataConnection();

            //execute the stored procodure
            DB.Execute("sproc_CopyTable_SelectAll");
            //get the count of records
            RecordCount = DB.Count;
            //while there are records to process
            while (Index < RecordCount)
            {
                //Create a blank Customer
                clsCopy AnBook = new clsCopy();
                AnBook.CopyBarCode   = Convert.ToInt32(DB.DataTable.Rows[Index]["CopyBarCode"]);
                AnBook.FK_ISBN       = Convert.ToInt32(DB.DataTable.Rows[Index]["FK_ISBN"]);
                AnBook.CopyLoanType  = Convert.ToString(DB.DataTable.Rows[Index]["CopyLoanType"]);
                AnBook.CopyCondition = Convert.ToString(DB.DataTable.Rows[Index]["CopyCondition"]);
                AnBook.CopyStatus    = Convert.ToString(DB.DataTable.Rows[Index]["CopyStatus"]);

                //add the records into a private data member
                mBookList.Add(AnBook);
                //point to the next record
                Index++;
            }
        }
        void PopulateArray(clsDataConnection DB)
        {
            //populates array list based on the data table in the parameter DB
            //var for the index
            Int32 Index = 0;
            //var to store the record count.
            Int32 RecordCount;

            //get the count of records
            RecordCount = DB.Count;
            //clear the private array lsit
            mBookList = new List <clsCopy>();
            //while there are records to process
            while (Index < RecordCount)
            {
                clsCopy AnBook = new clsCopy();
                AnBook.CopyBarCode   = Convert.ToInt32(DB.DataTable.Rows[Index]["CopyBarCode"]);
                AnBook.FK_ISBN       = Convert.ToInt32(DB.DataTable.Rows[Index]["FK_ISBN"]);
                AnBook.CopyCondition = Convert.ToString(DB.DataTable.Rows[Index]["CopyCondition"]);
                AnBook.CopyStatus    = Convert.ToString(DB.DataTable.Rows[Index]["CopyStatus"]);
                AnBook.CopyLoanType  = Convert.ToString(DB.DataTable.Rows[Index]["CopyLoanType"]);

                //add the records into a private data member
                mBookList.Add(AnBook);
                //point to the next record
                Index++;
            }
        }