Changeset e90ba32 for PostgreSqlDotnetCore/Controllers/PetCaresController.cs

Timestamp:

08/29/24 20:27:21 (4 weeks ago)

Author:

ElenaMoskova <elena.moskova99@…>

Branches:

main

Children:

99d0ecc

Parents:

a850333

Message:

fix issues

fix bugs with nested tables
fix delete nested fk items

File:

• PostgreSqlDotnetCore/Controllers/PetCaresController.cs (modified) (4 diffs)

PostgreSqlDotnetCore/Controllers/PetCaresController.cs

@@ -57 +57 @@
         {
             // check for permission
+            bool isAuthenticated = User.Identity.IsAuthenticated;
             UsersClass customerClass = await getCrrentUser();
             // set if is authenticated
@@ -75 +76 @@
 
                 var userPetCares =
-                    await query.ToListAsync<Pet_CaresClass>();
+                    await query.Include(n => n.PetsClass).ToListAsync<Pet_CaresClass>();
 
                 return View(userPetCares);
@@ -81 +82 @@
             else
             {
-                return View(db.PetCaresObj.ToList());
+                return View(db.PetCaresObj.Include(n => n.PetsClass).ToList());
             }
 
@@ -280 +281 @@
 
         // POST: Customer/Delete/5
+        /*  [HttpPost, ActionName("Delete")]
+          [ValidateAntiForgeryToken]
+          public ActionResult DeleteConfirmed(int id)
+          {
+              Pet_CaresClass peClass = db.PetCaresObj.Find(id);
+              db.PetCaresObj.Remove(peClass);
+              db.SaveChanges();
+              return RedirectToAction("Index");
+          }
+        */
+
         [HttpPost, ActionName("Delete")]
         [ValidateAntiForgeryToken]
-        public ActionResult DeleteConfirmed(int id)
-        {
-            Pet_CaresClass peClass = db.PetCaresObj.Find(id);
+        public async Task<ActionResult> DeleteConfirmed(int id)
+        {
+            Pet_CaresClass peClass = await db.PetCaresObj.FindAsync(id);
+            if (peClass == null)
+            {
+                return RedirectToAction("NotExist", "Error");
+            }
             db.PetCaresObj.Remove(peClass);
-            db.SaveChanges();
+            await db.SaveChangesAsync();
             return RedirectToAction("Index");
         }