Changeset e9bb9d1 for PostgreSqlDotnetCore/Controllers/VetCenterController.cs

Timestamp:

08/28/24 21:41:13 (4 weeks ago)

Author:

ElenaMoskova <elena.moskova99@…>

Branches:

main

Children:

a850333

Parents:

118e414

Message:

Use of views

1. Use of views in VetCenters.
2. Ability to provide a response to a given response.

File:

• PostgreSqlDotnetCore/Controllers/VetCenterController.cs (modified) (7 diffs)

PostgreSqlDotnetCore/Controllers/VetCenterController.cs

@@ -5 +5 @@
 using Microsoft.AspNetCore.Mvc.Rendering;
 using System.Threading.Tasks;
+using Npgsql;
+using PostgreSqlDotnetCore.Data;
 
 namespace PostgreSqlDotnetCore.Controllers
@@ -10 +12 @@
     public class VetCenterController : BaseController
     {
-        public VetCenterController(UserManager<IdentityUser> userManager) : base(userManager)
-        {
+        /*  
+         public VetCenterController(UserManager<IdentityUser> userManager) : base(userManager)
+           {
+           }
+        */
+        private readonly ApplicationDbContext db;
+
+        public VetCenterController(UserManager<IdentityUser> userManager, ApplicationDbContext context) : base(userManager)
+        {
+            db = context ?? throw new ArgumentNullException(nameof(context)); 
         }
 
@@ -45 +55 @@
              return View(vetCenters);
          }*/
+        /* public async Task<ActionResult> Index()
+         {
+             var vetCenters = await db.VetCentersObj.ToListAsync();
+             ViewBag.isAuthenticated = User.Identity.IsAuthenticated;
+             // no access for standard user
+             ViewBag.OnlyAdminManager = await checkAuthorizationSpecificRoleAsync(RoleConstants.Admin) ?? await checkAuthorizationSpecificRoleAsync(RoleConstants.Manager);
+
+             // Проверете дали корисникот е администратор или менаџер
+             UsersClass customerClass = await checkAuthorizationSpecificRoleAsync(RoleConstants.Admin);
+             // ?? await checkAuthorizationSpecificRoleAsync(RoleConstants.Manager);
+
+             ViewBag.hasAccess = customerClass != null;
+
+             return View(vetCenters);
+         }
+     */
         public async Task<ActionResult> Index()
         {
-            var vetCenters = await db.VetCentersObj.ToListAsync();
+            var vetCenters = await db.VetCentersWithCity.ToListAsync(); 
             ViewBag.isAuthenticated = User.Identity.IsAuthenticated;
             // no access for standard user
             ViewBag.OnlyAdminManager = await checkAuthorizationSpecificRoleAsync(RoleConstants.Admin) ?? await checkAuthorizationSpecificRoleAsync(RoleConstants.Manager);
 
-            // Проверете дали корисникот е администратор или менаџер
+            
             UsersClass customerClass = await checkAuthorizationSpecificRoleAsync(RoleConstants.Admin);
-               // ?? await checkAuthorizationSpecificRoleAsync(RoleConstants.Manager);
 
             ViewBag.hasAccess = customerClass != null;
@@ -62 +87 @@
 
 
-        public async Task<ActionResult> Details(int? id)
+
+        /*public async Task<ActionResult> Details(int? id)
         {
             if (id == null)
@@ -82 +108 @@
         }
 
+
+       */
+        public async Task<IActionResult> Details(int? id)
+        {
+            if (id == null)
+            {
+                return RedirectToAction("NotExist", "Error");
+            }
+
+            // Логирајте го ID-то за дебугирање
+            Console.WriteLine($"ID: {id}");
+
+            // Обидете се да најдете запис во view
+            VetCenterWithCity vetClass = await db.VetCentersWithCity
+                                                 .Where(v => v.id == id) 
+                                                 .FirstOrDefaultAsync();
+            if (vetClass == null)
+            {
+                return RedirectToAction("NotExist", "Error");
+            }
+
+            
+            UsersClass customerClass = await getCrrentUser();
+            ViewBag.isAuthenticated = customerClass;
+
+           
+            return View(vetClass);
+        }
+
+
+
+
+
+
+
+
+
+
+
+
         [HttpPost]
         [ValidateAntiForgeryToken]
@@ -99 +165 @@
             return View(vetClass);
         }
+
+   
+
+         /*public async Task<ActionResult> Create([Bind(include: "id,name,adress,description,workinghours,phonenumber,latitude,longitude,citiesid")] VetCenter vetClass)
+         {
+             // Логирање на параметрите
+             Console.WriteLine($"Parameters: {vetClass.name}, {vetClass.adress}, {vetClass.description}, {vetClass.workinghours}, {vetClass.phonenumber}, {vetClass.latitude}, {vetClass.longitude}, {vetClass.citiesid}");
+
+             if (ModelState.IsValid)
+             {
+                 // Повик на складираната процедура
+                 var parameters = new[]
+                 {
+             new NpgsqlParameter("@name", vetClass.name),
+             new NpgsqlParameter("@adress", vetClass.adress),
+             new NpgsqlParameter("@description", vetClass.description),
+             new NpgsqlParameter("@workinghours", vetClass.workinghours),
+             new NpgsqlParameter("@phonenumber", vetClass.phonenumber),
+             new NpgsqlParameter("@latitude", (decimal)vetClass.latitude),
+             new NpgsqlParameter("@longitude", (decimal)vetClass.longitude),
+             new NpgsqlParameter("@citiesid", vetClass.citiesid)
+         };
+
+                 await db.Database.ExecuteSqlRawAsync("CALL project.AddVetCenter(@name, @adress, @description, @workinghours, @phonenumber, @latitude, @longitude, @citiesid)", parameters);
+
+                 return RedirectToAction("Index");
+             }
+
+             // Ако моделот не е валиден, повторно пополнете ги градовите за паѓачкиот мени
+             var citiess = await db.CitiesObj.ToListAsync();
+             ViewBag.Citiess = new SelectList(citiess, "id", "name", vetClass.citiesid);
+
+             return View(vetClass);
+         }
+
+         
+
+
+        */
+
+
+
 
         public async Task<ActionResult> Edit(int? id)
@@ -149 +257 @@
         }
 
-        public async Task<ActionResult> Delete(int? id) { 
-             UsersClass customerClass = await checkAuthorizationAsync();
-        
-        ViewBag.isAuthenticated = await getCrrentUser();
-        
+        public async Task<ActionResult> Delete(int? id)
+        {
+            UsersClass customerClass = await checkAuthorizationAsync();
+
+            ViewBag.isAuthenticated = await getCrrentUser();
+
             if (id == null)
             {