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");
}
}
private void Add_Delivery_boy_Click(object sender, EventArgs e)
{
Add_Delivery_Boy add_boy = new Add_Delivery_Boy();
add_boy.Show();
}
