protected void btn_add_volunteer_task_Click(object sender, EventArgs e)
{
string taskName = addTaskNameInput.Text;
string taskSup = addTaskSupInput.Text;
int rows = 0;
databaseConnect db = new databaseConnect();
try
{
conn.Open();
string command = "INSERT INTO tasks VALUES(:t_id, :t_name, :t_sup)";
OracleCommand cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("t_id", null));
cmd.Parameters.Add(new OracleParameter("t_name", taskName));
cmd.Parameters.Add(new OracleParameter("t_sup", taskSup));
rows = cmd.ExecuteNonQuery();
conn.Close();
}
catch (OracleException ex)
{
error_message_text.Text = ex.Message;
}
finally
{
error_message_text.Text += " " + Convert.ToString(rows) + " rows updated.";
}
}
protected void btn_delete_volunteer_Click(object sender, EventArgs e)
{
volunteers volunteer = new volunteers();
volunteer.Volunteer_Email = deleteAccInput.Text;
int rows = 0;
databaseConnect db = new databaseConnect();
try
{
conn.Open();
string command = "DELETE FROM persons WHERE person_email = :v_email";
OracleCommand cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("v_email", volunteer.Volunteer_Email));
rows = cmd.ExecuteNonQuery();
conn.Close();
}
catch (OracleException ex)
{
error_message_text.Text = ex.Message;
}
finally
{
}
}
protected void btn_add_volunteer_Click(object sender, EventArgs e)
{
volunteers volunteer = new volunteers();
volunteer.Volunteer_FirstName = userFNameInput.Text;
volunteer.Volunteer_LastName = userLNameInput.Text;
volunteer.Volunteer_Email = userEmailInput.Text;
volunteer.Volunteer_Password = userPasswordInput.Text;
int rows = 0;
int testedRows = 0;
databaseConnect db = new databaseConnect();
if (userPasswordInput.Text == null || userPasswordInput.Text == "")
{
error_message_text.Text = "Please enter your password.";
}
else
{
if (userLNameInput.Text == null || userLNameInput.Text == "")
{
error_message_text.Text = "Please enter your last name.";
}
else
{
if (userFNameInput.Text == null || userFNameInput.Text == "")
{
error_message_text.Text = "Please enter your first name.";
}
else
{
if (Validator.EmailIsValid(volunteer.Volunteer_Email))
{
conn.Open();
string query1 = "SELECT * FROM persons WHERE person_email = :v_email";
OracleCommand cmd1 = new OracleCommand(query1, conn);
cmd1.Parameters.Add(new OracleParameter("v_email", volunteer.Volunteer_Email));
OracleDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
testedRows++;
}
conn.Close();
if (testedRows == 0)
{
try
{
conn.Open();
string command = "INSERT INTO persons VALUES(:v_id, :v_lname, :v_fname, :v_status, :v_email, :v_pw, :v_task)";
OracleCommand cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("v_id", null));
cmd.Parameters.Add(new OracleParameter("v_lname", volunteer.Volunteer_LastName));
cmd.Parameters.Add(new OracleParameter("v_fname", volunteer.Volunteer_FirstName));
cmd.Parameters.Add(new OracleParameter("v_status", "Volunteer"));
cmd.Parameters.Add(new OracleParameter("v_email", volunteer.Volunteer_Email));
cmd.Parameters.Add(new OracleParameter("v_pw", volunteer.Volunteer_Password));
cmd.Parameters.Add(new OracleParameter("v_task", 1));
rows = cmd.ExecuteNonQuery();
conn.Close();
}
catch (OracleException ex)
{
error_message_text.Text = ex.Message;
}
finally
{
error_message_text.Text += " " + Convert.ToString(rows) + " rows updated.";
}
}
else
{
error_message_text.Text = "Email is already in use.";
}
}
else
{
error_message_text.Text = "Please enter a valid email.";
}
}
}
}
}
