private void DoAddEmployeeMovement(int employeeNo, int inOut, DateTime movementDateTime)
{
if ((inOut != -1) && (inOut != 1))
{
throw new UserException("InOut must be -1 or 1");
}
_dataConnection.ExecSql(
"insert into EMP_MOVEMENTS_FOR_EDIT" + Environment.NewLine +
"(" + Environment.NewLine +
" EMP_MOVEMENT_CODE," + Environment.NewLine +
" EMPLOYEE_CODE," + Environment.NewLine +
" IN_OUT," + Environment.NewLine +
" EMP_MOVEMENT_DATE," + Environment.NewLine +
" EMP_MOVEMENT_TIME," + Environment.NewLine +
" CREATE_EMPLOYEE_CODE," + Environment.NewLine +
" CREATE_DATE," + Environment.NewLine +
" CREATE_TIME" + Environment.NewLine +
")" + Environment.NewLine +
"values" + Environment.NewLine +
"(" + Environment.NewLine +
" seq_EMP_MOVEMENTS.NextVal," + Environment.NewLine +
" ( select" + Environment.NewLine +
" e.EMPLOYEE_CODE" + Environment.NewLine +
" from" + Environment.NewLine +
" COMPANIES c," + Environment.NewLine +
" EMPLOYEES e" + Environment.NewLine +
" where" + Environment.NewLine +
" (c.COMPANY_NO = :EMPLOYEE_NO) and" + Environment.NewLine +
" (c.COMPANY_CODE = e.COMPANY_CODE)" + Environment.NewLine +
" )," + Environment.NewLine +
" :IN_OUT," + Environment.NewLine +
" Trunc(:EMP_MOVEMENT_DATE_TIME)," + Environment.NewLine +
" TimeOf(:EMP_MOVEMENT_DATE_TIME)," + Environment.NewLine +
" LoginContext.UserCode," + Environment.NewLine +
" ContextDate," + Environment.NewLine +
" ContextTime" + Environment.NewLine +
")",
new SqlDataParameter("EMPLOYEE_NO", employeeNo),
new SqlDataParameter("IN_OUT", inOut),
new SqlDataParameter("EMP_MOVEMENT_DATE_TIME", movementDateTime));
}
