public static bool addExtracurricularActivity(ExtracurricularActivity eca)
{
DBConnector dbcon = new DBConnector();
try
{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO extracurricular_activity (type, method, award, employee_idemployee) VALUES (N'" + eca.type + "', N'" + eca.method + "', N'" + eca.award + "', " + Employee.employee_id + ")";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
dbcon.closeConnection();
return false;
}
}
catch (MySqlException e)
{
int errorcode = e.Number;
dbcon.closeConnection();
return false;
}
}
public static ExtracurricularActivity getExtracurricularActivity()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM extracurricular_activity WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
ExtracurricularActivity ea = null;
if (reader.Read())
{
ea = new ExtracurricularActivity();
ea.ea_id = int.Parse(reader["idextracurricular_activity"].ToString());
ea.award = reader["award"].ToString();
ea.method = reader["method"].ToString();
ea.type = reader["type"].ToString();
}
reader.Close();
dbcon.closeConnection();
return ea;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public void updateExtraCurAc()
{
ExtracurricularActivity eca = new ExtracurricularActivity();
eca.ea_id = this.ea_id;
eca.award = this.ea_award.Text;
eca.method = this.ea_method.Text;
eca.type = this.ea_type.Text;
bool state = ExtracurricularActivityHandler.updateExtracurricularActivity(eca);
Console.Write(state + "\n");
}
public static bool updateExtracurricularActivity(ExtracurricularActivity ea)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE extracurricular_activity SET type=N'" + ea.type + "', method=N'" + ea.method + "', award=N'" + ea.award + "' WHERE employee_idemployee=" + Employee.employee_id + " AND idextracurricular_activity=" + ea.ea_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
private void btnSave3_Click(object sender, EventArgs e)
{
ExtracurricularActivity eca = new ExtracurricularActivity();
eca.award = ea_award.Text;
eca.method = ea_method.Text;
eca.type = ea_type.Text;
bool status = ExtracurricularActivityHandler.addExtracurricularActivity(eca);
if (status)
{
MessageBox.Show("Extracurricular activity details added successfully...!");
//btnSave4.Enabled = true;
//btnSave5.Enabled = true;
}
else { MessageBox.Show("Failed to add extracurricular activity experience details...!"); }
}
