Controller
SchoolContext _context annab Controllerile ja Vaatele teada mis andmebaas välja näeb ning kõik informatsioon selle sees.
Index laseb meil vaadata kõik Students informatsiooni üldiselt kasutades ToListAsync() meetodit mis paneb kõik raamatud tabelisse.
Create esimesena annab meile Create vaate ning siis kui on informatsioon antud, see kontrollib et mudel on õige ning kui on, lisab andmebaasile ja viib sind tagasi Indexisse.
See kasutab ka SaveChangesAsync et salvestada informatsiooni
Delete kustutab antud valik ära peale kui kontrollib et asi on olemas. see kasutab esimesena FirstorDefaultAsync, mis Tagastab asünkroonselt jada esimese elemendi. Ning kasutab Lambda meetodit et lühidalt näidata anonüümset meetodit.
Ning siis salvestab andmebaasi peale kui kustutab valitud objekt ära.
Details lubab meil vaadata täpsemad informatsiooni antud objekti kohta. See kasutab samuti FirstorDefaultAsync ja Lambda meetodit.
Edit lubab meil muuta antud objekti. Kasutab FirstorDefaultAsync ja Lambda meetodit. Sellel on ka post-meetod mis siis salvestab kõike mis muudeti.
Clone lubab meil teha koopia antud objektist, See kasutab FirstorDefaultAsync ja Lambda meetodit et anda informatsiooni vaatele ning salvestab peale kui koopia on tehtud.
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.IdentityModel.Tokens;
using TallinnaRakenduslikKolledzKaur.Data;
using TallinnaRakenduslikKolledzKaur.Models;
namespace TallinnaRakenduslikKolledzKaur.Controllers
{
public class StudentsController : Controller
{
private readonly SchoolContext _context;
public StudentsController(SchoolContext context)
{
_context = context;
}
public async Task<IActionResult> Index()
{
return View(await _context.Students.ToListAsync());
}
[HttpGet]
public IActionResult Create()
{
return View();
}
/// <summary>
/// Lisa uus student
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Id, LastName,FirstName,EnrollmentDate,Commendments")] Student student)
{
if (ModelState.IsValid)
{
_context.Students.Add(student);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
// return RedirectToAction(nameof(Index))
}
return View(student);
}
/// <summary>
/// Get delete view for student
/// </summary>
/// <param name="Id">id of student</param>
/// <returns></returns>
[HttpGet]
public async Task<IActionResult> Delete(int? Id)
{
if (Id == null)
{
return NotFound();
}
var student = await _context.Students.FirstOrDefaultAsync(m => m.Id == Id);
if (student == null)
{
return NotFound();
}
return View(student);
}
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int? Id)
{
var student = await _context.Students.FindAsync(Id);
_context.Students.Remove(student);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
}
[HttpGet]
public async Task<IActionResult> Details(int? Id)
{
if (Id == null)
{
return NotFound();
}
var student = await _context.Students.FirstOrDefaultAsync(m => m.Id == Id);
if (student == null)
{
return NotFound();
}
return View(student);
}
[HttpGet]
public async Task<IActionResult>Edit(int? Id)
{
if (Id == null)
{
return NotFound();
}
var student = await _context.Students.FirstOrDefaultAsync(m => m.Id == Id);
if (student == null)
{
return NotFound();
}
_context.Students.Update(student);
return View(student);
}
[HttpPost, ActionName("Edit")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> EditConfirmed([Bind("Id,LastName,FirstName,EnrollmentDate,Commendments")] Student student)
{
_context.Students.Update(student);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
}
[HttpGet]
public async Task<IActionResult> Clone(int? Id)
{
if (Id == null)
{
return NotFound();
}
var student = await _context.Students.FirstOrDefaultAsync(m => m.Id == Id);
if (student == null)
{
return NotFound();
}
return View(student);
}
[HttpPost, ActionName("Clone")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> CloneConfirmed(int? Id)
{
var student = await _context.Students.FirstOrDefaultAsync(m => m.Id == Id);
//ModelState.Remove("Id");
if (ModelState.IsValid)
{
_context.Students.Add(student);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
// return RedirectToAction(nameof(Index))
}
return View(student);
}
}
}
Mudel
using System.ComponentModel.DataAnnotations;
namespace TallinnaRakenduslikKolledzKaur.Models
{
public class Student
{
[Key]
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public ICollection<Enrollment>? Enrollments { get; set; }
public DateTime EnrollmentDate { get; set; }
public int? GPA { get; set; }
public ICollection<Commendation>? Commendations { get; set; } /* Kiitused */
public ICollection<Mark>? Marks { get; set; } /* Märkused */
}
}
View
Clone
@model TallinnaRakenduslikKolledzKaur.Models.Student
@{
ViewData["Title"] = "Copy õpilane";
}
<h1>Copy õpilane</h1>
<hr />
<div>
<h4>Õpilane @Model.FirstName @Model.LastName</h4>
<hr />
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.LastName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.LastName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.FirstName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.FirstName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.EnrollmentDate)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.EnrollmentDate)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Commendations)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Commendations)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Enrollments)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Enrollments)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Marks)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Marks)</dd>
</dl>
</div>
<form asp-action="Clone">
<input type="hidden" asp-for="Id" />
<input type="submit" asp-route-id="Id"value="Clone" class="btn btn-primary" /> | <a asp-action="Index">Tühista</a>
</form>
Create
@model TallinnaRakenduslikKolledzKaur.Models.Student
@{
ViewData["Title"] = "Loo uus õpilane";
}
<h1>Loo uus õpilane</h1>
<hr/>
<div class="row">
<div class="col-md-4">
<form asp-action="Create">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="LastName" class="control-label"></label>
<input asp-for="LastName" class="form-control" />
<span asp-validation-for="LastName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="FirstName" class="control-label"></label>
<input asp-for="FirstName" class="form-control" />
<span asp-validation-for="FirstName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="EnrollmentDate" class="control-label"></label>
<input asp-for="EnrollmentDate" class="form-control" />
<span asp-validation-for="EnrollmentDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Commendations" class="control-label"></label>
<input asp-for="Commendations" class="form-control" />
<span asp-validation-for="Commendations" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" value="Sisesta" class="btn btn-primary"/>
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index">Mine tagasi loendisse</a>
</div>
Delete
@model TallinnaRakenduslikKolledzKaur.Models.Student
@{
ViewData["Title"] = "Kustuta õpilane";
}
<h1>Kustuta õpilane</h1>
<h3>
Kas oled kindel et tahad õpilast @Model.FirstName @Model.LastName eemaldada?
</h3>
<div>
<h4>Õpilane @Model.FirstName @Model.LastName</h4>
<hr />
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.LastName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.LastName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.FirstName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.FirstName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.EnrollmentDate)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.EnrollmentDate)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Commendations)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Commendations)</dd>
</dl>
@if (Model.Enrollments != null)
{
foreach (var Enrollments in Model.Enrollments)
{
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Enrollments)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Enrollments)</dd>
</dl>
}
}
@if (Model.Marks != null)
{
foreach (var Marks in Model.Marks)
{
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Marks)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Marks)</dd>
</dl>
}
}
</div>
<form asp-action="Delete">
<input type="hidden" asp-for="Id"/>
<input type="submit" value="Kustuta õpilane" class="btn btn-danger"/> | <a asp-action="Index">Tühista</a>
</form>
Details
@model TallinnaRakenduslikKolledzKaur.Models.Student
@{
ViewData["Title"] = "Viewing õpilane";
}
<div>
<h4>Õpilane @Model.FirstName @Model.LastName</h4>
<hr />
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.LastName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.LastName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.FirstName)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.FirstName)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.EnrollmentDate)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.EnrollmentDate)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Commendations)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Commendations)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Enrollments)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Enrollments)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Marks)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Marks)</dd>
</dl>
</div>
<form asp-action="Tagasi">
<input type="hidden" asp-for="Id" />
<a asp-action="Index">Tagasi</a>
</form>
Edit
@model TallinnaRakenduslikKolledzKaur.Models.Student
@{
ViewData["Title"] = "Muuda õpilane";
}
<h1>Muuda õpilane</h1>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Edit">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="LastName" class="control-label"></label>
<input asp-for="LastName" class="form-control" />
<span asp-validation-for="LastName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="FirstName" class="control-label"></label>
<input asp-for="FirstName" class="form-control" />
<span asp-validation-for="FirstName" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="EnrollmentDate" class="control-label"></label>
<input asp-for="EnrollmentDate" class="form-control" />
<span asp-validation-for="EnrollmentDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Commendations" class="control-label"></label>
<input asp-for="Commendations" class="form-control" />
<span asp-validation-for="Commendations" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Marks" class="control-label"></label>
<input asp-for="Marks" class="form-control" />
<span asp-validation-for="Marks" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Enrollments" class="control-label"></label>
<input asp-for="Enrollments" class="form-control" />
<span asp-validation-for="Enrollments" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="GPA" class="control-label"></label>
<input asp-for="GPA" class="form-control" />
<span asp-validation-for="GPA" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" value="Edit" class="btn btn-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index">Mine tagasi loendisse</a>
</div>
Index
@model IEnumerable<TallinnaRakenduslikKolledzKaur.Models.Student>
@{
ViewData["Title"] = "Õpilased";
}
<h1>Õpilaste Loend:</h1>
<p>
<a asp-action="Create">Sisesta Õpilane</a>
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(Model => Model.LastName)
</th>
<th>
@Html.DisplayNameFor(Model => Model.FirstName)
</th>
<th>
@Html.DisplayNameFor(Model => Model.EnrollmentDate)
</th>
<th>
@Html.DisplayNameFor(Model => Model.GPA)
</th>
<th>Tööriistad</th>
</tr>
</thead>
<tbody>
@foreach (var student in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => student.LastName)
</td>
<td>
@Html.DisplayFor(modelItem => student.FirstName)
</td>
<td>
@Html.DisplayFor(modelItem => student.EnrollmentDate)
</td>
<td>
@Html.DisplayFor(modelItem => student.GPA)
</td>
<td>
<a asp-action="Edit" asp-route-id="@student.Id">Muuda</a>
</td>
<td>
<a asp-action="Details" asp-route-id="@student.Id">Vaata</a>
</td>
<td>
<a asp-action="Delete" asp-route-id="@student.Id">Kustuta</a>
</td>
<!--<td>
<a asp-action="Clone" asp-route-id="@student.Id">Clone</a>
</td> -->
</tr>
}
</tbody>
</table>