public static DataTable getDataTable(CritereRechercheClient criteres)
{
IDataReader reader = get(criteres);
DataTable dt = new DataTable();
if (reader != null)
{
dt.Load(reader);
reader.Close();
}
return(dt);
}
private static IDataReader get(CritereRechercheClient criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "EMAIL", criteres.Email, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "NOM", criteres.Nom, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PRENOM", criteres.Prenom, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ADRESSE_PRINC", criteres.Adresse, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_NAISS", criteres.DateNaissanceFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_NAISS", criteres.DateNaissanceDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private bool initCritereRecherche()
{
crtRechercheClient = new CritereRechercheClient();
crtRechercheClient.Adresse = txtAdresse.Text;
crtRechercheClient.Email = txtEmail.Text;
if (!string.IsNullOrEmpty(txtId.Text))
{
try{
crtRechercheClient.IdClient = long.Parse(txtId.Text);
}
catch {
Utilities.showErrorMessage("L'ID n'a pas été saisi correctement", "Erreur");
return(false);
}
}
crtRechercheClient.Nom = txtNom.Text;
crtRechercheClient.Prenom = txtPrenom.Text;
switch (cbDateNaissance.SelectedIndex)
{
case 0: break;
case 1:
crtRechercheClient.DateNaissanceDebut = dtDateNaissanceDebut.Value;
crtRechercheClient.DateNaissanceFin = dtDateNaissanceDebut.Value;
break;
case 2:
crtRechercheClient.DateNaissanceDebut = dtDateNaissanceDebut.Value;
break;
case 3:
crtRechercheClient.DateNaissanceFin = dtDateNaissanceFin.Value;
break;
case 4:
crtRechercheClient.DateNaissanceDebut = dtDateNaissanceDebut.Value;
crtRechercheClient.DateNaissanceFin = dtDateNaissanceFin.Value;
break;
}
return(true);
}
