About SkyComm

About the SkyComm Resource Portal

SkyComm is a conceptual company that provide leased intergated communication systems to fixed base operators at global airport locations. The SkyComm Resource Portal is a corporate intranet web application used by SkyComm employees for tracking resources and monitoring key performance indicators. The monitored resources are:

• Airports served by SkyComm
• Communications equipment provided to customers or operated by SkyComm
• Corporate office location and their assigned personnel

About the SkyCommCoreMVC web application project

The SkyCommCoreMVC web application is being developed as a demonstration project. It is a multi-tier application having layers for domain, data, services, and presentation. The dependency injection design pattern is used throughout the application.

• The domain layer contains the data models that were created by using the Entity Framework Core Database First for SQL Server process.
• The data layer uses the repository design pattern to process the data represented by the domain models. Each repository class has a related interface.
• The service layer provides the data, and any needed business logic, to the presentation layer. Each service class has a related interface.
• The presentation layer uses the MVC and MVVM design patterns. Each controller uses a dedicated service for building the required view models, which are then passed to their related views.

The application is deployed to Azure as both a Web App and a Container App.

Some of the technologies used in the application are:

• Microsoft .NET Framework 7.0
• Microsoft ASP.NET Core 7.0
• Microsoft Entity Framework Core 7.0
• C#
• Razor
• SQL
• LINQ
• JSON
• Bootstrap / Bootswatch

The environment used to develop and host the application include:

• Microsoft Visual Studio 2022 Community Edition
• Microsoft SQL Server Management Studio 18
• Microsoft Azure
• Docker
• Microsoft SQL Server Migration Assistant for Access
• Microsoft Visio
• LINQPad 7

The code repository for the project can be viewed here.

A video demonstration of the project can be viewed here.

Please note that this version of the application is intended to only demonstrate viewing capabilities of the portal's data. The ability to create, edit, or delete data is not implemented in this version of the application.