Пример #1
0
        private void EditCurrentCustomer()
        {
            if (_bsCustomers.DataSource == null)
            {
                MessageBox.Show("Please select some data");
                return;
            }

            var contactList = _dataOperations.RetrieveContactTitles();

            CustomerEditorForm f = new CustomerEditorForm();

            try
            {
                f.CompanyNameTextBox.Text     = _bsCustomers.CurrentRow().CompanyName();
                f.ContactNameTextBox.Text     = _bsCustomers.CurrentRow().ContactName();
                f.cboContactTitles.DataSource = contactList;

                f.cboContactTitles.SelectedIndex =
                    contactList.FindIndex((contactType) => contactType.ContactType == _bsCustomers.CurrentRow()
                                          .ContactTitle());

                if (f.ShowDialog() == DialogResult.OK)
                {
                    if (f.ValidateTextBoxes())
                    {
                        var customerIdentifier    = _bsCustomers.CurrentRow().Identifier();
                        var contactTypeIdentifier = ((ContactTypes)f.cboContactTitles.SelectedItem).Identifier;

                        if (_dataOperations.UpdateCustomer(customerIdentifier, f.CompanyNameTextBox.Text, f.ContactNameTextBox.Text, contactTypeIdentifier))
                        {
                            _bsCustomers.CurrentRow().SetCompanyName(f.CompanyNameTextBox.Text);
                            _bsCustomers.CurrentRow().SetContactName(f.ContactNameTextBox.Text);
                            _bsCustomers.CurrentRow().SetContactTitle(f.cboContactTitles.Text);
                        }
                    }
                    else
                    {
                        MessageBox.Show("Nothing save as one or more fields were empty.");
                    }
                }
            }
            finally
            {
                f.Dispose();
            }
        }
Пример #2
0
        /// <summary>
        /// Insert a new row
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <remarks></remarks>
        private void NewCustomerButton_Click(object sender, EventArgs e)
        {
            if (_bsCustomers.DataSource == null)
            {
                MessageBox.Show("Please select some data");
                return;
            }


            CustomerEditorForm f = new CustomerEditorForm();

            try
            {
                f.cboContactTitles.DataSource = _dataOperations.RetrieveContactTitles();

                if (f.ShowDialog() == DialogResult.OK)
                {
                    var contactTypeIdentifier = ((ContactTypes)f.cboContactTitles.SelectedItem).Identifier;
                    int primaryKey            = _dataOperations.AddCustomer(f.CompanyNameTextBox.Text, f.ContactNameTextBox.Text, contactTypeIdentifier);

                    if (primaryKey != -1)
                    {
                        _bsCustomers.AddRow(
                            primaryKey,
                            f.CompanyNameTextBox.Text,
                            f.ContactNameTextBox.Text,
                            f.cboContactTitles.Text,
                            contactTypeIdentifier);
                    }
                }
            }
            finally
            {
                f.Dispose();
            }
        }