How To Create Nested Grid Using Angular 8

Introduction : In this article we will learn how we create nested grid in angular 8.

How it will work ?

Here we are using the grid list to separate my page into small sections and in each section and we want to place a different component and one of these components is another smaller grid.

Prerequisite

Basic knowledge of Angular

Visual Studio Code must be installed

Angular CLI must be installed

Node JS must be installed

FRONT END

Step 1:Lets create a angular project using following npm command

1. ng new nestedGrid  

Step 2: Open the newly created project in visual studio code and install bootstrap in this project

1. npm install bootstrap --save  

Now open styles.css file and add Bootstrap file reference.To add reference in styles.css file add this line.

1. @import '~bootstrap/dist/css/bootstrap.min.css';  

Step 3 Now lets create a new component by using following command.

1. ng g c product  

Step 4 Now create a new service using the following command .

1. ng generate service product  

Step 5 Now open the 'product.component.html' and paste the following code to see the html template.

1. <div class="card">  
2.   <div class="card-body pb-0">  
3.     <h4 style="text-align: center;">Example of Angular Nested Grid</h4>  
4.     <div class="row">  
5.       <div class="col-12 col-md-12">  
6.         <div class="card">  
7.   
8.           <div class="card-body position-relative">  
9.             <div class="table-responsive cnstr-record product-tbl">  
10.               <table class="table table-bordered heading-hvr">  
11.                 <thead>  
12.                   <tr>  
13.                     <th> </th>  
14.                     <th width="50">Art.No  
15.                     </th>  
16.                     <th>Brand</th>  
17.                     <th>  
18.                       Price/Unit</th>  
19.                     <th>Provider</th>  
20.                     <th>P. Art. N</th>  
21.                     <th>S. A/C</th>  
22.                     <th>Buy A/C</th>  
23.                   </tr>  
24.                 </thead>  
25.   
26.                 <tbody *ngFor="let product of products; let i = index">  
27.   
28.                   <tr>  
29.                     <td align="center">  
30.                       <a class="expand-row" *ngIf="!hideme[i]" (click)="showProductCountryInfo(i,product.ProductId)">  
31.                         <img src="../../assets/Images/plus.png" />  
32.   
33.                       </a>  
34.                       <a class="expand-row" *ngIf="hideme[i]" (click)="hideme[i] = !hideme[i]">  
35.                         <img src="../../assets/Images/minus.png" />  
36.                       </a>  
37.                     </td>  
38.                     <td align="center">{{product.ArtNo}}</td>  
39.                     <td>{{product.Brand}}</td>  
40.                     <td>{{product.Price }}</td>  
41.                     <td>{{product.Provider}}</td>  
42.                     <td>{{product.ProviderArtNo}}</td>  
43.                     <td>{{product.SalesAccount}}</td>  
44.                     <td>{{product.BuyAccount}}</td>  
45.                   </tr>  
46.   
47.                   <!-- <div id="myresult" class="img-zoom-result"></div> -->  
48.                   <tr [hidden]="!hideme[i]" class="sub-table no-bg">  
49.                     <td align="center"> </td>  
50.                     <td colspan="15" class="p-0">  
51.                       <table class="table mb-0 table-striped">  
52.                         <thead class="bg-dark text-white">  
53.                           <tr>  
54.                             <th>CountryName</th>  
55.                             <th>Price/Unit</th>  
56.                             <th>Sales Account</th>  
57.                             <th>Buy Account</th>  
58.                               
59.                           </tr>  
60.                         </thead>  
61.                         <tbody>  
62.                           <tr *ngFor="let productCountryInfo of productCountryInformation[i]">  
63.                             <td>{{productCountryInfo.CountryName}}</td>  
64.                             <td>{{productCountryInfo.Price}}</td>  
65.                             <td>{{productCountryInfo.SalesAccount}}</td>  
66.                             <td>{{productCountryInfo.BuyAccount}}</td>  
67.                              
68.                           </tr>  
69.                         </tbody>  
70.                       </table>  
71.                     </td>  
72.                   </tr>  
73.   
74.                 </tbody>  
75.               </table>  
76.             </div>  
77.           </div>  
78.         </div>  
79.       </div>  
80.     </div>  
81.   </div>  
82. </div>  

Step 6 After then open 'product.component.ts' file and add the following code in this file where our logic has written.

1. import { Component, OnInit } from '@angular/core';  
2. import { ProductsService } from './products.service';  
3.   
4. @Component({  
5.   selector: 'app-products',  
6.   templateUrl: './products.component.html',  
7.   styleUrls: ['./products.component.css']  
8. })  
9. export class ProductsComponent implements OnInit {  
10.   
11.   products = [];  
12.   countryCode: any;  
13.   currencySymbol:any;  
14.   productCountryInformation: any = [];  
15.   hideme = [];  
16.   Index: any;  
17.   countryId: any;  
18.   country: any;  
19.   priceToDisplay=[];  
20.   
21.    constructor(private _productService: ProductsService) {  
22.   }  
23.   ngOnInit() {  
24.   
25.     this.countryId=0;  
26.     this.getProducts(this.countryId);  
27.   }  
28.   
29.   public getProducts(countryId) {  
30.     let data = [];  
31.     this._productService.getAllProducts(countryId).subscribe((data: any) => {  
32.       this.products =data;  
33.         
34.     })  
35.   
36.   }  
37.   public showProductCountryInfo(index,productId) {  
38.     this._productService.countryInfo(productId).subscribe((res:any)=>{  
39.       this.productCountryInformation[index] = res;  
40.     })  
41.     this.hideme[index] = !this.hideme[index];  
42.     this.Index = index;  
43.   }  
44.   
45. }  

Step 7 Next open 'product.component.css'  file and paste the code for some styling.

@charset "utf-8";   

/* CSS Document */  

@media all{  

    *{padding:0px;margin:0px;}  

div{vertical-align:top;}  

img{max-width:100%;}  

html {-webkit-font-smoothing:antialiased; -moz-osx-font-smoothing:grayscale;}  

body{overflow:auto!important; width:100%!important;}  

html, body{background-color:#e4e5e6;}  

html {position:relative; min-height:100%;}  

  

  

.card{border-radius:4px;}  

.card-header:first-child {border-radius:4px 4px 0px 0px;}  

  

/*Typekit*/  

html, body{font-family:'Roboto', sans-serif; font-weight:400; font-size:13px;}  

body{padding-top:52px;}  

  

p{font-family:'Roboto', sans-serif; color:#303030; font-weight:400; margin-bottom:1rem;}  

input, textarea, select{font-family:'Roboto', sans-serif;}  

  

h1,h2,h3,h4,h5,h6{font-family:'Roboto', sans-serif; font-weight:700;}  

h1{font-size:20px; color:#000000; margin-bottom:10px;}  

h2{font-size:30px;}  

h3{font-size:24px;}  

h4{font-size:18px;}  

h5{font-size:14px;}  

h6{font-size:12px;}  

  

.row {margin-right:-8px; margin-left:-8px;}  

.col, .col-1, .col-10, .col-11, .col-12, .col-2, .col-3, .col-4, .col-5, .col-6, .col-7, .col-8, .col-9, .col-auto, .col-lg, .col-lg-1, .col-lg-10, .col-lg-11, .col-lg-12, .col-lg-2, .col-lg-3, .col-lg-4, .col-lg-5, .col-lg-6, .col-lg-7, .col-lg-8, .col-lg-9, .col-lg-auto, .col-md, .col-md-1, .col-md-10, .col-md-11, .col-md-12, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-auto, .col-sm, .col-sm-1, .col-sm-10, .col-sm-11, .col-sm-12, .col-sm-2, .col-sm-3, .col-sm-4, .col-sm-5, .col-sm-6, .col-sm-7, .col-sm-8, .col-sm-9, .col-sm-auto, .col-xl, .col-xl-1, .col-xl-10, .col-xl-11, .col-xl-12, .col-xl-2, .col-xl-3, .col-xl-4, .col-xl-5, .col-xl-6, .col-xl-7, .col-xl-8, .col-xl-9, .col-xl-auto {padding-right:8px; padding-left:8px;}  

  

.card-header{background-color:#f0f3f5; border-bottom:1px solid #c8ced3; font-size:13px; font-weight:600; color:#464646; text-transform:uppercase; padding:.75rem 8px;}  

  

  

.cnstr-record th{white-space:nowrap;padding:.45rem .2rem; font-size:13px; border-bottom-width:0px!important;}  

.cnstr-record thead{background:#f0f3f5;}  

  

.cnstr-record .form-control{font-size:13px; padding:0px 0rem 0px 0.2rem; height:calc(2rem + 2px);}  

.cnstr-record select.form-control{padding-left:.05rem;}  

.cnstr-record .table td, .cnstr-record .table th {vertical-align:middle;}  

.cnstr-record .table td{padding:.3rem;}  

.cnstr-record .table td h4{margin:0px;}  

  

.wp-50{width:50px;}  

.wp-60{width:60px;}  

.wp-70{width:70px;}  

.wp-80{width:80px;}  

.wp-90{width:90px;}  

.wp-100{width:100px;}  

.mw-auto{min-width:inherit;}  

.expand-row{width:100%; border:solid 1px #596269; display:inline-block; border-radius:3px; width:16px; height:16px; vertical-align:top; background:#596269; color:#ffffff!important;}  

.expand-row img{vertical-align:top; position:relative; top:2px;}  

.sub-table th{font-weight:400; font-size:12px;}  

.sub-table td{background:#efefef;}  

.no-bg td{background:inherit;}  

.mw-100{max-width:100%;}  

  

}  

Step 8 At last open 'product.service.ts' file and add services to call our api.

1. import { Injectable } from '@angular/core';  
2. import { HttpClient } from '@angular/common/http';  
3.   
4.   
5. @Injectable()  
6.   
7.   
8. export class ProductsService {  
9.   
10.     private url = ""; 
11.   
12.     constructor(public http: HttpClient) {  
13.     }  
14.   
15.     getAllProducts(countryCode) {  
16.         this.url = 'http://localhost:49661/api/Company/getAllProducts?countryCode='+countryCode;  
17.         return this.http.get<any[]>(this.url);  
18.     }  
19.      
20.     countryInfo(productId) {  
21.         this.url = 'http://localhost:49661/api/Company/getProductCountryInformation?productId='+productId;  
22.         return this.http.get<any[]>(this.url);  
23.     }  
24. }  

Step 9:Its time to see the output in your terminal type 'ng serve -o' to compile and open it in browser.

After loading our page you can see the output like below images

 

Here i am taking product for example,grid data is related to product and their corresponding nested grid having information related to their parent grid.

You can check nested grid by clicking the plus icon of parent grid so that you can see the resultant nested grid based on the index i.e if you click on very 1st plus icon then you can only see its first product related information, if you click on second plus icon then their product related information would show.

Now Front end part is done and its time to add server side code and back end code.

WEB API

Create an ASP.NET Core application

Follow these steps to create an ASP.NET Core application.

Step 1: In Visual Studio 2019, click on File -> New -> Project.

 

Step 2: Choose the Create option and select Asp.net web Application.

 

Step 3: Select WebApi and click on Ok.

 

Step 4: Now right click on controller and add and then new item.

 

Step 5: Choose Ado.net Entity Data Model and then click on Add.

 

Step 6.Next Step is EF Designer just click on next .

 

Step 7: New Pop up will come click on next if your is not established then click on new connection.

 

Step 8:Copy your database connection server name and paste it in server name text box after then you will see all the database select your database and click on OK.

 

Step 9: Next pop up will come paste your database server name choose for the database and test for the connection then click on next here in new screen select your tables and store procedure and click on finish.

 

 Our Next Step is to Right-click on the Controllers folder and add a new controller. Name it as "Product controller" and add the following namespace in the Student controller.

Here is  the complete code to for getting all the products data and there nested product information data.

Complete Product controller code 

1. using System.Linq;  
2. using System.Web.Http;  
3. using CompanyDetails.Models;  
4. namespace CompanyDetails.Controllers  
5. {  
6.     [RoutePrefix("api/Company")]  
7.     public class CompanyController : ApiController  
8.     {  
9.         CompanyEntities2 DB = new CompanyEntities2();  
10.      
11.         [HttpGet]  
12.         [Route("getAllCountry")]  
13.         public object getAllCountry()  
14.         {  
15.             return DB.Countries.ToList();  
16.         }  
17.   
18.         [HttpGet]  
19.         [Route("getAllProducts")]  
20.         public object getAllProducts(string countrycode)  
21.         {  
22.             var productDetails = DB.USP_GetAllProducts().ToList();  
23.             return productDetails;  
24.         }  
25.   
26.         [HttpGet]  
27.         [Route("getProductCountryInformation")]  
28.         public object getProductCountryInformation(int ProductId)  
29.         {  
30.             var prod = DB.USP_getCountryInfo(ProductId).ToList();           
31.             return prod;  
32.         }  
33.     }  
34. }  

Now, its time to enable CORS. Go to Tools, open NuGet Package Manager, search for CORS, and install the "Microsoft.Asp.Net.WebApi.Cors" package.

If you are running your front end application in different port and your server is running in other port then to avoid Cross-Origin-Resource-Sharing issue you have to add small code in webapiconfig.cs file.

Open Webapiconfig.cs and add the following lines.

1. EnableCorsAttribute cors = new EnableCorsAttribute("*", "*", "*");
2. config.EnableCors(cors); 

BACK END

Here Back-end related code we will do it using SQL server

The very first step is to create a database

Create database

Let’s create a database on your local SQL Server. I hope you have installed SQL Server 2017 in your machine (you can use SQL Server 2008, 2012, or 2016, as well).

Step 1 create database product

1. create database product  

Step 2 Create Product Table by using the following code

1. USE [Product]  
2. GO  
3.   
4. /****** Object:  Table [dbo].[Product]    Script Date: 12/18/2019 10:23:19 PM ******/  
5. SET ANSI_NULLS ON  
6. GO  
7.   
8. SET QUOTED_IDENTIFIER ON  
9. GO  
10.   
11. CREATE TABLE [dbo].[Product](  
12.     [ProductId] [int] IDENTITY(1,1) NOT NULL,  
13.     [ProductCountryInformationId] [int] NULL,  
14.     [ArtNo] [nvarchar](50) NULL,  
15.     [Provider] [nvarchar](50) NULL,  
16.     [ProviderArtNo] [nvarchar](50) NULL,  
17.     [Brand] [nvarchar](50) NULL,  
18.  CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED   
19. (  
20.     [ProductId] ASC  
21. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
22. ) ON [PRIMARY]  
23. GO  
24.   
25. ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_ProductCountryInformation] FOREIGN KEY([ProductCountryInformationId])  
26. REFERENCES [dbo].[ProductCountryInformation] ([ProductCountryInformationId])  
27. GO  
28.   
29. ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductCountryInformation]  
30. GO  

Make product id as primary key

Step 3 Create Product Information Table by using the following code

1. USE [Product]  
2. GO  
3.   
4. /****** Object:  Table [dbo].[ProductCountryInformation]    Script Date: 12/18/2019 10:24:02 PM ******/  
5. SET ANSI_NULLS ON  
6. GO  
7.   
8. SET QUOTED_IDENTIFIER ON  
9. GO  
10.   
11. CREATE TABLE [dbo].[ProductCountryInformation](  
12.     [ProductCountryInformationId] [int] NOT NULL,  
13.     [Price] [decimal](18, 2) NULL,  
14.     [BuyAccount] [nvarchar](50) NULL,  
15.     [SalesAccount] [nvarchar](50) NULL,  
16.     [CountryName] [nvarchar](50) NULL,  
17.     [ProductId] [int] NULL,  
18.  CONSTRAINT [PK_ProductCountryInformation] PRIMARY KEY CLUSTERED   
19. (  
20.     [ProductCountryInformationId] ASC  
21. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
22. ) ON [PRIMARY]  
23. GO  
24.   
25. ALTER TABLE [dbo].[ProductCountryInformation]  WITH CHECK ADD  CONSTRAINT [FK_ProductCountryInformation_Product] FOREIGN KEY([ProductId])  
26. REFERENCES [dbo].[Product] ([ProductId])  
27. GO  
28.   
29. ALTER TABLE [dbo].[ProductCountryInformation] CHECK CONSTRAINT [FK_ProductCountryInformation_Product]  
30. GO  
31.   
32. ALTER TABLE [dbo].[ProductCountryInformation]  WITH CHECK ADD  CONSTRAINT [FK_ProductCountryInformation_ProductCountryInformation] FOREIGN KEY([ProductCountryInformationId])  
33. REFERENCES [dbo].[ProductCountryInformation] ([ProductCountryInformationId])  
34. GO  
35.   
36. ALTER TABLE [dbo].[ProductCountryInformation] CHECK CONSTRAINT [FK_ProductCountryInformation_ProductCountryInformation]  
37. GO  

Now its time to add some Store Procedures

Step 4: All you have to do is paste the following code in new query

1. USE [Product]  
2. GO  
3. /****** Object:  StoredProcedure [dbo].[USP_GetAllProducts]    Script Date: 12/18/2019 10:24:35 PM ******/  
4. SET ANSI_NULLS ON  
5. GO  
6. SET QUOTED_IDENTIFIER ON  
7. GO  
8. ALTER Proc [dbo].[USP_GetAllProducts]  
9. As  
10. Begin  
11.     Select  p.*,pci.Price,pci.BuyAccount,pci.SalesAccount from [Product] p    
12.   left join [ProductCountryInformation] pci    
13.   on p.ProductCountryInformationId=pci.ProductCountryInformationId   
14. End  
15.   

1. USE [Product]    
2. GO    
3. /****** Object:  StoredProcedure [dbo].[USP_getCountryInfo]    Script Date: 12/18/2019 10:24:57 PM ******/    
4. SET ANSI_NULLS ON    
5. GO    
6. SET QUOTED_IDENTIFIER ON    
7. GO    
8. ALTER Proc [dbo].[USP_getCountryInfo]    
9. @ProductId int    
10. As    
11. Begin    
12.     select pci.* from ProductCountryInformation pci     
13.     left join Product p on pci.ProductId=p.ProductId     
14.     where pci.ProductId=@ProductId    
15. End   

With this step we have successfully completed our front end ,web API and back end coding.

Conclusion:In this article i have discussed how we create nested grid  in Angular 8 Application and in my next article which is a continuation of this part we are going to learn about JavaScript function tolocalestring() by changing the price by changing the country and it give their appropriate currency format (Uploading very soon).

Please give your valuable feedback/comments/questions about this article. Please let me know if you liked and understood this article and how I could improve it.