using System;

using System.Collections.Generic;

using System.Data;

using System.Data.Common;

using System.Linq;

using System.Threading.Tasks;

using Dapper;

using Microsoft.AspNetCore.Authorization;

using Microsoft.AspNetCore.Http;

using Microsoft.AspNetCore.Mvc;

​

namespace RKPD.API.Controllers

{

    [Route("api/[controller]"), AllowAnonymous]

    [ApiController]

    public class SIPDController : ControllerBase

    {

        private readonly DbConnection _connection;

        public SIPDController(DbConnection connection)

        {

            _connection = connection;

        }

        [HttpPost]

        public async Task<IActionResult> Push()

        {

            using (IDbConnection dbConnection = _connection)

            {

                dbConnection.Open();

                List<string> kode = new List<string>();

                var data = await dbConnection.QueryAsync("SP_GETSIPDNAS", CommandType.StoredProcedure);

                //foreach(var d in data)

                //{

                //    kode.Add(d.data["kode"]);

                //}

                return Ok(data);

            }

        }

    }

}