string IntfDalUSCarteReduction.insertUSCarteReduction(crlUSCarteReduction carteReduction, string sigleAgence) { #region declaration string numCarteReduction = ""; IntfDalUSCarteReduction serviceUSCarteReduction = new ImplDalUSCarteReduction(); int nbInsert = 0; string dateDelivranceCertificatScolarite = "NULL"; string dateAtestationEmployeur = "NULL"; string numEtablissementScolaire = "NULL"; string numSociete = "NULL"; #endregion #region implemenbtation if (carteReduction != null) { if (carteReduction.DateDelivranceCertificatScolarite.Year > 1) { dateDelivranceCertificatScolarite = "'" + carteReduction.DateDelivranceCertificatScolarite.ToString("yyyy-MM-dd") + "'"; } if (carteReduction.DateAtestationEmployeur.Year > 1) { dateAtestationEmployeur = "'" + carteReduction.DateAtestationEmployeur.ToString("yyyy-MM-dd") + "'"; } if (carteReduction.NumEtablissementScolaire != "") { numEtablissementScolaire = "'" + carteReduction.NumEtablissementScolaire + "'"; } if (carteReduction.NumSociete != "") { numSociete = "'" + carteReduction.NumSociete + "'"; } carteReduction.NumCarteReduction = serviceUSCarteReduction.getNumUSCarteReduction(sigleAgence); this.strCommande = "INSERT INTO `uscartereduction` (`numCarteReduction`,`numClient`,`numCategorieBillet`,"; this.strCommande += " `dateValideDu`,`dateValideAu`,`isLundi`,`isMardi`,`isMercredi`,`isJeudi`,`isVendredi`,"; this.strCommande += " `isSamedi`,`isDimanche`,`etatCivil`,`dateNaissance`,`imageCarteReduction`,"; this.strCommande += " `dateDelivranceCertificatScolarite`,`dateAtestationEmployeur`,`numEtablissementScolaire`,"; this.strCommande += " `numSociete`) VALUES ('" + carteReduction.NumCarteReduction + "',"; this.strCommande += " '" + carteReduction.NumClient + "','" + carteReduction.NumCategorieBillet + "',"; this.strCommande += " '" + carteReduction.DateValideDu.ToString("yyyy-MM-dd") + "',"; this.strCommande += " '" + carteReduction.DateValideAu.ToString("yyyy-MM-dd") + "',"; this.strCommande += " '" + carteReduction.IsLundi.ToString("0") + "','" + carteReduction.IsMardi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsMercredi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsJeudi.ToString("0") + "','" + carteReduction.IsVendredi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsSamedi.ToString("0") + "','" + carteReduction.IsDimanche.ToString("0") + "',"; this.strCommande += " '" + carteReduction.EtatCivil + "',"; this.strCommande += " '" + carteReduction.DateNaissance.ToString("yyyy-MM-dd") + "','" + carteReduction.ImageCarteReduction + "',"; this.strCommande += " " + dateDelivranceCertificatScolarite + "," + dateAtestationEmployeur + ","; this.strCommande += " " + numEtablissementScolaire + "," + numSociete + ")"; this.serviceConnectBase.openConnection(); nbInsert = this.serviceConnectBase.requete(this.strCommande); if (nbInsert == 1) { numCarteReduction = carteReduction.NumCarteReduction; } this.serviceConnectBase.closeConnection(); } #endregion return numCarteReduction; }