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)); }