public ProbaDTO(int id, float distanta, Stiluri stil, int nrParticipanti) { Id = id; Distanta = distanta; Stil = stil; NrParticipanti = nrParticipanti; }
public Proba Get(int id) { log.InfoFormat("Se cauta proba cu id-ul {0}", id); var con = DBUtils.getConnection(); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from Probe where id=@id"; var paramId = comm.CreateParameter(); paramId.ParameterName = "@id"; paramId.Value = id; comm.Parameters.Add(paramId); using (var dataR = comm.ExecuteReader()) { if (dataR.Read()) { float distanta = dataR.GetFloat(1); Stiluri stil = (Stiluri)Enum.Parse(typeof(Stiluri), dataR.GetString(2)); Proba p = new Proba(id, distanta, stil); log.InfoFormat("S-a gasit {0}", p); return(p); } } } log.InfoFormat("Nu s-a gasit nicio proba cu id-ul {0}", id); return(null); }
public IEnumerable <Proba> FindAll() { log.Info("Se incepe conectarea la bd si selectarea tuturor probelor"); var con = DBUtils.getConnection(); IList <Proba> probe = new List <Proba>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from Probe"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int id = dataR.GetInt32(0); Console.WriteLine("proba " + id); float distanta = dataR.GetFloat(1); Stiluri stil = (Stiluri)Enum.Parse(typeof(Stiluri), dataR.GetString(2)); Proba p = new Proba(id, distanta, stil); probe.Add(p); } } } return(probe); }
public IEnumerable <Proba> FindProbeDupaStil(Stiluri stil) { throw new NotImplementedException(); }
public Proba(int id, float distanta, Stiluri stil) { base.Id = id; Distanta = distanta; Stil = stil; }