public void AddCompletedHow(CompletedHow completedHow)
{
using (var conn = Connection)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO CompletedHow (DateCompleted, HowId)
OUTPUT INSERTED.ID
VALUES (@DateCompleted, @HowId)";
cmd.Parameters.AddWithValue("@DateCompleted", completedHow.DateCompleted);
cmd.Parameters.AddWithValue("@HowId", completedHow.HowId);
completedHow.Id = (int)cmd.ExecuteScalar();
}
}
}
public IActionResult Post(CompletedHow completedHow)
{
_completedHowRepository.AddCompletedHow(completedHow);
return(CreatedAtAction("Get", new { id = completedHow.Id }, completedHow));
}
