custdialog.ui.h

/****************************************************************************
** ui.h extension file, included from the uic-generated form implementation.
**
** If you wish to add, delete or rename functions or slots use
** Qt Designer which will update this file, preserving your code. Create an
** init() function in place of a constructor, and a destroy() function in
** place of a destructor.
*****************************************************************************/

void CustDialog::init()
{
        inInit = TRUE ;
        mode = 0 ; // Read mode
        active_qa = "" ;
        activeCust = 0 ;
        custs = new QSqlCursor( "Contacts", TRUE ) ;
        setROMode( TRUE ) ;
        message->setText( "" ) ;
        canValidate() ;
        inInit = FALSE ;

}

void CustDialog::showInfo()
{
        if ( !inInit ) {
                mode = 0 ; // Read mode
                setROMode( TRUE ) ;
                int custid = customerSelector->getId( customerSelector->currentText() ) ;
                custs->setFilter( QString( "recid='%1'" ).arg( custid ) ) ;
                custs->select() ;
                if ( custs->next() ) {
                        activeCust = custid ;
                        message->setText( "" ) ;
                        contact_qa->setText( custs->value( "contact_qa").toString() ) ;
                        active_qa = contact_qa->text() ;
                        contact_name->setText( custs->value( "contact_name" ).toString() ) ;
                        address1->setText( custs->value( "address1" ).toString() ) ;
                        address2->setText( custs->value( "address2" ).toString() ) ;
                        address3->setText( custs->value( "address3" ).toString() ) ;
                        zip->setText( custs->value( "zip" ).toString() ) ;
                        city->setText( custs->value( "city" ).toString() ) ;
                        phone->setText( custs->value( "phone" ).toString() ) ;
                        fax->setText( custs->value( "fax" ).toString() ) ;
                        email->setText( custs->value( "email" ).toString() ) ;
                } else {
                        activeCust = 0 ;
                        active_qa = "" ;
                        message->setText( tr( "Database Error. Unable to get customer!" ) ) ;
                }
                custs->setFilter( "" ) ;
                canValidate() ;
        }
}


void CustDialog::custNew()
{
        custNewButton->setEnabled( FALSE ) ;
        custUpdateButton->setEnabled( FALSE ) ;
        activeCust = 0 ;
        mode = 1 ; // Create
        active_qa = "" ;
        canValidate() ;
        contact_qa->setText( custs->value( "contact_qa").toString() ) ;
        active_qa = contact_qa->text() ;
        contact_name->setText( custs->value( "contact_name" ).toString() ) ;
        address1->setText( custs->value( "address1" ).toString() ) ;
        address2->setText( custs->value( "address2" ).toString() ) ;
        address3->setText( custs->value( "address3" ).toString() ) ;
        zip->setText( custs->value( "zip" ).toString() ) ;
        city->setText( custs->value( "city" ).toString() ) ;
        phone->setText( custs->value( "phone" ).toString() ) ;
        fax->setText( custs->value( "fax" ).toString() ) ;
        email->setText( custs->value( "email" ).toString() ) ;
        setROMode( FALSE ) ;
}


void CustDialog::custUpdate()
{
        custNewButton->setEnabled( FALSE ) ;
        custUpdateButton->setEnabled( FALSE ) ;
        mode = 2 ; // Update
        setROMode( FALSE ) ;
}


void CustDialog::validate()
{
        QSqlRecord * buffer = 0 ;
        if ( mode == 1 ) {
                //create
                buffer = custs->primeInsert() ;
                buffer->setValue( "recid", SequenceGetNextValue( "Contacts" ) ) ;
                activeCust = buffer->value( "recid" ).toInt() ;
                buffer->setValue( "contact_xtype", "Customer" ) ;
                buffer->setValue( "created", QDateTime::currentDateTime() ) ;
                buffer->setValue( "active", 1 ) ;
                buffer->setValue( "lastchangedreason", "Creation" ) ;
        } else if ( mode == 2 ) {
                // Update
                buffer = custs->primeUpdate() ;
                buffer->setValue( "lastchangedreason", "Update" ) ;             
        }
        if ( mode != 0 ) {
                buffer->setValue( "contact_qa", contact_qa->text().upper() ) ;
                
                buffer->setValue( "contact_name", contact_name->text() ) ;
                buffer->setValue( "address1", address1->text() ) ;
                buffer->setValue( "address2", address2->text() ) ;
                buffer->setValue( "address3", address3->text() ) ;
                buffer->setValue( "zip", zip->text() ) ;
                buffer->setValue( "city", city->text() ) ;
                buffer->setValue( "phone", phone->text() ) ;
                buffer->setValue( "fax", fax->text() ) ;
                buffer->setValue( "email", email->text() ) ;
                if ( mode == 1 ) {
                        custs->insert() ;
                } else {
                        custs->update() ;
                }
        }
        accept() ;
}


void CustDialog::checkAbridged()
{
        QSqlCursor * srch = new QSqlCursor( "Contacts", TRUE ) ;
        if ( mode == 1 ) {
                QString want = contact_qa->text().upper().stripWhiteSpace() ;
                srch->setFilter( QString( "contact_qa='%1' AND contact_xtype='Customer'" ) ) ;
                srch->select() ;
                if ( srch->next() ) {
                        message->setText( tr( "Invalid Abridged Code. Already present in database." ) ) ;
                        active_qa = "" ;
                } else {
                        message->setText( "" ) ;
                        active_qa = want ;
                        contact_qa->setText( want ) ;
                }
                canValidate() ;
        }
}


void CustDialog::checkNotEmpty()
{
        if ( contact_name->text().stripWhiteSpace().isEmpty() ) {
                message->setText( tr( "Customer Name MUST be filled." ) ) ;
        }
        canValidate() ;
}


void CustDialog::setROMode( bool ed )
{
        if ( mode == 2 ) {
                contact_qa->setReadOnly( TRUE ) ;
        } else {
                contact_qa->setReadOnly( ed ) ;
        }
        contact_name->setReadOnly( ed ) ;
        address1->setReadOnly( ed ) ;
        address2->setReadOnly( ed ) ;
        address3->setReadOnly( ed ) ;
        zip->setReadOnly( ed ) ;
        city->setReadOnly( ed ) ;
        phone->setReadOnly( ed ) ;
        fax->setReadOnly( ed ) ;
        email->setReadOnly( ed ) ;
}


int CustDialog::selected()
{
        return activeCust ;
}


void CustDialog::canValidate()
{
        if ( active_qa.isEmpty() 
                || contact_name->text().stripWhiteSpace().isEmpty() ) {
                okButton->setEnabled( FALSE ) ;
        } else {
                okButton->setEnabled( TRUE ) ;
        }
}