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 Departments 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.
Antud juhul annab ka teada ViewBag-ile et “Creation” on Tõene et vaade näitaks Creation vaadet.
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.
Antud juhul annab ka ViewBag-ile teada et “Deletion” on tõene, et vaade teab mida näidata.
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. See laseb ka teada ViewBag-ile et deletion on väär et vaade näitab Detaile.
Edit lubab meil muuta antud objekti. Kasutab FirstorDefaultAsync ja Lambda meetodit. Sellel on ka post-meetod mis siis salvestab kõike mis muudeti. Laseb teada ka ViewBag-ile et Creation on väär et teab millist vaadet näidata.
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using TallinnaRakenduslikKolledzKaur.Data;
using TallinnaRakenduslikKolledzKaur.Models;
namespace TallinnaRakenduslikKolledzKaur.Controllers
{
public class DepartmentsController : Controller
{
private readonly SchoolContext _context;
public DepartmentsController(SchoolContext context)
{
_context = context;
}
public async Task<IActionResult> Index()
{
var schoolContext = _context.Departments.Include(d => d.Administrator);
return View(await schoolContext.ToListAsync());
}
[HttpGet]
public IActionResult Create()
{
ViewData["creation"] = true;
ViewData["InstructorID"] = new SelectList(_context.Instructors,"Id", "FullName");
/*ViewData["StudentId"] = new SelectList(_context.Students, "Id", "LastName", "FirstName");*/
return View();
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Name,Budget,StartDate,RowVersion,InstructorId,Staplers,WastedHours")]Department department)
{
if (ModelState.IsValid)
{
_context.Add(department);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
}
ViewData["InstructorID"] = new SelectList(_context.Instructors, "Id", "FullName", department.InstructorID);
/*ViewData["CourseStatus"] = new SelectList(_context.Instructors,"Id",department.CurrentStatus.ToString)*/
return View(department);
}
[HttpGet]
public async Task<IActionResult> Edit(int? id)
{
ViewData["creation"] = false;
if (id == null)
{
return NotFound();
}
var department = await _context.Departments.FirstOrDefaultAsync(d => d.DepartmentID == id);
if (department == null)
{
return NotFound();
}
/*_context.Departments.Update(department); */
return View("Create", department);
}
[HttpPost, ActionName("Edit")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> EditConfirmed([Bind("DepartmentID,Name,Budget,StartDate,RowVersion,InstructorId,Staplers,WastedHours")] Department department)
{
_context.Departments.Update(department);
await _context.SaveChangesAsync();
return RedirectToAction("Index");
}
[HttpGet]
public async Task<IActionResult> Delete(int? id)
{
ViewData["deletion"] = true;
if (id == null)
{
return NotFound();
}
var department = await _context.Departments.FirstOrDefaultAsync(d => d.DepartmentID == id);
if (department == null)
{
return NotFound();
}
return View(department);
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Delete(Department department)
{
if (await _context.Departments.AnyAsync(m => m.DepartmentID == department.DepartmentID))
{
_context.Departments.Remove(department);
await _context.SaveChangesAsync();
}
return RedirectToAction("Index");
}
[HttpGet]
public async Task<IActionResult> Details(int? id)
{
ViewData["deletion"] = false;
if (id == null)
{
return NotFound();
}
var department = await _context.Departments.FirstOrDefaultAsync(d => d.DepartmentID == id);
if (department == null)
{
return NotFound();
}
return View("Delete", department);
}
}
}
Mudel
using System.ComponentModel.DataAnnotations;
namespace TallinnaRakenduslikKolledzKaur.Models
{
public class Department
{
[Key]
public int DepartmentID { get; set; }
public string Name { get; set; }
public decimal Budget { get; set; }
public DateTime StartDate { get; set; }
public int? InstructorID { get; set; }
public Instructor? Administrator { get; set; }
public ICollection<Course>? Courses { get; set; }
public byte? RowVersion { get; set; }
public int? Staplers { get; set; }
public string? Accomplishments { get; set; }
public int? WastedHours { get; set; }
}
}
View
Create + Edit
@model TallinnaRakenduslikKolledzKaur.Models.Department
@if (ViewBag.creation == true)
{
ViewData["Title"] = "Osakond";
<h1>Asuta uus osakond</h1>
<h4></h4>
<hr/>
<div class="row">
<div class="col-md-8">
<form asp-action="Create">
<input type="hidden" asp-for="RowVersion" value="@Html.Raw("0")"/>
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="Name" class="control-label"></label>
<input asp-for="Name" class="control-label"/>
<span asp-validation-for="Name" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Budget" class="control-label"></label>
<input asp-for="Budget" class="control-label" />
<span asp-validation-for="Budget" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="StartDate" class="control-label"></label>
<input asp-for="StartDate" class="control-label" />
<span asp-validation-for="StartDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Staplers" class="control-label"></label>
<input asp-for="Staplers" class="control-label" />
<span asp-validation-for="Staplers" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Accomplishments" class="control-label"></label>
<input asp-for="Accomplishments" class="control-label" />
<span asp-validation-for="Accomplishments" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="WastedHours" class="control-label"></label>
<input asp-for="WastedHours" class="control-label" />
<span asp-validation-for="WastedHours" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="InstructorID" class="control-label"></label>
<select asp-for="InstructorID" class="control-label" asp-items="ViewBag.InstructorID">
<option value="">-- Palun Vali Õpetaja --</option>
</select>
<span asp-validation-for="InstructorID" class="text-danger"></span>
</div>
<div>
<input type="submit" value="Sisesta" class="btn btn-primary" />
</div>
<div>
<a asp-action="Index">Tühista Lisamine</a>
</div>
</form>
</div>
</div>
}
else if(ViewBag.creation == false)
{
ViewData["Title"] = "Muuda osakond";
<h1>Muuda Department</h1>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Edit">
<input type="hidden" asp-for="@Model.DepartmentID" />
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="Name" class="control-label"></label>
<input asp-for="Name" class="form-control" />
<span asp-validation-for="Name" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="StartDate" class="control-label"></label>
<input asp-for="StartDate" class="form-control" />
<span asp-validation-for="StartDate" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Budget" class="control-label"></label>
<input asp-for="Budget" class="form-control" />
<span asp-validation-for="Budget" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="RowVersion" class="control-label"></label>
<input asp-for="RowVersion" class="form-control" />
<span asp-validation-for="RowVersion" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Staplers" class="control-label"></label>
<input asp-for="Staplers" class="form-control" />
<span asp-validation-for="Staplers" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Accomplishments" class="control-label"></label>
<input asp-for="Accomplishments" class="form-control" />
<span asp-validation-for="Accomplishments" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="WastedHours" class="control-label"></label>
<input asp-for="WastedHours" class="form-control" />
<span asp-validation-for="WastedHours" class="text-danger"></span>
</div>
<!--<div class="form-group">
<label asp-for="InstructorID" class="control-label"></label>
<input asp-for="InstructorID" class="form-control" />
<span asp-validation-for="InstructorID" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Administrator" class="control-label"></label>
<input asp-for="Administrator" class="form-control" />
<span asp-validation-for="Administrator" class="text-danger"></span>
</div> -->
<div class="form-group">
<input type="submit" asp-route-id="@Model.DepartmentID"value="Edit" class="btn btn-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index">Mine tagasi loendisse</a>
</div>
}
Delete + Details
@model TallinnaRakenduslikKolledzKaur.Models.Department
@if (ViewBag.deletion == true)
{
ViewData["Title"] = "Kustuta osakond";
<h2>@Html.DisplayFor(modelItem => Model.Name)</h2>
<p>
<h3>Kustuta Osakond:</h3>
</p>
<div>
<hr />
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Name)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.Name)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.DepartmentID)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.DepartmentID)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Staplers)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.Staplers)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.RowVersion)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.RowVersion)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Budget)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.Budget)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.StartDate)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.StartDate)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Accomplishments)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.Accomplishments)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.WastedHours)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.WastedHours)</dt>
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.InstructorID)</dt>
<dt class="col-sm-2">@Html.DisplayFor(Model => Model.InstructorID)</dt>
<form asp-action="Delete">
<input type="hidden" asp-for="DepartmentID" />
<input type="hidden" asp-for="RowVersion"/>
<input type="submit" value="Kustuta Osakond" class="btn btn-danger" /> | <a asp-action="Index">Tühista</a>
</form>
</div>
}
else if (ViewBag.deletion == false)
{
ViewData["Title"] = "Viewing õpetaja";
<div>
<h4>Osakond @Model.Name</h4>
<hr />
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Name)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Name)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.StartDate)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.StartDate)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Budget)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Budget)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.RowVersion)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.RowVersion)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Staplers)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Staplers)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Accomplishments)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Accomplishments)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.WastedHours)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.WastedHours)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.InstructorID)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.InstructorID)</dd>
</dl>
<dl class="row">
<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Administrator)</dt>
<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Administrator)</dd>
</dl>
</div>
<form asp-action="Tagasi">
<input type="hidden" asp-for="DepartmentID" />
<a asp-action="Index">Tagasi</a>
</form>
}
Index
@model IEnumerable<TallinnaRakenduslikKolledzKaur.Models.Department>
@{
ViewData["Title"] = "Osakonnad";
}
<h1>Osakonnad</h1>
<p>
<a asp-action="Create">Loo uus osakond</a>
</p>
<table class="table">
<thead>
<tr>
<!--<th>@Html.DisplayNameFor(Model => Model.DepartmentID)</th> -->
<th>@Html.DisplayNameFor(Model => Model.Name)</th>
<th>@Html.DisplayNameFor(Model => Model.Budget)</th>
<th>@Html.DisplayNameFor(Model => Model.StartDate)</th>
<th>@Html.DisplayNameFor(Model => Model.Administrator)</th>
<th>@Html.DisplayNameFor(Model => Model.RowVersion)</th>
<th>@Html.DisplayNameFor(Model => Model.Accomplishments)</th>
<th>@Html.DisplayNameFor(Model => Model.WastedHours)</th> <!-- woag, -->
<th>Tööriistad</th>
</tr>
</thead>
<tbody>
@foreach(var department in Model)
{
<tr>
<!--<td>@Html.DisplayFor(modelItem => department.DepartmentID)</td> -->
<td> @Html.DisplayFor(modelItem => department.Name) </td>
<td> @Html.DisplayFor(modelItem => department.Budget) </td>
<td> @Html.DisplayFor(modelItem => department.StartDate) </td>
<td> @Html.DisplayFor(modelItem => department.Administrator) </td>
<td> @Html.DisplayFor(modelItem => department.RowVersion) </td>
<td> @Html.DisplayFor(modelItem => department.Accomplishments) </td>
<td> @Html.DisplayFor(modelItem => department.WastedHours) </td>
<td>
@* /* Muuda */ *@
<a asp-action="Edit" asp-route-id="@department.DepartmentID" class="btn btn-primary">Edit</a>
@* /* Vaata */ *@
<a asp-action="Details" asp-route-id="@department.DepartmentID" class="btn btn-primary">Detail</a>
@* /* Vaata Admin */ *@
@* /* Kustuta */ *@
<a asp-action="Delete" asp-route-id="@department.DepartmentID" class="btn btn-danger">Eemalda</a>
</td>
</tr>
}
</tbody>
</table>