commit 5ca452b81580c2215b221c7271458e359e60c667
parent 9663ce359d73a78643e25c192ab1b84244d52e96
Author: William Lindholm <william_lindholm@outlook.com>
Date: Sun, 15 Oct 2023 19:02:00 +0200
Implemented procedure call.
Diffstat:
4 files changed, 56 insertions(+), 1 deletion(-)
diff --git a/MVC-databaskonstruktion/Controllers/OperationsController.cs b/MVC-databaskonstruktion/Controllers/OperationsController.cs
@@ -33,6 +33,13 @@ namespace MVC_databaskonstruktion.Controllers
return View("Details");
}
+ public IActionResult FilterOperations(DateTime StarDate, DateTime EndDate)
+ {
+ ViewBag.FilteredOperations = _operationsModel.FilterOperations(StarDate, EndDate);
+
+ return View("FilterOperations");
+ }
+
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
@@ -35,6 +35,13 @@ namespace MVC_databaskonstruktion.Models
.Build();
}
+ public TableObject FilterOperations(DateTime StartDate, DateTime EndDate)
+ {
+ return _tableBuilder
+ .SetDataTable(_databaseRepository.GetTable($"CALL GetOperationsInRange('{StartDate}', '{EndDate}')"))
+ .Build();
+ }
+
public TableObject GetAgentsInOperation(string OperationName, DateTime StartDate, string IncidentName, int IncidentNumber)
{
return _tableBuilder
diff --git a/MVC-databaskonstruktion/Views/Operations/FilterOperations.cshtml b/MVC-databaskonstruktion/Views/Operations/FilterOperations.cshtml
@@ -0,0 +1,24 @@
+@{
+ ViewData["Title"] = "Filtered operations";
+}
+
+<h1>Operations</h1>
+<hr />
+
+<h5>Filter by date:</h5>
+<form action="@Url.Action("FilterOperations")" method="get" class="mt-1 d-inline-flex">
+ <div class="me-3">
+ <label for="startDateInput">Start Date:</label>
+ <br />
+ <input id="startDateInput" type="date" name="StartDate" class="form-control d-inline-block" style="vertical-align: middle; width: auto;" />
+ </div>
+ <div>
+ <label for="endDateInput">End Date:</label>
+ <br />
+ <input id="endDateInput" type="date" name="EndDate" class="form-control d-inline-block" style="vertical-align: middle; width: auto;" />
+ <button type="submit" class="btn btn-primary ml-2">Filter</button>
+ </div>
+</form>
+<hr />
+
+<partial name="_TablePartial" model="ViewBag.FilteredOperations" />
diff --git a/MVC-databaskonstruktion/Views/Operations/index.cshtml b/MVC-databaskonstruktion/Views/Operations/index.cshtml
@@ -15,10 +15,26 @@
</form>
<hr />
+<h5>Filter by date:</h5>
+<form action="@Url.Action("FilterOperations")" method="get" class="mt-1 d-inline-flex">
+ <div class="me-3">
+ <label for="startDateInput">Start Date:</label>
+ <br />
+ <input id="startDateInput" type="date" name="StartDate" class="form-control d-inline-block" style="vertical-align: middle; width: auto;" />
+ </div>
+ <div>
+ <label for="endDateInput">End Date:</label>
+ <br />
+ <input id="endDateInput" type="date" name="EndDate" class="form-control d-inline-block" style="vertical-align: middle; width: auto;" />
+ <button type="submit" class="btn btn-primary ml-2">Filter</button>
+ </div>
+</form>
+<hr />
+
<h3>Operations</h3>
<partial name="_TablePartial" model="ViewBag.Table" />
<hr />
<label>Create Operation:</label>
<br />
-<partial name="_ModalPartial" model="ViewBag.Modal" />
+<partial name="_ModalPartial" model="ViewBag.Modal" />
+\ No newline at end of file
