{"id":43,"date":"2025-10-08T09:55:16","date_gmt":"2025-10-08T07:55:16","guid":{"rendered":"https:\/\/kaurpakaste24.thkit.ee\/wp\/?page_id=43"},"modified":"2025-10-20T15:31:02","modified_gmt":"2025-10-20T13:31:02","slug":"raamatud-view-controller-ja-mudel","status":"publish","type":"page","link":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/","title":{"rendered":"Books View, Controller ja Model"},"content":{"rendered":"\n

Controller<\/h2>\n\n\n\n

The SchoolContext _context tells the Controller and View what the database looks like and all the information inside it.\n\nIndex lets us view all the information about Books in general using the ToListAsync() method which puts all the books into a table.\n\nCreate first gives us the Create view and then when the information is given, it checks that the model is correct and if it is, adds it to the database and takes you back to the Index.\n\nIt also uses SaveChangesAsync to save the information\n\nDelete deletes the given selection after checking that it exists. It first uses FirstorDefaultAsync which returns the first element of the sequence asynchronously. And uses the Lambda method to briefly show the anonymous method\nAnd then saves it to the database when it deletes the selected object.<\/p>\n\n\n

\nusing Microsoft.AspNetCore.Mvc;\nusing Microsoft.AspNetCore.Mvc.Rendering;\nusing Microsoft.EntityFrameworkCore;\nusing TallinnaRakenduslikKolledzKaur.Data;\nusing TallinnaRakenduslikKolledzKaur.Models;\n\nnamespace TallinnaRakenduslikKolledzKaur.Controllers\n{\n    public class BooksController : Controller\n    {\n        private readonly SchoolContext _context;\n\n        public BooksController(SchoolContext context)\n        {\n            _context = context;\n        }\n\n        public async Task<IActionResult> Index()\n        {\n            return View(await _context.Books.ToListAsync());\n        }\n        [HttpGet]\n        public IActionResult Create()\n        {\n            return View();\n        }\n        [HttpPost]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> Create(Book book)\n        {\n            if (ModelState.IsValid)\n            {\n                _context.Books.Add(book);\n                await _context.SaveChangesAsync();\n            }\n\n            return RedirectToAction("Index");\n        }\n\n        [HttpGet]\n        public async Task<IActionResult> Delete(int? id)\n        {\n            ViewData["deletion"] = true;\n            if (id == null)\n            {\n                return NotFound();\n            }\n            var books = await _context.Books.FirstOrDefaultAsync(b => b.BookId == id);\n            if (books == null)\n            {\n                return NotFound();\n            }\n            return View(books);\n        }\n\n        [HttpPost]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> Delete(Book book)\n        {\n            if (await _context.Books.AnyAsync(b => b.BookId == book.BookId))\n            {\n                _context.Books.Remove(book);\n                await _context.SaveChangesAsync();\n            }\n            return RedirectToAction("Index");\n        }\n    }\n}\n<\/pre><\/div>\n\n\n
Mudel<\/h2>\n\n\n\n
<\/p>\n\n\n
\nusing System.ComponentModel.DataAnnotations;\n\nnamespace TallinnaRakenduslikKolledzKaur.Models\n{\n    public class Book\n    {\n        [Key]\n        public int BookId { get; set; }\n        public string Title { get; set; }\n        public int? PageCount { get; set; }\n        public int TotalStock { get; set; }\n        public int? AmountBorrowed { get; set; }\n        public int? CurrentStock\n        {\n            get { return TotalStock-AmountBorrowed; }\n        }\n\n\n    }\n}\n<\/pre><\/div>\n\n\n
View<\/h2>\n\n\n\n
Create View et teha uus raamat<\/p>\n\n\n
\n@model TallinnaRakenduslikKolledzKaur.Models.Book\n@{ViewData["Title"] = "Uus Kursus";}\n<h1>Tee uus kursus<\/h1>\n<h4>Sisesta info:<\/h4>\n<hr \/>\n<div class="row">\n\t<div class="col-md-4">\n\t\t<form asp-action="Create">\n\t\t\t<div asp-validation-summary="ModelOnly" class="text-danger"><\/div>\n\t\t\t<!--<div>\n\t\t\t\t<label asp-for="CourseId" class="control-label"><\/label>\n\t\t\t\t<input asp-for="CourseId" class="form-control" \/>\n\t\t\t\t<span asp-validation-for="CourseId" class="text-danger"><\/span>\n\t\t\t<\/div> -->\n\t\t\t<div>\n\t\t\t\t<label asp-for="Title" class="control-label"><\/label>\n\t\t\t\t<input asp-for="Title" class="form-control" \/>\n\t\t\t\t<span asp-validation-for="Title" class="text-danger"><\/span>\n\t\t\t<\/div>\n\t\t\t<div>\n\t\t\t\t<label asp-for="PageCount" class="control-label"><\/label>\n\t\t\t\t<input asp-for="PageCount" class="form-control" \/>\n\t\t\t\t<span asp-validation-for="PageCount" class="text-danger"><\/span>\n\t\t\t<\/div>\n\t\t\t<div>\n\t\t\t\t<label asp-for="TotalStock" class="control-label"><\/label>\n\t\t\t\t<input asp-for="TotalStock" class="form-control" \/>\n\t\t\t\t<span asp-validation-for="TotalStock" class="text-danger"><\/span>\n\t\t\t<\/div>\n\t\t\t<div>\n\t\t\t\t<label asp-for="AmountBorrowed" class="control-label"><\/label>\n\t\t\t\t<input asp-for="AmountBorrowed" class="form-control" \/>\n\t\t\t\t<span asp-validation-for="AmountBorrowed" class="text-danger"><\/span>\n\t\t\t<\/div>\n\t\t\t<div class="form-group">\n\t\t\t\t<input type="submit" value="Tee uus" class="btn btn-primary" \/> | <a asp-action="Index" class="btn btn-outline-primary">T\u00fchista<\/a>\n\t\t\t<\/div>\n\t\t<\/form>\n\t<\/div>\n<\/div>\n<\/pre><\/div>\n\n\n
Delete view et kustutada raamat<\/p>\n\n\n
\n@model TallinnaRakenduslikKolledzKaur.Models.Book\n\n@{\n\tViewData["Title"] = "Kustuta \u00d5petaja";\n}\n\n&lt;h1>Kustuta \u00d5petaja&lt;\/h1>\n&lt;h3>\n\tKas oled kindel et tahad kustudada @Html.DisplayFor(Model => Model.Title)\n&lt;\/h3>\n&lt;div>\n\t&lt;h4>Raamat&lt;\/h4>\n\t&lt;hr \/>\n\t&lt;dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Title)&lt;\/dt>\n\t&lt;dt class="col-sm-10">@Html.DisplayFor(Model => Model.Title)&lt;\/dt>\n\t&lt;dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.PageCount)&lt;\/dt>\n\t&lt;dt class="col-sm-10">@Html.DisplayFor(Model => Model.PageCount)&lt;\/dt>\n\t&lt;dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.TotalStock)&lt;\/dt>\n\t&lt;dt class="col-sm-10">@Html.DisplayFor(Model => Model.TotalStock)&lt;\/dt>\n\t&lt;dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.AmountBorrowed)&lt;\/dt>\n\t&lt;dt class="col-sm-10">@Html.DisplayFor(Model => Model.AmountBorrowed)&lt;\/dt>\n\n\t&lt;form asp-action="Delete">\n\t\t&lt;input type="hidden" asp-for="BookId" \/>\n\t\t&lt;input type="submit" value="Kustuta \u00d5petaja" class="btn btn-danger" \/> | &lt;a asp-action="Index">T\u00fchista&lt;\/a>\n\t&lt;\/form>\n&lt;\/div>\n\n<\/pre><\/div>\n\n\n
Index view et n\u00e4ha k\u00f5ik raamatud<\/p>\n\n\n
\n@model IEnumerable<TallinnaRakenduslikKolledzKaur.Models.Book>\n\n@{\n\tViewData["Title"] = "Raamatud";\n}\n<h2>Raamatud<\/h2>\n<p>\n\t<a asp-action="Create">Tee uus raamat<\/a>\n<\/p>\n\n<table class="table">\n\t<thead>\n\t\t<tr>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.BookId)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.Title)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.PageCount)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.TotalStock)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.AmountBorrowed)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.CurrentStock)<\/th>\n\t\t\t<th>T\u00f6\u00f6riistad<\/th>\n\t\t<\/tr>\n\t<\/thead>\n\n\t<tbody>\n\t\t@foreach (var books in Model)\n\t\t{\n\t\t\t<tr>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.BookId)<\/td>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.Title)<\/td>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.PageCount)<\/td>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.TotalStock)<\/td>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.AmountBorrowed)<\/td>\n\t\t\t\t<td>@Html.DisplayFor(modelItem => books.CurrentStock)<\/td>\n\t\t\t\t<td>\n\t\t\t\t\t<a asp-action="Delete" asp-route-id="@books.BookId">Kustuta<\/a>\n\t\t\t\t\t<a asp-action="Details" asp-route-id="@books.BookId">Details<\/a>\n\t\t\t\t\t<a asp-action="Edit" asp-route-id="@books.BookId">Edit<\/a>\n\t\t\t\t<\/td>\n\t\t\t<\/tr>\n\t\t}\n\t<\/tbody>\n<\/table>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Controller The SchoolContext _context tells the Controller and View what the database looks like and all the information inside it. Index lets us view all the information about Books in general using the ToListAsync() method which puts all the books into a table. Create first gives us the Create view and then when the information is given, it checks that the model is correct and if it is, adds it to the database and takes you back to the Index. It also uses SaveChangesAsync to save the information Delete deletes the given selection after checking that it exists. It first uses FirstorDefaultAsync which returns the first element of the sequence asynchronously. And uses the Lambda method to briefly show the anonymous method And then saves it to the database when it deletes the selected object. Mudel View Create View et teha uus raamat Delete view et kustutada raamat Index view et n\u00e4ha k\u00f5ik raamatud<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-43","page","type-page","status-publish","hentry"],"yoast_head":"\nBooks View, Controller ja Model - Kaur portfoolio \/ English<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Books View, Controller ja Model - Kaur portfoolio \/ English\" \/>\n<meta property=\"og:description\" content=\"Controller The SchoolContext _context tells the Controller and View what the database looks like and all the information inside it. Index lets us view all the information about Books in general using the ToListAsync() method which puts all the books into a table. Create first gives us the Create view and then when the information is given, it checks that the model is correct and if it is, adds it to the database and takes you back to the Index. It also uses SaveChangesAsync to save the information Delete deletes the given selection after checking that it exists. It first uses FirstorDefaultAsync which returns the first element of the sequence asynchronously. And uses the Lambda method to briefly show the anonymous method And then saves it to the database when it deletes the selected object. Mudel View Create View et teha uus raamat Delete view et kustutada raamat Index view et n\u00e4ha k\u00f5ik raamatud\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/\" \/>\n<meta property=\"og:site_name\" content=\"Kaur portfoolio \/ English\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-20T13:31:02+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/raamatud-view-controller-ja-mudel\\\/\",\"url\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/raamatud-view-controller-ja-mudel\\\/\",\"name\":\"Books View, Controller ja Model - Kaur portfoolio \\\/ English\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"datePublished\":\"2025-10-08T07:55:16+00:00\",\"dateModified\":\"2025-10-20T13:31:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/raamatud-view-controller-ja-mudel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/raamatud-view-controller-ja-mudel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/raamatud-view-controller-ja-mudel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Books View, Controller ja Model\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Kaur portfoolio \\\/ English\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kaurpakaste24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Books View, Controller ja Model - Kaur portfoolio \/ English","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/","og_locale":"en_US","og_type":"article","og_title":"Books View, Controller ja Model - Kaur portfoolio \/ English","og_description":"Controller The SchoolContext _context tells the Controller and View what the database looks like and all the information inside it. Index lets us view all the information about Books in general using the ToListAsync() method which puts all the books into a table. Create first gives us the Create view and then when the information is given, it checks that the model is correct and if it is, adds it to the database and takes you back to the Index. It also uses SaveChangesAsync to save the information Delete deletes the given selection after checking that it exists. It first uses FirstorDefaultAsync which returns the first element of the sequence asynchronously. And uses the Lambda method to briefly show the anonymous method And then saves it to the database when it deletes the selected object. Mudel View Create View et teha uus raamat Delete view et kustutada raamat Index view et n\u00e4ha k\u00f5ik raamatud","og_url":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/","og_site_name":"Kaur portfoolio \/ English","article_modified_time":"2025-10-20T13:31:02+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/","url":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/","name":"Books View, Controller ja Model - Kaur portfoolio \/ English","isPartOf":{"@id":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/#website"},"datePublished":"2025-10-08T07:55:16+00:00","dateModified":"2025-10-20T13:31:02+00:00","breadcrumb":{"@id":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/raamatud-view-controller-ja-mudel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Books View, Controller ja Model"}]},{"@type":"WebSite","@id":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/","name":"Kaur portfoolio \/ English","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":3,"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/43\/revisions"}],"predecessor-version":[{"id":189,"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/43\/revisions\/189"}],"wp:attachment":[{"href":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}