Footloose Financial Services

Check out the .NetCore 2.0 version of the client web site at https://github.com/pcarrasco23/FootlooseFinancialServicesNetCore

Simple banking and management system built on the .NET Framework using C#, SQL Server, Entity Framework, MongoDB, WCF, WebAPI, AngularJS, and ASP.NET MVC

User facing web sites:

• FootlooseFS.Web.Client: Client facing web site built with AngularJS 2
• FootlooseFS.Web.AdminUI: Management portal built with ASP.NET MVC 5 application

Back-end web services:

• FootlooseFS.Web.Service: WebAPI RESTful back-end service for client facing site
• FootlooseFS.EnterpriseService: WCF back-end service for management portal

DLL projects for back-end web services

• FootlooseFS.Service: interface to service layer for database and business logic

• FootlooseFS.DataPersistence: data access layer for SQL using Entity Framework 6

• FootlooseFSDocumentDBETL: Utility program to create the MongoDB database and load it with data from the SQL MDF file

• \Data\FootlooseFS.mdf - SQL Server data file

How to Build

• To build from Visual Studio, open the solution FootlooseFS.sln file in Visual Studio 2015 or higher and build. This solution uses NuGet packages so your installation of Visual Studio must have the NuGet Package manager installed.

• To run the unit and integration tests from within Visual Studio you will need to install the NUnit3 Test Adapter and restart Visual Studio

Download and install runtime dependencies

Running the client facing web site requires SQL Server Express LocaleDB 2014 or higher and IIS Express 10.0

• Download and install SqlLocalDB.msi from the download for [SQL Server Express LocalDB 2014] (https://www.microsoft.com/en-us/sql-server/sql-server-downloads)

• Create a LocalDB instance called FootlooseDb:

  • Open a command prompt and go to "C:\Program Files\Microsoft SQL Server\120\LocalDB\Binn"
  • Enter the command: sqllocaldb create FootlooseDb

• Download and install [IIS 10.0 Express] (https://www.microsoft.com/en-us/download/details.aspx?id=48264)

In addition to run the Management portal you will need MongoDB 3 for Windows

• Download and install [MongoDB windows] (https://www.mongodb.com/download-center#community)
  • Review the installation instructions [here] (https://docs.mongodb.com/manual/tutorial/install-mongodb-on-windows/)
  • To make runnning MongoDB easier you will want to run it as a Windows service
  • Be sure to review the README file and create a directory for the data file and update the mongodb.cfg file with the location of the data file
  • If you need to change the default MongoDB port you will have to update the MongoDB configuration in the FootlooseFS.EnterpriseService and FootlooseFSDocumentDBETL projects.

How to Run Client facing web site

• (Only have to do this once) Open the file FootlooseFS.Web.Service/web.config

  • Change the app setting "DataDirectory" to your specific location of the "FootlooseFinancialServices\Data" folder with the MDF file.

• To start the WebAPI service open a command window and enter "C:\Program Files\IIS Express\iisexpress" /path:C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.Web.Service /port:9095

  • Replace "C:\Users\Peter\Source\Repos" with your specific location of the Visual Studio project

• To start the AngularJS web site open a command window and enter "C:\Program Files\IIS Express\iisexpress" /path:C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.Web.Client /port:9092

  • Replace "C:\Users\Peter\Source\Repos" with your specific location of the Visual Studio project

• Open a web browser and go to http://localhost:9092

• Enter "avenere" for the user name and "avenere1" for the password" and click the Submit button.

The AngularJS web site uses the WebAPI web site for the data service. By default it communicates to the service on port 9095 but that can be modified in the file C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.Web.Client\config.js

How to Run the Management portal

These 3 steps only have to be run once before running the portal

• Open the file FootlooseFS.EnterpriseService/web.config

  • Change the app setting "DataDirectory" to your specific location of the "FootlooseFinancialServices\Data" folder with the MDF file.

• Open the file FootlooseFSDocumentDBETL/app.config

  • Change the app setting "DataDirectory" to your specific location of the "FootlooseFinancialServices\Data" folder with the MDF file.

• From Visual Studio set the startup project to FootlooseFSDocumentDBETL and run the program.

  • This will create the MongoDB database footloosefs and load it with data from the SQL MDF file

• To start the WCF service open a command window and enter "C:\Program Files\IIS Express\iisexpress" /path:C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.EnterpriseService /port:9096

  • Replace "C:\Users\Peter\Source\Repos" with your specific location of the Visual Studio project

• To start the Management port ASP.NET MVC 5 web site open a command window and enter "C:\Program Files\IIS Express\iisexpress" /path:C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.Web.AdminUI /port:9093

  • Replace "C:\Users\Peter\Source\Repos" with your specific location of the Visual Studio project

• Open a web browser and go to http://localhost:9093

• Enter "admin" for the user name and "admin1" for the password" and click the Submit button.

The Management portal web site uses the WCF web service for the data service. By default it communicates to the service on port 9096 but that can be modified in system.serviceModel client endpoint URL in the file C:\Users\Peter\Source\Repos\FootlooseFinancialServices\FootlooseFS.Web.AdminUI\web.config

Why are there 2 web sites?

The Management portal is for employees of the Footloose Financial services who are in charge of updating or adding new account holders (clients). The Client-facing web site is for the client or account holder of the financial institution to view or update his/her information.

Why does each web site consist of 2 separate web sites - front-end and back-end?

Scalability and security. The back-end web service can be scaled separately from the web site to meet demand. Also the back-end service can be hosted behind the company's firewall for better protection since it has direct access to the company's critical consumer data.

Why are we using the Express versions of SQL Server and IIS?

To get the web sites up and running easier for developers. We can focus more on the code and less on the server administration. However using the enterprise versions of SQL Server and IIS against these web sites would be trivial and not require any code changes.

Why are we using MongoDB for the WCF service?

MongoDB is a NoSQL document database that provides optimal performance for querying large datasets. It is used in the Management Portal for querying customer data. If Footloose were to grow and have 10 million customers, querying highly normalized customer data in a relational SQL database could be very slow. Storing the customer data in MongoDB provides sub-second query performance against millions of records which could be used for developing analytic interfaces in the portal.

The main challenge however is syncing any updates in the SQL master database with data in the MongoDB database.