public void InsertEmployee(E_Employees _employee)
{
SqlCommand cmd = new SqlCommand("SP_create_employees", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
cmd.Parameters.AddWithValue("@name_employee", _employee.NameEmployee);
cmd.Parameters.AddWithValue("@last_name", _employee.LastName);
cmd.Parameters.AddWithValue("@mothers_last_name", _employee.MothersLastName);
cmd.Parameters.AddWithValue("@dni", _employee.Dni);
cmd.Parameters.AddWithValue("@email", _employee.Email);
cmd.Parameters.AddWithValue("@sex", _employee.Sex);
cmd.Parameters.AddWithValue("@phone", _employee.Phone);
cmd.Parameters.AddWithValue("@civil_status", _employee.CivilStatus);
cmd.Parameters.AddWithValue("@address_employee", _employee.AddressEmployee);
cmd.Parameters.AddWithValue("@date_of_admission", _employee.DateOfAdmission);
cmd.Parameters.AddWithValue("@id_department", _employee.IdDepartment);
cmd.ExecuteNonQuery();
connection.Close();
}
public void UpdateEmployee(E_Employees _employees)
{
objEmployee.UpdateEmployee(_employees);
}
public void InsertEmployee(E_Employees _employees)
{
objEmployee.InsertEmployee(_employees);
}
