private void btnUpdate_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
DataTable jb = db.dbSelect("SELECT id from tb_job WHERE description='" + cmbJob.Text + "'");
DataTable dp = db.dbSelect("SELECT id from tb_department WHERE code='" + cmbDept.Text + "'");
DataTable parent = db.dbSelect("SELECT id from tb_department WHERE code='" + cmbParent.Text + "'");
if (this.activeForm == "Information")
{
db.dbUpdate("UPDATE tb_info SET lastname='" + txtLN.Text + "', firstname='" + txtFN.Text + "', middlename='" + txtMN.Text + "', address='" + txtAdd.Text + "', birthdate='" + pickBday.Text + "', birthplace='" + txtBPlace.Text + "', contact='" + txtContact.Text + "', department=" + dp.Rows[0][0].ToString() + ", job=" + jb.Rows[0][0].ToString() + " WHERE id=" + this.activeID);
}
if (this.activeForm == "Department")
{
db.dbUpdate("UPDATE tb_department SET code='" + txtCode.Text + "', description='" + txtDesc.Text + "' WHERE id=" + this.activeID);
}
if (this.activeForm == "Job")
{
db.dbUpdate("UPDATE tb_job SET description='" + txtJob.Text + "', parent=" + parent.Rows[0][0] + ", salary=" + txtSalary.Text + " WHERE id=" + this.activeID);
}
Main main = new Main();
this.Hide();
main.Show();
MessageBox.Show("Updated!");
}