public List <PreValue> GetAllPreValues(Field field) { List <PreValue> l = new List <PreValue>(); string sql = "SELECT * From UFprevalues where field = @field"; IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@field", field.Id)); while (rr.Read()) { PreValue pv = PreValue.CreateFromDataReader(rr); l.Add(pv); } rr.Dispose(); return(l); }
public PreValue GetPreValue(Guid id) { string sql = "SELECT * From UFprevalues where id = @id"; IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@id", id)); PreValue pv = new PreValue(); if (rr.Read()) { pv = PreValue.CreateFromDataReader(rr); return(pv); } rr.Dispose(); return(pv); }