string IntfDalVerification.insertVerification(crlVerification Verification, string sigleAgence) { #region declaration int nombreInsertion = 0; string idVerification = ""; IntfDalVerification serviceVerification = new ImplDalVerification(); #endregion #region implementation if (Verification != null) { Verification.IdVerification = serviceVerification.getIdVerification(sigleAgence); this.strCommande = "INSERT INTO `verification` (`idVerification`,`numLicence`,`idItineraire`,"; this.strCommande += " `idChauffeur`,`matriculeAgent`,`verificationTechnique`,`aVoireVT`,`verificationPapier`,`aVoireVP`,`dateVerification`,`planDepart`) "; this.strCommande += " VALUES ('" + Verification.IdVerification + "','" + Verification.NumLicence + "','" + Verification.IdItineraire + "'"; this.strCommande += " ,'" + Verification.IdChauffeur + "','" + Verification.MatriculeAgent + "'"; this.strCommande += " ,'" + Verification.VerificationTechnique + "', '" + Verification.AVoireVT + "'"; this.strCommande += " ,'" + Verification.VerificationPapier + "', '" + Verification.AVoireVP + "', '" + Verification.DateVerification.ToString("yyyy-MM-dd") + "','" + Verification.PlanDepart + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { idVerification = Verification.IdVerification; } this.serviceConnectBase.closeConnection(); } #endregion return(idVerification); }
void IntfDalVerification.insertToGridVerificationNonValider(GridView gridView, string param, string paramLike, string valueLike) { #region declaration IntfDalVerification serviceVerification = new ImplDalVerification(); #endregion #region implementation this.strCommande = "SELECT chauffeur.idChauffeur, chauffeur.nomChauffeur, chauffeur.prenomChauffeur,"; this.strCommande += " chauffeur.cinChauffeur, chauffeur.adresseChauffeur, chauffeur.telephoneChauffeur,"; this.strCommande += " chauffeur.telephoneMobileChauffeur, chauffeur.imageChauffeur, chauffeur.numCooperative,"; this.strCommande += " chauffeur.situationFamilialeChauffeur, chauffeur.dateNaissanceChauffeur, verification.dateVerification,"; this.strCommande += " chauffeur.lieuNaissanceChauffeur, verification.idVerification, vehicule.numVehicule,"; this.strCommande += " vehicule.numParamVehicule, vehicule.sourceEnergie, vehicule.numProprietaire,"; this.strCommande += " vehicule.matriculeVehicule, vehicule.marqueVehicule, vehicule.typeVehicule,"; this.strCommande += " vehicule.numSerieVehicule, vehicule.numMoteurVehicule, vehicule.puissanceVehicule,"; this.strCommande += " vehicule.couleurVehicule, vehicule.placesAssiseVehicule, vehicule.nombreColoneVehicule,"; this.strCommande += " vehicule.poidsTotalVehicule, vehicule.poidsVideVehicule, vehicule.imageVehicule,"; this.strCommande += " itineraire.numVilleItineraireDebut, itineraire.numVilleItineraireFin FROM verification"; this.strCommande += " Inner Join chauffeur ON chauffeur.idChauffeur = verification.idChauffeur"; this.strCommande += " Inner Join licence ON licence.numLicence = verification.numLicence"; this.strCommande += " Inner Join vehicule ON vehicule.numVehicule = licence.numVehicule"; this.strCommande += " Left Join autorisationvoyage ON autorisationvoyage.idVerification = verification.idVerification"; this.strCommande += " Inner Join itineraire ON itineraire.idItineraire = verification.idItineraire"; this.strCommande += " WHERE autorisationvoyage.idVerification IS NULL AND"; this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')"; this.strCommande += " ORDER BY " + param + " DESC"; gridView.DataSource = serviceVerification.getDataTableVerificationNonValider(this.strCommande); gridView.DataBind(); #endregion }
crlAutorisationVoyage IntfAutorisationVoyage.selectAutorisationVoyage(string numerosAV) { #region declaration IntfDalAgent serviceAgent = new ImplDalAgent(); IntfDalVerification serviceVerification = new ImplDalVerification(); crlAutorisationVoyage AutorisationVoyage = null; #endregion #region implementation if (numerosAV != "") { this.strCommande = "SELECT * FROM `autorisationvoyage` WHERE (`numerosAV`='" + numerosAV + "')"; this.serviceConnectBase.openConnection(); reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { AutorisationVoyage = new crlAutorisationVoyage(); AutorisationVoyage.NumerosAV = reader["numerosAV"].ToString(); AutorisationVoyage.MatriculeAgent = reader["matriculeAgent"].ToString(); AutorisationVoyage.IdVerification = reader["idVerification"].ToString(); AutorisationVoyage.DatePrevueDepart = Convert.ToDateTime(reader["datePrevueDepart"].ToString()); } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (AutorisationVoyage != null) { AutorisationVoyage.Verification = serviceVerification.selectVerification(AutorisationVoyage.IdVerification); AutorisationVoyage.Agent = serviceAgent.selectAgent(AutorisationVoyage.MatriculeAgent); } } #endregion return(AutorisationVoyage); }