private void button1_Click(object sender, EventArgs e) { DbSupplier db = new DbSupplier(); WindowsFormsApplication1.Supplier w = new WindowsFormsApplication1.Supplier(); try { w.SupplierId = textBox1.Text; if (db.SupplierExist(w.SupplierId) == true) { DialogResult dialogResult = MessageBox.Show("Are You Sure To Delete Supplier?", "Delete", MessageBoxButtons.YesNoCancel); if (dialogResult == DialogResult.Yes) { db.DeleteSupplier(w); MessageBox.Show("Call was deleted Successfully"); } } else { MessageBox.Show("Supplier with similar ID was not found , try again", "Error"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click_1(object sender, EventArgs e) { DbSupplier db = new DbSupplier(); try { WindowsFormsApplication1.Supplier w = new WindowsFormsApplication1.Supplier(); w.SupplierId = textBox1.Text; if (comboBox1.SelectedIndex == 0) { dataGridView1.DataSource = db.SearchSupplierById(w.SupplierId).Tables[0]; } else if (comboBox1.SelectedIndex == 1) { dataGridView1.DataSource = db.SearchSuppliersByName(w.Name).Tables[0]; } else { dataGridView1.DataSource = db.SearchSuppliersByCompany(w.Company).Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click(object sender, EventArgs e) { DbSupplier db = new DbSupplier(); WindowsFormsApplication1.Supplier w = new WindowsFormsApplication1.Supplier(); w.SupplierId = textBox1.Text; w.Name = textBox3.Text; w.Company = textBox2.Text; w.Address = textBox4.Text; w.Phone = textBox5.Text; w.Fax = textBox6.Text; }
private void button1_Click(object sender, EventArgs e) { WindowsFormsApplication1.Supplier w = new WindowsFormsApplication1.Supplier(); DbSupplier db = new DbSupplier(); w.SupplierId = textBox1.Text; w.SupplierId = textBox3.Text; w.Name = textBox2.Text; w.Company = textBox4.Text; w.Address = textBox5.Text; w.Phone = textBox6.Text; db.UpdateSupplier(w); MessageBox.Show("Successfully updated Supplier"); }
private void button3_Click(object sender, EventArgs e) { WindowsFormsApplication1.Supplier w = new WindowsFormsApplication1.Supplier(); DbSupplier db = new DbSupplier(); DataSet ds = new DataSet(); }