public void initContrats()
{
CritereRechercheContrat crtRechercheContrat = new CritereRechercheContrat();
crtRechercheContrat.IdClient = client.IdClient;
dgvLstContrats.DataSource = BSGestionClient.RechercherContrats(crtRechercheContrat);
}
public static DataTable getDataTable(CritereRechercheContrat criteres)
{
IDataReader reader = get(criteres);
DataTable dt = new DataTable();
if (reader != null)
{
dt.Load(reader);
reader.Close();
}
return(dt);
}
private static IDataReader get(CritereRechercheContrat criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "INTITULE", criteres.Intitule, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "TYPE", criteres.Type, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_SOUS", criteres.DateSouscriptionFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_SOUS", criteres.DateSouscriptionDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CONTRAT", criteres.IdContrat, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_PRODUIT", criteres.IdProduit, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private bool initCritereRecherche()
{
crtRechercheContrat = new CritereRechercheContrat();
if (!string.IsNullOrEmpty(txtIdClient.Text))
{
try
{
crtRechercheContrat.IdClient = long.Parse(txtIdClient.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id client valide", "Id client non valide");
return(false);
}
}
if (!string.IsNullOrEmpty(txtId.Text))
{
try
{
crtRechercheContrat.IdContrat = long.Parse(txtId.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id contrat valide", "Id contrat non valide");
return(false);
}
}
if (!string.IsNullOrEmpty(txtIdCompte.Text))
{
try
{
crtRechercheContrat.IdCompte = long.Parse(txtIdCompte.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id compte valide", "Id compte non valide");
return(false);
}
}
if (!string.IsNullOrEmpty(txtIdProduit.Text))
{
try
{
crtRechercheContrat.IdProduit = long.Parse(txtIdProduit.Text);
}
catch
{
Utilities.showErrorMessage("Veuillez saisir un id produit valide", "Id produit non valide");
return(false);
}
}
crtRechercheContrat.Intitule = txtIntitule.Text;
if (cb_type.SelectedIndex > 0)
{
crtRechercheContrat.Type = (string)cb_type.SelectedItem;
}
switch (cbDateSouscription.SelectedIndex)
{
case 0: break;
case 1:
crtRechercheContrat.DateSouscriptionDebut = dtDateSouscriptionDebut.Value;
crtRechercheContrat.DateSouscriptionFin = dtDateSouscriptionDebut.Value;
break;
case 2:
crtRechercheContrat.DateSouscriptionDebut = dtDateSouscriptionDebut.Value;
break;
case 3:
crtRechercheContrat.DateSouscriptionFin = dtDateSouscriptionFin.Value;
break;
case 4:
crtRechercheContrat.DateSouscriptionDebut = dtDateSouscriptionDebut.Value;
crtRechercheContrat.DateSouscriptionFin = dtDateSouscriptionFin.Value;
break;
}
return(true);
}
