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