For professional health providers who need to concentrate on providing the best solution to patient's health problems, the Medical Facility Manager is a health information management system that provides a single point of access to the practice information to providers, patients and vendors. The system will store all internal and external transactions within the facility by keeping record of every interaction between patients and providers including accounting. The system will save facilities 40 percent of clerical costs in the first year of use by allowing patients to self-register, schedule appointments and retrieving tests results online. Furthermore it will allow facilities to save on accounting costs since it implements claims, billing, payroll and general accounting tasks by using The Accounting Engine. Unlike the current antiquated systems with poor security record and insecure slow manual systems, Medical Facility Manager implements state of the art security and backup sub-systems and will comply with federal and state government security and reporting requirements.

One of the advantages of open source software is that it assist in troubleshooting and solving errors in your application.

Recently I ran into the following problem with ASP.NET MVC 2.0 RC.

After some searching I found the following post:

ASP.NET MVC 2 problem with UpdateModel

I downloaded the ASP.NET MVC 2 RC source code, extracted the zip file, located the offending method and commented out the problem:

    public sealed class FormCollection : NameValueCollection, IValueProvider {

        public FormCollection() {
        }

        public FormCollection(NameValueCollection collection) {
            if (collection == null) {
                throw new ArgumentNullException("collection");
            }

            Add(collection);
        }

        public ValueProviderResult GetValue(string name) {

Commented Code
            //if (String.IsNullOrEmpty(name)) {
            //    throw new ArgumentException(MvcResources.Common_NullOrEmpty, "name");
            //}

            string[] rawValue = GetValues(name);
            if (rawValue == null) {
                return null;
            }

            string attemptedValue = this[name];
            return new ValueProviderResult(rawValue, attemptedValue, CultureInfo.CurrentCulture);
        }

        public IValueProvider ToValueProvider() {
            return this;
        }

        #region IValueProvider Members
        bool IValueProvider.ContainsPrefix(string prefix) {
            return ValueProviderUtil.CollectionContainsPrefix(AllKeys, prefix);
        }

        ValueProviderResult IValueProvider.GetValue(string key) {
            return GetValue(key);
        }
        #endregion

        private sealed class FormCollectionBinderAttribute : CustomModelBinderAttribute {

            // since the FormCollectionModelBinder.BindModel() method is thread-safe, we only need to keep
            // a single instance of the binder around
            private static readonly FormCollectionModelBinder _binder = new FormCollectionModelBinder();

            public override IModelBinder GetBinder() {
                return _binder;
            }

            // this class is used for generating a FormCollection object
            private sealed class FormCollectionModelBinder : IModelBinder {
                public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext) {
                    if (controllerContext == null) {
                        throw new ArgumentNullException("controllerContext");
                    }

                    return new FormCollection(controllerContext.HttpContext.Request.Form);
                }
            }
        }

    }
}

After the solution was built,  I copied the output to the Libraries folder of the application:

Removed the existing reference to System.Web.Mvc from the MVC Application and created a reference the the System.Web.Mvc in the Libraries folder.

Then I commented out the  System.Web.Mvc GAC-version reference from web.config:

<compilation debug="true">
    <assemblies>
        <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Web.Abstractions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <!--<add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" />-->
        <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
    </assemblies>
    <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </buildProviders>
</compilation>

and updated the /Views/web.config: (Replaced PublicKeyToken=31bf3856ad364e35 with PublicKeyToken=null)

 <pages validateRequest="false"
          pageParserFilterType="System.Web.Mvc.ViewTypeParserFilter, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null, processorArchitecture=MSIL"
          pageBaseType="System.Web.Mvc.ViewPage, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null, processorArchitecture=MSIL"
          userControlBaseType="System.Web.Mvc.ViewUserControl, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null, processorArchitecture=MSIL">
      <controls>
          <add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null, processorArchitecture=MSIL"
               namespace="System.Web.Mvc" tagPrefix="mvc" />
      </controls>
  </pages>      
<!--<pages validateRequest="false" 
       pageParserFilterType="System.Web.Mvc.ViewTypeParserFilter, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" 
       pageBaseType="System.Web.Mvc.ViewPage, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" 
       userControlBaseType="System.Web.Mvc.ViewUserControl, System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
  <controls>
    <add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" 
         namespace="System.Web.Mvc" tagPrefix="mvc" />
  </controls>
</pages>-->

This morning when I turned on my development computer I had the intention to re-factor some WPF user controls but every time I tried to open any of them in the designer Visual Studio 2008 will crash without any warning.

When I opened the Application error log I found the following message: 

Log Name:      Application
Source:        .NET Runtime
Date:          3/26/2009 11:07:53 AM
Event ID:      1023
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SRV.Dev.CyberBizSoft.com
Description:
.NET Runtime version 2.0.50727.3074 - Fatal Execution Engine Error (70FC5FC0) (80131506)
Event Xml:
<Eventxmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
        <ProviderName=".NET Runtime" />
        <EventID Qualifiers="0">1023</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2009-03-26T15:07:53.000Z" />
        <EventRecordID>186149</EventRecordID>
        <Channel>Application</Channel>
        <Computer>SRV.Dev.CyberBizSoft.com</Computer>
        <Security/>
    </System>
    <EventData>
        <Data>.NET Runtime version 2.0.50727.3074 - Fatal Execution Engine Error (70FC5FC0) (80131506)

</Data>
    </EventData>
</Event>

After some online searching I found the following thread with this link to a hotfix to this problem. 

Earlier I posted about this problem I had with NHibernate, SQL CE 3.5.1.0 & ClickOnce. Well I found a workaround and it is very simple.

Instead of setting the "System.Data.SqlServerCe" reference property "Copy Local" to True,  when you are ready to deploy, set that reference property to false and on the ClickOnce Publish menu click on the "Application Files" button and change it from "Prerequisite (Auto)" to "Include".

You still have to set the "System.Data.SqlServerCe" reference property "Copy Local" to True while debugging your application locally for Nhibernate to work properly.

Remember to set it to false before publishing your application if not ClickOnce will remind you with the dreaded System.ArgumentException when launching the application.

Found Workaround!

I had wasted so much time with this ClickOnce error that I decided to create a new project and copy everything from the "bad" project and recreate all the references.

The deployment to ClickOnce worked fine but as soon as I logged into the application I got the following error from NHibernate:

The type initializer for 'CBSI.GL.Application.GLSetupService' threw an exception. (InnerException: Could not create the driver from NHibernate.Driver.SqlServerCeDriver.) (InnerException: Exception has been thrown by the target of an invocation.) (InnerException: The IDbCommand and IDbConnection implementation in the assembly System.Data.SqlServerCe could not be found. Ensure that the assembly System.Data.SqlServerCe is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.)!

I had forgotten in the new project that with NHibernate you need to set the "System.Data.SqlServerCe" reference property "Copy Local" to True. As soon as I compiled and tested the debugging local copy it worked fine but when I deployed to ClickOnce the System.ArgumentException was back.

Since I noticed that I had a compiler warning and NHibernate.Driver.SqlServerCeDriver exception message say to "use <qualifyAssembly/> element" I added the following to my app.config:

<runtime>
    <assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentassembly>
            <assemblyidentity culture="neutral" publickeytoken="89845dcd8080cc91" 

name="System.Data.SqlServerCe" />
            <bindingredirect newVersion="3.5.1.0" oldVersion="3.5.0.0" />
        </dependentassembly>
        <qualifyAssembly partialName="System.Data.SqlServerCe" 

fullName="System.Data.SqlServerCe,version=3.5.1.0,publicKeyToken=89845dcd8080cc91,culture=neutral"/>
    </assemblybinding>
</runtime>    

It didn't work either!

I found the culprit, SQL CE 3.5.1.0 but apparently it is either ClickOnce or NHibernate with .NET 3.5 SP1.

If someone has a workable solution please let me know!

Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination are omnipotent. The slogan press on has solved and always will solve the problems of the human race.  No person was ever honored for what he received. Honor has been the reward for what he gave.

(John) Calvin Coolidge

My name is Santos Ray Victorero, II, I am a software developer, architect and consultant specializing in building customized business solutions. I have worked with computers since 1981 and have a Bachelor’s degree in Electrical Engineering from Florida Atlantic University.

Over the past twenty-years some of the technologies I have worked with include mainframes, minicomputers and microcomputers.  I have also developed several business applications including Payroll Systems, Point-of-Sale applications, School Management Systems, Private Investigation tools, Inventory Systems, Cargo Managers, etc…

Since September of 2000 I have been developing applications using the .NET Framework (alpha version). In 2001 I began working on a business framework that makes it easier to create customized business solutions.

My hobbies include music, reading and boating.  I mostly read books about business, software architecture and programming but I love to read anything as long as it is interesting.

The CyberBizSoft Inc.'s Enterprise Business Accounting Framework (CBSI-EBA Framework) is a baseline Service Oriented architecture for developing customized business applications that is composed of several business components:

•  CBSI-EBA Accounting Engine^TM
•  CBSI-EBA Business Tools^TM
• CBSI-EBA Master Sets^TM

Just as the Accounting Process  also called the Accounting Cycle the CBSI-EBA Framework consist of several parts for:

• Accumulating and Classifying Information
• Recording and Processing Transactions
• Reporting Financial Information   

The CBSI-EBA Accounting Engine^TM is a transaction processor that receives transactions from customized CBSI-EBA Business Tools^TM or other, anywhere, anytime and from any client in the enterprise validates and post them to the General Ledger. In other words the CBSI-EBA Accounting Engine^TM  is a distributed or online General Ledger that also exposes its content through the standard Financial Statements and other reports.

CBSI-EBA Business Tools^TM are customizable transaction generators that represent the money exchanges between the several entities of the enterprise; Disbursements, Receipts, Point of Sale/Service, Purchasing, Billing, Payroll, etc.

CBSI-EBA Master Sets^TM are customizable data collectors that are designed to help with the accumulating and classifying of information and they represent the entities of the enterprise; Customers, Vendors, Employees, Taxes, etc.

Since all business are not created equal one size does not fit all!

The Accounting Engine has a set of addressing components that include Countries, States/Provinces, Zip/Regions, etc. The back-end of these components is composed of WCF (Windows Communication Foundation) services, business logic, data access repository (DAO) and an O/R mapper (NHibernate). I have a Smart Client to maintain those components but eventually I want to be able to use AJAX as Web Client in the future. The problem is that AJAX does not support WCF yet and it only supports ASMX services. (Complete support for WCF Services will be provided with .NET 3.5)

 Since I want to be able to maintain those components using AJAX now, I have implemented ASMX client services (aggregators) that make synchronous requests to the WCF services.

 For the benefit of those that find themselves in the same situation I will provide an outline of the steps I performed while creating the CountryService aggregation.

 First I created an ASMX Web project and added references to the Data Contract and Service Contract projects and to the System.Web.Extensions dll.

 Then I added a using System.Web.Script.Services; statement and the following Attributes:

[ScriptService]

[GenerateScriptType(typeof(CountryData))]

[GenerateScriptType(typeof(CountryListData))]

 I also added the ICountryService interface (service contract) to the Web Service class:

 public class CountryService : WebService, ICountryService

 generated the stubs for the ICountryService and added the WebMethod attributes:

 …

[WebMethod]

public CountryData Save(CountryData data)

{

throw new Exception("The method or operation is not implemented.");

}

 [WebMethod]

public void Delete(int countryID)

{

throw new Exception("The method or operation is not implemented.");

}

…

 Now I needed a typed proxy to access the WCF service and I created that from a Visual Studio command prompt using the following command:

 wsdl /n:CyberBizSoft.Common.Services /o:CountryClient.cs /urlkey:CountryClientAddress http://localhost:1218/common/countryservice.svc?wsdl

 After including the generated file in the project I created a class variable reference to the WCF CountryService:

 CountryClient mClient = new CountryClient();

 Then added the code to all the interface stubs:

 …

[WebMethod]

public CountryData Save(CountryData data)

{

   return mClient.Save(data);

}

 [WebMethod]

public void Delete(int countryID)

{

   mClient.Delete(countryID);

}

 …

Finally I added the following to the web.config to specify the endpoint to communicate with:

 <appSettings>

<add key="CountryClientAddress" value="http://localhost:1218/common/countryservice.svc"/>

appSettings>

 Now I can access the services from AJAX!