public void RemoveDelivaryBoy(Remove_Delivery_Boy booy)
{
delivery_boy boy = new delivery_boy();
string ordb = "Data source=orcl;User Id=hr; Password=hr;";
OracleConnection conn;
conn = new OracleConnection(ordb);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "delete from Delivery_boy where Delivery_boy_ID=:id";
cmd.Parameters.Add("id", booy.cmb_Delivery_boy_delete.Text);
int r = cmd.ExecuteNonQuery();
if (r != -1)
{
booy.cmb_Delivery_boy_delete.Items.RemoveAt(booy.cmb_Delivery_boy_delete.SelectedIndex);
booy.Full_Name_del_Delivery_Boy_box.Text = "";
booy.Phone_del_Delivery_Boy_box.Text = "";
booy.No_Orders_del_delivery_boy_box.Text = "";
MessageBox.Show("Delivery Boy deleted");
}
}
public void addDelivayBoy(Add_Delivery_Boy booy)
{
delivery_boy boy = new delivery_boy();
string ordb = "Data source=orcl;User Id=hr; Password=hr;";
OracleConnection conn;
conn = new OracleConnection(ordb);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
boy.setName(booy.Full_Name_Delivery_Boy_box.Text.ToString());
boy.setId(int.Parse(booy.ID_Delivery_Boy_box.Text.ToString()));
boy.setPhone_no(booy.Phone_No_delivery_boy_box.Text.ToString());
cmd.CommandText = "insert into Delivery_boy values (:Full_Name,:ID,:Phone_No,:No_Orders)";
cmd.Parameters.Add("Full_Name", boy.getName());
cmd.Parameters.Add("ID", boy.getId());
cmd.Parameters.Add("Phone_No", boy.getPhone_no());
cmd.Parameters.Add("No_Orders", "0");
int r = cmd.ExecuteNonQuery();
if (r != -1)
{
MessageBox.Show("New Delivery Boy is added");
}
}