void IntfDalVehicule.insertToGridRecuForVehicule(GridView gridView, string param, string paramLike, string valueLike, string numVehicule)
{
#region declaration
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
this.strCommande = "SELECT (recuad.numRecuAD) AS numR, typeprelevement.commentaire, recuad.matriculeAgent,";
this.strCommande += " recuad.libele, recuad.montant, recuad.dateRecu FROM vehicule";
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 += " vehicule.numVehicule = '" + numVehicule + "' AND";
this.strCommande += " (" + paramLike + " LIKE '%" + valueLike + "%')";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceVehicule.getDataTableRecuForVehicule(this.strCommande);
gridView.DataBind();
#endregion
}
void IntfDalVehicule.insertToGridADForVehicule(GridView gridView, string param, string paramLike, string valueLike, string numVehicule)
{
#region declaration
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
this.strCommande = "SELECT autorisationdepart.recetteTotale, autorisationdepart.resteRegle,";
this.strCommande += " vehicule.matriculeVehicule, vehicule.marqueVehicule, vehicule.couleurVehicule,";
this.strCommande += " chauffeur.nomChauffeur, chauffeur.prenomChauffeur, fichebord.dateHeurDepart,";
this.strCommande += " autorisationdepart.dateAD, verification.idItineraire FROM autorisationdepart";
this.strCommande += " Inner Join fichebord ON fichebord.numerosFB = autorisationdepart.numerosFB";
this.strCommande += " Inner Join autorisationvoyage ON autorisationvoyage.numerosAV = fichebord.numerosAV";
this.strCommande += " Inner Join verification ON verification.idVerification = autorisationvoyage.idVerification";
this.strCommande += " Inner Join licence ON licence.numLicence = verification.numLicence";
this.strCommande += " Inner Join vehicule ON vehicule.numVehicule = licence.numVehicule";
this.strCommande += " Inner Join chauffeur ON chauffeur.idChauffeur = verification.idChauffeur";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%' AND";
this.strCommande += " autorisationdepart.resteRegle > '0' AND";
this.strCommande += " vehicule.numVehicule = '" + numVehicule + "'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceVehicule.getDataTableADForVehicule(this.strCommande);
gridView.DataBind();
#endregion
}
string IntfDalVehicule.insertVehicule(crlVehicule vehicule, string sigleAgence)
{
#region declaration
string numVehicule = "";
string numParamVehicule = "NULL";
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
int nombreInsert = 0;
#endregion
#region implementation
if (vehicule != null)
{
if (vehicule.NumParamVehicule != "")
{
numParamVehicule = "'" + vehicule.NumParamVehicule + "'";
}
if (sigleAgence != "")
{
vehicule.NumVehicule = serviceVehicule.getNumVehicule(sigleAgence);
this.strCommande = "INSERT INTO `vehicule` (`numVehicule`,`numParamVehicule`,`sourceEnergie`,";
this.strCommande += " `numProprietaire`,`matriculeVehicule`,`marqueVehicule`,`typeVehicule`,";
this.strCommande += " `numSerieVehicule`,`numMoteurVehicule`,`puissanceVehicule`,`couleurVehicule`,";
this.strCommande += " `placesAssiseVehicule`,`nombreColoneVehicule`,`poidsTotalVehicule`,`poidsVideVehicule`,";
this.strCommande += " `imageVehicule`) VALUES ('" + vehicule.NumVehicule + "', " + numParamVehicule + ",";
this.strCommande += " '" + vehicule.SourceEnergie + "','" + vehicule.NumProprietaire + "',";
this.strCommande += " '" + vehicule.MatriculeVehicule.ToUpper() + "','" + vehicule.MarqueVehicule + "','" + vehicule.TypeVehicule + "',";
this.strCommande += " '" + vehicule.NumSerieVehicule + "','" + vehicule.NumMoteurVehicule + "',";
this.strCommande += " '" + vehicule.PuissanceVehicule + "','" + vehicule.CouleurVehicule + "','" + vehicule.PlacesAssiseVehicule + "',";
this.strCommande += " '" + vehicule.NombreColoneVehicule + "','" + vehicule.PoidsTotalVehicule + "',";
this.strCommande += " '" + vehicule.PoidsVideVehicule + "','" + vehicule.ImageVehicule + "')";
this.serviceConnection.openConnection();
nombreInsert = this.serviceConnection.requete(this.strCommande);
if (nombreInsert == 1)
{
numVehicule = vehicule.NumVehicule;
}
this.serviceConnection.closeConnection();
}
}
#endregion
return(numVehicule);
}
void IntfDalVehicule.insertToGridVehicule(GridView gridView, string param, string paramLike, string valueLike)
{
#region declaration
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
this.strCommande = "SELECT vehicule.numVehicule, vehicule.sourceEnergie, vehicule.matriculeVehicule,";
this.strCommande += " vehicule.marqueVehicule, vehicule.typeVehicule, vehicule.couleurVehicule,";
this.strCommande += " Individu.nomIndividu, Individu.prenomIndividu FROM vehicule";
this.strCommande += " Inner Join proprietaire ON proprietaire.numProprietaire = vehicule.numProprietaire";
this.strCommande += " Inner Join Individu ON Individu.numIndividu = proprietaire.numIndividu";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceVehicule.getDataTableVehicule(this.strCommande);
gridView.DataBind();
#endregion
}
void IntfDalVehicule.insertToGridVehiculeForFacture(GridView gridView, string param, string paramLike, string valueLike)
{
#region declaration
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
this.strCommande = "SELECT vehicule.matriculeVehicule, vehicule.marqueVehicule,";
this.strCommande += " vehicule.couleurVehicule, vehicule.numVehicule, proprietaire.numOrganisme,";
this.strCommande += " proprietaire.numSociete, proprietaire.numIndividu FROM vehicule";
this.strCommande += " Inner Join proprietaire ON proprietaire.numProprietaire = vehicule.numProprietaire";
this.strCommande += " Left Join Individu ON Individu.numIndividu = proprietaire.numIndividu";
this.strCommande += " Left Join societe ON societe.numSociete = proprietaire.numSociete";
this.strCommande += " Left Join organisme ON organisme.numOrganisme = proprietaire.numOrganisme";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceVehicule.getDataTableVehiculeForFacture(this.strCommande);
gridView.DataBind();
#endregion
}
crlLicence IntfDalLicence.selectLicence(string numLicence)
{
#region declaration
IntfDalLicence serviceLicence = new ImplDalLicence();
List <crlItineraire> Itineraires = null;
crlLicence Licence = null;
IntfDalCooperative serviceCooperative = new ImplDalCooperative();
IntfDalZone serviceZone = new ImplDalZone();
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
if (numLicence != "")
{
Itineraires = serviceLicence.selectItineraire(numLicence);
this.strCommande = "SELECT * FROM licence WHERE (licence.numLicence = '" + numLicence + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
if (reader.Read())
{
Licence = new crlLicence();
Licence.NumLicence = reader["numLicence"].ToString();
Licence.NumerosLicence = reader["numerosLicence"].ToString();
Licence.Zone = reader["zone"].ToString();
Licence.NumCooperative = reader["numCooperative"].ToString();
Licence.NumVehicule = reader["numVehicule"].ToString();
try
{
Licence.DatePremiereMiseCiculation = Convert.ToDateTime(reader["datePremiereMiseCiculation"].ToString());
}
catch (Exception) { }
try
{
Licence.DatePremiereExploitation = Convert.ToDateTime(reader["datePremiereExploitation"].ToString());
}
catch (Exception) { }
try
{
Licence.ValideAu = Convert.ToDateTime(reader["valideAu"].ToString());
}
catch (Exception)
{
}
try
{
Licence.ValideDu = Convert.ToDateTime(reader["valideDu"].ToString());
}
catch (Exception)
{
}
try
{
Licence.NombrePlacePayante = int.Parse(reader["nombrePlacePayante"].ToString());
}
catch (Exception)
{
}
try
{
Licence.IsProvisoire = int.Parse(reader["isProvisoire"].ToString());
}
catch (Exception)
{
}
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (Licence != null)
{
if (Licence.Zone != "")
{
Licence.zoneObj = serviceZone.selectZone(Licence.Zone);
}
if (Licence.NumCooperative != "")
{
Licence.cooperative = serviceCooperative.selectCooperative(Licence.NumCooperative);
}
if (Licence.NumVehicule != "")
{
Licence.vehicule = serviceVehicule.selectVehicule(Licence.NumVehicule);
}
Licence.itineraires = serviceLicence.selectItineraire(Licence.NumLicence);
}
}
#endregion
return(Licence);
}
