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


import classes.routines.AddPerson;
import classes.routines.AddPosition;
import classes.routines.AddPositionSalary;
import classes.routines.AddProduct1;
import classes.routines.AddProduct2;
import classes.routines.AddProductAmount;
import classes.routines.AddProductPrice;
import classes.routines.AddProductType;
import classes.routines.AddSellLog;
import classes.routines.AddShop;
import classes.routines.DeletePerson;
import classes.routines.Test;
import classes.routines.TfAddLog;
import classes.routines.TfAddPerson;
import classes.routines.TfAddPosition;
import classes.routines.TfAddProduct;
import classes.routines.TfAddProductType;
import classes.routines.TfAddScheduleId;
import classes.routines.TfAddShop;
import classes.routines.TfUpdateLog;
import classes.routines.TfUpdatePerson;
import classes.routines.TfUpdatePositionSalary;
import classes.routines.TfUpdateProductPrice;
import classes.routines.UpdatePerson;
import classes.routines.UpdatePosition;
import classes.routines.UpdatePositionSalary;
import classes.routines.UpdateProduct;
import classes.routines.UpdateProductAmount;
import classes.routines.UpdateProductPrice;
import classes.routines.UpdateProductType;
import classes.routines.UpdateSellLog;
import classes.routines.UpdateShop;

import java.math.BigDecimal;
import java.sql.Date;

import javax.annotation.Generated;

import org.jooq.Configuration;
import org.jooq.Field;


/**
 * Convenience access to all stored procedures and functions in public
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.6"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class Routines {

    /**
     * Call <code>public.add_person</code>
     */
    public static AddPerson addPerson(Configuration configuration, String lastName, String firstName, String secondName, Date dateOfBirth, String sex, String placeOfBirth, String address, String phone, byte[] photo, Integer passportSerial, Integer passportId, String[] timetable, String positionName) {
        AddPerson p = new AddPerson();
        p.setLastName(lastName);
        p.setFirstName(firstName);
        p.setSecondName(secondName);
        p.setDateOfBirth(dateOfBirth);
        p.setSex(sex);
        p.setPlaceOfBirth(placeOfBirth);
        p.setAddress(address);
        p.setPhone(phone);
        p.setPhoto(photo);
        p.setPassportSerial(passportSerial);
        p.setPassportId(passportId);
        p.setTimetable(timetable);
        p.setPositionName(positionName);

        p.execute(configuration);
        return p;
    }

    /**
     * Call <code>public.add_position</code>
     */
    public static Integer addPosition(Configuration configuration, String name, String description) {
        AddPosition f = new AddPosition();
        f.setName_(name);
        f.setDescription(description);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_position</code> as a field.
     */
    public static Field<Integer> addPosition(String name, String description) {
        AddPosition f = new AddPosition();
        f.setName_(name);
        f.setDescription(description);

        return f.asField();
    }

    /**
     * Get <code>public.add_position</code> as a field.
     */
    public static Field<Integer> addPosition(Field<String> name, Field<String> description) {
        AddPosition f = new AddPosition();
        f.setName_(name);
        f.setDescription(description);

        return f.asField();
    }

    /**
     * Call <code>public.add_position_salary</code>
     */
    public static Integer addPositionSalary(Configuration configuration, Integer posId, Integer shId, BigDecimal salary) {
        AddPositionSalary f = new AddPositionSalary();
        f.setPosId(posId);
        f.setShId(shId);
        f.setSalary(salary);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_position_salary</code> as a field.
     */
    public static Field<Integer> addPositionSalary(Integer posId, Integer shId, BigDecimal salary) {
        AddPositionSalary f = new AddPositionSalary();
        f.setPosId(posId);
        f.setShId(shId);
        f.setSalary(salary);

        return f.asField();
    }

    /**
     * Get <code>public.add_position_salary</code> as a field.
     */
    public static Field<Integer> addPositionSalary(Field<Integer> posId, Field<Integer> shId, Field<BigDecimal> salary) {
        AddPositionSalary f = new AddPositionSalary();
        f.setPosId(posId);
        f.setShId(shId);
        f.setSalary(salary);

        return f.asField();
    }

    /**
     * Call <code>public.add_product</code>
     */
    public static Integer addProduct1(Configuration configuration, String name, String typeName) {
        AddProduct1 f = new AddProduct1();
        f.setName_(name);
        f.setTypeName(typeName);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_product</code> as a field.
     */
    public static Field<Integer> addProduct1(String name, String typeName) {
        AddProduct1 f = new AddProduct1();
        f.setName_(name);
        f.setTypeName(typeName);

        return f.asField();
    }

    /**
     * Get <code>public.add_product</code> as a field.
     */
    public static Field<Integer> addProduct1(Field<String> name, Field<String> typeName) {
        AddProduct1 f = new AddProduct1();
        f.setName_(name);
        f.setTypeName(typeName);

        return f.asField();
    }

    /**
     * Call <code>public.add_product</code>
     */
    public static Integer addProduct2(Configuration configuration, String name, Integer typeId) {
        AddProduct2 f = new AddProduct2();
        f.setName_(name);
        f.setTypeId(typeId);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_product</code> as a field.
     */
    public static Field<Integer> addProduct2(String name, Integer typeId) {
        AddProduct2 f = new AddProduct2();
        f.setName_(name);
        f.setTypeId(typeId);

        return f.asField();
    }

    /**
     * Get <code>public.add_product</code> as a field.
     */
    public static Field<Integer> addProduct2(Field<String> name, Field<Integer> typeId) {
        AddProduct2 f = new AddProduct2();
        f.setName_(name);
        f.setTypeId(typeId);

        return f.asField();
    }

    /**
     * Call <code>public.add_product_amount</code>
     */
    public static Integer addProductAmount(Configuration configuration, Integer prId, Integer shId, Integer amount) {
        AddProductAmount f = new AddProductAmount();
        f.setPrId(prId);
        f.setShId(shId);
        f.setAmount(amount);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_product_amount</code> as a field.
     */
    public static Field<Integer> addProductAmount(Integer prId, Integer shId, Integer amount) {
        AddProductAmount f = new AddProductAmount();
        f.setPrId(prId);
        f.setShId(shId);
        f.setAmount(amount);

        return f.asField();
    }

    /**
     * Get <code>public.add_product_amount</code> as a field.
     */
    public static Field<Integer> addProductAmount(Field<Integer> prId, Field<Integer> shId, Field<Integer> amount) {
        AddProductAmount f = new AddProductAmount();
        f.setPrId(prId);
        f.setShId(shId);
        f.setAmount(amount);

        return f.asField();
    }

    /**
     * Call <code>public.add_product_price</code>
     */
    public static Integer addProductPrice(Configuration configuration, Integer prId, Integer shId, BigDecimal price) {
        AddProductPrice f = new AddProductPrice();
        f.setPrId(prId);
        f.setShId(shId);
        f.setPrice(price);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_product_price</code> as a field.
     */
    public static Field<Integer> addProductPrice(Integer prId, Integer shId, BigDecimal price) {
        AddProductPrice f = new AddProductPrice();
        f.setPrId(prId);
        f.setShId(shId);
        f.setPrice(price);

        return f.asField();
    }

    /**
     * Get <code>public.add_product_price</code> as a field.
     */
    public static Field<Integer> addProductPrice(Field<Integer> prId, Field<Integer> shId, Field<BigDecimal> price) {
        AddProductPrice f = new AddProductPrice();
        f.setPrId(prId);
        f.setShId(shId);
        f.setPrice(price);

        return f.asField();
    }

    /**
     * Call <code>public.add_product_type</code>
     */
    public static Integer addProductType(Configuration configuration, String title, String description) {
        AddProductType f = new AddProductType();
        f.setTitle(title);
        f.setDescription(description);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_product_type</code> as a field.
     */
    public static Field<Integer> addProductType(String title, String description) {
        AddProductType f = new AddProductType();
        f.setTitle(title);
        f.setDescription(description);

        return f.asField();
    }

    /**
     * Get <code>public.add_product_type</code> as a field.
     */
    public static Field<Integer> addProductType(Field<String> title, Field<String> description) {
        AddProductType f = new AddProductType();
        f.setTitle(title);
        f.setDescription(description);

        return f.asField();
    }

    /**
     * Call <code>public.add_sell_log</code>
     */
    public static Integer addSellLog(Configuration configuration, Integer pId, Integer shId, Integer inAmount, Date date) {
        AddSellLog f = new AddSellLog();
        f.setPId(pId);
        f.setShId(shId);
        f.setInAmount(inAmount);
        f.setDate(date);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_sell_log</code> as a field.
     */
    public static Field<Integer> addSellLog(Integer pId, Integer shId, Integer inAmount, Date date) {
        AddSellLog f = new AddSellLog();
        f.setPId(pId);
        f.setShId(shId);
        f.setInAmount(inAmount);
        f.setDate(date);

        return f.asField();
    }

    /**
     * Get <code>public.add_sell_log</code> as a field.
     */
    public static Field<Integer> addSellLog(Field<Integer> pId, Field<Integer> shId, Field<Integer> inAmount, Field<Date> date) {
        AddSellLog f = new AddSellLog();
        f.setPId(pId);
        f.setShId(shId);
        f.setInAmount(inAmount);
        f.setDate(date);

        return f.asField();
    }

    /**
     * Call <code>public.add_shop</code>
     */
    public static Integer addShop(Configuration configuration, String street) {
        AddShop f = new AddShop();
        f.setStreet(street);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.add_shop</code> as a field.
     */
    public static Field<Integer> addShop(String street) {
        AddShop f = new AddShop();
        f.setStreet(street);

        return f.asField();
    }

    /**
     * Get <code>public.add_shop</code> as a field.
     */
    public static Field<Integer> addShop(Field<String> street) {
        AddShop f = new AddShop();
        f.setStreet(street);

        return f.asField();
    }

    /**
     * Call <code>public.delete_person</code>
     */
    public static void deletePerson(Configuration configuration, Integer pId) {
        DeletePerson p = new DeletePerson();
        p.setPId(pId);

        p.execute(configuration);
    }

    /**
     * Call <code>public.test</code>
     */
    public static Integer test(Configuration configuration, String one) {
        Test f = new Test();
        f.setOne(one);

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.test</code> as a field.
     */
    public static Field<Integer> test(String one) {
        Test f = new Test();
        f.setOne(one);

        return f.asField();
    }

    /**
     * Get <code>public.test</code> as a field.
     */
    public static Field<Integer> test(Field<String> one) {
        Test f = new Test();
        f.setOne(one);

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_log</code>
     */
    public static Object tfAddLog(Configuration configuration) {
        TfAddLog f = new TfAddLog();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_log</code> as a field.
     */
    public static Field<Object> tfAddLog() {
        TfAddLog f = new TfAddLog();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_person</code>
     */
    public static Object tfAddPerson(Configuration configuration) {
        TfAddPerson f = new TfAddPerson();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_person</code> as a field.
     */
    public static Field<Object> tfAddPerson() {
        TfAddPerson f = new TfAddPerson();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_position</code>
     */
    public static Object tfAddPosition(Configuration configuration) {
        TfAddPosition f = new TfAddPosition();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_position</code> as a field.
     */
    public static Field<Object> tfAddPosition() {
        TfAddPosition f = new TfAddPosition();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_product</code>
     */
    public static Object tfAddProduct(Configuration configuration) {
        TfAddProduct f = new TfAddProduct();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_product</code> as a field.
     */
    public static Field<Object> tfAddProduct() {
        TfAddProduct f = new TfAddProduct();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_product_type</code>
     */
    public static Object tfAddProductType(Configuration configuration) {
        TfAddProductType f = new TfAddProductType();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_product_type</code> as a field.
     */
    public static Field<Object> tfAddProductType() {
        TfAddProductType f = new TfAddProductType();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_schedule_id</code>
     */
    public static Object tfAddScheduleId(Configuration configuration) {
        TfAddScheduleId f = new TfAddScheduleId();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_schedule_id</code> as a field.
     */
    public static Field<Object> tfAddScheduleId() {
        TfAddScheduleId f = new TfAddScheduleId();

        return f.asField();
    }

    /**
     * Call <code>public.tf_add_shop</code>
     */
    public static Object tfAddShop(Configuration configuration) {
        TfAddShop f = new TfAddShop();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_add_shop</code> as a field.
     */
    public static Field<Object> tfAddShop() {
        TfAddShop f = new TfAddShop();

        return f.asField();
    }

    /**
     * Call <code>public.tf_update_log</code>
     */
    public static Object tfUpdateLog(Configuration configuration) {
        TfUpdateLog f = new TfUpdateLog();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_update_log</code> as a field.
     */
    public static Field<Object> tfUpdateLog() {
        TfUpdateLog f = new TfUpdateLog();

        return f.asField();
    }

    /**
     * Call <code>public.tf_update_person</code>
     */
    public static Object tfUpdatePerson(Configuration configuration) {
        TfUpdatePerson f = new TfUpdatePerson();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_update_person</code> as a field.
     */
    public static Field<Object> tfUpdatePerson() {
        TfUpdatePerson f = new TfUpdatePerson();

        return f.asField();
    }

    /**
     * Call <code>public.tf_update_position_salary</code>
     */
    public static Object tfUpdatePositionSalary(Configuration configuration) {
        TfUpdatePositionSalary f = new TfUpdatePositionSalary();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_update_position_salary</code> as a field.
     */
    public static Field<Object> tfUpdatePositionSalary() {
        TfUpdatePositionSalary f = new TfUpdatePositionSalary();

        return f.asField();
    }

    /**
     * Call <code>public.tf_update_product_price</code>
     */
    public static Object tfUpdateProductPrice(Configuration configuration) {
        TfUpdateProductPrice f = new TfUpdateProductPrice();

        f.execute(configuration);
        return f.getReturnValue();
    }

    /**
     * Get <code>public.tf_update_product_price</code> as a field.
     */
    public static Field<Object> tfUpdateProductPrice() {
        TfUpdateProductPrice f = new TfUpdateProductPrice();

        return f.asField();
    }

    /**
     * Call <code>public.update_person</code>
     */
    public static void updatePerson(Configuration configuration, Integer pId, String lastname, String firstname, String secondname, Date dateofbirth, String inSex, String placeofbirth, String inAddress, String inPhone, byte[] inPhoto, Integer passportSerial, Integer passportId, String[] inTimetable, String inPositionName) {
        UpdatePerson p = new UpdatePerson();
        p.setPId(pId);
        p.setLastname(lastname);
        p.setFirstname(firstname);
        p.setSecondname(secondname);
        p.setDateofbirth(dateofbirth);
        p.setInSex(inSex);
        p.setPlaceofbirth(placeofbirth);
        p.setInAddress(inAddress);
        p.setInPhone(inPhone);
        p.setInPhoto(inPhoto);
        p.setPassportSerial(passportSerial);
        p.setPassportId(passportId);
        p.setInTimetable(inTimetable);
        p.setInPositionName(inPositionName);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_position</code>
     */
    public static void updatePosition(Configuration configuration, Integer posId, String name, String description) {
        UpdatePosition p = new UpdatePosition();
        p.setPosId(posId);
        p.setName_(name);
        p.setDescription(description);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_position_salary</code>
     */
    public static void updatePositionSalary(Configuration configuration, Integer posId, Integer shId, BigDecimal inSalary) {
        UpdatePositionSalary p = new UpdatePositionSalary();
        p.setPosId(posId);
        p.setShId(shId);
        p.setInSalary(inSalary);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_product</code>
     */
    public static void updateProduct(Configuration configuration, Integer pId, String name, Integer typeId) {
        UpdateProduct p = new UpdateProduct();
        p.setPId(pId);
        p.setName_(name);
        p.setTypeId(typeId);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_product_amount</code>
     */
    public static void updateProductAmount(Configuration configuration, Integer prId, Integer shId, Integer amount) {
        UpdateProductAmount p = new UpdateProductAmount();
        p.setPrId(prId);
        p.setShId(shId);
        p.setAmount(amount);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_product_price</code>
     */
    public static void updateProductPrice(Configuration configuration, Integer prId, Integer shId, Integer amount) {
        UpdateProductPrice p = new UpdateProductPrice();
        p.setPrId(prId);
        p.setShId(shId);
        p.setAmount(amount);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_product_type</code>
     */
    public static void updateProductType(Configuration configuration, Integer tId, String title, String description) {
        UpdateProductType p = new UpdateProductType();
        p.setTId(tId);
        p.setTitle(title);
        p.setDescription(description);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_sell_log</code>
     */
    public static void updateSellLog(Configuration configuration, Integer lId, Integer pId, Integer shId, Integer inAmount, Date inDate) {
        UpdateSellLog p = new UpdateSellLog();
        p.setLId(lId);
        p.setPId(pId);
        p.setShId(shId);
        p.setInAmount(inAmount);
        p.setInDate(inDate);

        p.execute(configuration);
    }

    /**
     * Call <code>public.update_shop</code>
     */
    public static void updateShop(Configuration configuration, Integer shId, String street) {
        UpdateShop p = new UpdateShop();
        p.setShId(shId);
        p.setStreet(street);

        p.execute(configuration);
    }
}