public IEnumerable <MaterialCor> Get() { var lstCorMaterial = new List <MaterialCor>(); using (var db = new DatabaseConnect()) using (var reader = db.Query("SELECT Id, Nome FROM MaterialCor;")) while (reader.Read()) { lstCorMaterial.Add(new MaterialCor { Id = (int)reader["Id"], Nome = (string)reader["Nome"] }); } return(lstCorMaterial); }
public Referencia BuscarPorNome(string nome) { var query = $"SELECT Id, Nome FROM Referencia WHERE Nome LIKE '{nome}';"; using (var db = new DatabaseConnect()) using (var reader = db.Query(query)) if (reader.Read()) { return new Referencia { Id = (int)reader["Id"], Nome = (string)reader["Nome"] } } ; return(null); }
public MaterialCor Criar(string nome) { var query = $"INSERT INTO MaterialCor (Nome) VALUES ('{nome}') RETURNING id;"; using (var db = new DatabaseConnect()) { using (var reader = db.Query(query)) if (reader.Read()) { return new MaterialCor { Id = int.Parse(reader["id"].ToString()), Nome = nome } } ; return(null); } } }