private void button1_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into DISTRIBUTOR (NAME,CONTACTNUMBER,TRADEMARKID,EMAIL)values ('{0}','{1}','{2}','{3}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text);
EventMangementSystemClass.Add(addquery);
var query = string.Format("SELECT * FROM DISTRIBUTOR");
EventMangementSystemClass.RecordShow(query, dataGridView2);
Vendoridtextbox.Clear();
vendornametextbox.Clear();
maskedTextBox1.Clear();
emailtextbox.Clear();
comboBox1.Text = "";
textBox1.Clear();
companyaddresstextbox.Clear();
contactnumbertextbox.Clear();
emailaddresstextbox.Clear();
VENDOR_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
string updatequery = string.Format("delete from DISTRIBUTOR where DISTRIBUTORID = ('{0}')", Convert.ToInt32(Vendoridtextbox.Text));
EventMangementSystemClass.Update(updatequery);
var query = string.Format("SELECT * FROM DISTRIBUTOR");
EventMangementSystemClass.RecordShow(query, dataGridView2);
Vendoridtextbox.Clear();
vendornametextbox.Clear();
maskedTextBox1.Clear();
emailtextbox.Clear();
comboBox1.Text = "";
textBox1.Clear();
companyaddresstextbox.Clear();
contactnumbertextbox.Clear();
emailaddresstextbox.Clear();
VENDOR_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
//try
//{
string updatequery = string.Format("UPDATE DISTRIBUTOR SET NAME = ('{0}'), CONTACTNUMBER = ('{1}'),TRADEMARKID = ('{2}'), EMAIL = ('{3}') where DISTRIBUTORID=('{4}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text, Convert.ToInt32(Vendoridtextbox.Text));
EventMangementSystemClass.Update(updatequery);
var query = string.Format("SELECT * FROM DISTRIBUTOR");
EventMangementSystemClass.RecordShow(query, dataGridView2);
Vendoridtextbox.Clear();
vendornametextbox.Clear();
maskedTextBox1.Clear();
emailtextbox.Clear();
comboBox1.SelectedValue = "";;
textBox1.Clear();
companyaddresstextbox.Clear();
contactnumbertextbox.Clear();
emailaddresstextbox.Clear();
VENDOR_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
// }
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}