public void searchDataGrid(object sender, EventArgs e) { clearDataGrid(); updateResultsNumber(); if (!this.txtVendorSearch.Text.ToString().Equals("")) { if (this.comboVendorSearchTypes.SelectedItem.ToString().Equals("ID")) { int temp; if (!Int32.TryParse(txtVendorSearch.Text.ToString(), out temp)) { MessageBox.Show("You must enter a number"); } else { VendorDB.PullVendorByID(Int32.Parse(txtVendorSearch.Text)); populateDateGrid(); } } else { clearDataGrid(); VendorDB.PullVendorByName(txtVendorSearch.Text.ToString()); populateDateGrid(); } } }
public void TestRefresh(frmVendors theForm) { this.clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); }
public frmVendors() { InitializeComponent(); clearDataGrid(); VendorDB.PullVendorsFromDB(); InitTimer(); populateDateGrid(); comboVendorSearchTypes.Items.Clear(); comboVendorSearchTypes.Items.Add("ID"); comboVendorSearchTypes.Items.Add("Name"); }
private void btnVendorAdd_Click(object sender, EventArgs e) { if (!txtVendorName.Text.ToString().Equals("")) { if (VendorDB.AddVendor(txtVendorName.Text, txtVendorDescription.Text, txtVendorPhone.Text, txtVendorWebsite.Text, txtVendorNotes.Text)) { frmVendors.updated = true; MessageBox.Show("Success!"); clearTextBoxes(sender, e); this.Close(); } else { MessageBox.Show("Error?"); } } else { MessageBox.Show("You must enter at least a name!"); } }
private void btnVendorDelete_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete this record?", "ATTENTION: PERMANENT CHANGE", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { Console.WriteLine("Yes"); VendorIDSelected = Int32.Parse(dataGridVendors.CurrentRow.Cells[0].Value.ToString()); string deleteStatement = "delete from Vendors where VendorID='" + VendorIDSelected + "'"; SqlConnection connection = new SqlConnection(VendorDB.connectionString); SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); try { connection.Open(); deleteCommand.ExecuteNonQuery(); MessageBox.Show("Record deleted. "); clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } } else if (dialogResult == DialogResult.No) { // } }
public void reloadDefaultData() { clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); }