Exemplo n.º 1
0
        private void DeleteRegistrationBtn_Click(object sender, EventArgs e)
        {
            if (registrationListBox.SelectedIndex < 0)
            {
                MessageBox.Show("Please select a registration");
                return;
            }

            Registration registration = (Registration)registrationListBox.SelectedItem;

            string message = $"Are you sure you want to delete Customer #{registration.CustomerID}'s registration?";

            DialogResult result = MessageBox.Show(text: message,
                                                  caption: "Delete?",
                                                  buttons: MessageBoxButtons.YesNo,
                                                  icon: MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                try
                {
                    BookRegistrationDB.Delete(registration.CustomerID);
                    registrationListBox.Items.Remove(registration);
                    MessageBox.Show("Registration deleted");
                }
                catch (SqlException)
                {
                    MessageBox.Show("We are having server issues. Try again later");
                }
                catch (Exception)
                {
                    MessageBox.Show("No registrations were deleted");
                }
            }
        }
Exemplo n.º 2
0
        private void ShowAllRegisteredForm_Load(object sender, EventArgs e)
        {
            List <Registration> allRegistration = BookRegistrationDB.GetAllRegistration();

            allRegistration = allRegistration
                              .OrderBy(id => id.CustomerID)
                              .ToList();

            registrationListBox.Items.Clear();

            foreach (Registration r in allRegistration)
            {
                registrationListBox.Items.Add(r);
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// Registers a single selected customer and book
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void RegisterProductButton_Click(object sender, EventArgs e)
        {
            if (IsSelectionValid() == true)
            {
                //Create a RegistrationConfirmationForm object
                RegisterConfirmationForm confirm = new RegisterConfirmationForm();

                //Gives the user an option to confirm their registration or not
                DialogResult result = confirm.ShowDialog();

                //If user clicks yes
                if (result == DialogResult.OK)
                {
                    //Get the selected customer
                    Customer c = (Customer)customerComboBox.SelectedItem;

                    //Grab the selected book
                    Book b = (Book)bookComboBox.SelectedItem;

                    //Create a registration object
                    Registration regBook = new Registration()
                    {
                        //Get the selected customer's CustomerID
                        CustomerID = c.CustomerID,

                        //Get the selected book's ISBN
                        ISBN = b.ISBN,

                        //Get the register date
                        RegDate = dateRegisteredPicker.Value
                    };

                    //Once the registration object has been created
                    //set the new registration into the property (Registration.cs)
                    NewReg = regBook;

                    //Add the registration to the database
                    BookRegistrationDB.RegisterBook(regBook);

                    bookComboBox.Text     = "";
                    customerComboBox.Text = "";
                }
            }
        }
Exemplo n.º 4
0
        private void btnRegBook_Click(object sender, EventArgs e)
        {
            if (cboCustomer.SelectedIndex < 0 || cboBook.SelectedIndex < 0)
            {
                MessageBox.Show("You must make a selection.");
                return;
            }
            try
            {
                Customer selectedCust = (Customer)cboCustomer.SelectedItem;
                Book     selectedBook = (Book)cboBook.SelectedItem;
                DateTime DateReg      = (DateTime)dtpRegDate.Value;

                Registration updateReg = new Registration(selectedCust.CustomerID, selectedBook.ISBN, DateReg);
                BookRegistrationDB.RegisterBook(updateReg);
            }
            catch (SqlException sqlex)
            {
                MessageBox.Show("We are having server issues, please try again later.");
            }
        }