using System.Collections.Generic;
using System.Data.Common;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
namespace RKPD.API.Controllers
[Route("api/[controller]"), AllowAnonymous]
public class SIPDController : ControllerBase
private readonly DbConnection _connection;
public SIPDController(DbConnection connection)
_connection = connection;
public async Task<IActionResult> Push()
using (IDbConnection dbConnection = _connection)
List<string> kode = new List<string>();
var data = await dbConnection.QueryAsync("SP_GETSIPDNAS", CommandType.StoredProcedure);