void IntfDalProprietaire.insertToGridRecu(GridView gridView, string param, string paramLike, string valueLike, string numProprietaire) { #region declaration IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); #endregion #region implementation this.strCommande = "SELECT (recuad.numRecuAD) AS numR, typeprelevement.commentaire, recuad.matriculeAgent,"; this.strCommande += " recuad.libele, recuad.montant, recuad.dateRecu FROM proprietaire"; this.strCommande += " Inner Join vehicule ON vehicule.numProprietaire = proprietaire.numProprietaire"; this.strCommande += " Inner Join licence ON licence.numVehicule = vehicule.numVehicule"; this.strCommande += " Inner Join verification ON verification.numLicence = licence.numLicence"; this.strCommande += " Inner Join autorisationvoyage ON autorisationvoyage.idVerification = verification.idVerification"; this.strCommande += " Inner Join fichebord ON fichebord.numerosAV = autorisationvoyage.numerosAV"; this.strCommande += " Inner Join autorisationdepart ON autorisationdepart.numerosFB = fichebord.numerosFB"; this.strCommande += " Inner Join prelevement ON prelevement.numAutorisationDepart = autorisationdepart.numAutorisationDepart"; this.strCommande += " Inner Join recuad ON recuad.numPrelevement = prelevement.numPrelevement"; this.strCommande += " Inner Join typeprelevement ON typeprelevement.typePrelevement = prelevement.typePrelevement"; this.strCommande += " WHERE autorisationdepart.resteRegle > 0 AND"; this.strCommande += " proprietaire.numProprietaire = '" + numProprietaire + "' AND"; this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')"; this.strCommande += " ORDER BY " + param + " ASC"; gridView.DataSource = serviceProprietaire.getDataTableRecu(this.strCommande); gridView.DataBind(); #endregion }
void IntfDalProprietaire.insertToGridListeVoyageVoitureProprietaire(GridView gridView, string param, string paramLike, string valueLike, string numProprietaire) { #region declaration IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); #endregion #region implementation this.strCommande = "SELECT vehicule.matriculeVehicule, chauffeur.nomChauffeur, chauffeur.prenomChauffeur,"; this.strCommande += " (autorisationdepart.numAutorisationDepart) AS numAD, vehicule.marqueVehicule, itineraire.numVilleItineraireDebut,"; this.strCommande += " itineraire.numVilleItineraireFin, (fichebord.numerosFB) AS numFB, proprietaire.numProprietaire,"; this.strCommande += " autorisationdepart.recetteTotale, autorisationdepart.resteRegle,"; this.strCommande += " fichebord.dateHeurDepart FROM proprietaire"; this.strCommande += " Inner Join vehicule ON vehicule.numProprietaire = proprietaire.numProprietaire"; this.strCommande += " Inner Join licence ON licence.numVehicule = vehicule.numVehicule"; this.strCommande += " Inner Join verification ON verification.numLicence = licence.numLicence"; this.strCommande += " Inner Join autorisationvoyage ON autorisationvoyage.idVerification = verification.idVerification"; this.strCommande += " Inner Join fichebord ON fichebord.numerosAV = autorisationvoyage.numerosAV"; this.strCommande += " Inner Join autorisationdepart ON autorisationdepart.numerosFB = fichebord.numerosFB"; this.strCommande += " Left Join assocautorisationdepartfacture ON assocautorisationdepartfacture.numAutorisationDepart = autorisationdepart.numAutorisationDepart"; this.strCommande += " Inner Join chauffeur ON chauffeur.idChauffeur = verification.idChauffeur"; this.strCommande += " Inner Join itineraire ON itineraire.idItineraire = verification.idItineraire"; this.strCommande += " WHERE assocautorisationdepartfacture.numAutorisationDepart IS NULL AND"; this.strCommande += " proprietaire.numProprietaire = '" + numProprietaire + "' AND"; this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')"; this.strCommande += " ORDER BY " + param + " ASC"; gridView.DataSource = serviceProprietaire.getDataTableVoyageVoitureProprietaire(this.strCommande); gridView.DataBind(); #endregion }
string IntfDalProprietaire.insertProprietaire(crlProprietaire proprietaire, string sigleAgence) { #region declaration string numProprietaire = ""; IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); int nombreInsert = 0; string numIndividu = ""; string numOrganisme = ""; string numSociete = ""; #endregion #region implementation if (proprietaire != null) { if (proprietaire.NumIndividu != "") { numIndividu = "'" + proprietaire.NumIndividu + "'"; } else { numIndividu = "NULL"; } if (proprietaire.NumOrganisme != "") { numOrganisme = "'" + proprietaire.NumOrganisme + "'"; } else { numOrganisme = "NULL"; } if (proprietaire.NumSociete != "") { numSociete = "'" + proprietaire.NumSociete + "'"; } else { numSociete = "NULL"; } proprietaire.NumProprietaire = serviceProprietaire.getNumProprietaire(sigleAgence); this.strCommande = "INSERT INTO `proprietaire` (`numProprietaire`,`typeProprietaire`,"; this.strCommande += " `numOrganisme`,`numSociete`,`numIndividu`,`numAgence`)"; this.strCommande += " VALUES ('" + proprietaire.NumProprietaire + "',"; this.strCommande += " '" + proprietaire.TypeProprietaire + "'," + numOrganisme + ","; this.strCommande += " " + numSociete + "," + numIndividu + ","; this.strCommande += " '" + proprietaire.NumAgence + "')"; this.serviceConnection.openConnection(); nombreInsert = this.serviceConnection.requete(this.strCommande); if (nombreInsert == 1) { numProprietaire = proprietaire.NumProprietaire; } this.serviceConnection.closeConnection(); } #endregion return(numProprietaire); }
void IntfDalProprietaire.insertToGridProprietaireAll(GridView gridView, string param, string paramLike, string valueLike, string numAgence) { #region declaration IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); #endregion #region implementation this.strCommande = "SELECT proprietaire.numProprietaire, proprietaire.typeProprietaire, proprietaire.numOrganisme,"; this.strCommande += " proprietaire.numSociete, proprietaire.numIndividu, proprietaire.numAgence FROM proprietaire"; this.strCommande += " Left Join organisme ON organisme.numOrganisme = proprietaire.numOrganisme"; this.strCommande += " Left Join societe ON societe.numSociete = proprietaire.numSociete"; this.strCommande += " Left Join Individu ON Individu.numIndividu = proprietaire.numIndividu"; this.strCommande += " WHERE proprietaire.numAgence = '" + numAgence + "' AND"; this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')"; this.strCommande += " ORDER BY " + param + " ASC"; gridView.DataSource = serviceProprietaire.getDataTableProprietaireAll(this.strCommande); gridView.DataBind(); #endregion }
void IntfDalProprietaire.insertToGridProprietaire(GridView gridView, string param, string paramLike, string valueLike, string typeProprietaire) { #region declaration IntfDalProprietaire serviceProprietaire = new ImplDalProprietaire(); #endregion #region implementation this.strCommande = "SELECT proprietaire.numProprietaire, Individu.numIndividu, Individu.civiliteIndividu,"; this.strCommande += " Individu.nomIndividu, Individu.prenomIndividu, Individu.cinIndividu,"; this.strCommande += " Individu.adresse, Individu.profession, Individu.telephoneFixeIndividu,"; this.strCommande += " Individu.telephoneMobileIndividu FROM proprietaire"; this.strCommande += " Inner Join Individu ON Individu.numIndividu = proprietaire.numIndividu"; this.strCommande += " WHERE proprietaire.typeProprietaire = '" + typeProprietaire + "' AND"; this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')"; this.strCommande += " ORDER BY " + param + " ASC"; gridView.DataSource = serviceProprietaire.getDataTableProprietaire(this.strCommande); gridView.DataBind(); #endregion }
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); }