MMEX Discussion Forum

Code: Select all

void mmTransDialog::updateControlsForTransType()
{
    wxStaticText* st = (wxStaticText*)FindWindow(ID_DIALOG_TRANS_STATIC_FROM);
    wxStaticText* stp = (wxStaticText*)FindWindow(ID_DIALOG_TRANS_STATIC_PAYEE);

	// If this is an edited transaction, look to see what the original transtype was
	wxString PayeeName = wxT("");
	int PayeeId = -1;
//	if (edit_)
//	{
	   mmBEGINSQL_LITE_EXCEPTION;
		
		static const char sql[] = 
        "select c.PAYEEID as PAYEEID, p.PAYEENAME as PAYEENAME from CHECKINGACCOUNT_V1 c, PAYEE_V1 p " 
		"where c.payeeid=p.payeeid and TRANSID = ? ";
		wxSQLite3Statement st = db_->PrepareStatement(sql);
        st.Bind(1, transID_);
		wxSQLite3ResultSet q1 = st.ExecuteQuery();

		//if (q1.NextRow())
			PayeeName = q1.GetString(wxT("PAYEENAME"));
			PayeeId = q1.GetInt(wxT("PAYEEID"));
		q1.Finalize();
		mmENDSQL_LITE_EXCEPTION 
//	}
	//Evaluate the new transaction type and act accordingly
     if (choiceTrans_->GetSelection() == DEF_WITHDRAWAL)
     {
		fillControls();
        st->Show(false);
        bTo_->Show(false);
        stp->SetLabel(_("Payee"));
		
		// Keep Payee info if old type was deposit or withdrawal 
		//note transTypeString will be wxT("") if new transaction (not edited)
//		if (transTypeString != wxT("Deposit") && transTypeString != wxT("Withdrawal"))
//        {
//			bPayee_->SetLabel(_("Select Payee"));
		bPayee_->SetLabel(PayeeName);
		payeeID_ = PayeeId;
//		}
        toID_    = -1;
       
        bAdvanced_->Enable(false);
        bPayee_->SetToolTip(_("Specify to whom the transaction is going to or coming from "));
     }
     else if (choiceTrans_->GetSelection() == DEF_DEPOSIT)
    {
//        payeeID_ = PayeeId;
        fillControls();
        bTo_->Show(false);
        st->Show(false);    

        stp->SetLabel(_("Payee"));
		// Keep Payee info if old type was deposit or withdrawal
		//note transTypeString will be wxT("") if new transaction (not edited)
//		if (transTypeString != wxT("Deposit") && transTypeString != wxT("Withdrawal"))
//		{
//        bPayee_->SetLabel(_("Select Payee"));
		bPayee_->SetLabel(PayeeName);
        payeeID_ = PayeeId;
//		}
        toID_    = -1;
        bAdvanced_->Enable(false);
        bPayee_->SetToolTip(_("Specify to whom the transaction is going to or coming from "));
    }
    else if (choiceTrans_->GetSelection() == DEF_TRANSFER)
    {
        bTo_->SetLabel(_("Select To Account"));
        toID_    = -1;
        
        bTo_->Show(true);
        st->Show(true);
        stp->SetLabel(_("From"));   
        bAdvanced_->Enable(true);

        wxString acctName = mmDBWrapper::getAccountName(db_, accountID_);
        bPayee_->SetLabel(acctName);
        payeeID_ = accountID_;

        bPayee_->SetToolTip(_("Specify the account from which the transfer is occurring"));
    }
}