IT stuff

Tools used for presenting

noreply@blogger.com (Jessy Houle) — Tue, 11 Oct 2011 16:11:00 +0000

One tool that I cannot live without during presentations is ZoomIt. This tool supports screen zooming and annotations for technical presentations. It has a very small footprint and will not impede your presentation. Here is a good YouTube vid of ZoomIt usage.

A great timer application is always helpful for sticking to a schedule. Focus Boost makes a small, simple, free timer.

Please add comments with other tools you have used during your technical presentations.

Serializing an object to file

noreply@blogger.com (Jessy Houle) — Mon, 19 Sep 2011 18:55:00 +0000

I'm always trying to compare two objects of the same type with different situations. An easy way to do this is to kick out the serialized version of each object and diff them with Araxis (or your diffing tool of choice). However, I always forget the snippet used to do this. Keep in mind, you have to have your object decorated with Serializable to do this.

vm = GetViewModel(Client, groupProposal, gpgDashboard);

/* start serialization */

var serializer = new XmlSerializer(typeof(GroupProposalGridViewModel));

var output = new StringWriter(new System.Text.StringBuilder());

var xmlTempDocument = new XmlDocument();

serializer.Serialize(output,vm);

xmlTempDocument.LoadXml(output.ToString());

xmlTempDocument.Save(@"C:\Temp\GroupProposal.xml");

/* end serialization */

Multiple DIV center technique

noreply@blogger.com (Jessy Houle) — Thu, 07 Apr 2011 17:24:00 +0000

I always have a hard time finding CSS specific to my neeeds. Below is an example that will center n-amount of DIVs:

<style type="text/css">
    body {
        font-family: Verdana,Arial;
        font-size: 12px;
        letter-spacing: -0.04em;
    }
        
    #product-list-outer-container {
        background-color: #F7F4EF;
        position: relative;
        width: 100%;
        height: 75px;
    }
        
    #product-list-container {
        position: absolute;
        left: 50%;
    }
        
    #product-list-inner-container {
        position: relative;
        left: -50%;
        width: 245px;
        height: 75px;
    }
        
    .product {
        background-color: #EEE6DC;
        float: left;
        margin: 5px 5px;
        padding: 5px 5px;
    }
</style>

<div id="product-list-outer-container">
    <div id="product-list-container">
        <div id="product-list-inner-container">
            <div class="product">Shoes</div>
            <div class="product">Jacket</div>
            <div class="product">Socks</div>
            <div class="product">Hat</div>
        </div>
    </div>
</div>

How to deal with an ambiguous method exception in MVC

noreply@blogger.com (Jessy Houle) — Tue, 09 Feb 2010 19:22:00 +0000

This was sent to me by a friend at work, Andy Pickett, and I thought it deemed worthy of Brain.Save:

Ok, I wanted to have these URLs both be valid:

1) http://localhost/ProposalGrid.mvc/display/2/15418
- Get the latest Active Proposal for borrower
2) http://localhost/ProposalGrid.mvc/display/2/15418/26
- Get the Proposal with ProposalId = 26 (assume borrowerid matches)

I think these may be common scenarios throughout CARRS given the way we’ve set up route masks (ignore for the moment that there are Primary Keys in our URLs ;) )

I wanted 2 different action methods (instead of a single action with a switch stmt):

A) public ActionResult Display()
B) public ActionResult Display(int id)

but by default mvc doesn’t like that and can’t figure out which method to call for the #2 URL above, it throws an ambiguous method exception at runtime (note: #1 works fine and always goes to (A)). So I found this on StackOverflow, and I think it makes some sense.

http://stackoverflow.com/questions/1045316/asp-net-mvc-ambiguous-action-methods

So I added and modified their RequireRequestValueAttribute to check if the Route has data for “id” (has to be an positive int per route mapping). And then by adding it to the action method like so:

[RequireRequestValue("id")]
public ActionResult Display(int id)

then URL (1) gets routed to Action (A), and URL (2) goes to (B). So far it works the way I want it to, but it may not be the preferred “MVC way”. If there’s alternatives out there please let me know. Otherwise, feel free to use this attrib for your own overloads.

x64 IIS7 MVC 404

noreply@blogger.com (Jessy Houle) — Mon, 11 Jan 2010 18:58:00 +0000

Hopefully this will save people time when setting up MVC to work with IIS7 using the .MVC extension. Most of these steps are well documented elsewhere, but the x64 thing took a while to figure out (Thanks Jeff Diercks).

Add the .MVC extension to the [Handler Mappings] of the website, and make sure to use the same ISAPI DLL as the .ASPX extension within the Website settings.

Make sure [Network Service] has full access to the filesystem directory IIS is pointing to.

Make sure [Managed Pipeline Mode] is set to [Classic] in the Application Pool settings.

In 64-bit OS, make sure to set the [Enable 32-Bit Applications] to [True] in the Application Pool settings.

If you find any other settings that you had change, please add comments.

Crystal Reports on Visual Studio 2010

noreply@blogger.com (Jessy Houle) — Mon, 14 Dec 2009 19:40:00 +0000

Our boss is allowing us to install and use Visual Studio 2010 (in beta). That said, Crystal Reports is not yet available for VS 2010. Uggg. Thought this was going to be a deal breaker, but it seems that you can install the CRRedist2008_x86.msi and continue to use Crystal Reports, but just not edit the reports themselves. That said, here is the official documentation that we put in our Wiki:

Crystal Reports Configuration:
As we all know, Crystal Reports is a necessary evil for the ERS applications we have such as NAO and IO for example. This document was created to walk a developer / System engineer through the installation process and debugging steps.

Installation steps:

Run the MSI installer package called "CRRedist2008_x86.msi".

Important to note is that the installer will install files in two different locations.

.Net assemblies in the GAC
COM objects under the Program Files\Business Objects directory.

Also important to note is the Crystal Report .Net assemblies use COM interOP with the Crystal Reports COM objects.

If things go well, everything should work but typically is not the case. Below are a number of steps to try in case things don't go according to plan.

In the folder “c:\program files\ business objects\” make sure the local group on the server called “Users” has full control of it and its subdirectories. (Read permissions will not suffice)
Look into the GAC using Windows Explorer at “C:\WINNT\assembly”. Scroll through the list of assemblies and look for ones starting with the words CrystalDecisions.xxxxx. If you don’t see any, run the “CRRedist2008_x86.msi” installer again. If you do see some, make sure you see the version number of 10.5.3700.0. If you see an earlier version, you most likely used the wrong MSI installer package.
If step 1 and 2 don’t work, look at the file system security settings of the root of the website. Add the local account of “Network Services” and give it full permissions. Make sure the sub directories inherit from the root folder.

Please keep in mind that Crystal reports may install on some servers with no problems but not on others. It can be both perplexing and frustrating as to why this is. As far as we know, there is no rhyme or reason on why this is. Our one suggestion is to give yourself ample time for the Crystal reports installation.

Lastly, if things do work you should see a shiny new PDF document pop up if you selected PDF on the reports creation page. If you see a dialog box asking you to save instead, that just means you don’t have Adobe Acrobat Reader on your computer.

Shrinking SQL DB with scripts

noreply@blogger.com (Jessy Houle) — Thu, 14 May 2009 22:13:00 +0000

Today I went through the fun exercise of Restoring a multi-gig SQL database from Backup.

5+ hours later, I knew I didn’t want to go through it again! Anywise, long story short, we had some scripts at work that truncates unused tables, truncates the transaction log, and shrinks the data file. I slightly modified this script to work with the currently selected database.

-- truncate unneeded tables
--TRUNCATE TABLE {tablename}
--GO

-- truncate transaction log
DECLARE @LOG_FILENAME VARCHAR(200)
SELECT @LOG_FILENAME = FILE_NAME (2)

 
BACKUP LOG NAO WITH Truncate_only
DBCC SHRINKFILE (@LOG_FILENAME)
GO
 
-- shrink data file
DECLARE @DATA_FILENAME VARCHAR(200)
SELECT @DATA_FILENAME = FILE_NAME (1)
 
DBCC SHRINKFILE (@DATA_FILENAME)
GO

Ajax with dynamic JavaScript creation

noreply@blogger.com (Jessy Houle) — Fri, 07 Nov 2008 16:02:00 +0000

When working with pages that do a partial post back (i.e. Ajax), you must use the static method of the scriptmanager class to register your javascript. As a best practice, you should always use the static method, this way if we decide to use Ajax on the page in the future we won't run into problems.

USE: System.Web.UI.ScriptManager.RegisterClientScriptBlock

Do Not USE: Page.ClientScript.RegisterClientScriptBlock

Fix database users upon a restore (on MS SQL)

noreply@blogger.com (Jessy Houle) — Tue, 12 Aug 2008 18:42:00 +0000

When you do a database restore from a backup that was taken from a different machine, you also get all the users from that environment (and their SQL Ids).

So, the scenario is... I backup my production database, and then I restore that production database locally. The user that resides in my web.config file is correct (correct username and password). However, the actual user that is in my local database is the production user (meaning it holds the production user's SQL Id). I have the very same user, with the very same password... but this is not the same user.

Ok, now, how to fix this... Very easy trick a co-worker had in his bag of tricks:

sp_change_users_login 'auto_fix', '{userid}'

* where {userid} is the user id that you have locally, as well as restored from the production restore.

So, in my case, it would be something like:

sp_change_users_login 'auto_fix', 'DMSPFR'

This will fix my local database to reference my local DMSPFR user; not the production DMSPFR user.

Inside IIS

noreply@blogger.com (Jessy Houle) — Tue, 01 Jul 2008 15:02:00 +0000

There is a great sample chapter on hacking IIS, which is written more for hackers, but is a must read for developers who manage their IIS servers. It explains AppDomains, Application Pools, ISAPI, and IIS process, and security surrounding IIS. Again, this is written for hackers, so, the interesting piece is the first part of the chapter, which explains IIS; you may want to skip the remaining part of the chapter, which goes into the hacking end of IIS.

Windows Live Writer

noreply@blogger.com (Jessy Houle) — Wed, 02 Apr 2008 02:15:00 +0000

Just testing out the Windows Live Writer from Microsoft. This will allow people to blog much easier. Features include spell checking, many views (normal, web, html), saving of drafts to work on later, and easy one click publish.

Good View State Article

noreply@blogger.com (Jessy Houle) — Thu, 08 Nov 2007 21:52:00 +0000

http://aspnetresources.com/articles/ViewState.aspx

nice web.config commenting

noreply@blogger.com (Jessy Houle) — Tue, 06 Nov 2007 20:59:00 +0000

I always find myself relying upon IntelliSense to create or edit the web.config file. Microsoft has provided a web.config file with great commenting for you, that can be found at (with the 2.0 .NET Framework installed):

C:\WINNT\Microsoft.NET\Framework\v2.0.50727\CONFIG\web.config.comments

For reference sake, here it is:

<?xml version="1.0" encoding="us-ascii"?>

<!-- the root web configuration file -->

<configuration>

  <!--

        Using a location directive with a missing path attribute

        scopes the configuration to the entire machine.  If used in

        conjunction with allowOverride="false", it can be used to

        prevent configuration from being altered on the machine

        Administrators that want to restrict permissions granted to

        web applications should change the default Trust level and ensure

        that overrides are not allowed

-->

  <system.web>

    <!--

            <anonymousIdentification

                enabled = "false" [true|false]

                cookieName = ".ASPXANONYMOUS" [String]

                cookieTimeout = "100000"  [in Minutes][number]

                cookiePath = "/" [String]

                cookieRequireSSL = "false" [true|false]

                cookieSlidingExpiration = "true" [true|false]

                cookieProtection = "Validation" [None | Validation | Encryption | All]

                cookieless = "UseCookies" [UseUri | UseCookies | AutoDetect | UseDeviceProfile]

                domain = "" [String]

/>

-->

    <anonymousIdentification enabled="false" cookieName=".ASPXANONYMOUS" cookieTimeout="100000" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="Validation" cookieless="UseCookies" />

    <!--

            <authentication

                mode = "Windows" [None | Windows | Passport | Forms]

                <forms

                    name = ".ASPXAUTH" [String]

                    loginUrl = "login.aspx" [String]

                    defaultUrl = "default.aspx" [String]

                    protection = "All" [All | None | Encryption | Validation]

                    timeout = "30"  [in Minutes][number]

                    path = "/" [String]

                    requireSSL = "false" [true|false]

                    slidingExpiration = "true" [true|false]

                    enableCrossAppRedirects = "false" [true|false]

                    cookieless = "UseDeviceProfile" [UseUri | UseCookies | AutoDetect | UseDeviceProfile]

                    domain = "" [String]

                    <credentials

                        passwordFormat = "SHA1" [Clear | SHA1 | MD5]

                        <user

                            name = "" [String, Required, Collection Key]

                            password = "" [String, Required]

/>

                    </credentials>

                </forms>

                <passport

                    redirectUrl = "internal" [String]

/>

            </authentication>

-->

    <authentication mode="Windows">

      <forms name=".ASPXAUTH" loginUrl="login.aspx" defaultUrl="default.aspx" protection="All" timeout="30" path="/" requireSSL="false" slidingExpiration="true" cookieless="UseDeviceProfile" enableCrossAppRedirects="false">

        <credentials passwordFormat="SHA1" />

      </forms>

      <passport redirectUrl="internal" />

    </authentication>

    <!--

            <customErrors

                defaultRedirect = "" [String]

                mode = "RemoteOnly" [RemoteOnly | On | Off]

                <error

                    statusCode = "" [number, Required, Collection Key]

                    redirect = "" [String, Required]

/>

            </customErrors>

-->

    <customErrors mode="RemoteOnly" />

    <!--

            <deviceFilters

                <filter

                    name = "" [String, Required, Collection Key]

                    type = ""

                    method = "" [String]

                    compare = "" [String]

                    argument = "" [String]

/>

            </deviceFilters>

-->

    <deviceFilters />

    <!--

            <globalization

                requestEncoding = "utf-8"

                responseEncoding = "utf-8"

                responseHeaderEncoding = "utf-8"

                fileEncoding = ""

                culture = "" [String]

                uiCulture = "" [String]

                enableClientBasedCulture = "false" [true|false]

                resourceProviderFactoryType = "" [String]

                enableBestFitResponseEncoding = "false" [true|false]

/>

-->

    <globalization requestEncoding="utf-8" responseEncoding="utf-8" fileEncoding="" culture="" uiCulture="" enableClientBasedCulture="false" responseHeaderEncoding="utf-8" resourceProviderFactoryType="" enableBestFitResponseEncoding="false" />

    <!--

            <hostingEnvironment

                shutdownTimeout = "30"  [in Seconds][number]

                idleTimeout = "Infinite"  [in Minutes][number]

                shadowCopyBinAssemblies = "true" [true|false]

/>

-->

    <hostingEnvironment idleTimeout="Infinite" shutdownTimeout="30" shadowCopyBinAssemblies="true" />

    <!--

            <httpCookies

                httpOnlyCookies = "false" [true|false]

                requireSSL = "false" [true|false]

                domain = "" [String]

/>

-->

    <httpCookies httpOnlyCookies="false" requireSSL="false" domain="" />

    <!--

            <httpRuntime

                executionTimeout = "110"  [in Seconds][number]

                maxRequestLength = "4096" [number]

                requestLengthDiskThreshold = "80" [number]

                useFullyQualifiedRedirectUrl = "false" [true|false]

                minFreeThreads = "8" [number]

                minLocalRequestFreeThreads = "4" [number]

                appRequestQueueLimit = "5000" [number]

                enableKernelOutputCache = "true" [true|false]

                enableVersionHeader = "true" [true|false]

                apartmentThreading = "false" [true|false]

                requireRootedSaveAsPath = "true" [true|false]

                enable = "true" [true|false]

                sendCacheControlHeader = "true" [true|false]

                shutdownTimeout = "90"  [in Seconds][number]

                delayNotificationTimeout = "5"  [in Seconds][number]

                waitChangeNotification = "0" [number]

                maxWaitChangeNotification = "0" [number]

                enableHeaderChecking = "true" [true|false]

/>

-->

    <httpRuntime executionTimeout="110" maxRequestLength="4096" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false" />

    <!--

            <identity

                impersonate = "false" [true|false]

                userName = "" [String]

                password = "" [String]

/>

-->

    <identity impersonate="false" userName="" password="" />

    <!--

            <machineKey

                validationKey = "AutoGenerate,IsolateApps" [String]

                decryptionKey = "AutoGenerate,IsolateApps" [String]

                decryption = "Auto" [AUTO | DES | 3DES | AES]

                validation = "SHA1" [MD5 | SHA1 | 3DES | AES]

/>

-->

    <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="SHA1" decryption="Auto" />

    <!--

            <sessionPageState

                historySize = "9" [number]

/>

-->

    <sessionPageState historySize="9" />

    <!--

            <sessionState

                mode = "InProc" [Off | InProc | StateServer | SQLServer | Custom]

                stateConnectionString = "tcpip=loopback:42424" [String]

                stateNetworkTimeout = "10"  [in Seconds][number]

                sqlConnectionString = "data source=localhost;Integrated Security=SSPI" [String]

                sqlCommandTimeout = "30"  [in Seconds][number]

                customProvider = "" [String]

                cookieless = "" [UseUri | UseCookies | AutoDetect | UseDeviceProfile]

                cookieName = "ASP.NET_SessionId" [String]

                timeout = "20"  [in Minutes][number]

                allowCustomSqlDatabase = "false" [true|false]

                regenerateExpiredSessionId = "true" [true|false]

                partitionResolverType = "" [String]

                useHostingIdentity = "true" [true|false]

                sessionIDManagerType = "" [String]

                <providers>

                    <add

                        name = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </providers>

            </sessionState>

-->

    <sessionState mode="InProc" stateConnectionString="tcpip=loopback:42424" stateNetworkTimeout="10" sqlConnectionString="data source=localhost;Integrated Security=SSPI" sqlCommandTimeout="30" customProvider="" cookieless="UseCookies" cookieName="ASP.NET_SessionId" timeout="20" allowCustomSqlDatabase="false" regenerateExpiredSessionId="true" partitionResolverType="" useHostingIdentity="true" sessionIDManagerType="">

      <providers>

        <clear />

      </providers>

    </sessionState>

    <!--

            <trace

                enabled = "false" [true|false]

                mostRecent = "false" [true|false]

                localOnly = "true" [true|false]

                pageOutput = "false" [true|false]

                requestLimit = "10" [number]

                traceMode = "SortByTime" [SortByTime | SortByCategory]

                writeToDiagnosticsTrace = "false" [true|false]

/>

-->

    <trace enabled="false" localOnly="true" mostRecent="false" pageOutput="false" requestLimit="10" traceMode="SortByTime" writeToDiagnosticsTrace="false" />

    <!--

            <webServices

                <conformanceWarnings>

                    <add

                        name = "None" [None | BasicProfile1_1, Collection Key]

/>

                </conformanceWarnings>

                <protocols>

                    <add

                        name = "Unknown" [Unknown | HttpSoap | HttpGet | HttpPost | Documentation | HttpPostLocalhost | HttpSoap12 | AnyHttpSoap, Collection Key]

/>

                </protocols>

                <soapEnvelopeProcessing

                    readTimeout = "2147483647" [number]

                    strict = "false" [true|false]

/>

                <DiagnosticsElement

                    suppressReturningExceptions = "false" [true|false]

/>

                <serviceDescriptionFormatExtensionTypes>

                    <add

                        type = "" [Collection Key]

/>

                </serviceDescriptionFormatExtensionTypes>

                <soapExtensionImporterTypes>

                    <add

                        type = "" [Collection Key]

/>

                </soapExtensionImporterTypes>

                <soapExtensionReflectorTypes>

                    <add

                        type = "" [Collection Key]

/>

                </soapExtensionReflectorTypes>

                <soapExtensionTypes>

                    <add

                        group = "Low" [High | Low, Collection Key]

                        priority = "0" [number, Collection Key]

                        type = "" [Collection Key]

/>

                </soapExtensionTypes>

                <soapServerProtocolFactory

                    type = "" [Collection Key]

/>

                <soapTransportImporterTypes>

                    <add

                        type = "" [Collection Key]

/>

                </soapTransportImporterTypes>

                <wsdlHelpGenerator

                    href = "DefaultWsdlHelpGenerator.aspx" [String, Required]

/>

            </webServices>

-->

    <webServices>

      <conformanceWarnings>

        <clear />

        <add name="BasicProfile1_1" />

      </conformanceWarnings>

      <protocols>

        <clear />

        <add name="HttpSoap12" />

        <add name="HttpSoap" />

        <add name="HttpPostLocalhost" />

        <add name="Documentation" />

      </protocols>

      <serviceDescriptionFormatExtensionTypes>

        <clear />

      </serviceDescriptionFormatExtensionTypes>

      <soapEnvelopeProcessing readTimeout="Infinite" strict="false" />

      <soapExtensionImporterTypes>

        <clear />

      </soapExtensionImporterTypes>

      <soapExtensionReflectorTypes>

        <clear />

      </soapExtensionReflectorTypes>

      <soapExtensionTypes>

        <clear />

      </soapExtensionTypes>

      <soapTransportImporterTypes>

        <clear />

      </soapTransportImporterTypes>

      <wsdlHelpGenerator href="DefaultWsdlHelpGenerator.aspx" />

      <soapServerProtocolFactory type="System.Web.Services.Protocols.SoapServerProtocolFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

      <diagnostics suppressReturningExceptions="false" />

    </webServices>

    <!--

            <xhtmlConformance

                mode = "Transitional" [Transitional | Legacy | Strict]

/>

-->

    <xhtmlConformance mode="Transitional" />

    <!--

            <authorization

                <allow

                    verbs = ""

                    users = ""

                    roles = ""

/>

                <deny

                    verbs = ""

                    users = ""

                    roles = ""

/>

            </authorization>

-->

    <authorization>

      <allow users="*" />

    </authorization>

    <!--

            <browserCaps

/>

-->

    <browserCaps userAgentCacheKeyLength="64">

      <result type="System.Web.Mobile.MobileCapabilities, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

    </browserCaps>

    <!--

            <clientTarget

                <add

                    alias = "" [String, Required, Collection Key]

                    userAgent = "" [String, Required]

/>

            </clientTarget>

-->

    <clientTarget>

      <clear />

      <add alias="ie5" userAgent="Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)" />

      <add alias="ie4" userAgent="Mozilla/4.0 (compatible; MSIE 4.0; Windows NT 4.0)" />

      <add alias="uplevel" userAgent="Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.1)" />

      <add alias="downlevel" userAgent="Generic Downlevel" />

    </clientTarget>

    <!--

            <compilation

                tempDirectory = "" [String]

                debug = "false" [true|false]

                strict = "false" [true|false]

                explicit = "true" [true|false]

                batch = "true" [true|false]

                urlLinePragmas = "false" [true|false]

                batchTimeout = "900"  [in Seconds][number]

                maxBatchSize = "1000" [number]

                maxBatchGeneratedFileSize = "1000" [number]

                numRecompilesBeforeAppRestart = "15" [number]

                defaultLanguage = "vb" [String]

                assemblyPostProcessorType = "" [String]

                <assemblies>

                    <add

                        assembly = "" [String, Required, Collection Key]

/>

                </assemblies>

                <buildProviders>

                    <add

                        extension = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </buildProviders>

                <expressionBuilders>

                    <add

                        expressionPrefix = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </expressionBuilders>

                <codeSubDirectories>

                    <add

                        directoryName = "" [String, Required, Collection Key]

/>

                </codeSubDirectories>

            </compilation>

-->

    <compilation tempDirectory="" debug="false" strict="false" explicit="true" batch="true" batchTimeout="900" maxBatchSize="1000" maxBatchGeneratedFileSize="1000" numRecompilesBeforeAppRestart="15" defaultLanguage="vb" urlLinePragmas="false" assemblyPostProcessorType="">

      <assemblies>

        <clear />

        <add assembly="mscorlib" />

        <add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

        <add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

        <add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

        <add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        <add assembly="*" />

      </assemblies>

      <buildProviders>

        <clear />

        <add extension=".aspx" type="System.Web.Compilation.PageBuildProvider" />

        <add extension=".ascx" type="System.Web.Compilation.UserControlBuildProvider" />

        <add extension=".master" type="System.Web.Compilation.MasterPageBuildProvider" />

        <add extension=".asmx" type="System.Web.Compilation.WebServiceBuildProvider" />

        <add extension=".ashx" type="System.Web.Compilation.WebHandlerBuildProvider" />

        <add extension=".soap" type="System.Web.Compilation.WebServiceBuildProvider" />

        <add extension=".resx" type="System.Web.Compilation.ResXBuildProvider" />

        <add extension=".resources" type="System.Web.Compilation.ResourcesBuildProvider" />

        <add extension=".wsdl" type="System.Web.Compilation.WsdlBuildProvider" />

        <add extension=".xsd" type="System.Web.Compilation.XsdBuildProvider" />

        <add extension=".js" type="System.Web.Compilation.ForceCopyBuildProvider" />

        <add extension=".lic" type="System.Web.Compilation.IgnoreFileBuildProvider" />

        <add extension=".licx" type="System.Web.Compilation.IgnoreFileBuildProvider" />

        <add extension=".exclude" type="System.Web.Compilation.IgnoreFileBuildProvider" />

        <add extension=".refresh" type="System.Web.Compilation.IgnoreFileBuildProvider" />

      </buildProviders>

      <expressionBuilders>

        <clear />

        <add expressionPrefix="Resources" type="System.Web.Compilation.ResourceExpressionBuilder" />

        <add expressionPrefix="ConnectionStrings" type="System.Web.Compilation.ConnectionStringsExpressionBuilder" />

        <add expressionPrefix="AppSettings" type="System.Web.Compilation.AppSettingsExpressionBuilder" />

      </expressionBuilders>

    </compilation>

    <!--

            <healthMonitoring

                heartbeatInterval = "0"  [in Seconds][number]

                enabled = "true" [true|false]

                <bufferModes>

                    <add

                        name = "" [String, Required, Collection Key]

                        maxBufferSize = "2147483647" [number, Required]

                        maxFlushSize = "2147483647" [number, Required]

                        urgentFlushThreshold = "2147483647" [number, Required]

                        regularFlushInterval = "00:00:01" [HH:MM:SS, Required]

                        urgentFlushInterval = "00:00:00" [HH:MM:SS, Required]

                        maxBufferThreads = "1" [number]

/>

                </bufferModes>

                <providers>

                    <add

                        name = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </providers>

                <profiles>

                    <add

                        name = "" [String, Required, Collection Key]

                        minInstances = "1" [number]

                        maxLimit = "2147483647" [number]

                        minInterval = "00:00:00" [HH:MM:SS]

                        custom = "" [String]

/>

                </profiles>

                <rules>

                    <add

                        name = "" [String, Required, Collection Key]

                        eventName = "" [String, Required]

                        custom = "" [String]

                        profile = "" [String]

                        provider = "" [String]

                        minInstances = "1" [number]

                        maxLimit = "2147483647" [number]

                        minInterval = "00:00:00" [HH:MM:SS]

/>

                </rules>

                <eventMappings>

                    <add

                        name = "" [String, Required, Collection Key]

                        type = "" [String, Required]

                        startEventCode = "0" [number]

                        endEventCode = "2147483647" [number]

/>

                </eventMappings>

            </healthMonitoring>

-->

    <healthMonitoring heartbeatInterval="0" enabled="true">

      <bufferModes>

        <clear />

        <add name="Critical Notification" maxBufferSize="100" maxFlushSize="20" urgentFlushThreshold="1" regularFlushInterval="Infinite" urgentFlushInterval="00:01:00" maxBufferThreads="1" />

        <add name="Notification" maxBufferSize="300" maxFlushSize="20" urgentFlushThreshold="1" regularFlushInterval="Infinite" urgentFlushInterval="00:01:00" maxBufferThreads="1" />

        <add name="Analysis" maxBufferSize="1000" maxFlushSize="100" urgentFlushThreshold="100" regularFlushInterval="00:05:00" urgentFlushInterval="00:01:00" maxBufferThreads="1" />

        <add name="Logging" maxBufferSize="1000" maxFlushSize="200" urgentFlushThreshold="800" regularFlushInterval="00:30:00" urgentFlushInterval="00:05:00" maxBufferThreads="1" />

      </bufferModes>

      <providers>

        <clear />

        <add name="EventLogProvider" type="System.Web.Management.EventLogWebEventProvider,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />

        <add connectionStringName="LocalSqlServer" maxEventDetailsLength="1073741823" buffer="false" bufferMode="Notification" name="SqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />

        <add name="WmiWebEventProvider" type="System.Web.Management.WmiWebEventProvider,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />

      </providers>

      <profiles>

        <clear />

        <add name="Default" minInstances="1" maxLimit="Infinite" minInterval="00:01:00" custom="" />

        <add name="Critical" minInstances="1" maxLimit="Infinite" minInterval="00:00:00" custom="" />

      </profiles>

      <rules>

        <clear />

        <add name="All Errors Default" eventName="All Errors" provider="EventLogProvider" profile="Default" minInstances="1" maxLimit="Infinite" minInterval="00:01:00" custom="" />

        <add name="Failure Audits Default" eventName="Failure Audits" provider="EventLogProvider" profile="Default" minInstances="1" maxLimit="Infinite" minInterval="00:01:00" custom="" />

      </rules>

      <eventMappings>

        <clear />

        <add name="All Events" type="System.Web.Management.WebBaseEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Heartbeats" type="System.Web.Management.WebHeartbeatEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Application Lifetime Events" type="System.Web.Management.WebApplicationLifetimeEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Request Processing Events" type="System.Web.Management.WebRequestEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="All Errors" type="System.Web.Management.WebBaseErrorEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Infrastructure Errors" type="System.Web.Management.WebErrorEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Request Processing Errors" type="System.Web.Management.WebRequestErrorEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="All Audits" type="System.Web.Management.WebAuditEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Failure Audits" type="System.Web.Management.WebFailureAuditEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

        <add name="Success Audits" type="System.Web.Management.WebSuccessAuditEvent,System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" startEventCode="0" endEventCode="2147483647" />

      </eventMappings>

    </healthMonitoring>

    <!--

            <httpHandlers

                <add

                    path = "" [String, Required, Collection Key]

                    verb = "" [String, Required, Collection Key]

                    type = "" [String, Required]

                    validate = "true" [true|false]

/>

            </httpHandlers>

-->

    <httpHandlers>

      <clear />

      <add path="trace.axd" verb="*" type="System.Web.Handlers.TraceHandler" validate="true" />

      <add path="WebResource.axd" verb="GET" type="System.Web.Handlers.AssemblyResourceLoader" validate="true" />

      <add path="*.axd" verb="*" type="System.Web.HttpNotFoundHandler" validate="true" />

      <add path="*.aspx" verb="*" type="System.Web.UI.PageHandlerFactory" validate="true" />

      <add path="*.ashx" verb="*" type="System.Web.UI.SimpleHandlerFactory" validate="true" />

      <add path="*.asmx" verb="*" type="System.Web.Services.Protocols.WebServiceHandlerFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />

      <add path="*.rem" verb="*" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory, System.Runtime.Remoting, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" validate="false" />

      <add path="*.soap" verb="*" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory, System.Runtime.Remoting, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" validate="false" />

      <add path="*.asax" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.ascx" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.master" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.skin" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.browser" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.sitemap" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.dll.config" verb="GET,HEAD" type="System.Web.StaticFileHandler" validate="true" />

      <add path="*.exe.config" verb="GET,HEAD" type="System.Web.StaticFileHandler" validate="true" />

      <add path="*.config" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.cs" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.csproj" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.vb" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.vbproj" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.webinfo" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.licx" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.resx" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.resources" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.mdb" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.vjsproj" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.java" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.jsl" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.ldb" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.ad" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.dd" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.ldd" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.sd" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.cd" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.adprototype" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.lddprototype" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.sdm" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.sdmDocument" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.mdf" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.ldf" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.exclude" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*.refresh" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />

      <add path="*" verb="GET,HEAD,POST" type="System.Web.DefaultHttpHandler" validate="true" />

      <add path="*" verb="*" type="System.Web.HttpMethodNotAllowedHandler" validate="true" />

    </httpHandlers>

    <!--

            <httpModules

                <add

                    name = "" [String, Required, Collection Key]

                    type = "" [String, Required]

/>

            </httpModules>

-->

    <httpModules>

      <clear />

      <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />

      <add name="Session" type="System.Web.SessionState.SessionStateModule" />

      <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />

      <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />

      <add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />

      <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />

      <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />

      <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />

      <add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" />

      <add name="Profile" type="System.Web.Profile.ProfileModule" />

      <add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

    </httpModules>

    <!--

            <mobileControls

                sessionStateHistorySize = "6" [number]

                cookielessDataDictionaryType = "System.Web.Mobile.CookielessData"

                allowCustomAttributes = "false" [true|false]

                <device

                    name = "" [String, Required, Collection Key]

                    inheritsFrom = "" [String]

                    predicateClass = ""

                    predicateMethod = "" [String]

                    pageAdapter = ""

                    <control

                        name = "" [String, Required, Collection Key]

                        adapter = "" [Required]

/>

                </>/>

            </mobileControls>

-->

    <mobileControls sessionStateHistorySize="6" cookielessDataDictionaryType="System.Web.Mobile.CookielessData" allowCustomAttributes="false">

      <device name="XhtmlDeviceAdapters" predicateClass="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlPageAdapter" predicateMethod="DeviceQualifies" pageAdapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlPageAdapter">

        <control name="System.Web.UI.MobileControls.Panel" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlPanelAdapter" />

        <control name="System.Web.UI.MobileControls.Form" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlFormAdapter" />

        <control name="System.Web.UI.MobileControls.TextBox" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlTextBoxAdapter" />

        <control name="System.Web.UI.MobileControls.Label" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlLabelAdapter" />

        <control name="System.Web.UI.MobileControls.LiteralText" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlLiteralTextAdapter" />

        <control name="System.Web.UI.MobileControls.Link" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlLinkAdapter" />

        <control name="System.Web.UI.MobileControls.Command" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlCommandAdapter" />

        <control name="System.Web.UI.MobileControls.PhoneCall" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlPhoneCallAdapter" />

        <control name="System.Web.UI.MobileControls.List" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlListAdapter" />

        <control name="System.Web.UI.MobileControls.SelectionList" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlSelectionListAdapter" />

        <control name="System.Web.UI.MobileControls.ObjectList" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlObjectListAdapter" />

        <control name="System.Web.UI.MobileControls.Image" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlImageAdapter" />

        <control name="System.Web.UI.MobileControls.ValidationSummary" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlValidationSummaryAdapter" />

        <control name="System.Web.UI.MobileControls.Calendar" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlCalendarAdapter" />

        <control name="System.Web.UI.MobileControls.TextView" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlTextViewAdapter" />

        <control name="System.Web.UI.MobileControls.MobileControl" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlControlAdapter" />

        <control name="System.Web.UI.MobileControls.BaseValidator" adapter="System.Web.UI.MobileControls.Adapters.XhtmlAdapters.XhtmlValidatorAdapter" />

      </device>

      <device name="HtmlDeviceAdapters" predicateClass="System.Web.UI.MobileControls.Adapters.HtmlPageAdapter" predicateMethod="DeviceQualifies" pageAdapter="System.Web.UI.MobileControls.Adapters.HtmlPageAdapter">

        <control name="System.Web.UI.MobileControls.Panel" adapter="System.Web.UI.MobileControls.Adapters.HtmlPanelAdapter" />

        <control name="System.Web.UI.MobileControls.Form" adapter="System.Web.UI.MobileControls.Adapters.HtmlFormAdapter" />

        <control name="System.Web.UI.MobileControls.TextBox" adapter="System.Web.UI.MobileControls.Adapters.HtmlTextBoxAdapter" />

        <control name="System.Web.UI.MobileControls.Label" adapter="System.Web.UI.MobileControls.Adapters.HtmlLabelAdapter" />

        <control name="System.Web.UI.MobileControls.LiteralText" adapter="System.Web.UI.MobileControls.Adapters.HtmlLiteralTextAdapter" />

        <control name="System.Web.UI.MobileControls.Link" adapter="System.Web.UI.MobileControls.Adapters.HtmlLinkAdapter" />

        <control name="System.Web.UI.MobileControls.Command" adapter="System.Web.UI.MobileControls.Adapters.HtmlCommandAdapter" />

        <control name="System.Web.UI.MobileControls.PhoneCall" adapter="System.Web.UI.MobileControls.Adapters.HtmlPhoneCallAdapter" />

        <control name="System.Web.UI.MobileControls.List" adapter="System.Web.UI.MobileControls.Adapters.HtmlListAdapter" />

        <control name="System.Web.UI.MobileControls.SelectionList" adapter="System.Web.UI.MobileControls.Adapters.HtmlSelectionListAdapter" />

        <control name="System.Web.UI.MobileControls.ObjectList" adapter="System.Web.UI.MobileControls.Adapters.HtmlObjectListAdapter" />

        <control name="System.Web.UI.MobileControls.Image" adapter="System.Web.UI.MobileControls.Adapters.HtmlImageAdapter" />

        <control name="System.Web.UI.MobileControls.BaseValidator" adapter="System.Web.UI.MobileControls.Adapters.HtmlValidatorAdapter" />

        <control name="System.Web.UI.MobileControls.ValidationSummary" adapter="System.Web.UI.MobileControls.Adapters.HtmlValidationSummaryAdapter" />

        <control name="System.Web.UI.MobileControls.Calendar" adapter="System.Web.UI.MobileControls.Adapters.HtmlCalendarAdapter" />

        <control name="System.Web.UI.MobileControls.TextView" adapter="System.Web.UI.MobileControls.Adapters.HtmlTextViewAdapter" />

        <control name="System.Web.UI.MobileControls.MobileControl" adapter="System.Web.UI.MobileControls.Adapters.HtmlControlAdapter" />

      </device>

      <device name="UpWmlDeviceAdapters" inheritsFrom="WmlDeviceAdapters" predicateClass="System.Web.UI.MobileControls.Adapters.UpWmlPageAdapter" predicateMethod="DeviceQualifies" pageAdapter="System.Web.UI.MobileControls.Adapters.UpWmlPageAdapter" />

      <device name="WmlDeviceAdapters" predicateClass="System.Web.UI.MobileControls.Adapters.WmlPageAdapter" predicateMethod="DeviceQualifies" pageAdapter="System.Web.UI.MobileControls.Adapters.WmlPageAdapter">

        <control name="System.Web.UI.MobileControls.Panel" adapter="System.Web.UI.MobileControls.Adapters.WmlPanelAdapter" />

        <control name="System.Web.UI.MobileControls.Form" adapter="System.Web.UI.MobileControls.Adapters.WmlFormAdapter" />

        <control name="System.Web.UI.MobileControls.TextBox" adapter="System.Web.UI.MobileControls.Adapters.WmlTextBoxAdapter" />

        <control name="System.Web.UI.MobileControls.Label" adapter="System.Web.UI.MobileControls.Adapters.WmlLabelAdapter" />

        <control name="System.Web.UI.MobileControls.LiteralText" adapter="System.Web.UI.MobileControls.Adapters.WmlLiteralTextAdapter" />

        <control name="System.Web.UI.MobileControls.Link" adapter="System.Web.UI.MobileControls.Adapters.WmlLinkAdapter" />

        <control name="System.Web.UI.MobileControls.Command" adapter="System.Web.UI.MobileControls.Adapters.WmlCommandAdapter" />

        <control name="System.Web.UI.MobileControls.PhoneCall" adapter="System.Web.UI.MobileControls.Adapters.WmlPhoneCallAdapter" />

        <control name="System.Web.UI.MobileControls.List" adapter="System.Web.UI.MobileControls.Adapters.WmlListAdapter" />

        <control name="System.Web.UI.MobileControls.SelectionList" adapter="System.Web.UI.MobileControls.Adapters.WmlSelectionListAdapter" />

        <control name="System.Web.UI.MobileControls.ObjectList" adapter="System.Web.UI.MobileControls.Adapters.WmlObjectListAdapter" />

        <control name="System.Web.UI.MobileControls.Image" adapter="System.Web.UI.MobileControls.Adapters.WmlImageAdapter" />

        <control name="System.Web.UI.MobileControls.BaseValidator" adapter="System.Web.UI.MobileControls.Adapters.WmlValidatorAdapter" />

        <control name="System.Web.UI.MobileControls.ValidationSummary" adapter="System.Web.UI.MobileControls.Adapters.WmlValidationSummaryAdapter" />

        <control name="System.Web.UI.MobileControls.Calendar" adapter="System.Web.UI.MobileControls.Adapters.WmlCalendarAdapter" />

        <control name="System.Web.UI.MobileControls.TextView" adapter="System.Web.UI.MobileControls.Adapters.WmlTextViewAdapter" />

        <control name="System.Web.UI.MobileControls.MobileControl" adapter="System.Web.UI.MobileControls.Adapters.WmlControlAdapter" />

      </device>

      <device name="ChtmlDeviceAdapters" inheritsFrom="HtmlDeviceAdapters" predicateClass="System.Web.UI.MobileControls.Adapters.ChtmlPageAdapter" predicateMethod="DeviceQualifies" pageAdapter="System.Web.UI.MobileControls.Adapters.ChtmlPageAdapter">

        <control name="System.Web.UI.MobileControls.Form" adapter="System.Web.UI.MobileControls.Adapters.ChtmlFormAdapter" />

        <control name="System.Web.UI.MobileControls.Calendar" adapter="System.Web.UI.MobileControls.Adapters.ChtmlCalendarAdapter" />

        <control name="System.Web.UI.MobileControls.Image" adapter="System.Web.UI.MobileControls.Adapters.ChtmlImageAdapter" />

        <control name="System.Web.UI.MobileControls.TextBox" adapter="System.Web.UI.MobileControls.Adapters.ChtmlTextBoxAdapter" />

        <control name="System.Web.UI.MobileControls.SelectionList" adapter="System.Web.UI.MobileControls.Adapters.ChtmlSelectionListAdapter" />

        <control name="System.Web.UI.MobileControls.Command" adapter="System.Web.UI.MobileControls.Adapters.ChtmlCommandAdapter" />

        <control name="System.Web.UI.MobileControls.PhoneCall" adapter="System.Web.UI.MobileControls.Adapters.ChtmlPhoneCallAdapter" />

        <control name="System.Web.UI.MobileControls.Link" adapter="System.Web.UI.MobileControls.Adapters.ChtmlLinkAdapter" />

      </device>

    </mobileControls>

    <!--

            <pages

                buffer = "true" [true|false]

                enableSessionState = "true" [False | ReadOnly | True]

                enableViewState = "true" [true|false]

                enableViewStateMac = "true" [true|false]

                enableEventValidation = "true" [true|false]

                smartNavigation = "false" [true|false]

                autoEventWireup = "true" [true|false]

                maintainScrollPositionOnPostBack = "false" [true|false]

                pageBaseType = "System.Web.UI.Page" [String]

                userControlBaseType = "System.Web.UI.UserControl" [String]

                pageParserFilterType = "" [String]

                validateRequest = "true" [true|false]

                masterPageFile = "" [String]

                theme = "" [String]

                styleSheetTheme = "" [String]

                maxPageStateFieldLength = "-1" [number]

                compilationMode = "Always" [Auto | Never | Always]

                viewStateEncryptionMode = "Auto" [Auto | Always | Never]

                asyncTimeout = "45"  [in Seconds][number]

                <namespaces

                    autoImportVBNamespace = "true" [true|false]

                    <add

                        namespace = "" [String, Required, Collection Key]

/>

                </namespaces>

                <controls>

                    <add

                        tagPrefix = "/" [String, Required]

                        tagName = "" [String]

                        namespace = "" [String]

                        assembly = "" [String]

                        src = "" [String]

/>

                </controls>

                <tagMapping>

                    <add

                        mappedTagType = "" [String]

                        tagType = "" [String, Required, Collection Key]

/>

                </tagMapping>

            </pages>

-->

    <pages buffer="true" enableSessionState="true" enableViewState="true" enableViewStateMac="true" enableEventValidation="true" smartNavigation="false" autoEventWireup="true" pageBaseType="System.Web.UI.Page" userControlBaseType="System.Web.UI.UserControl" validateRequest="true" masterPageFile="" theme="" styleSheetTheme="" maxPageStateFieldLength="-1" compilationMode="Always" pageParserFilterType="" viewStateEncryptionMode="Auto" maintainScrollPositionOnPostBack="false" asyncTimeout="45">

      <namespaces autoImportVBNamespace="true">

        <clear />

        <add namespace="System" />

        <add namespace="System.Collections" />

        <add namespace="System.Collections.Specialized" />

        <add namespace="System.Configuration" />

        <add namespace="System.Text" />

        <add namespace="System.Text.RegularExpressions" />

        <add namespace="System.Web" />

        <add namespace="System.Web.Caching" />

        <add namespace="System.Web.SessionState" />

        <add namespace="System.Web.Security" />

        <add namespace="System.Web.Profile" />

        <add namespace="System.Web.UI" />

        <add namespace="System.Web.UI.WebControls" />

        <add namespace="System.Web.UI.WebControls.WebParts" />

        <add namespace="System.Web.UI.HtmlControls" />

      </namespaces>

      <controls>

        <add tagPrefix="asp" tagName="" namespace="System.Web.UI.WebControls.WebParts" assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" src="" />

      </controls>

      <tagMapping>

        <clear />

      </tagMapping>

    </pages>

    <!--

            <siteMap

                defaultProvider = "AspNetXmlSiteMapProvider" [String]

                enabled = "true" [true|false]

                <providers>

                    <add

                        name = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </providers>

            </siteMap>

-->

    <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">

      <providers>

        <clear />

        <add siteMapFile="web.sitemap" name="AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

      </providers>

    </siteMap>

    <!--

            <urlMappings

                enabled = "true" [true|false]

                <add

                    url = "" [String, Required, Collection Key]

                    mappedUrl = "" [String, Required]

/>

            </urlMappings>

-->

    <urlMappings enabled="true">

      <clear />

    </urlMappings>

    <!--

            <webControls

                clientScriptsLocation = "/aspnet_client/{0}/{1}/" [String, Required]

/>

-->

    <webControls clientScriptsLocation="/aspnet_client/{0}/{1}/" />

    <!--

            <webParts

                enableExport = "false" [true|false]

                <personalization

                    defaultProvider = "AspNetSqlPersonalizationProvider" [String]

                    <providers>

                        <add

                            name = "" [String, Required, Collection Key]

                            type = "" [String, Required]

/>

                    </providers>

                </personalization>

                <transformers>

                    <add

                        name = "" [String, Required, Collection Key]

                        type = "" [String, Required]

/>

                </transformers>

            </webParts>

-->

    <webParts enableExport="false">

      <personalization defaultProvider="AspNetSqlPersonalizationProvider">

        <providers>

          <clear />

          <add connectionStringName="LocalSqlServer" name="AspNetSqlPersonalizationProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

        </providers>

        <authorization>

          <deny verbs="enterSharedScope" users="*" />

          <allow verbs="modifyState" users="*" />

        </authorization>

      </personalization>

      <transformers>

        <clear />

        <add name="RowToFieldTransformer" type="System.Web.UI.WebControls.WebParts.RowToFieldTransformer" />

        <add name="RowToParametersTransformer" type="System.Web.UI.WebControls.WebParts.RowToParametersTransformer" />

      </transformers>

    </webParts>

    <caching>

      <!--

                <cache

                    disableMemoryCollection = "false" [true|false]

                    disableExpiration = "false" [true|false]

                    privateBytesLimit = "0" [number]

                    percentagePhysicalMemoryUsedLimit = "89" [number]

                    privateBytesPollTime = "00:02:00" [HH:MM:SS]

/>

-->

      <cache disableMemoryCollection="false" disableExpiration="false" privateBytesLimit="0" percentagePhysicalMemoryUsedLimit="89" privateBytesPollTime="00:02:00" />

      <!--

                <outputCache

                    enableOutputCache = "true" [true|false]

                    enableFragmentCache = "true" [true|false]

                    sendCacheControlHeader = "true" [true|false]

                    omitVaryStar = "false" [true|false]

/>

-->

      <outputCache enableOutputCache="true" enableFragmentCache="true" sendCacheControlHeader="true" omitVaryStar="false" />

      <!--

                <outputCacheSettings

                    <outputCacheProfiles>

                        <add

                            name = "" [String, Required, Collection Key]

                            enabled = "true" [true|false]

                            duration = "-1" [number]

                            location = "" [Any | Client | Downstream | Server | None | ServerAndClient]

                            sqlDependency = "" [String]

                            varyByCustom = "" [String]

                            varyByControl = "" [String]

                            varyByHeader = "" [String]

                            varyByParam = "" [String]

                            noStore = "false" [true|false]

/>

                    </outputCacheProfiles>

                </outputCacheSettings>

-->

      <outputCacheSettings>

        <outputCacheProfiles>

          <clear />

        </outputCacheProfiles>

      </outputCacheSettings>

      <!--

                <sqlCacheDependency

                    enabled = "true" [true|false]

                    pollTime = "60000" [number]

                    <databases>

                        <add

                            name = "" [String, Required, Collection Key]

                            connectionStringName = "" [String, Required]

                            pollTime = "60000" [number]

/>

                    </databases>

                </sqlCacheDependency>

-->

      <sqlCacheDependency enabled="true" pollTime="60000">

        <databases>

          <clear />

        </databases>

      </sqlCacheDependency>

    </caching>

    <!--

            <securityPolicy

                <trustLevel

                    name = "Full" [String, Required, Collection Key]

                    policyFile = "internal" [String, Required]

/>

            </securityPolicy>

-->

    <securityPolicy>

      <trustLevel name="Full" policyFile="internal" />

      <trustLevel name="High" policyFile="web_hightrust.config" />

      <trustLevel name="Medium" policyFile="web_mediumtrust.config" />

      <trustLevel name="Low" policyFile="web_lowtrust.config" />

      <trustLevel name="Minimal" policyFile="web_minimaltrust.config" />

    </securityPolicy>

    <!--

            <trust

                level = "Full" [String, Required]

                originUrl = "" [String]

                processRequestInApplicationTrust = "true" [true|false]

/>

-->

    <trust level="Full" originUrl="" processRequestInApplicationTrust="true" />

  </system.web>

</configuration>

Using IComparable and IComparer to sort by many child properties

noreply@blogger.com (Jessy Houle) — Fri, 19 Oct 2007 21:55:00 +0000

Below is parent Collection code used to allow sorting by many different child properties:

using System.Collections;
using System.Data;
 
namespace CARRS
{
    #region Sort Enumerations
 
    /// <summary>
    /// Lookup Collection Sort Column
    /// </summary>
    public enum LookupCollectionSortColumn
    {
        Id,
        SortNumber,
        Description,
        Code,
        Value
    }
 
    /// <summary>
    /// Lookup Collection Sort Direction
    /// </summary>
    public enum LookupCollectionSortDirection
    {
        Ascending,
        Descending
    }
 
    #endregion
 
    #region Lookup Collection
 
    /// <summary>
    /// Lookup Collection
    /// </summary>
    public class LookupCollection : ReadOnlyCollectionBase
    {
 
        #region Indexer
 
        public Lookup this[int index]
        {
            get { return this[index]; }
        }
 
        #endregion
 
        #region General Object Methods
 
        public int IndexOf(Lookup ob)
        {
            return IndexOf(ob);
        }
 
        public bool Contains(Lookup ob)
        {
            return Contains(ob);
        }
 
        public bool Contains(int id)
        {
            foreach (Lookup ob in this)
            {
                if (ob.Id == id)
                    return true;
            }
 
            return false;
        }
 
        #endregion
 
        #region Sort
 
        public void Sort(LookupCollectionSortColumn sortColumn, LookupCollectionSortDirection sortDirection)
        {
            IComparer ob = new LookupCollectionComparer(sortColumn, sortDirection);
            InnerList.Sort(ob);
        }
 
        public void Sort(LookupCollectionSortColumn sortColumn)
        {
            LookupCollectionComparer ob = new LookupCollectionComparer(sortColumn, LookupCollectionSortDirection.Ascending);
            InnerList.Sort(ob);
        }
 
        public void Sort()
        {
            InnerList.Sort();
        }
 
        #endregion
 
        #region Constructor
 
        public LookupCollection(IDataReader dr)
        {
            while (dr.Read())
            {
                Lookup ob = Lookup.GetLookup(dr);
                InnerList.Add(ob);
            }
        }
 
        #endregion
 
    }
 
    #endregion
 
    #region IComparer Implimentation
 
    /// <summary>
    /// Custom Lookup Collection Sort IComparer implimentation
    /// </summary>
    internal class LookupCollectionComparer : IComparer
    {
 
        private LookupCollectionSortColumn _sortColumn;
        private LookupCollectionSortDirection _sortDirection;
 
        public LookupCollectionComparer(LookupCollectionSortColumn sortColumn, LookupCollectionSortDirection sortirection)
        {
            _sortColumn = sortColumn;
            _sortDirection = sortirection;
        }
 
        public int Compare(object x, object y)
        {
            Lookup Comparer, Comparee;
 
            // define two objects, and sort direction switches their identity, thus switches order
            if (_sortDirection == LookupCollectionSortDirection.Ascending)
            {
                Comparer = (Lookup)x;
                Comparee = (Lookup)y;
            }
            else
            {
                Comparer = (Lookup)y;
                Comparee = (Lookup)x;
            }
 
            // add more columns as defined
            switch (_sortColumn)
            {
                case LookupCollectionSortColumn.SortNumber:
                    return Comparer.SortNumber.CompareTo(Comparee.SortNumber);
                case LookupCollectionSortColumn.Description:
                    return Comparer.Description.CompareTo(Comparee.Description);
                case LookupCollectionSortColumn.Code:
                    return Comparer.Code.CompareTo(Comparee.Code);
                case LookupCollectionSortColumn.Value:
                    return Comparer.Value.CompareTo(Comparee.Value);
                case LookupCollectionSortColumn.Id:
                    return Comparer.Id.CompareTo(Comparee.Id);
                default:
                    return 0;
            }
        }
    }
 
#endregion
 
}

Below is the child object code used by the parent. Notice that we still implement IComparable here as well, to allow for a default .Sort() call:

using System;
using System.Data;
 
namespace CARRS
{
    [Serializable]
    public class Lookup : IComparable<Lookup>
    {
        #region Private Members
 
        private int _id = 0;
        private string _code = string.Empty;
        private string _value = string.Empty;
        private string _description = string.Empty;
        private bool _isActive = true;
        private int _sortNumber = 0;
 
        #endregion
 
        #region Business Properties
 
        public int Id
        {
            get
            {
                return _id;
            }
        }
 
        public string Code
        {
            get
            {
                return _code;
            }
        }
 
        public string Value
        {
            get
            {
                return _value;
            }
        }
 
        public string Description
        {
            get
            {
                return _description;
            }
        }
 
        public bool IsActive
        {
            get
            {
                return _isActive;
            }
        }
 
        public int SortNumber
        {
            get
            {
                return _sortNumber;
            }
        }
 
        #endregion
 
        #region Overrides
 
        public override string ToString()
        {
            return _id.ToString();
        }
 
        public bool Equals(Lookup ob)
        {
            return _id.Equals(ob.Id);
        }
 
        public override int GetHashCode()
        {
            return (_id.ToString()).GetHashCode();
        }
 
        #endregion
 
        #region IComparable Implimentation
 
        public int CompareTo(Lookup ob)
        {
            return _sortNumber.CompareTo(ob.SortNumber);
        }
 
        #endregion
 
        #region Static Members
 
        internal static Lookup GetLookup(IDataReader dr)
        {
            Lookup ob = new Lookup();
            ob.Fetch(dr);
            return ob;
        }
 
        #endregion
 
        #region Constructor
 
        private Lookup()
        {
            // Prevent direct creation
        }
 
        #endregion
 
        #region Data Access
 
        private void Fetch(IDataRecord dr)
        {
            //TODO: if we don't use CSLA.Data.SafeDataReader we will have to validate
            _id = Convert.ToInt32(dr["ID"]);
            _code = dr["Code"].ToString();
            _value = dr["Value"].ToString();
            _description = dr["Description"].ToString();
            _isActive = Convert.ToBoolean(dr["IsActive"]);
            _sortNumber = Convert.ToInt32(dr["SortNumber"]);
        }
 
        #endregion
    }
}

Here is the class diagram for the above:

Open Source C++

noreply@blogger.com (Jessy Houle) — Tue, 24 Jul 2007 05:21:00 +0000

List of some of the best Open Souce projects written in VC++/MFC.

localhost SSL certificate

noreply@blogger.com (Jessy Houle) — Wed, 18 Jul 2007 22:27:00 +0000

Download and Install the SSL cert generator

Download the Xeno certificate generator at http://www.xenossoftware.com/freetools/certificategenerator/.
Install the software

Create an SSL certificate

Run the Xeno certificate generator

Start -> All Programs -> Xeno Certificate Generator -> Xeno Certificate Generator

Fill in the necessary fields and browse to C:\certificate.pfx for the output.

Click the [Generate Certificate] button

Import your cert into your personal certificate store

Open the certificate manager MMC

Start -> Run -> type: "certmgr.msc" -> click the [OK] button

Right click on the Personal folder
Choose All Tasks -> Import… from the context menu
Click Next

Browse to your newly created certificate. You may have to change the extension type to .pfx

Click the [Next] Button 3 times, and then the [Finish] button

You should receive a message box with "The import was successful."

Use your new certificate in IIS

Open IIS

Start -> Run -> type: "inetmgr" -> click the [OK]

Right click on Default Website
Choose Properties from the context menu
Click on the [Directory Security] tab

Click the [Server Certificate...] button
On the dialog box, that pops up click the [Next] button
Choose Assign an existing certificate and click the [Next] button
Your newly created certificate will be available, choose this certificate and click [Next]
Click the [Next] button and then the [Finish] button

Verify that 443 is the SSL Port

With the Default Web Site Properties dialog box still open, click on the [Web Site] tab

Test the SSL

Now open up you browser and open a page on your local IIS
Now change the URL to use HTTPS instead of HTTP

Simple DataSet (DataGrid) to Excel

noreply@blogger.com (Jessy Houle) — Fri, 22 Jun 2007 18:15:00 +0000

Below is a very simple DataSet (using a DataGrid) to Excel. The DataGrid, when rendered, is nothing more then an HTML Table. Microsoft Excel dose a great job of translating this to a worksheet.

TABLE == Excel Worksheet
TR == Excel Row
TD == Excel Cell

    private void DisplayPrimitiveExportReport(DataSet dsDataSet)
    {
        // clear out and set the response stream
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.Charset = "";
        Response.ClearContent();
        Response.ClearHeaders();
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("Content-Disposition", "attachment; filename=ExcelReport.xls");

        // set up the in mem datagrid
        DataGrid dg = new DataGrid();
        dg.DataSource = dsDataSet.Tables[0];

        dg.DataBind();

        // render the datagrid to HTML
        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        dg.RenderControl(htmlWrite);

        // output the HTML (from datagrid)
        Response.Write(stringWrite.ToString());
        Response.End();
    }

This same method can be used with Word (using a content type of "application/word").

Great looking WBT and/or CBT tool

noreply@blogger.com (Jessy Houle) — Mon, 11 Jun 2007 22:08:00 +0000

Recently a tech friend of mine turned me on to yet another code generator (Subsonic) to handle DAL creation. What impressed me most about the demo that he sent me was not necessarily the code generator itself, but rather the tool that was used to create the demo. This is one of the most clean looking demos I've seen. The product is BB FlashBack, and it's from a UK company. You can find out more information at: http://www.bbsoftware.co.uk/bbflashback.aspx. If you are into WBTs (Web Based Training) or CBTs (Computer Based Training), this has got to be in your bag of tools.

Hot Key

noreply@blogger.com (Jessy Houle) — Wed, 06 Jun 2007 04:09:00 +0000

For you hot-key lovers, AutoHotkey seems really promising. It allows for simple, yet powerful, programmatic scripting to perform send keys, run applications, provide status, and much more. The open architecture has spawned a script showcase. Very powerful and handy.

Also, there is a great write-up and macro for obtaining a printout of all of your Visual Studio hotkeys by the author of Coding Horror.

Web 2.0 PDF conversion

noreply@blogger.com (Jessy Houle) — Wed, 06 Jun 2007 01:11:00 +0000

There is a new Web 2.0 PDF conversion service called KoolWIRE

(From the website):
Koolwire File Conversion Services are as easy as counting 1-2-3:

Choose the file format output/e-mail address from the list

Attach your file

Check your inbox for the incoming KOOLverted file

You can attach multiple files, no matter their size, provided their extension is allowed (see right). Should you exceed the maximum size set by your e-mail provider, try and split your attachments into multiple e-mails.

Scrolling DIV

noreply@blogger.com (Jessy Houle) — Tue, 05 Jun 2007 22:54:00 +0000

One very handy way to scroll content of any kind in HTML is a scrolling div.

<div style="overflow:auto; position:relative; width:150px; height:50px;">
    line 1<br>
    line 2<br>
    line 3<br>
    line 4<br>
    line 5<br>
    <b>testing bold</b><br>
    <u>testing underline</u><br>
</div>

AppleTV - tech podcasts

noreply@blogger.com (Jessy Houle) — Sun, 03 Jun 2007 07:31:00 +0000

I just purchased an AppleTV and canceled my DirecTV subscription. I was hesitant at first, but just after a day, I know that I made the right decision. The FREE content available for my wife, kids, and I are staggering. Some of the tech video podcasts that I'm subscribing to are:

CNET TV

commandN

Diggnation

dl.tv

Hak5

MAKE Magazine

PaulDotCom

Webnation

Please comment on other tech podcasts that you know of.

Loop through all controls on an ASP.NET Web Form

noreply@blogger.com (Jessy Houle) — Thu, 31 May 2007 22:56:00 +0000

I was amazed to find that Microsoft didn't put all controls in the Page.Controls collection. They have followed more of a hierarchy pattern, where a page control has other controls, which may have other controls, which... You get the idea. This makes sense, especially if you've created any server controls yourself. However, this dose make it a bit harder to loop through every control on a page. The below is what I came up with, and I would be interested to see others.

private Control[] GetControls(ControlCollection parent, ref ArrayList controls)
{
    foreach (Control c in parent)
    {
        controls.Add(c);

        if(c.Controls.Count > 0)
        {
            GetControls(c.Controls, ref controls);
        }
    }

    return (Control[])controls.ToArray(typeof(Control));
}

...

ArrayList ar = new ArrayList();
Control[] ControlArray = GetControls(Page.Controls, ref ar);