private void deactivateEmployeeButton_Click(object sender, EventArgs e)
{
//Deactivates a selected employee.
try
{
//Checks to ensure an employee is selected.
if (employeeListingListView.SelectedItems.Count == 0)
{
MessageBox.Show("Employee not selected, select an Employee and try again.");
}
//Loops through and deletes only the selected employee.
foreach (int i in employeeListingListView.SelectedIndices)
{
DsUtil utility = new DsUtil();
int employee = utility.getEmployeeId(employeeListingListView.Items[i].Text);
employeeListingListView.Items.Remove(employeeListingListView.Items[i]);
string query = "DELETE FROM software_eng_db_1.employee WHERE employee.employee_id = " + employee + ";";
RetrieveData rD = new RetrieveData(query);
if (rD.updateData())
{
//Shows a success message upon sucessful deletion from the database.
MessageBox.Show("Employee Deactivated.");
}
}
}
catch
{
MessageBox.Show("Database may have disconnected, or selected data is not available.");
}
}
private void enterTaskButton_Click(object sender, EventArgs e)
{
DsUtil utility = new DsUtil();
//Set variables to user input
int project = DsUtil.selectedIndex;
string taskDesc = taskNameTextBox.Text;
int hours = int.Parse(hoursTextBox.Text);
int completedBy = utility.getEmployeeId(completedTextBox.Text);
int materialID = utility.getMaterialId(materialNameTextBox.Text);
bool flag = false;
try
{
//Create SQL query.
string query = "INSERT INTO software_eng_db_1.task (task_description, task_hours_to_complete, employee_id, project_id, material_id)"
+ " VALUES('" + taskDesc + "', " + hours + ", " + completedBy + ", " + project + ", " + materialID + ");";
//Send query to data retrieval class.
RetrieveData rD = new RetrieveData(query);
if (rD.updateData())
{
//If update is successful, set flag.
flag = true;
}
if (flag)
{
MessageBox.Show("New Task created.");
}
}
catch
{
MessageBox.Show("Database may have disconnected, or selected data is not available.");
}
}