using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1.Controllers
{
    public class TestController : Controller
    {
        public IActionResult Index()
        {
            // 使用ViewData
            ViewData["Message"] = "Hello World!";
            return View();
        }
    }
}

@*
    For more information on enabling MVC for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860
*@
@ViewData["Message"]

public JsonResult TestJsonResult()
{
    return Json(new { data = 5 });
}

public FileResult TestFileResult()
{
    string excelPath = @"C:\example.xlsx";
    return File(excelPath, "application/vnd.ms-excel", "example.xlsx");
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1.Models
{
    public class TestViewModel
    {
        Customer Customer { get; set; }
        public List<Product> Products { get; set; }

    }
}

using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class TestController : Controller
    {
        public IActionResult Index()
        {
            // 使用ViewData
            ViewData["Message"] = "Hello World!";

            TestViewModel testViewModel = new TestViewModel();
            testViewModel.Customer = new Customer() ;
            testViewModel.Customer.Name = "YU HSIANG";
            testViewModel.Customer.Number = "A001";
            testViewModel.Customer.Tel = "00-00000000";

            testViewModel.Products = new List<Product>();
            testViewModel.Products.Add(new Product() { Name = "PS4", Number = "P001", Price = 11000 });
            testViewModel.Products.Add(new Product() { Name = "PS5", Number = "P002", Price = 15000 });

            return View(testViewModel);
        }
        public JsonResult TestJsonResult()
        {
            return Json(new { data = 5 });
        }


        public FileResult TestFileResult()
        {
            string excelPath = @"C:\example.xlsx";
            return File(excelPath, "application/vnd.ms-excel", "example.xlsx");
        }
    }
}

@model WebApplication1.Models.TestViewModel
@*
    For more information on enabling MVC for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860
*@
@ViewData["Message"]<br>
@Model.Customer.Name<br>
@Model.Customer.Number<br>
@Model.Customer.Tel<br>

<table>
@foreach (Product item in Model.Products)
{
    <tr>
        <td>@Html.TextBoxFor(m => item.Number)</td>
        <td>@Html.TextBoxFor(m => item.Name)</td>
        <td>@Html.TextBoxFor(m => item.Price)</td>
    </tr>
}
</table>

public IActionResult Index()
{
    // 使用ViewData
    ViewData["Message"] = "Hello World!";

    //使用ViewBag
    ViewBag.msg = "使用ViewBag的資料";

    TestViewModel testViewModel = new TestViewModel();
    testViewModel.Customer = new Customer() ;
    testViewModel.Customer.Name = "YU HSIANG";
    testViewModel.Customer.Number = "A001";
    testViewModel.Customer.Tel = "00-00000000";

    testViewModel.Products = new List<Product>();
    testViewModel.Products.Add(new Product() { Name = "PS4", Number = "P001", Price = 11000 });
    testViewModel.Products.Add(new Product() { Name = "PS5", Number = "P002", Price = 15000 });


    return View(testViewModel);
}

@model WebApplication1.Models.TestViewModel
@*
    For more information on enabling MVC for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860
*@
@ViewData["Message"]<br>
@ViewBag.msg<br>
@Model.Customer.Name
<br>
@Model.Customer.Number
<br>
@Model.Customer.Tel
<br>

<table>
    @foreach (Product item in Model.Products)
    {
        <tr>
            <td>@Html.TextBoxFor(m => item.Number)</td>
            <td>@Html.TextBoxFor(m => item.Name)</td>
            <td>@Html.TextBoxFor(m => item.Price)</td>
        </tr>
    }
</table>

Scaffold-DbContext "Server=.\SQLExpress;Database=Orders;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

public void ConfigureServices(IServiceCollection services)
  {
      
      services.AddControllersWithViews();
      // 資料庫配置
      var connection = @"Server=.\SQLExpress;Database=Orders;Trusted_Connection=True;ConnectRetryCount=0";
      services.AddDbContext<OrdersContext>(options => options.UseSqlServer(connection));
  }

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;

        // 添加Context
        private readonly OrdersContext _context;


        public HomeController(ILogger<HomeController> logger, OrdersContext context)
        {
            _logger = logger;
            // 初始化Context
            _context = context;
        }

        [HttpGet]
        public IActionResult Create()
        {
            return View();
        }

        [HttpPost]
        public IActionResult Create(UsersModel usersmodel)
        {
            if (ModelState.IsValid)
            {
                //如果連結資料庫在這進行儲存

                //導回首頁
                return RedirectToAction(nameof(Index));
            }
            return View(usersmodel);
        }


        public IActionResult Index()
        {
            // 透過Context取得資料
            var model = _context.Customers.Select(b => new Customer
            {
                Name = b.Name,
                Number = b.Number,
                Tel = b.Tel
            }).ToList();

            // 取第一列資料出來
            Customer m = model[0];

            return View(m);
        }

        public IActionResult Privacy()
        {
            return View();
        }

        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Error()
        {
            return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
        }
    }
}

@model WebApplication1.Models.Customer;
@{
    ViewData["Title"] = "Home Page";
}
<ul>
    <li>@Model.Number</li>
    <li>@Model.Name</li>
    <li>@Model.Tel</li>
</ul>
<div class="text-center">
    <h1 class="display-4">Welcome</h1>
    <p>Learn about <a href="https://docs.microsoft.com/aspnet/core">building Web apps with ASP.NET Core</a>.</p>
</div>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models
{
    public class UsersModel
    {
        [Display(Name = "編號")]
        public int ID { get; set; }

        [Required(ErrorMessage = "姓名不可為空")]
        [Display(Name = "姓名")]
        public string Name { get; set; }

        [Display(Name = "年齡")]
        public int Age { get; set; }
    }
}

[HttpGet]
public IActionResult Create()
{
    return View();
}

[HttpPost]
public IActionResult Create(UsersModel usersmodel)
{
    if (ModelState.IsValid)
    {
        //如果連結資料庫在這進行儲存

        //導回首頁
        return RedirectToAction(nameof(Index));
    }
    return View(usersmodel);
}

@model WebApplication1.Models.UsersModel
@{
    ViewData["Title"] = "Create Page";
}
<form asp-action="Create">
    <div>
        <label asp-for="Name"></label>
        <input asp-for="Name" />
        <span asp-validation-for="Name"></span>
    </div>
    <div>
        <label asp-for="Age"></label>
        <input asp-for="Age" />
        <span asp-validation-for="Age"></span>
    </div>
    <div>
        <input type="submit" value="Save" />
    </div>
</form>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models
{
    public class UsersModel
    {
        [Display(Name = "編號")]
        public int ID { get; set; }

        [Required(ErrorMessage = "姓名不可為空")]
        [Display(Name = "姓名")]
        public string Name { get; set; }

        [CheckValidAge]
        [Display(Name = "年齡")]
        public int Age { get; set; }
    }

    public class CheckValidAge : ValidationAttribute
    {

        public CheckValidAge()
        {
            ErrorMessage = "年齡不可超過50歲";
        }

        public override bool IsValid(object value)
        {
            if (value == null)
            {
                return true;
            }
            int age = (int)value;
            if (age > 50)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1.Models
{
    public class UsersModel
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
    }
}

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;

        public HomeController(ILogger<HomeController> logger)
        {
            _logger = logger;
        }

        public IActionResult Index()
        {
            // 建立usersModel物件
            UsersModel usersModel = new UsersModel()
            {
                ID = 1,
                Name = "YU HSIANG",
                Age = 25
            };
            // 傳入View
            return View(usersModel);
        }

        public IActionResult Privacy()
        {
            return View();
        }

        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Error()
        {
            return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
        }
    }
}

@model WebApplication1.Models.UsersModel
@{
    ViewData["Title"] = "Home Page";
}
<ul>
    <li>@Model.ID</li>
    <li>@Model.Name</li>
    <li>@Model.Age</li>
</ul>
<div class="text-center">
    <h1 class="display-4">Welcome</h1>
    <p>Learn about <a href="https://docs.microsoft.com/aspnet/core">building Web apps with ASP.NET Core</a>.</p>
</div>

using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1
{
    public class Program
    {
        public static void Main(string[] args)
        {
            CreateHostBuilder(args).Build().Run();
        }

        public static IHostBuilder CreateHostBuilder(string[] args) =>
            Host.CreateDefaultBuilder(args)
                .ConfigureWebHostDefaults(webBuilder =>
                {
                    webBuilder.UseStartup<Startup>();
                });
    }
}

using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            // 添加服務
            services.AddControllersWithViews();
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                app.UseExceptionHandler("/Home/Error");
                // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
                app.UseHsts();
            }
            app.UseHttpsRedirection();
            app.UseStaticFiles();

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(
                    name: "default",
                    pattern: "{controller=Home}/{action=Index}/{id?}");
            });
        }
    }
}

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
}

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;

        public HomeController(ILogger<HomeController> logger)
        {
            _logger = logger;
        }

        public IActionResult Index()
        {
            return View();
        }

        public IActionResult Privacy()
        {
            return View();
        }

        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Error()
        {
            return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
        }
    }
}

using System;

namespace WebApplication1.Models
{
    public class ErrorViewModel
    {
        public string RequestId { get; set; }

        public bool ShowRequestId => !string.IsNullOrEmpty(RequestId);
    }
}

@{
    ViewData["Title"] = "Home Page";
}

<div class="text-center">
    <h1 class="display-4">Welcome</h1>
    <p>Learn about <a href="https://docs.microsoft.com/aspnet/core">building Web apps with ASP.NET Core</a>.</p>
</div>

@{
    ViewData["Title"] = "Privacy Policy";
}
<h1>@ViewData["Title"]</h1>

<p>Use this page to detail your site's privacy policy.</p>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>@ViewData["Title"] - WebApplication1</title>
    <link rel="stylesheet" href="~/lib/bootstrap/dist/css/bootstrap.min.css" />
    <link rel="stylesheet" href="~/css/site.css" />
</head>
<body>
    <header>
        <nav class="navbar navbar-expand-sm navbar-toggleable-sm navbar-light bg-white border-bottom box-shadow mb-3">
            <div class="container">
                <a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index">WebApplication1</a>
                <button class="navbar-toggler" type="button" data-toggle="collapse" data-target=".navbar-collapse" aria-controls="navbarSupportedContent"
                        aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="navbar-collapse collapse d-sm-inline-flex flex-sm-row-reverse">
                    <ul class="navbar-nav flex-grow-1">
                        <li class="nav-item">
                            <a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Index">Home</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Privacy">Privacy</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
    </header>
    <div class="container">
        <main role="main" class="pb-3">
            @RenderBody()
        </main>
    </div>

    <footer class="border-top footer text-muted">
        <div class="container">
            &copy; 2021 - WebApplication1 - <a asp-area="" asp-controller="Home" asp-action="Privacy">Privacy</a>
        </div>
    </footer>
    <script src="~/lib/jquery/dist/jquery.min.js"></script>
    <script src="~/lib/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
    <script src="~/js/site.js" asp-append-version="true"></script>
    @RenderSection("Scripts", required: false)
</body>
</html>

<script src="~/lib/jquery-validation/dist/jquery.validate.min.js"></script>
<script src="~/lib/jquery-validation-unobtrusive/jquery.validate.unobtrusive.min.js"></script>

@model ErrorViewModel
@{
    ViewData["Title"] = "Error";
}

<h1 class="text-danger">Error.</h1>
<h2 class="text-danger">An error occurred while processing your request.</h2>

@if (Model.ShowRequestId)
{
    <p>
        <strong>Request ID:</strong> <code>@Model.RequestId</code>
    </p>
}

<h3>Development Mode</h3>
<p>
    Swapping to <strong>Development</strong> environment will display more detailed information about the error that occurred.
</p>
<p>
    <strong>The Development environment shouldn't be enabled for deployed applications.</strong>
    It can result in displaying sensitive information from exceptions to end users.
    For local debugging, enable the <strong>Development</strong> environment by setting the <strong>ASPNETCORE_ENVIRONMENT</strong> environment variable to <strong>Development</strong>
    and restarting the app.
</p>

@using WebApplication1
@using WebApplication1.Models
@addTagHelper *, Microsoft.AspNetCore.Mvc.TagHelpers

@{
    Layout = "_Layout";
}

select
users.name,
comments.id,
comments.comment_parent_id,
comments.title,
comments.content
from comments left join users on comments.user_id = users.id

[
    {id:1,comment_parent_id:null,title:'留言1',content:'內容',name:'路人A'},
    {id:2,comment_parent_id:null,title:'留言2',content:'內容',name:'路人B'},
    {id:3,comment_parent_id:2,title:'留言3',content:'內容',name:'路人C'},
    {id:4,comment_parent_id:3,title:'留言4',content:'內容',name:'路人D'},
    {id:5,comment_parent_id:3,title:'留言5',content:'內容',name:'路人E'}
]

<!DOCTYPE html>
<html>
<head>
<title>Page Title</title>
</head>
<body>
</body>
</html>
<script>
const commentList = [
    {id:1,comment_parent_id:null,title:'留言1',content:'內容',name:'路人A'},
    {id:2,comment_parent_id:null,title:'留言2',content:'內容',name:'路人B'},
    {id:3,comment_parent_id:2,title:'留言3',content:'內容',name:'路人C'},
    {id:4,comment_parent_id:3,title:'留言4',content:'內容',name:'路人D'},
    {id:5,comment_parent_id:3,title:'留言5',content:'內容',name:'路人E'}
]

// 建立樹狀階層
function buildTree(commentList){
    // 根節點
    const rootNode = commentList.filter(it=> it.comment_parent_id === null)
    // 增加子節點
    return addNode(rootNode,commentList)
}

// 添加子節點
function addNode(children,commentList){
    // 找不到子節點返回
    if(children.length === 0){
    	return []
    }
    // 添加子節點
    const arr = [] 
    // 遍歷當前children節點
    for(let i=0;i<children.length;i++){
    	// 查詢底下的子節點
        const childrenNode = commentList.filter(it=> 
        it.comment_parent_id === children[i].id)
        // 把底下子節點添加進陣列
        arr.push({
            id:children[i].id,
            name:children[i].name,
            title:children[i].title,
            content:children[i].content,
            children:addNode(childrenNode,commentList)
        })
    }
    // 返回子節點陣列
    return arr
}
// 印出結果
console.log(JSON.stringify(buildTree(commentList)));

</script>

[
    {
        "id": 1,
        "name": "路人A",
        "title": "留言1",
        "content": "內容",
        "children": []
    },
    {
        "id": 2,
        "name": "路人B",
        "title": "留言2",
        "content": "內容",
        "children": [
            {
                "id": 3,
                "name": "路人C",
                "title": "留言3",
                "content": "內容",
                "children": [
                    {
                        "id": 4,
                        "name": "路人D",
                        "title": "留言4",
                        "content": "內容",
                        "children": []
                    },
                    {
                        "id": 5,
                        "name": "路人E",
                        "title": "留言5",
                        "content": "內容",
                        "children": []
                    }
                ]
            }
        ]
    }
]

<!DOCTYPE html>
<html>
<head>
<title>Page Title</title>
</head>
<body>

<div id="comment">
</div>

</body>
</html>
<script>
const commentList = [
    { id: 1, comment_parent_id: null, title: '留言1', content: '內容', name: '路人A' },
    { id: 2, comment_parent_id: null, title: '留言2', content: '內容', name: '路人B' },
    { id: 3, comment_parent_id: 2, title: '留言3', content: '內容', name: '路人C' },
    { id: 4, comment_parent_id: 3, title: '留言4', content: '內容', name: '路人D' },
    { id: 5, comment_parent_id: 3, title: '留言5', content: '內容', name: '路人E' }
]

// 建立樹狀階層
function buildTree(commentList) {
    // 根節點
    const rootNode = commentList.filter(it => it.comment_parent_id === null)
    // 增加子節點
    return addNode(rootNode, commentList)
}

// 添加子節點
function addNode(children, commentList) {
    // 找不到子節點返回
    if (children.length === 0) {
        return []
    }
    // 添加子節點
    const arr = []
    // 遍歷當前children節點
    for (let i = 0; i < children.length; i++) {
        // 查詢底下的子節點
        const childrenNode = commentList.filter(it =>
            it.comment_parent_id === children[i].id)
        // 把底下子節點添加進陣列
        arr.push({
            id: children[i].id,
            name: children[i].name,
            title: children[i].title,
            content: children[i].content,
            children: addNode(childrenNode, commentList)
        })
    }
    // 返回子節點陣列
    return arr
}

// 在網頁上呈現出結果
function generateCommentTemplate(children) {
    let template = '<ul>'
    for (let i = 0; i < children.length; i++) {
        template += '<li>'
        template += children[i].title + '<br>'
        template += children[i].content + '<br>'
        template += children[i].name + '<br>'

        // 如果有子節點則遞迴再次呼叫
        if (children[i].children.length !== 0) {
            template += generateCommentTemplate(children[i].children)
        }
        template += '</li>'
    }
    template += '</ul>'
    return template
}
// 建立樹狀結構
const tree = buildTree(commentList)
// 產生HTML模板
document.getElementById("comment").innerHTML = generateCommentTemplate(tree)
</script>