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...!"); } }