コード例 #1
0
ファイル: DatabaseReader.cs プロジェクト: schakuu/prototypes
        public void showAllInventory()
        {
            BTreeCursor cursor = myDbs.InventoryDB.Cursor();
            Inventory theInventory;

            while (cursor.MoveNext()) {
                theInventory = new Inventory(cursor.Current.Value.Data);
                displayInventory(theInventory);
            }
            cursor.Close();
        }
コード例 #2
0
ファイル: DatabaseReader.cs プロジェクト: schakuu/prototypes
        public void displayInventory(Inventory theInventory)
        {
            Console.WriteLine("Item: {0} ",theInventory.Itemname);
            Console.WriteLine("SKU: {0} ", theInventory.Sku);
            Console.WriteLine("Price per unit: {0} ", theInventory.Price);
            Console.WriteLine("Quantity: {0} ", theInventory.Quantity);
            Console.WriteLine("Category: {0} ", theInventory.Category);
            Console.WriteLine("Contact: {0} ", theInventory.Vendor);

            /* Display the associated Vendor information. */
            displayVendor(theInventory);
        }
コード例 #3
0
ファイル: DatabaseLoader.cs プロジェクト: schakuu/prototypes
        public void LoadInventoryDB(string dataDir)
        {
            DatabaseEntry key, data;
            string inventory_text_file = dataDir + "\\" + "inventory.txt";

            if (!File.Exists(inventory_text_file)) {
                Console.WriteLine("{0} does not exist.", inventory_text_file);
                return;
            }

            using (StreamReader sr = File.OpenText(inventory_text_file)) {
                Inventory inventory = new Inventory();
                string input;

                /* Text file fields are delimited by #, just read them in. */
                while ((input=sr.ReadLine())!=null) {
                    char [] delimiterPound = {'#'};
                    string [] fields = input.Split(delimiterPound);
            #if TEST_DEBUG
                    System.Console.WriteLine(input);
            #endif
                    inventory.Itemname = fields[0];
                    inventory.Sku = fields[1];
                    inventory.Price = float.Parse(fields[2]);
                    inventory.Quantity = int.Parse(fields[3]);
                    inventory.Category = fields[4];
                    inventory.Vendor = fields[5];

                    /* Insert key/data pairs into database. */
                    key = new DatabaseEntry();
                    key.Data = System.Text.Encoding.ASCII.GetBytes(
                        inventory.Sku);

                    byte [] bytes = inventory.getBytes();
                    data = new DatabaseEntry(bytes);

                    try {
                        myDbs.InventoryDB.Put(key, data);
                    } catch(Exception e) {
                        Console.WriteLine("LoadInventoryDB Error.");
                        Console.WriteLine(e.Message);
                        throw e;
                    }
                }
            }
        }
コード例 #4
0
ファイル: DatabaseReader.cs プロジェクト: schakuu/prototypes
        public void showItem(string locateItem)
        {
            SecondaryCursor secCursor;

            /* searchKey is the key to find in the secondary db. */
            DatabaseEntry searchKey = new DatabaseEntry();
            searchKey.Data = System.Text.Encoding.ASCII.GetBytes(locateItem);

            /* Open a secondary cursor. */
            secCursor = this.myDbs.ItemSecbtreeDB.SecondaryCursor();

            /*
             * Search for the secondary. The primary key/data pair
             * associated with the given secondary key is stored in Current.
             * In the presence of duplicate key values, the first data
             * item in the set of duplicates is stored in Current.
             */
            if (secCursor.Move(searchKey, true)) {
                Inventory theInventory = new Inventory(
                    secCursor.Current.Value.Value.Data);

                /* Display the record. */
                displayInventory(theInventory);

                /* Get each duplicate. */
                while (secCursor.MoveNextDuplicate()) {
                    theInventory = new Inventory(
                        secCursor.Current.Value.Value.Data);
                    displayInventory(theInventory);
                }
            } else {
                Console.WriteLine("Could not find itemname {0} ", locateItem);
                Console.WriteLine();
                Console.WriteLine();
                return;
            }

            /* Close the cursor and the duplicate cursor. */
            secCursor.Close();
        }
コード例 #5
0
ファイル: MyDbs.cs プロジェクト: schakuu/prototypes
        /*
         * Used to extract an inventory item's name from an
         * inventory database record. This function is used to create
         * keys for secondary database records. Note key is the primary
         * key, and data is the primary data, the return is the secondary key.
         */
        public DatabaseEntry CreateSecondaryKey(
            DatabaseEntry key, DatabaseEntry data)
        {
            DatabaseEntry SecKeyDbt = new DatabaseEntry();
            Inventory inventory = new Inventory(data.Data);

            SecKeyDbt.Data = System.Text.Encoding.ASCII.GetBytes(
                inventory.Itemname);
            return SecKeyDbt;
        }
コード例 #6
0
ファイル: DatabaseReader.cs プロジェクト: schakuu/prototypes
        private void displayVendor(Inventory theInventory)
        {
            BinaryFormatter formatter = new BinaryFormatter();
            DatabaseEntry foundVendor = new DatabaseEntry();
            MemoryStream memStream;
            Vendor theVendor;

            foundVendor.Data = System.Text.Encoding.ASCII.GetBytes(
                theInventory.Vendor);
            try {
                KeyValuePair<DatabaseEntry, DatabaseEntry> pair =
                    new KeyValuePair<DatabaseEntry, DatabaseEntry>();
                string vendorData;

                pair = this.myDbs.VendorDB.Get(foundVendor);
                vendorData = System.Text.ASCIIEncoding.ASCII.GetString(
                    pair.Value.Data);

                memStream = new MemoryStream(pair.Value.Data.Length);
                memStream.Write(pair.Value.Data, 0, pair.Value.Data.Length);

                /* Read from the begining of the stream. */
                memStream.Seek(0, SeekOrigin.Begin);
                theVendor = (Vendor)formatter.Deserialize(memStream);

                memStream.Close();

                System.Console.WriteLine("Vendor: {0}", theVendor.Name);
                System.Console.WriteLine("Vendor Phone: {0}",
                    theVendor.PhoneNumber);
                System.Console.Write("Vendor Address: {0}, ",theVendor.Street);
                System.Console.Write("{0} ",theVendor.City);
                System.Console.Write("{0} ",theVendor.State);
                System.Console.WriteLine("{0} ",theVendor.Zipcode);
                System.Console.WriteLine("Vendor Rep: {0}: {1}",
                    theVendor.SalesRep, theVendor.SalesRepPhone);
                System.Console.WriteLine();
                System.Console.WriteLine();
            }
            catch (Exception e) {
                Console.WriteLine("displayVendor Error.");
                Console.WriteLine(e.Message);
                throw e;
            }
        }