public async Task <bool> Update(int id, ImportTransport importtransport)
{
// Update
using (var db = Connection)
{
const string sql = @"UPDATE [ImportTransports] SET Sender = @Sender, ImportDate = @ImportDate WHERE ImportTransportId = @ImportTransportId";
var result = await db.ExecuteAsync(sql, new { Sender = importtransport.Sender, ImportDate = importtransport.ImportDate, ImportTransportId = id });
return(result != 0);
}
}
public async Task <bool> Insert(ImportTransport importtransport)
{
// Insert
using (var db = Connection)
{
const string sql = @"INSERT INTO [ImportTransports] (Sender, ImportDate) VALUES (@Sender, @ImportDate)";
var result = await db.ExecuteAsync(sql, new { Sender = importtransport.Sender, ImportDate = importtransport.ImportDate }).ConfigureAwait(false);
return(result != 0);
}
}
public async Task <IActionResult> Put(int id, [FromBody] ImportTransport import)
{
var result = await _repository.Update(id, import).ConfigureAwait(false);
return(result ? new StatusCodeResult(200) : new StatusCodeResult(422));
}
