MVC-databaskonstruktion

commit 54dcb24387fdaba1b7b4cafd603d4fbac771bcac
parent 70e8d5d3237a53db8f3ee9e54430225b5fe68f4c
Author: William Lindholm <william_lindholm@outlook.com>
Date:   Sun, 15 Oct 2023 02:38:26 +0200

Added search for operations

Diffstat:
M
MVC-databaskonstruktion/Controllers/OperationsController.cs
 | 
7
+++++++
M
MVC-databaskonstruktion/Models/OperationsModel.cs
 | 
12
++++++++++++
M
MVC-databaskonstruktion/Views/Operations/index.cshtml
 | 
4
++++

3 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/MVC-databaskonstruktion/Controllers/OperationsController.cs b/MVC-databaskonstruktion/Controllers/OperationsController.cs
@@ -24,6 +24,13 @@ namespace MVC_databaskonstruktion.Controllers
             return View();
         }
 
+        public IActionResult Details(string OperationName, DateTime StartDate, string IncidentName, int IncidentNumber)
+        {
+            ViewBag.AgentsInOperation = _operationsModel.GetAgentsInOperation(OperationName, StartDate, IncidentName, IncidentNumber);
+
+            return View("Details");
+        }
+
         public IActionResult Delete(string table, string IncidentName, string IncidentNumber, string OperationName, DateTime StartDate)
         {
             try
diff --git a/MVC-databaskonstruktion/Models/OperationsModel.cs b/MVC-databaskonstruktion/Models/OperationsModel.cs
@@ -23,6 +23,7 @@ namespace MVC_databaskonstruktion.Models
         {
             return _tableBuilder
                 .SetDataTable(_databaseRepository.GetTable($"SELECT * FROM Operation WHERE OperationName LIKE '%{searchQuery}%';"))
+                .SetRedirect("Details")
                 .Build();
         }
 
@@ -33,6 +34,17 @@ namespace MVC_databaskonstruktion.Models
                 .Build();
         }
 
+        public TableObject GetAgentsInOperation(string OperationName, DateTime StartDate, string IncidentName, int IncidentNumber)
+        {
+            return _tableBuilder
+                .SetDataTable(_databaseRepository.GetTable($"SELECT * FROM OperatesIn WHERE OperationName = '{OperationName}' AND StartDate = '{StartDate}' AND IncidentName = '{IncidentName}' AND IncidentNumber = '{IncidentNumber}';"))
+                .SetControllerName("Agents")
+                .SetDeleteTable("OperatesIn")
+                .SetRedirect("FieldAgentDetails")
+                .SetPrimaryKeys(new List<string> { "CodeName", "OperationName", "StartDate", "IncidentName", "IncidentNumber" })
+                .Build();
+        }
+
         public void DeleteOperation(string table, string IncidentName, string IncidentNumber, string OperationName, DateTime StartDate)
         {
                List<KeyValuePair<string, string>> conditions = new List<KeyValuePair<string, string>>
diff --git a/MVC-databaskonstruktion/Views/Operations/index.cshtml b/MVC-databaskonstruktion/Views/Operations/index.cshtml
@@ -3,6 +3,10 @@
     ViewData["Title"] = "index";
 }
 
+<h1>Operations</h1>
+<hr />
+
+
 <form action="@Url.Action("index")" method="get" class="mt-1">
     <label>Search for Operation:</label>
     <br />