bool IntfDalInfoPrixCommission.deleteInfoPrixCommission(crlInfoPrixCommission InfoPrixCommission) { #region declaration bool isDelete = false; int nombreDelete = 0; #endregion #region implementation if (InfoPrixCommission != null) { if (InfoPrixCommission.NumInfoPrixCommission != "") { this.strCommande = "DELETE FROM `infoprixcommission` WHERE (`numInfoPrixCommission` = '" + InfoPrixCommission.NumInfoPrixCommission + "')"; this.serviceConnectBase.openConnection(); nombreDelete = this.serviceConnectBase.requete(this.strCommande); if (nombreDelete == 1) { isDelete = true; } this.serviceConnectBase.closeConnection(); } } #endregion return(isDelete); }
string IntfDalInfoPrixCommission.insertInfoPrixCommission(crlInfoPrixCommission InfoPrixCommission, string sigleAgence) { #region declaration IntfDalInfoPrixCommission serviceInfoPrixCommission = new ImplDalInfoPrixCommission(); int nombreInsertion = 0; string numInfoPrixCommission = ""; #endregion #region implementation if (InfoPrixCommission != null) { InfoPrixCommission.NumInfoPrixCommission = serviceInfoPrixCommission.getNumInfoPrixCommission(sigleAgence); this.strCommande = "INSERT INTO `infoprixcommission` (`numInfoPrixCommission`,`prix`,`paiement`)"; this.strCommande += " VALUES ('" + InfoPrixCommission.NumInfoPrixCommission + "', '" + InfoPrixCommission.Prix + "', "; this.strCommande += " '" + InfoPrixCommission.Paiement + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numInfoPrixCommission = InfoPrixCommission.NumInfoPrixCommission; } this.serviceConnectBase.closeConnection(); } #endregion return(numInfoPrixCommission); }
crlInfoPrixCommission IntfDalInfoPrixCommission.selectInfoPrixCommissionPaiement(string paiement) { #region declaration crlInfoPrixCommission InfoPrixCommission = null; #endregion #region implementation if (paiement != "") { this.strCommande = "SELECT * FROM `infoprixcommission` WHERE (`paiement`='" + paiement + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { InfoPrixCommission = new crlInfoPrixCommission(); reader.Read(); InfoPrixCommission.NumInfoPrixCommission = reader["numInfoPrixCommission"].ToString(); InfoPrixCommission.Paiement = int.Parse(reader["paiement"].ToString()); InfoPrixCommission.Prix = reader["prix"].ToString(); } reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(InfoPrixCommission); }
string IntfDalInfoPrixCommission.isInfoPrixCommission(crlInfoPrixCommission InfoPrixCommission) { #region initialisation string numInfoPrixCommission = ""; #endregion #region implementation if (InfoPrixCommission != null) { this.strCommande = "SELECT * FROM `infoprixcommission` WHERE (`numInfoPrixCommission`<>'" + InfoPrixCommission.NumInfoPrixCommission + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { if (InfoPrixCommission.Paiement == int.Parse(reader["paiement"].ToString()) && InfoPrixCommission.Prix.Trim().ToLower().Equals(reader["prix"].ToString().Trim().ToLower())) { numInfoPrixCommission = reader["numInfoPrixCommission"].ToString(); break; } } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(numInfoPrixCommission); }
bool IntfDalInfoPrixCommission.updateInfoPrixCommission(crlInfoPrixCommission InfoPrixCommission) { #region declaration bool isUpdate = false; int nombreUpdate = 0; #endregion #region implementation if (InfoPrixCommission != null) { if (InfoPrixCommission.NumInfoPrixCommission != "") { this.strCommande = "UPDATE `infoprixcommission` SET `prix`='" + InfoPrixCommission.Prix + "', "; this.strCommande += "`paiement`='" + InfoPrixCommission.Paiement + "' "; this.strCommande += "WHERE (`numInfoPrixCommission`='" + InfoPrixCommission.NumInfoPrixCommission + "')"; this.serviceConnectBase.openConnection(); nombreUpdate = this.serviceConnectBase.requete(this.strCommande); if (nombreUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } } #endregion return(isUpdate); }
List <crlInfoPrixCommission> IntfDalInfoPrixCommission.selectInfoPrixCommissions(string idItineraire) { #region declaration List <crlInfoPrixCommission> InfoPrixCommissions = null; crlInfoPrixCommission tempInfoPrixCommission = null; #endregion #region implementation if (idItineraire != "") { this.strCommande = "SELECT infoprixcommission.numInfoPrixCommission, infoprixcommission.prix,"; this.strCommande += " infoprixcommission.paiement FROM infoprixcommission"; this.strCommande += " Inner Join associationitineraireinfoprixcommission ON associationitineraireinfoprixcommission.numInfoPrixCommission = infoprixcommission.numInfoPrixCommission"; this.strCommande += " WHERE associationitineraireinfoprixcommission.idItineraire = '" + idItineraire + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { InfoPrixCommissions = new List <crlInfoPrixCommission>(); while (reader.Read()) { tempInfoPrixCommission = new crlInfoPrixCommission(); tempInfoPrixCommission.NumInfoPrixCommission = reader["numInfoPrixCommission"].ToString(); tempInfoPrixCommission.Paiement = int.Parse(reader["paiement"].ToString()); tempInfoPrixCommission.Prix = reader["prix"].ToString(); InfoPrixCommissions.Add(tempInfoPrixCommission); } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(InfoPrixCommissions); }