arnab-developer / medicalsystem

Personal medical system.

Medical system

Medical system is a small application build with ASP.NET 5 and EF to document medical records. User can store doctor, patient and consultation information in this application with their web browser. This is a proof of concept of how we can use microservice with ASP.NET 5.

This is influenced by .NET Microservices Sample Reference Application

CI CD status

Module	Status
Doctor service
Patient service
Consultation service
Web gateway
Web mvc
Doctor sync job
Patient sync job
Health check dashboard

Tech stack

Module	Tech
Backend apis	ASP.NET 5 gRPC service
Gateway	ASP.NET 5 Web Api
Frontend web application	ASP.NET 5 MVC
Jobs	Azure function
Database access	Entity Framework
Database	SQL Server
Unit test	NUnit

Architecture diagram

Docker images

This app is in docker images and stored in dockerhub.

Images	Dockerhub	Version
Doctor service	https://hub.docker.com/r/45862391/doctorservice
Patient service	https://hub.docker.com/r/45862391/patientservice
Consultation service	https://hub.docker.com/r/45862391/consultationservice
Web gateway	https://hub.docker.com/r/45862391/webgateway
Web mvc	https://hub.docker.com/r/45862391/webmvc

Hosting

When a new release is created then this app is stored inside a docker image and push to docker hub through CI CD. Hosting in Azure is not done as a part of CI CD. That needs to be done manually.

• Create a new resource group in Azure
• In that resource group create the following resources
  • App Service Plan for Linux
  • Web App for Doctor service, Patient service, Consultation service, Web Gateway and Web Mvc
  • SQL Server
  • Database for Doctor service, Patient service and Consultation service
• Create tables in the databases for Doctor service, Patient service and Consultation service
• Update the connection strings in the web app configuration for Doctor service, Patient service and Consultation service
• Update api endpoint urls in Web Gateway and Web Mvc

Now open the Web App URL in web browser for Web Mvc and you should access the app.

The future plan is to deploy the services in AKS.

How to run

You need Visual Studio 2019, ASP.NET 5, Entity Framework, Azure tools for Visual Studio 2019 and SQL Server 2016 to work on this solution locally.

• Clone the repo
• Create the databases and tables with the script provided in the repo.
• Update the connection strings and other configs in appsettings.Development.json file in different projects as applicable to your local settings before executing this app.
• Open the solution in Visual Studio
• Set the below projects as startup projects
  • Doctor service
  • Patient service
  • Consultation service
  • Web gateway
  • Web frontend
• Press F5 to run

medicalsystem's Issues

Patient gateway options tests.

GitHub build action failed after grpc tool nuget package update.

Error:

grpc/grpc#20501

Unit tests for web mvc controllers.

Patient gateway model tests.

Consultation gateway options tests

Show proper errors

Use dapper for cqrs queries.

Fix web application footer name.

Web application footer name is showing project name. Please change it to application name.

Give more details in contribution file.

Consultation model gateway tests.

Xml comments for consultation patent service.

Unit test for patient sync job.

Update Moq nuget lib version.

Doctor gateway options tests.

Add architecture diagram

Unit tests for gateway doctor controller.

Show doctor name in consultation add page.

Edit readme.

Use two spaces for xml files.

Ignore codes from covarage.

Remove docs.

Update nuget packages.

External xml comment file for consultation service domain and view models.

Use connection string for database connection.

Update privacy page.

Create separate contribution file.

Consultation gateway controller tests.

Update readme

gRPC service for backend apis.

Convert below backend services to gRPC service instead of web api.

• Doctor service
• Patient service
• Consultation service

Request comes from web browser to gateway through web api. Request goes from gateway to backend services through gRPC.

Less columns in consultation list page.

Doctor gateway model tests.

Setup deployment pipeline.

Unit test for doctor sync job.

Remove MedicalSystemProjectStructure.JPG

Remove MedicalSystemProjectStructure.JPG because it is unused now.

Create front end common

Consultation list page column mismatch

Xml comments for consultation doctor service.

Unit tests for gateway patient controller.

Test coverage.

Usage of var.

Use var only those places where it is obvious, other places use explicit type names.

Example:

var person1 = new Person(); 

IEnumerable<Person> persons = dal.GetAllPersons();

Add constraint in db.

Unit tests for gateway and webmvc.

Implement cqrs pattern for consultation service.

Swagger support in web gateway.

Xml comments

Create xml comments for all external types. Use external xml document.

Create unit tests for web mvc model and option.

GitHub action place in readme under main heading.

Action name

xml documentation

Nuget package update