string IntfDalObservationVehicule.insertObservationVehicule(crlObservationVehicule observation, string sigleAgence)
{
#region declaration
string numObservation = "";
IntfDalObservationVehicule serviceObservationVehicule = new ImplDalObservationVehicule();
int nbInsert = 0;
#endregion
#region implementation
if (observation != null && sigleAgence != "")
{
observation.NumObservationVehicule = serviceObservationVehicule.getNumObservationVehicule(sigleAgence);
this.strCommande = "INSERT INTO `observationvehicule` (`numObservationVehicule`,`numVehicule`,`textObesvationVehicule`,";
this.strCommande += "`dateObservation`,`isListeNoire`) VALUES ('" + observation.NumObservationVehicule + "',";
this.strCommande += "'" + observation.NumVehicule + "','" + observation.TextObesvationVehicule + "',";
this.strCommande += "'" + observation.DateObservation.ToString("yyyy-MM-dd") + "','" + observation.IsListeNoire + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numObservation = observation.NumObservationVehicule;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numObservation);
}
void IntfDalObservationVehicule.insertToGridObservationVehicule(GridView gridView, string param, string paramLike, string valueLike, string numVehicule)
{
#region declaration
IntfDalObservationVehicule serviceObservationVehicule = new ImplDalObservationVehicule();
#endregion
#region implementation
this.strCommande = "SELECT observationvehicule.numObservationVehicule, observationvehicule.numVehicule,";
this.strCommande += " observationvehicule.textObesvationVehicule, observationvehicule.dateObservation,";
this.strCommande += " observationvehicule.isListeNoire, vehicule.numVehicule, vehicule.numParamVehicule,";
this.strCommande += " vehicule.sourceEnergie, vehicule.numProprietaire, vehicule.matriculeVehicule,";
this.strCommande += " vehicule.marqueVehicule, vehicule.typeVehicule, vehicule.numSerieVehicule,";
this.strCommande += " vehicule.numMoteurVehicule, vehicule.puissanceVehicule, vehicule.couleurVehicule,";
this.strCommande += " vehicule.placesAssiseVehicule, vehicule.nombreColoneVehicule, vehicule.poidsTotalVehicule,";
this.strCommande += " vehicule.poidsVideVehicule, vehicule.imageVehicule FROM observationvehicule";
this.strCommande += " Inner Join vehicule ON vehicule.numVehicule = observationvehicule.numVehicule";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%' AND";
this.strCommande += " observationvehicule.numVehicule LIKE '%" + numVehicule + "%'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceObservationVehicule.getDataTableObservationVehicule(this.strCommande);
gridView.DataBind();
#endregion
}
