ASP.NET Core1.0: Insert/Select To Database Using Angular2 And WEB API

Syed Shanu
Jul 18, 2016

81.9k
0
11
- facebook
- twitter
- linkedIn
- Reddit
- WhatsApp
- Email
- Print
- Other Artcile

output
Introduction

In our previous article,

ASP.NET Core 1.0 RC2 And Angular2 Using WEB API

we have seen in detail about ASP.NET Core 1.0, Angular2 and WEB API to display the data.

In this article we will see in detail about using ASP.NET Core 1.0 with Angular2 to Insert and Select Student Details to SQL Server Database using WEB API.

In this article we will see in detail how to,

Create our ASP.NET Core 1.0 RC2 Web Application.
Create Model to add Student details.
Create WEB API Controller using Entity framework to Select and Insert data to database.
How to add TypeScript JSON Configuration File
How to add grunt package using NPM configuration file
How to configure Grunt File.
Adding Dependencies to install Angular2 and all other files
How to create our Angular2 App, boot using Type Script file.
Using HTTP Get/Post to Insert and select data from Angular2 to WEB API to insert in DB.
Creating HTML File
How to Run the Grunt file using Visual Studio Task Runner Explorer
How to Run and view our Sample.

Reference website :

Prerequisites

Visual Studio 2015: You can download it from here.
ASP.NET Core 1.0 RC2: download link,link2.

Code Part

Create a Database

We will be using our SQL Server database for our WEB API. First we create a database named StudentsDB and a table as StudentMaster. Here is the SQL script to create Database table and sample record insert query in our table. Run the below query in your local SQL server to create Database and Table to be used in our project.

USE MASTER
GO
-- 1) Check for the Database Exists .If the database is exist then drop and create new DB
IF EXISTS (SELECT [name] FROM sys.databases WHERE [name] = 'StudentsDB' )
DROP DATABASE StudentsDB
GO
CREATE DATABASE StudentsDB
GO
USE StudentsDB
GO
-- 1) //////////// StudentMasters
IF EXISTS ( SELECT [name] FROM sys.tables WHERE [name] = 'StudentMasters' )
DROP TABLE StudentMasters
GO
CREATE TABLE [dbo].[StudentMasters](
[StdID] INT IDENTITY PRIMARY KEY,
[StdName] [varchar](100) NOT NULL,
[Email] [varchar](100) NOT NULL,
[Phone] [varchar](20) NOT NULL,
[Address] [varchar](200) NOT NULL
)
-- insert sample data to Student Master table
INSERT INTO [StudentMasters] ([StdName],[Email],[Phone],[Address])
VALUES ('Shanu','[email protected]','01030550007','Madurai,India')
INSERT INTO [StudentMasters] ([StdName],[Email],[Phone],[Address])
VALUES ('Afraz','[email protected]','01030550006','Madurai,India')
INSERT INTO [StudentMasters] ([StdName],[Email],[Phone],[Address])
VALUES ('Afreen','[email protected]','01030550005','Madurai,India')
select * from [StudentMasters]

Step 1: Create our ASP.NET Core 1.0 Web Application.

After installing both Visual Studio 2015 and ASP.NET Core 1.0 RC2. Click Start, then Programs and select Visual Studio 2015 - Click Visual Studio 2015. Click New, then Project, select Web and select ASP.NET Core Web Application. Enter your Project Name and click OK.

ASP.NET Core 1.0 Web Application

Next select Web Application. If you are not hosting in Cloud then you can uncheck the Host in the Cloud at the bottom right corner. Click OK.

Now we have,

Web Application

Database Connection String

Now we need to change the local connection string from ASP.Net 5 project with our SQL Server connection.

Note: In ASP.NET Core 1.0 we need to use “appsettings.json” file instead of web.config.We can find the “appsettings.json” file from our ASP.NET Core 1.0 solution.

To change the default connection string with our SQL connection open the “appsettings.json” file .Yes this is JSON file and this file looks like below Image by default.

Now the default connectionstring will be something like this,

"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-Core1.0Angular2CRUDInsert-599f2ca4-119a-4fd5-a2a4-e58fb4b2e5be;Trusted_Connection=True;MultipleActiveResultSets=true"
},

Now we change this to our SQL Connection like below,

"ConnectionStrings": {
"DefaultConnection": "Server=SQLSERVERNAME;Database=StudentsDB;user id=SQLID;password=SQLPWD;Trusted_Connection=True;MultipleActiveResultSets=true;"
},

Step 2: Creating MVC Model to return student list

We can create a model by adding a new class file in our Model Folder.

create

Right click the Models folder and click new Item. Select Class and enter your class name as “StudentMasters.cs”

Now in this class we first create property variable, add student. We will be using this in our WEB API controller.

using System.ComponentModel.DataAnnotations;
namespace WebApplicationTestSample.Models
{
public class StudentMasters
{
[Key]
public int StdID { get; set; }
[Required]
[Display(Name = "Name")]
public string StdName { get; set; }
[Required]
[Display(Name = "Email")]
public string Email { get; set; }
[Required]
[Display(Name = "Phone")]
public string Phone { get; set; }
public string Address { get; set; }
}
}

Step 3: Creating WEB API Controller

We can create a controller by adding a new Empty API Controller in our Controller Folder.

Right click the Controller folder and Add Controller. Select API Controller with action, using Entity Framework and click Add,

Add

Select the Model class as StudentMasters.

After selecting the Model Class select the Data Context Class. Here we are selecting the default ApplicationDbContext. Note we have set the default connection string to our SQL Server database Connection. Next give our WEB API controller name as StudentMastersAPI.

add

We can see that our WEB API Controller has been created now and also the controller will contain default Select (HttpGet) and Insert method as (HttpPost). We will be using this get and post method In our Angular2 to select and insert data to database.

code

To test it we can run our project and copy the get method api path here we can see our API path for get is api/StudentMastersAPI/

Run the program and paste the above API path to test our output.

output

Step 4: How to add TypeScript JSON Configuration File

The TypeScript JSON file specifies the root files and the compiler options required to compile the project .To know more about TypeScript JSON Configuration kindly visit this site.

To create the TypeScript JSON file right click on you Project and Click Add new Item.

Select TypeScript JSCON Configuration File and Click ok. The File will be look like below image.

code

Now copy the below code and replace with your config file.

"compilerOptions": {
"emitDecoratorMetadata": true,
"experimentalDecorators": true,
"module": "commonjs",
"moduleResolution": "node",
"noImplicitAny": false,
"noEmitOnError": true,
"removeComments": false,
"target": "es5",
"sourceMap": true

Step 5: How to add grunt package using NPM configuration file

Now we need to add a NPM Configuration File for adding a grunt package to run our java scripts. As we have created as a Web Application the NPM Configuration File will be located in our project. By default we can’t view our NPM Configuration File. The NPM Configuration File will be in the name of “package.JSON” . To view that from the Solution Explorer click on “Show All Files”

Now open the “package.JSON” file. Now first we need to change the name to our project Solution name and add our grunt package. We can see the code here below the image.

Here we have changed the name as our Solution name and also added the grunt package.

{
"name": "test",
"version": "0.0.0",
"private": true,
"devDependencies": {
"grunt": "1.0.1",
"grunt-contrib-copy": "1.0.0",
"grunt-contrib-uglify": "1.0.1",
"grunt-contrib-watch": "1.0.0",
"grunt-ts": "5.5.1",
"gulp": "3.8.11",
"gulp-concat": "2.5.2",
"gulp-cssmin": "0.1.7",
"gulp-uglify": "1.2.0",
"rimraf": "2.2.8"
}
}

Now save the package.json file and you should be able to see a grunt package under Dependencies/ npm Folder will be first Resorted and then installed.

Restoring

Al Installed

Step 6: Configure Grunt File.

Grunt is used to build all our client side resources like JavaScript for our project.

First step is to add a Grunt file to our project. Right click our project and Select Grunt Configuration File and click Add.

Add

After creating the file now we need to edit this file to add load plugins, configure plugins and define tasks

Here in our Grunt file we have first load plugins which we have added in our npm. Using loadNpmTask here we load 'grunt-contrib-copy ,'grunt-contrib-uglify' , 'grunt-contrib-watch',

Grunt

Next we configure the grunt add the app.js file in our wwwroot folder. All our Script files from Scripts folder result will be added in this app.js file. Next we need to copy all the Script file from 'node_modules/ to our local js Folder.

The watch plugin will be used to check for any changes on JavaScript file and update it app.js with all new changes.

/*
This file in the main entry point for defining grunt tasks and using grunt plugins.
Click here to learn more. http://go.microsoft.com/fwlink/?LinkID=513275&clcid=0x409
*/
module.exports = function (grunt) {
grunt.loadNpmTasks('grunt-contrib-copy');
grunt.loadNpmTasks('grunt-contrib-uglify');
grunt.loadNpmTasks('grunt-contrib-watch');
grunt.loadNpmTasks('grunt-ts');
grunt.initConfig({
ts:
{
base:
{
src: ['Scripts/app/boot.ts', 'Scripts/app/**/*.ts'],
outDir: 'wwwroot/app',
tsconfig: './tsconfig.json'
}
},
uglify:
{
my_target:
{
files: [{
expand: true,
cwd: 'wwwroot/app',
src: ['**/*.js'],
dest: 'wwwroot/app'
}]
},
options:
{
sourceMap: true
}
},
// Copy all JS files from external libraries and required NPM packages to wwwroot/js
copy: {
main: {
files:
[{
expand: true,
flatten: true,
src: ['Scripts/js/**/*.js', 'node_modules/es6-shim/es6-shim.min.js', 'node_modules/systemjs/dist/system-polyfills.js', 'node_modules/angular2/bundles/angular2-polyfills.js', 'node_modules/systemjs/dist/system.src.js', 'node_modules/rxjs/bundles/Rx.js', 'node_modules/angular2/bundles/angular2.dev.js'],
dest: 'wwwroot/js/',
filter: 'isFile'
}]
}
},
// Watch specified files and define what to do upon file changes
watch: {
scripts: {
files: ['Scripts/**/*.js'],
tasks: ['ts', 'uglify', 'copy']
}
}
});
// Define the default task so it will launch all other tasks
grunt.registerTask('default', ['ts', 'uglify', 'copy', 'watch']);
};

Step 7: Adding Dependencies to install Angular2 and all other files

We are using NPM to install our Angular2 in our web application. Open our Package.JSON file and the below dependencies.

"dependencies": {
"@angular/http": "2.0.0-rc.1",
"angular2": "^2.0.0-beta.8",
"angular2-jwt": "0.1.16",
"angular2-meteor": "0.5.5",
"cors": "2.7.1",
"systemjs": "0.19.22",
"es6-promise": "^3.0.2",
"es6-shim": "^0.33.3",
"reflect-metadata": "0.1.2",
"rxjs": "5.0.0-beta.2",
"tsd": "^0.6.5",
"zone.js": "0.5.15"
},

The edited Package.json file will be look like below image.

Save the file and wait for a few second to complete all dependencies installed.

file

Step 8 How to create our Angular2 App, boot using Type Script file.

Now it’s time to create our Angular2 application. First create a Folder named Scripts. Right click our project and click add new Folder and name the folder name as “Scripts”. Now we will create our TypeScript files inside this Scripts folder.

To work with Angular2 we need to create 2 important TypeScript files.

Component File where we write our Angular coding.
Boot file: To run our component app .

Creating App TypeScript file

Right Click on Scripts folder and click on add new Item. Select TypeScript File and name the file as App.ts and click Add.

Add

In App.ts file we have three parts first is the,

import part
Next is component part
Next we have the class for writing our business logics.

Here we can see a simple basic one way binding example to display the welcome message in side h1 tag.Here.

Import part

First we import angular2 files to be used in our component here we import http for using http client in our Angular2 component and importing NgFor for using the looping and binding all the student details array values one by one, and also we are importing one more typescript export class name StudentMasters from the model file.
1. import { Component, Injectable, Inject} from 'angular2/core';
2. import { NgIf, NgFor } from 'angular2/common';
3. import {Http, Response, HTTP_PROVIDERS, Headers, RequestOptions} from 'angular2/http';
4. import { StudentMasters } from './model';
5. import {Observable} from 'rxjs/Observable';
6. import 'rxjs/Rx';
Next is component part

In component we have selector, directives and template. Selector is to give a name for this app and in our html file we use this selector name to display in our html page.

In template we write our code. In template first we create a form to insert Student details to database using the http post method. In Button click we call the addStudentsDetails() method to insert student details. After inserting we call the getData() method to bind the updated result.

To display the StudentMaster details we are using ngFOR inside html table. In the method we have used http get function to load data from WEB API and to display in our html page. We have made all the design inside the template. There is also another method as we can create a html file and add all the design in that html page and in template we can give the html file name.
1. @Component({
2. selector: "my-app",
3. directives: [NgFor],
4. template: `
5. <table style="background-color:#FFFFFF; border: dashed 3px #6D7B8D; padding :5px;width :99%;table-layout:fixed;" cellpadding="2" cellspacing="2">
6. <tr style="height: 30px; background-color:#336699 ; color:#FFFFFF ;border: solid 1px #659EC7;">
8. <td>
9. <h2>Insert Student Details : </h2>
10. </td>
11. </tr>
12. <tr>
13. <td>
14. <table style="color:#9F000F;font-size:large" cellpadding="4" cellspacing="6">
15. <tr>
16. <td><b>Students ID: </b> </td>
17. <td>
18. <input [(ngModel)]="students.StdID" value="0" style="background-color:tan" readonly>
19. </td>
20. <td><b>Students Name: </b> </td>
21. <td>
22. <input [(ngModel)]="students.StdName" >
23. </td>
24. </tr>
25. <tr>
26. <td><b>Email: </b> </td>
27. <td>
28. <input [(ngModel)]="students.Email" >
29. </td>
30. <td><b>Phone: </b> </td>
31. <td>
32. <input [(ngModel)]="students.Phone" >
33. </td>
34. </tr>
35. <tr>
36. <td><b>Address: </b> </td>
37. <td>
38. <input [(ngModel)]="students.Address" >
39. </td>
40. <td colspan="2">
41. <button (click)=addStudentsDetails() style="background-color:#334668;color:#FFFFFF;font-size:large;width:200px;
42. border-color:#a2aabe;border-style:dashed;border-width:2px;">Save</button>
43. </td>
44. </tr>
45. </table>
46. </td>
47. </tr>
49. <tr><td> </td></tr>
51. <tr>
52. <td>
53. <table style="background-color:#FFFFFF; border solid 2px #6D7B8D; padding 5px;width 99%;table-layout:fixed;" cellpadding="2" cellspacing="2">
55. <tr style="height: 30px; background-color:#336699 ; color:#FFFFFF ;border: solid 1px #659EC7;">
56. <td width="100" align="center">Student ID</td>
57. <td width="240" align="center">Student Name</td>
58. <td width="240" align="center">Email</td>
59. <td width="120" align="center">Phone</td>
60. <td width="340" align="center">Address</td>
63. </tr>
64. <tbody *ngFor="let std of student">
65. <tr>
67. <td align="center" style="border: solid 1px #659EC7; padding: 5px;table-layout:fixed;">
68. <span style="color:#9F000F">{{std.StdID}}</span>
69. </td>
71. <td align="left" style="border: solid 1px #659EC7; padding: 5px;table-layout:fixed;">
72. <span style="color:#9F000F">{{std.StdName}}</span>
73. </td>
75. <td align="left" style="border: solid 1px #659EC7; padding: 5px;table-layout:fixed;">
76. <span style="color:#9F000F">{{std.Email}}</span>
77. </td>
79. <td align="center" style="border: solid 1px #659EC7; padding: 5px;table-layout:fixed;">
80. <span style="color:#9F000F">{{std.Phone}}</span>
81. </td>
83. <td align="left" style="border: solid 1px #659EC7; padding: 5px;table-layout:fixed;">
84. <span style="color:#9F000F">{{std.Address}}</span>
85. </td>
87. </tr>
88. </tbody>
89. </table>
90. </td>
91. </tr>
92. </table>
93. `,
95. })
Export Class

This is the main class where we do all our business logic and variable declaration to be used in our component template. In this class we have created a method named getData() and in this method we get the API method result and bind the result to the student array. In button click we call the addStudentsDetails() method to insert the data to database using http post method.
1. export class AppComponent {
2. student: Array<StudentMasters> = [];
3. students = {};
4. myName: string;
5. constructor(@Inject(Http) public http: Http) {
6. this.myName = "Shanu";
7. this.getData();
8. }
10. getData() {
11. this.http.get('api/StudentMastersAPI')
12. .map((responseData) => {
13. return responseData.json();
14. })
15. .map((student: Array<any>) => {
16. let result: Array<StudentMasters> = [];
17. if (student) {
18. student.forEach((student) => {
19. result.push(new StudentMasters(student.StdID, student.StdName,
20. student.Email, student.Phone, student.Address));
21. });
22. }
23. return result;
24. })
25. .subscribe(res => this.student = res);
26. }
28. addStudentsDetails() {
29. var headers = new Headers();
30. headers.append('Content-Type', 'application/json; charset=utf-8');
31. this.http.post('api/StudentMastersAPI', JSON.stringify(this.students), { headers: headers }).subscribe();
32. alert("Student Detail Inserted");
33. this.getData();
34. }
36. }

Next we need to add the boot.ts file to run our app.

Creating boot TypeScript file

Right Click on Scripts folder and click on add new Item. Select TypeScript File and name the file as boot.ts and click Add.

Add

In boot.ts file we add the below code. Here first we import bootstrap file to load and run our app file and also we import our app component. Note to import our app we need to give the same class name which was given in our app typescript file and give our app path in from as ’./app’ .Next we run our app by adding the app name in bootstrap as bootstrap(myAppComponent);.

///<reference path="../node_modules/angular2/typings/browser.d.ts" />
import {bootstrap} from 'angular2/platform/browser'
import {ROUTER_PROVIDERS} from "angular2/router";
import {HTTP_PROVIDERS, HTTP_BINDINGS} from "angular2/http";
import {AppComponent} from './app'
bootstrap(AppComponent, [HTTP_BINDINGS, HTTP_PROVIDERS]);

Creating model TypeScript file

Right Click on Scripts folder and click on add new Item. Select TypeScript File and name the file as model.ts and click Add.

model

We use this model typescript file to create our Studentmasters model and declare all the public properties which we created in our MVC model.

export class StudentMasters {
constructor(
public StdID: number,
public StdName: string,
public Email: string,
public Phone: string,
public Address: string
) { }
}

Step 9: Creating HTML File

Next we need to create our html page to view result. To add the HTML file right click on wwwroot folder and click add new item, give the name as index.html and click Add.

HTML

In HTMl file replaces the below code. Here we can see first in header part we add all the script reference files and in script we load our boot file to run our app. In body part we display the result using the component selector name. In our app component we have given the selector name as “myapp1”. In this HTML in order to display the result we add tag like this <my-app>Please wait...</my-app>

<html>
<head>
<title>ASP.NET Core: AngularJS 2 Demo</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="/js/es6-shim.min.js"></script>
<script src="/js/system-polyfills.js"></script>
<script src="/js/angular2-polyfills.js"></script>
<script src="/js/system.src.js"></script>
<script src="/js/Rx.js"></script>
<script src="/js/angular2.dev.js"></script>
<script src="/js/router.dev.js"></script>
<script src="/js/http.dev.js"></script>
<script>
System.config
({
packages:
{
"app":
{
defaultExtension: 'js'
},
'lib': { defaultExtension: 'js' }
}
});
System.import('app/boot').then(null, console.error.bind(console));
</script>
</head>
<body>
<table style='width: 99%;table-layout:fixed;'>
<tr>
<td>
<table style="background-color:#FFFFFF;border: dashed 3px #6D7B8D; padding:10px;width: 99%;table-layout:fixed;" cellpadding="12" cellspacing="12">
<tr style="height: 30px; background-color:#f06a0a ; color:#FFFFFF ;border: solid 1px #659EC7;">
<td align="center">
<h3> SHANU ASP.NET Core1.0 Insert/Select Student Details to Database Using Angular2 and WEB API </h3>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<my-app>Please wait...</my-app>
</td>
</tr>
</table>
</body>
</html>

So what is next -- we have successfully created our first Angular2 and Asp.Net core 1.0 web application and wait -- we have to do one more pending work to run our application. Yes we need to run our Grunt file to create our entire script file in our wwwroot scripts folder.

Step 10: Run the Grunt file using Visual Studio Task Runner Explorer

Now we need to run the Grunt file using Visual Studio Task Runner.

To view the Task Runner Click the menu View-> Other Windows,-> and click on Task Runner Explorer.

We can also open Task Runner by right clicking on our Gruntfile.js in Solution Explorer and clicking on Task Runner Explorer.

Now we can see our Task Runner Explorer.

Click on GruntFile.js and click on refresh button at top left.

Now we can see all the GruntFiles have been added.

Right click the default under Alias Task and click Run.

Run

Now our Grunt file has been successfully run in our project. When we add a script file we can see new app.js file will be created in our wwwroot folder.

folder

Run the Program

Here we can see all the data from WEB API has been bound to our HTML page using Angular2.You can insert new Student details In the same way you can add Update and Delete function to perform complete CRUD operations to maintain Student records.

Note: First create the Database and Table in your SQL Server. You can run the SQL Script from this article to create StudentsDB database and StudentMasters Table and also don’t forget to change the Connection string from “appsettings.json”.

output

Recommended Free Ebook

Crack Your Angular Interview

Download Now!