/**
 * This class is generated by jOOQ
 */
package classes.routines;


import classes.Public;

import java.sql.Date;

import javax.annotation.Generated;

import org.jooq.Parameter;
import org.jooq.impl.AbstractRoutine;


/**
 * This class is generated by jOOQ.
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.6"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class AddPerson extends AbstractRoutine<java.lang.Void> {

    private static final long serialVersionUID = 938891496;

    /**
     * The parameter <code>public.add_person.last_name</code>.
     */
    public static final Parameter<String> LAST_NAME = createParameter("last_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.first_name</code>.
     */
    public static final Parameter<String> FIRST_NAME = createParameter("first_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.second_name</code>.
     */
    public static final Parameter<String> SECOND_NAME = createParameter("second_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.date_of_birth</code>.
     */
    public static final Parameter<Date> DATE_OF_BIRTH = createParameter("date_of_birth", org.jooq.impl.SQLDataType.DATE, false, false);

    /**
     * The parameter <code>public.add_person.sex</code>.
     */
    public static final Parameter<String> SEX = createParameter("sex", org.jooq.impl.SQLDataType.CHAR, false, false);

    /**
     * The parameter <code>public.add_person.place_of_birth</code>.
     */
    public static final Parameter<String> PLACE_OF_BIRTH = createParameter("place_of_birth", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.address</code>.
     */
    public static final Parameter<String> ADDRESS = createParameter("address", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.phone</code>.
     */
    public static final Parameter<String> PHONE = createParameter("phone", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.photo</code>.
     */
    public static final Parameter<byte[]> PHOTO = createParameter("photo", org.jooq.impl.SQLDataType.BLOB, false, false);

    /**
     * The parameter <code>public.add_person.passport_serial</code>.
     */
    public static final Parameter<Integer> PASSPORT_SERIAL = createParameter("passport_serial", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.add_person.passport_id</code>.
     */
    public static final Parameter<Integer> PASSPORT_ID = createParameter("passport_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.add_person.timetable</code>.
     */
    public static final Parameter<String[]> TIMETABLE = createParameter("timetable", org.jooq.impl.SQLDataType.CHAR.getArrayDataType(), false, false);

    /**
     * The parameter <code>public.add_person.position_name</code>.
     */
    public static final Parameter<String> POSITION_NAME = createParameter("position_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.add_person.person_id</code>.
     */
    public static final Parameter<Integer> PERSON_ID = createParameter("person_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.add_person.sched_id</code>.
     */
    public static final Parameter<Integer> SCHED_ID = createParameter("sched_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * Create a new routine call instance
     */
    public AddPerson() {
        super("add_person", Public.PUBLIC);

        addInParameter(LAST_NAME);
        addInParameter(FIRST_NAME);
        addInParameter(SECOND_NAME);
        addInParameter(DATE_OF_BIRTH);
        addInParameter(SEX);
        addInParameter(PLACE_OF_BIRTH);
        addInParameter(ADDRESS);
        addInParameter(PHONE);
        addInParameter(PHOTO);
        addInParameter(PASSPORT_SERIAL);
        addInParameter(PASSPORT_ID);
        addInParameter(TIMETABLE);
        addInParameter(POSITION_NAME);
        addOutParameter(PERSON_ID);
        addOutParameter(SCHED_ID);
    }

    /**
     * Set the <code>last_name</code> parameter IN value to the routine
     */
    public void setLastName(String value) {
        setValue(LAST_NAME, value);
    }

    /**
     * Set the <code>first_name</code> parameter IN value to the routine
     */
    public void setFirstName(String value) {
        setValue(FIRST_NAME, value);
    }

    /**
     * Set the <code>second_name</code> parameter IN value to the routine
     */
    public void setSecondName(String value) {
        setValue(SECOND_NAME, value);
    }

    /**
     * Set the <code>date_of_birth</code> parameter IN value to the routine
     */
    public void setDateOfBirth(Date value) {
        setValue(DATE_OF_BIRTH, value);
    }

    /**
     * Set the <code>sex</code> parameter IN value to the routine
     */
    public void setSex(String value) {
        setValue(SEX, value);
    }

    /**
     * Set the <code>place_of_birth</code> parameter IN value to the routine
     */
    public void setPlaceOfBirth(String value) {
        setValue(PLACE_OF_BIRTH, value);
    }

    /**
     * Set the <code>address</code> parameter IN value to the routine
     */
    public void setAddress(String value) {
        setValue(ADDRESS, value);
    }

    /**
     * Set the <code>phone</code> parameter IN value to the routine
     */
    public void setPhone(String value) {
        setValue(PHONE, value);
    }

    /**
     * Set the <code>photo</code> parameter IN value to the routine
     */
    public void setPhoto(byte[] value) {
        setValue(PHOTO, value);
    }

    /**
     * Set the <code>passport_serial</code> parameter IN value to the routine
     */
    public void setPassportSerial(Integer value) {
        setValue(PASSPORT_SERIAL, value);
    }

    /**
     * Set the <code>passport_id</code> parameter IN value to the routine
     */
    public void setPassportId(Integer value) {
        setValue(PASSPORT_ID, value);
    }

    /**
     * Set the <code>timetable</code> parameter IN value to the routine
     */
    public void setTimetable(String[] value) {
        setValue(TIMETABLE, value);
    }

    /**
     * Set the <code>position_name</code> parameter IN value to the routine
     */
    public void setPositionName(String value) {
        setValue(POSITION_NAME, value);
    }

    /**
     * Get the <code>person_id</code> parameter OUT value from the routine
     */
    public Integer getPersonId() {
        return get(PERSON_ID);
    }

    /**
     * Get the <code>sched_id</code> parameter OUT value from the routine
     */
    public Integer getSchedId() {
        return get(SCHED_ID);
    }
}