Index: PostgreSqlDotnetCore/Controllers/BlogController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/BlogController.cs	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Controllers/BlogController.cs	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -44,5 +44,5 @@
             // query
             var query = from st in db.BlogPostAnswersObj
-                        where st.blogpostconsultationid == blogClass.id
+                        where st.BlogPostConsultationid == blogClass.id
                         select st;
             //elenaaa
Index: PostgreSqlDotnetCore/Controllers/PetCaresController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/PetCaresController.cs	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Controllers/PetCaresController.cs	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -130,5 +130,36 @@
 
         // GET: Customer/Edit/5
-        public ActionResult Edit(int? id)
+        /*  public ActionResult Edit(int? id)
+          {
+              if (id == null)
+              {
+                  return RedirectToAction("NotExist", "Error");
+              }
+              Pet_CaresClass peClass = db.PetCaresObj.Find(id);
+              if (peClass == null)
+              {
+                  return RedirectToAction("NotExist", "Error");
+              }
+
+
+              return View(peClass);
+          }*/
+        // GET: Customer/Edit/5
+        /* public  ActionResult Edit(int? id)
+         {
+             if (id == null)
+             {
+                 return RedirectToAction("NotExist", "Error");
+             }
+             Pet_CaresClass peClass = db.PetCaresObj.Find(id);
+             if (peClass == null)
+             {
+                 return RedirectToAction("NotExist", "Error");
+             }
+
+
+             return View(peClass);
+         }*/
+        public async Task<ActionResult> Edit(int? id)
         {
             if (id == null)
@@ -136,11 +167,18 @@
                 return RedirectToAction("NotExist", "Error");
             }
-            Pet_CaresClass peClass = db.PetCaresObj.Find(id);
+
+            Pet_CaresClass peClass = await db.PetCaresObj.FindAsync(id);
             if (peClass == null)
             {
                 return RedirectToAction("NotExist", "Error");
             }
-            return View(peClass);
-        }
+
+            var vetCenters = await db.VetCentersObj.ToListAsync();
+            ViewBag.VetCenters = new SelectList(vetCenters, "id", "name", peClass.vetcentersid);
+
+            return View(peClass);
+        }
+
+
 
         // POST: Customer/Edit/5
@@ -149,5 +187,5 @@
         [HttpPost]
         [ValidateAntiForgeryToken]
-        public async Task<ActionResult> EditAsync([Bind(include: "id,title,description,dateending, start_date vetcentersid")] Pet_CaresClass peClass)
+        public async Task<ActionResult> EditAsync([Bind(include: "id,title,description,dateending, vetcentersid")] Pet_CaresClass peClass)
         {
             bool isAuthenticated = User.Identity.IsAuthenticated;
@@ -156,9 +194,8 @@
                 return RedirectToAction("AccessDenied", "Error");
             }
-             
+
             if (ModelState.IsValid)
             {
                 peClass.dateending = DateTime.SpecifyKind(peClass.dateending, DateTimeKind.Utc);
-                peClass.start_date = DateTime.SpecifyKind(peClass.start_date, DateTimeKind.Utc);
                 var user = await _userManager.GetUserAsync(User);
                 var customerClass = db.CustomerObj.SingleOrDefault(x => x.email == user.Email);
@@ -171,4 +208,7 @@
         }
 
+
+
+
         // GET: Customer/Delete/5
         public ActionResult Delete(int? id)
Index: PostgreSqlDotnetCore/Controllers/PetsController.cs
===================================================================
--- PostgreSqlDotnetCore/Controllers/PetsController.cs	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Controllers/PetsController.cs	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -73,5 +73,5 @@
         [HttpPost]
         [ValidateAntiForgeryToken]
-        public async Task<ActionResult> CreateAsync([Bind(include: "id,color,description,dateofbirthday, usersid,typeofpetsid")] PetsClass peClass)
+        public async Task<ActionResult> CreateAsync([Bind(include: "id,name,color,description,dateofbirthday, usersid,typeofpetsid")] PetsClass peClass)
         {
             bool isAuthenticated = User.Identity.IsAuthenticated;
@@ -116,5 +116,5 @@
         [HttpPost]
         [ValidateAntiForgeryToken]
-        public async Task<ActionResult> EditAsync([Bind(include: "id,color,description,dateofbirthday, usersid,typeofpetsid")] PetsClass peClass)
+        public async Task<ActionResult> EditAsync([Bind(include: "id,name, color,description,dateofbirthday, usersid,typeofpetsid")] PetsClass peClass)
         {
             bool isAuthenticated = User.Identity.IsAuthenticated;
Index: PostgreSqlDotnetCore/Models/BlogPostAnswers.cs
===================================================================
--- PostgreSqlDotnetCore/Models/BlogPostAnswers.cs	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Models/BlogPostAnswers.cs	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -12,5 +12,10 @@
         public int parent_id { get; set; }
         public string reply { get; set; }
-        public int? blogpostconsultationid { get; set; }
+
+        [ForeignKey("BlogPostConsultation")]
+        [Column("blogpostconsid")]
+        public int BlogPostConsultationid { get; set; }
+        public BlogPostConsultation BlogPostConsultation { get; set; }
+
         public int usersid { get; set; }
     }
Index: PostgreSqlDotnetCore/Models/PetsClass.cs
===================================================================
--- PostgreSqlDotnetCore/Models/PetsClass.cs	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Models/PetsClass.cs	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -16,4 +16,6 @@
         public string color { get; set; }
 
+        public string name { get; set; }
+
         public string description { get; set; }
        // public DateTime dateofbirthday { get; set; }
Index: PostgreSqlDotnetCore/Views/PetCares/Edit.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/PetCares/Edit.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/PetCares/Edit.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -48,5 +48,14 @@
         </div>
 
-    <div class="form-group">
+        <div class="form-group">
+            @Html.LabelFor(model => model.vetcentersid, htmlAttributes: new { @class = "control-label col-md-2" })
+            <div class="col-md-10">
+                @Html.DropDownListFor(model => model.vetcentersid, (SelectList)ViewBag.VetCenters, "Select VetCenter", new { @class = "form-control" })
+                @Html.ValidationMessageFor(model => model.vetcentersid, "", new { @class = "text-danger" })
+            </div>
+        </div>
+
+
+   @*<div class="form-group">
         @Html.LabelFor(model => model.vetcentersid, htmlAttributes: new { @class = "control-label col-md-2" })
         <div class="col-md-10">
@@ -55,4 +64,13 @@
         </div>
     </div>
+    *@
+        @*
+        <div class="form-group">
+            <label class="control-label col-md-2" for="vetcentersid">VetCenter:</label>
+            <div class="col-md-10">
+                @Html.DropDownList("vetcentersid", (SelectList)ViewBag.VetCenters, "Select VetCenter", new { @class = "form-control" })
+            </div>
+        </div>
+    *@
 
 
Index: PostgreSqlDotnetCore/Views/Pets/Create.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Pets/Create.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/Pets/Create.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -16,4 +16,12 @@
     <hr />
     @Html.ValidationSummary(true, "", new { @class = "text-danger" })
+
+        <div class="form-group">
+            @Html.LabelFor(model => model.name, htmlAttributes: new { @class = "control-label col-md-2" })
+            <div class="col-md-10">
+                @Html.EditorFor(model => model.name, new { htmlAttributes = new { @class = "form-control" } })
+                @Html.ValidationMessageFor(model => model.name, "", new { @class = "text-danger" })
+            </div>
+        </div>
 
     <div class="form-group">
Index: PostgreSqlDotnetCore/Views/Pets/Delete.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Pets/Delete.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/Pets/Delete.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -12,4 +12,12 @@
     <hr />
     <dl class="dl-horizontal">
+
+        <dt>
+            @Html.DisplayNameFor(model => model.name)
+        </dt>
+
+        <dd>
+            @Html.DisplayFor(model => model.name)
+        </dd>
         <dt>
             @Html.DisplayNameFor(model => model.color)
Index: PostgreSqlDotnetCore/Views/Pets/Details.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Pets/Details.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/Pets/Details.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -11,4 +11,11 @@
     <hr />
     <dl class="dl-horizontal">
+        <dt>
+            @Html.DisplayNameFor(model => model.name)
+        </dt>
+
+        <dd>
+            @Html.DisplayFor(model => model.name)
+        </dd>
         <dt>
             @Html.DisplayNameFor(model => model.color)
Index: PostgreSqlDotnetCore/Views/Pets/Edit.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Pets/Edit.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/Pets/Edit.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -18,4 +18,11 @@
     @Html.HiddenFor(model => model.id)
 
+        <div class="form-group">
+            @Html.LabelFor(model => model.name, htmlAttributes: new { @class = "control-label col-md-2" })
+            <div class="col-md-10">
+                @Html.EditorFor(model => model.name, new { htmlAttributes = new { @class = "form-control" } })
+                @Html.ValidationMessageFor(model => model.name, "", new { @class = "text-danger" })
+            </div>
+        </div>
     <div class="form-group">
         @Html.LabelFor(model => model.color, htmlAttributes: new { @class = "control-label col-md-2" })
Index: PostgreSqlDotnetCore/Views/Pets/Index.cshtml
===================================================================
--- PostgreSqlDotnetCore/Views/Pets/Index.cshtml	(revision ae6c0712e0210e422db7f9965730be72399e4ad4)
+++ PostgreSqlDotnetCore/Views/Pets/Index.cshtml	(revision 8f8226c8dbb4aa7ecab93c2a9feb0b429fbf2f1c)
@@ -12,4 +12,7 @@
 <table class="table">
     <tr>
+        <th>
+            @Html.DisplayNameFor(model => model.name)
+        </th>
 
         <th>
@@ -36,4 +39,7 @@
 @foreach (var item in Model) {
     <tr>
+            <td>
+                @Html.DisplayFor(modelItem => item.name)
+            </td>
         <td>
             @Html.DisplayFor(modelItem => item.color)