{"id":33,"date":"2025-10-07T12:49:12","date_gmt":"2025-10-07T10:49:12","guid":{"rendered":"https:\/\/kaurpakaste24.thkit.ee\/wp\/?page_id=33"},"modified":"2025-10-20T15:39:28","modified_gmt":"2025-10-20T13:39:28","slug":"tallinnarakenduslikkolledz","status":"publish","type":"page","link":"https:\/\/kaurpakaste24.thkit.ee\/wp\/eng\/tallinnarakenduslikkolledz\/","title":{"rendered":"TallinnaRakenduslikKolled\u017e Project"},"content":{"rendered":"\n

In programming class, our main project has been a TallinnaRakenduslikKoled\u017e assignment, the goal of which is to manage teachers and students in a hypothetical school.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

The project works using these Controllers, Views, and Models.<\/p>\n\n\n\n


<\/p>\n\n\n

\npublic class CoursesController : Controller\n{\n    private readonly SchoolContext _context;\n\n    public CoursesController(SchoolContext context)\n    {\n        _context = context;\n    }\n\n    public async Task<IActionResult> Index()\n    {\n        var courses = _context.Courses.Include(c => c.Department);\n        return View(await courses.ToListAsync());\n    }\n<\/pre><\/div>\n\n
\nusing System.ComponentModel.DataAnnotations;\n\nnamespace TallinnaRakenduslikKolledzKaur.Models\n{\n    public class Student\n    {\n        [Key]\n        public int Id { get; set; }\n        public string FirstName { get; set; }\n        public string LastName { get; set; }\n        public ICollection<Enrollment>? Enrollments { get; set; }\n        public DateTime EnrollmentDate { get; set; }\n\n        public int? GPA { get; set; }\n        public ICollection<Commendation>? Commendations { get; set; } \/* Kiitused *\/\n        public ICollection<Mark>? Marks { get; set; } \/* M\u00e4rkused *\/\n\n\n\n    }\n}\n<\/pre><\/div>\n\n
\n        protected override void OnModelCreating(ModelBuilder modelBuilder)\n        {\n            modelBuilder.Entity<Course>().ToTable("Course");\n            modelBuilder.Entity<Commendation>().ToTable("Commendation");\n            modelBuilder.Entity<Enrollment>().ToTable("Enrollment");\n            modelBuilder.Entity<Mark>().ToTable("Mark");\n            modelBuilder.Entity<Student>().ToTable("Student");\n            modelBuilder.Entity<Instructor>().ToTable("Instructor");\n            modelBuilder.Entity<CourseAssignment>().ToTable("CourseAssignment");\n            modelBuilder.Entity<OfficeAssignment>().ToTable("OfficeAssignment");\n            modelBuilder.Entity<Department>().ToTable("Department");\n            modelBuilder.Entity<Book>().ToTable("Books");\n            modelBuilder.Entity<Delinquent>().ToTable("Delinquents");\n\n        }\n<\/pre><\/div>\n\n
\n<form asp-action="Create">\n\t<input type="hidden" asp-for="RowVersion" value="@Html.Raw("0")"\/>\n\t<div asp-validation-summary="ModelOnly" class="text-danger"><\/div>\n\n\t<div class="form-group">\n\t\t<label asp-for="Name" class="control-label"><\/label>\n\t\t<input asp-for="Name" class="control-label"\/>\n\t\t<span asp-validation-for="Name" class="text-danger"><\/span>\n\t<\/div>\n\n\t<div class="form-group">\n\t\t<label asp-for="Budget" class="control-label"><\/label>\n\t\t<input asp-for="Budget" class="control-label" \/>\n\t\t<span asp-validation-for="Budget" class="text-danger"><\/span>\n\t<\/div>\n<\/pre><\/div>\n\n\n
Views<\/h2>\n\n\n\n
Each view controls a different part of the project.<\/p>\n\n\n\n
<\/p>\n\n\n\n
The Books view controls the Books model, which was supposed to show what books were in the College.\nThe Courses view shows what courses are in the College.\nThe Delinquents view shows the delinquents in the College.\nThe Departments view shows the jobs in the College.\nThe Instructors view shows the employees in the College.\nThe Students view shows all the teachers in the College.<\/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>\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
\nodel IEnumerable<TallinnaRakenduslikKolledzKaur.Models.Department>\n@{\n\tViewData["Title"] = "Osakonnad";\n}\n<h1>Osakonnad<\/h1>\n<p>\n\t<a asp-action="Create">Loo uus osakond<\/a>\n<\/p>\n<table class="table">\n\t<thead>\n\t\t<tr>\n\t\t\t<!--<th>@Html.DisplayNameFor(Model => Model.DepartmentID)<\/th>\t -->\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.Name)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.Budget)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.StartDate)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.Administrator)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.RowVersion)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.Accomplishments)<\/th>\n\t\t\t<th>@Html.DisplayNameFor(Model => Model.WastedHours)<\/th>   <!-- woag, -->\n\t\t\t<th>T\u00f6\u00f6riistad<\/th>\n\t\t<\/tr>\n\t<\/thead>\n\t<tbody>\n\t\t@foreach(var department in Model)\n\t\t{\n\t\t\t<tr>\n\t\t\t\t<!--<td>@Html.DisplayFor(modelItem => department.DepartmentID)<\/td>\t  -->\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.Name) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.Budget) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.StartDate) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.Administrator) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.RowVersion) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.Accomplishments) <\/td>\n\t\t\t\t<td> @Html.DisplayFor(modelItem => department.WastedHours) <\/td>\n\t\t\t\t<td>\n\t\t\t\t\t@* \/* Muuda *\/ *@\n\t\t\t\t\t<a asp-action="Edit" asp-route-id="@department.DepartmentID" class="btn btn-primary">Edit<\/a>\n\t\t\t\t\t@* \/* Vaata *\/ *@\n\t\t\t\t\t<a asp-action="Details" asp-route-id="@department.DepartmentID" class="btn btn-primary">Detail<\/a>\n\t\t\t\t\t@* \/* Vaata Admin *\/ *@\n\n\t\t\t\t\t@* \/* Kustuta *\/ *@\n\t\t\t\t\t<a asp-action="Delete" asp-route-id="@department.DepartmentID" class="btn btn-danger">Eemalda<\/a>\n\t\t\t\t<\/td>\n\t\t\t<\/tr>\n\t\t}\n\t<\/tbody>\n<\/table>\n<\/pre><\/div>\n\n
\n@model TallinnaRakenduslikKolledzKaur.Models.Student\n\n@{\n\tViewData["Title"] = "Copy \u00f5pilane";\n}\n\n<h1>Copy \u00f5pilane<\/h1>\n<hr \/>\n<div>\n\t<h4>\u00d5pilane @Model.FirstName @Model.LastName<\/h4>\n\t<hr \/>\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.LastName)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.LastName)<\/dd>\n\t<\/dl>\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.FirstName)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.FirstName)<\/dd>\n\t<\/dl>\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.EnrollmentDate)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.EnrollmentDate)<\/dd>\n\t<\/dl>\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Commendations)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Commendations)<\/dd>\n\t<\/dl>\n\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Enrollments)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Enrollments)<\/dd>\n\t<\/dl>\n\n\n\t<dl class="row">\n\t\t<dt class="col-sm-2">@Html.DisplayNameFor(Model => Model.Marks)<\/dt>\n\t\t<dd class="col-sm-10">@Html.DisplayFor(Model => Model.Marks)<\/dd>\n\t<\/dl>\n\n<\/div>\n<form asp-action="Clone">\n\t<input type="hidden" asp-for="Id" \/>\n\t<input type="submit" asp-route-id="Id"value="Clone" class="btn btn-primary" \/> | <a asp-action="Index">T\u00fchista<\/a>\n<\/form>\n<\/pre><\/div>\n\n\n
Controllers<\/h2>\n\n\n\n
Every View needs a Controller to work.<\/p>\n\n\n
\n        public async Task<IActionResult> Delete(int? Id)\n        {\n            if (Id == null)\n            {\n                return NotFound();\n            }\n            var delinquent = await _context.Delinquents.FirstOrDefaultAsync(d => d.BreakerId == Id);\n            if (delinquent == null)\n            {\n                return NotFound();\n            }\n            return View(delinquent);\n        }\n\n        [HttpPost]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> Delete(Delinquent delinquent)\n        {\n            if (await _context.Delinquents.AnyAsync(d => d.BreakerId == delinquent.BreakerId))\n            {\n                _context.Delinquents.Remove(delinquent);\n                await _context.SaveChangesAsync();\n            }\n            return RedirectToAction("Index");\n        }\n<\/pre><\/div>\n\n
\n    public class DepartmentsController : Controller\n    {\n        private readonly SchoolContext _context;\n        public DepartmentsController(SchoolContext context)\n        {\n            _context = context;\n        }\n        public async Task<IActionResult> Index()\n        {\n            var schoolContext = _context.Departments.Include(d => d.Administrator);\n            return View(await schoolContext.ToListAsync());\n        }\n\n<\/pre><\/div>\n\n
\nusing TallinnaRakenduslikKolledzKaur.Data;\nusing Microsoft.AspNetCore.Mvc;\nusing TallinnaRakenduslikKolledzKaur.Models;\nusing System.Threading.Tasks;\nusing Microsoft.EntityFrameworkCore;\nusing System.Reflection;\n\nnamespace TallinnaRakenduslikKolledzKaur.Controllers\n{\n    public class InstructorsController : Controller\n    {\n        private readonly SchoolContext _context;\n        public InstructorsController(SchoolContext context)\n        {\n            _context = context;\n        }\n        public async Task<IActionResult> Index(int? id, int? courseId)\n        {\n            var vm = new InstructorIndexData();\n            vm.Instructors = await _context.Instructors\n            .Include(i => i.OfficeAssignment)\n            .Include(i => i.CourseAssignments)\n            .ToListAsync();\n            return View(vm);\n        }\n\n        [HttpGet]\n        public IActionResult Create()\n        {\n            var instructor = new Instructor();\n            instructor.CourseAssignments = new List<CourseAssignment>();\n            return View();\n        }\n        [HttpPost]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> Create(Instructor instructor, string selectedCourses)\n        {\n            if (selectedCourses == null)\n            {\n                instructor.CourseAssignments = new List<CourseAssignment>();\n                if (selectedCourses != null)\n                {\n                    foreach (var course in selectedCourses)\n                    {\n                        var courseToAdd = new CourseAssignment\n                        {\n                            InstructorId = instructor.Id,\n                            CourseID = course\n                        };\n                        instructor.CourseAssignments.Add(courseToAdd);\n                    }\n                }\n            }\n            ModelState.Remove("selectedCourses");\n            if (ModelState.IsValid)\n            {\n                _context.Add(instructor);\n                await _context.SaveChangesAsync();\n                return RedirectToAction("Index");\n            }\n            \/\/PopulateAssignedCourseData(instructor);\n            return View(instructor);\n        }\n        private void PopulateAssignedCourseData(Instructor instructor)\n        {\n            var allCourses = _context.Courses; \/\/ leiame k\u00f5ik kursused\n            var instructorCourses = new HashSet<int>(instructor.CourseAssignments.Select(c => c.CourseID));\n            \/\/ valime kursused kus courseId on \u00f5petajal olemas\n            var vm = new List<AssignedCourseData>();\n            foreach (var course in allCourses)\n            {\n                vm.Add(new AssignedCourseData\n                {\n                    CourseID = course.CourseId,\n                    Title = course.Title,\n                    Assigned = instructorCourses.Contains(course.CourseId)\n                });\n            }\n            ViewData["Courses"] = vm;\n        }\n        [HttpGet]\n        public async Task<IActionResult> Delete(int? id, bool? saveChangesError = false)\n        {\n            if (id == null)\n            {\n                return NotFound();\n            }\n            var deletableInstructor = await _context.Instructors\n                .FirstOrDefaultAsync(s => s.Id == id);\n            if (deletableInstructor == null)\n            {\n                return NotFound();\n            }\n            return View(deletableInstructor);\n        }\n        [HttpPost, ActionName("Delete")]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> DeleteConfirmed(int id)\n        {\n            Instructor deletableInstructor = await _context.Instructors\n                .SingleAsync(i => i.Id == id);\n            _context.Instructors.Remove(deletableInstructor);\n            await _context.SaveChangesAsync();\n            return RedirectToAction("Index");\n        }\n        [HttpGet]\n        public async Task<IActionResult> Details(int? Id)\n        {\n            if (Id == null)\n            {\n                return NotFound();\n            }\n            var instructor = await _context.Instructors.FirstOrDefaultAsync(m => m.Id == Id);\n            if (instructor == null)\n            {\n                return NotFound();\n            }\n            return View(instructor);\n        }\n        [HttpGet]\n        public async Task<IActionResult> Edit(int? Id)\n        {\n            if (Id == null)\n            {\n                return NotFound();\n            }\n            var instructor = await _context.Instructors.FirstOrDefaultAsync(m => m.Id == Id);\n            if (instructor == null)\n            {\n                return NotFound();\n            }\n            _context.Instructors.Update(instructor);\n            return View(instructor);\n        }\n        [HttpPost, ActionName("Edit")]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> EditConfirmed([Bind("Id,LastName,FirstName,HireDate,CourseAssignments,OfficeAssignment,VacationDays,Comments,BirthDate,Status")] Instructor instructor)\n        {\n            _context.Instructors.Update(instructor);\n            await _context.SaveChangesAsync();\n            return RedirectToAction("Index");\n        }\n        public async Task<IActionResult> Quickedit(int? Id)\n        {\n            if (Id == null)\n            {\n                return NotFound();\n            }\n            var instructor = await _context.Instructors.FirstOrDefaultAsync(m => m.Id == Id);\n            if (instructor == null)\n            {\n                return NotFound();\n            }\n            _context.Instructors.Update(instructor);\n            return View(instructor);\n        }\n        [HttpPost, ActionName("Quickedit")]\n        [ValidateAntiForgeryToken]\n        public async Task<IActionResult> QuickeditConfirmed([Bind("Id,LastName,FirstName,HireDate,CourseAssignments,OfficeAssignment,VacationDays,Comments,BirthDate,Status")] Instructor instructor)\n        {\n            _context.Instructors.Update(instructor);\n            await _context.SaveChangesAsync();\n            return RedirectToAction("Index");\n        }\n    }\n}\n<\/pre><\/div>\n\n\n
Models<\/h2>\n\n\n\n
These are necessary for the Database.<\/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
\nusing System.ComponentModel.DataAnnotations;\n\nnamespace TallinnaRakenduslikKolledzKaur.Models\n{\n    public class Course\n    {\n        [Key]\n        public int CourseId { get; set; }\n        public string Title { get; set; }\n        public int Credits { get; set; }\n\n        public ICollection<Enrollment>? Enrollments { get; set; }\n        public Department? Department { get; set; }\n        public int? DepartmentID { get; set; }\n        public ICollection<CourseAssignment>? CourseAssignments { get; set; }\n    }\n}\n<\/pre><\/div>\n\n
\nusing System.ComponentModel.DataAnnotations;\n\nnamespace TallinnaRakenduslikKolledzKaur.Models\n{\n    public class Student\n    {\n        [Key]\n        public int Id { get; set; }\n        public string FirstName { get; set; }\n        public string LastName { get; set; }\n        public ICollection&lt;Enrollment>? Enrollments { get; set; }\n        public DateTime EnrollmentDate { get; set; }\n\n        public int? GPA { get; set; }\n        public ICollection&lt;Commendation>? Commendations { get; set; } \/* Kiitused *\/\n        public ICollection&lt;Mark>? Marks { get; set; } \/* M\u00e4rkused *\/\n\n\n\n    }\n}\n\n<\/pre><\/div>\n\n\n
Rohkem Detailid:<\/h2>\n\n\n\n