package th.co.muangthai.endrprint.dao.serviceInterface;

import th.co.muangthai.endrprint.model.bean.form.data.PrinterDataTxtForm;
import th.co.muangthai.endrprint.model.bean.form.data.PrintingDataForm;
import th.co.muangthai.endrprint.model.bean.form.master.EndrProvincialForm;
import th.co.muangthai.endrprint.model.bean.form.master.EndrUserLoginForm;
import th.co.muangthai.endrprint.model.bean.form.master.PrinterForm;
import th.co.muangthai.endrprint.model.bean.form.master.TeamForm;
import th.co.muangthai.endrprint.model.bean.tmp.EndrTmpDataPrintBean;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * Information management Job CommonService Interface
 */
public interface CommonServiceInterface {

    /**
     * Check Connect Database
     * @return Boolean Result
     */
    public boolean chkConnectDB();

    /**
     * Update Table
     * @param obj -Data Object
     * @return Boolean Result
     */
    public boolean updateTable(Object obj);

    /**
     * Update Table
     * @param obj -Data Object
     * @param obj2 -Data Object
     * @param obj3 -Data Object
     * @param obj4 -Data Object
     * @param obj5 -Data Object
     * @return Boolean Result
     */
    public boolean updateTable(Object obj,Object obj2,Object obj3,Object obj4,Object obj5);

    /**
     * Search Class By Primary key
     * @param obj -Data Object
     * @param pk -Primary key
     * @return Object Result
     */
    public Object searchClassByPK(Object obj , BigDecimal pk) ;

    /**
     * Search Class By Primary key BigDecimal
     * @param obj -Data Object
     * @param pk -Primary key
     * @return Object Result
     */
    public Object searchClassByPKBigDecimal(Object obj , BigDecimal pk) ;

    /**
     * Search Class By Primary key
     * @param obj -Data Object
     * @param pk -Primary key
     * @return Object Result
     */
    public Object searchClassByPK(Object obj , String pk) ;

    /**
     * Search user login by package
     * @param userId - userId
     * @param passWord - password
     * @return EndrUserLoginForm - data
     */
    public EndrUserLoginForm searchUserLoginBeanByUserId(String userId,String passWord);

    /**
     * Search ENDR data print
     * @param dataForm - PrintingDataForm
     * @return - List of PrintingDataForm
     */
    public List<PrintingDataForm> searchPrintingDataFormPkg(PrintingDataForm dataForm);

    /**
     * Search master team by package
     * @param userId - userId
     * @return List of TeamForm
     */
    public List<TeamForm> searchTeamFormPkg(String userId);

    /**
     * Search master printer by package
     * @param userId - userId
     * @return List of PrinterForm
     */
    public List<PrinterForm> searchPrinterFormPkg(String userId);

    /**
     * Insert/Save ENDR print data into temp table by package
     * @param lstEndrTmpDataPrintBean - list of ENDR print data
     * @return boolean
     */
    public boolean insertEndrTmpDataPrint(List<EndrTmpDataPrintBean> lstEndrTmpDataPrintBean);

    /**
     * Search ENDR print data by package
     * @param sProcessID - processId
     * @param sType - 0 = first printing, 1 = reprint
     * @return List of PrinterDataTxtForm
     */
    public List<PrinterDataTxtForm> searchPrinterDataTxtFormPkg(String sProcessID , BigDecimal sType);

    /**
     * Update ENDR print data to finish by package
     * @param sProcessID - processId
     * @param sType - 0 = first printing, 1 = reprint
     * @return boolean
     */
    public boolean updateFinishFtp(String sProcessID , BigDecimal sType);

    /**
     * Update ENDR print data to reject by package
     * @param sProcessID - processId
     * @param sType - 0 = first printing, 1 = reject
     * @return boolean
     */
    public boolean updateReject(String sProcessID , BigDecimal sType);

    /**
     * Search data path file
     * @return Map Result
     */
    public Map getPathFile();

    public Object[] searchTxtSql(String sql);

    public int executeTxtSql(String sql);

    public boolean executeTxtSqlUpdatePkg(String sql);

    public Object[] searchTxtSqlEdas(String sql);

    /**
     * Search master provincial by package
     * @param userId - userId
     * @return object of EndrProvincialForm
     */
    public EndrProvincialForm searchProvincialFormPkg(String userId);

    /**
     * Search master provincial by package
     * @param provincial - provincial
     * @return boolean
     */
    public boolean isProvincialFormPkg(EndrProvincialForm provincial);

    /**
     * Search master team by package
     * @param userId - userId
     * @return List of TeamForm
     */
    public List<TeamForm>searchProvincialTeamFormPkg(String userId);

    /**
     * Search master printer by package
     * @param userId - userId
     * @return List of PrinterForm
     */
    public List<PrinterForm> searchProvincialPrinterFormPkg(String userId);

    /**
     * Search userId printer by package
     * @param userId - userId
     * @param firstname - firstname
     * @param lastname - lastname
     * @param operId - operId
     * @return List of EndrUserLoginForm -data
     */
    public List<EndrUserLoginForm> searchLstUserLoginBeanFormPkg(String userId,String firstname,String lastname,String operId);
}