Changeset 6f203af for FarmatikoData/FarmatikoRepo/PHRepo.cs

Timestamp:

10/28/20 22:06:48 (3 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

993189e

Parents:

1454207

Message:

Change methods & add error controller

File:

• FarmatikoData/FarmatikoRepo/PHRepo.cs (modified) (3 diffs)

FarmatikoData/FarmatikoRepo/PHRepo.cs

@@ -1 +1 @@
 using FarmatikoData.FarmatikoRepoInterfaces;
 using FarmatikoData.Models;
-using System;
+using Microsoft.EntityFrameworkCore;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using System.Threading.Tasks;
 
@@ -16 +15 @@
             _context = context;
         }
-
-        public async Task ClaimPharmacy(RequestPharmacyHead pharmacy)
+        //GET
+        public async Task<PharmacyHead> GetPharmacyHeadByIdAsync(int id)
         {
-            await Task.Run(() => _context.PHRequests.Add(pharmacy));
-            await _context.SaveChangesAsync();
-        }
-
-        public async Task<PharmacyHead> GetPharmacyHead(PharmacyHead pharmacyHead)
-        {
-            var Phead = await Task.Run(() => _context.PharmacyHeads.Where(x => x.Email.Equals(pharmacyHead.Email)).FirstOrDefault());
+            var Phead = await _context.PharmacyHeads.Where(x => x.Id == id).FirstOrDefaultAsync();
             return Phead;
         }
 
-        public async Task<IQueryable<PharmacyHead>> GetPharmacyHeadInfo()
+        public async Task<IEnumerable<PharmacyHead>> GetPharmacyHeadInfo()
         {
-            var PHeadInfo = await Task.Run(() => _context.PharmacyHeads.Take(10));
+            var PHeadInfo = await _context.PharmacyHeads.Take(10).Where(x => x.DeletedOn == null)
+                .Select(x => new PharmacyHead
+                {
+                    Id = x.Id,
+                    Name = x.Name,
+                    Email = x.Email,
+                    Password = x.Password,
+                    MedicineLists = x.MedicineLists,
+                    PharmaciesList = x.PharmaciesList
+                }).ToListAsync();
             return PHeadInfo;
         }
-
+        //POST
         public async Task UpdatePharmacyHead(PharmacyHead pharmacyHead)
         {
-            var EditedPHead = await Task.Run(() => _context.PharmacyHeads.Where(x => x.Id == pharmacyHead.Id).FirstOrDefault());
+            var EditedPHead = await _context.PharmacyHeads.Where(x => x.Id == pharmacyHead.Id).FirstOrDefaultAsync();
             EditedPHead.Email = pharmacyHead.Email;
             EditedPHead.Name = pharmacyHead.Name;
@@ -45 +47 @@
             await _context.SaveChangesAsync();
         }
+        public async Task ClaimPharmacy(RequestPharmacyHead pharmacy)
+        {
+            await _context.PHRequests.AddAsync(pharmacy);
+            await _context.SaveChangesAsync();
+        }
+        public async Task Add(PharmacyHead pharmacyHead)
+        {
+            await _context.PharmacyHeads.AddAsync(pharmacyHead);
+            await _context.SaveChangesAsync();
+        }
+
+        public async Task Remove(PharmacyHead phead)
+        {
+            var Phead = await _context.PharmacyHeads.Where(x => x.Id == phead.Id).FirstOrDefaultAsync();
+            Phead.DeletedOn = phead.DeletedOn;
+            await _context.SaveChangesAsync();
+        }
+
+        public async Task RemoveClaimingRequest(int id)
+        {
+            var req = await _context.PHRequests.Where(r => r.Id == id).FirstOrDefaultAsync();
+            _context.PHRequests.Remove(req);
+            await _context.SaveChangesAsync();
+        }
     }
 }