SO-40406540 | C# Online Compiler

SO-40406540 by Stephen Muecke

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

namespace HelloWorldMvcApp
{
	// Data models
	public class List
    {
        public string Variant { get; set; }
        public int Id { get; set; }
        public List<TestList> TestList { get; set; }
    }
    public class TestList
    {
        public List<SubVariantList> SubVariantList { get; set; }
    }
    public class SubVariantList
    {
        public int Id { get; set; }
		public int Order { get; set;}
        public string Name { get; set; }
        public decimal Fluctuation { get; set; }
    }
	// View models
    public class TableVM
    {
        public TableVM()
        {
            Variants = new List<RowVM>();
        }
        public string Title { get; set; }
        public string Key { get; set; }
        public bool IsSequential { get; set; }
        public List<RowVM> Variants { get; set; }
		public IEnumerable<string> Headers { get; set; }
		public int MaxColumns { get; set; }
    }
    public class RowVM
    {
        public RowVM()
        {
            Fluctuations = new List<ColumnVM>();
        }
        public string Variant { get; set; }
        public List<ColumnVM> Fluctuations { get; set; }
    }
    public class ColumnVM
    {
        public decimal Fluctuation { get; set; }
    }
	// Repository
	public static class Repository
	{
		public static List<List> FetchData()
		{
			return new List<List>()
            {
                new List()
                {
                    Variant = "V1",
                    Id = 1,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>()
                            {
                                new SubVariantList()
                                {
                                    Id = 10,
                                    Name = "A",
									Order = 1,
                                    Fluctuation = 100M
                                },
                                new SubVariantList()
                                {
                                    Id = 20,
                                    Name = "B",
									Order = 2,
                                    Fluctuation = 100M
                                },
                                new SubVariantList()
                                {
                                    Id = 30,
                                    Name = "C",
									Order = 3,
                                    Fluctuation = 200M
                                }
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V2",
                    Id = 2,
                    TestList = new List<TestList>()
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>()
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
									Order = 1,
                                    Fluctuation = 1100M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "B",
									Order = 2,
                                    Fluctuation = 1200M
                                },
                                new SubVariantList()
                                {
                                    Id = 60,
                                    Name = "C",
									Order = 3,
                                    Fluctuation = 1300M
                                }
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V3",
                    Id = 3,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
									Order = 1,
                                    Fluctuation = 500M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "C",
									Order = 3,
                                    Fluctuation = 600M
                                },
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V4",
                    Id = 4,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
									Order = 1,
                                    Fluctuation = 250M
                                },
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "B",
									Order = 2,
                                    Fluctuation = 450M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "C",
									Order = 3,
                                    Fluctuation = 650M
                                },
                               new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "D",
									Order = 4,
                                    Fluctuation = 750M
                                },
                            }
                        }
                    }
                }
            };
		}
	}

}

Model

​x
 
using System;
using System.ComponentModel.DataAnnotations;
using System.Collections.Generic;
​
namespace HelloWorldMvcApp
{
    // Data models
    public class List
    {
        public string Variant { get; set; }
        public int Id { get; set; }
        public List<TestList> TestList { get; set; }
    }
    public class TestList
    {
        public List<SubVariantList> SubVariantList { get; set; }
    }
    public class SubVariantList
    {
        public int Id { get; set; }
        public int Order { get; set;}
        public string Name { get; set; }
        public decimal Fluctuation { get; set; }
    }
    // View models
    public class TableVM
    {
        public TableVM()
        {
            Variants = new List<RowVM>();
        }
        public string Title { get; set; }
        public string Key { get; set; }
        public bool IsSequential { get; set; }
        public List<RowVM> Variants { get; set; }
        public IEnumerable<string> Headers { get; set; }
        public int MaxColumns { get; set; }
    }
    public class RowVM
    {
        public RowVM()
        {
            Fluctuations = new List<ColumnVM>();
        }
        public string Variant { get; set; }
        public List<ColumnVM> Fluctuations { get; set; }
    }
    public class ColumnVM
    {
        public decimal Fluctuation { get; set; }
    }
    // Repository
    public static class Repository
    {
        public static List<List> FetchData()
        {
            return new List<List>()
            {
                new List()
                {
                    Variant = "V1",
                    Id = 1,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>()
                            {
                                new SubVariantList()
                                {
                                    Id = 10,
                                    Name = "A",
                                    Order = 1,
                                    Fluctuation = 100M
                                },
                                new SubVariantList()
                                {
                                    Id = 20,
                                    Name = "B",
                                    Order = 2,
                                    Fluctuation = 100M
                                },
                                new SubVariantList()
                                {
                                    Id = 30,
                                    Name = "C",
                                    Order = 3,
                                    Fluctuation = 200M
                                }
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V2",
                    Id = 2,
                    TestList = new List<TestList>()
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>()
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
                                    Order = 1,
                                    Fluctuation = 1100M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "B",
                                    Order = 2,
                                    Fluctuation = 1200M
                                },
                                new SubVariantList()
                                {
                                    Id = 60,
                                    Name = "C",
                                    Order = 3,
                                    Fluctuation = 1300M
                                }
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V3",
                    Id = 3,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
                                    Order = 1,
                                    Fluctuation = 500M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "C",
                                    Order = 3,
                                    Fluctuation = 600M
                                },
                            }
                        }
                    }
                },
                new List()
                {
                    Variant = "V4",
                    Id = 4,
                    TestList = new List<TestList>
                    {
                        new TestList()
                        {
                            SubVariantList = new List<SubVariantList>
                            {
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "A",
                                    Order = 1,
                                    Fluctuation = 250M
                                },
                                new SubVariantList()
                                {
                                    Id = 40,
                                    Name = "B",
                                    Order = 2,
                                    Fluctuation = 450M
                                },
                                new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "C",
                                    Order = 3,
                                    Fluctuation = 650M
                                },
                               new SubVariantList()
                                {
                                    Id = 50,
                                    Name = "D",
                                    Order = 4,
                                    Fluctuation = 750M
                                },
                            }
                        }
                    }
                }
            };
        }
    }
​
}

@model List<HelloWorldMvcApp.TableVM>
@{
	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">
			h4 {
				margin: 25px 0 0 10px;
			}
			table {
				margin: 5px 10px;
			}
			tr {
				border-bottom: solid grey 1px;
			}
			th {
				width: 50px;
				text-align: center;
			}
			th:nth-child(odd) {
				width: 15px;
			}
			th:first-child {
				width: 100px;
				text-align: left;
			}
			td {
				text-align: center;
			}

			td:first-child {
				text-align: left;
			}
		</style>
	</head>
	
	<body>
		@foreach(var table in Model)
		{
			var columnCount = table.MaxColumns;
			var index = 1;
			<h4>@table.Title</h4>
			<table>
				<thead>
					<tr>
						<th>Variant</th>
						@foreach(var header in table.Headers)
						{
							<th>@header</th>
							if (index < columnCount)
							{
								<th>-></th>
							}
							index++;
								
						}
					</tr>
				</thead>
				<tbody>
					@foreach(var row in table.Variants)
					{
						index = 1;
						<tr>
							<td>@row.Variant</td>
							@foreach(var column in row.Fluctuations)
							{
								<td>@column.Fluctuation</td>
								if (index < columnCount)
								{
									<td></td>
								}
								index++;
							}
							@for (int i = index - 1; i < @columnCount; i++)
							{
								<td></td>
								if (index < columnCount)
								{
									<td></td>
								}
							}
						</tr>
		
					}
				</tbody>

			</table>
		}
		



		<!-- JS includes -->
		<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
		<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
	
		<script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
		<script src="//ajax.aspnetcdn.com/ajax/mvc/4.0/jquery.validate.unobtrusive.min.js"></script>
		
		<script type="text/javascript">
		
		</script>
	</body>
</html>

View

 
@model List<HelloWorldMvcApp.TableVM>
@{
    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">
            h4 {
                margin: 25px 0 0 10px;
            }
            table {
                margin: 5px 10px;
            }
            tr {
                border-bottom: solid grey 1px;
            }
            th {
                width: 50px;
                text-align: center;
            }
            th:nth-child(odd) {
                width: 15px;
            }
            th:first-child {
                width: 100px;
                text-align: left;
            }
            td {
                text-align: center;
            }
​
            td:first-child {
                text-align: left;
            }
        </style>
    </head>
    
    <body>
        @foreach(var table in Model)
        {
            var columnCount = table.MaxColumns;
            var index = 1;
            <h4>@table.Title</h4>
            <table>
                <thead>
                    <tr>
                        <th>Variant</th>
                        @foreach(var header in table.Headers)
                        {
                            <th>@header</th>
                            if (index < columnCount)
                            {
                                <th>-></th>
                            }
                            index++;
                                
                        }
                    </tr>
                </thead>
                <tbody>
                    @foreach(var row in table.Variants)
                    {
                        index = 1;
                        <tr>
                            <td>@row.Variant</td>
                            @foreach(var column in row.Fluctuations)
                            {
                                <td>@column.Fluctuation</td>
                                if (index < columnCount)
                                {
                                    <td></td>
                                }
                                index++;
                            }
                            @for (int i = index - 1; i < @columnCount; i++)
                            {
                                <td></td>
                                if (index < columnCount)
                                {
                                    <td></td>
                                }
                            }
                        </tr>
        
                    }
                </tbody>
​
            </table>
        }
        
​
​
​
        <!-- JS includes -->
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
        <script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
    
        <script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
        <script src="//ajax.aspnetcdn.com/ajax/mvc/4.0/jquery.validate.unobtrusive.min.js"></script>
        
        <script type="text/javascript">
        
        </script>
    </body>
</html>
​

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

namespace HelloWorldMvcApp
{
	public class HomeController : Controller
	{
		[HttpGet]
		public ActionResult Index()
		{
			var data = Repository.FetchData();
			List<TableVM> model = new List<TableVM>();
			
            foreach(List list in data)
            {
				var headers = list.TestList[0].SubVariantList.Select(x => x.Name);
                //var sequence = String.Join("", headers);
                var sequence = list.TestList[0].SubVariantList.Select(x => x.Order);
				var key = String.Join("", sequence);
                var current = model.Where(x => x.Key == key).FirstOrDefault();
                bool isSequential = IsSequential(sequence);
				if (isSequential)
                {
                    current = model.Where(x => x.IsSequential).FirstOrDefault();
                }
				if (current == null)
                {
                    current = new TableVM()
                    {
                        Title = String.Format("Table {0}", model.Count + 1),
                        Key = key,
                        IsSequential = isSequential
                    };
                    model.Add(current);
                }
                RowVM row = new RowVM()
                {
                    Variant = list.Variant
                };
                foreach(var subVariant in list.TestList[0].SubVariantList)
                {
                    ColumnVM column = new ColumnVM()
                    {
                        Fluctuation = subVariant.Fluctuation
                    };
                    row.Fluctuations.Add(column);
                }
                current.Variants.Add(row);
				if (row.Fluctuations.Count > current.MaxColumns)
                {
                    current.MaxColumns = row.Fluctuations.Count;
					current.Headers = headers;
                }
            }
			return View(model);
		}
		private bool IsSequential(IEnumerable<int> sequence)
		{
			return sequence.First() +  sequence.Count() - 1 == sequence.Last();
		}
		
	}
}

Controller

 
using System;
using System.Web.Mvc;
using System.Collections.Generic;
using System.Linq;
​
namespace HelloWorldMvcApp
{
    public class HomeController : Controller
    {
        [HttpGet]
        public ActionResult Index()
        {
            var data = Repository.FetchData();
            List<TableVM> model = new List<TableVM>();
            
            foreach(List list in data)
            {
                var headers = list.TestList[0].SubVariantList.Select(x => x.Name);
                //var sequence = String.Join("", headers);
                var sequence = list.TestList[0].SubVariantList.Select(x => x.Order);
                var key = String.Join("", sequence);
                var current = model.Where(x => x.Key == key).FirstOrDefault();
                bool isSequential = IsSequential(sequence);
                if (isSequential)
                {
                    current = model.Where(x => x.IsSequential).FirstOrDefault();
                }
                if (current == null)
                {
                    current = new TableVM()
                    {
                        Title = String.Format("Table {0}", model.Count + 1),
                        Key = key,
                        IsSequential = isSequential
                    };
                    model.Add(current);
                }
                RowVM row = new RowVM()
                {
                    Variant = list.Variant
                };
                foreach(var subVariant in list.TestList[0].SubVariantList)
                {
                    ColumnVM column = new ColumnVM()
                    {
                        Fluctuation = subVariant.Fluctuation
                    };
                    row.Fluctuations.Add(column);
                }
                current.Variants.Add(row);
                if (row.Fluctuations.Count > current.MaxColumns)
                {
                    current.MaxColumns = row.Fluctuations.Count;
                    current.Headers = headers;
                }
            }
            return View(model);
        }
        private bool IsSequential(IEnumerable<int> sequence)
        {
            return sequence.First() +  sequence.Count() - 1 == sequence.Last();
        }
        
    }
}

View in Full Screen

Work

Last Run:	12:43:07 am
Compile:	0.276s
Execute:	0s
Memory:	0b
CPU:	0s

View IL Code