private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Proba proba = (Proba)comboBox1.SelectedItem;
selectedProba = probaController.findOne(proba.Id);
showParticipantiFaraNotaLaProba();
}
public Scor findOne(int id)
{
MySqlConnection connection = databaseConnection.getConnection();
ParticipantRepository participantRepository = new ParticipantRepository();
ProbaRepository probaRepository = new ProbaRepository();
using (connection)
{
connection.Open();
MySqlCommand cmd = new MySqlCommand("Select * from scores where id=@id", connection);
cmd.Parameters.AddWithValue("@id", id);
cmd.Prepare();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Participant participant = participantRepository.findOne(Convert.ToInt32(reader["id_participant"]));
Proba proba = probaRepository.findOne(Convert.ToInt32(reader["id_proba"]));
return(new Scor(
Convert.ToInt32(reader["ID"]),
participant,
proba,
Convert.ToInt32(reader["score"])
));
}
}
connection.Close();
}
return(null);
}
public List <Participant> getParticipantWithNoScoreForProba(Proba proba)
{
MySqlConnection connection = databaseConnection.getConnection();
using (connection)
{
connection.Open();
MySqlCommand cmd = new MySqlCommand("Select * from participants p " +
"where p.ID not in " +
"(select IDparticipant " +
"from scores s " +
"inner join proba pr " +
"on pr.ID=s.IDProba " +
"where IDProba=@id)", connection);
List <Participant> list = new List <Participant>();
cmd.Parameters.AddWithValue("@id", proba.Id);
cmd.Prepare();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Participant(
Convert.ToInt32(reader["ID"]),
reader["name"].ToString()));
}
return(list);
}
}
}
public Scor(int id, Participant participant, Proba proba, int score)
{
this.id = id;
this.participant = participant;
this.proba = proba;
this.score = score;
}
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 List <Scor> getScoresFromProba(Proba proba)
{
MySqlConnection connection = databaseConnection.getConnection();
using (connection)
{
connection.Open();
MySqlCommand cmd = new MySqlCommand("Select * from participants p Inner join scores s on p.ID = s.IDParticipant inner join proba pr on s.IDProba = pr.ID where pr.ID = @id order by s.score desc", connection);
List <Scor> list = new List <Scor>();
cmd.Parameters.AddWithValue("@id", proba.Id);
cmd.Prepare();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Participant participant = participantRepository.findOne(Convert.ToInt32(reader["IDParticipant"]));
list.Add(new Scor(
Convert.ToInt32(reader["ID"]),
participant,
proba,
Convert.ToInt32(reader["score"])));
}
return(list);
}
}
}
public List <Scor> findAll()
{
MySqlConnection connection = databaseConnection.getConnection();
using (connection)
{
connection.Open();
MySqlCommand cmd = new MySqlCommand("Select * from scores", connection);
List <Scor> list = new List <Scor>();
cmd.Prepare();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Participant participant = participantRepository.findOne(Convert.ToInt32(reader["IDParticipant"]));
Proba proba = probaRepository.findOne(Convert.ToInt32(reader["IDProba"]));
list.Add(new Scor(
Convert.ToInt32(reader["ID"]),
participant,
proba,
Convert.ToInt32(reader["score"])));
}
return(list);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Proba proba = db.Probe.Find(id);
db.Probe.Remove(proba);
db.SaveChanges();
return(RedirectToAction("Index"));
}
static void Main()
{
Proba<DateTime> a=new Proba<DateTime>(data);
a(DateTime.Now);
Proba<int>b=new Proba<int>(int1);
b(6);
Proba<string>c=new Proba<string>(Proba1);
c("test");
}
public void Dostava(Proba p)
{
//Console.WriteLine($"{p.ID},{p.Nesto},{p.Bla}");
DB ef = new DB();
ef.Probas.Add(p);
ef.SaveChanges();
Clients.Caller.SendAsync("saServera", ef.Probas.ToList());
}
/*
* REPO PROBA
*/
public Proba SaveProba(int id, float distanta, String stil)
{
lock (this)
{
Proba p = new Proba(id, distanta, (Stiluri)Enum.Parse(typeof(Stiluri), stil));
validatorProba.Validate(p);
return(repoProba.Save(p));
}
}
public ActionResult Edit([Bind(Include = "Id,Prob")] Proba proba)
{
if (ModelState.IsValid)
{
db.Entry(proba).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(proba));
}
public ActionResult Create([Bind(Include = "Id,Prob")] Proba proba)
{
if (ModelState.IsValid)
{
db.Probe.Add(proba);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(proba));
}
/// <summary>
/// Afiseaza scorurile in tabel
/// </summary>
private void showScoruriForProba()
{
Proba proba = (Proba)comboBoxProbe.SelectedItem;
ScorRepository scorRepository = new ScorRepository();
ScorService scorService = new ScorService(scorRepository);
scorController = new ScorController(scorService);
List <Scor> listaScoruri = scorController.getScoruriFromProba(proba);
var bindingList = new BindingList <Scor>(listaScoruri);
var source = new BindingSource(bindingList, null);
dataGridViewParticipantiScoruri.DataSource = source;
}
// GET: Proba/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Proba proba = db.Probe.Find(id);
if (proba == null)
{
return(HttpNotFound());
}
return(View(proba));
}
/// <summary>
/// Adauga nota pentru un participant
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonAddNota_Click(object sender, EventArgs e)
{
int nota = Convert.ToInt32(textBoxNota.Text);
Participant participant = (Participant)comboBoxParticipanti.SelectedItem;
Console.Write(participant);
ScorRepository scorRepository = new ScorRepository();
ScorService scorService = new ScorService(scorRepository);
scorController = new ScorController(scorService);
Proba proba = selectedProba;
Scor scor = new Scor(participant, proba, nota);
scorController.save(scor);
showTableNrTotalPuncte();
}
private void Form2_Load(object sender, EventArgs e)
{
UserRepository userRepository = new UserRepository();
LoginService loginService = new LoginService(userRepository);
loginController = new LoginController(loginService);
arbitru = loginController.findByUsername(Form1.username);
fillProbeComboBox();
selectedProba = probaController.findAllForArbitru(arbitru)[0];
showParticipantiFaraNotaLaProba();
showTableNrTotalPuncte();
fillProbeCombo();
}
public IList <ParticipantDTO> CautaParticipantiByProba(int idPr)
{
Proba proba = probaRepository.FindOne(idPr);
IList <ParticipantDTO> participantDTOs = new List <ParticipantDTO>();
var ids = inscriereRepository.FindParticipantByProba(proba.ID);
foreach (int id in ids)
{
Participant participant = participantRepository.FindOne(id);
var idProbe = inscriereRepository.FindProbaByParticipant(id);
IList <Proba> probe = new List <Proba>();
foreach (var idProba in idProbe)
{
Proba findProba = probaRepository.FindOne(idProba);
probe.Add(findProba);
}
ParticipantDTO dto = new ParticipantDTO(participant, probe);
participantDTOs.Add(dto);
}
return(participantDTOs);
}
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 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 IList <ParticipantDTO> FindAllParticipantByProba(Proba proba)
{
return(service.CautaParticipantiByProba(proba.ID));
}
public List <Scor> getScoruriFromProba(Proba proba)
{
return(scorRepository.getScoresFromProba(proba));
}
public List <Participant> getParticipantWithNoScoreForProba(Proba proba)
{
return(participantService.getParticipantWithNoScoreForProba(proba));
}
public IList <ParticipantDTO> FindAllParticipantByProba(Proba proba)
{
return(server.FindAllParticipantByProba(proba));
}
public Proba Delete(Proba elem)
{
throw new NotImplementedException();
}
public List <Scor> getScoruriFromProba(Proba proba)
{
return(scorService.getScoruriFromProba(proba));
}
public int NumarParticipantiProba(Proba p)
{
throw new NotImplementedException();
}
public List <Participant> getParticipantWithNoScoreForProba(Proba proba)
{
return(participantRepository.getParticipantWithNoScoreForProba(proba));
}
