public static Qualification getQualification()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM qualification WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Console.Write(Employee.employee_id + "\n");
Qualification q = null;
if (reader.Read())
{
q = new Qualification();
q.q_id = int.Parse(reader["idqualification"].ToString());
q.institute = reader["institute"].ToString();
q.months = reader["months"].ToString();
q.status = reader["status"].ToString();
q.note = reader["note"].ToString();
q.qualification = reader["qualification"].ToString();
q.year = reader["year"].ToString();
q.qualification_no = reader["qualification_no"].ToString();
if (reader["occupation_relevant"].ToString() == "True") { q.occupation_relevant = true; }
else { q.occupation_relevant = false; }
if (reader["highest_qualification"].ToString() == "True") { q.highest_qualification = true; }
else { q.highest_qualification = false; }
}
reader.Close();
dbcon.closeConnection();
return q;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public static bool addQualification(Qualification q)
{
DBConnector dbcon = new DBConnector();
try
{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO qualification (qualification_no, institute, months, occupation_relevant, highest_qualification, status, note, qualification, year, employee_idemployee) VALUES (N'" + q.qualification_no + "', N'" + q.institute + "', N'" + q.months + "', " + q.occupation_relevant + ", " + q.highest_qualification + ", N'" + q.status + "', N'" + q.note + "', N'" + q.qualification + "', N'" + q.year + "', " + 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 void updateQualification()
{
Qualification q = new Qualification();
q.q_id = this.q_id;
if (this.qual_highest_qualification.Checked) { q.highest_qualification = true; }
else { q.highest_qualification = false; }
if (this.qual_occupation_relevant.Checked) { q.occupation_relevant = true; }
else { q.occupation_relevant = false; }
q.institute = this.qual_institute.Text;
q.months = this.qual_months.Text;
q.note = this.qual_note.Text;
q.qualification = this.qual_qualification.Text;
q.qualification_no = this.qualification_no.Text;
q.status = this.qual_status.Text;
q.year = this.qual_year.Text;
bool state = QualificationsHandler.updateQualifications(q);
Console.Write(state + "\n");
}
public static bool updateQualifications(Qualification q)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE qualification SET qualification_no=N'" + q.qualification_no + "', institute=N'" + q.institute + "', months=N'" + q.months + "', occupation_relevant=" + q.occupation_relevant + ", highest_qualification=" + q.highest_qualification + ", status=N'" + q.status + "', note=N'" + q.note + "', qualification=N'" + q.qualification + "', year=N'" + q.year + "' WHERE employee_idemployee=" + Employee.employee_id + " AND idqualification=" + q.q_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 btnSave1_Click(object sender, EventArgs e)
{
Qualification q = new Qualification();
if (qual_highest_qualification.Checked) { q.highest_qualification = true; }
else { q.highest_qualification = false; }
if (qual_occupation_relevant.Checked) { q.occupation_relevant = true; }
else { q.occupation_relevant = false; }
q.institute = qual_institute.Text;
q.months = qual_months.Text;
q.note = qual_note.Text;
q.qualification = qual_qualification.Text;
q.qualification_no = qualification_no.Text;
q.status = qual_status.Text;
q.year = qual_year.Text;
bool status = QualificationsHandler.addQualification(q);
if (status)
{
MessageBox.Show("Qualification details added successfully...!");
//btnSave4.Enabled = true;
//btnSave5.Enabled = true;
}
else { MessageBox.Show("Failed to add qualification details...!"); }
}
