bool IntfDalParamVehicule.upDateParamVehicule(crlParamVehicule paramVehicule) { #region declaration bool isUpdate = false; int nombreUpdate = 0; #endregion #region implementation if (paramVehicule != null) { this.strCommande = "UPDATE `paramvehicule` SET `nbPassagerMin`='" + paramVehicule.NbPassagerMin + "',"; this.strCommande += " `avanceCarburantMax`='" + paramVehicule.AvanceCarburantMax + "', `avanceChauffeurMax`='" + paramVehicule.AvanceChauffeurMax + "',"; this.strCommande += " `poidBagageMax`='" + paramVehicule.PoidBagageMax + "',`fond`='" + paramVehicule.Fond + "'"; this.strCommande += " WHERE `numParamVehicule`='" + paramVehicule.NumParamVehicule + "'"; this.serviceConnection.openConnection(); nombreUpdate = this.serviceConnection.requete(this.strCommande); if (nombreUpdate == 1) { isUpdate = true; } this.serviceConnection.closeConnection(); } #endregion return(isUpdate); }
string IntfDalParamVehicule.insertParamVehicule(crlParamVehicule paramVehicule, string sigleAgence) { #region declaration string numParamVehicule = ""; IntfDalParamVehicule serviceParamVehicule = new ImplDalParamVehicule(); int nombreInsert = 0; #endregion #region implementation if (paramVehicule != null) { if (sigleAgence != "") { paramVehicule.NumParamVehicule = serviceParamVehicule.getNumParamVehicule(sigleAgence); this.strCommande = "INSERT INTO `paramvehicule` (`numParamVehicule`,`nbPassagerMin`,`avanceCarburantMax`,"; this.strCommande += " `avanceChauffeurMax`,`poidBagageMax`,`fond`) VALUES"; this.strCommande += " ('" + paramVehicule.NumParamVehicule + "', " + paramVehicule.NbPassagerMin + ","; this.strCommande += " '" + paramVehicule.AvanceCarburantMax + "','" + paramVehicule.AvanceChauffeurMax + "',"; this.strCommande += " '" + paramVehicule.PoidBagageMax + "','" + paramVehicule.Fond + "')"; this.serviceConnection.openConnection(); nombreInsert = this.serviceConnection.requete(this.strCommande); if (nombreInsert == 1) { numParamVehicule = paramVehicule.NumParamVehicule; } this.serviceConnection.closeConnection(); } } #endregion return(numParamVehicule); }
crlParamVehicule IntfDalParamVehicule.selectParamVehicule(string numParamVehicule) { #region declaration crlParamVehicule paramVehicule = null; #endregion #region implementation if (numParamVehicule != "") { this.strCommande = "SELECT * FROM `paramvehicule` WHERE (`numParamVehicule`='" + numParamVehicule + "')"; this.serviceConnection.openConnection(); this.reader = this.serviceConnection.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { paramVehicule = new crlParamVehicule(); if (this.reader.Read()) { paramVehicule.NumParamVehicule = this.reader["numParamVehicule"].ToString(); try { paramVehicule.NbPassagerMin = int.Parse(this.reader["nbPassagerMin"].ToString()); } catch (Exception) { } try { paramVehicule.AvanceCarburantMax = double.Parse(this.reader["avanceCarburantMax"].ToString()); } catch (Exception) { } try { paramVehicule.AvanceChauffeurMax = double.Parse(this.reader["avanceChauffeurMax"].ToString()); } catch (Exception) { } try { paramVehicule.PoidBagageMax = double.Parse(this.reader["poidBagageMax"].ToString()); } catch (Exception) { } try { paramVehicule.Fond = double.Parse(this.reader["fond"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnection.closeConnection(); } #endregion return(paramVehicule); }