Workflow

I have created a Workflow system that enables work to be received, processed and despatched as one seamless progression. All SQL Server database transactions are performed using Entity Framework and LINQ to SQL Classes.
The system consists of the following modules:-

1. A clustered Windows service that monitors a list of folders for file arrivals. Each file is associated with a job number using a combination of the arrivals folder and file-name.
    A row is added to a Work database table for each file. Each job has a set of processes stored in the database. Each file is zipped and stored in a data-store.

2. A clustered Windows service that monitors an Inbox using Exchange Web Services for emails containing file attachments. Files are booked in using the job number in the subject of the email.

3. Two Windows Forms applications run on as many workstations as is required. One executes bespoke applications, the other handles standard tasks like unzipping, file-copying and emailing. Both apps poll the database periodically to request work to run.

4. Two web-front-ended applications have been implemented to provide a schedule of work and an administration panel for CRUD database operations. These Web apps use C#, MVC, Razor, Javascript and Entity Framework.

---