bool IntfDalObservationVehicule.updateObservationVehicule(crlObservationVehicule observation) { #region declaration bool isUpdate = false; int nbUpdate = 0; #endregion #region implementation if (observation != null) { this.strCommande = "UPDATE `observationvehicule` SET `numVehicule`='" + observation.NumVehicule + "',"; this.strCommande += "`textObesvationVehicule`='" + observation.TextObesvationVehicule + "',"; this.strCommande += "`dateObservation`='" + observation.DateObservation.ToString("yyyy-MM-dd") + "',"; this.strCommande += "`isListeNoire`='" + observation.IsListeNoire.ToString("0") + "'"; this.strCommande += " WHERE `numObservationVehicule`='" + observation.NumObservationVehicule + "'"; this.serviceConnectBase.openConnection(); nbUpdate = this.serviceConnectBase.requete(this.strCommande); if (nbUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }
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); }
private void insertToObjObservationVehicule(crlObservationVehicule observationVehicule) { if (observationVehicule != null) { observationVehicule.NumVehicule = hfNumVehicule.Value; observationVehicule.TextObesvationVehicule = TextObservation.Text; observationVehicule.IsListeNoire = int.Parse(rbAvertissement.SelectedValue); } }
protected void btnModifier_Click(object sender, EventArgs e) { #region declaration crlObservationVehicule observationVehicule = null; crlVehicule vehicule = null; string strIndicationText = ""; #endregion #region implementation if (hfObservationVehicule.Value != "") { observationVehicule = serviceObservationVehicule.selectObservationVehicule(hfObservationVehicule.Value); if (observationVehicule != null) { if (hfNumVehicule.Value != "") { this.insertToObjObservationVehicule(observationVehicule); if (serviceObservationVehicule.updateObservationVehicule(observationVehicule)) { this.initialiseGridObservationVehicule(); this.initialiseGridListeNoireVehicule(); this.initialiseFormulaireObs(); vehicule = serviceVehicule.selectVehicule(observationVehicule.NumVehicule); strIndicationText = "Observation bien modifier!"; if (vehicule != null) { strIndicationText += " Véhicule: " + vehicule.MatriculeVehicule + " " + vehicule.MarqueVehicule + " " + vehicule.CouleurVehicule; } this.divIndicationText(strIndicationText, "Black"); } else { strIndicationText = "Une erreur ce produit durant la modification!"; this.divIndicationText(strIndicationText, "Red"); } } else { // } } else { // } } else { // } #endregion }
crlObservationVehicule IntfDalObservationVehicule.selectObservationVehicule(string numObservationVehicule) { #region declaration crlObservationVehicule observationVehicule = null; #endregion #region implementation if (numObservationVehicule != "") { this.strCommande = "SELECT * FROM `observationvehicule` WHERE `numObservationVehicule`='" + numObservationVehicule + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { observationVehicule = new crlObservationVehicule(); try { observationVehicule.DateObservation = Convert.ToDateTime(this.reader["dateObservation"].ToString()); } catch (Exception) { } observationVehicule.NumVehicule = this.reader["numVehicule"].ToString(); try { observationVehicule.IsListeNoire = int.Parse(this.reader["isListeNoire"].ToString()); } catch (Exception) { } observationVehicule.NumObservationVehicule = this.reader["numObservationVehicule"].ToString(); observationVehicule.TextObesvationVehicule = this.reader["textObesvationVehicule"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(observationVehicule); }
private void afficheObservation(string numObservation) { #region declaration crlObservationVehicule observation = null; crlVehicule vehicule = null; string strConfirm = ""; #endregion #region implementation if (numObservation != "") { observation = serviceObservationVehicule.selectObservationVehicule(numObservation); if (observation != null) { this.afficheVehicule(observation.NumVehicule); TextObservation.Text = observation.TextObesvationVehicule; rbAvertissement.SelectedValue = observation.IsListeNoire.ToString(); hfObservationVehicule.Value = observation.NumObservationVehicule; vehicule = serviceVehicule.selectVehicule(observation.NumVehicule); btnModifier.Enabled = true; btnValider.Enabled = false; strConfirm = "Voulez vous vraiment modifier l'observation?\n"; if (vehicule != null) { strConfirm += "Véhicule: " + vehicule.MatriculeVehicule + " " + vehicule.MarqueVehicule + " " + vehicule.CouleurVehicule + "\n"; strConfirm += "Date: " + observation.DateObservation.ToString("dd MMMM yyyy"); } ConfirmButtonExtender_btnModifier.ConfirmText = strConfirm; } } #endregion }