public ActionResult Post([FromBody] dynamic value)
{
var itens = value as Newtonsoft.Json.Linq.JObject;
foreach (var item in itens)
{
var command = new InsertAnswerCommand
{
IdQuestion = item.Key.ToString(),
IdAnswer = item.Value.ToString()
};
serviceAnswer.InsertAnswer(command);
}
return(CustomResponse());
}
public void Insert(InsertAnswerCommand insertAnswer)
{
using (var conexao = Connection.Factory.Crie(Configuration))
using (var cmd = conexao.ObtenhaComando())
{
var ultimoCodigo = ObtenhaUltimoCodigo();
cmd.CommandText = $@"INSERT INTO ANSWER(ANSCODIGO, ANSQSID, ANSLETRA) VALUES (@ANSCODIGO, @ANSQSID, @ANSLETRA)";
cmd.AddParametersToCommand(new[] { "@ANSCODIGO", "@ANSQSID", "@ANSLETRA" });
cmd.AddValuesToParameters(new List <object> {
ultimoCodigo, insertAnswer.IdQuestion, insertAnswer.IdAnswer
});
cmd.ExecuteNonQuery();
cmd.Commit();
}
}
public void InsertAnswer(InsertAnswerCommand insertAnswer)
{
mapper.Insert(insertAnswer);
}
