internal static void updateInscritEnUnGrup(Inscrit i, Grup g) { using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); MySqlTransaction trans = connexio.BeginTransaction(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.Transaction = trans; consulta.CommandText = @"update inscrit set grup_num = @grupNum where soci_id = @idSoci and torneig_id = @idTorneig"; UtilsDB.AddParameter(consulta, "grupNum", g.Num, MySqlDbType.Int32); UtilsDB.AddParameter(consulta, "idTorneig", i.Torneig.Id, MySqlDbType.Int32); UtilsDB.AddParameter(consulta, "idSoci", i.Soci.Id, MySqlDbType.Int32); try { consulta.ExecuteNonQuery(); trans.Commit(); } catch (Exception e) { } } } }
//INSCRIT public Inscrit Inscrire(Etudiant etudiant, Cours cours) { var inscription = new Inscrit { Etudiant = etudiant, Cours = cours }; bdd.Inscrit.Add(inscription); bdd.SaveChanges(); return(inscription); }
public static ObservableCollection <Inscrit> selectInscritsDeUnTorneigIGrup(Int32 idTorneig, Grup g) { DateTime data; ObservableCollection <Inscrit> inscrits = new ObservableCollection <Inscrit>(); //--------------------------------- using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.CommandText = @"select inscrit.* from inscrit where inscrit.torneig_id = @idTorneig and inscrit.grup_num = @numGrup"; UtilsDB.AddParameter(consulta, "idTorneig", idTorneig, MySqlDbType.Int32); UtilsDB.AddParameter(consulta, "numGrup", g.Num, MySqlDbType.Int32); MySqlDataReader reader = consulta.ExecuteReader(); while (reader.Read()) { Inscrit i; Int32 idS = reader.GetInt32(reader.GetOrdinal("soci_id")); Int32 idT = reader.GetInt32(reader.GetOrdinal("torneig_id")); Int32 numG = -1; try { numG = reader.GetInt32(reader.GetOrdinal("grup_num")); } catch (Exception e) { } data = reader.GetDateTime(reader.GetOrdinal("data")); Soci s = TorneigBD.selectSociPerId(idS); Torneig t = TorneigBD.selectTorneigPerId(idT); if (numG != -1) { Grup gr = TorneigBD.selectGrupDeUnTorneigIUnGrup(idT, numG); i = new Inscrit(s, t, gr, data); inscrits.Add(i); } else { i = new Inscrit(s, t, null, data); inscrits.Add(i); } } } } return(inscrits); }
public static ObservableCollection <Inscrit> selectInscritsDeUnTorneig(Int32 idTorneig) { DateTime data; ObservableCollection <Inscrit> inscrits = new ObservableCollection <Inscrit>(); //--------------------------------- using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.CommandText = @"select inscrit.* from inscrit inner join soci on inscrit.soci_id = soci.id left join estadistica_modalitat on estadistica_modalitat.soci_id = soci.id where inscrit.torneig_id = @idTorneig and inscrit.grup_num is NULL and estadistica_modalitat.modalitat_id = 1 order by estadistica_modalitat.coeficient_base desc"; UtilsDB.AddParameter(consulta, "idTorneig", idTorneig, MySqlDbType.Int32); MySqlDataReader reader = consulta.ExecuteReader(); while (reader.Read()) { Inscrit i; Int32 idS = reader.GetInt32(reader.GetOrdinal("soci_id")); Int32 idT = reader.GetInt32(reader.GetOrdinal("torneig_id")); Int32 numG = -1; try { numG = reader.GetInt32(reader.GetOrdinal("grup_num")); } catch (Exception e) { } data = reader.GetDateTime(reader.GetOrdinal("data")); Soci s = TorneigBD.selectSociPerId(idS); Torneig t = TorneigBD.selectTorneigPerId(idT); if (numG != -1) { Grup g = TorneigBD.selectGrupDeUnTorneigIUnGrup(idT, numG); i = new Inscrit(s, t, g, data); inscrits.Add(i); } else { i = new Inscrit(s, t, null, data); inscrits.Add(i); } } } } return(inscrits); }
private void btnAfegirInscritAGrup_Click(object sender, RoutedEventArgs e) { Torneig t = (Torneig)lvTornejos.SelectedItem; if (lvGrupsDisponibles.SelectedItem == null || lvInscrits.SelectedItem == null) { DisplayError("Error", "Selecciona un inscrit i un grup"); } else { Grup g = (Grup)lvGrupsDisponibles.SelectedItem; Inscrit i = (Inscrit)lvInscrits.SelectedItem; TorneigBD.updateInscritEnUnGrup(i, g); lvInscrits.ItemsSource = TorneigBD.selectInscritsDeUnTorneig(t.Id); } }
public static float selectCoeficientDeUnInscrit(Inscrit i) { float coeficient = 0; using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.CommandText = @"select coeficient_base from estadistica_modalitat inner join soci on estadistica_modalitat.soci_id = soci.id left join inscrit on inscrit.soci_id = soci.id where estadistica_modalitat.modalitat_id = 1 and soci.id = @sociId"; UtilsDB.AddParameter(consulta, "sociId", i.Soci.Id, MySqlDbType.Int32); MySqlDataReader reader = consulta.ExecuteReader(); while (reader.Read()) { coeficient = reader.GetFloat(reader.GetOrdinal("coeficient_base")); } } } return(coeficient); }
internal static Int32 selectPartidesPerdudesDeUnInscrit(int idTorneig, int num, Inscrit inscrit) { Int32 contador = 0; using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.CommandText = @"select count(*) from partida where torneig_id = @idTorneig and grup_num = @numGrup and (inscrit_a = @idSoci and guanyador = 'B') or (inscrit_b = @idSoci and guanyador = 'A') and estat_partida = 'jugada'"; UtilsDB.AddParameter(consulta, "idTorneig", idTorneig, MySqlDbType.Int32); UtilsDB.AddParameter(consulta, "numGrup", num, MySqlDbType.Int32); UtilsDB.AddParameter(consulta, "idSoci", inscrit.Soci.Id, MySqlDbType.Int32); return((Int32)(long)consulta.ExecuteScalar()); } } }
private void AddGroup_Click(object sender, RoutedEventArgs e) { int caramboles = 0; int entrades = 0; string nom = ""; // CloseGroup.IsEnabled = false; try { if (!(String.IsNullOrEmpty(txtnom.Text.ToString()))) { nom = txtnom.Text.ToString(); } if (!(String.IsNullOrEmpty(txtcCaram.ToString()))) { caramboles = Int32.Parse(txtcCaram.Text.ToString()); } if (!(String.IsNullOrEmpty(txtEntrades.Text.ToString()))) { entrades = Int32.Parse(txtEntrades.Text.ToString()); } if (lvSInscrits.IndexItemSeleccionat != -1) { Socilist i = (Socilist)lvSInscrits.ObjecteSeleccionat; grupActual = con.getIdGrup(); if (primero == true) { { mismogrupo = grupActual; primero = false; int idPartida = 0; Grup gp = new Grup(grupActual, torneoActual, nom, caramboles, entrades, mismogrupo); torneoActual.Grups.Add(gp); con.AddGroup(gp.Id, gp.Torneig.Id, gp.Descripcio, gp.CaramVictoria, gp.LimitEntrades, mismogrupo, idPartida); GActual = gp; lvSInscrits.ItemsSource.Remove(i); } } lvSInscrits.ItemsSource.Remove(i); DateTime d = DateTime.Today.Date; Inscrit ins = new Inscrit(i.Id, GActual, torneoActual, d); con.AddInscrit(ins.Numero, mismogrupo, ins.Torneo.Id, ins.DataInscrp); // gp.Inscrits.Add(ins); GActual.addInscrit(ins); if (GActual.Inscrits.Count() > 1) { btnCloseTorneo.IsEnabled = true; } } } catch { //mensaje eerrooo } //private async void canviTextBlock() //{ // await System.Threading.Tasks.Task.Delay(2000); // tbErrorCita.Text = ""; //} }