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