Changeset d2e69be for FarmatikoData

Timestamp:

07/27/20 17:10:07 (4 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

ef1219a

Parents:

4b342bb

Message:

Add Route Attribute

Location:

FarmatikoData

Files:

• Base/BaseEntity.cs (modified) (1 diff)
• FarmatikoRepo/HealthFacilityRepository.cs (modified) (1 diff)
• FarmatikoRepoInterfaces/IHealthFacilityRepository.cs (modified) (1 diff)
• Migrations/20200722131856_Initial migration.cs (modified) (7 diffs)

FarmatikoData/Base/BaseEntity.cs

@@ -9 +9 @@
         public int Id { get; set; }
         public DateTime CreatedOn { get; set; }
+
         public DateTime DeletedOn { get; set; }
     }

FarmatikoData/FarmatikoRepo/HealthFacilityRepository.cs

@@ -26 +26 @@
         public IEnumerable<HealthFacilities> GetAll()
         {
-            return _context.HealthFacilities;
+            return _context.HealthFacilities.OrderBy(x => x.Name).ToList();
         }
 
-        public HealthFacilities GetByFullName(string FullName)
+        public IEnumerable<HealthFacilities> GetAllByName(string Name)
         {
-            return (HealthFacilities)_context.HealthFacilities
-                .Where(Facility => Facility.Name == FullName)
-                .FirstOrDefault(Facility => Facility.Name == FullName);
+            Name = Name.ToLower();
+
+            return _context.HealthFacilities.Where(x => x.Name.ToLower().Contains(Name)).OrderBy(x => x.Name.ToLower().IndexOf(Name)).ToList();
         }
 
-        public HealthFacilities GetByType(string FacilityType)
+        IEnumerable<HealthFacilities> IHealthFacilityRepository.GetByType(string Type)
         {
-            return (HealthFacilities)_context.HealthFacilities
-                .Where(FacilityType => FacilityType.Type.Equals(FacilityType))
-                .FirstOrDefault(FacilityType => FacilityType.Name.Equals(FacilityType));
+            return (IEnumerable<HealthFacilities>)_context.HealthFacilities
+               .Where(type => type.Type.Equals(Type));
         }
-
-        public void Remove(string healthFacility)
-        {
-            HealthFacilities Facility = (HealthFacilities)_context.HealthFacilities.Where(healthFacility => healthFacility.Name.Equals(healthFacility));
-            _context.Remove(Facility);
-            _context.SaveChangesAsync();
-        }
-
     }
 }

FarmatikoData/FarmatikoRepoInterfaces/IHealthFacilityRepository.cs

@@ -9 +9 @@
     {
         IEnumerable<HealthFacilities> GetAll();
-        HealthFacilities GetByFullName(string FullName);
-        HealthFacilities GetByType(string FacilityType);
+        IEnumerable<HealthFacilities> GetByType(string Type);
         void Add(HealthFacilities healthFacility);
-        void Remove(string healthFacility);
+        IEnumerable<HealthFacilities> GetAllByName(string Name);
     }
 }

FarmatikoData/Migrations/20200722131856_Initial migration.cs

@@ -15 +15 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: false),
                     Municipality = table.Column<string>(nullable: false),
@@ -35 +35 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: true),
                     TotalMK = table.Column<int>(nullable: false),
@@ -57 +57 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: false),
                     Branch = table.Column<string>(nullable: false),
@@ -81 +81 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: true),
                     Strength = table.Column<string>(nullable: true),
@@ -103 +103 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     PharmacyMedicinesId = table.Column<int>(nullable: true),
                     PharmacyId = table.Column<int>(nullable: true),
@@ -122 +122 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     MedicinesId = table.Column<int>(nullable: true),
                     HasMedicine = table.Column<bool>(nullable: false),
@@ -151 +151 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false),
-                    DeletedOn = table.Column<DateTime>(nullable: false),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: true),
                     Location = table.Column<string>(nullable: true),