Changeset e9bb9d1 for PostgreSqlDotnetCore/Controllers/HomeController.cs

Timestamp:

08/28/24 21:41:13 (4 weeks ago)

Author:

ElenaMoskova <elena.moskova99@…>

Branches:

main

Children:

a850333

Parents:

118e414

Message:

Use of views

1. Use of views in VetCenters.
2. Ability to provide a response to a given response.

File:

• PostgreSqlDotnetCore/Controllers/HomeController.cs (modified) (5 diffs)

PostgreSqlDotnetCore/Controllers/HomeController.cs

@@ -1 +1 @@
 using Microsoft.AspNetCore.Identity;
 using Microsoft.AspNetCore.Mvc;
+using Microsoft.EntityFrameworkCore;
 using PostgreSqlDotnetCore.Data;
 using PostgreSqlDotnetCore.Models;
@@ -30 +31 @@
                 if (user != null)
                 {
-                    UsersClass customerClass = db.CustomerObj.SingleOrDefault(x=> x.email == user.Email);
+                    UsersClass customerClass = db.CustomerObj.SingleOrDefault(x => x.email == user.Email);
                     if (customerClass == null)
                     {
@@ -43 +44 @@
                                 lastName = nameLastName[0].Split('.')[1];
                             }
-                        } catch(Exception ex) { 
+                        }
+                        catch (Exception ex)
+                        {
                         }
                         db.CustomerObj.Add(new UsersClass(
@@ -65 +68 @@
                 }
 
-            } else
+            }
+            else
             {
                 ViewBag.isAuthenticated = null;
@@ -86 +90 @@
         public async Task<IActionResult> ContactAsync()
         {
+
+            //var query = db.Database.ExecuteSqlRaw("CALL get_pet_details()");
+            //var query = db.Database.ExecuteSqlRaw("SELECT * FROM get_pet_details()");
+
+
             // set if is authenticated
             ViewBag.isAuthenticated = await getCrrentUser();