Retrieving customer part numbers from NetSuite

I couldn't find any documentation on retrieving customer part numbers from NetSuite and it took an age to find what I needed.  Here's the end code for cribbing - needs tidying up but you can extract what you need to do in SuiteTalk from it:

// Find the customization id for customrecord_scm_customerpartnumber here

public String getCustomizationId(String scriptId) throws Exception
{
    CustomizationType ct = new CustomizationType();

    ct.setGetCustomizationType(GetCustomizationType.CUSTOM_RECORD_TYPE);

    // Retrieve active custom record type IDs. The includeInactives param is set to false.    GetCustomizationIdResult getCustIdResult = port.getCustomizationId(ct, false);

    for (CustomizationRef customizationRef : getCustIdResult.getCustomizationRefList().getCustomizationRef())
    {
        if (customizationRef.getScriptId().equals(scriptId)) return customizationRef.getInternalId();
    }

    return null;
}

....

// Configure search objectsCustomRecordSearch customerPartNumberRecordSearch = new CustomRecordSearch();
SearchCustomFieldList searchCustomFieldList = new SearchCustomFieldList();
CustomRecordSearchBasic customerPartNumberRecordSearchBasic = new CustomRecordSearchBasic();
customerPartNumberRecordSearchBasic.setCustomFieldList(searchCustomFieldList);
customerPartNumberRecordSearch.setBasic(customerPartNumberRecordSearchBasic);


// Filter by the customer part number record typecustomerPartNumberRecordSearchBasic.setRecType(new RecordRef());
customerPartNumberRecordSearchBasic.getRecType().setInternalId(*ID of customization*); // This is the internal id of the custom record type
// Filter by the customer idSearchMultiSelectCustomField customerFilter = new SearchMultiSelectCustomField();
customerFilter.setScriptId("custrecord_scm_cpn_customer");
customerFilter.setOperator(SearchMultiSelectFieldOperator.ANY_OF);
ListOrRecordRef customerRecordRef = new ListOrRecordRef();
customerRecordRef.setInternalId(customerId);
customerFilter.getSearchValue().add(customerRecordRef);
searchCustomFieldList.getCustomField().add(customerFilter);

// Filter by the inventory item idSearchMultiSelectCustomField itemFilter = new SearchMultiSelectCustomField();
itemFilter.setScriptId("custrecord_scm_cpn_item");
itemFilter.setOperator(SearchMultiSelectFieldOperator.ANY_OF);
ListOrRecordRef itemRecordRef = new ListOrRecordRef();
itemRecordRef.setInternalId(itemNumer);
itemFilter.getSearchValue().add(itemRecordRef);
searchCustomFieldList.getCustomField().add(itemFilter);
customerPartNumberRecordSearchBasic.setCustomFieldList(searchCustomFieldList);

// Search for the customer entitySearchResult partNumbersSearchResult = port.search(customerPartNumberRecordSearch);


return ((CustomRecord)partNumbersSearchResult.getRecordList().getRecord().get(0)).getName();

YorkCode

Ok, so now that I'm a contractor I've set myself up with a website.  Check out http://www.yorkcode.co.uk to see what we do.

NCrunch - Pretty Amazing

This is really just a shameless plug for a project that I think is stunningly well executed and will save anyone that does unit testing in .NET so much of the disruption they go through every day in stopping coding, compiling and then running their unit tests when they can just let their dev environment do all that for them in the background.  The project is NCrunch - http://www.ncrunch.net/download.htm and, in case you hadn't guessed I'm a big fan.  It works better, in my opinion, on NUnit than MSTest, but then the world is a much nicer place when you use NUnit anyway.

Using reflection to map values to properties that could be nullable in C# 4

I encountered an issue with a piece of reflection code that someone had written before I joined the project.  They were mapping to fields on a class that matched the column names on a database.  The only problem was that when the field was a nullable datetime any combination of Convert and SetValue I tried resulted in an error due to the absence of a Convert function for DateTime.  The solution I came up with was to use the dynamic keyword to declare an initialised Nullable generic so that assignment of null to the object acted exactly as if it was being assigned to an actual Nullable object.

/// <summary>
        /// Maps a field name value pair to the matching property on the target object
        /// </summary>
        /// <param name="targetObj">The object to assign a parameter value to</param>
        /// <param name="fieldName">The name of the parameter</param>
        /// <param name="fieldValue">The value to be assigned</param>
        public static void GenericMapField(object targetObj, string fieldName, object fieldValue)
        {
            PropertyInfo prop = targetObj.GetType().GetProperty(fieldName);
            if (prop != null)
            {
                if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
                {
                    dynamic objValue = System.Activator.CreateInstance(prop.PropertyType);
                    objValue = fieldValue;
                    prop.SetValue(targetObj, (object)objValue, null);
                }
                else
                {
                    prop.SetValue(targetObj, fieldValue, null);
                }
            }
        }

MSDeploy "Could not find Default Web Site" issue

I was having a pretty strange issue where one of our sites was failing to deploy over MSDeploy.  We were deploying about 3 other sites to the same server, all of which were deploying fine to Default Web Site but just this one site was throwing a deployment error: Error: Site 'Default Web Site' does not exist..  After some googling, with no luck finding a sensible cause I tried modifying the .csproj file to clean it up so that it matched one of the successfully deploying sites.
I made the following changes that wound up sorting the issue:
1. Added a "ProductVersion" to the project file
2. Removed the empty TargetFrameworkProfile tag
3. Moved assembly signing details from Project config property groups into global propertygroup.
4. Removed DeployIisAppPhysicalPath and DeployIisAppPath tags from config propertygroups into global propertygroup.

I also then deployed the project using Visual studio before I then used our full build process.  All of this seemed to solve our issue with the "'Default Web Site' does not exist" issue for that site.

Javascript code seperation

When I arrived at my current role, the first and most obvious problem that made maintenance next to impossible was the intertwining of javascript with the C# code behind.  It was one of my pet peeves before I arrived to see C# strings used to inject javascript into a page but the codebase here was almost unbelievable - javascript that called a setTimeout with javascript inside it that had multi-escaped double quotes inside the string.
Now, sometimes there's just no avoiding it - if you want to get that truely fantastic maps integration to work really slickly with the data in your working context you might have to inject some dynmically  generated javascript.  Now, most of the time it would be better to do it by using json, parameterising properly but sometimes it's difficult to avoid.  The prime example would be when you're trying to write a server control that outputs javascript appropriate to its environment based on some control parameters.
So, how do we solve the problem?  Well, javascript lives in javascript files for a reason.  Code seperation is there for a reason too but there just wasn't a mechanism for creating the kind of dynamic javascript we wanted.  The solution I came up with was to have the server read in from a series of javascript file resources that contained some placeholder symbols to put variables in to.  I did the same for HTML injection where we needed to dynamically output html, which was also pretty useful.
Of course, since we finally managed to convince the boss that jQuery was a good thing the need for all of that has dropped significantly but it's still a nice thing to be able to do.  I'll post a link to the javascript reader class and html reader class soon so that anyone that wants to can use it.

Making more of this blog

Well, the decision is made and it's coming up to crunch time.  I've been working my way up to becoming a contractor for a long time and now I've got a fixed time frame to do it.  Come mid-August the notice is going in and I'll be looking for a contract as soon as I can get one.  So I've decided to put more posts out on this blog to give myself a bit more of a proffessional presence on the internet.  I'll look at migrating any posts I make out to my own website as soon if I ever get the time (I imagine that will be priority one if I find myself in need of a project to do whie I'm looking for work - if I get work straight away though then I won't have such a need for the blog ;-) ).  Anyway, I hope the stuff I put out there is useful to somebody