private void button1_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
DataTable dt_job = new DataTable();
DataTable dt_dept = new DataTable();
dt_job = db.dbSelect("SELECT id FROM tb_job WHERE description='" + cmbJob.Text + "'");
dt_dept = 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.dbInsert("INSERT INTO tb_info (lastname, firstname, middlename, address, birthdate, birthplace, contact, department, job) VALUES ('" + txtLN.Text + "', '" + txtFN.Text + "', '" + txtMN.Text + "', '" + txtAdd.Text + "', '" + pickBday.Text + "', '" + txtBPlace.Text + "', '" + txtContact.Text + "', " + Convert.ToInt32(dt_dept.Rows[0][0]) + ", " + Convert.ToInt32(dt_job.Rows[0][0]) + ")");
}
if (this.activeForm == "Department")
{
db.dbInsert("INSERT INTO tb_department (code, description) VALUES ('" + txtCode.Text + "', '" + txtDesc.Text + "')");
}
if (this.activeForm == "Job")
{
db.dbInsert("INSERT INTO tb_job (description, parent, salary) VALUES ('" + txtJob.Text + "', " + parent.Rows[0][0] + ", " + txtSalary.Text + ")");
}
Main main = new Main();
this.Hide();
main.Show();
MessageBox.Show("Added!");
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtOtherLoansName.Text == "Name")
{
txtOtherLoansName.Text = "Other";
}
if (this.txtNetPay.Text != "0.00")
{
dbClass db = new dbClass();
DateTime date = DateTime.Now;
String query = "insert into tb_employee (fullname, department, job, rate, no_of_days, gross_income, overtime_hrs, no_of_absences, loan_pagibig, loan_sss, loan_other_name, loan_other, prem_pagibig, prem_sss, prem_philhealth, total_loans, total_prem_loans, total_deduction, net_pay, date) values ('" + cmbEmployees.Text + "', '" + lblDept.Text + "', '" + lblJob.Text + "', " + txtSalary.Text + ", " + numWorkDays.Value + ", " + this.gross_pay + ", " + numOT.Value + ", " + numAbsent.Value + ", " + txtPagibigLoans.Text + ", " + txtSSSLoans.Text + ", '" + txtOtherLoansName.Text + "', " + txtOtherLoans.Text + ", " + txtPremPagibig.Text + ", " + txtPremSSS.Text + ", " + txtPremPhil.Text + ", " + labelLoans.Text + ", " + lblPremLoans.Text + ", " + lblTotalDeductions.Text + ", " + txtNetPay.Text + ", '" + date + "')";
db.dbInsert(query);
Main main = new Main();
this.Hide();
main.Show();
MessageBox.Show("Record added!");
}
else
{
MessageBox.Show("Please fill all forms!");
}
}