public void initComptes()
{
CritereRechercheCompte crtRechercheCompte = new CritereRechercheCompte();
crtRechercheCompte.IdClient = client.IdClient;
dgvLstComptes.DataSource = BSGestionClient.RechercherComptes(crtRechercheCompte);
}
private bool initCritereRecherche()
{
crtRechercheCompte = new CritereRechercheCompte();
if (!string.IsNullOrEmpty(txtIdClient.Text))
{
try
{
crtRechercheCompte.IdClient = long.Parse(txtIdClient.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id client valide", "Id client non valide");
return(false);
}
}
if (!string.IsNullOrEmpty(txtIdCompte.Text))
{
try
{
crtRechercheCompte.IdCompte = long.Parse(txtIdCompte.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id compte valide", "Id compte non valide");
return(false);
}
}
if (cb_type.SelectedIndex > 0)
{
crtRechercheCompte.TypeCompte = (string)cb_type.SelectedItem;
}
switch (cbDateOuverture.SelectedIndex)
{
case 0: break;
case 1:
crtRechercheCompte.DateOuvertureDebut = dtDateOuvertureDebut.Value;
crtRechercheCompte.DateOuvertureFin = dtDateOuvertureDebut.Value;
break;
case 2:
crtRechercheCompte.DateOuvertureDebut = dtDateOuvertureDebut.Value;
break;
case 3:
crtRechercheCompte.DateOuvertureFin = dtDateOuvertureFin.Value;
break;
case 4:
crtRechercheCompte.DateOuvertureDebut = dtDateOuvertureDebut.Value;
crtRechercheCompte.DateOuvertureFin = dtDateOuvertureFin.Value;
break;
}
return(true);
}
public static DataTable getDataTable(CritereRechercheCompte criteres)
{
IDataReader reader = get(criteres);
DataTable dt = new DataTable();
if (reader != null)
{
dt.Load(reader);
reader.Close();
}
return(dt);
}
private static IDataReader get(CritereRechercheCompte criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "TYPE_COMPTE", criteres.TypeCompte, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OUVERTURE", criteres.DateOuvertureFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OUVERTURE", criteres.DateOuvertureDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
