P26 - Modify Tiered Enterprise Framework Web Services using VS2013 C#

I have an existing VS 2013 solution that is tiered and utilises the Microsoft Enterprise Library and based on MS standard patterns and practices. It generates 2 services with a SQL workflow database with integrated editing forms locally from the SQL 2012. These show how the code works to deliver an editable form using the service including workflow using C#. No data exists other than lookup tables so I can supply as scripts. The primary objective is to generate secure and filtered services that can be consumed by external web or mobile apps. Source code will be supplied in two separate solutions as the code base infrastructure. The project will be managed in Microsoft TFS online which integrates with VS 2013 for code synchronisation. You require a Microsoft LIVE account for this. Other requirements include an excellent working knowledge of MS SQL, TFS (Agile), C#, Services, WebAPI2, MVC4+ is essential and a working knowledge of the Enterprise Library is desirable. Small SQL databases have been generated that represent logical business/application units (eg DB1 (DB1 parent admin) vs DB2a (shared lookup tables e.g. Countries) vs DB2b (client information) vs DB3 (client projects and tasks). This helps isolate static non-sensitive data to dynamic sensitive data. The advantages to the developer are that Views that help display or filter data are organised with each database. Views must be integrated as C# for faster execution and field decryption. Tables are structured in the following ways; the first division is data vs domain (lookup tables). The second division is structural, single or multiple hierarchy vs standalone. All tables share a common id and each row has a row GUID which is required as a second primary key for child tables. The database server is within the same domain and location as the IIS server that will host this resource. The services for data tables must be capable of secure two-way databinding. Data processed by applications will be encrypted (128bit) prior to it SQL storage. Standard FORMS construction for editing against these services is NOT required for this project. An [login to view URL] solution is needed for online for system administration. Relevant business and other logic should be integrated into the tier or as new solutions where required. This interface is required to perform system management tasks through a tabbed dashboard. It also needs to show system statuses and enables management of critical settings e.g. HTTPS enabled etc, connection strings and service publication control. This resource requires 2 roles; Host and Client Admin. The Client Admin role is to enable access by approved Client IT staff to check the status of the databases and services through a tabbed dashboard. An [login to view URL] and an [login to view URL] sample website solutions need to be generated that are MVC4+ and normal ASP.NET 4.x. The samples are required for the editing of various data types based on the table types and structures mentioned above. The sample edit forms need to demonstrate data basic two-way data bound controls for radio, checkbox (multiple CSV e.g. 1,2,3), drop downs, textboxes (255 and Max) and short and long datetime. The View services will be read only and secured and filtered by single or multiple roles that can be defined in the C#. A sample drop-down filtered grid and listview which includes a multiple contains textbox search filter and Boolean radio and multiple checkbox filter is also required. The dropdown filter also needs to have include a hierarchical dependant combo. The proposed UI controls will be Angular X-Editable, however the Telerik suite or Standard MS controls may be used. The interface should not postback and utilise Async where practical. The pages must be stateful, especially the stateless MVC. Provide documentation or media to know what is required to modify schemas, regenerate controllers, forms, views, data and view services etc. The can be written or as mp4 videos.