Create, Edit And Delete API Using Entity Framework Core

Introduction

 

In this post we will learn about Create, Edit and Delete API using Entity Framework core. The below posts will help to understand the basics of Entity Framework core and application structure.

• EFCore Implementation Using .NET core
• Using Entity Framework Core Code First Approach

Step 1

 

All the basic steps are covered in the above posts. First we will add below methods in "IEmployeeRepository.cs" file. 

void AddEmployeeAddress(int employeeId, Address address);
bool SaveDbChanges();

Step 2

 

Implement these 2 methods in "EmployeeRepository.cs". 

   public void AddEmployeeAddress(int employeeId, Address address)
      {
          var employee = GetEmployee(employeeId);
          employee.EmployeeAddress.Add(address);
      }

      public bool SaveDbChanges()
      {
          return (_context.SaveChanges() >= 0);
      }

Step 3

 

Now we will create and implement "CreateAddress" Method in "AddressController".

• Line 01, we have added "HttpPost" attribute to add "Address" entity.
• Line 08, we did the input mapping to "Address" entities.
• Line 09,10, we have used the "AddEmployeeAddress" and "SaveDbChanges" method which we created in "EmployeeRepository.cs"
• Line 11,we did the "Address" entities mapping back to "Address" DTO Model.
• Line 12-15, in general we can return the created data(Address),so that we will display in API result. 

     [HttpPost]
     public IActionResult CreateAddress(int employeeId, [FromBody] AddressModel address)
     {
         if (!_employeeRepository.IsEmployeeAvailable(employeeId))
         {
             return NotFound();
         }
         var addressData = _mapper.Map<Address>(address);
         _employeeRepository.AddEmployeeAddress(employeeId, addressData);
         _employeeRepository.SaveDbChanges();
         var addressToReturn = _mapper.Map<AddressModel>(addressData);
         return CreatedAtRoute(
             "GetEmployeeAddress",
             new { employeeId, Id = addressToReturn.Id },
             addressToReturn);
     }

Step 4

 

In Postman, if we run the POST query with input body "AddressDetail", it's inserted in Db and returns the data.

 

 

Step 5

 

Before we update the "Address" data, first check the data in "GET" call. 

 

 

Step 6

 

We can't use the "AddressModel" which we used in "CreateAddress". We need to create below "AddresUpdateModel" without "Id" fields. 

public class AddressUpdateModel
    {
        public string AddressDetail { get; set; }
    }

Step 7

 

We need add this "AddressUpdateModel" to "Address" db entities. Add the below line in "EmployeeMapper.cs" file. 

CreateMap<AddressUpdateModel,Address>();

Step 8

 

We will implement the update "UpdateAddress" method in "AddressController". We have used ""AddresUpdateModel" in input parameter and "HttpPut" Attribute.

[HttpPut("{id}")]
        public IActionResult UpdateAddress(int employeeId, int id, [FromBody] AddressUpdateModel address)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var employeeAddress = _employeeRepository.GetEmployeeAddress(employeeId, id);
            if (employeeAddress == null)
            {
                return NotFound();
            }
            _mapper.Map(address, employeeAddress);
            _employeeRepository.UpdateAddress(employeeId, employeeAddress);
            _employeeRepository.SaveDbChanges();
            return NoContent();
        }

Step 9

 

If we run the API in postman, the address details got updated as shown below. 

 

 

Step 10

 

We will add a new "Delete" method in "IEmployeeRepository" and then Impement in "EmployeeRepository" class.

 

In IEmployeeRepository,

void DeleteAddress(Address address);

In EmployeeRepository,

public void DeleteAddress(Address address)
       {
           _context.Addresses.Remove(address);
       }

Implement the method in "AddressController. 

[HttpDelete("{id}")]
       public IActionResult DeleteAddress(int employeeId, int id)
       {
           if (!_employeeRepository.IsEmployeeAvailable(employeeId))
           {
               return NotFound();
           }
           var employeeAddress = _employeeRepository.GetEmployeeAddress(employeeId, id);
           if (employeeAddress == null)
           {
               return NotFound();
           }
           _employeeRepository.DeleteAddress(employeeAddress);
           _employeeRepository.SaveDbChanges();
           return NoContent();
       }

Step 11

 

Now run the "DeleteAddress" from PostMan and we got the "204 No content" in the result. 

 

If we run the GET call for the deleted Address, we won't find it.

 

 

Step 12

 

I added below codes for your reference.

 

AddressController,

[ApiController]
    [Route("api/employee/{employeeId}/address")]
    public class AddressController : ControllerBase
    {
        private readonly ILogger<EmployeeController> _logger;
        private readonly IEmployeeRepository _employeeRepository;
        private IMapper _mapper;
        public AddressController(ILogger<EmployeeController> logger, IEmployeeRepository employeeRepository, IMapper mapper)
        {
            _logger = logger;
            _employeeRepository = employeeRepository;
            _mapper = mapper;
        }
        // GET: api/<controller>
        [HttpGet]
        public IActionResult GetAllAddress(int employeeId)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var addressData = _employeeRepository.GetAddress(employeeId);
            if (addressData == null)
            {
                return NotFound();
            }
            return Ok(_mapper.Map<IEnumerable<Address>>(addressData));
        }

        [HttpGet("{id}", Name = "GetEmployeeAddress")]
        public IActionResult GetEmployeeAddress(int employeeId, int id)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var address = _employeeRepository.GetEmployeeAddress(employeeId, id);
            if (address == null)
            {
                return NotFound();
            }
            return Ok(_mapper.Map<Address>(address));
        }

        [HttpPost]
        public IActionResult CreateAddress(int employeeId, [FromBody] AddressModel address)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var addressData = _mapper.Map<Address>(address);
            _employeeRepository.AddEmployeeAddress(employeeId, addressData);
            _employeeRepository.SaveDbChanges();
            var addressToReturn = _mapper.Map<AddressModel>(addressData);
            return CreatedAtRoute(
                "GetEmployeeAddress",
                new { employeeId, Id = addressToReturn.Id },
                addressToReturn);
        }

        [HttpPut("{id}")]
        public IActionResult UpdateAddress(int employeeId, int id, [FromBody] AddressUpdateModel address)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var employeeAddress = _employeeRepository.GetEmployeeAddress(employeeId, id);
            if (employeeAddress == null)
            {
                return NotFound();
            }
            _mapper.Map(address, employeeAddress);
            _employeeRepository.UpdateAddress(employeeId, employeeAddress);
            _employeeRepository.SaveDbChanges();
            return NoContent();
        }

        [HttpDelete("{id}")]
        public IActionResult DeleteAddress(int employeeId, int id)
        {
            if (!_employeeRepository.IsEmployeeAvailable(employeeId))
            {
                return NotFound();
            }
            var employeeAddress = _employeeRepository.GetEmployeeAddress(employeeId, id);
            if (employeeAddress == null)
            {
                return NotFound();
            }
            _employeeRepository.DeleteAddress(employeeAddress);
            _employeeRepository.SaveDbChanges();
            return NoContent();
        }
    }

EmployeeRepository,

public class EmployeeRepository : IEmployeeRepository
    {
        private readonly EmployeeDbContext _context;
        public EmployeeRepository(EmployeeDbContext context)
        {
            _context = context;
        }
        public void AddEmployeeAddress(int employeeId, Address address)
        {
            var employee = GetEmployee(employeeId);
            employee.EmployeeAddress.Add(address);
        }
        public bool SaveDbChanges()
        {
            return (_context.SaveChanges() >= 0);
        }
        public void UpdateAddress(int employeeId, Address address)
        {
            //var employee = GetEmployee(employeeId);
            //employee.EmployeeAddress.Add(address);
        }
        public void DeleteAddress(Address address)
        {
            _context.Addresses.Remove(address);
        }
        public IEnumerable<Employee> GetAllEmployee()
        {
            return _context.Employees.OrderBy(e => e.EmployeeName).ToList();
        }
        public Employee GetEmployee(int employeeId, bool isWithAddress=false)
        {
            if (isWithAddress)
            {
                return _context.Employees.Include(e => e.EmployeeAddress)
                            .Where(a => a.Id == employeeId).FirstOrDefault();
            }
              return _context.Employees.Where(e => e.Id==employeeId).FirstOrDefault();
        }
        public Address GetEmployeeAddress(int employeeId, int addressId)
        {
            return _context.Addresses.Where(a => a.Id == addressId
                                        && a.EmployeeId == employeeId).FirstOrDefault();
        }
        public IEnumerable<Address> GetAddress(int employeeId)
        {
            return _context.Addresses.Where(a => a.EmployeeId == employeeId).ToList();
        }
        public bool IsEmployeeAvailable(int employeeId)
        {
            return _context.Employees.Any(e => e.Id == employeeId);
        }
    }

Summary

 

In this post we learned to create, update and delete API resources using "Entity Framwork Core". You can also check the previous "Entitiy Framework Core" posts from the below links.

• EFCore Implementation Using .NET core
• Using Entity Framework Core Code First Approach