Delete Opertaion Query

[arunprasathv]

@Boriszn
I would like to know more about delete, since there's no context in api, i want to know how to delete row from a particular table.

[rudreshgp]

To delete a record you need to first create a method in the service

IDeviceService.cs

/// <summary>
/// Deletes a record from the Device Table
/// </summary>
/// <param name="deviceId">Id of the device</param>
void DeleteDevice(Guid deviceId);

Implement this method in the DeviceService.cs

/// <summary>
/// Deletes a record from the Device Table
/// </summary>
/// <param name="deviceId">Id of the device</param>
public void DeleteDevice(Guid deviceId)
{
    deviceValidationService.ValidateDeviceId(deviceId);

    var deviceRepository = unitOfWork.GetRepository<Device>();

    Device device = deviceRepository.Get(deviceId);

    if (device == null)
        throw new NullReferenceException();

    var entityState = deviceRepository.Delete(device);

    if (entityState != EntityState.Deleted)   // Move this to validation service
        throw new DbUpdateException("Record Not deleted", innerException: null);

    unitOfWork.Commit();
}

Then call this method from the Delete action inside DeviceController

/// <summary>
/// 
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
[HttpDelete("{deviceId}")]
[SwaggerOperation("DeleteDevice")]
public IActionResult Delete([FromRoute]Guid deviceId)
{
       deviceService.DeleteDevice(deviceId);
       return new OkResult();
}

To delete a record use HttpDelete and pass DeviceId, TenanatId as parameters.

[Boriszn]

Thanks a lot @arunprasathv @rudreshgp for the question and input.

I will create PR based on this issue, as soon as I finish with the current my task "Integration with docker and kubernetes". ;)

Best,
Boris