
Install Visual Studio using the free community edition, run installer, and select dot net and web development, dot net desktop development, and dot net cross platform development, then click install.
Install Postman to enable testing of the redBus endpoints, using Postman to validate them in the full-stack web app.
Create database objects for Europe by adding two tables: department (auto-generated id, name) and employee (name, department, date of joining, profile picture); insert records and verify with select queries.
Create a .NET web API project in Visual Studio, explore files like dependencies, appsettings, controllers, program, startup, and services, and learn how dependency injection configures the request processing pipeline.
Enable CORS by default, disable cross-domain security, update the JSON serializer by installing a package and importing the namespace, then run the project to verify the sample controller.
Create a models folder and add a department model with fields department and department name, then add an employee model with fields employee name, department, and joining.
Create and test department APIs by wiring a DB connection, injecting configuration, and building get, post, and update endpoints that return JSON and use parameterized queries.
Upload photos via a post route, storing in a photos folder with dependency injection, returning the uploaded image or a default anonymous picture file name on error.
Explore routing and navigation in a Vue.js app by creating a root component, screens (home, employee, department), and a navigation menu with router-link for routes /, /employee, /department.
Consume data with axios in a bootstrap table to display, insert, and manage department records via the get API, using a mounted lifecycle method.
Adapt the employee detail screen by copying from the department screen, add a bootstrap flex layout, a department dropdown, a date of joining, and a profile picture upload workflow.
Download source code here. (.NET Core Web API project and Vue JS project).
In this course, you will learn how to create a full stack web application from scratch using Microsoft SQL server for the database, .NET Core Web API for the backend, and Vue JS for the front end.
We will first install the necessary tools needed for the development.
And then start with creating the necessary tables in Microsoft SQL server, then create the Web API project with the required rest API end points. Finally we will use Vue JS for creating the front end.
> You will learn to create database tables in Microsoft SQL Server.
> Create ASP .NET Core Web API project and understand the project structure.
> Enable CORS and JSON serializer in the API project.
> Implement CRUD APIs in API project.
> Implement upload file API and store files in backend server.
> You will learn how to add routing for our app using vue router.
> Create bootstrap table and populate data by consuming the Rest APIs using axios.
> Use axios to consume the REST Apis.
> Add bootstrap modal pop up windows with drop downs and date pickers.
> We will also learn how to upload an image and store it in the backend server.
> Learn to implement custom sorting and filtering features for the bootstrap table.