private void btn_add_Click(object sender, EventArgs e) { DialogResult yesno = MessageBox.Show("Add new employee?", "ADD", MessageBoxButtons.YesNo); if (yesno == DialogResult.Yes) { try { myconn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = @"INSERT INTO Emp_Overview(Emp_ID, Last_Name, Mid_Name, Suffix_Name, First_Name, Emp_Status, Date_Hired, Contract_Exp, Emp_Position, Emp_Dept) VALUES (@id, @lname, @mname, @suffix, @fname, @empstatus, @datehired, @contract, @pos, @dept)"; cmd.Parameters.AddWithValue("@id", tb_id.Text); cmd.Parameters.AddWithValue("@lname", tb_lname.Text); cmd.Parameters.AddWithValue("@mname", tb_mname.Text); cmd.Parameters.AddWithValue("@suffix", tb_suffix.Text); cmd.Parameters.AddWithValue("@fname", tb_fname.Text); cmd.Parameters.AddWithValue("@empstatus", cb_status.Text); cmd.Parameters.AddWithValue("@datehired", date_hired.Value.ToShortDateString()); cmd.Parameters.AddWithValue("@contract", datecontract); cmd.Parameters.AddWithValue("@pos", tb_position.Text); cmd.Parameters.AddWithValue("@dept", cb_dept.Text); cmd.Connection = myconn; cmd.ExecuteNonQuery(); MessageBox.Show("Record Added Successfully"); User_Control.UC_Employee ue = new User_Control.UC_Employee(); ue.loademployees(); myconn.Close(); audittrail("Added Employee No. " + tb_id.Text); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); myconn.Close(); } } }
private void setstatus() { try { myconn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = @"UPDATE Emp_Overview set Emp_Status = @status where ID=@id"; cmd.Parameters.AddWithValue("@status", "Inactive"); cmd.Parameters.AddWithValue("@id", empsystemid); cmd.Connection = myconn; cmd.ExecuteNonQuery(); MessageBox.Show("Record Removed Successfully"); User_Control.UC_Employee ue = new User_Control.UC_Employee(); ue.loademployees(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } myconn.Close(); }