Dynamics Community Forum Thread Details

I've written some c# code to look up customers by name because out customer id's are all 8 digit numeric numbers now.

I added custom lookup buttons to some of the forms...My problem is I only get back the customer number and the customer name and the rest never populates.

Any idea why? I'll post my code here.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Dexterity.Bridge;
using Microsoft.Dexterity.Applications;
using Microsoft.Dexterity.Applications.DynamicsDictionary;
using System.Windows.Forms;

namespace DynamicsGPAddin
{
    public class GPAddIn : IDexterityAddIn
    {
        // IDexterityAddIn interface
        //RmCustomerInquiryForm rmCustomerInquiryForm = Dynamics.Forms.RmCustomerInquiry;
        public static Boolean ReturnToLookup = false;
        public void Initialize()
        {
            //this.rmCustomerInquiryForm.OpenAfterOriginal  = RmCustomerInquiryForm_OpenAfterOriginal;
            DynamicsGpModified.Forms.SopEntry.SopEntry.CustomerName.LeaveAfterOriginal  = SOPEntry_CustomerName_LeaveAfterOriginal;
            DynamicsGpModified.Forms.SopEntry.SopEntry.LocalLookupButtonCn.ClickAfterOriginal  = SOPEntry_LocalLookupButtonCn_ClickAfterOriginal;

            DynamicsGpModified.Forms.RmSalesEntry.RmSalesEntry.CustomerName.LeaveAfterOriginal  = RMSalesEntry_CustomerName_LeaveAfterOriginal;
            DynamicsGpModified.Forms.RmSalesEntry.RmSalesEntry.LocalPushButtonM147.ClickAfterOriginal  = RmSalesEntry_LocalPushButtonM147_ClickAfterOriginal;

            DynamicsGpModified.Forms.RmCashReceipts.RmCashReceipts.CustomerName.LeaveAfterOriginal  = RMCashReceipts_CustomerName_LeaveAfterOriginal;
            DynamicsGpModified.Forms.RmCashReceipts.RmCashReceipts.LocalPushButtonM83.ClickAfterOriginal  = RmCashReceipts_LocalPushButtonM83_ClickAfterOriginal;

            DynamicsGpModified.Forms.RmTransactionInquiry.RmTransactionInquiry.CustomerName.LeaveAfterOriginal  = RMTransactionInquiry_CustomerName_LeaveAfterOriginal;
            DynamicsGpModified.Forms.RmTransactionInquiry.RmTransactionInquiry.LocalPushButtonM18.ClickAfterOriginal  = RMTransactionInquiry_LocalPushButtonM18_ClickAfterOriginal;

            DynamicsGpModified.Forms.RmCustomerMaintenance.RmCustomerMaintenance.CustomerName.LeaveAfterOriginal  = RMCustomerMaintenance_CustomerName_LeaveAfterOriginal;
            DynamicsGpModified.Forms.RmCustomerMaintenance.RmCustomerMaintenance.LocalPushButtonM109.ClickAfterOriginal  = RMCustomerMaintenance_LocalPushButtonM109_ClickAfterOriginal;

            Microsoft.Dexterity.Applications.SmartListDictionary.CustomerLookupForm custlookupform = SmartList.Forms.CustomerLookup;
            custlookupform.CustomerLookup.SelectButton.ClickBeforeOriginal  = new System.ComponentModel.CancelEventHandler(custSelectButton_ClickBeforeOriginal);
        }
        private void SOPEntry_CustomerName_LeaveAfterOriginal(object sender, EventArgs e)
        {

            //MessageBox.Show(DynamicsGpModified.Forms.SopEntry.SopEntry.CustomerName.Value);
            dynamic gpWindow = DynamicsGpModified.Forms.SopEntry.SopEntry;

            FindFirstCustByName(gpWindow);

        }
        private void SOPEntry_LocalLookupButtonCn_ClickAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.SopEntry.SopEntry;
            LaunchCustomerLookup(gpWindow);
        }
        private void RMCustomerMaintenance_LocalPushButtonM109_ClickAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmCustomerMaintenance.RmCustomerMaintenance;
            LaunchCustomerLookup(gpWindow);
        }

        private void RMCustomerMaintenance_CustomerName_LeaveAfterOriginal(object sender, EventArgs e)
        {
            //dynamic gpWindow = DynamicsGpModified.Forms.RmCustomerMaintenance.RmCustomerMaintenance;
            //FindFirstCustByName(gpWindow);
        }

        private void RMTransactionInquiry_LocalPushButtonM18_ClickAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmTransactionInquiry.RmTransactionInquiry;
            LaunchCustomerLookup(gpWindow);
        }

        private void RMTransactionInquiry_CustomerName_LeaveAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmTransactionInquiry.RmTransactionInquiry;
            FindFirstCustByName(gpWindow);
        }

        private void RmCashReceipts_LocalPushButtonM83_ClickAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmCashReceipts.RmCashReceipts;
            LaunchCustomerLookup(gpWindow);
        }

        private void RMCashReceipts_CustomerName_LeaveAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmCashReceipts.RmCashReceipts;
            FindFirstCustByName(gpWindow);
        }

        private void RMSalesEntry_CustomerName_LeaveAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmSalesEntry.RmSalesEntry;
            FindFirstCustByName(gpWindow);
        }

        private void RmSalesEntry_LocalPushButtonM147_ClickAfterOriginal(object sender, EventArgs e)
        {
            dynamic gpWindow = DynamicsGpModified.Forms.RmSalesEntry.RmSalesEntry;
            LaunchCustomerLookup(gpWindow);
        }

        private static void FindFirstCustByName(dynamic gpWindow)
        {
            RmCustomerMstrTable CustomerMasterTable = Dynamics.Tables.RmCustomerMstr;
            //CustomerMasterTable.Key = 2;
            string custName = gpWindow.CustomerName.Value;
            if (custName != "")
            {
                TableError err = TableError.NoError;
                try
                {
                    err = CustomerMasterTable.GetFirst();
                    while (err == TableError.NoError)
                    {

                        if (CustomerMasterTable.CustomerName.Value.StartsWith(custName, StringComparison.CurrentCultureIgnoreCase))
                        {
                            gpWindow.CustomerName.Value = CustomerMasterTable.CustomerName;
                            gpWindow.CustomerNumber.Value = CustomerMasterTable.CustomerNumber;
                            break;
                        }
                        err = CustomerMasterTable.GetNext();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK);
                }
                finally
                {
                    CustomerMasterTable.Close();
                }
            }
        }



        private void LaunchCustomerLookup(dynamic gpWindow)
        {
            CustomerLookupForm customerlookup = Dynamics.Forms.CustomerLookup;
            //Open the lookup form first.
            customerlookup.Open();
            //Call the Initialize procedure to set the window fields and fill the window.
            //For parameter information, reference the lookup.rtf installed with the GP SDK.  All
            //paramter information is listed.  
            customerlookup.Procedures.Initialize.Invoke(2, 0, "", gpWindow.CustomerName.Value, "", "", "", "");
            
            //Set the ReturnToLookup flag to true so we know we called the lookup window.
            DynamicsGPAddin.GPAddIn.ReturnToLookup = true;
            gpWindowThatLaunchedCustomerLookup = gpWindow;
        }
        dynamic gpWindowThatLaunchedCustomerLookup;
        void custSelectButton_ClickBeforeOriginal(object sender, System.ComponentModel.CancelEventArgs e)
        {
            //Check the ReturnToLookup flag so we only run the code if the lookup
            //was called for our form.  If the lookup was called from GP, we don't
            //want to do anything. 
            if (ReturnToLookup == true)
            {
                //Pressed select button on customer lookup
                Microsoft.Dexterity.Applications.SmartListDictionary.CustomerLookupForm custlookupform = SmartList.Forms.CustomerLookup;
                //Set our window field equal to what is selected from the scrolling window.
                string custid = custlookupform.CustomerLookup.CustomerLookupScroll.CustomerNumber;
                string custName = custlookupform.CustomerLookup.CustomerLookupScroll.CustomerName;
                //Make sure the Modifiers on the field on the window set to Public.  
                //vstoolslookupform.CustomerNumber.Text = custid;
                gpWindowThatLaunchedCustomerLookup.CustomerNumber.Value = custid;
                gpWindowThatLaunchedCustomerLookup.RunValidate();
                


            }
        }
        

    }
}

Categories:

Microsoft Dynamics GP