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);
}
