private void button1_Click(object sender, EventArgs e)
{
projectpizzaDataSet ds = new projectpizzaDataSet();
projectpizzaDataSetTableAdapters.customersTableAdapter daCust = new projectpizzaDataSetTableAdapters.customersTableAdapter();
daCust.Fill(ds.customers);
projectpizzaDataSet.customersRow dr = ds.customers.FindByTel_Numbers(textBox1.Text);
try
{ if(textBox1.Text != null && textBox2.Text != null && textBox3.Text !=null && textBox5.Text !=null)
daCust.Insert(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text); // to create new customer
}
catch (Exception ex)
{
MessageBox.Show("This customer already exist");
}
}
private void button3_Click(object sender, EventArgs e)
{
//to fill the texts
projectpizzaDataSet ds = new projectpizzaDataSet();
projectpizzaDataSetTableAdapters.customersTableAdapter daCust = new projectpizzaDataSetTableAdapters.customersTableAdapter();
daCust.Fill(ds.customers);
projectpizzaDataSet.customersRow dr = ds.customers.FindByTel_Numbers(textBox1.Text);
//for (int i = 0; i < ds.customers.Count; i++)
//{
// if (textBox1.Text == ds.customers[i].Tel_Numbers)
// {
// textBox2.Text = ds.customers[i].Name;
// break;
// }
// else textBox2.Text = "";
if (dr != null)
{
textBox2.Text = dr.Name;
textBox3.Text = dr.Address;
textBox4.Text = dr.Post_code;
textBox5.Text = dr.City;
}
else MessageBox.Show("No such customer.Create new or Search again.");
}
private void button6_Click(object sender, EventArgs e)
{
projectpizzaDataSet ds = new projectpizzaDataSet();
projectpizzaDataSetTableAdapters.customersTableAdapter daCust = new projectpizzaDataSetTableAdapters.customersTableAdapter();
daCust.Fill(ds.customers);
projectpizzaDataSet.customersRow dr = ds.customers.FindByTel_Numbers(textBox1.Text);
if (dr != null && dr.Tel_Numbers == textBox1.Text)
{
daCust.Delete(Original_Tel_Numbers = textBox1.Text, Original_Name = textBox2.Text, Original_Address = textBox3.Text, Original_City = textBox4.Text, Original_Post_code = textBox5.Text);
}
}