The customer is a large Russian Federal Agency that is proactively using public purchases in its business activity.
The customer was faced with new legislative regulations that imposed strict requirements on procurement process. The breach of regulations may result in procurement results' protestation and cancellation.
The procedures used customer personnel to prepare procurement documents were not automated. All documents were made by manually using Microsoft Office: requests for proposal - in Microsoft Word, main stages were tracked in Microsoft Excel, reports were written by hand on pre-printed forms.
Considering new rules that mainly set up new time-constraints and restricted procedures execution, the customer could not rely upon old outdated practices any longer as they might result in transactions cancellation and financial loss.
Also the system was designed to be easily extended to support new methods of procurements that were introduced by new legislation.
The solution was designed as a web part for Microsoft SharePoint Portal Server 2003 and is a typical 3-layered application.
Microsoft SQL Server 2000 and xml configuration files are used for storing data. Data management is implemented using stored procedures and a separate layer for data access. Business functions, such as data verification and reports generation, are performed by business logic layer. A separate system service sends automatic e-mail notifications about business events in the system. Visual part of the application is presented by the set of ASP.NET controls, consolidated into a single SharePoint Portal Server module.
A special feature of the system is usage of template files to generate report documents in MS Word и Excel formats. Interaction with MS Office applications is performed using standard Office API и .NET Framework.
