//Deletes everything from the employee benefits, job benefits and entitlement tables
private void ClearEntitleBtn_Click(object sender, EventArgs e)
{
DialogResult Dr = MessageBox.Show("You pressed the button to completely clear all your entitlements from the database. Are you sure you want to do this?", "Clear Job Benefits", MessageBoxButtons.YesNo);
if (Dr == DialogResult.Yes)
{
String query = "Delete from [Job Benefits]; " +
"Delete from [Employee Benefits]; " +
"Delete from [Entitlements];";
using (connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Hide();
EnterEntitlement En = new EnterEntitlement();
En.Show();
}
}
//closes the current page and then opens the Enter Entitlement page when the button is pressed
private void EnterBeneBtn_Click(object sender, EventArgs e)
{
this.Hide();
EnterEntitlement Ee = new EnterEntitlement();
Ee.Show();
}
//deletes everything in the database
private void ClearDatabaseBtn_Click(object sender, EventArgs e)
{
DialogResult Dr = MessageBox.Show("You pressed the button to completely clear your database of all data. Are you sure you want to do this?", "Clear Database", MessageBoxButtons.YesNo);
if (Dr == DialogResult.Yes)
{
DialogResult dr = MessageBox.Show("Are you completely sure that you wish to clear your database? You cannot retrieve your database and it will be deleted forever", "Clear Database", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
String query = "Delete from [Employee Benefits]; " +
"Delete from [Job Benefits]; " +
"Delete from Entitlements; " +
"Delete from Employee; " +
"Delete from Jobs;";
using (connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Hide();
EnterEntitlement En = new EnterEntitlement();
En.Show();
}
}
}
