Defining the Solution

The new system will be named Invoicer.NET, and will consist of several parts. The core of the new system will be an OrderProcessor component that will run on the server, reading information from the Excel file and committing it to a record in the SQL Server database. This component will run continuously on a server computer and will be implemented as a Windows service. This component is used in both the first and second stage of the design.

Of course, the client won’t interact directly with the OrderProcessor component. Instead, the sales manager will receive the e-mail and forward the spreadsheet to the OrderProcessor. Figure 16-1 diagrams the first iteration of the system. Notice that the sales manager just copies the e-mail ...

Get Microsoft® .NET Distributed Applications: Integrating XML Web Services and .NET Remoting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.