public ProbaParticipant Save(ProbaParticipant elem) { log.Info("Se incearca adaugarea"); var con = DBUtils.getConnection(); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into ProbeParticipanti (idProba,idParticipant) values (@idProba, @idParticipant)"; var paramNume = comm.CreateParameter(); paramNume.ParameterName = "@idProba"; paramNume.Value = elem.IdProba; comm.Parameters.Add(paramNume); var paramVarsta = comm.CreateParameter(); paramVarsta.ParameterName = "@idParticipant"; paramVarsta.Value = elem.IdParticipant; comm.Parameters.Add(paramVarsta); var result = comm.ExecuteNonQuery(); log.Info("S-a adaugat " + elem.ToString()); return(elem); } }
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 Proba Save(Proba elem) { log.Info("Se incearca adaugarea"); var con = DBUtils.getConnection(); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into Probe (distanta,stil) values (@distanta, @stil)"; var paramNume = comm.CreateParameter(); paramNume.ParameterName = "@distanta"; paramNume.Value = elem.Distanta; comm.Parameters.Add(paramNume); var paramVarsta = comm.CreateParameter(); paramVarsta.ParameterName = "@stil"; paramVarsta.Value = elem.Stil.ToString(); comm.Parameters.Add(paramVarsta); var result = comm.ExecuteNonQuery(); log.Info("S-a adaugat " + elem.ToString()); return(elem); } }
public Participant Save(Participant elem) { log.Info("Se incearca adaugarea"); var con = DBUtils.getConnection(); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into Participanti (nume,varsta) values (@nume, @varsta)"; var paramNume = comm.CreateParameter(); paramNume.ParameterName = "@nume"; paramNume.Value = elem.Nume; comm.Parameters.Add(paramNume); var paramVarsta = comm.CreateParameter(); paramVarsta.ParameterName = "@varsta"; paramVarsta.Value = elem.Varsta; comm.Parameters.Add(paramVarsta); var result = comm.ExecuteNonQuery(); log.Info("S-a adaugat " + elem.ToString()); return(FindParticipantiDupaNume(elem.Nume).First()); } }