public List <crlBillet> getBillet(crlBilletCommande billetCommande, crlAgent agent) { #region declaration List <crlBillet> billets = null; crlBillet tempBillet = null; #endregion #region implementation if (billetCommande != null && agent != null) { if (billetCommande.NombreBilletCommande > 0) { billets = new List <crlBillet>(); for (int i = 0; i < billetCommande.NombreBilletCommande; i++) { tempBillet = new crlBillet(); tempBillet.agent = agent; tempBillet.calculCategorieBillet = billetCommande.calculCategorieBillet; tempBillet.calculReductionBillet = billetCommande.calculReductionBillet; try { tempBillet.DateDeValidite = DateTime.Now.AddMonths(int.Parse(ReGlobalParam.nbValiditeBillet)); } catch (Exception) { tempBillet.DateDeValidite = DateTime.Now.AddMonths(1); } tempBillet.MatriculeAgent = agent.matriculeAgent; tempBillet.ModePaiement = "Commande"; tempBillet.NumCalculCategorieBillet = billetCommande.NumCalculCategorieBillet; tempBillet.NumCalculReductionBillet = billetCommande.NumCalculReductionBillet; tempBillet.NumTrajet = billetCommande.NumTrajet; tempBillet.PrixBillet = billetCommande.MontantBilletCommande.ToString("0"); tempBillet.trajet = billetCommande.trajet; tempBillet.NumIndividu = billetCommande.NumIndividu; tempBillet.individu = billetCommande.individu; tempBillet.NumBilletCommande = billetCommande.NumBilletCommande; billets.Add(tempBillet); tempBillet = null; } } } #endregion return(billets); }
crlBilletCommande IntfDalBilletCommande.selectBilletCommande(string numBilletCommande) { #region declaration crlBilletCommande billetCommande = null; IntfDalTrajet serviceTrajet = new ImplDalTrajet(); IntfDalProforma serviceProforma = new ImplDalProforma(); IntfDalCalculCategorieBillet serviceCalculCategorieBillet = new ImplDalCalculCategorieBillet(); IntfDalCalculReductionBillet serviceCalculReductionBillet = new ImplDalCalculReductionBillet(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation if (numBilletCommande != "") { this.strCommande = "SELECT * FROM `billetcommande` WHERE (`numBilletCommande`='" + numBilletCommande + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { billetCommande = new crlBilletCommande(); billetCommande.NumBilletCommande = this.reader["numBilletCommande"].ToString(); billetCommande.NumTrajet = this.reader["numTrajet"].ToString(); billetCommande.NumProforma = this.reader["numProforma"].ToString(); try { billetCommande.MontantBilletCommande = double.Parse(this.reader["montantBilletCommande"].ToString()); } catch (Exception) { } try { billetCommande.NombreBilletCommande = int.Parse(this.reader["nombreBilletCommande"].ToString()); } catch (Exception) { } billetCommande.NumCalculCategorieBillet = this.reader["numCalculCategorieBillet"].ToString(); billetCommande.NumCalculReductionBillet = this.reader["numCalculReductionBillet"].ToString(); billetCommande.NumIndividu = this.reader["numIndividu"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (billetCommande != null) { if (billetCommande.NumTrajet != "") { billetCommande.trajet = serviceTrajet.selectTrajet(billetCommande.NumTrajet); } if (billetCommande.NumCalculCategorieBillet != "") { billetCommande.calculCategorieBillet = serviceCalculCategorieBillet.selectCalculCategorieBillet(billetCommande.NumCalculCategorieBillet); } if (billetCommande.NumCalculReductionBillet != "") { billetCommande.calculReductionBillet = serviceCalculReductionBillet.selectCalculReductionBillet(billetCommande.NumCalculReductionBillet); } if (billetCommande.NumIndividu != "") { billetCommande.individu = serviceIndividu.selectIndividu(billetCommande.NumIndividu); } } } #endregion return(billetCommande); }
bool IntfDalBilletCommande.updateBilletCommande(crlBilletCommande billetCommande) { #region declaration bool isUpdate = false; int nombreUpdate = 0; string numCalculCategorieBillet = ""; string numCalculReductionBillet = ""; string numTrajet = ""; string numIndividu = "NULL"; #endregion #region implementation if (billetCommande != null) { if (billetCommande.NumCalculCategorieBillet != "") { numCalculCategorieBillet = "'" + billetCommande.NumCalculCategorieBillet + "'"; } else { numCalculCategorieBillet = "NULL"; } if (billetCommande.NumCalculReductionBillet != "") { numCalculReductionBillet = "'" + billetCommande.NumCalculReductionBillet + "'"; } else { numCalculReductionBillet = "NULL"; } if (billetCommande.NumTrajet != "") { numTrajet = "'" + billetCommande.NumTrajet + "'"; } else { numTrajet = "NULL"; } if (billetCommande.NumIndividu != "") { numIndividu = "'" + billetCommande.NumIndividu + "'"; } this.strCommande = "UPDATE `billetcommande` SET `numTrajet`=" + numTrajet + ","; this.strCommande += " `numProforma`='" + billetCommande.NumProforma + "', `montantBilletCommande`='" + billetCommande.MontantBilletCommande.ToString("0") + "',"; this.strCommande += " `nombreBilletCommande`='" + billetCommande.NombreBilletCommande + "',`numCalculCategorieBillet`=" + numCalculCategorieBillet + ","; this.strCommande += " `numCalculReductionBillet`=" + numCalculReductionBillet + ",`numIndividu`=" + numIndividu; this.strCommande += " WHERE `numBilletCommande`='" + billetCommande.NumBilletCommande + "'"; this.serviceConnectBase.openConnection(); nombreUpdate = this.serviceConnectBase.requete(this.strCommande); if (nombreUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isUpdate); }
string IntfDalBilletCommande.insertBilletCommande(crlBilletCommande billetCommande, string sigleAgence) { #region declaration string numBilletCommande = ""; int nombreInsert = 0; IntfDalBilletCommande serviceChequeBilletCommande = new ImplDalBilletCommande(); string numCalculCategorieBillet = ""; string numCalculReductionBillet = ""; string numTrajet = ""; string numIndividu = "NULL"; #endregion #region implementation if (billetCommande != null) { if (sigleAgence != "") { if (billetCommande.NumCalculCategorieBillet != "") { numCalculCategorieBillet = "'" + billetCommande.NumCalculCategorieBillet + "'"; } else { numCalculCategorieBillet = "NULL"; } if (billetCommande.NumCalculReductionBillet != "") { numCalculReductionBillet = "'" + billetCommande.NumCalculReductionBillet + "'"; } else { numCalculReductionBillet = "NULL"; } if (billetCommande.NumTrajet != "") { numTrajet = "'" + billetCommande.NumTrajet + "'"; } else { numTrajet = "NULL"; } if (billetCommande.NumIndividu != "") { numIndividu = "'" + billetCommande.NumIndividu + "'"; } billetCommande.NumBilletCommande = serviceChequeBilletCommande.getNumBilletCommande(sigleAgence); this.strCommande = "INSERT INTO `billetcommande` (`numBilletCommande`,`numTrajet`,`numProforma`,`montantBilletCommande`,"; this.strCommande += " `nombreBilletCommande`,`numCalculCategorieBillet`,`numCalculReductionBillet`,`numIndividu`)"; this.strCommande += " VALUES ('" + billetCommande.NumBilletCommande + "'," + numTrajet + ","; this.strCommande += " '" + billetCommande.NumProforma + "','" + billetCommande.MontantBilletCommande.ToString("0") + "',"; this.strCommande += " '" + billetCommande.NombreBilletCommande + "'," + numCalculCategorieBillet + ","; this.strCommande += " " + numCalculReductionBillet + "," + numIndividu + ")"; this.serviceConnectBase.openConnection(); nombreInsert = this.serviceConnectBase.requete(this.strCommande); if (nombreInsert == 1) { numBilletCommande = billetCommande.NumBilletCommande; } this.serviceConnectBase.closeConnection(); } } #endregion return(numBilletCommande); }