C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
using System.ComponentModel.DataAnnotations;
using System.Collections.Generic;

namespace HelloWorldMvcApp
{
	public class SampleViewModel
	{		
		public string Request {get;set;}
        public List<BasicTicketData> Tickets {get;set;}

		public SampleViewModel(List<BasicTicketData> tickets)
        {
            Tickets = tickets;
        }
		public SampleViewModel()
        {
           
        }
		
	}
	
	public class RequestData
	{
		public string Request {get;set;}
	}
	
	   public class BasicTicketData
    {
        /// <summary>
        /// Gets or sets the Internal Ticket Id.
        /// </summary>
        public int Id { get; set; }



        /// <summary>
        /// Gets or sets the Status of the ticket.
        /// </summary>
        public string Status { get; set; }



        /// <summary>
        /// Gets or sets the Title of the ticket.
        /// </summary>
        public string Title { get; set; }



        /// <summary>
        /// Gets or sets the Description of the ticket.
        /// </summary>
        public string Description { get; set; }



        /// <summary>
        /// Gets or sets the impact of the ticket.
        /// </summary>
        public string Impact { get; set; }


        /// <summary>
        /// Gets or sets the Name of the customer.
        /// </summary>
        public string CustomerName { get; set; }



        public string ReportedBy { get; set; }



        /// <summary>
        /// Gets or sets the creation time of the ticket.
        /// </summary>
        public DateTime CreationTime { get; set; }



    }

}

Model

​x
 
using System;
using System.ComponentModel.DataAnnotations;
using System.Collections.Generic;
​
namespace HelloWorldMvcApp
{
    public class SampleViewModel
    {       
        public string Request {get;set;}
        public List<BasicTicketData> Tickets {get;set;}
​
        public SampleViewModel(List<BasicTicketData> tickets)
        {
            Tickets = tickets;
        }
        public SampleViewModel()
        {
           
        }
        
    }
    
    public class RequestData
    {
        public string Request {get;set;}
    }
    
       public class BasicTicketData
    {
        /// <summary>
        /// Gets or sets the Internal Ticket Id.
        /// </summary>
        public int Id { get; set; }
​
​
​
        /// <summary>
        /// Gets or sets the Status of the ticket.
        /// </summary>
        public string Status { get; set; }
​
​
​
        /// <summary>
        /// Gets or sets the Title of the ticket.
        /// </summary>
        public string Title { get; set; }
​
​
​
        /// <summary>
        /// Gets or sets the Description of the ticket.
        /// </summary>
        public string Description { get; set; }
​
​
​
        /// <summary>
        /// Gets or sets the impact of the ticket.
        /// </summary>
        public string Impact { get; set; }
​
​
        /// <summary>
        /// Gets or sets the Name of the customer.
        /// </summary>
        public string CustomerName { get; set; }
​
​
​
        public string ReportedBy { get; set; }
​
​
​
        /// <summary>
        /// Gets or sets the creation time of the ticket.
        /// </summary>
        public DateTime CreationTime { get; set; }
​
​
​
    }
​
}

@model HelloWorldMvcApp.SampleViewModel
@{
	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>

		<!-- CSS Includes -->
		<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
		
		<style type="text/css">

			.field-validation-error {
				color: #ff0000;
			}

		</style>
	</head>
	
	<body>
		
		<div class="container">
			<table id="tickets" class="display" style="width:90%">
			<thead>
        <tr>
            <th>Status</th>
            <th>Title</th>
            <th>Description</th>
			<th>Impact</th>
            <th>Customer</th>
            <th>Contact</th>
            <th>Creation Date</th>
            <th>ID</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var ticket in Model.Tickets){
            <tr>
                <td>@ticket.Status</td>
                <td>@ticket.Title</td>
                <td>@ticket.Description</td>
                <td>@ticket.Impact</td>
                <td>@ticket.CustomerName</td>
                <td>@ticket.ReportedBy</td>
                <td>@ticket.CreationTime</td>
                <td>@ticket.Id</td>
            </tr>
        }
    </tbody>
			</table>

			<button type="button" class="btn btn-success submitOpen">All Open</button>
			<button type="button" class="btn btn-success submitActive">Only Active</button>
		</div>

		<!-- JS includes -->
		
		
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
    	<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
		<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
		<script src="https://cdn.datatables.net/fixedheader/3.2.3/js/dataTables.fixedHeader.min.js"></script>
		<script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
		<script type="text/javascript">
$(document).ready(formatTable());
			
			function formatTable()
			{
			  // Setup - add a text input to each footer cell
				$('#tickets thead tr')
					.clone(true)
					.addClass('filters')
					.appendTo('#tickets thead');

				var table = $('#tickets').DataTable({
			 order: [[5, 'desc']],
					orderCellsTop: true,
					fixedHeader: true,
					initComplete: function () {
						var api = this.api();

						// For each column
						api
							.columns()
							.eq(0)
							.each(function (colIdx) {
								// Set the header cell to contain the input element
								var cell = $('.filters th').eq(
									$(api.column(colIdx).header()).index()
								);
								var title = $(cell).text();
								$(cell).html('<input type="text" placeholder="' + title + '" />');

								// On every keypress in this input
								$(
									'input',
									$('.filters th').eq($(api.column(colIdx).header()).index())
								)
									.off('keyup change')
									.on('change', function (e) {
										// Get the search value
										$(this).attr('title', $(this).val());
										var regexr = '({search})'; //$(this).parents('th').find('select').val();

										var cursorPosition = this.selectionStart;
										// Search the column for that value
										api
											.column(colIdx)
											.search(
												this.value != ''
													? regexr.replace('{search}', '(((' + this.value + ')))')
													: '',
												this.value != '',
												this.value == ''
											)
											.draw();
									})
									.on('keyup', function (e) {
										e.stopPropagation();

										$(this).trigger('change');
										$(this)
											.focus()[0]
											.setSelectionRange(cursorPosition, cursorPosition);
									});
							});
					},
				});
			}
			
			function populateTable(jsonData) {
				var oTable = $("#tickets").dataTable();

				oTable.fnClearTable();
				loadTable('tickets', ['Status', 'Title', 'Description', 'Impact', 'Customer','ReportedBy','CreationTime', 'Id'], jsonData);	
			}
			
			function loadTable(tableId, fields, data) {
				//$('#' + tableId).empty(); //not really necessary			
				var table = $('#' +tableId).DataTable();
					var rows = '';
					$.each(data, function(index, item) {
						var row = '<tr>';
						$.each(fields, function(index, field) {
							row += '<td>' + item[field+''] + '</td>';
						});
				var newRow = row + '<tr>';
				table.row.add($(newRow )).draw();
				});
			}
		
	
			
			$(function(){
						
				$('.submitActive').click(function(){
			
			var tickets = @Html.Raw(Json.Encode(Model.Tickets));
			
			
						var values = 
						{
						request:"Active",
							modelTickets: JSON.stringify(tickets),
						}
						getData(values);

					});


				$('.submitOpen').click(function(){
			
			var tickets = @Html.Raw(Json.Encode(Model.Tickets));
			
			
						var values = 
						{
						request:"Open",
						modelTickets: JSON.stringify(tickets),
						}
						getData(values);

					});

				function getData(request)
				{
			
					$.post("@Url.Action("GetTickets")",request,function(data)
					{
						populateTable(data);
					});		
				}		
			});
		</script>
	</body>
</html>

View

 
@model HelloWorldMvcApp.SampleViewModel
@{
    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>
​
        <!-- CSS Includes -->
        <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
        
        <style type="text/css">
​
            .field-validation-error {
                color: #ff0000;
            }
​
        </style>
    </head>
    
    <body>
        
        <div class="container">
            <table id="tickets" class="display" style="width:90%">
            <thead>
        <tr>
            <th>Status</th>
            <th>Title</th>
            <th>Description</th>
            <th>Impact</th>
            <th>Customer</th>
            <th>Contact</th>
            <th>Creation Date</th>
            <th>ID</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var ticket in Model.Tickets){
            <tr>
                <td>@ticket.Status</td>
                <td>@ticket.Title</td>
                <td>@ticket.Description</td>
                <td>@ticket.Impact</td>
                <td>@ticket.CustomerName</td>
                <td>@ticket.ReportedBy</td>
                <td>@ticket.CreationTime</td>
                <td>@ticket.Id</td>
            </tr>
        }
    </tbody>
            </table>
​
            <button type="button" class="btn btn-success submitOpen">All Open</button>
            <button type="button" class="btn btn-success submitActive">Only Active</button>
        </div>
​
        <!-- JS includes -->
        
        
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
        <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
        <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
        <script src="https://cdn.datatables.net/fixedheader/3.2.3/js/dataTables.fixedHeader.min.js"></script>
        <script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
        <script type="text/javascript">
$(document).ready(formatTable());
            
            function formatTable()
            {
              // Setup - add a text input to each footer cell
                $('#tickets thead tr')
                    .clone(true)
                    .addClass('filters')
                    .appendTo('#tickets thead');
​
                var table = $('#tickets').DataTable({
             order: [[5, 'desc']],
                    orderCellsTop: true,
                    fixedHeader: true,
                    initComplete: function () {
                        var api = this.api();
​
                        // For each column
                        api
                            .columns()
                            .eq(0)
                            .each(function (colIdx) {
                                // Set the header cell to contain the input element
                                var cell = $('.filters th').eq(
                                    $(api.column(colIdx).header()).index()
                                );
                                var title = $(cell).text();
                                $(cell).html('<input type="text" placeholder="' + title + '" />');
​
                                // On every keypress in this input
                                $(
                                    'input',
                                    $('.filters th').eq($(api.column(colIdx).header()).index())
                                )
                                    .off('keyup change')
                                    .on('change', function (e) {
                                        // Get the search value
                                        $(this).attr('title', $(this).val());
                                        var regexr = '({search})'; //$(this).parents('th').find('select').val();
​
                                        var cursorPosition = this.selectionStart;
                                        // Search the column for that value
                                        api
                                            .column(colIdx)
                                            .search(
                                                this.value != ''
                                                    ? regexr.replace('{search}', '(((' + this.value + ')))')
                                                    : '',
                                                this.value != '',
                                                this.value == ''
                                            )
                                            .draw();
                                    })
                                    .on('keyup', function (e) {
                                        e.stopPropagation();
​
                                        $(this).trigger('change');
                                        $(this)
                                            .focus()[0]
                                            .setSelectionRange(cursorPosition, cursorPosition);
                                    });
                            });
                    },
                });
            }
            
            function populateTable(jsonData) {
                var oTable = $("#tickets").dataTable();
​
                oTable.fnClearTable();
                loadTable('tickets', ['Status', 'Title', 'Description', 'Impact', 'Customer','ReportedBy','CreationTime', 'Id'], jsonData); 
            }
            
            function loadTable(tableId, fields, data) {
                //$('#' + tableId).empty(); //not really necessary          
                var table = $('#' +tableId).DataTable();
                    var rows = '';
                    $.each(data, function(index, item) {
                        var row = '<tr>';
                        $.each(fields, function(index, field) {
                            row += '<td>' + item[field+''] + '</td>';
                        });
                var newRow = row + '<tr>';
                table.row.add($(newRow )).draw();
                });
            }
        
    
            
            $(function(){
                        
                $('.submitActive').click(function(){
            
            var tickets = @Html.Raw(Json.Encode(Model.Tickets));
            
            
                        var values = 
                        {
                        request:"Active",
                            modelTickets: JSON.stringify(tickets),
                        }
                        getData(values);
​
                    });
​
​
                $('.submitOpen').click(function(){
            
            var tickets = @Html.Raw(Json.Encode(Model.Tickets));
            
            
                        var values = 
                        {
                        request:"Open",
                        modelTickets: JSON.stringify(tickets),
                        }
                        getData(values);
​
                    });
​
                function getData(request)
                {
            
                    $.post("@Url.Action("GetTickets")",request,function(data)
                    {
                        populateTable(data);
                    });     
                }       
            });
        </script>
    </body>
</html>
​

using System;
using System.Web.Mvc;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using Newtonsoft.Json;

namespace HelloWorldMvcApp
{
	
public class JsonFilter : ActionFilterAttribute
{
    public string Param { get; set; }
    public Type JsonDataType { get; set; }
    public override void OnActionExecuting(ActionExecutingContext filterContext)
    {
        if (filterContext.HttpContext.Request.ContentType.Contains("application/json"))
        {
            string inputContent;
            using (var sr = new StreamReader(filterContext.HttpContext.Request.InputStream))
            {
                inputContent = sr.ReadToEnd();
            }
            var result = JsonConvert.DeserializeObject(inputContent, JsonDataType);
            filterContext.ActionParameters[Param] = result;
        }
    }
}
	
	public class HomeController : Controller
	{
	
		private SampleViewModel myModel = null;
		
		[HttpGet]
		public ActionResult Index()
		{
		List<BasicTicketData>  tickets = new List<BasicTicketData>();
			tickets.Add(new BasicTicketData(){ Status = "New", Title = "Active ticket - new", Id = 1, Description="custom description", CreationTime = DateTime.Now.AddHours(-5) });
			tickets.Add(new BasicTicketData(){ Status = "In Progress", Title = "Active ticket - in progress", Id = 2,CreationTime = DateTime.Now.AddHours(-4)});
			tickets.Add(new BasicTicketData(){ Status = "In Progress (2nd)", Title = "Active ticket - 2nd line", Id = 3,CreationTime = DateTime.Now.AddHours(-3)});
			tickets.Add(new BasicTicketData(){ Status = "Folow-up", Title = "Open ticket - follow up", Id = 4,CreationTime = DateTime.Now.AddHours(-2)});
			tickets.Add(new BasicTicketData(){ Status = "Resolved", Title = "Open ticket - Resolved", Id = 5,CreationTime = DateTime.Now.AddHours(-1)});
			
			myModel = new SampleViewModel(tickets);
			return View(myModel);
		}

		[HttpPost]
		public JsonResult GetTickets(string request, string modelTickets)
		{	
			var allTickets = JsonConvert.DeserializeObject<List<BasicTicketData>>(modelTickets);
			List<JavaFormattedTicket>  tickets = new List<JavaFormattedTicket>();
			foreach(var ticket in allTickets)
			{
			
				JavaFormattedTicket formattedTicket = JavaFormattedTicket.Convert(ticket);
			
				if (request != "Open")
				{
					// Return limited data.
					if(formattedTicket.Status == "New" || formattedTicket.Status == "In Progress" || formattedTicket.Status == "In Progress (2nd)")
					{
						tickets.Add(formattedTicket);
					}
				}
				else
				{
					// Return all data passed from Model.
					tickets.Add(formattedTicket);
				}		
			}
			
			// Json only supports text and number vars, data needs to be formatted before sending it.
			return Json(tickets);
		}
		
		public class JavaFormattedTicket
		{
			public int Id {get;set;}
			public string Status {get;set;}
			public string Title {get;set;}
			public string Description { get; set; }
			public string Impact { get; set; }
			public string CustomerName { get; set; }
			public string ReportedBy { get; set; }
			public string CreationTime { get; set; }
			
			public static JavaFormattedTicket Convert (BasicTicketData ticket)
			{
			return new JavaFormattedTicket
			{
				Id = ticket.Id, //.ToString(),
				Status = ticket.Status,
				Title = ticket.Title,
				Description = ticket.Description,
				Impact = ticket.Impact == null ? "" : ticket.Impact, 
				CustomerName = ticket.CustomerName,
				ReportedBy = ticket.ReportedBy,
				CreationTime = ticket.CreationTime.ToLocalTime().ToString(),
			};
			}
		}
	}
}

Controller

 
using System;
using System.Web.Mvc;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using Newtonsoft.Json;
​
namespace HelloWorldMvcApp
{
    
public class JsonFilter : ActionFilterAttribute
{
    public string Param { get; set; }
    public Type JsonDataType { get; set; }
    public override void OnActionExecuting(ActionExecutingContext filterContext)
    {
        if (filterContext.HttpContext.Request.ContentType.Contains("application/json"))
        {
            string inputContent;
            using (var sr = new StreamReader(filterContext.HttpContext.Request.InputStream))
            {
                inputContent = sr.ReadToEnd();
            }
            var result = JsonConvert.DeserializeObject(inputContent, JsonDataType);
            filterContext.ActionParameters[Param] = result;
        }
    }
}
    
    public class HomeController : Controller
    {
    
        private SampleViewModel myModel = null;
        
        [HttpGet]
        public ActionResult Index()
        {
        List<BasicTicketData>  tickets = new List<BasicTicketData>();
            tickets.Add(new BasicTicketData(){ Status = "New", Title = "Active ticket - new", Id = 1, Description="custom description", CreationTime = DateTime.Now.AddHours(-5) });
            tickets.Add(new BasicTicketData(){ Status = "In Progress", Title = "Active ticket - in progress", Id = 2,CreationTime = DateTime.Now.AddHours(-4)});
            tickets.Add(new BasicTicketData(){ Status = "In Progress (2nd)", Title = "Active ticket - 2nd line", Id = 3,CreationTime = DateTime.Now.AddHours(-3)});
            tickets.Add(new BasicTicketData(){ Status = "Folow-up", Title = "Open ticket - follow up", Id = 4,CreationTime = DateTime.Now.AddHours(-2)});
            tickets.Add(new BasicTicketData(){ Status = "Resolved", Title = "Open ticket - Resolved", Id = 5,CreationTime = DateTime.Now.AddHours(-1)});
            
            myModel = new SampleViewModel(tickets);
            return View(myModel);
        }
​
        [HttpPost]
        public JsonResult GetTickets(string request, string modelTickets)
        {   
            var allTickets = JsonConvert.DeserializeObject<List<BasicTicketData>>(modelTickets);
            List<JavaFormattedTicket>  tickets = new List<JavaFormattedTicket>();
            foreach(var ticket in allTickets)
            {
            
                JavaFormattedTicket formattedTicket = JavaFormattedTicket.Convert(ticket);
            
                if (request != "Open")
                {
                    // Return limited data.
                    if(formattedTicket.Status == "New" || formattedTicket.Status == "In Progress" || formattedTicket.Status == "In Progress (2nd)")
                    {
                        tickets.Add(formattedTicket);
                    }
                }
                else
                {
                    // Return all data passed from Model.
                    tickets.Add(formattedTicket);
                }       
            }
            
            // Json only supports text and number vars, data needs to be formatted before sending it.
            return Json(tickets);
        }
        
        public class JavaFormattedTicket
        {
            public int Id {get;set;}
            public string Status {get;set;}
            public string Title {get;set;}
            public string Description { get; set; }
            public string Impact { get; set; }
            public string CustomerName { get; set; }
            public string ReportedBy { get; set; }
            public string CreationTime { get; set; }
            
            public static JavaFormattedTicket Convert (BasicTicketData ticket)
            {
            return new JavaFormattedTicket
            {
                Id = ticket.Id, //.ToString(),
                Status = ticket.Status,
                Title = ticket.Title,
                Description = ticket.Description,
                Impact = ticket.Impact == null ? "" : ticket.Impact, 
                CustomerName = ticket.CustomerName,
                ReportedBy = ticket.ReportedBy,
                CreationTime = ticket.CreationTime.ToLocalTime().ToString(),
            };
            }
        }
    }
}

View in Full Screen

Items count: 20
HashSet count: 5
3
4
2
1
5

Last Run:	9:48:40 am
Compile:	0.224s
Execute:	0.013s
Memory:	8kb
CPU:	0.016s

View IL Code