string IntfDalUSCategorieBillet.isCategorieBillet(crlUSCategorieBillet categorieBillet) { #region declaration string numCategorie = ""; #endregion #region implementation if (categorieBillet != null) { this.strCommande = "SELECT uscategoriebillet.numCategorieBillet FROM uscategoriebillet"; this.strCommande += " WHERE uscategoriebillet.categorieBillet = '" + categorieBillet.CategorieBillet + "' AND"; this.strCommande += " uscategoriebillet.numCategorieBillet <> '" + categorieBillet.NumCategorieBillet + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { numCategorie = this.reader["numCategorieBillet"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(numCategorie); }
crlUSCategorieBillet IntfDalUSCategorieBillet.selectUSCategorieBillet(string numCategorieBillet) { #region declaration crlUSCategorieBillet categorieBillet = null; #endregion #region implementation if (numCategorieBillet != "") { this.strCommande = "SELECT * FROM `uscategoriebillet` WHERE `numCategorieBillet`='" + numCategorieBillet + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { categorieBillet = new crlUSCategorieBillet(); categorieBillet.CategorieBillet = this.reader["categorieBillet"].ToString(); categorieBillet.NumCategorieBillet = this.reader["numCategorieBillet"].ToString(); try { categorieBillet.ReductionMontant = double.Parse(this.reader["reductionMontant"].ToString()); } catch (Exception) { } try { categorieBillet.ReductionPourcentage = double.Parse(this.reader["reductionPourcentage"].ToString()); } catch (Exception) { } try { categorieBillet.DureeMaxValidite = int.Parse(this.reader["dureeMaxValidite"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(categorieBillet); }
string IntfDalUSCategorieBillet.insertUSCategorieBillet(crlUSCategorieBillet categorieBillet, string sigleAgence) { #region declaration string numCategorieBillet = ""; IntfDalUSCategorieBillet serviceUSCategorieBillet = new ImplDalUSCategorieBillet(); string reductionPourcentage = "NULL"; string reductionMontant = "NULL"; int nbInsert = 0; #endregion #region implementation if (categorieBillet != null) { if (categorieBillet.ReductionPourcentage >= 0) { reductionPourcentage = "'" + categorieBillet.ReductionPourcentage.ToString() + "'"; } if (categorieBillet.ReductionMontant >= 0) { reductionMontant = "'" + categorieBillet.ReductionMontant.ToString("0") + "'"; } categorieBillet.NumCategorieBillet = serviceUSCategorieBillet.getNumUSCategorieBillet(sigleAgence); this.strCommande = "INSERT INTO `uscategoriebillet` (`numCategorieBillet`,`categorieBillet`,"; this.strCommande += " `reductionPourcentage`,`reductionMontant`,`dureeMaxValidite`) VALUES"; this.strCommande += " ('" + categorieBillet.NumCategorieBillet + "',"; this.strCommande += " '" + categorieBillet.CategorieBillet + "'," + reductionPourcentage + ","; this.strCommande += " " + reductionMontant + ",'" + categorieBillet.DureeMaxValidite.ToString("0") + "')"; this.serviceConnectBase.openConnection(); nbInsert = this.serviceConnectBase.requete(this.strCommande); if (nbInsert == 1) { numCategorieBillet = categorieBillet.NumCategorieBillet; } this.serviceConnectBase.closeConnection(); } #endregion return(numCategorieBillet); }
bool IntfDalUSCategorieBillet.updateUSCategorieBillet(crlUSCategorieBillet categorieBillet) { #region declaration bool isUpdate = false; int nbUpdate = 0; string reductionPourcentage = "NULL"; string reductionMontant = "NULL"; #endregion #region implementation if (categorieBillet != null) { if (categorieBillet.ReductionPourcentage >= 0) { reductionPourcentage = "'" + categorieBillet.ReductionPourcentage.ToString() + "'"; } if (categorieBillet.ReductionMontant >= 0) { reductionMontant = "'" + categorieBillet.ReductionMontant.ToString("0") + "'"; } this.strCommande = "UPDATE `uscategoriebillet` SET `categorieBillet`='" + categorieBillet.CategorieBillet + "',"; this.strCommande += " `reductionPourcentage`=" + reductionPourcentage + ",`reductionMontant`=" + reductionMontant + ","; this.strCommande += " `dureeMaxValidite`='" + categorieBillet.DureeMaxValidite.ToString("0") + "'"; this.strCommande += " WHERE `numCategorieBillet`='" + categorieBillet.NumCategorieBillet + "'"; this.serviceConnectBase.openConnection(); nbUpdate = this.serviceConnectBase.requete(this.strCommande); if (nbUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }