XML Windows Service

Create a Windows Service using VB.NET that will request an XML file from a? .net web? service, validate the XML file against an XSD, write the XML to a SQL Database using an XSD mapping file, then upon successful writing, send an XML file to a web service to indicate that the XML file has been successfully transmitted.? The windows service must have a configurable request interval and must write to a the Windows event log with a custom event log to record requests/validations/uploads/errors.? The Windows Service must be able to request XML files from multiple sources that are configurable via an XML file that contains a list of the XSD locations. Coder is to provide a generic sample and will create the web services, the XML and XSD files, and the SQL Database using SQL Server or SQL Express and the Northwind Database.? .NET 3.5 framework is to be used for web services. ## Deliverables Here are the additional requirements that the project must meet: The project will use the Microsoft Northwind Database In the Northwind Database, add a column to the Customers Table called NewRecord. This column will be a bit field with a default value of 1. This field will be used to identify customer records that are newly added to the Customers table. Update all existing customer records in the Customers table so that the NewRecord field has a value of 1. In the Northwind database, add a column to the Orders table called NewRecord. This column will be a bit field with a default value of 1. This field will be used to identify order records that are newly added to the Orders table. Update all existing order records in the Orders table so that the NewRecord field has a value of 1 Copy the Northwind database and create as a new Database called InfoTech in SQL Server. Copy all the tables into the InfoTech database, but only include the table structure from the Orders and Customers table. This database should be an exact duplicate of the Northwind database but not contain any records in the Orders and Customers tables. Add an additional field called CustomerKey to the Customer table, and OrderKey to the Orders table in the InfoTech database, which will be a foriegn key to the Customers and orders tables respectively, in the Northwind database. Create a web service that Provides a GetNewCustomerRecords() function, whose purpose is to query the Customers table in the Northwind database and return all Customer records that have the NewRecord flag set to 1, as an XML file. This XML file should contain the primary key of each customer record passed in the xml file. Create an XML Schema file that matches the structure of the Customers table in the Northwind database. This XSD file will be used to validate the XML files that are being retrieved from the GetNewCustomerRecords() function. Create a web service that provides a UpdateCustomerRecords() function, that accepts an XML file containing the primary key of the Customers table as the CustomerKey value from the Customers table in the InfoTech Database. This function will take the XML entries and set the NewRecord field to 0 (zero) for all records in the Northwind Customers table whose primary key is found in the XML passed to this function Create a web service that Provides a GetNewOrderRecords() function, whose purpose is to query the Orders table in the Northwind database and return all order records that have the NewRecord flag set to 1, as an XML file. This XML file should contain the primary key of each order record passed in the xml file. Create an XML Schema file that matches the structure of the Orders table in the Northwind database. This XSD file will be used to validate the XML files that are being retrieved from the GetNewOrderRecords() function. Create a web service that provides a UpdateOrderRecords() function, that accepts an XML file containing the primary key of the Orders table as the OrderKey value from the Orders table in the InfoTech Database. This function will take the XML entries and set the NewRecord field to 0 (zero) for all records in the Northwind Orders table whose primary key is found in the XML passed to this function Create a Windows Service that will call the GetNewCustomerRecords() and GetNewOrderRecords() web services on a regularly scheduled interval. The interval must be configurable from an XML file that can be read by the Windows Service. The windows service must include a custom log that writes to the Windows Event Log. The basic functionality of the service must be as follows: 1. At a regular interval, the windows service will execute the GetNewCustomerRecords web request, which will query the web service for an xml file containing all new customer records - that is customer records from the Northwind Customers table that have a NewRecord field value of 1. 2. The service will validate the XML file returned by the GetNewCustomerRecords web request using an XSD schema file that was previously created. 3. If the XML file fails validation, an error entry will be written to the custom event log in the Windows Event log, and the process will abort 4. If the XML passes validation, the data from the XML file will be written to the Customers table in the InfoTech database, using an XSD mapping file that the coder will create, for this purpose. 5. Upon successful write to the Customers table, the UpdateCustomerRecords web service will be called, which will return an XML file containing the CustomerKey from the InfoTech Customers table for each record that was added to the InfoTech Customers table in step 4. THis XML file will only contain the CustomerKey for newly added records 6. The UpdateCustomerRecords function will update Customer Records in the Northwind Customers table, to set the NewRecord value to zero, for all records that are passed by the XML file in step 5. 7. The windows service will next execute the GetNewOrderRecords web request, which will query the web service for an xml file containing all new order records - that is order records from the Northwind orders table that have a NewRecord field value of 1. 8. The service will validate the XML file returned by the GetNewOrderRecords web request using an XSD schema file that was previously created. 9. If the XML file fails validation, an error entry will be written to the custom event log in the Windows Event log, and the process will abort 10. If the XML passes validation, the data from the XML file will be written to the Orders table in the InfoTech database, using an XSD mapping file that the coder will create for this purpose. 11. Upon successful write to the Orders table, the UpdateOrderRecords web service will be called, which will return an XML file containing the OrderKey from the InfoTech Orders table for each record that was added to the InfoTech Orders table in step 10. THis XML file will only contain the OrderKey for newly added records 12. The UpdateOrderRecords function will update Order Records in the Northwind Orders table, to set the NewRecord value to zero, for all records that are passed by the XML file in step 11. 13. The process should repeat at the regularly scheduled interval. The primary and foriegn key matches are as follows: [login to view URL] = [login to view URL] [login to view URL] = [login to view URL] The final deliverable will include the Source and Installation files for the windows service and web services created, in addition to the XML, and XSD files created for the project. All coding is to be done in VB.NET only, and must be compatible with Visual Studio 2008 and the .NET 2.0 framwork and higher, and must run on both Windows XP SP2 and Windows Small Business Server 2003 Standard platforms.