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 = "";
//}
}
