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>

public class Solution {
    public int SearchInsert(int[] nums, int target) {
        int index = 0;
        Boolean isFind = false;
        for(int i=0;i<nums.Length;i++){
            if(nums[i] == target){
                isFind = true;
                index = i;
                break;
            }
        }
        if(!isFind){
            for(int i=0;i<nums.Length;i++){
                if(nums[i] > target){
                    index = i;
                    break;
                }else if(i == nums.Length -1 ){
                    index = i+1;
                }
            }
        }
        return index;
    }
}