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