string IntfDalTarifBaseCommission.insertTarifBaseCommission(crlTarifBaseCommission TarifBaseCommission, string sigleAgence) { #region declaration IntfDalTarifBaseCommission serviceTarifBaseCommission = new ImplDalTarifBaseCommission(); int nombreInsertion = 0; string numTarifBaseBillet = ""; #endregion #region implementation if (TarifBaseCommission != null) { TarifBaseCommission.NumTarifBaseCommission = serviceTarifBaseCommission.getNumerosTarifBaseCommission(sigleAgence); this.strCommande = "INSERT INTO `tarifbasecommission` (`numTarifBaseCommission`,`numTarifCommissionPar`,`montantTarifBaseCommission`)"; this.strCommande += " VALUES ('" + TarifBaseCommission.NumTarifBaseCommission + "','" + TarifBaseCommission.NumTarifCommissionPar + "','" + TarifBaseCommission.MontantTarifBaseCommission + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numTarifBaseBillet = TarifBaseCommission.NumTarifBaseCommission; } this.serviceConnectBase.closeConnection(); } #endregion return(numTarifBaseBillet); }
bool IntfDalTarifBaseCommission.updateTarifBaseCommission(crlTarifBaseCommission TarifBaseCommission) { #region declaration bool isUpdate = false; int nbUpdate = 0; #endregion #region implementation if (TarifBaseCommission != null) { this.strCommande = "UPDATE `tarifbasecommission` SET `numTarifCommissionPar`='" + TarifBaseCommission.NumTarifCommissionPar + "',"; this.strCommande += "`montantTarifBaseCommission`='" + TarifBaseCommission.MontantTarifBaseCommission.ToString("0") + "'"; this.strCommande += " WHERE `numTarifBaseCommission`='" + TarifBaseCommission.NumTarifBaseCommission + "'"; this.serviceConnectBase.openConnection(); nbUpdate = this.serviceConnectBase.requete(this.strCommande); if (nbUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }
List <crlTarifBaseCommission> IntfDalTarifBaseCommission.selectTarifBaseCommissions(string numTrajet) { #region decalaration List <crlTarifBaseCommission> tarifBaseCommissions = null; crlTarifBaseCommission tempTarifBaseCommission = null; IntfDalTarifCommissionPar serviceTarifCommissionPar = new ImplDalTarifCommissionPar(); #endregion #region implementation if (numTrajet != "") { this.strCommande = "SELECT tarifbasecommission.numTarifBaseCommission, tarifbasecommission.numTarifCommissionPar,"; this.strCommande += " tarifbasecommission.montantTarifBaseCommission FROM tarifbasecommission"; this.strCommande += " Inner Join associationtrajettarifcommission ON associationtrajettarifcommission.numTarifBaseCommission = tarifbasecommission.numTarifBaseCommission"; this.strCommande += " WHERE associationtrajettarifcommission.numTrajet = '" + numTrajet + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { tarifBaseCommissions = new List <crlTarifBaseCommission>(); while (this.reader.Read()) { tempTarifBaseCommission = new crlTarifBaseCommission(); tempTarifBaseCommission.NumTarifBaseCommission = this.reader["numTarifBaseCommission"].ToString(); tempTarifBaseCommission.NumTarifCommissionPar = this.reader["numTarifCommissionPar"].ToString(); try { tempTarifBaseCommission.MontantTarifBaseCommission = double.Parse(this.reader["montantTarifBaseCommission"].ToString()); } catch (Exception) { } tarifBaseCommissions.Add(tempTarifBaseCommission); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (tarifBaseCommissions != null) { for (int i = 0; i < tarifBaseCommissions.Count; i++) { if (tarifBaseCommissions[i].NumTarifCommissionPar != "") { tarifBaseCommissions[i].tarifCommissionPar = serviceTarifCommissionPar.selectTarifCommissionPar(tarifBaseCommissions[i].NumTarifCommissionPar); } } } } #endregion return(tarifBaseCommissions); }
crlTarifBaseCommission IntfDalTarifBaseCommission.selectTarifBaseCommission(string numTarifBaseCommission) { #region decalaration crlTarifBaseCommission tarifBaseCommission = null; IntfDalTarifCommissionPar serviceTarifCommissionPar = new ImplDalTarifCommissionPar(); #endregion #region implementation if (numTarifBaseCommission != "") { this.strCommande = "SELECT * FROM `tarifbasecommission` WHERE (`numTarifBaseCommission`='" + numTarifBaseCommission + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { tarifBaseCommission = new crlTarifBaseCommission(); tarifBaseCommission.NumTarifBaseCommission = this.reader["numTarifBaseCommission"].ToString(); tarifBaseCommission.NumTarifCommissionPar = this.reader["numTarifCommissionPar"].ToString(); try { tarifBaseCommission.MontantTarifBaseCommission = double.Parse(this.reader["montantTarifBaseCommission"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (tarifBaseCommission != null) { if (tarifBaseCommission.NumTarifCommissionPar != "") { tarifBaseCommission.tarifCommissionPar = serviceTarifCommissionPar.selectTarifCommissionPar(tarifBaseCommission.NumTarifCommissionPar); } } } #endregion return(tarifBaseCommission); }