private static Soci selectSociPerId(int idS) { Soci s = null; using (MySqlConnection connexio = MySQL.GetConnexio()) { connexio.Open(); using (MySqlCommand consulta = connexio.CreateCommand()) { consulta.CommandText = @"select * from soci s where s.Id = @sId"; UtilsDB.AddParameter(consulta, "sId", idS, MySqlDbType.Int32); MySqlDataReader reader = consulta.ExecuteReader(); while (reader.Read()) { Int32 id = reader.GetInt32(reader.GetOrdinal("id")); string nif = reader.GetString(reader.GetOrdinal("nif")); string nom = reader.GetString(reader.GetOrdinal("nom")); string cognom1 = reader.GetString(reader.GetOrdinal("cognom1")); string cognom2 = reader.GetString(reader.GetOrdinal("cognom2")); DateTime dataAlta = reader.GetDateTime(reader.GetOrdinal("data_alta")); string passwordHash = reader.GetString(reader.GetOrdinal("password_hash")); Int32 actiu = reader.GetInt32(reader.GetOrdinal("actiu")); s = new Soci(id, nif, nom, cognom1, cognom2, dataAlta, passwordHash, actiu); } } } return(s); }
public HttpResponseMessage PostSoci([FromBody] Soci val) { var resposta = GimnasRepository.InsertSoci(val); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, resposta); return(response); }
public SociDAO(Soci a) { this.Id = a.Id; this.nom = a.nom; this.cognoms = a.cognoms; this.dni = a.dni; this.correu = a.correu; this.naixement = a.naixement; }
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); }