Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / web / HTML

Angular JS Filter, Sorting and Animation using MVC and WCF Rest

4.89/5 (23 votes)
8 Jul 2015CPOL11 min read 50.7K   2K  
How to use AngularJs Filter, AngularJs Sort, AngularJs Animation, Image Mouse Over and Mouse Out Event
In this article, we will see how to use an AngularJs Filter, AngularJs Sort, AngularJs Animation, Image Mouse Over and Mouse Out Event.

Image 1

Introduction

In this article, we will see how to use:

  • AngularJs Filter
  • AngularJs Sort
  • AngularJs Animation
  • Image Mouse Over and Mouse Out Event

You can also view my previous articles related to AngularJs using MVC and WCF Rest Service:

This article will explain in detail how to create an Online Mind Reader quiz game using Angular JS and a WCF Rest Service. This article will explain:

  1. How to create a WCF Rest service and retrieve data from a database
  2. How to install the Angular JS Package into a MVC application
  3. How to create our Angular JS application to create our own Master Detail Grid
  4. How to use a WCS service in Angular JS to create our own online Quiz Game for Mind Reader

Note: The prerequisites are Visual Studio 2013 (if you don't have Visual Studio 2013, you can download it from the Microsoft website here).

Here, we can see some basics and reference links for Windows Communication Foundation (WCF). WCF is a framework for building service-oriented applications.

Service-Oriented Application

Using a protocol, the service can be shared and used over a network.

For example, let's consider now we are working on a project and we need to create a common database function and those functions need to be used in multiple projects and the projects are in a different place and connected by the internet.

In this case, we can create a WCF service and we can write all our common database functions in our WCF service class. We can deploy our WCF in IIS and use the URL in our application to do DB functions. In the code part, let's see how to create a WCF REST service and use it in our Angular JS application.

If you are interested in reading more about WCF, kindly go through this link.

Angular JS

We might be familiar with what the Model, View, View Model (MVVM) and what Model, View and Controller (MVC) are. Angular JS is a JavaScript framework that is purely based on HTML, CSS and JavaScript.

The Angular JS Model View Whatever (MVW) pattern is similar to the MVC and MVVM patterns. In our example, I have used Model, View and Service. In the code part, let's see how to install and create Angular JS in our MVC application.

As this article explains how to use Filter, Sort and Simple Animation in AngularJS, let’s see one by one here.

ng-repeat: First, we start with ng-repeat. This can be used to display the array of data one by one within our Table td or within a List, for example, let’s consider if we want to display the data from 1 to 10. Usually, we do loop and display the value one by one, or we add values from 1 to 10 to array and display using the looping. To use looping and display the data one by one in AngularJs, we use ng-repeat.

For example, let’s see the above case as to display the data from 1 to 10 in table so the code will be like this:

HTML
<table>
    <tbody ng-repeat="Numbers in [1, 2, 3, 4,5,6,7,8,9,10] ">
        <tr>
            <td>
                {{Numbers}}
            </td>
        </tr>
    </tbody>
</table>

The example can be used to display the Names one by one from name Array.

HTML
<table>
   <tbody ng-repeat="Names in ['Shanu','Afraz',
   'Raja','Afreen','Mak','Albert'] ">
        <tr>
            <td>
                {{Names}}
            </td>
        </tr>
    </tbody>
</table>

To test this example, we need to add our angular.js in our root folder. The complete code will be like this. Here, we can see first we have added the angular.js reference.

HTML
<html ng-app="MyAngularModule" xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
<script src="http://code.angularjs.org/1.2.2/angular.js"></script>
<script>
        angular.module('MyAngularModule', [])
        .controller('myAngularController', function (
          $scope
        ) {
        });
    </script>
</head>
<body ng-controller="myAngularController">
    <table>
        <tbody ng-repeat="Numbers in [1, 2, 3, 4,5,6,7,8,9,10] ">
            <tr>
                <td>
                    {{Numbers}}
                </td>
            </tr>
        </tbody>
    </table>
    <table>
        <tbody ng-repeat="Names in ['Shanu','Afraz',
        'Raja','Afreen','Mak','Albert'] ">
            <tr>
                <td>
                    {{Names}}
                </td>
            </tr>
        </tbody>
    </table>
</body>
</html>

1) Filter

The filters can be added with the ng-repeat using pipe symbol, for example, let’s consider the above example.

For example, we can consider the above example where we have displayed the names of array using the ng-repeat. Now, we can add the filter for the above example.

Here, we can see with ng-repeat we have added the filter and for filter, we have given the textbox Model id. When user press key on the textbox, the filter will be applied for the loop and display the appropriate value.

JavaScript
ng-repeat="Names in ['Shanu','Afraz','Raja','Afreen','Mak','Albert'] | filter:myNameFilters

Complete Code

HTML
<html ng-app="MyAngularModule" xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="http://code.angularjs.org/1.2.2/angular.js"></script>
    <script>
        angular.module('MyAngularModule', [])
        .controller('myAngularController', function (
          $scope
        ) {
        });
    </script>
</head>
<body ng-controller="myAngularController">
    Filter By NAme : <input type="text" ng-model="myNameFilters">
    <table border=1>
 <tbody ng-repeat="Names in ['Shanu','Afraz','Raja','Afreen','Mak','Albert']  |
                              filter:myNameFilters ">
            <tr>
                <td>
                    {{Names}}
                </td>
            </tr>
        </tbody>
    </table>
</body>
</html>

2) Sort

Same like filter, we add the orderBy with field and reverse value in ng-repeat using the pipe symbol. The OrderBy can be added with the ng-repeat using pipe symbol, for example, let’s consider the above example. Where we have displayed the names of array using the ng-repeat. Now we can add the filter for the above example.

Here, in first Tr and Td, I display the Table Heading and in click event, I display the order by Names in Ascending and by descending order.

HTML
ng-repeat="nme in Names | filter:myNameFilters | orderBy:predicate:reverse

Complete Code

HTML
<html ng-app="MyAngularModule" xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="http://code.angularjs.org/1.2.2/angular.js"></script>
    <script>
        angular.module('MyAngularModule', [])
        .controller('myAngularController', function (
          $scope
        ) {
        });
    </script>
</head>
<body ng-controller="myAngularController" ng-init="Names = [{name:'Shanu'},
                     {name:'Afraz'},{name:'Afreen'},{name:'Vijay'},
                     {name:'Mak'}, {name:'Raja'}]">

    Filter By NAme : <input type="text" ng-model="myNameFilters">
    <table border=1>
        <tr>
            <td ng-click="predicate = 'name'; reverse=!reverse">
                <b>Toy Code</b>
            </td>
        </tr>

        <tbody ng-repeat="nme in Names   |
         filter:myNameFilters  | orderBy:predicate:reverse">
            <tr>
                <td>
                    {{nme.name}}
                </td>
            </tr>
        </tbody>
    </table>
</body>
</html>

3) Animation

For using the Animation in AngularJs, we must include “angular-animate.min.js” and in module my must pass the parameter “ngAnimate”:

The code will look like this:

  1. Add the reference:
    HTML
    <script src="http://code.angularjs.org/1.2.2/angular-animate.min.js"></script>
  2. Pass the parameter in Module as ‘ngAnimate’:
    JavaScript
    angular.module('MyAngularModule', ['ngAnimate'])
    
  3. Add your animation CSS to your HTML page. Here in my example, I will fade In and Out the display of the text which is binding using ng-repeat.

Complete Code

HTML
<html ng-app="MyAngularModule" xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="http://code.angularjs.org/1.2.2/angular.js"></script>
    <script src="http://code.angularjs.org/1.2.2/angular-animate.min.js"></script>
    <style>
        .ng-enter {
            -webkit-transition: 1s;
            transition: 3s;
            opacity: 0;
        }

        .ng-enter-active {
            opacity: 1;
        }

        .ng-leave {
            -webkit-transition: 1s;
            transition: 2s;
        }

        .ng-leave-active {
            opacity: 0;
        }
    </style>
    <script>
        angular.module('MyAngularModule', ['ngAnimate'])
        .controller('myAngularController', function (
          $scope
        ) {
        });
    </script>
</head>
<body ng-controller="myAngularController" ng-init="Names = [{name:'Shanu'},
                     {name:'Afraz'}, {name:'Afreen'}, {name:'Vijay'},
                     {name:'Mak'}, {name:'Raja'}]">

    Filter By NAme : <input type="text" ng-model="myNameFilters">
    <table border=1>
        <tr>
            <td ng-click="predicate = 'name'; reverse=!reverse">
                <b>Toy Code</b>
            </td>
        </tr>
        <tbody ng-repeat="nme in Names   | filter:myNameFilters  |
                                           orderBy:predicate:reverse">

            <tr>
                <td>
                    {{nme.name}}
                </td>
            </tr>
        </tbody>
    </table>
</body>
</html>

Reference Links

These are all few simple examples using HTML. Now let’s see in detail how to implement this in our MVC application using WCF rest Service.

Using the Code

1) Create Database and Table

We will create a ToysDetails table under the database ToysDB. The following is the script to create a database, table and sample insert query. Run this script in your SQL Server. I have used SQL Server 2012.

SQL
-- =============================================
-- Author      : Shanu
-- Create date : 2015-03-20
-- Description : To Create Database,Table and Sample Insert Query
-- Latest
-- Modifier    : Shanu
-- Modify date : 2015-03-20
-- =============================================
--Script to create DB,Table and sample Insert data
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] = 'ToysDB' )
DROP DATABASE ToysDB
GO

CREATE DATABASE ToysDB
GO

USE ToysDB
GO

-- 1) //////////// ToysDetails table

-- Create Table ToysDetails, this table will be used
-- to store the details like Toys Information

IF EXISTS ( SELECT [name] FROM sys.tables WHERE [name] = 'ToysDetails' )
DROP TABLE Professional_Type
GO

CREATE TABLE ToysDetails
(
   Toy_ID VARCHAR(20) NOT NULL,
   Toy_Name VARCHAR(100)  NOT NULL,
   Toy_Price int  NOT NULL,
   Image_Name VARCHAR(100)  NOT NULL,
   Item_Date DateTime  NOT NULL,
   AddedBy VARCHAR(100)  NOT NULL,
CONSTRAINT [PK_ToysDetails] PRIMARY KEY CLUSTERED
(
  [Toy_ID] 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
-- Insert the sample records to the ToysDetails Table

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
                 values('Toy001','Abacus',250,'Abacus.png',getdate(),'Shanu')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy002','Babel Fish',350,'Babelfish.png',getdate()-10,'Afraz')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy003','Base Ball',1400,'Baseball.png',getdate()-24,'Shanu')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy004','Basket Ball',1390,'BasketballBall.png',getdate()-36,'Raj')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy005','Blue Fish',450,'BlueFish.png',getdate()-90,'Afraz')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy006','Brown Bear',1250,'BrownBear.png',getdate()-34,'Mak')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy007','CabrioletRed Car',950,'CabrioletRed.png',getdate()-20,'Albert')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy008','Chevelot Car',1150,'Chevelot.png',getdate()-26,'Gowri')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy009','Duck',399,'Duck.png',getdate()-44,'Afraz')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy010','FireEscape Van',897,'FireEscape.png',getdate()-12,'Shanu')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy011','Mini Car',750,'MiniCar.png',getdate(),'Shanu')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy012','Nemo',675,'Nemo.png',getdate()-1,'Kim')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy013','Old Car',1950,'OldCar.png',getdate()-3,'Jack')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy014','Red Car',679,'RedCar.png',getdate(),'Lee')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy015','Soccer Ball',950,'SoccerBall.png',getdate(),'Shanu')

Insert into ToysDetails(Toy_ID,Toy_Name,Toy_Price,Image_Name,Item_Date,AddedBy) _
values('Toy016','Tennis Ball',350,'TennisBall.png',getdate()-29,'Afraz')

select * from ToysDetails

-- 1) END //

2) Create WCF REST Service

Open Visual Studio 2013 -> Select File - New- Project – Select WCF Service Application -> Select your Project path and Name your WCF service and click OK.

Image 2

Once we created our WCF Service, we can see “IService.CS” and “Service1.svc” in Solution Explorer as below:

Image 3

  • IService.CS - > In “IService.CS”, we can see 3 Contract by default
  • [ServiceContract] - > describes the methods or any operations available for service. Service Contract is an Interface and methods can be declared inside the Service Interface using Operation Contract attribute
  • [OperationContract] -> is similar to web service [WEBMETHOD]
  • [DataContract] -> describes the data exchange between the client and the service

[ServiceContract]

The below code will be automatically created for all the IService.CS file. We can change and write our own code here.

C#
public interface IService1
{
    [OperationContract]
    string GetData(int value);

    [OperationContract]
    CompositeType GetDataUsingDataContract(CompositeType composite);
}

[DataContract]
public class CompositeType
{
    bool boolValue = true;
    string stringValue = "Hello ";

    [DataMember]
    public bool BoolValue
    {
        get { return boolValue; }
        set { boolValue = value; }
    }

    [DataMember]
    public string StringValue
    {
        get { return stringValue; }
        set { stringValue = value; }
    }
}

Data Contract

In our example, we need to get all Toys details, so I have created a Data Contract “ToyItemDataContract” Here, we can see we have decelerated our entire Table column name as Data Member.

C#
public class ToysDetailDataContract
    {
        [DataContract]
        public class ToyItemDataContract
        {
            [DataMember]
            public string Toy_ID { get; set; }

            [DataMember]
            public string Toy_Name { get; set; }

            [DataMember]
            public string Toy_Price { get; set; }

            [DataMember]
            public string Image_Name { get; set; }

            [DataMember]
            public string Item_Date { get; set; }

            [DataMember]
            public string AddedBy { get; set; }
        }
    }

Service Contract

In Operation Contract, we can see “WebInvoke” and “WebGet” which is to retrieve the data from the database in REST Service.

JavaScript
RequestFormat = WebMessageFormat.Json,
ResponseFormat = WebMessageFormat.Json,

Here, we can see both the request and response format. Here, I have used the Json format.

  • JSON -> JavaScript Object Notation is a lightweight data interchange format
  • UriTemplate -> Is our method Name and here, our method return type is List.

Here, I have declared “GetToyDetails” method and used to get the details of all Toys from the Database.

C#
[ServiceContract]
    public interface IService1
    {
[OperationContract]
        [WebInvoke(Method = "GET",
           RequestFormat = WebMessageFormat.Json,
           ResponseFormat = WebMessageFormat.Json,
           UriTemplate = "/GetToyDetails/")]
        List<ToysDetailDataContract.ToyItemDataContract> GetToyDetails();    }

Iservice.Cs -> Complete Source Code

C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace Shanu_QuizWcfService
{.
     [ServiceContract]
    public interface IService1
    {
        [OperationContract]
        [WebInvoke(Method = "GET",
           RequestFormat = WebMessageFormat.Json,
           ResponseFormat = WebMessageFormat.Json,
           UriTemplate = "/GetToyDetails/")]
        List<ToysDetailDataContract.ToyItemDataContract> GetToyDetails();
    }

    public class ToysDetailDataContract
    {
        [DataContract]
        public class ToyItemDataContract
        {
            [DataMember]
            public string Toy_ID { get; set; }

            [DataMember]
            public string Toy_Name { get; set; }

            [DataMember]
            public string Toy_Price { get; set; }

            [DataMember]
            public string Image_Name { get; set; }

            [DataMember]
            public string Item_Date { get; set; }

            [DataMember]
            public string AddedBy { get; set; }
        }
    }
}

Add Database using ADO.NET Entity Data Model

Right click your WCF project and select Add New Item->Select ADO.NET Entity Data Model and click Add.

Image 4

Select EF Designer from Database and click Next.

Image 5

Click New Connection.

Image 6

Here, we can select our Database Server Name and enter your DB server SQL Server Authentication User ID and Password. We have already created our data base as “ToysDB” so we can select the database and click OK.

Image 7

Click Next and select our tables need to be used and click Finish.

Here, we can see now we have created our shanuToyDetailsModel.

Image 8

Service1.SVC

In “Service.SVC.CS” implements IService Interface and override and define all the methods of Operation Contract.

For example, here we can see that I have implemented the IService1 in Service1 class. Created the Object for our Entity model and in GetToyDetails using LINQ Query.

C#
public class Service1 : IService1
    {
shanuToysDBEntities OME;

        public Service1()
        {
            OME = new shanuToysDBEntities();
        }

public List<ToysDetailDataContract.ToyItemDataContract> GetToyDetails()
        {
            var query = (from a in OME.ToysDetails
                         select a).Distinct();

            List<ToysDetailDataContract.ToyItemDataContract> ToyDetailList =
                 new List<ToysDetailDataContract.ToyItemDataContract>();

            query.ToList().ForEach(rec =>
            {
                ToyDetailList.Add(new ToysDetailDataContract.ToyItemDataContract
                {
                    Toy_ID = rec.Toy_ID,
                    Toy_Name = rec.Toy_Name,
                    Toy_Price = Convert.ToString(rec.Toy_Price),
                    Image_Name = rec.Image_Name,
                    Item_Date = Convert.ToString(rec.Item_Date),
                    AddedBy = rec.AddedBy
                });
            });
            return ToyDetailList;
        }

“Service.SVC.CS” - Complete Source Code

C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using shanu_AngularJsFilter.Model;

namespace shanu_AngularJsFilter
{
public class Service1 : IService1
    {
        shanuToysDBEntities OME;

        public Service1()
        {
            OME = new shanuToysDBEntities();
        }

public List<ToysDetailDataContract.ToyItemDataContract> GetToyDetails()
        {
            var query = (from a in OME.ToysDetails
                         select a).Distinct();

            List<ToysDetailDataContract.ToyItemDataContract> ToyDetailList =
                           new List<ToysDetailDataContract.ToyItemDataContract>();

            query.ToList().ForEach(rec =>
            {
                ToyDetailList.Add(new ToysDetailDataContract.ToyItemDataContract
                {
                    Toy_ID = rec.Toy_ID,
                    Toy_Name = rec.Toy_Name,
                    Toy_Price = Convert.ToString(rec.Toy_Price),
                    Image_Name = rec.Image_Name,
                    Item_Date = Convert.ToString(rec.Item_Date),
                    AddedBy = rec.AddedBy
                });
            });
            return ToyDetailList;
        }
    }
}

Web.Config

In WCF project “Web.Config”:

  1. Change <add binding="basicHttpsBinding" scheme="https" /> to <add binding="webHttpBinding" scheme="http" />
  2. Replace the </behaviors> to:
HTML
<endpointBehaviors>
        <behavior>
          <webHttp helpEnabled="True"/>
        </behavior>
      </endpointBehaviors>
    </behaviors>

Run WCF Service: -> Now we have created our WCF Rest service, let’s run and test our service. In our service URL, we can add our method name and we can see the JSON result data from database.

Image 9

Create MVC Web Application

So now we have completed our WCF and now it’s time to create our MVC Angular JS application.

We can add new project to our existing project and create new MVC web Application as below.

Right click your Solution and click Add New Project -> Enter your project Name and click OK.

Image 10

Select MVC and click OK.

Image 11

Now we have created our MVC application and, it’s time to add our WCF Service and install the Angular JS package to our solution.

Add WCF Service: Right click MVC Solution and click Add ->click Service Reference.

Image 12

Enter your WCF URL and click GO. Here, my WCF URL is http://localhost:5029/Service1.svc/.

Add your name and click OK.

Now we have successfully added our WCF Service to our MVC Application.

Image 13

Steps to Install Angular JS Package

Right click your MVC project and Click-> Manage NuGet Packages.

Image 14

Select Online and Search for Angular JS. Select the AngularJs and click Install.

Image 15

Now we have Installed AngularJS package to our MVC Project. Now let’s create our Angular Js

  • Modules.js
  • Controllers.js
  • Services.js

Steps to Create Angular JS Script Files

Right click Script folder and create your own folder to create our Angular Js Model/Controller and Service JavaScript. In your script folder, add three JavaScript file and name as Modules.js, Controllers.js and Services.js as below:

Image 16

Modules.js: Here, we add the reference to the Angular.js JavaScript. In our application, we are going to use AngularJs animation. In order to use the animation, we need to add the “angular-animate.js” and “angular-animate.min.js”. We give our module name as “RESTClientModule” and to use the animation, we need to pass the parameter to our module as 'ngAnimate'.

JavaScript
/// <reference path="../angular.js" />
/// <reference path="../angular.min.js" />
/// <reference path="../angular-animate.js" />
/// <reference path="../angular-animate.min.js" />
var app;
(function () {
    app = angular.module("RESTClientModule", ['ngAnimate']);
})();

Services.js: Here, we add the reference to the Angular.js JavaScript and our Module.js.

Here, we give name to our service and we use this name in controllers.js. Here, for Angular service, I have given the name as "AngularJs_WCFService". You can give your own name, but careful about changing the name in Controllers.js. Here, we can see in method as I have passed the URL of our WCF Service URL.

JavaScript
/// <reference path="../angular.js" />
/// <reference path="../angular.min.js" />
/// <reference path="../angular-animate.js" />
/// <reference path="../angular-animate.min.js" />
/// <reference path="Modules.js" />

app.service("AngularJs_WCFService", function ($http) {
    //Get Order Master Records
    this.GetToyDetails = function () {
        return $http.get("http://localhost:5029/Service1.svc/GetToyDetails/");
    };
});

Controllers.js: Here, we add the reference to the Angular.js JavaScript and our Module.js and Services.js. Same like Services, for the controller, I have given the name as "AngularJs_WCFController".

In Controller, I have performed all the business logic and return the data from WCF JSON data to our MVC HTML page.

  1. Variable Declarations

    First, I declared all the local Variable which needs to be used and current date and store the date using $scope.date.

  2. Methods
    • GetToyDetails(): This method is used to get all the details of Toys from the JSON and bind the result to the main page.
    • $scope.showImage
  3. $scope.showImage = function (imageNm, ToyCode, ToyName, ToyPrize,animatval) {

    In Image mouse over, we get the details and display the data and image in detail view. In this method, I have used the $scope.showAnim Boolean value to Fade In and fade out the Image in details display.

Controller.js Full Source Code

JavaScript
/// <reference path="../angular.js" />
/// <reference path="../angular.min.js" />
/// <reference path="../angular-animate.js" />
/// <reference path="../angular-animate.min.js" />
/// <reference path="Modules.js" />
/// <reference path="Services.js" />

app.controller("AngularJs_WCFController",
function ($scope,$timeout, $rootScope, $window, AngularJs_WCFService) {
    $scope.date = new Date();
    // To show and Hide the Table to display  Character Type Selection and Question
    var firstbool = true;
    $scope.Imagename = "";
    $scope.ToyCode = "";
    $scope.ToyName = "";
    $scope.ToyPrize = "";
    $scope.showAnim = true;

GetToyDetails();
    // To Get All Records
    function GetToyDetails() {

        var promiseGet = AngularJs_WCFService.GetToyDetails();
        promiseGet.then(function (pl) {
            $scope.getToyDetailsDisp = pl.data
            if($scope.getToyDetailsDisp.length>0)
            {
                $scope.Imagename = $scope.getToyDetailsDisp[0].Image_Name;
                $scope.ToyCode = $scope.getToyDetailsDisp[0].Toy_ID;
                $scope.ToyName = $scope.getToyDetailsDisp[0].Toy_Name;
                $scope.ToyPrize = $scope.getToyDetailsDisp[0].Toy_Price;
            }
            else {
                $scope.Imagename = "";
                $scope.ToyCode ="";
                $scope.ToyName = "";
                $scope.ToyPrize = "";
            }
        },
             function (errorPl) {
             });
    }

    $scope.showImage = function (imageNm, ToyCode, ToyName, ToyPrize,animatval) {
        $scope.Imagename = imageNm;
        $scope.ToyCode = ToyCode;
        $scope.ToyName = ToyName;
        $scope.ToyPrize = ToyPrize;
        if(animatval==1)
        {
            $scope.showAnim = false;
        }
        else
        {
            $scope.showAnim = true;
        }
    }});

So now, we have created our Angular Js Module /Controller and Service. So what is next?

Create MVC Control and View to Display Our Result

Add Controller

Right click Controllers->Add Controller ->Select MVC 5 ControllerEmpty->click Add.

Image 17

Change the Controller name and here I have given the name as “WhosinYourMindController” and click OK.

Add View: Right click on Controller Index and click Add View.

Image 18

Index View: Name the View as “Index”.

In View Design your page and reference of angular.Js, Modules.js, Services.js and Controllers.js.

In Angular JS, we use {{ }} to bind or display the data.

Here, we can see first I create one table and for that table.

First in table, I have used the data-ng-controller="AngularJs_WCFController" and here, we can see data-ng-controller will be used to bound the data of controller to our HTML table.

  1. Data Bind using Data-ng-repeat and added Filter and Order By to the details in order to perform the Filter and Sorting to our display.
    HTML
    <tbody data-ng-repeat="detail in getToyDetailsDisp | filter:search  | 
    orderBy:predicate:reverse" ng-animate="{enter: 'animate-enter', leave: 'animate-leave'}">

    Here, I have used ng-animate to display the data while loading with fade In animation.

  2. Filter textbox as in column headers.
    HTML
    <input ng-model="search.Toy_ID" style="width:100px">
    
    <input ng-model="search.Toy_Name" >

    Here, we can see I have used the textbox to filter each column by their field name.

  3. Sort: When user clicks on Table Heading TD, I will sort appropriate column by using ng-click event:
    HTML
    <td ng-click="predicate = 'Toy_Name'; reverse=!reverse">
                                <b>Toy Name</b>
                            </td>
  4. Image Mouse Over and Mouse Event to display the detail image with animation.
    HTML
    <img src="~/Images/Thumb/{{detail.Image_Name}}" alt="{{detail.Toy_Name}}" 
     ng-mouseover="showImage(detail.Image_Name,detail.Toy_ID,detail.Toy_Name,detail.
    
    Toy_Price,1)" ng-mouseleave="showImage(detail.Image_Name,detail.Toy_ID,detail.Toy_Name,
    
    detail.Toy_Price,2)">

In Detail image:

HTML
<div>
     <div class="animate-show" ng-show="showAnim">
         <img alt="" src="~/Images/Actual/{{Imagename}}" />
      </div>
</div>

Complete HTML Code

HTML
<style type="text/css">
    .ng-enter
      {
          -webkit-transition: 1s;
          transition: 1s;
          opacity:0;
      }
      .ng-enter-active
      {
            -webkit-transition: 1s;
          transition: 1s;
          opacity:1;
      }
      .ng-leave
      {
          -webkit-transition: 1s;
          transition: 1s;
      }

      .ng-leave-active
      {
          opacity:0;
      }

      .animate-show {
  opacity: 1;
}

.animate-show.ng-hide-add.ng-hide-add-active,
.animate-show.ng-hide-remove.ng-hide-remove-active {
  -webkit-transition: all linear 0.5s;
  transition: all linear 0.5s;
}

.animate-show.ng-hide {
  opacity: 0;
}

</style>
<html data-ng-app="RESTClientModule">
@{
    ViewBag.Title = "Angular JS Filters and Sorting";
}

<body>
    <img src="~/Images/blank.gif" alt="" width="1" height="10" />
    <table width="99%" style=" border-bottom:3px solid #3273d5;">
        <tr>
            <td width=" 250">
                <table width="99%">
                    <tr>
                        <td>
                            Welcome Mr. {{'SHANU'}} .
                        </td>
                    </tr>
                </table>
            </td>

            <td class="style1" align="center">
                <h3>Shanu - ANgularJs Filter and Sorting with
                    simple Animation using MVC and WCF Rest Service  :)</h3>

            </td>
            <td align="right">
                <div ng-controller="AngularJs_WCFController">
                    Today Date is :
                    {{date | date:'yyyy-MM-dd'}}
                </div>
            </td>
        </tr>
    </table>
    <img src="~/Images/blank.gif" alt="" width="1" height="10" />

    <table id="tblContainer" data-ng-controller="AngularJs_WCFController"
     style='width: 99%;table-layout:fixed;'>
        <tr>
            <td >
                <table style=" background-color:#FFFFFF; border: solid 2px #6D7B8D;
                 padding: 5px;width: 99%;table-layout:fixed;"
                 cellpadding="2" cellspacing="2">
     <tr style="height: 30px; background-color:#336699 ; color:#FFFFFF ;
         border: solid 1px #659EC7;">
                        <td >
                            Toy Image
                        </td>
                        <td>
                            Toy Details
                        </td>
                    </tr>
     <tr style="height: 30px; background-color:#FFFFFF ; color:#336699 ;
         border: solid 1px #659EC7;">
                        <td >
                            <div >
                                <div class="animate-show" ng-show="showAnim">
                                   <img alt="" src="~/Images/Actual/{{Imagename}}" />
                                </div>
                            </div>
                        </td>
                        <td>
                            <h3 style="color:#9F000F">
                             Toy Code : <b>{{ToyCode}} </b></h3><br />

                            <h3 style="color:#9F000F">
                             Toy Name : <b>{{ToyName}} </b></h3><br />

                            <h3 style="color:#9F000F">
                             Toy Price : <b>{{ToyPrize}} </b></h3><br />
                       </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
  <table style=" background-color:#FFFFFF; border: solid 2px #6D7B8D;
         padding: 5px;width: 99%;table-layout:fixed;" cellpadding="2" cellspacing="2">
     <tr style="height: 30px; background-color:#336699 ; color:#FFFFFF ;
                              border: solid 1px #659EC7;">
                        <td width="40" align="center">
                        <b>Image</b>
                        </td>
                        <td width="40" align="center" style="border: solid 1px #FFFFFF;
                            padding: 5px;table-layout:fixed;cursor: pointer;"
                            ng-click="predicate = 'Toy_ID'; reverse=!reverse">

                           <b>Toy Code</b>
                       </td>

                        <td width="120" align="center" style="border: solid 1px #FFFFFF;
                            padding: 5px;table-layout:fixed;cursor: pointer;"
                            ng-click="predicate = 'Toy_Name'; reverse=!reverse">
                            <b>Toy Name</b>
                        </td>

                        <td width="40" align="center" style="border: solid 1px #FFFFFF;
                            padding: 5px;table-layout:fixed;cursor: pointer;"
                            ng-click="predicate = 'Toy_Price'; reverse=!reverse">
                            <b>Price</b>
                        </td>

                        <td width="90" align="center" style="border: solid 1px #FFFFFF;
                            padding: 5px;table-layout:fixed;cursor: pointer;"
                            ng-click="predicate = 'Item_Date'; reverse=!reverse">
                            <b>Date</b>
                        </td>

                        <td width="90" align="center" style="border: solid 1px #FFFFFF;
                            padding: 5px;table-layout:fixed;cursor: pointer;"
                            ng-click="predicate = 'AddedBy'; reverse=!reverse">
                            <b>User Name</b>
                        </td>
                    </tr>
         <tr style="height: 30px; background-color:#336699 ; color:#FFFFFF ;
                                  border: solid 1px #659EC7;">
                        <td width="40" align="center">
                           Filter By ->
                        </td>
                    <td width="40" style="border: solid 1px #FFFFFF; padding: 5px;
                                   table-layout:fixed;">
                            <input ng-model="search.Toy_ID" style="width:100px">
                        </td>

  <td width="120" align="center" style="border: solid 1px #FFFFFF; padding: 5px;
                                 table-layout:fixed;">
                            <input ng-model="search.Toy_Name" placeholder="filter Name...">
                        </td>
 <td width="40" align="center" style="border: solid 1px #FFFFFF; padding: 5px;
                               table-layout:fixed;">
                        </td>
      <td width="90" align="center" style="border: solid 1px #FFFFFF; padding: 5px;
                                    table-layout:fixed;">
                            <input ng-model="search.Item_Date">
                        </td>
                        <td width="90" align="center" style="border: solid 1px #FFFFFF;
                                       padding: 5px;table-layout:fixed;">
                            <input ng-model="search.AddedBy">
                        </td>
                    </tr>
                    <tbody data-ng-repeat="detail in getToyDetailsDisp |
                           filter:search  | orderBy:predicate:reverse"
                           ng-animate="{enter: 'animate-enter', leave: 'animate-leave'}">
                        <tr>
                            <td align="center" style="border: solid 1px #659EC7;
                                padding: 5px;table-layout:fixed;">
                                <span style="color:#9F000F">
                                    <img src="~/Images/Thumb/{{detail.Image_Name}}"
                                         alt="{{detail.Toy_Name}}"
                                         ng-mouseover="showImage(detail.Image_Name,
                                         detail.Toy_ID,detail.Toy_Name,detail.Toy_Price,1)"

                                         ng-mouseleave="showImage(detail.Image_Name,
                                         detail.Toy_ID,detail.Toy_Name,detail.Toy_Price,2)">
                                </span>
                            </td>
                            <td style="border: solid 1px #659EC7; padding: 5px;
                                table-layout:fixed;">
                                <span style="color:#9F000F">
                                    {{detail.Toy_ID}}
                                </span>
                            </td>
                            <td style="border: solid 1px #659EC7; padding: 5px;
                                table-layout:fixed;">
                                <span style="color:#9F000F">
                                    {{detail.Toy_Name}}
                                </span>
                            </td>
                            <td align="right" style="border: solid 1px #659EC7;
                                              padding: 5px;table-layout:fixed;">
                                <span style="color:#9F000F">
                                    {{detail.Toy_Price}}
                                </span>
                            </td>
                            <td style="border: solid 1px #659EC7; padding: 5px;
                                table-layout:fixed;">
                                <span style="color:#9F000F">
                                    {{detail.Item_Date}}
                                </span>
                            </td>
                            <td style="border: solid 1px #659EC7; padding: 5px;
                                               table-layout:fixed;">
                                <span style="color:#9F000F">
                                    {{detail.AddedBy}}
                                </span>
                            </td>
                        </tr>
</table>
            </td>
        </tr>
</table>
    <img src="~/Images/blank.gif" alt="" width="1" height="10" />
</body>
</html>
<script src="~/Scripts/angular.js"></script>
<script src="~/Scripts/angular-animate.js"></script>
<script src="~/Scripts/angular-animate.min.js"></script>
<script src="~/Scripts/angular.min.js"></script>
<script src="~/Scripts/shanuAngularScript/Modules.js"></script>
<script src="~/Scripts/shanuAngularScript/Services.js"></script>
<script src="~/Scripts/shanuAngularScript/Controllers.js"></script>

Run Your Program

Here, we can see that when I run the program, first, I display all Toy details.

Image 19

Filter by Toy Name. Here, we can see in the Toy Name Filter, I have entered the car and in table, we can see only the toys names which has car.

Image 20

Next, we can see the same above result has been sort by Toy Code in reverse order.

Image 21

Note: In my application Image folder, I have added both Thumb and Actual image. In database, I have provided the same names as in both folders. If you need to add more photos, you can add in both folder and in database, kindly add the image name as in folder with new record or update with existing record.

Supported Browsers: Chrome and Firefox

History

  • 6th May, 2015: Initial version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)