public async Task <IActionResult> AlphaDeliveryStatus(DeliveryStatusRequest item)
{
var now = $"{DateTime.Now:yyyy-MM-dd HH:mm:ss}";
var receive = $"{item.ReceiveDate:yyyy-MM-dd HH:mm:ss}";
//insert 1of2
var strSql = $"insert tbl_scg_3rd_parcel_status (3rd_party_id,3rd_parcel_status_code,c2_tracking_number,3rd_party_tracking_1,datetime_input,datetime_created) values ('4','{item.Status}','{item.QRCode}','{item.QRCode}','{receive}','{now}')";
//insert 2of2
//todo waiting from joe
await appQuery.ExecuteToSqlAsync(strSql);
var serealize = System.Text.Json.JsonSerializer.Serialize <OkObjectResult>(new OkObjectResult(StatusCodes.Status200OK));
return(StatusCode(StatusCodes.Status201Created, serealize));
}
