pathDongle LearnMVC | C# Online Compiler

pathDongle LearnMVC by sleeyuen

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

namespace LearnMVC.Models
{
	public class tblProducts
	{
		//SQL table is named tblProducts
	
		[Key]
		public int ID { get; set; }
		public DateTime Date { get; set; }
		public string Field1 { get; set; }
		public string Field2 { get; set; }
		public string Product { get; set; } //<<Want separate tables split by this field
	}
	
	public class IndexViewModel
    {
        public List<tblProducts> Products { get; set; }
        public List<string> Titles { get; set; }

        public IndexViewModel()
        {
            Products = new List<tblProducts>();
            Titles = new List<string>();
        }
    }
}

Model

​x
 
using System;
using System.ComponentModel.DataAnnotations;
using System.Collections.Generic;
​
namespace LearnMVC.Models
{
    public class tblProducts
    {
        //SQL table is named tblProducts
    
        [Key]
        public int ID { get; set; }
        public DateTime Date { get; set; }
        public string Field1 { get; set; }
        public string Field2 { get; set; }
        public string Product { get; set; } //<<Want separate tables split by this field
    }
    
    public class IndexViewModel
    {
        public List<tblProducts> Products { get; set; }
        public List<string> Titles { get; set; }
​
        public IndexViewModel()
        {
            Products = new List<tblProducts>();
            Titles = new List<string>();
        }
    }
}

@model LearnMVC.Models.IndexViewModel

@{
    ViewData["Title"] = "Index";
}

<h2>Index</h2>

<p>
    <a asp-action="Create">Create New</a>
</p>

@{ foreach (var title in Model.Titles)
{
	var products = Model.Products.Where(x => x.Product == title);

	foreach (var product in products)
	{<text>

<table class="table">
    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(model => product.Date)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Field1)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Field2)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Product)
            </th>
            <th></th>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in product)
        {
            <tr>
                <td>
                    @Html.DisplayFor(modelItem => item.Date)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Field1)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Field2)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Product)
                </td>
                <td>
                    <a asp-action="Edit" asp-route-id="@item.ID">Edit</a> |
                    <a asp-action="Details" asp-route-id="@item.ID">Details</a> |
                    <a asp-action="Delete" asp-route-id="@item.ID">Delete</a>
                </td>
            </tr>
        }
    </tbody>
</table>

	</text>}
}

View

 
@model LearnMVC.Models.IndexViewModel
​
@{
    ViewData["Title"] = "Index";
}
​
<h2>Index</h2>
​
<p>
    <a asp-action="Create">Create New</a>
</p>
​
@{ foreach (var title in Model.Titles)
{
    var products = Model.Products.Where(x => x.Product == title);
​
    foreach (var product in products)
    {<text>
​
<table class="table">
    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(model => product.Date)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Field1)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Field2)
            </th>
            <th>
                @Html.DisplayNameFor(model => product.Product)
            </th>
            <th></th>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in product)
        {
            <tr>
                <td>
                    @Html.DisplayFor(modelItem => item.Date)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Field1)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Field2)
                </td>
                <td>
                    @Html.DisplayFor(modelItem => item.Product)
                </td>
                <td>
                    <a asp-action="Edit" asp-route-id="@item.ID">Edit</a> |
                    <a asp-action="Details" asp-route-id="@item.ID">Details</a> |
                    <a asp-action="Delete" asp-route-id="@item.ID">Delete</a>
                </td>
            </tr>
        }
    </tbody>
</table>
​
    </text>}
}

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

namespace LearnMVC
{
	public class tblProductsController : Controller
	{
		public async Task<IActionResult> Index()
		{
			var allProducts = await _context.tblProducts.ToListAsync();
			var titles = allProducts.Select(x => x.Product).Distinct();
	
			var model = new Models.IndexViewModel()
			{
				Products = allProducts,
				Titles = titles
			};
	
			return View(model);
		}
	}
}

Controller

 
using System;
using System.Web.Mvc;
using System.Collections.Generic;
using System.Threading.Tasks;
​
namespace LearnMVC
{
    public class tblProductsController : Controller
    {
        public async Task<IActionResult> Index()
        {
            var allProducts = await _context.tblProducts.ToListAsync();
            var titles = allProducts.Select(x => x.Product).Distinct();
    
            var model = new Models.IndexViewModel()
            {
                Products = allProducts,
                Titles = titles
            };
    
            return View(model);
        }
    }
}

View in Full Screen

View IL Code