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();
}
