Changeset e90ba32 for PostgreSqlDotnetCore/Controllers/BlogController.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/BlogController.cs (modified) (4 diffs)

PostgreSqlDotnetCore/Controllers/BlogController.cs

@@ -60 +60 @@
 
             // Список на блог постови
-            var blogPosts = await db.BlogPostControllerObj.ToListAsync();
+            var blogPosts = await db.BlogUsers.ToListAsync();
 
             // Вземи тековниот корисник
@@ -105 +105 @@
             blogClass.BlogPostAnswers = blogAnswers;
             ViewBag.OnlyAdminManager = await checkAuthorizationSpecificRoleAsync(RoleConstants.Admin) ?? await checkAuthorizationSpecificRoleAsync(RoleConstants.Manager);
+            ViewBag.CurrentUserId = customerClass?.id;
             return View(blogClass);
         }
@@ -301 +302 @@
         // POST: Customer/Delete/5
 
+        /*
+                [HttpPost, ActionName("Delete")]
+                [ValidateAntiForgeryToken]
+                public ActionResult DeleteConfirmed(int id)
+                {
+                    BlogPostConsultation blogClass = db.BlogPostControllerObj.Find(id);
+                    db.BlogPostControllerObj.Remove(blogClass);
+                    db.SaveChanges();
+                    return RedirectToAction("Index");
+                }
+                */
 
         [HttpPost, ActionName("Delete")]
@@ -306 +318 @@
         public ActionResult DeleteConfirmed(int id)
         {
+            // Наоѓање на објектот по ID
             BlogPostConsultation blogClass = db.BlogPostControllerObj.Find(id);
+
+            // Проверка дали објектот е пронајден
+            if (blogClass == null)
+            {
+                // Ако објектот не е пронајден, враќаме 404 Not Found или друга соодветна акција
+                return View(null);
+            }
+            //  prvo izbrisi gi site odgovori po sot BlogId e primaren kluc vo drugata tabela
+
+            // query
+            var query = from st in db.BlogPostAnswersObj
+                        where st.BlogPostConsultationid == blogClass.id
+                        select st;
+            //elenaaa
+            var blogAnswers = query.ToList();
+            foreach (BlogPostAnswers answerClass in blogAnswers)
+            {
+                db.BlogPostAnswersObj.Remove(answerClass);
+                db.SaveChanges();
+
+            }
+
+            // Отстранување на објектот ако е пронајден
             db.BlogPostControllerObj.Remove(blogClass);
             db.SaveChanges();
+
+            // Пренасочување на корисникот кон Index страницата
             return RedirectToAction("Index");
         }
-        
+
         // GET: Customer/Delete/5
         // GET: Customer/Delete/5
         // GET: Customer/Delete/5
-    
+