public async Task <IActionResult> AgencyDeleteByIdAsync(int id)
{
var req = new AgencyDeleteByIdRequest
{
Id = id,
CurrentUser = User.CurrentUserName()
};
var result = await _AgencyManager.DeleteAgencyByIdAsync(req);
return(Ok(result));
}
public async Task <AgencyDeleteByIdResponse> DeleteAgencyByIdAsync(AgencyDeleteByIdRequest req)
{
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
var result = new AgencyDeleteByIdResponse();
const string storeproc = @"[dbo].[uspAgenciesDelete_New]";
await conn.OpenAsync();
var dynParm = new
{
ID = req.Id,
LastUpdatedBy = req.CurrentUser,
LastModifiedDate = req.UpdatedDate
};
await conn.ExecuteAsync(storeproc, dynParm, null, null, CommandType.StoredProcedure);
return(result);
}
}
public async Task <AgencyDeleteByIdResponse> DeleteAgencyByIdAsync(AgencyDeleteByIdRequest req)
{
req.UpdatedDate = DateTime.Today;
return(await _repos.DeleteAgencyByIdAsync(req));
}
