public void DeleteEmployee(Employee add)
{
if (add is Manager)
{
string query = "DELETE FROM administration WHERE idAdministration='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "DELETE FROM users WHERE person_id = '"+ add.getIdNumber() +"' AND type = 'manager';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
else if (add is Receptionist)
{
string query = "DELETE FROM reception WHERE idReception='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "DELETE FROM users WHERE person_id = '" + add.getIdNumber() + "' AND type = 'reception';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
else if (add is Trainer)
{
string query = "DELETE FROM trainers WHERE idtrainer='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "DELETE FROM users WHERE person_id = '" + add.getIdNumber() + "' AND type = 'trainer';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
else if (add is Instructor)
{
string query = "DELETE FROM instructor WHERE idInstructor='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
string query2 = "DELETE FROM users WHERE person_id = '" + add.getIdNumber() + "' AND type = 'instructor';";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
}
public String EditEmployee(Employee add)
{
int returnRows = 0;
if (add is Manager)
{
string query = "UPDATE administration SET F_Name='" + add.getNameFirst() + "', L_Name='" + add.getNameLast() + "', Job_Description='manager', Premission='" + add.getPermissionLevel() + "', Sal_Hour='" + add.getSallaryPerHour() + "', phone_number='" + add.getPhoneNumber() + "', person_id='" + add.getIdNumber() + "', address='" + add.getHomeAddress() + "', email='" + add.getEmailAddress() + "' WHERE idAdministration='"+add.getDBid()+"';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
returnRows = cmd.ExecuteNonQuery();
}
else if (add is Receptionist)
{
string query = "UPDATE reception SET F_Name='" + add.getNameFirst() + "', L_Name='" + add.getNameLast() + "', Job_Description='reception', Premission='" + add.getPermissionLevel() + "', Sal_Hour='" + add.getSallaryPerHour() + "', phone_number='" + add.getPhoneNumber() + "', person_id='" + add.getIdNumber() + "', address='" + add.getHomeAddress() + "', email='" + add.getEmailAddress() + "' WHERE idReception='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
returnRows = cmd.ExecuteNonQuery();
}
else if (add is Trainer)
{
string query = "UPDATE trainers SET F_Name='" + add.getNameFirst() + "', L_Name='" + add.getNameLast() + "', Job_Description='trainer', Premission='" + add.getPermissionLevel() + "', Sal_Hour='" + add.getSallaryPerHour() + "', phone_number='" + add.getPhoneNumber() + "', person_id='" + add.getIdNumber() + "', address='" + add.getHomeAddress() + "', certificate=" + ((Trainer)add).getTrainerCartificate() + ",email='" + add.getEmailAddress() + "' WHERE idtrainer='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
returnRows = cmd.ExecuteNonQuery();
}
else if (add is Instructor)
{
string query = "UPDATE instructor SET F_Name='" + add.getNameFirst() + "', L_Name='" + add.getNameLast() + "', Job_Description='instructor', Premission='" + add.getPermissionLevel() + "', Sal_Hour='" + add.getSallaryPerHour() + "', phone_number='" + add.getPhoneNumber() + "', person_id='" + add.getIdNumber() + "', address='" + add.getHomeAddress() + "', email='" + add.getEmailAddress() + "' WHERE idInstructor='" + add.getDBid() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
returnRows = cmd.ExecuteNonQuery();
}
if (returnRows <= 0)
{
return "No Employee Was Edited";
}
else {
return add.getNameFirst() + " " + add.getNameLast() + " was Edited";
}
}
