Esempio n. 1
0
        }//end of display dvd

        void DisplayCDOrchestra()
        {
            btnCreateCDOrchestra.Enabled = true;
            btnCreateCDOrchestra.Text    = "Save CD Orchestra";
            FormController.formAddMode(this);
            txtProductUPC.Enabled              = true;
            txtProductPrice.Enabled            = true;
            txtProductTitle.Enabled            = true;
            txtProductQuantity.Enabled         = true;
            txtDVDLeadActor.Enabled            = false;
            txtDVDReleaseDate.Enabled          = false;
            txtDVDRunTime.Enabled              = false;
            txtBookISBNLeft.Enabled            = false;
            txtBookISBNRight.Enabled           = false;
            txtBookAuthor.Enabled              = false;
            txtBookPages.Enabled               = false;
            txtBookCISCISArea.Enabled          = false;
            txtCDClassicalLabel.Enabled        = true;
            txtCDClassicalArtists.Enabled      = true;
            txtCDOrchestraConductor.Enabled    = true;
            txtCDChamberInstrumentList.Enabled = false;

            btnCreateBook.Enabled      = false;
            btnCreateBookCIS.Enabled   = false;
            btnCreateDVD.Enabled       = false;
            btnCreateCDChamber.Enabled = false;

            FormController.activateCDOrchestra(this);
            FormController.deactivateBook(this);
            FormController.deactivateBookCIS(this);
            FormController.deactivateCDChamber(this);
            FormController.deactivateDVD(this);
            toolTip1.SetToolTip(btnCreateCDOrchestra, ttSaveCDOrchestra);
            txtProductUPC.Focus();
        }//end display CD Orchestra
Esempio n. 2
0
        }  // end deactivateAllButCDChamber

        // Deactivate all but CDChamber
        public static void deactivateAllButCDChamber(frmBookCDDVDShop f)
        {
            FormController.deactivateBook(f);
            FormController.deactivateBookCIS(f);
            FormController.deactivateCDOrchestra(f);
            FormController.deactivateDVD(f);
            FormController.deactivateAddButtons(f);
        }  // end deactivateAllButCDOrchestra
Esempio n. 3
0
        //Deletes an item
        private void btnDelete_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("Are you sure you want to delete this item?", "Confirm", MessageBoxButtons.YesNo);

            if (result == DialogResult.Yes)
            {
                dbFunctions.Delete(Convert.ToInt32(txtProductUPC.Text));
                recordsProcessedCount++;
                FormController.clear(this);
            }
        }
Esempio n. 4
0
 private void btnCreateBookCIS_Click(object sender, EventArgs e)
 {
     txtBookISBNLeft.ReadOnly   = false;
     txtBookISBNRight.ReadOnly  = false;
     txtBookAuthor.ReadOnly     = false;
     txtBookPages.ReadOnly      = false;
     txtBookCISCISArea.ReadOnly = false;
     FormController.activateBookCIS(this);
     clickedBtn      = "create_book_CIS";
     btnSave.Enabled = true;
 }
Esempio n. 5
0
 private void btnCreateDVD_Click(object sender, EventArgs e)
 {
     txtDVDLeadActor.ReadOnly   = false;
     txtDVDReleaseDate.ReadOnly = false;
     txtDVDRunTime.ReadOnly     = false;
     FormController.activateDVD(this);
     btnCreateBook.Enabled        = false;
     btnCreateBookCIS.Enabled     = false;
     btnCreateCDChamber.Enabled   = false;
     btnCreateCDOrchestra.Enabled = false;
     btnSave.Enabled = true;
     clickedBtn      = "create_DVD";
 }
Esempio n. 6
0
 private void btnCreateCDChamber_Click(object sender, EventArgs e)
 {
     txtCDClassicalArtists.ReadOnly      = false;
     txtCDClassicalLabel.ReadOnly        = false;
     txtCDChamberInstrumentList.ReadOnly = false;
     FormController.activateCDClassical(this);
     FormController.activateCDChamber(this);
     btnCreateBook.Enabled        = false;
     btnCreateBookCIS.Enabled     = false;
     btnCreateDVD.Enabled         = false;
     btnCreateCDOrchestra.Enabled = false;
     btnSave.Enabled = true;
     clickedBtn      = "create_CD_chamber";
 }
Esempio n. 7
0
        }   // end Validate Product data

        //Create Buttons on Form Begin
        private void btnCreateBook_Click(object sender, EventArgs e)
        {
            txtBookISBNLeft.ReadOnly  = false;
            txtBookISBNRight.ReadOnly = false;
            txtBookAuthor.ReadOnly    = false;
            txtBookPages.ReadOnly     = false;
            FormController.activateBook(this);
            FormController.activateProduct(this);
            btnCreateBookCIS.Enabled     = true;
            btnCreateCDChamber.Enabled   = false;
            btnCreateCDOrchestra.Enabled = false;
            btnCreateDVD.Enabled         = false;
            btnSave.Enabled = true;
            clickedBtn      = "create_book";
        }
Esempio n. 8
0
        //*****This section has the forms load and closing events

        // This sub is called when the form is loaded
        private void frmBookCDDVDShop_Load(System.Object sender, System.EventArgs e)
        {
            // Read serialized binary data file
            SFManager.readFromFile(ref thisProductList, FileName);
            FormController.clear(this);

            // Set initial Tooltips
            toolTip1.SetToolTip(btnCreateBookCIS, ttCreateBookCIS);
            toolTip1.SetToolTip(btnCreateBook, ttCreateBook);
            toolTip1.SetToolTip(btnCreateCDChamber, ttCreateCDOrchestra);
            toolTip1.SetToolTip(btnCreateCDOrchestra, ttCreateDVD);
            toolTip1.SetToolTip(btnCreateDVD, ttCreateCDChamber);

            toolTip1.SetToolTip(btnClear, ttClear);
            toolTip1.SetToolTip(btnDelete, ttDelete);
            toolTip1.SetToolTip(btnEdit, ttEdit);
            toolTip1.SetToolTip(btnFind, ttFind);
            toolTip1.SetToolTip(btnExit, ttExit);

            toolTip1.SetToolTip(txtProductUPC, ttProductUPC);
            toolTip1.SetToolTip(txtProductPrice, ttProductPrice);
            toolTip1.SetToolTip(txtProductQuantity, ttProductQuantity);
            toolTip1.SetToolTip(txtProductTitle, ttProductTitle);
            toolTip1.SetToolTip(txtCDOrchestraConductor, ttCDOrchestraConductor);
            toolTip1.SetToolTip(txtBookISBNLeft, ttBookISBN);
            toolTip1.SetToolTip(txtBookAuthor, ttBookAuthor);
            toolTip1.SetToolTip(txtBookPages, ttBookPages);
            toolTip1.SetToolTip(txtDVDLeadActor, ttDVDLeadActor);
            toolTip1.SetToolTip(txtDVDReleaseDate, ttDVDReleaseDate);
            toolTip1.SetToolTip(txtDVDRunTime, ttDVDRunTime);
            toolTip1.SetToolTip(txtCDClassicalLabel, ttCDClassicalLabel);
            toolTip1.SetToolTip(txtCDClassicalArtists, ttCDClassicalArtists);
            toolTip1.SetToolTip(txtCDOrchestraConductor, ttCDOrchestraConductor);
            toolTip1.SetToolTip(txtCDChamberInstrumentList, ttCDChamberInstrumentList);
            toolTip1.SetToolTip(txtBookCISCISArea, ttBookCISCISArea);
            toolTip1.SetToolTip(btnCreateBookCIS, ttCreateBookCIS);
        } // end frmEBookCDDVDShop_Load
Esempio n. 9
0
        }         //end of edit on click method

        private void btnEnterUPC_Click(object sender, EventArgs e)
        {
            if (btnEnterUPC.Text == "Click HERE to enter a UPC")
            {
                FormController.deactivateAddButtons(this); //add buttons cannot be clicked
                txtProductUPC.Enabled = true;              //lets user add a upc

                MessageBox.Show("Enter the desired product UPC above. Then click 'Check for Product' to continue.");

                btnEnterUPC.Text = "Check for Product";
            }
            else
            {
                if (Validators.ValidateProductUPC(txtProductUPC.Text))//validates product upc
                {
                    bool   OkayFlag;
                    string productFields;
                    dbFunctions.SelectProductFromProduct(Convert.ToInt32(txtProductUPC.Text), out OkayFlag, out productFields);//returns out variable values

                    //if (thisProductList.checkForDuplicate(Convert.ToInt32(txtProductUPC.Text)))//checks product list for same value

                    if (OkayFlag)//will be true if product is found in database
                    {
                        MessageBox.Show("Match Found!");
                        btnEnterUPC.Enabled   = false;
                        btnEdit.Enabled       = true;//allows for display/edit/delete options
                        btnDelete.Enabled     = true;
                        btnFind.Enabled       = true;
                        txtProductUPC.Enabled = false;//cannot change the UPC
                    }
                    else//OKFlag = false
                    {
                        MessageBox.Show("Match Not Found");
                    }
                }
            }
        }//end of UPC enter on click method
Esempio n. 10
0
        void DisplayCDChamberForm()
        {
            // Display form for Create/Insert or Find/SELECT or Edit/Update or Delete a Chamber Music CD
            btnCreateCDChamber.Enabled = true;
            btnCreateCDChamber.Text    = "Save CD Chamber";
            FormController.formAddMode(this);
            txtProductUPC.Enabled              = true;
            txtProductPrice.Enabled            = true;
            txtProductTitle.Enabled            = true;
            txtProductQuantity.Enabled         = true;
            txtDVDLeadActor.Enabled            = false;
            txtDVDReleaseDate.Enabled          = false;
            txtDVDRunTime.Enabled              = false;
            txtBookISBNLeft.Enabled            = false;
            txtBookISBNRight.Enabled           = false;
            txtBookAuthor.Enabled              = false;
            txtBookPages.Enabled               = false;
            txtBookCISCISArea.Enabled          = false;
            txtCDClassicalLabel.Enabled        = true;
            txtCDClassicalArtists.Enabled      = true;
            txtCDOrchestraConductor.Enabled    = false;
            txtCDChamberInstrumentList.Enabled = true;

            btnCreateBookCIS.Enabled     = false;
            btnCreateBook.Enabled        = false;
            btnCreateDVD.Enabled         = false;
            btnCreateCDOrchestra.Enabled = false;

            FormController.activateCDChamber(this);
            FormController.deactivateCDOrchestra(this);
            FormController.deactivateDVD(this);
            FormController.deactivateBook(this);
            FormController.deactivateBookCIS(this);
            toolTip1.SetToolTip(btnCreateCDChamber, ttSaveCDChamber);
            txtProductUPC.Focus();
        } // end DisplayCDChamberForm
Esempio n. 11
0
        //Edit button - Checks to see what type of object is being edited.
        private void btnEditUpdate_Click(object sender, EventArgs e)
        {
            bool success;

            btnDelete.Enabled = false;
            btnSave.Enabled   = false;
            success           = findAnItem("Edit/Update");
            if (success)
            {
                btnSave.Enabled       = true;
                btnEditUpdate.Enabled = false;

                txtProductUPC.ReadOnly      = false;
                txtProductTitle.ReadOnly    = false;
                txtProductQuantity.ReadOnly = false;
                txtProductPrice.ReadOnly    = false;
                Product p = thisProductList.getAnItem(currentIndex);
                txtProductPrice.Text    = p.ProductPrice.ToString();
                txtProductUPC.Text      = p.ProductUPC.ToString();
                txtProductQuantity.Text = p.ProductQuantity.ToString();
                txtProductTitle.Text    = p.ProductTitle.ToString();
                MessageBox.Show("Edit/UPDATE current Product (as shown). Press Save Updates Button", "Edit/Update Notice",
                                MessageBoxButtons.OK);
                if (p.GetType() == typeof(CDChamber))
                {
                    FormController.activateCDChamber(this);
                    FormController.deactivateAllButCDChamber(this);
                    FormController.deactivateAddButtons(this);

                    txtCDClassicalArtists.ReadOnly      = false;
                    txtCDClassicalLabel.ReadOnly        = false;
                    txtCDChamberInstrumentList.ReadOnly = false;
                    txtCDClassicalLabel.Text            = ((CDClassical)p).CDClassicalLabel;
                    txtCDClassicalArtists.Text          = ((CDClassical)p).CDClassicalArtists;
                    txtCDChamberInstrumentList.Text     = ((CDChamber)p).getCDChamberInstrumentList();
                    recordsProcessedCount++;
                }
                else if (p.GetType() == typeof(CDOrchestra))
                {
                    FormController.activateCDOrchestra(this);
                    FormController.deactivateAllButCDOrchestra(this);

                    txtCDClassicalArtists.ReadOnly   = false;
                    txtCDClassicalLabel.ReadOnly     = false;
                    txtCDOrchestraConductor.ReadOnly = false;
                    txtCDClassicalLabel.Text         = ((CDClassical)p).CDClassicalLabel;
                    txtCDClassicalArtists.Text       = ((CDClassical)p).CDClassicalArtists;
                    txtCDOrchestraConductor.Text     = ((CDOrchestra)p).getCDOrchestraConductor();
                    recordsProcessedCount++;
                }
                else if (p.GetType() == typeof(Book))
                {
                    FormController.activateBook(this);
                    FormController.deactivateAllButBook(this);
                    FormController.deactivateAddButtons(this);

                    txtBookISBNLeft.ReadOnly  = false;
                    txtBookISBNRight.ReadOnly = false;
                    txtBookAuthor.ReadOnly    = false;
                    txtBookPages.ReadOnly     = false;
                    txtBookISBNLeft.Text      = (((Book)p).BookISBNLeft).ToString();
                    txtBookISBNRight.Text     = (((Book)p).BookISBNRight).ToString();
                    txtBookAuthor.Text        = ((Book)p).BookAuthor;
                    txtBookPages.Text         = ((Book)p).BookPages.ToString();
                    recordsProcessedCount++;
                }
                else if (p.GetType() == typeof(BookCIS))
                {
                    FormController.activateBookCIS(this);
                    FormController.deactivateAllButBookCIS(this);

                    txtBookISBNLeft.ReadOnly   = false;
                    txtBookISBNRight.ReadOnly  = false;
                    txtBookAuthor.ReadOnly     = false;
                    txtBookPages.ReadOnly      = false;
                    txtBookCISCISArea.ReadOnly = false;
                    txtBookISBNLeft.Text       = (((Book)p).BookISBNLeft).ToString();
                    txtBookISBNRight.Text      = (((Book)p).BookISBNRight).ToString();
                    txtBookAuthor.Text         = ((Book)p).BookAuthor;
                    txtBookPages.Text          = (((Book)p).BookPages).ToString();
                    txtBookCISCISArea.Text     = ((BookCIS)p).BookCISCISArea;
                    recordsProcessedCount++;
                }  // end multiple alternative if

                else if (p.GetType() == typeof(DVD))
                {
                    FormController.activateDVD(this);
                    FormController.deactivateAllButDVD(this);

                    txtDVDLeadActor.ReadOnly   = false;
                    txtDVDReleaseDate.ReadOnly = false;
                    txtDVDRunTime.ReadOnly     = false;
                    txtDVDLeadActor.Text       = ((DVD)p).DVDLeadActor;
                    txtDVDReleaseDate.Text     = ((DateTime)((DVD)p).DVDReleaseDate).ToString("MM/dd/yyyy");
                    txtDVDRunTime.Text         = (((DVD)p).DVDRunTime).ToString();
                    recordsProcessedCount++;
                }
                else
                {
                    MessageBox.Show("Fatal error. Data type not Book, BookCIS, DVD, DC Chamber or CD Orchestra. Program Terminated. ",
                                    "Mis-typed Object", MessageBoxButtons.OK);
                    this.Close();
                } // end multiple alternative if
            }     // end if on success
        }
Esempio n. 12
0
        //Create Buttons on Form End

        //Clear all text boxes
        private void btnClear_Click(object sender, EventArgs e)
        {
            FormController.clear(this);
        }
Esempio n. 13
0
        } // end frmEBookCDDVDShop_Load


        // Clear textboxes
        private void btnClear_Click(System.Object sender, System.EventArgs e)
        {
            FormController.clear(this);
        }  // end btnClear_Click
Esempio n. 14
0
        }//end of saveEditUpdate on click method

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (btnDelete.Text == "Delete")
            {
                btnFind.Enabled = false;
                btnEdit.Enabled = false;

                bool   OkayFlag;
                string productFields;

                dbFunctions.SelectProductFromProduct(Convert.ToInt32(txtProductUPC.Text), out OkayFlag, out productFields); //returns out variable values

                string[] productFieldArray = handleFieldOutput(productFields);                                              //splits and trims productFields

                //Product p = thisProductList.getAnItem(Convert.ToInt32(txtProductUPC.Text));// product to be found

                //sets textboxes to proper values in product field array
                txtProductPrice.Text    = productFieldArray[1];
                txtProductUPC.Text      = productFieldArray[0];
                txtProductQuantity.Text = productFieldArray[3];
                txtProductTitle.Text    = productFieldArray[2];
                if (productFieldArray[4] == "CDChamber")//handles cd chamber
                {
                    FormController.activateCDChamber(this);
                    FormController.deactivateAllButCDChamber(this);
                    FormController.deactivateAddButtons(this);

                    txtCDClassicalLabel.Text        = productFieldArray[5];
                    txtCDClassicalArtists.Text      = productFieldArray[6];
                    txtCDChamberInstrumentList.Text = productFieldArray[7];
                }
                else if (productFieldArray[4] == "CDOrchestra")//handles cd orchestra
                {
                    FormController.activateCDOrchestra(this);
                    FormController.deactivateAllButCDOrchestra(this);

                    txtCDClassicalLabel.Text     = productFieldArray[5];
                    txtCDClassicalArtists.Text   = productFieldArray[6];
                    txtCDOrchestraConductor.Text = productFieldArray[7];
                }
                else if (productFieldArray[4] == "Book")//handles book
                {
                    FormController.activateBook(this);
                    FormController.deactivateAllButBook(this);
                    FormController.deactivateAddButtons(this);

                    string leftISBN  = "";
                    string rightISBN = "";

                    for (int j = 0; j < productFieldArray[5].Length; j++)//seperates ISBN for 2 seperate textboxes
                    {
                        if (leftISBN.Length != 3)
                        {
                            leftISBN += productFieldArray[5][j];
                        }
                        else
                        {
                            rightISBN += productFieldArray[5][j];
                        }
                    }

                    txtBookISBNLeft.Text  = leftISBN;
                    txtBookISBNRight.Text = rightISBN;
                    txtBookAuthor.Text    = productFieldArray[6];
                    txtBookPages.Text     = productFieldArray[7];
                }
                else if (productFieldArray[4] == "BookCIS")//handles book cis
                {
                    FormController.activateBookCIS(this);
                    FormController.deactivateAllButBookCIS(this);

                    string leftISBN  = "";
                    string rightISBN = "";

                    for (int j = 0; j < productFieldArray[5].Length; j++)//seperates ISBN for 2 seperate textboxes
                    {
                        if (leftISBN.Length != 3)
                        {
                            leftISBN += productFieldArray[5][j];
                        }
                        else
                        {
                            rightISBN += productFieldArray[5][j];
                        }
                    }

                    txtBookISBNLeft.Text   = leftISBN;
                    txtBookISBNRight.Text  = rightISBN;
                    txtBookAuthor.Text     = productFieldArray[6];
                    txtBookPages.Text      = productFieldArray[7];
                    txtBookCISCISArea.Text = productFieldArray[8];
                }  // end multiple alternative if

                else if (productFieldArray[4] == "DVD")//handles dvd
                {
                    FormController.activateDVD(this);
                    FormController.deactivateAllButDVD(this);

                    txtDVDLeadActor.Text   = productFieldArray[5];
                    txtDVDReleaseDate.Text = productFieldArray[6];
                    txtDVDRunTime.Text     = productFieldArray[7];
                }
                else
                {
                    MessageBox.Show("Fatal error. Data type not Book, BookCIS, DVD, DC Chamber or CD Orchestra. Program Terminated. ",
                                    "Mis-typed Object", MessageBoxButtons.OK);
                    this.Close();
                }  // end multiple alternative if
                FormController.disableTextBoxes(this);//make sure user cannot change info during delete
                MessageBox.Show("Are you sure you want to delete this product? Confirm delete action below.");
                btnDelete.Text = "Confirm Delete";
            }
            else//confirm
            {
                //Product p = thisProductList.getAnItem(Convert.ToInt32(txtProductUPC.Text));// product to be deleted
                //thisProductList.removeAnItem(p);
                dbFunctions.Delete(Convert.ToInt32(txtProductUPC.Text));

                btnDelete.Enabled = false;
                MessageBox.Show("Product Deleted");
            }
        }//end of delete click method
Esempio n. 15
0
        }//end display CD Orchestra

        private void btnEdit_Click(object sender, EventArgs e)
        {
            bool   OkayFlag;
            string productFields;

            btnFind.Enabled           = false;
            btnDelete.Enabled         = false;
            btnSaveEditUpdate.Enabled = false;

            dbFunctions.SelectProductFromProduct(Convert.ToInt32(txtProductUPC.Text), out OkayFlag, out productFields); //returns values to out parameters

            string[] productFieldArray = handleFieldOutput(productFields);                                              //splits and trims productFields

            if (OkayFlag)                                                                                               //if a product was found
            {
                btnSaveEditUpdate.Enabled = true;
                btnEdit.Enabled           = false;


                //setting textboxes to correct values in field array
                txtProductPrice.Text    = productFieldArray[1];
                txtProductUPC.Text      = productFieldArray[0];
                txtProductQuantity.Text = productFieldArray[3];
                txtProductTitle.Text    = productFieldArray[2];
                MessageBox.Show("Edit/UPDATE current Product (as shown). Press Save Updates Button", "Edit/Update Notice",
                                MessageBoxButtons.OK);
                if (productFieldArray[4] == "CDChamber")//handles cd Chamber
                {
                    FormController.activateCDChamber(this);
                    FormController.deactivateAllButCDChamber(this);
                    FormController.deactivateAddButtons(this);

                    txtCDClassicalLabel.Text        = productFieldArray[5];
                    txtCDClassicalArtists.Text      = productFieldArray[6];
                    txtCDChamberInstrumentList.Text = productFieldArray[7];
                }
                else if (productFieldArray[4] == "CDOrchestra")//handles cd orchestra
                {
                    FormController.activateCDOrchestra(this);
                    FormController.deactivateAllButCDOrchestra(this);

                    txtCDClassicalLabel.Text     = productFieldArray[5];
                    txtCDClassicalArtists.Text   = productFieldArray[6];
                    txtCDOrchestraConductor.Text = productFieldArray[7];
                }
                else if (productFieldArray[4] == "Book")//handles book
                {
                    FormController.activateBook(this);
                    FormController.deactivateAllButBook(this);
                    FormController.deactivateAddButtons(this);

                    string leftISBN  = "";
                    string rightISBN = "";

                    for (int j = 0; j < productFieldArray[5].Length; j++)//seperates ISBN for 2 seperate textboxes
                    {
                        if (leftISBN.Length != 3)
                        {
                            leftISBN += productFieldArray[5][j];
                        }
                        else
                        {
                            rightISBN += productFieldArray[5][j];
                        }
                    }

                    txtBookISBNLeft.Text  = leftISBN;
                    txtBookISBNRight.Text = rightISBN;
                    txtBookAuthor.Text    = productFieldArray[6];
                    txtBookPages.Text     = productFieldArray[7];
                }
                else if (productFieldArray[4] == "BookCIS")//handles book cis
                {
                    FormController.activateBookCIS(this);
                    FormController.deactivateAllButBookCIS(this);

                    string leftISBN  = "";
                    string rightISBN = "";

                    for (int j = 0; j < productFieldArray[5].Length; j++)//seperates ISBN for 2 seperate textboxes
                    {
                        if (leftISBN.Length != 3)
                        {
                            leftISBN += productFieldArray[5][j];
                        }
                        else
                        {
                            rightISBN += productFieldArray[5][j];
                        }
                    }

                    txtBookISBNLeft.Text   = leftISBN;
                    txtBookISBNRight.Text  = rightISBN;
                    txtBookAuthor.Text     = productFieldArray[6];
                    txtBookPages.Text      = productFieldArray[7];
                    txtBookCISCISArea.Text = productFieldArray[8];
                }  // end multiple alternative if
                else if (productFieldArray[4] == "DVD")//handles dvd
                {
                    FormController.activateDVD(this);
                    FormController.deactivateAllButDVD(this);

                    txtDVDLeadActor.Text   = productFieldArray[5];
                    txtDVDReleaseDate.Text = productFieldArray[6];
                    txtDVDRunTime.Text     = productFieldArray[7];
                }
                else
                {
                    MessageBox.Show("Fatal error. Data type not Book, BookCIS, DVD, DC Chamber or CD Orchestra. Program Terminated. ",
                                    "Mis-typed Object", MessageBoxButtons.OK);
                    this.Close();
                } // end multiple alternative if
            }     // end if on success
        }         //end of edit on click method
Esempio n. 16
0
        }     // end getItem

        //Searches item by the UPC number since it is guarenteed that this will be a unique identifier
        private void btnProductUPCSearch_Click(object sender, EventArgs e)
        {
            bool temp = Validation.validateProductUPC(txtProductUPCSearch.Text); //first make sure the format is correct

            if (temp)
            {
                bool    found;   // boolean reference for search success
                string  pstring; // Product string updated upon product DB search call.
                Product prod;

                //  this returns an OleDbDataReader object, but you don't really need to use it
                //  the boolean flag and string that are returned are important
                //  pstring will hold the attributes of a product from the database in a single string, separated by newline characters
                //  split it below

                OleDbDataReader odb = dbFunctions.SelectProductFromProduct(Convert.ToInt32(txtProductUPCSearch.Text), out found, out pstring);

                if (!found) //not found
                {
                    MessageBox.Show("Product not found");
                    txtProductUPCSearch.Clear();
                    txtProductUPCSearch.Focus();
                } // Creates a new product to display in form.
                else
                {
                    txtProductUPC.ReadOnly      = true;
                    txtProductTitle.ReadOnly    = true;
                    txtProductQuantity.ReadOnly = true;
                    txtProductPrice.ReadOnly    = true;

                    btnDelete.Enabled = true;
                    string[] attributes = pstring.Split('\n'); // splits product attributes into array

                    for (int i = 0; i < attributes.Length; i++)
                    {
                        attributes[i] = attributes[i].Trim('\r'); // clears "junk" from each field
                    }

                    string ptype = attributes[4]; // gets the product type from this attribute and then creates new product to display in form

                    if (ptype == "DVD")
                    {
                        txtDVDLeadActor.ReadOnly   = true;
                        txtDVDReleaseDate.ReadOnly = true;
                        txtDVDRunTime.ReadOnly     = true;
                        prod = new DVD(Convert.ToInt32(attributes[0]), Convert.ToDecimal(attributes[1]), attributes[2], Convert.ToInt32(attributes[3]),
                                       attributes[5], DateTime.Parse(attributes[6]), Convert.ToInt32(attributes[7]));
                        prod.Display(this);
                        FormController.searchForm(this);
                        FormController.activateDVD(this);
                        thisProductList.Add(prod);
                        currentIndex++;
                    }

                    if (ptype == "Book")
                    {
                        String isbnS = attributes[5];
                        String isbn1 = isbnS.Substring(0, 3);
                        String isbn2 = isbnS.Substring(3, 3);
                        txtBookISBNLeft.ReadOnly  = true;
                        txtBookISBNRight.ReadOnly = true;
                        txtBookAuthor.ReadOnly    = true;
                        txtBookPages.ReadOnly     = true;
                        prod = new Book(Convert.ToInt32(attributes[0]), Convert.ToDecimal(attributes[1]), attributes[2], Convert.ToInt32(attributes[3]),
                                        Convert.ToInt32(isbn1), Convert.ToInt32(isbn2), attributes[6], Convert.ToInt32(attributes[7]));
                        prod.Display(this);
                        FormController.searchForm(this);
                        FormController.activateBook(this);
                        thisProductList.Add(prod);
                        currentIndex++;
                    }

                    if (ptype == "BookCIS")
                    {
                        String isbnS = attributes[5];
                        String isbn1 = isbnS.Substring(0, 3);
                        String isbn2 = isbnS.Substring(3, 3);
                        txtBookISBNLeft.ReadOnly   = true;
                        txtBookISBNRight.ReadOnly  = true;
                        txtBookAuthor.ReadOnly     = true;
                        txtBookPages.ReadOnly      = true;
                        txtBookCISCISArea.ReadOnly = true;
                        prod = new BookCIS(Convert.ToInt32(attributes[0]), Convert.ToDecimal(attributes[1]), attributes[2], Convert.ToInt32(attributes[3]),
                                           Convert.ToInt32(isbn1), Convert.ToInt32(isbn2), attributes[6], Convert.ToInt32(attributes[7]), attributes[8]);
                        prod.Display(this);
                        FormController.searchForm(this);
                        FormController.activateBookCIS(this);
                        thisProductList.Add(prod);
                        currentIndex++;
                    }

                    if (ptype == "CDOrchestra")
                    {
                        txtCDClassicalArtists.ReadOnly   = true;
                        txtCDClassicalLabel.ReadOnly     = true;
                        txtCDOrchestraConductor.ReadOnly = true;
                        prod = new CDOrchestra(Convert.ToInt32(attributes[0]), Convert.ToDecimal(attributes[1]), attributes[2], Convert.ToInt32(attributes[3]),
                                               attributes[5], attributes[6], attributes[7]);
                        prod.Display(this);
                        FormController.searchForm(this);
                        FormController.activateCDOrchestra(this);
                        thisProductList.Add(prod);
                        currentIndex++;
                    }

                    if (ptype == "CDChamber")
                    {
                        txtCDClassicalArtists.ReadOnly      = true;
                        txtCDClassicalLabel.ReadOnly        = true;
                        txtCDChamberInstrumentList.ReadOnly = true;
                        //String[] InstrumentList = attributes[6].Split(' ');
                        prod = new CDChamber(Convert.ToInt32(attributes[0]), Convert.ToDecimal(attributes[1]), attributes[2], Convert.ToInt32(attributes[3]),
                                             attributes[5], attributes[6], attributes[7]);
                        prod.Display(this);
                        FormController.searchForm(this);
                        FormController.activateCDChamber(this);
                        thisProductList.Add(prod);
                        currentIndex++;
                    }

                    /*
                     *
                     * add else ifs for the other product types and handle each accordingly
                     *
                     */
                    else
                    {
                        // this is an invalid record (since it does not fit one of our types)
                    }
                }
            }
            else
            {
                // UPC is invalid
                MessageBox.Show("Invalid URL", "Error:");
            }
        }
Esempio n. 17
0
        //Saves item to database
        private void btnSave_Click(object sender, EventArgs e)
        {
            bool productValidated;

            productValidated = Validation.validateProductUPC(txtProductUPC.Text) &&
                               Validation.validateProductPrice(txtProductPrice.Text) &&
                               Validation.validateAnything(txtProductTitle.Text) &&
                               Validation.validatePositiveInteger(txtProductQuantity.Text);

            if (productValidated == false)
            {
                MessageBox.Show("You have errors with your product information! Please check the product information and try again.", "Product Input Error");
            }
            else
            {
                bool   found;   // boolean reference for search success
                string pstring; // Product string updated upon product DB search call.
                //Product prod;

                OleDbDataReader odb = dbFunctions.SelectProductFromProduct(Convert.ToInt32(txtProductUPC.Text), out found, out pstring);

                if (!found)
                {
                    //works
                    if (clickedBtn == "create_book")
                    {
                        bool bookValidated;

                        bookValidated = Validation.validateBookISBN(txtBookISBNLeft.Text) &&
                                        Validation.validateBookISBN(txtBookISBNRight.Text) &&
                                        Validation.validatePersonName(txtBookAuthor.Text) &&
                                        Validation.validatePositiveInteger(txtBookPages.Text);

                        if (bookValidated == true)
                        {
                            Book saveBook = new Book(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                     txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                     Convert.ToInt32(txtBookISBNLeft.Text), Convert.ToInt32(txtBookISBNRight.Text),
                                                     txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            dbFunctions.InsertProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text), "Book");
                            dbFunctions.InsertBook(Convert.ToInt32(txtProductUPC.Text), Convert.ToInt32(txtBookISBNLeft.Text + txtBookISBNRight.Text),
                                                   txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            MessageBox.Show("Book successfully inserted into database!", "Success");
                            recordsProcessedCount++;
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the book into the file. Check the entered information and try again!", "Error");
                        }
                    }
                    //works
                    else if (clickedBtn == "create_book_CIS")
                    {
                        bool bookCISValidated;

                        bookCISValidated = Validation.validateBookISBN(txtBookISBNLeft.Text) &&
                                           Validation.validateBookISBN(txtBookISBNRight.Text) &&
                                           Validation.validatePersonName(txtBookAuthor.Text) &&
                                           Validation.validatePositiveInteger(txtBookPages.Text) &&
                                           Validation.validateAnything(txtBookCISCISArea.Text);

                        if (bookCISValidated == true)
                        {
                            BookCIS saveCISBook = new BookCIS(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                              txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                              Convert.ToInt32(txtBookISBNLeft.Text), Convert.ToInt32(txtBookISBNRight.Text),
                                                              txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text), txtBookCISCISArea.Text);

                            dbFunctions.InsertProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text), "BookCIS");

                            dbFunctions.InsertBook(Convert.ToInt32(txtProductUPC.Text), Convert.ToInt32(txtBookISBNLeft.Text + txtBookISBNRight.Text),
                                                   txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            dbFunctions.InsertBookCIS(Convert.ToInt32(txtProductUPC.Text), txtBookCISCISArea.Text);

                            MessageBox.Show("Book successfully inserted into database!", "Success");
                            recordsProcessedCount++;
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the book into the file. Check the entered information and try again!", "Error");
                        }
                    }
                    //works
                    else if (clickedBtn == "create_DVD")
                    {
                        bool dvdValidated;

                        dvdValidated = Validation.validatePersonName(txtDVDLeadActor.Text) &&
                                       Validation.validateDate(Convert.ToDateTime(txtDVDReleaseDate.Text)) &&
                                       Validation.validatePositiveInteger(txtDVDRunTime.Text);

                        if (dvdValidated == true)
                        {
                            DVD saveDVD = new DVD(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                  txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                  txtDVDLeadActor.Text, Convert.ToDateTime(txtDVDReleaseDate.Text),
                                                  Convert.ToInt32(txtDVDRunTime.Text));

                            dbFunctions.InsertProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text), "DVD");

                            dbFunctions.InsertDVD(Convert.ToInt32(txtProductUPC.Text), txtDVDLeadActor.Text,
                                                  Convert.ToDateTime(txtDVDReleaseDate.Text), Convert.ToInt32(txtDVDRunTime.Text));

                            MessageBox.Show("DVD successfully inserted into database!", "Success");
                            recordsProcessedCount++;
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the DVD into the file. Check the entered information and try again!", "Error");
                        }
                    }
                    //works
                    else if (clickedBtn == "create_CD_chamber")
                    {
                        bool chamberValidated;

                        chamberValidated = Validation.validateAnything(txtCDClassicalLabel.Text) &&
                                           Validation.validatePersonName(txtCDClassicalArtists.Text) &&
                                           Validation.validateAnything(txtCDChamberInstrumentList.Text);

                        if (chamberValidated == true)
                        {
                            dbFunctions.InsertProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text), "CDChamber");
                            dbFunctions.InsertCDClassical(Convert.ToInt32(txtProductUPC.Text), txtCDClassicalLabel.Text, txtCDClassicalArtists.Text);

                            dbFunctions.InsertCDChamber(Convert.ToInt32(txtProductUPC.Text), txtCDChamberInstrumentList.Text);

                            MessageBox.Show("Chamber CD successfully inserted into database!", "Success");
                            recordsProcessedCount++;
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the chamber CD into the file. Check the entered information and try again!", "Error");
                        }
                    }
                    //works
                    else if (clickedBtn == "create_CD_orchestra")
                    {
                        bool orchestraValidated;

                        orchestraValidated = Validation.validateAnything(txtCDClassicalLabel.Text) &&
                                             Validation.validatePersonName(txtCDClassicalArtists.Text) &&
                                             Validation.validatePersonName(txtCDOrchestraConductor.Text);

                        if (orchestraValidated == true)
                        {
                            dbFunctions.InsertProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text), "CDOrchestra");

                            dbFunctions.InsertCDClassical(Convert.ToInt32(txtProductUPC.Text), txtCDClassicalLabel.Text, txtCDClassicalArtists.Text);

                            dbFunctions.InsertCDOrchestra(Convert.ToInt32(txtProductUPC.Text), txtCDOrchestraConductor.Text);

                            MessageBox.Show("Orchestra CD successfully inserted into database!", "Success");
                            recordsProcessedCount++;
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the orchestra CD into the file. Check the entered information and try again!", "Error");
                        }
                    }
                }
                //his is for updating

                else
                {
                    string[] attributes = pstring.Split('\n'); // splits product attributes into array

                    for (int i = 0; i < attributes.Length; i++)
                    {
                        attributes[i] = attributes[i].Trim('\r'); // clears "junk" from each field
                    }

                    string ptype = attributes[4]; // gets the product type from this attribute and then creates new product to display in form

                    //Works
                    if (ptype == "Book")
                    {
                        bool bookValidated;

                        bookValidated = Validation.validateBookISBN(txtBookISBNLeft.Text) &&
                                        Validation.validateBookISBN(txtBookISBNRight.Text) &&
                                        Validation.validatePersonName(txtBookAuthor.Text) &&
                                        Validation.validatePositiveInteger(txtBookPages.Text);

                        if (bookValidated == true)
                        {
                            Book saveBook = new Book(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                     txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                     Convert.ToInt32(txtBookISBNLeft.Text), Convert.ToInt32(txtBookISBNRight.Text),
                                                     txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            dbFunctions.UpdateProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text));
                            dbFunctions.UpdateBook(Convert.ToInt32(txtProductUPC.Text), Convert.ToInt32(txtBookISBNLeft.Text + txtBookISBNRight.Text),
                                                   txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            MessageBox.Show("Book successfully updated to database!", "Success");
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the book into the file. Check the entered information and try again!", "Error");
                        }
                    }

                    //Works
                    if (ptype == "BookCIS")
                    {
                        bool bookCISValidated;

                        bookCISValidated = Validation.validateBookISBN(txtBookISBNLeft.Text) &&
                                           Validation.validateBookISBN(txtBookISBNRight.Text) &&
                                           Validation.validateAnything(txtBookAuthor.Text) &&
                                           Validation.validatePositiveInteger(txtBookPages.Text) &&
                                           Validation.validateAnything(txtBookCISCISArea.Text);

                        if (bookCISValidated == true)
                        {
                            BookCIS saveCISBook = new BookCIS(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                              txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                              Convert.ToInt32(txtBookISBNLeft.Text), Convert.ToInt32(txtBookISBNRight.Text),
                                                              txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text), txtBookCISCISArea.Text);

                            dbFunctions.UpdateProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text));

                            dbFunctions.UpdateBook(Convert.ToInt32(txtProductUPC.Text), Convert.ToInt32(txtBookISBNLeft.Text + txtBookISBNRight.Text),
                                                   txtBookAuthor.Text, Convert.ToInt32(txtBookPages.Text));

                            dbFunctions.UpdateBookCIS(Convert.ToInt32(txtProductUPC.Text), txtBookCISCISArea.Text);

                            MessageBox.Show("BookCIS successfully updated to database!", "Success");
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the book into the file. Check the entered information and try again!", "Error");
                        }
                    }
                    if (ptype == "DVD")
                    {
                        bool dvdValidated;

                        dvdValidated = Validation.validatePersonName(txtDVDLeadActor.Text) &&
                                       Validation.validateDate(Convert.ToDateTime(txtDVDReleaseDate.Text)) &&
                                       Validation.validatePositiveInteger(txtDVDRunTime.Text);

                        if (dvdValidated == true)
                        {
                            DVD saveDVD = new DVD(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                  txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text),
                                                  txtDVDLeadActor.Text, Convert.ToDateTime(txtDVDReleaseDate.Text),
                                                  Convert.ToInt32(txtDVDRunTime.Text));

                            dbFunctions.UpdateProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text));

                            dbFunctions.UpdateDVD(Convert.ToInt32(txtProductUPC.Text), txtDVDLeadActor.Text,
                                                  Convert.ToDateTime(txtDVDReleaseDate.Text), Convert.ToInt32(txtDVDRunTime.Text));

                            MessageBox.Show("DVD successfully updated to database!", "Success");
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the DVD into the file. Check the entered information and try again!", "Error");
                        }
                    }

                    if (ptype == "CDOrchestra")
                    {
                        bool orchestraValidated;

                        orchestraValidated = Validation.validateAnything(txtCDClassicalLabel.Text) &&
                                             Validation.validatePersonName(txtCDClassicalArtists.Text) &&
                                             Validation.validatePersonName(txtCDOrchestraConductor.Text);

                        if (orchestraValidated == true)
                        {
                            dbFunctions.UpdateProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text));

                            dbFunctions.UpdateCDClassical(Convert.ToInt32(txtProductUPC.Text), txtCDClassicalLabel.Text, txtCDClassicalArtists.Text);

                            dbFunctions.UpdateCDOrchestra(Convert.ToInt32(txtProductUPC.Text), txtCDOrchestraConductor.Text);

                            MessageBox.Show("CDOrchestra successfully updated to database!", "Success");
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the orchestra CD into the file. Check the entered information and try again!", "Error");
                        }
                    }


                    if (ptype == "CDChamber")
                    {
                        bool chamberValidated;

                        chamberValidated = Validation.validateAnything(txtCDClassicalLabel.Text) &&
                                           Validation.validateAnything(txtCDClassicalArtists.Text) &&
                                           Validation.validateAnything(txtCDChamberInstrumentList.Text);

                        if (chamberValidated == true)
                        {
                            dbFunctions.UpdateProduct(Convert.ToInt32(txtProductUPC.Text), Convert.ToDecimal(txtProductPrice.Text),
                                                      txtProductTitle.Text, Convert.ToInt32(txtProductQuantity.Text));
                            dbFunctions.UpdateCDClassical(Convert.ToInt32(txtProductUPC.Text), txtCDClassicalLabel.Text, txtCDClassicalArtists.Text);

                            dbFunctions.UpdateCDChamber(Convert.ToInt32(txtProductUPC.Text), txtCDChamberInstrumentList.Text);

                            MessageBox.Show("CDChamber successfully updated to database!", "Success");
                            FormController.clear(this);
                        }
                        else
                        {
                            MessageBox.Show("There was a problem inserting the chamber CD into the file. Check the entered information and try again!", "Error");
                        }
                    }
                }
            }
        }
Esempio n. 18
0
        }//end of create chamber on click method

        private void btnResetForm_Click(object sender, EventArgs e)
        {
            FormController.clear(this);                     //clears form
            btnEnterUPC.Text = "Click HERE to enter a UPC"; //not covered in clear method
            btnDelete.Text   = "Delete";                    //not covered in clear method
        }