string IntfDalUSReductionParticulier.isUSReductionParticulier(crlUSReductionParticulier reductionParticulier)
{
#region declaration
string numUSReductionParticulier = "";
#endregion
#region implementation
if (reductionParticulier != null)
{
this.strCommande = "SELECT usreductionparticulier.numUSReductionParticulier FROM `usreductionparticulier` WHERE";
this.strCommande += " usreductionparticulier.numIndividu = '" + reductionParticulier.NumIndividu + "' AND";
this.strCommande += " usreductionparticulier.numUSReductionParticulier <> '" + reductionParticulier.NumUSReductionParticulier + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numUSReductionParticulier = this.reader["numUSReductionParticulier"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numUSReductionParticulier);
}
crlUSReductionParticulier IntfDalUSReductionParticulier.selectUSReductionParticulier(string numUSReductionParticulier)
{
#region declaration
crlUSReductionParticulier reductionParticulier = null;
IntfDalIndividu serviceIndividu = new ImplDalIndividu();
IntfDalUSCategorieBillet serviceUSCategorieBillet = new ImplDalUSCategorieBillet();
#endregion
#region implementation
if (numUSReductionParticulier != "")
{
this.strCommande = "SELECT * FROM `usreductionparticulier` WHERE";
this.strCommande += " usreductionparticulier.numUSReductionParticulier = '" + numUSReductionParticulier + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
reductionParticulier = new crlUSReductionParticulier();
reductionParticulier.NumCategorieBillet = this.reader["numCategorieBillet"].ToString();
reductionParticulier.NumIndividu = this.reader["numIndividu"].ToString();
reductionParticulier.NumEtablissementScolaire = this.reader["numEtablissementScolaire"].ToString();
reductionParticulier.NumSociete = this.reader["numSociete"].ToString();
reductionParticulier.NumUSReductionParticulier = this.reader["numUSReductionParticulier"].ToString();
reductionParticulier.ImageReductionParticulier = this.reader["imageReductionParticulier"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (reductionParticulier != null)
{
if (reductionParticulier.NumIndividu != "")
{
reductionParticulier.individu = serviceIndividu.selectIndividu(reductionParticulier.NumIndividu);
}
if (reductionParticulier.NumCategorieBillet != "")
{
reductionParticulier.categorieBillet = serviceUSCategorieBillet.selectUSCategorieBillet(reductionParticulier.NumCategorieBillet);
}
}
}
#endregion
return(reductionParticulier);
}
string IntfDalUSReductionParticulier.insertUSReductionParticulier(crlUSReductionParticulier reductionParticulier, string sigleAgence)
{
#region declaration
int nbInsert = 0;
string numUSReductionParticulier = "";
string numEtablissementScolaire = "NULL";
string numSociete = "NULL";
IntfDalUSReductionParticulier serviceUSReductionParticulier = new ImplDalUSReductionParticulier();
#endregion
#region implementation
if (reductionParticulier != null)
{
if (reductionParticulier.NumEtablissementScolaire != "")
{
numEtablissementScolaire = "'" + reductionParticulier.NumEtablissementScolaire + "'";
}
if (reductionParticulier.NumSociete != "")
{
numSociete = "'" + reductionParticulier.NumSociete + "'";
}
reductionParticulier.NumUSReductionParticulier = serviceUSReductionParticulier.getNumUSReductionParticulier(sigleAgence);
this.strCommande = "INSERT INTO `usreductionparticulier` (`numUSReductionParticulier`,`numIndividu`,";
this.strCommande += " `numEtablissementScolaire`,`numSociete`,`numCategorieBillet`,";
this.strCommande += " `imageReductionParticulier`) VALUES ('" + reductionParticulier.NumUSReductionParticulier + "',";
this.strCommande += " '" + reductionParticulier.NumIndividu + "'," + numEtablissementScolaire + ",";
this.strCommande += " " + numSociete + ",'" + reductionParticulier.NumCategorieBillet + "',";
this.strCommande += " '" + reductionParticulier.ImageReductionParticulier + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numUSReductionParticulier = reductionParticulier.NumUSReductionParticulier;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numUSReductionParticulier);
}
bool IntfDalUSReductionParticulier.updateUSReductionParticulier(crlUSReductionParticulier reductionParticulier)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
string numEtablissementScolaire = "NULL";
string numSociete = "NULL";
#endregion
#region implementation
if (reductionParticulier != null)
{
if (reductionParticulier.NumEtablissementScolaire != "")
{
numEtablissementScolaire = "'" + reductionParticulier.NumEtablissementScolaire + "'";
}
if (reductionParticulier.NumSociete != "")
{
numSociete = "'" + reductionParticulier.NumSociete + "'";
}
this.strCommande = "UPDATE `usreductionparticulier` SET `numIndividu`='" + reductionParticulier.NumIndividu + "',";
this.strCommande += " `numEtablissementScolaire`=" + numEtablissementScolaire + ",";
this.strCommande += " `numSociete`=" + numSociete + ",`numCategorieBillet`='" + reductionParticulier.NumCategorieBillet + "',";
this.strCommande += " `imageReductionParticulier`='" + reductionParticulier.ImageReductionParticulier + "'";
this.strCommande += " WHERE `numUSReductionParticulier`='" + reductionParticulier.NumUSReductionParticulier + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
