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); }
crlVehicule IntfDalVehicule.selectVehicule(string numVehicule) { #region declaration crlVehicule vehicule = null; IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); IntfDalSourceEnergie serviceSourceEnergie = new ImplDalSourceEnergie(); IntfDalParamVehicule serviceParamVehicule = new ImplDalParamVehicule(); #endregion #region implementation if (numVehicule != "") { this.strCommande = "SELECT * FROM `vehicule` WHERE (`numVehicule`='" + numVehicule + "')"; this.serviceConnection.openConnection(); if (this.serviceConnection.IsConnection) { this.reader = this.serviceConnection.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { vehicule = new crlVehicule(); vehicule.MarqueVehicule = this.reader["marqueVehicule"].ToString(); vehicule.NumParamVehicule = this.reader["numParamVehicule"].ToString(); vehicule.MatriculeVehicule = this.reader["matriculeVehicule"].ToString(); try { vehicule.NombreColoneVehicule = int.Parse(this.reader["nombreColoneVehicule"].ToString()); } catch (Exception) { } vehicule.NumMoteurVehicule = this.reader["numMoteurVehicule"].ToString(); vehicule.NumProprietaire = this.reader["numProprietaire"].ToString(); vehicule.NumSerieVehicule = this.reader["numSerieVehicule"].ToString(); vehicule.NumVehicule = this.reader["numVehicule"].ToString(); vehicule.CouleurVehicule = this.reader["couleurVehicule"].ToString(); try { vehicule.PlacesAssiseVehicule = int.Parse(this.reader["placesAssiseVehicule"].ToString()); } catch (Exception) { } try { vehicule.PoidsTotalVehicule = double.Parse(this.reader["poidsTotalVehicule"].ToString()); } catch (Exception) { } try { vehicule.PoidsVideVehicule = double.Parse(this.reader["poidsVideVehicule"].ToString()); } catch (Exception) { } vehicule.PuissanceVehicule = this.reader["puissanceVehicule"].ToString(); vehicule.SourceEnergie = this.reader["sourceEnergie"].ToString(); vehicule.TypeVehicule = this.reader["typeVehicule"].ToString(); vehicule.ImageVehicule = this.reader["imageVehicule"].ToString(); } } this.reader.Dispose(); } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } if (vehicule != null) { if (vehicule.SourceEnergie != "") { vehicule.sourceEnergieObj = serviceSourceEnergie.selectSourceEnergie(vehicule.SourceEnergie); } if (vehicule.NumProprietaire != "") { vehicule.proprietaire = serviceProprietaire.selectProprietaire(vehicule.NumProprietaire); } if (vehicule.NumParamVehicule != "") { vehicule.paramVehicule = serviceParamVehicule.selectParamVehicule(vehicule.NumParamVehicule); } } } #endregion return(vehicule); }