private void btnCustomerAdd_Click(object sender, EventArgs e) { if (TextBoxValidation(txtCustomerName, txtCustomerSurname, txtContactNumber, txtCustomerEmailAddress)) { DialogResult dr = new DialogResult(); dr = MessageBox.Show("Are you sure you want to add this customer?", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { int isValid; CCustomer customer = new CCustomer(); SqlConnection conn = new SqlConnection(); List <int> iList = customer.AddCustomer(conn, txtCustomerName.Text.ToString(), txtCustomerSurname.Text, txtCustomerEmailAddress.Text, txtContactNumber.Text); isValid = iList[0]; if (isValid == 1) { MessageBox.Show("Customer has successfully been added."); iCustomerId = iList[1]; this.Close(); } else { MessageBox.Show("Customer was not added.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnRemoveCustomer_Click(object sender, EventArgs e) { if (dgvCustomers.Rows.Count < 1 || txtCustomeID.Text == "" || txtCustomeID.Text == "Generated automatically") { MessageBox.Show("Please select an item to remove.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DialogResult dr = new DialogResult(); dr = MessageBox.Show("Are you sure you want to remove this customer?", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { int isValid; CCustomer customer = new CCustomer(); isValid = customer.RemoveCustomer(conn, Convert.ToInt32(txtCustomeID.Text)); if (isValid == 1) { MessageBox.Show("Customer has successfully been removed."); RefreshDataSource(dgvCustomers, "sp_GetCustomerInfo"); } else { MessageBox.Show("Customer was not removed.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnCustomerEdit_Click(object sender, EventArgs e) { if (TextBoxValidation(txtCustomerName, txtCustomerSurname, txtContactNumber, txtCustomerEmailAddress)) { DialogResult dr = new DialogResult(); dr = MessageBox.Show("Are you sure you want to edit this customer?", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { int isValid; CCustomer customer = new CCustomer(); isValid = customer.EditCustomer(conn, Convert.ToInt32(txtCustomeID.Text), txtCustomerName.Text, txtCustomerSurname.Text, txtContactNumber.Text, txtCustomerEmailAddress.Text); if (isValid == 1) { MessageBox.Show("Customer has successfully been updated."); RefreshDataSource(dgvCustomers, "sp_GetCustomerInfo"); CustomerLayoutChange(); } else { MessageBox.Show("Customer was not updated.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }