MagicVilla App

A villa management app built on .net core 8 web API, Entity framework with authentication and authorization in API and consume API. This project is done as a part of a training session conducted by Bhrugen Patel. Goto websites

What I Learned

• Learn fundamentals of ASP NET Core web API
• Build RESTful APIs in .NET 8
• How to properly document an API using Swagger and Swashbuckle.
• Versioning in an API.
• Implement Repository Pattern in API to the database using EF.
• Authentication and Authorization in ASP.NET Core API's.
• Integrate Entity Framework along with code-first migrations
• Learn how to consume API using HTTPClient in the Repository Pattern.
• Deploying .NET 8 API

Plant Startup App

A tool build on .NET language using AVEVA SDK to load required settings and environment variables and finally open E3D projects. It provides the alternative solution of default AVEVA startup which can not handle more than 50 projects.

Technology used

• C# WPF

My roles

• .Net development
• Partial architect designing
• Testing

Plant Viewer Web App

A web platform that renders nwd model data in a browser. During this procedure, we can additionally incorporate metadata from external applications by loading them into our databases and integrating them seamlessly.

Technology used

• Raw JavaScript
• ASP .Net Framework
• Forge SDK

E3D Project Creator App

A tool build on C# - WPF and PML, create E3D projects with correct teams, user, dbs and mdb structure. There is a flexible setting for adding components/equipment (based on industry requirement), also can be selected from predefined templates.

Technology used

• C# WPF
• PML
• Dapper
• Sql Server

My roles

• Solution architect
• Net developemt
• Testing

Log Dashboard

A web platform that dynamically load and view data on different integration systems stored in SQL server. .NET MVC is used to build all the controllers and React for frontend.

Technology used

• React Js
• ASP .Net
• Sql Server

My roles

• Back-end developemt
• Testing

Automatic Export Process

I have developed scripts that automates the nightly export of NWD files. It operates by initiating the project, exporting the RVM with precise settings, exporting dump attributes, applying accurate colors, and consolidating all files with the appropriate metadata.

Technology used

• C#
• PML
• VB Script

My roles

• Back-end developemt
• Testing
• Maintenance

Dependency Injection Training

A demo currency market app built on .net core 8 web app, Entity framework exploring deep dependency injection concent and practise. This project is done as a part of a training session conducted by Bhrugen Patel.

What I Leran

• Dependency Injection in .NET 8 (.NET Core)
• Need for Dependency Injection
• Service Lifetime for Dependency Injection
• Injecting services in Middleware
• Injecting services in Views
• Injecting services in Controller Actions
• Different ways to register services
• Registering interface multiple times
• Adding, removing, and replacing service registration
• Register multiple implementations
• Framework services like ILogger
• Inject Action Filters in ASP .NET Core
• Resolve Dependencies Based on Given Conditions
• Inject Services Directly Into The Views in ASP .NET Core
• Plug Third-Party IoC Containers (e.g. AutoFac) into Dependency Injection Framework of ASP .NET Core

Automatic Data Import

I was involved in configuring the AVEVA Tags module, starting from its setup and User Defined Attributes (UDA) configuration to mapping data from external sources such as databases. Additionally, I created PML forms and a flexible explorer interface to facilitate access, creation, and updating of Tags components.

Technology used

• C#
• PML

My roles

• Solution architect
• Solution development
• Testing & Maintenance

Productivity tools

These are few AVEVA E3D supportable C# tool that are made to enhance productivity and collaboration.

Technology used

• C#

My roles

• Solution architect
• .Net development
• Testing & Maintenance

Library Component Manager

This tool enables users to dynamically create components with adjustable design parameters. It offers a selection of over 60 prebuilt components across 8 different categories, all accessible through this form. Additionally, it provides flexibility for users to easily expand the library by adding new items.

Technology used

• Dynamic PML
• Aveva SDK

My roles

• Solution architect
• Development support
• Testing & Maintenance

Customize MEI import tool

Code modification for AVEVA MEI Import tool by adding an area for step model simplification. Here the PML form call an external form (build by C#) which simplify the model, get the path and return it to PML form.

Technology used

• PML
• C# WinForms
• Aveva SDK

My roles

• Solution architect
• Development support
• Testing & Maintenance

Minimal API Project

A coupon management app built on .net core 8 minimal API, Entity framework with authentication and authorization in API. This project is done as a part of a training session conducted by Bhrugen Patel.

What I Learn

• Learn fundamentals of .NET Minimal API
• How to properly document Minimal API using Swagger.
• Validation in an API.
• Implement Repository Pattern in API to the database using EF.
• Authentication and Authorization in Minimal API.
• Integrate Entity Framework along with code-first migrations.
• Filters in Minimal API.
• Build .NET Minimal API Endpoints.

Dapper Training

Dapper provides a super fast library for mapping between databases and .NET. This code-focused course discussed all the basics to be productive with Dapper and how to incorporate Dapper in the project. This project is done as a part of a training session conducted by Bhrugen Patel.

What I Learn

• Learn fundamentals of Dapper.
• Perform CRUD operation with Entity Framework Core.
• Perform CRUD operation with Dapper using SQL.
• Perform CRUD operation with Dapper Async using SQL.
• Perform CRUD operation with Dapper using Stored Procedures.
• Perform CRUD operation with Dapper Contrib library.
• Learn complex parent-child objects in Dapper.
• Learn one-to-one, one-to-many relations in mapping.
• Bulk insert in Dapper.
• Transaction in Dapper.
• Implement generic Dapper stored procedure repository.