Kavi | C# Online Compiler

Kavi by kblau237

using System;
using System.ComponentModel.DataAnnotations;

namespace HelloWorldMvcApp
{
	 public class product
    {
        public int ProductId { get; set; }
        public string Name { get; set; }
        public string Code { get; set; }
        public decimal Price { get; set; }
        public int Available { get; set; }
        public byte[] is_deleted { get; set; }
    }
}

Model

​x
 
using System;
using System.ComponentModel.DataAnnotations;
​
namespace HelloWorldMvcApp
{
     public class product
    {
        public int ProductId { get; set; }
        public string Name { get; set; }
        public string Code { get; set; }
        public decimal Price { get; set; }
        public int Available { get; set; }
        public byte[] is_deleted { get; set; }
    }
}

@{
	Layout = null;
}

<!DOCTYPE html>
<!-- template from http://getbootstrap.com/getting-started -->

<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>Bootstrap 101 Template</title>

		 <style>
            body {
                padding-left: 50px;
                width: 80%;
            }
        </style>
			<link href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" />
			<link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" />
			<script src="https://code.jquery.com/jquery-1.12.4.min.js"
                integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ="
                crossorigin="anonymous"></script>
			<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
			 <script>
            $(document).ready(function () {
                $('#productsTable').DataTable({
                    "ajax": {
                        //using home controller instead of products
                        url: '@Url.RouteUrl(new{ action="GetData", controller="Home"})',
                        //"url": "/Products/GetData",
                        "type": "GET",
                        "datatype": "json"
                    },
                    "columns": [
                        { "data": "Name" },
                        { "data": "Code" },
                        { "data": "Price" },
                        { "data": "Available" }
                    ]

                });
            });
        </script>
	</head>
	
	<body>
		 <table id="productsTable" class="table table-striped table-bordered display">
            @*added display class*@
            <thead>
                <tr>
                    <th>Name</th>
                    <th>Code</th>
                    <th>Price</th>
                    <th>No of Products</th>
                </tr>
            </thead>
        </table>
		
		
		
					
						
	</body>
</html>

View

 
@{
    Layout = null;
}
​
<!DOCTYPE html>
<!-- template from http://getbootstrap.com/getting-started -->
​
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Bootstrap 101 Template</title>
​
         <style>
            body {
                padding-left: 50px;
                width: 80%;
            }
        </style>
            <link href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" />
            <link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" />
            <script src="https://code.jquery.com/jquery-1.12.4.min.js"
                integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ="
                crossorigin="anonymous"></script>
            <script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
             <script>
            $(document).ready(function () {
                $('#productsTable').DataTable({
                    "ajax": {
                        //using home controller instead of products
                        url: '@Url.RouteUrl(new{ action="GetData", controller="Home"})',
                        //"url": "/Products/GetData",
                        "type": "GET",
                        "datatype": "json"
                    },
                    "columns": [
                        { "data": "Name" },
                        { "data": "Code" },
                        { "data": "Price" },
                        { "data": "Available" }
                    ]
​
                });
            });
        </script>
    </head>
    
    <body>
         <table id="productsTable" class="table table-striped table-bordered display">
            @*added display class*@
            <thead>
                <tr>
                    <th>Name</th>
                    <th>Code</th>
                    <th>Price</th>
                    <th>No of Products</th>
                </tr>
            </thead>
        </table>
        
        
        
                    
                        
    </body>
</html>
​

using System;
using System.Web.Mvc;
using System.Collections.Generic;

namespace HelloWorldMvcApp
{
	public class HomeController : Controller
	{
		[HttpGet]
		public ActionResult Index()
		{
			return View();
		}

		 public ActionResult GetData()
        {
            List<product> proList = new List<product>{ new product { Available = 1, Code = "Code1", is_deleted = new byte[1],
                                                                         Name = "Name1", Price = 1.27M, ProductId = 1 },
                                                       new product { Available = 2, Code = "Code2", is_deleted = new byte[2],
                                                                         Name = "Name2", Price = 1.28M, ProductId = 2 },
                                                       new product { Available = 3, Code = "Code3", is_deleted = new byte[3],
                                                                         Name = "Name3", Price = 1.29M, ProductId = 3 } };

            return Json(new { data = proList }, JsonRequestBehavior.AllowGet);
        }
}
}

Controller

 
using System;
using System.Web.Mvc;
using System.Collections.Generic;
​
namespace HelloWorldMvcApp
{
    public class HomeController : Controller
    {
        [HttpGet]
        public ActionResult Index()
        {
            return View();
        }
​
         public ActionResult GetData()
        {
            List<product> proList = new List<product>{ new product { Available = 1, Code = "Code1", is_deleted = new byte[1],
                                                                         Name = "Name1", Price = 1.27M, ProductId = 1 },
                                                       new product { Available = 2, Code = "Code2", is_deleted = new byte[2],
                                                                         Name = "Name2", Price = 1.28M, ProductId = 2 },
                                                       new product { Available = 3, Code = "Code3", is_deleted = new byte[3],
                                                                         Name = "Name3", Price = 1.29M, ProductId = 3 } };
​
            return Json(new { data = proList }, JsonRequestBehavior.AllowGet);
        }
}
}

View in Full Screen

View IL Code