public void addClientWithDetails(Tables.Users user, Tables.User_Details user_Details)
{
OracleConnection Connection = new OracleConnection(stringConnection);
OracleCommand cmd = new OracleCommand("AddUser", Connection);
OracleCommand cmd2 = new OracleCommand("AddUserDetails", Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd2.CommandType = CommandType.StoredProcedure;
//insert user
cmd.Parameters.Add("UserId_", OracleDbType.NVarchar2).Value = user.UserId;
cmd.Parameters.Add("Password_", OracleDbType.NVarchar2).Value = user.UserPassword;
cmd.Parameters.Add("Admin_", OracleDbType.Int16).Value = user.Admin;
//insert user details
cmd2.Parameters.Add("UserId_", OracleDbType.NVarchar2).Value = user.UserId;
cmd2.Parameters.Add("Email_", OracleDbType.NVarchar2).Value = user_Details.Email;
cmd2.Parameters.Add("FirstName_", OracleDbType.NVarchar2).Value = user_Details.FirstName;
cmd2.Parameters.Add("LastName_", OracleDbType.NVarchar2).Value = user_Details.LastName;
cmd2.Parameters.Add("Adresse_", OracleDbType.NVarchar2).Value = user_Details.Adresse;
cmd2.Parameters.Add("Phone_", OracleDbType.NVarchar2).Value = user_Details.Phone;
cmd2.Parameters.Add("BrithDay_", OracleDbType.Date).Value = user_Details.BrithDay;
//try execute the querys
try
{
Connection.Open();
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
Connection.Close();
}catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_ok_Click(object sender, EventArgs e)
{
//test if the fields
OracleDataBase db = new OracleDataBase();
Tables.User_Details user_Details = new Tables.User_Details(txb_user_name.Text, txb_email.Text, txb_first_name.Text,
txb_last_name.Text, txb_adresse.Text, txb_phone_number.Text, DateTime.Parse(dtp_brith_day.Text), false);
Tables.Users user = new Tables.Users(txb_user_name.Text, txb_password.Text, cb_admin.Checked);
db.addClientWithDetails(user, user_Details);
clearTextBoxes();
//test if the fields is not null
//add client if note exist else update with comfirmation msg
//get user detail by id for modify
}