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