crlOrganisme IntfDalOrganisme.selectOrganisme(string numOrganisme) { #region declaration crlOrganisme organisme = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation if (numOrganisme != "") { this.strCommande = "SELECT * FROM organisme WHERE `numOrganisme`='" + numOrganisme + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { organisme = new crlOrganisme(); organisme.AdresseOrganisme = this.reader["adresseOrganisme"].ToString(); organisme.MailOrganisme = this.reader["mailOrganisme"].ToString(); organisme.NomOrganisme = this.reader["nomOrganisme"].ToString(); organisme.NumOrganisme = this.reader["numOrganisme"].ToString(); organisme.TelephoneFixeOrganisme = this.reader["telephoneFixeOrganisme"].ToString(); organisme.TelephoneMobileOrganisme = this.reader["telephoneMobileOrganisme"].ToString(); organisme.NumQuartier = this.reader["numQuartier"].ToString(); organisme.NumIndividuResponsable = this.reader["numIndividuResponsable"].ToString(); try { organisme.IsCheque = int.Parse(this.reader["isCheque"].ToString()); } catch (Exception) { } try { organisme.IsBonCommande = int.Parse(this.reader["isBonCommande"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (organisme != null) { if (organisme.NumIndividuResponsable != "") { organisme.individuResponsable = serviceIndividu.selectIndividu(organisme.NumIndividuResponsable); } } } #endregion return(organisme); }
crlVoyage IntfDalVoyage.selectVoyage(string idVoyage) { #region declaration crlVoyage Voyage = null; IntfDalBagage serviceBagage = new ImplDalBagage(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalBillet serviceBillet = new ImplDalBillet(); IntfDalPlaceFB servicePlaceFB = new ImplDalPlaceFB(); #endregion #region implementation if (idVoyage != "") { this.strCommande = "SELECT * FROM `voyage` WHERE (`idVoyage`='" + idVoyage + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { Voyage = new crlVoyage(); Voyage.IdVoyage = reader["idVoyage"].ToString(); Voyage.NumIndividu = reader["numIndividu"].ToString(); Voyage.NumerosFB = reader["numerosFB"].ToString(); try { Voyage.PoidBagage = double.Parse(reader["poidBagage"].ToString()); } catch (Exception) {} Voyage.Destination = reader["destination"].ToString(); Voyage.NumBillet = reader["numBillet"].ToString(); Voyage.NumPlace = reader["numPlace"].ToString(); Voyage.PieceIdentite = reader["pieceIdentite"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (Voyage != null) { Voyage.billet = serviceBillet.selectBillet(Voyage.NumBillet); Voyage.individu = serviceIndividu.selectIndividu(Voyage.NumIndividu); Voyage.placeFB = servicePlaceFB.selectPlaceFB(Voyage.NumerosFB, Voyage.NumPlace); Voyage.bagage = serviceBagage.selectBagageForVoyage(Voyage.IdVoyage); } } #endregion return(Voyage); }
bool IntfDalIndividu.updateIndividu(crlIndividu Individu, HtmlGenericControl divIndication) { #region declaration bool isUpdate = false; string numIndividu = ""; string strIndication = ""; crlIndividu individuIndication = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation divIndication.Style.Add("font-size", "14px"); divIndication.Style.Add("color", "Red"); if (Individu != null) { if (Individu.CinIndividu != "") { numIndividu = serviceIndividu.isAllIndividu(Individu); if (numIndividu.Equals("")) { isUpdate = serviceIndividu.updateIndividu(Individu); if (!isUpdate) { strIndication = "Une erreur ce produit durant la modification!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } else { strIndication = "CIN déjà enregistrer dans la base de données!<br/>"; individuIndication = serviceIndividu.selectIndividu(numIndividu); if (individuIndication != null) { strIndication += "Nom:" + individuIndication.NomIndividu + "<br/>"; strIndication += "Prénom:" + individuIndication.PrenomIndividu + "<br/>"; } divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } else { isUpdate = serviceIndividu.updateIndividu(Individu); if (!isUpdate) { strIndication = "Une erreur ce produit durant la modification!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } } #endregion return(isUpdate); }
crlUSReductionParticulier IntfDalUSReductionParticulier.selectUSReductionParticulier(string numUSReductionParticulier) { #region declaration crlUSReductionParticulier reductionParticulier = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalUSCategorieBillet serviceUSCategorieBillet = new ImplDalUSCategorieBillet(); #endregion #region implementation if (numUSReductionParticulier != "") { this.strCommande = "SELECT * FROM `usreductionparticulier` WHERE"; this.strCommande += " usreductionparticulier.numUSReductionParticulier = '" + numUSReductionParticulier + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { reductionParticulier = new crlUSReductionParticulier(); reductionParticulier.NumCategorieBillet = this.reader["numCategorieBillet"].ToString(); reductionParticulier.NumIndividu = this.reader["numIndividu"].ToString(); reductionParticulier.NumEtablissementScolaire = this.reader["numEtablissementScolaire"].ToString(); reductionParticulier.NumSociete = this.reader["numSociete"].ToString(); reductionParticulier.NumUSReductionParticulier = this.reader["numUSReductionParticulier"].ToString(); reductionParticulier.ImageReductionParticulier = this.reader["imageReductionParticulier"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (reductionParticulier != null) { if (reductionParticulier.NumIndividu != "") { reductionParticulier.individu = serviceIndividu.selectIndividu(reductionParticulier.NumIndividu); } if (reductionParticulier.NumCategorieBillet != "") { reductionParticulier.categorieBillet = serviceUSCategorieBillet.selectUSCategorieBillet(reductionParticulier.NumCategorieBillet); } } } #endregion return(reductionParticulier); }
List <crlVoyage> IntfDalFicheBord.getVoyage(string numerosFB) { #region declaration List <crlVoyage> Voyages = new List <crlVoyage>(); crlVoyage tempVoyage = null; IntfDalBagage serviceBagage = new ImplDalBagage(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalBillet serviceBillet = new ImplDalBillet(); IntfDalPlaceFB servicePlaceFB = new ImplDalPlaceFB(); #endregion #region implementation if (numerosFB != "") { this.strCommande = "SELECT * FROM `voyage` WHERE (`numerosFB`='" + numerosFB + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { while (this.reader.Read()) { tempVoyage = new crlVoyage(); tempVoyage.IdVoyage = reader["idVoyage"].ToString(); tempVoyage.NumIndividu = reader["numIndividu"].ToString(); tempVoyage.NumerosFB = reader["numerosFB"].ToString(); try { tempVoyage.PoidBagage = double.Parse(reader["poidBagage"].ToString()); } catch (Exception) {} tempVoyage.Destination = reader["destination"].ToString(); tempVoyage.NumBillet = reader["numBillet"].ToString(); tempVoyage.NumPlace = reader["numPlace"].ToString(); tempVoyage.PieceIdentite = reader["pieceIdentite"].ToString(); Voyages.Add(tempVoyage); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); for (int i = 0; i < Voyages.Count; i++) { if (Voyages[i] != null) { Voyages[i].billet = serviceBillet.selectBillet(Voyages[i].NumBillet); Voyages[i].individu = serviceIndividu.selectIndividu(Voyages[i].NumIndividu); Voyages[i].placeFB = servicePlaceFB.selectPlaceFB(Voyages[i].NumerosFB, Voyages[i].NumPlace); Voyages[i].bagage = serviceBagage.selectBagageForVoyage(Voyages[i].IdVoyage); } } } #endregion return(Voyages); }
string IntfDalIndividu.insertIndividu(crlIndividu Individu, string sigleAgence, HtmlGenericControl divIndication) { #region declaration string strNumIndividuTemp = ""; string numIndividu = ""; string strIndication = ""; crlIndividu individuIndication = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation divIndication.Style.Add("font-size", "14px"); divIndication.Style.Add("color", "Red"); if (Individu != null) { if (Individu.CinIndividu != "") { Individu.NumIndividu = serviceIndividu.isCINIndividu(Individu); if (Individu.NumIndividu.Equals("")) { Individu.NumIndividu = serviceIndividu.insertIndividu(Individu, sigleAgence); if (Individu.NumIndividu != "") { numIndividu = Individu.NumIndividu; } else { strIndication = "Une erreur ce produit durant l'enregistrement!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } else { strNumIndividuTemp = Individu.NumIndividu; Individu.NumIndividu = ""; Individu.NumIndividu = serviceIndividu.isAllIndividu(Individu); if (Individu.NumIndividu.Equals("")) { strIndication = "CIN déjà enregistrer dans la base de données!<br/>"; individuIndication = serviceIndividu.selectIndividu(strNumIndividuTemp); if (individuIndication != null) { strIndication += "Nom:" + individuIndication.NomIndividu + "<br/>"; strIndication += "Prénom:" + individuIndication.PrenomIndividu + "<br/>"; } divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } else { if (serviceIndividu.updateIndividu(Individu)) { numIndividu = Individu.NumIndividu; } else { strIndication = "Une erreur ce produit durant l'enregistrement!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } } } else { Individu.NumIndividu = serviceIndividu.isNotCINIndividu(Individu); if (individuIndication.NumIndividu.Equals("")) { Individu.NumIndividu = serviceIndividu.insertIndividu(Individu, sigleAgence); if (Individu.NumIndividu != "") { numIndividu = Individu.NumIndividu; } else { strIndication = "Une erreur ce produit durant l'enregistrement!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } else { if (serviceIndividu.updateIndividu(Individu)) { numIndividu = Individu.NumIndividu; } else { strIndication = "Une erreur ce produit durant l'enregistrement!"; divIndication.InnerHtml = "<p>" + strIndication + "</p>"; } } } } #endregion return(numIndividu); }
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); }
DataTable IntfDalAbonnement.getDataTableAbonnement(string strRqst) { #region declaration DataTable dataTable = new DataTable(); crlOrganisme organisme = null; crlSociete societe = null; crlIndividu individu = null; IntfDalSociete serviceSociete = new ImplDalSociete(); IntfDalOrganisme serviceOrganisme = new ImplDalOrganisme(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); string telephone = ""; string mobile = ""; #endregion #region implementation #region initialisation du dataTable dataTable = new DataTable(); dataTable.Columns.Add("numAbonnement", typeof(string)); dataTable.Columns.Add("client", typeof(string)); dataTable.Columns.Add("adresse", typeof(string)); dataTable.Columns.Add("contact", typeof(string)); dataTable.Columns.Add("respSociete", typeof(string)); dataTable.Columns.Add("respContact", typeof(string)); DataRow dr; #endregion this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(strRqst); if (this.reader != null) { if (this.reader.HasRows) { while (this.reader.Read()) { dr = dataTable.NewRow(); dr["numAbonnement"] = reader["numAbonnement"].ToString(); if (reader["numIndividu"].ToString() != "") { individu = serviceIndividu.selectIndividu(reader["numIndividu"].ToString()); } if (reader["numOrganisme"].ToString() != "") { organisme = serviceOrganisme.selectOrganisme(reader["numOrganisme"].ToString()); } if (reader["numSociete"].ToString() != "") { societe = serviceSociete.selectSociete(reader["numSociete"].ToString()); } if (individu != null) { dr["client"] = individu.PrenomIndividu + " " + individu.NomIndividu; dr["adresse"] = individu.Adresse; dr["contact"] = individu.TelephoneFixeIndividu + " / " + individu.TelephoneMobileIndividu; dr["respSociete"] = "-"; dr["respContact"] = "-"; } else if (societe != null) { dr["client"] = societe.NomSociete; dr["adresse"] = societe.AdresseSociete; dr["contact"] = societe.TelephoneFixeSociete + " / " + societe.TelephoneMobileSociete; if (societe.individuResponsable != null) { dr["respSociete"] = societe.individuResponsable.PrenomIndividu + " " + societe.individuResponsable.NomIndividu; dr["respContact"] = societe.individuResponsable.TelephoneFixeIndividu + " / " + societe.individuResponsable.TelephoneMobileIndividu; } } else if (organisme != null) { dr["client"] = organisme.NomOrganisme; dr["adresse"] = organisme.AdresseOrganisme; dr["contact"] = organisme.TelephoneFixeOrganisme + " / " + organisme.TelephoneMobileOrganisme; if (organisme.individuResponsable != null) { dr["respSociete"] = organisme.individuResponsable.PrenomIndividu + " " + organisme.individuResponsable.NomIndividu; dr["respContact"] = organisme.individuResponsable.TelephoneFixeIndividu + " / " + organisme.individuResponsable.TelephoneMobileIndividu; } } individu = null; societe = null; organisme = null; dataTable.Rows.Add(dr); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); #endregion return(dataTable); }
crlAbonnement IntfDalAbonnement.selectAbonnement(string numAbonnement) { #region declaration IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalAgent serviceAgent = new ImplDalAgent(); IntfDalOrganisme serviceOrganisme = new ImplDalOrganisme(); IntfDalSociete serviceSociete = new ImplDalSociete(); crlAbonnement Abonnement = null; #endregion #region implementation if (numAbonnement != "") { this.strCommande = "SELECT * FROM `abonnement` WHERE `numAbonnement`='" + numAbonnement + "' OR"; this.strCommande += " `numIndividu`='" + numAbonnement + "' OR `numSociete`='" + numAbonnement + "' OR"; this.strCommande += " `numOrganisme`='" + numAbonnement + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { Abonnement = new crlAbonnement(); if (this.reader.Read()) { Abonnement.NumAbonnement = this.reader["numAbonnement"].ToString(); Abonnement.NumIndividu = this.reader["numIndividu"].ToString(); Abonnement.MatriculeAgent = this.reader["matriculeAgent"].ToString(); Abonnement.NumOrganisme = this.reader["numOrganisme"].ToString(); Abonnement.NumSociete = this.reader["numSociete"].ToString(); try { Abonnement.DateAbonnement = Convert.ToDateTime(this.reader["dateAbonnement"].ToString()); } catch (Exception) { } Abonnement.ImageAbonner = this.reader["imageAbonner"].ToString(); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (Abonnement != null) { if (Abonnement.NumIndividu != "") { Abonnement.individu = serviceIndividu.selectIndividu(Abonnement.NumIndividu); } if (Abonnement.MatriculeAgent != "") { Abonnement.agent = serviceAgent.selectAgent(Abonnement.MatriculeAgent); } if (Abonnement.NumOrganisme != "") { Abonnement.organisme = serviceOrganisme.selectOrganisme(Abonnement.NumOrganisme); } if (Abonnement.NumSociete != "") { Abonnement.societe = serviceSociete.selectSociete(Abonnement.NumSociete); } } } #endregion return(Abonnement); }
crlSociete IntfDalSociete.selectSociete(string numSociete) { #region declaration crlSociete societe = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation if (numSociete != "") { this.strCommande = "SELECT * FROM `societe` WHERE `numSociete`='" + numSociete + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { societe = new crlSociete(); societe.AdresseSociete = this.reader["adresseSociete"].ToString(); societe.NumQuartier = this.reader["numQuartier"].ToString(); societe.MailSociete = this.reader["mailSociete"].ToString(); societe.NomSociete = this.reader["nomSociete"].ToString(); societe.NumSociete = this.reader["numSociete"].ToString(); societe.SecteurActiviteSociete = this.reader["secteurActiviteSociete"].ToString(); societe.TelephoneFixeSociete = this.reader["telephoneFixeSociete"].ToString(); societe.TelephoneMobileSociete = this.reader["telephoneMobileSociete"].ToString(); try { societe.IsReductionUS = int.Parse(this.reader["isReductionUS"].ToString()); } catch (Exception) { } societe.NumIndividuResponsable = this.reader["numIndividuResponsable"].ToString(); try { societe.IsCheque = int.Parse(this.reader["isCheque"].ToString()); } catch (Exception) { } try { societe.IsBonCommande = int.Parse(this.reader["isBonCommande"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (societe != null) { if (societe.NumIndividuResponsable != "") { societe.individuResponsable = serviceIndividu.selectIndividu(societe.NumIndividuResponsable); } } } #endregion return(societe); }
crlEtablissementScolaire IntfDalEtablissementScolaire.selectEtablissementScolaire(string numEtablissementScolaire) { #region declaration crlEtablissementScolaire etablissementScolaire = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); #endregion #region implementation if (numEtablissementScolaire != "") { this.strCommande = "SELECT * FROM `etablissementscolaire` WHERE `numEtablissementScolaire`='" + numEtablissementScolaire + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { etablissementScolaire = new crlEtablissementScolaire(); etablissementScolaire.AdresseEtablissementScolaire = this.reader["adresseEtablissementScolaire"].ToString(); etablissementScolaire.EtablissementScolaire = this.reader["etablissementScolaire"].ToString(); etablissementScolaire.MailEtablissementScolaire = this.reader["mailEtablissementScolaire"].ToString(); etablissementScolaire.NumEtablissementScolaire = this.reader["numEtablissementScolaire"].ToString(); etablissementScolaire.TelephoneFixeEtablissementScolaire = this.reader["telephoneFixeEtablissementScolaire"].ToString(); etablissementScolaire.TelephonePortableEtablissementScolaire = this.reader["telephonePortableEtablissementScolaire"].ToString(); etablissementScolaire.TypeEtablissementScolaire = this.reader["typeEtablissementScolaire"].ToString(); etablissementScolaire.SecteurEtablissementScolaire = this.reader["secteurEtablissementScolaire"].ToString(); etablissementScolaire.NumQuartier = this.reader["numQuartier"].ToString(); etablissementScolaire.NumIndividuResponsable = this.reader["numIndividuResponsable"].ToString(); try { etablissementScolaire.IsCheque = int.Parse(this.reader["isCheque"].ToString()); } catch (Exception) { } try { etablissementScolaire.IsBonCommande = int.Parse(this.reader["isBonCommande"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (etablissementScolaire != null) { if (etablissementScolaire.NumIndividuResponsable != "") { etablissementScolaire.individuResponsable = serviceIndividu.selectIndividu(etablissementScolaire.NumIndividuResponsable); } } } #endregion return(etablissementScolaire); }
crlProprietaire IntfDalProprietaire.selectProprietaire(string numProprietaire) { #region declaration crlProprietaire proprietaire = null; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalTypeProprietaire serviceTypeProprietaire = new ImplDalTypeProprietaire(); IntfDalAgence serviceAgence = new ImplDalAgence(); IntfDalSociete serviceSociete = new ImplDalSociete(); IntfDalOrganisme serviceOrganisme = new ImplDalOrganisme(); #endregion #region implementation if (numProprietaire != "") { this.strCommande = "SELECT * FROM `proprietaire` WHERE (`numProprietaire`='" + numProprietaire + "')"; this.serviceConnection.openConnection(); if (this.serviceConnection.IsConnection) { this.reader = this.serviceConnection.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { proprietaire = new crlProprietaire(); proprietaire.NumProprietaire = this.reader["numProprietaire"].ToString(); proprietaire.NumIndividu = this.reader["numIndividu"].ToString(); proprietaire.NumOrganisme = this.reader["numOrganisme"].ToString(); proprietaire.NumSociete = this.reader["numSociete"].ToString(); proprietaire.TypeProprietaire = this.reader["typeProprietaire"].ToString(); proprietaire.NumAgence = this.reader["numAgence"].ToString(); } } this.reader.Dispose(); } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } if (proprietaire != null) { if (proprietaire.NumIndividu != "") { proprietaire.Individu = serviceIndividu.selectIndividu(proprietaire.NumIndividu); } if (proprietaire.TypeProprietaire != "") { proprietaire.typeProprietaireObj = serviceTypeProprietaire.selectTypeProprietaire(proprietaire.TypeProprietaire); } if (proprietaire.NumAgence != "") { proprietaire.agence = serviceAgence.selectAgence(proprietaire.NumAgence); } if (proprietaire.NumOrganisme != "") { proprietaire.organisme = serviceOrganisme.selectOrganisme(proprietaire.NumOrganisme); } if (proprietaire.NumSociete != "") { proprietaire.societe = serviceSociete.selectSociete(proprietaire.NumSociete); } } } #endregion return(proprietaire); }
crlBillet IntfDalBillet.isValide(string numBillet, string idItineraire) { #region declaration crlBillet Billet = null; IntfDalTrajet serviceTrajet = new ImplDalTrajet(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalAgent serviceAgent = new ImplDalAgent(); IntfDalCalculCategorieBillet serviceCalculCategorieBillet = new ImplDalCalculCategorieBillet(); IntfDalCalculReductionBillet serviceCalculReductionBillet = new ImplDalCalculReductionBillet(); #endregion #region implementation if (numBillet != "") { this.strCommande = "SELECT billet.numBillet, billet.dateDeValidite, billet.numTrajet,"; this.strCommande += " billet.modePaiement, billet.numIndividu, billet.matriculeAgent, billet.prixBillet,"; this.strCommande += " billet.numCalculCategorieBillet, billet.numCalculReductionBillet, billet.dateBillet,"; this.strCommande += " billet.numDureeAbonnement, billet.numVoyageAbonnement, billet.numBilletCommande FROM billet"; this.strCommande += " Left Join voyage ON voyage.numBillet = billet.numBillet"; this.strCommande += " Inner Join trajet ON trajet.numTrajet = billet.numTrajet"; this.strCommande += " Inner Join associationtrajetitineraire ON associationtrajetitineraire.numTrajet = trajet.numTrajet"; this.strCommande += " WHERE voyage.numBillet IS NULL AND"; this.strCommande += " billet.numBillet = '" + numBillet + "' AND"; this.strCommande += " billet.dateDeValidite >= '" + DateTime.Now.ToString("yyyyMMdd") + "' AND"; this.strCommande += " associationtrajetitineraire.idItineraire = '" + idItineraire + "'"; this.serviceConnectBase.openConnection(); reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { Billet = new crlBillet(); Billet.NumBillet = reader["numBillet"].ToString(); Billet.DateDeValidite = Convert.ToDateTime(reader["dateDeValidite"].ToString()); Billet.NumTrajet = reader["numTrajet"].ToString(); Billet.ModePaiement = reader["modePaiement"].ToString(); Billet.NumIndividu = reader["numIndividu"].ToString(); Billet.MatriculeAgent = reader["matriculeAgent"].ToString(); Billet.PrixBillet = reader["prixBillet"].ToString(); Billet.NumCalculCategorieBillet = reader["numCalculCategorieBillet"].ToString(); Billet.NumCalculReductionBillet = reader["numCalculReductionBillet"].ToString(); Billet.DateBillet = Convert.ToDateTime(reader["dateBillet"].ToString()); Billet.NumDureeAbonnement = reader["numDureeAbonnement"].ToString(); Billet.NumVoyageAbonnement = reader["numVoyageAbonnement"].ToString(); Billet.NumBilletCommande = reader["numBilletCommande"].ToString(); } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (Billet != null) { if (Billet.NumTrajet != "") { Billet.trajet = serviceTrajet.selectTrajet(Billet.NumTrajet); } if (Billet.NumIndividu != "") { Billet.individu = serviceIndividu.selectIndividu(Billet.NumIndividu); } if (Billet.MatriculeAgent != "") { Billet.agent = serviceAgent.selectAgent(Billet.MatriculeAgent); } if (Billet.NumCalculCategorieBillet != "") { Billet.calculCategorieBillet = serviceCalculCategorieBillet.selectCalculCategorieBillet(Billet.NumCalculCategorieBillet); } if (Billet.NumCalculReductionBillet != "") { Billet.calculReductionBillet = serviceCalculReductionBillet.selectCalculReductionBillet(Billet.NumCalculReductionBillet); } } } #endregion return(Billet); }
crlBillet IntfDalBillet.selectBillet(string numBillet) { #region declaration crlBillet Billet = null; IntfDalTrajet serviceTrajet = new ImplDalTrajet(); IntfDalIndividu serviceIndividu = new ImplDalIndividu(); IntfDalAgent serviceAgent = new ImplDalAgent(); IntfDalCalculCategorieBillet serviceCalculCategorieBillet = new ImplDalCalculCategorieBillet(); IntfDalCalculReductionBillet serviceCalculReductionBillet = new ImplDalCalculReductionBillet(); #endregion #region implementation if (numBillet != "") { this.strCommande = "SELECT * FROM `billet` WHERE (`numBillet`='" + numBillet + "')"; this.serviceConnectBase.openConnection(); reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { Billet = new crlBillet(); Billet.NumBillet = reader["numBillet"].ToString(); Billet.DateDeValidite = Convert.ToDateTime(reader["dateDeValidite"].ToString()); Billet.NumTrajet = reader["numTrajet"].ToString(); Billet.ModePaiement = reader["modePaiement"].ToString(); Billet.NumIndividu = reader["numIndividu"].ToString(); Billet.MatriculeAgent = reader["matriculeAgent"].ToString(); Billet.PrixBillet = reader["prixBillet"].ToString(); Billet.NumCalculCategorieBillet = reader["numCalculCategorieBillet"].ToString(); Billet.NumCalculReductionBillet = reader["numCalculReductionBillet"].ToString(); Billet.DateBillet = Convert.ToDateTime(reader["dateBillet"].ToString()); Billet.NumDureeAbonnement = reader["numDureeAbonnement"].ToString(); Billet.NumVoyageAbonnement = reader["numVoyageAbonnement"].ToString(); Billet.NumBilletCommande = reader["numBilletCommande"].ToString(); } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); if (Billet != null) { if (Billet.NumTrajet != "") { Billet.trajet = serviceTrajet.selectTrajet(Billet.NumTrajet); } if (Billet.NumIndividu != "") { Billet.individu = serviceIndividu.selectIndividu(Billet.NumIndividu); } if (Billet.MatriculeAgent != "") { Billet.agent = serviceAgent.selectAgent(Billet.MatriculeAgent); } if (Billet.NumCalculCategorieBillet != "") { Billet.calculCategorieBillet = serviceCalculCategorieBillet.selectCalculCategorieBillet(Billet.NumCalculCategorieBillet); } if (Billet.NumCalculReductionBillet != "") { Billet.calculReductionBillet = serviceCalculReductionBillet.selectCalculReductionBillet(Billet.NumCalculReductionBillet); } } } #endregion return(Billet); }