Index: PostgreSqlDotnetCore/Controllers/BlogController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/BlogController.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Controllers/BlogController.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -60,10 +60,5 @@
         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,7 +78,4 @@
                     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);
Index: PostgreSqlDotnetCore/Controllers/ProductsController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/ProductsController.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Controllers/ProductsController.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -2,6 +2,10 @@
 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,4 +13,5 @@
     public class ProductsController : BaseController
     {
+
         public ProductsController(UserManager<IdentityUser> userManager) : base(userManager)
         {
@@ -68,8 +73,11 @@
             var model = new ProductsClass
             {
-                dateadded = DateTime.Now // Поставете го датумот на моменталниот датум
+              //  dateadded = DateTime.Now // Поставете го датумот на моменталниот датум
             };
             return View(model);
         }
+
+
+
 
         // POST: Customer/Create
@@ -78,9 +86,9 @@
         [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,4 +99,14 @@
             return View(prodClass);
         }
+
+
+
+
+
+
+
+
+
+
 
         // GET: Customer/Edit/5
@@ -117,5 +135,5 @@
         [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)
Index: PostgreSqlDotnetCore/Controllers/VetCenterController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/VetCenterController.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Controllers/VetCenterController.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
Index: PostgreSqlDotnetCore/Data/ApplicationDbContext.cs
===================================================================
--- PostgreSqlDotnetCore/Data/ApplicationDbContext.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Data/ApplicationDbContext.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -51,6 +51,13 @@
             modelBuilder.Entity<BlogPostAnswers>().Metadata.SetIsTableExcludedFromMigrations(true);
             //modelBuilder.Entity<PetCareAllData>().Metadata.SetIsTableExcludedFromMigrations(true);
+           
+
+
             base.OnModelCreating(modelBuilder);
 
+            // Configure the relationship between VetCenter and CitiesClass
+       
+
+            
             // ... model definition ...
         }
Index: PostgreSqlDotnetCore/Models/ApplicationDbContext.cs
===================================================================
--- PostgreSqlDotnetCore/Models/ApplicationDbContext.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
+++ PostgreSqlDotnetCore/Models/ApplicationDbContext.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -0,0 +1,11 @@
+// File: Models/ActiveProductsView.cs
+
+namespace PostgreSqlDotnetCore.Models
+{
+    public class ActiveProductsView
+    {
+        public string Name { get; set; }
+        public string Description { get; set; }
+        public decimal Price { get; set; }
+    }
+}
Index: PostgreSqlDotnetCore/Models/ProductsClass.cs
===================================================================
--- PostgreSqlDotnetCore/Models/ProductsClass.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Models/ProductsClass.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -19,7 +19,11 @@
         public string price { get; set; }
         public bool isactive { get; set; }
-        public DateTime dateadded { get; set; }
+        //public DateTime dateadded { get; set; }
+
+        public DateOnly dateadded { get; set; } = DateOnly.FromDateTime(DateTime.UtcNow);
         public string category { get; set; }
-        
+
+        public int  available_quantity { get; set; }
+
 
     }
Index: PostgreSqlDotnetCore/Models/VetCenter.cs
===================================================================
--- PostgreSqlDotnetCore/Models/VetCenter.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Models/VetCenter.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -24,5 +24,7 @@
         public float longitude { get; set; }
         public string phonenumber { get; set; }
+       // [ForeignKey("CitiesClass")]
         public int citiesid { get; set; }
+       // public CitiesClass CitiesClass { get; set; }
 
 
Index: PostgreSqlDotnetCore/Program.cs
===================================================================
--- PostgreSqlDotnetCore/Program.cs	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Program.cs	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -2,4 +2,5 @@
 using Microsoft.EntityFrameworkCore;
 using PostgreSqlDotnetCore.Data;
+using PostgreSqlDotnetCore.Models;
 
 var builder = WebApplication.CreateBuilder(args);
Index: PostgreSqlDotnetCore/Views/Products/Create.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Products/Create.cshtml	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Views/Products/Create.cshtml	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -48,4 +48,14 @@
         </div>
     </div>
+
+        <div class="form-group">
+            @Html.LabelFor(model => model.available_quantity, htmlAttributes: new { @class = "control-label col-md-2" })
+            <div class="col-md-10">
+                @Html.EditorFor(model => model.available_quantity, new { htmlAttributes = new { @class = "form-control" } })
+                <span class="input-group-addon">euro</span>
+                @Html.ValidationMessageFor(model => model.available_quantity, "", new { @class = "text-danger" })
+            </div>
+        </div>
+    
     @*<div class="form-group">
             @Html.LabelFor(model => model.category, htmlAttributes: new { @class = "control-label col-md-2" })
@@ -57,5 +67,5 @@
 
     <div class="form-group">
-        <label for="category">Jobs:</label>
+        <label for="category">Category:</label>
         <select class="form-control" id="category" name="category">
             <option value="">Select category</option>
Index: PostgreSqlDotnetCore/Views/Products/Delete.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Products/Delete.cshtml	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Views/Products/Delete.cshtml	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -56,4 +56,12 @@
         </dd>
 
+        <dt>
+            @Html.DisplayNameFor(model => model.available_quantity)
+        </dt>
+
+        <dd>
+            @Html.DisplayFor(model => model.available_quantity)
+        </dd>
+
 
     </dl>
Index: PostgreSqlDotnetCore/Views/Products/Details.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Products/Details.cshtml	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Views/Products/Details.cshtml	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -55,4 +55,12 @@
         </dd>
 
+        <dt>
+            @Html.DisplayNameFor(model => model.available_quantity)
+        </dt>
+
+        <dd>
+            @Html.DisplayFor(model => model.available_quantity)
+        </dd>
+
     </dl>
 </div>
Index: PostgreSqlDotnetCore/Views/Products/Edit.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Products/Edit.cshtml	(revision 784b3ad6420c8fa9640b0729b33503c54890a454)
+++ PostgreSqlDotnetCore/Views/Products/Edit.cshtml	(revision 2639fab359508f3b32dc9d13a69c79dcec869305)
@@ -54,4 +54,11 @@
         </div>
     </div>
+        <div class="form-group">
+            @Html.LabelFor(model => model.available_quantity, htmlAttributes: new { @class = "control-label col-md-2" })
+            <div class="col-md-10">
+                @Html.EditorFor(model => model.available_quantity, new { htmlAttributes = new { @class = "form-control" } })
+                @Html.ValidationMessageFor(model => model.available_quantity, "", new { @class = "text-danger" })
+            </div>
+        </div>
 
     <div class="form-group">