public List <Membre> getMembres(string sSexe, int age, int poids, int deltaAge, int deltaPoids, string lstClub, string lstDone)
{
openBase();
int AgeMax = age + deltaAge;
int poidsMax = poids + deltaPoids;
if (lstDone.EndsWith(","))
{
lstDone = lstDone.Substring(0, lstDone.Length - 1);
}
string sql = "SELECT mem_id, mem_nom, mem_prenom, mem_sexe, mem_age, mem_poids, mem_club FROM membre WHERE mem_sexe = '" + sSexe
+ "' AND mem_age >= " + age + " AND mem_age <= " + AgeMax
+ " AND mem_poids >= " + poids + " AND mem_poids <= " + poidsMax
+ " AND MEM_POULE is null AND mem_id not in (" + lstDone + ")" + " AND mem_club not in (" + lstClub + ")";
logger.Info("getMembre: requête = " + sql);
List <Membre> lstMembre = new List <Membre>();
using (SQLiteCommand cmd = new SQLiteCommand(sql, _dbConnection))
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Categorie.Sexe sexe = reader.GetString(3) == "F" ? Categorie.Sexe.FEMALE : Categorie.Sexe.MALE;
Membre membre = new Membre((int)reader.GetInt16(0),
reader.GetString(1),
reader.GetString(2),
sexe,
(int)reader.GetInt16(4),
(int)reader.GetInt16(5),
(int)reader.GetInt16(6));
lstMembre.Add(membre);
}
}
}
closeBase();
return(lstMembre);
}
public Boolean updateMembre(Membre membre)
{
openBase();
string sql = "UPDATE membre SET mem_nom = '" + membre.getNom() + "', mem_prenom = '" + membre.getPrenom()
+ "', mem_sexe = '" + membre.getSexe() + "', mem_age = " + membre.getAge().ToString()
+ ", mem_poids = " + membre.getPoids().ToString() + ", mem_club = " + membre.getClub() + ", mem_modification = DATETIME('NOW')"
+ " WHERE mem_id = " + membre.getId();
logger.Info("updateMembre: requête = " + sql);
using (SQLiteCommand cmd = new SQLiteCommand(sql, _dbConnection))
{
cmd.ExecuteNonQuery();
}
closeBase();
return(true);
}
public List <Membre> getMembres(int pouleId)
{
openBase();
string sql = "SELECT mem_id, mem_nom, mem_prenom, mem_sexe, mem_age, mem_poids, mem_club FROM membre "
+ "WHERE mem_poule = " + pouleId
+ " ORDER BY mem_sexe, mem_age, mem_poids";
logger.Info("getMembres: requête = " + sql);
List <Membre> lstMembre = new List <Membre>();
using (SQLiteCommand cmd = new SQLiteCommand(sql, _dbConnection))
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Categorie.Sexe sexe = reader.GetString(3) == "F" ? Categorie.Sexe.FEMALE : Categorie.Sexe.MALE;
Membre membre = new Membre((int)reader.GetInt16(0),
reader.GetString(1),
reader.GetString(2),
sexe,
(int)reader.GetInt16(4),
(int)reader.GetInt16(5),
(int)reader.GetInt16(6));
lstMembre.Add(membre);
}
}
}
closeBase();
return(lstMembre);
}
