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_view_volunteers_Click(object sender, EventArgs e)
{
volunteers volunteer = new volunteers();
volunteer.Volunteer_Task = Convert.ToInt32(viewDropdownList.SelectedValue);
try
{
conn.Open();
string command = "SELECT person_first_name, person_last_name, person_email FROM persons WHERE person_task = :v_task";
OracleCommand cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("v_task", volunteer.Volunteer_Task));
OracleDataReader reader = cmd.ExecuteReader();
displayVolunteers.Text = "";
displayVolunteers.Text = "<table style=\"border:1px solid black;text-align:left;\"><tr><th style=\"border:1px solid black;\">First Name</th><th style=\"border:1px solid black;\">Last Name</th><th style=\"border:1px solid black;\">Email</th></tr>";
while (reader.Read())
{
displayVolunteers.Text += "<tr><td style=\"border:1px solid black;\">" + reader["person_first_name"] + "</td><td style=\"border:1px solid black;\">" + reader["person_last_name"] + "</td><td style=\"border:1px solid black;\">" + reader["person_email"] + "</td><tr>";
}
displayVolunteers.Text += "</table>";
conn.Close();
}
catch (OracleException except)
{
error_message_text.Text += except.Message;
}
finally
{
}
}
protected void btn_volunteer_update_Click(object sender, EventArgs e)
{
volunteers volunteer = new volunteers();
volunteer.Volunteer_Task = Convert.ToInt32(dropdownList.SelectedValue);
volunteer.Volunteer_Email = loginEmailInput.Text;
volunteer.Volunteer_Password = loginPasswordInput.Text;
int rows = 0;
try
{
conn.Open();
string command = "UPDATE persons SET person_task = :v_task WHERE person_email = :v_email AND person_pw = :v_pw";
OracleCommand cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("v_task", volunteer.Volunteer_Task));
cmd.Parameters.Add(new OracleParameter("v_email", volunteer.Volunteer_Email));
cmd.Parameters.Add(new OracleParameter("v_pw", volunteer.Volunteer_Password));
rows = cmd.ExecuteNonQuery();
conn.Close();
}
catch (OracleException except)
{
error_message_text.Text += except.Message;
}
finally
{
error_message_text.Text += " " + Convert.ToString(rows) + " rows updated.";
}
}
protected void btn_login_volunteer_Click(object sender, EventArgs e)
{
volunteers volunteer = new volunteers();
volunteer.Volunteer_Email = loginEmailInput.Text;
volunteer.Volunteer_Password = loginPasswordInput.Text;
int rows = 0;
try
{
conn.Open();
string query = "SELECT * FROM persons JOIN tasks ON person_task = task_id WHERE person_email = :v_email AND person_pw = :v_pw";
OracleCommand cmd = new OracleCommand(query, conn);
cmd.Parameters.Add(new OracleParameter("v_email", volunteer.Volunteer_Email));
cmd.Parameters.Add(new OracleParameter("v_pw", volunteer.Volunteer_Password));
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
displayName.Text = reader["person_first_name"] + " " + reader["person_last_name"];
if (reader["person_task"] == null)
{
displayVolunteer.Text += "Not Currently Volunteering";
}
else
{
displayVolunteer.Text = "Currently Volunteering with: " + reader["task_name"];
}
rows++;
}
if (volunteer.Volunteer_Email == "*****@*****.**" && volunteer.Volunteer_Password == "admin")
{
adminLoggedIn.Visible = true;
Session["adminLoggedIn"] = 1;
Session["volLoggedIn"] = null;
}
else if (rows > 0)
{
ifLoggedIn.Visible = true;
Session["volLoggedIn"] = 1;
Session["adminLoggedIn"] = null;
}
else
{
ifLoggedIn.Visible = false;
error_message_text.Text = "The login information you provided did not match our records.";
}
conn.Close();
}
catch (OracleException excep)
{
error_message_text.Text = excep.ToString();
error_message_text.Text = excep.Message;
}
finally
{
}
try
{
conn.Open(); //open connection
string query = "SELECT * FROM tasks";
OracleCommand cmd = new OracleCommand(query, conn);
OracleDataReader reader = cmd.ExecuteReader();
listOfTasks.Text = "<table style=\"border:1px solid black;text-align:left;\"><tr><th style=\"border:1px solid black;\">Task Name</th><th style=\"border:1px solid black;\">Task Supervisor</th></tr>";
while (reader.Read())
{
listOfTasks.Text += "<tr><td style=\"border:1px solid black;\">" + reader["task_name"] + "</td><td style=\"border:1px solid black;\">" + reader["task_supervisor"] + "</td><tr>";
if (Session["uploaded1"] == null)
{
ListItem insert = new ListItem(Convert.ToString(reader["task_name"]), Convert.ToString(reader["task_id"]));
dropdownList.Items.Insert(dropdownList.Items.Count, insert);
}
if (Session["uploaded2"] == null)
{
ListItem insertAdmin = new ListItem(Convert.ToString(reader["task_name"]), Convert.ToString(reader["task_id"]));
viewDropdownList.Items.Insert(viewDropdownList.Items.Count, insertAdmin);
}
}
listOfTasks.Text += "</table>";
Session["uploaded1"] = 1;
Session["uploaded2"] = 1;
conn.Close();
}
catch (OracleException excep)
{
error_message_text.Text = excep.ToString();
error_message_text.Text = excep.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.";
}
}
}
}
}
