string IntfDalRecuAD.insertRecuAD(crlRecuAD RecuAD) { #region declaration IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD(); int nombreInsertion = 0; string numRecu = ""; string numPrelevement = "NULL"; string numFacture = "NULL"; #endregion #region implementation if (RecuAD != null) { if (RecuAD.NumPrelevement != "") { numPrelevement = "'" + RecuAD.NumPrelevement + "'"; } if (RecuAD.NumFacture != "") { numFacture = "'" + RecuAD.NumFacture + "'"; } RecuAD.NumRecuAD = serviceRecuAD.getNumRecuAD(RecuAD.agent.agence.SigleAgence); this.strCommande = "INSERT INTO `recuad` (`numRecuAD`,`numPrelevement`,`matriculeAgent`,`libele`,`montant`,`dateRecu`,`numFacture`)"; this.strCommande += " VALUES ('" + RecuAD.NumRecuAD + "', " + numPrelevement + ", '" + RecuAD.MatriculeAgent + "',"; this.strCommande += " '" + RecuAD.Libele + "','" + RecuAD.Montant + "','" + RecuAD.Date.ToString("yyyy-MM-dd") + "'," + numFacture + ")"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numRecu = RecuAD.NumRecuAD; } this.serviceConnectBase.closeConnection(); } #endregion return(numRecu); }