In my previous article I showed how to do CRUD operations in MVC4 using AngularJs and the Web API.
Manage Data (CRUD Operations) Using MVC4 Web API AngularJS: Manage Data (CRUD Operations) Using MVC4 Web API AngularJS.
Now in this article I will show how to do Create, Retrieve, Update and Delete (CRUD) operations in MVC4 using AngularJS and WCF REST Services.
The following are the highlights of this article:
- Create a Database. (SchoolManagement).
- Create a Table (Student).
- Create a WCF REST Service Application to do CRUD operations.
- Create a MVC 4 application and use AngularJs to consume WCF REST service.
- Perform the CRUD (Create, Read, Update & Delete) operations.
Angular
AngularJS is a structural framework for dynamic web apps. It lets you use HTML as your template language and lets you extend HTML's syntax to express your application's components clearly and succinctly. AngularJS is a JavaScript framework. Its goal is to augment browser-based applications with Model–View–Controller (MVC) capability, in an effort to make both development and testing easier.
REST
REST stands for Representational State Transfer. This is a protocol for exchanging data over a distributed environment. The main idea behind REST is that we should treat our distributed services as a resource and we should be able to use simple HTTP protocols to perform various operations on that resource.
When we talk about the database as a resource, we usually talk in terms of Create, Retrieve, Update and Delete (CRUD) operations. Now the philosophy of REST is that for a remote resource all these operations should be possible and they should be possible using simple HTTP protocols.
Now the basic CRUD operations are mapped to the HTTP protocols in the following manner:
- GET: Retrieve the required data (representation of data) from the remote resource.
- POST: Update the current representation of the data on the remote server.
- PUT: Insert new data.
- DELETE: Delete the specified data from the remote server.
Now we will go step-by-step.
The following is my data table.
![data table]()
Image 1
The following is the script of my data table:
- CREATE TABLE [dbo].[Student](
- [StudentID] [int] IDENTITY(1,1) NOT NULL,
- [Name] [varchar](50) NULL,
- [Email] [varchar](500) NULL,
- [Class] [varchar](50) NULL,
- [EnrollYear] [varchar](50) NULL,
- [City] [varchar](50) NULL,
- [Country] [varchar](50) NULL,
- CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
- (
- [StudentID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
-
- GO
-
- SET ANSI_PADDING OFF
- GO
So first we need to create the WCF REST Service. So use the following procedure.
Open Visual Studio and select "File" -> "New" -> "Project..." then select WCF in the left Side then select WCF Service Application then click OK.
![wcf service]()
Image 2
Now delete the IService.cs and Service.cs files.
![is service]()
Image 3
Now right-click on the project in the Solution Explorer then select Add New Item then select WCF Service then name it as EmployeeService.
![new wcf service]()
Image 4
Now I will create a Data Contract as
StudentDataContract.
Right-click on the project in the Solution Explorer then select Add New Item then add a .cs file and use the following code:
![new class]()
Image 5
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Runtime.Serialization;
-
- namespace WCF_REST_Service
- {
- public class StudentDataContract
- {
- [DataContract]
- public class EmployeeDataContract
- {
- [DataMember]
- public string StudentID { get; set; }
-
- [DataMember]
- public string Name { get; set; }
-
- [DataMember]
- public string Email { get; set; }
-
- [DataMember]
- public string Class { get; set; }
-
- [DataMember]
- public string EnrollYear { get; set; }
-
- [DataMember]
- public string City { get; set; }
-
- [DataMember]
- public string Country { get; set; }
- }
-
- }
- }
Now it is time to add your database to your application. So create a new folder name as the Model in your project. Now right-click on the Model folder and select Add -> New Item.
![add new item]()
Image 6
Select the ADO.NET Entity Data Model.
![ado dotnet]()
Image 7
![model contain]()
Image 8
Here click on New Connection then enter your SQL Server Details then select your database.
![select server]()
Image 9
![select data connection]()
Image 10
![select table]()
Image 11
![model]()
Image 12
Now open the IStudentService.cs file to define an interface:
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Runtime.Serialization;
- using System.ServiceModel;
- using System.ServiceModel.Web;
- using System.Text;
-
- namespace WCF_REST_Service
- {
-
- ile together.
-
- [ServiceContract]
- public interface IStudentService
- {
-
- [OperationContract]
- [WebInvoke(Method = "GET",
- RequestFormat = WebMessageFormat.Json,
- ResponseFormat = WebMessageFormat.Json,
- UriTemplate = "/GetAllStudent/")]
- List<StudentDataContract> GetAllStudent();
-
- [OperationContract]
- [WebGet(RequestFormat = WebMessageFormat.Json,
- ResponseFormat = WebMessageFormat.Json,
- UriTemplate = "/GetStudentDetails/{StudentId}")]
- StudentDataContract GetStudentDetails(string StudentId);
-
- [OperationContract]
- [WebInvoke(Method = "POST",
- RequestFormat = WebMessageFormat.Json,
- ResponseFormat = WebMessageFormat.Json,
- UriTemplate = "/AddNewStudent")]
- bool AddNewStudent(StudentDataContract student);
-
- [OperationContract]
- [WebInvoke(Method = "PUT",
- RequestFormat = WebMessageFormat.Json,
- ResponseFormat = WebMessageFormat.Json,
- UriTemplate = "/UpdateStudent")]
- void UpdateStudent(StudentDataContract contact);
-
- [OperationContract]
- [WebInvoke(Method = "DELETE",
- RequestFormat = WebMessageFormat.Json,
- ResponseFormat = WebMessageFormat.Json,
- UriTemplate = "DeleteStudent/{StudentId}")]
- void DeleteStudent(string StudentId);
- }
- }
Now Open StudentService.cs
Now make the following changes in your WCF application web.config file:
- <system.serviceModel>
- <behaviors>
- <serviceBehaviors>
- <behavior>
- <!-- To avoid disclosing metadata information, set the values below to false before deployment -->
- <serviceMetadata httpGetEnabled="true" httpsGetEnabled="true" />
- <!-- To receive exception details in faults for debugging purposes, set the value below to true. Set to false before deployment to avoid disclosing exception information -->
- <serviceDebug includeExceptionDetailInFaults="false" />
- </behavior>
- </serviceBehaviors>
- <endpointBehaviors>
- <behavior>
- <webHttp helpEnabled="True"/>
- </behavior>
- </endpointBehaviors>
- </behaviors>
- <protocolMapping>
- <add binding="webHttpBinding" scheme="http" />
- </protocolMapping>
- <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
- </system.serviceModel>
Now our WCF REST Service is ready; run the WCF REST service.
![student service]()
Image 13
It is now time to create a new MVC application. So right-click on your solution and add a new project as below:
![add new project]()
Image 14
![asp mvc application]()
Image 15
![internet application]()
Image 16
Now, add your WCF Service URL to your MVC application. You can host your WCF service in IIS or you can run it and discover the URL locally like the following.
Right-click on your MVC project then select Add Service Reference.
![mvc angularJS]()
Image 17
![select namespace]()
Image 18
Now it is time to add the AngularJs reference. So right-click on your MVC project name in the Solution Explorer then select Add NuGet Packages.
![manage nuget packages]()
Image 19
![AngulaJS]()
Image 20
Now create a new folder (MyScripts) under the Scripts Folder. Here add the following 3 JavaScript files:
- Modules.JS
- Controllers.JS
- Services.JS
1. Module.JS
-
- var app;
-
- (function () {
- app = angular.module("RESTClientModule", []);
- })();
2. Controller.JS
-
-
-
-
- app.controller("CRUD_AngularJs_RESTController", function ($scope, CRUD_AngularJs_RESTService) {
-
- $scope.OperType = 1;
-
-
- GetAllRecords();
-
- function GetAllRecords() {
- var promiseGet = CRUD_AngularJs_RESTService.getAllStudent();
- promiseGet.then(function (pl) { $scope.Students = pl.data },
- function (errorPl) {
- $log.error('Some Error in Getting Records.', errorPl);
- });
- }
-
-
- function ClearModels() {
- $scope.OperType = 1;
- $scope.StudentID = "";
- $scope.Name = "";
- $scope.Email = "";
- $scope.Class = "";
- $scope.EnrollYear = "";
- $scope.City = "";
- $scope.Country = "";
- }
-
-
- $scope.save = function () {
- var Student = {
- Name: $scope.Name,
- Email: $scope.Email,
- Class: $scope.Class,
- EnrollYear: $scope.EnrollYear,
- City: $scope.City,
- Country: $scope.Country
- };
- if ($scope.OperType === 1) {
- var promisePost = CRUD_AngularJs_RESTService.post(Student);
- promisePost.then(function (pl) {
- $scope.StudentID = pl.data.StudentID;
- GetAllRecords();
-
- ClearModels();
- }, function (err) {
- console.log("Some error Occured" + err);
- });
- } else {
-
- debugger;
- Student.StudentID = $scope.StudentID;
- var promisePut = CRUD_AngularJs_RESTService.put($scope.StudentID, Student);
- promisePut.then(function (pl) {
- $scope.Message = "Student Updated Successfuly";
- GetAllRecords();
- ClearModels();
- }, function (err) {
- console.log("Some Error Occured." + err);
- });
- }
- };
-
-
- $scope.get = function (Student) {
- var promiseGetSingle = CRUD_AngularJs_RESTService.get(Student.StudentID);
- promiseGetSingle.then(function (pl) {
- var res = pl.data;
- $scope.StudentID = res.StudentID;
- $scope.Name = res.Name;
- $scope.Email = res.Email;
- $scope.Class = res.Class;
- $scope.EnrollYear = res.EnrollYear;
- $scope.City = res.City;
- $scope.Country = res.Country;
- $scope.OperType = 0;
- },
- function (errorPl) {
- console.log('Some Error in Getting Details', errorPl);
- });
- }
-
-
- $scope.delete = function (Student) {
- var promiseDelete = CRUD_AngularJs_RESTService.delete(Student.StudentID);
- promiseDelete.then(function (pl) {
- $scope.Message = "Student Deleted Successfuly";
- GetAllRecords();
- ClearModels();
- }, function (err) {
- console.log("Some Error Occured." + err);
- });
- }
- });
3. Services.JS
Here change the WCF Service URL according to your WCF Service.
-
-
-
- app.service("CRUD_AngularJs_RESTService", function ($http) {
-
- this.post = function (Student) {
- var request = $http({
- method: "post",
- url: "http://localhost:27321/StudentService.svc/AddNewStudent",
- data: Student
- });
- return request;
- }
-
-
- this.put = function (StudentID, Student) {
- debugger;
- var request = $http({
- method: "put",
- url: "http://localhost:27321/StudentService.svc/UpdateStudent",
- data: Student
- });
- return request;
- }
-
- this.getAllStudent = function () {
- return $http.get("http://localhost:27321/StudentService.svc/GetAllStudent");
- };
-
-
- this.get = function (StudentID) {
- return $http.get("http://localhost:27321/StudentService.svc/GetStudentDetails/" + StudentID);
- }
-
-
- this.delete = function (StudentID) {
- var request = $http({
- method: "delete",
- url: "http://localhost:27321/StudentService.svc/DeleteStudent/" + StudentID
- });
- return request;
- }
- });
Now add a new controller as in the following:
Right-click on the Controller folder then select Add New.
![add new controller]()
Image 21
![controller name]()
Image 22
Now add a View.
Right-click on Index then select "Add View...".
![add view]()
Image 23
![type view name]()
Image 24
Now Index.cshtm will be:
It is now time to run the application. To run your view make the following changes in Route.config:
![routes]()
Image 25
Now run application as in the following:
![AngulaJS CRUD operation]()
Image 26
![save data]()
Image 27
![manage student]()
Image 28