Changeset 2639fab for PostgreSqlDotnetCore/Controllers

Timestamp:

08/14/24 16:27:55 (3 months ago)

Author:

ElenaMoskova <elena.moskova99@…>

Branches:

main

Children:

ae6c071

Parents:

784b3ad

Message:

Update with triggers

Location:

PostgreSqlDotnetCore/Controllers

Files:

• BlogController.cs (modified) (2 diffs)
• ProductsController.cs (modified) (6 diffs)

PostgreSqlDotnetCore/Controllers/BlogController.cs

@@ -60 +60 @@
         public ActionResult Create()
         {
-            var model = new BlogPostConsultation
-            {
-                //date_askes = DateTime.Now // Поставете го датумот на моменталниот датум
-                // date_askes= DateTime.UtcNow.Date
-                date_askes = DateOnly.FromDateTime(DateTime.UtcNow.Date)
-            };
+            var model = new BlogPostConsultation();
             return View(model);
         }
@@ -83 +78 @@
                     var user = await _userManager.GetUserAsync(User);
                     var customerClass = db.CustomerObj.SingleOrDefault(x => x.email == user.Email);
-                    // blogClass.date_askes = new DateTime();
-                    // blogClass.date_askes = DateTime.UtcNow;
-                    blogClass.date_askes = DateOnly.FromDateTime(DateTime.UtcNow);
                     blogClass.users_id = customerClass.id;
                     db.BlogPostControllerObj.Add(blogClass);

PostgreSqlDotnetCore/Controllers/ProductsController.cs

@@ -2 +2 @@
 using Microsoft.AspNetCore.Mvc;
 using Microsoft.EntityFrameworkCore;
+using Npgsql;
+using System.Linq;
 using PostgreSqlDotnetCore.Models;
-using System.Net;
+//using System.Net;
+using System.Threading.Tasks;
+using PostgreSqlDotnetCore.Data;
 
 namespace PostgreSqlDotnetCore.Controllers
@@ -9 +13 @@
     public class ProductsController : BaseController
     {
+
         public ProductsController(UserManager<IdentityUser> userManager) : base(userManager)
         {
@@ -68 +73 @@
             var model = new ProductsClass
             {
-                dateadded = DateTime.Now // Поставете го датумот на моменталниот датум
+              //  dateadded = DateTime.Now // Поставете го датумот на моменталниот датум
             };
             return View(model);
         }
+
+
+
 
         // POST: Customer/Create
@@ -78 +86 @@
         [HttpPost]
         [ValidateAntiForgeryToken]
-        public ActionResult Create([Bind(include: "id,name,description,price, is_active, dateadded, category")] ProductsClass prodClass)
+        public ActionResult Create([Bind(include: "id,name,description,price, is_active, dateadded, category, int available_quantity")] ProductsClass prodClass)
         {
             if (ModelState.IsValid)
             {
-                prodClass.dateadded = new DateTime();
+              //  prodClass.dateadded = new DateTime();
                 prodClass.isactive = true;
                 db.ProductObj.Add(prodClass);
@@ -91 +99 @@
             return View(prodClass);
         }
+
+
+
+
+
+
+
+
+
+
 
         // GET: Customer/Edit/5
@@ -117 +135 @@
         [HttpPost]
         [ValidateAntiForgeryToken]
-        public ActionResult Edit([Bind(include: "id,name,description,price, is_active, dateadded, category")] ProductsClass prodClass)
+        public ActionResult Edit([Bind(include: "id,name,description,price, is_active, dateadded, category, int available_quantity")] ProductsClass prodClass)
         {
             if (ModelState.IsValid)