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