string IntfDalRecuDecaisser.insertRecuDecaisser(crlRecuDecaisser recuDecaisser, string sigleAgence) { #region declaration int nombreInsert = 0; string numRecuDecaisser = ""; IntfDalRecuDecaisser serviceRecuDecaisser = new ImplDalRecuDecaisser(); #endregion #region implementation if (recuDecaisser != null) { recuDecaisser.NumRecuDecaisser = serviceRecuDecaisser.getNumRecuDecaisser(sigleAgence); this.strCommande = "INSERT INTO `recudecaisser` (`numRecuDecaisser`,`matriculeAgent`,`dateRecuDecaisser`,"; this.strCommande += " `motantRecuDecaisser`,`libelleRecuDecaisser`) VALUES ('" + recuDecaisser.NumRecuDecaisser + "',"; this.strCommande += " '" + recuDecaisser.MatriculeAgent + "','" + recuDecaisser.DateRecuDecaisser.ToString("yyyy-MM-dd HH:mm:ss") + "',"; this.strCommande += " '" + recuDecaisser.MotantRecuDecaisser.ToString("0") + "','" + recuDecaisser.LibelleRecuDecaisser + "')"; this.serviceConnectBase.openConnection(); nombreInsert = this.serviceConnectBase.requete(this.strCommande); if (nombreInsert == 1) { numRecuDecaisser = recuDecaisser.NumRecuDecaisser; } this.serviceConnectBase.closeConnection(); } #endregion return(numRecuDecaisser); }
bool IntfDalRecuDecaisser.updateRecuDecaisser(crlRecuDecaisser recuDecaisser) { #region declaration bool isUpdate = false; int nombreUpdate = 0; #endregion #region implementation if (recuDecaisser != null) { this.strCommande = "UPDATE `recudecaisser` SET `matriculeAgent`='" + recuDecaisser.MatriculeAgent + "',"; this.strCommande += " `dateRecuDecaisser`='" + recuDecaisser.DateRecuDecaisser.ToString("yyyy-MM-dd HH:mm:ss") + "',"; this.strCommande += " `motantRecuDecaisser`='" + recuDecaisser.MotantRecuDecaisser.ToString("0") + "',"; this.strCommande += " `libelleRecuDecaisser`='" + recuDecaisser.LibelleRecuDecaisser + "'"; this.strCommande += " WHERE `numRecuDecaisser`='" + recuDecaisser.NumRecuDecaisser + "'"; this.serviceConnectBase.openConnection(); nombreUpdate = this.serviceConnectBase.requete(this.strCommande); if (nombreUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }
crlRecuDecaisser IntfDalRecuDecaisser.selectRecuDecaisser(string numRecuDecaisser) { #region declaration crlRecuDecaisser recuDecaisser = null; IntfDalAgent serviceAgent = new ImplDalAgent(); #endregion #region implementation if (numRecuDecaisser != "") { this.strCommande = "SELECT * FROM `recudecaisser` WHERE `numRecuDecaisser`='" + numRecuDecaisser + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { recuDecaisser = new crlRecuDecaisser(); try { recuDecaisser.DateRecuDecaisser = Convert.ToDateTime(this.reader["dateRecuDecaisser"].ToString()); } catch (Exception) { } recuDecaisser.LibelleRecuDecaisser = this.reader["libelleRecuDecaisser"].ToString(); recuDecaisser.MatriculeAgent = this.reader["matriculeAgent"].ToString(); try { recuDecaisser.MotantRecuDecaisser = double.Parse(this.reader["motantRecuDecaisser"].ToString()); } catch (Exception) { } recuDecaisser.NumRecuDecaisser = this.reader["numRecuDecaisser"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (recuDecaisser.MatriculeAgent != "") { recuDecaisser.agent = serviceAgent.selectAgent(recuDecaisser.MatriculeAgent); } } #endregion return(recuDecaisser); }