public IActionResult Post([FromBody] ObjetoVM obj) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var result = _service.Post(obj); if (result == null) { return(NoContent()); } return(Ok(result)); } catch (Exception ex) { return(BadRequest(new { errors = new string[] { "Falha ao postar: " + ex.Message } })); } }
public ProtocoloVM Post(ObjetoVM obj) { ProtocoloVM protocolo = new ProtocoloVM { Sequencia = string.Empty }; var procedure = "sp_registro"; var parameters = new List <MySqlParameter> { new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@tipo", Value = obj.Tipo }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@assunto", Value = obj.Assunto }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@mensagem", Value = obj.Mensagem }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@nome", Value = obj.Nome }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@fone", Value = obj.Fone }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@email", Value = obj.Email }, new MySqlParameter { MySqlDbType = MySqlDbType.DateTime, ParameterName = "@datahora", Value = DateTime.Now.AddDays(7) }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@observacao", Value = "WEB" }, new MySqlParameter { MySqlDbType = MySqlDbType.Int32, ParameterName = "@usuario", Value = obj.Usuario }, new MySqlParameter { MySqlDbType = MySqlDbType.VarChar, ParameterName = "@protocolo", Value = string.Empty, Direction = ParameterDirection.Output } }; MySqlConnection connection = new MySqlConnection(DbConn.ConnectionString); connection.Open(); MySqlCommand command = new MySqlCommand(procedure, connection); command.Parameters.AddRange(parameters.ToArray()); command.CommandTimeout = 5; command.CommandType = CommandType.StoredProcedure; command.ExecuteNonQuery(); protocolo.Sequencia = command.Parameters["@protocolo"].Value.ToString(); command.Dispose(); return(protocolo); }
public static RegistroLog ObjToModelLog(this ObjetoVM obj) { if (obj == null) { return(null); } var model = new RegistroLog() { Id_registro = obj.Id, Id_usuario = obj.Usuario, }; return(model); }
public static Registro ObjToModel(this ObjetoVM obj) { if (obj == null) { return(null); } var model = new Registro() { Id = obj.Id, Tipo = obj.Tipo, Assunto = obj.Assunto, Mensagem = obj.Mensagem, Nome = obj.Nome, Fone = obj.Fone, Email = obj.Email, Registrado_em = obj.Registrado_em, Uu_Id = obj.Uu_Id }; return(model); }