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();
}
