string IntfDalUSCarte.insertUSCarte(crlUSCarte carte, string sigleAgence) { #region declaration string numCarte = ""; IntfDalUSCarte serviceUSCarte = new ImplDalUSCarte(); string numAbonnement = "NULL"; string numAbonnementNV = "NULL"; string numAbonnementNVDevis = "NULL"; string numUSReductionParticulier = "NULL"; string numUSValidationReduction = "NULL"; int nbInsert = 0; #endregion #region implementation if (carte != null && sigleAgence != "") { if (carte.NumAbonnement != "") { numAbonnement = "'" + carte.NumAbonnement + "'"; } if (carte.NumUSReductionParticulier != "") { numUSReductionParticulier = "'" + carte.NumUSReductionParticulier + "'"; } if (carte.NumUSValidationReduction != "") { numUSValidationReduction = "'" + carte.NumUSValidationReduction + "'"; } if (carte.NumAbonnementNV != "") { numAbonnementNV = "'" + carte.NumAbonnementNV + "'"; } if (carte.NumAbonnementNVDevis != "") { numAbonnementNVDevis = "'" + carte.NumAbonnementNVDevis + "'"; } carte.NumCarte = serviceUSCarte.getNumUSCarte(sigleAgence); this.strCommande = "INSERT INTO `uscarte` (`numCarte`,`prixCarte`,`numUSReductionParticulier`,"; this.strCommande += " `numAbonnement`,`numAgence`, `numAbonnementNV`, `numAbonnementNVDevis`,"; this.strCommande += " `numUSValidationReduction`)"; this.strCommande += " VALUES ('" + carte.NumCarte + "','" + carte.PrixCarte.ToString("0") + "',"; this.strCommande += " " + numUSReductionParticulier + "," + numAbonnement + ",'" + carte.NumAgence + "',"; this.strCommande += " " + numAbonnementNV + ", " + numAbonnementNVDevis + "," + numUSValidationReduction + ")"; this.serviceConnectBase.openConnection(); nbInsert = this.serviceConnectBase.requete(this.strCommande); if (nbInsert == 1) { numCarte = carte.NumCarte; } this.serviceConnectBase.closeConnection(); } #endregion return(numCarte); }
void IntfDalUSCarte.insertToGridCarte(GridView gridView, string param, string paramLike, string valueLike, string numAgence) { #region declaration IntfDalUSCarte serviceUSCarte = new ImplDalUSCarte(); #endregion #region implementation this.strCommande = "SELECT uscarte.numCarte, uscarte.prixCarte, uscarte.numUSReductionParticulier,"; this.strCommande += " uscarte.numAbonnement, uscarte.numAgence, uscarte.numUSValidationReduction"; this.strCommande += " FROM uscarte WHERE " + paramLike + " LIKE '%" + valueLike + "%' AND"; this.strCommande += " uscarte.numAgence LIKE '%" + numAgence + "%'"; this.strCommande += " ORDER BY " + param; gridView.DataSource = serviceUSCarte.getDataTableCarte(this.strCommande); gridView.DataBind(); #endregion }