string IntfDalObservationMateriel.insertObservationMateriel(crlObservationMateriel observation, string sigleAgence) { #region declaration string numObservation = ""; IntfDalObservationMateriel serviceObservationMateriel = new ImplDalObservationMateriel(); int nbInsert = 0; #endregion #region implementation if (observation != null && sigleAgence != "") { observation.NumObservation = serviceObservationMateriel.getNumObservation(sigleAgence); this.strCommande = "INSERT INTO `observationmateriel` (`numObservation`,`numAppareil`,`textObservation`,"; this.strCommande += "`dateObservation`,`isListeNoire`) VALUES ('" + observation.NumObservation + "',"; this.strCommande += "'" + observation.NumAppareil + "','" + observation.TextObesvation + "',"; this.strCommande += "'" + observation.DateObservation.ToString("yyyy-MM-dd") + "','" + observation.IsListeNoire + "')"; this.serviceConnectBase.openConnection(); nbInsert = this.serviceConnectBase.requete(this.strCommande); if (nbInsert == 1) { numObservation = observation.NumObservation; } this.serviceConnectBase.closeConnection(); } #endregion return(numObservation); }
bool IntfDalObservationMateriel.updateObservationMateriel(crlObservationMateriel observation) { #region declaration bool isUpdate = false; int nbUpdate = 0; #endregion #region implementation if (observation != null) { this.strCommande = "UPDATE `observationmateriel` SET `numAppareil`='" + observation.NumAppareil + "',"; this.strCommande += "`textObservation`='" + observation.TextObesvation + "',"; this.strCommande += "`dateObservation`='" + observation.DateObservation.ToString("yyyy-MM-dd") + "',"; this.strCommande += "`isListeNoire`='" + observation.IsListeNoire.ToString("0") + "'"; this.strCommande += " WHERE `numObservation`='" + observation.NumObservation + "'"; this.serviceConnectBase.openConnection(); nbUpdate = this.serviceConnectBase.requete(this.strCommande); if (nbUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }
crlObservationMateriel IntfDalObservationMateriel.selectObservationMateriel(string numObservation) { #region declaration crlObservationMateriel observationMateriel = null; #endregion #region implementation if (numObservation != "") { this.strCommande = "SELECT * FROM `observationmateriel` WHERE `numObservation`='" + numObservation + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { observationMateriel = new crlObservationMateriel(); try { observationMateriel.DateObservation = Convert.ToDateTime(this.reader["dateObservation"].ToString()); } catch (Exception) { } observationMateriel.NumAppareil = this.reader["numAppareil"].ToString(); try { observationMateriel.IsListeNoire = int.Parse(this.reader["isListeNoire"].ToString()); } catch (Exception) { } observationMateriel.NumObservation = this.reader["numObservation"].ToString(); observationMateriel.TextObesvation = this.reader["textObservation"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(observationMateriel); }