//Monta o values do insert
private string _GetValuesAlocacoes(ObjBanco objBanco)
{
try
{
StringBuilder campos = new StringBuilder();
PropertyInfo[] propriedades = typeof(ObjBanco).GetProperties();
int i = 1;
foreach (PropertyInfo prop in propriedades)
{
if (prop.Name.ToUpper() != "ID")
{
if (i == propriedades.Length)
{
campos.AppendLine($"{_ferramentas.TratarCampos(prop.GetValue(objBanco), prop)}");
}
else
{
campos.AppendLine($"{_ferramentas.TratarCampos(prop.GetValue(objBanco), prop)},");
}
}
i++;
}
string script = campos.ToString();
return(script);
}
catch (Exception)
{
throw;
}
}
public int Post(ObjBanco Aloc)
{
StringBuilder script = new StringBuilder();
script.AppendLine("INSERT INTO [TABLE](");
script.AppendLine(_GetCampos());
script.AppendLine($") VALUES ({_GetValuesAlocacoes(Aloc)})");
using (SqlConnection conexao = _connection.Conectar())
{
int rowAffected;
using (SqlCommand cmd = new SqlCommand(script.ToString(), conexao))
{
cmd.CommandText = script.ToString();
conexao.Open();
rowAffected = cmd.ExecuteNonQuery();
}
return(rowAffected);
}
}
public IHttpActionResult postAlocacoes([FromBody] ObjBanco obj)
{
return(Ok(data.Post(obj)));
}
