@page
@model IndexModel
@{
   ViewData["Title"] = "Home page";
}

<style>
   th {
      background-color: antiquewhite;
   }
   th, td{
      padding: 10px;
   }
</style>
@using (Html.BeginForm())
{
<div class="text-center">
   <h1 class="display-4">Project 4: Advanced Project</h1>
   <h3>Aurel Villyani</h3>
   @* <button class="btn-primary" type="submit" value="get_instructor_list" asp-page-handler="AccessInstructorList">Get Instructor List</button>*@
   @if (ViewData["showInstructorList"] != null)
   {
      <label for="instructorList">Select an instructor: </label>
      @Html.DropDownList("instructorList", (IEnumerable<SelectListItem>)ViewData["showInstructorList"])
   }

   <button asp-page-handler="GetInstructorInfo">Get Instructor Info</button>
   @if (ViewData["showInstructorInformation"] != null)
   {
      var showData = ViewData["showInstructorInformation"] as System.Data.DataTable;
      var students = ViewData["students"] as System.Data.DataTable;
      
      // Get student in course
      //
      
         @foreach (System.Data.DataRow row in showData.Rows)
         {
                <table>
                    <tr>
                        <th>Course No</th>
                        <th>Course Name</th>
                        <th>Students</th>
                        <th>Section Number</th>
                        <th>Starting Date</th>
                        <th>Location</th>
                        <th>Capacity</th>
                    </tr>
                    <tr>
                        <td>@row["course_id"]</td>
                        <td>@row["course_name"]</td>
                        <td>
                            <table>
                                <tr>
                                    <th>Student ID</th>
                                    <th>Student Name</th>
                                </tr>
                                @foreach (System.Data.DataRow student in students.Rows)
                                {
                                    if (student["course_id"].Equals(row["course_id"]) && student["section_number"].Equals(row["section_number"]))
                                    {
                                        <tr>
                                            <td>@student["student_id"]</td>
                                            <td>@student["student_name"]</td>
                                        </tr>
                                    }
                                }
                            </table>
                        </td>
                        <td>@row["section_number"]</td>
                        <td>@row["starting_date"]</td>
                        <td>@row["location"]</td>
                        <td>@row["capacity"]</td>

                    </tr>
                </table>
                
                
         }
   }
</div>
}