string IntfDalIndividu.insertIndividu(crlIndividu Individu, string sigleAgence) { #region declaration string numIndividu = ""; string numQuartier = "NULL"; int nombreInsert = 0; IntfDalIndividu serviceIndividu = new ImplDalIndividu(); string dateNaissance = "NULL"; #endregion #region implementation if (Individu != null) { if (Individu.NumQuartier != "") { numQuartier = "'" + Individu.NumQuartier + "'"; } if (Individu.DateNaissanceIndividu.Year > 1900) { dateNaissance = "'" + Individu.DateNaissanceIndividu.ToString("yyyy-MM-dd") + "'"; } Individu.NumIndividu = serviceIndividu.getNumIndividu(sigleAgence); this.strCommande = "INSERT INTO `Individu` (`numIndividu`,`civiliteIndividu`,"; this.strCommande += " `nomIndividu`,`prenomIndividu`,`cinIndividu`,`adresse`,"; this.strCommande += " `profession`,`telephoneFixeIndividu`,`telephoneMobileIndividu`,"; this.strCommande += " `dateNaissanceIndividu`,`lieuNaissanceIndividu`,"; this.strCommande += " `mailIndividu`,`numQuartier`,`isCheque`,`isBonCommande`)"; this.strCommande += " VALUES ('" + Individu.NumIndividu + "',"; this.strCommande += " '" + Individu.CiviliteIndividu + "','" + Individu.NomIndividu + "',"; this.strCommande += " '" + Individu.PrenomIndividu + "','" + Individu.CinIndividu + "',"; this.strCommande += " '" + Individu.Adresse + "','" + Individu.Profession + "',"; this.strCommande += " '" + Individu.TelephoneFixeIndividu + "','" + Individu.TelephoneMobileIndividu + "',"; this.strCommande += " " + dateNaissance + ",'" + Individu.LieuNaissanceIndividu + "',"; this.strCommande += " '" + Individu.MailIndividu + "'," + numQuartier + ","; this.strCommande += " '" + Individu.IsCheque + "','" + Individu.IsBonCommande + "')"; this.serviceConnection.openConnection(); if (this.serviceConnection.IsConnection) { nombreInsert = this.serviceConnection.requete(this.strCommande); if (nombreInsert == 1) { numIndividu = Individu.NumIndividu; } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } } #endregion return(numIndividu); }
string IntfDalIndividu.isAllIndividu(crlIndividu Individu) { #region declaration string numIndividu = ""; #endregion #region implementation if (Individu != null) { if (Individu.DateNaissanceIndividu.Year > 1900) { this.strCommande = "SELECT * FROM `Individu` WHERE (`numIndividu` <> '" + Individu.NumIndividu + "') AND"; this.strCommande += " (Individu.nomIndividu = '" + Individu.NomIndividu + "' AND"; this.strCommande += " Individu.prenomIndividu = '" + Individu.PrenomIndividu + "' AND"; this.strCommande += " Individu.dateNaissanceIndividu = '" + Individu.DateNaissanceIndividu.ToString("yyyy-MM-dd") + "' AND"; this.strCommande += " Individu.lieuNaissanceIndividu = '" + Individu.LieuNaissanceIndividu + "' AND"; this.strCommande += " Individu.civiliteIndividu = '" + Individu.CiviliteIndividu + "' AND"; this.strCommande += " Individu.cinIndividu = '" + Individu.CinIndividu + "')"; } else { this.strCommande = "SELECT * FROM `Individu` WHERE (`numIndividu` <> '" + Individu.NumIndividu + "') AND"; this.strCommande += " (Individu.nomIndividu = '" + Individu.NomIndividu + "' AND"; this.strCommande += " Individu.prenomIndividu = '" + Individu.PrenomIndividu + "' AND"; this.strCommande += " Individu.dateNaissanceIndividu IS NULL AND"; this.strCommande += " Individu.lieuNaissanceIndividu = '" + Individu.LieuNaissanceIndividu + "' AND"; this.strCommande += " Individu.civiliteIndividu = '" + Individu.CiviliteIndividu + "' AND"; this.strCommande += " Individu.cinIndividu = '" + Individu.CinIndividu + "')"; } this.serviceConnection.openConnection(); if (this.serviceConnection.IsConnection) { reader = this.serviceConnection.select(this.strCommande); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { numIndividu = reader["numIndividu"].ToString(); } } reader.Dispose(); } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } } #endregion return(numIndividu); }
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); }
public crlVoyage() { this.NumIndividu = ""; this.IdVoyage = ""; this.NumerosFB = ""; this.NumBillet = ""; this.Destination = ""; this.NumPlace = ""; this.PieceIdentite = ""; this.poidBagage = 0.00; this.bagage = null; this.individu = null; this.billet = null; this.placeFB = null; }
public crlEtablissementScolaire() { this.AdresseEtablissementScolaire = ""; this.EtablissementScolaire = ""; this.MailEtablissementScolaire = ""; this.NumEtablissementScolaire = ""; this.TelephoneFixeEtablissementScolaire = ""; this.TelephonePortableEtablissementScolaire = ""; this.TypeEtablissementScolaire = ""; this.NumQuartier = ""; this.SecteurEtablissementScolaire = ""; this.NumIndividuResponsable = ""; this.IsCheque = -1; this.IsBonCommande = -1; this.individuResponsable = null; }
string IntfDalIndividu.isCINIndividu(crlIndividu Individu) { #region declaration string numIndividu = ""; #endregion #region implementation if (Individu != null) { this.strCommande = "SELECT * FROM `Individu` WHERE `numIndividu` <> '" + Individu.NumIndividu + "' AND"; this.strCommande += " Individu.cinIndividu = '" + Individu.CinIndividu + "'"; this.serviceConnection.openConnection(); if (this.serviceConnection.IsConnection) { reader = this.serviceConnection.select(this.strCommande); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { numIndividu = reader["numIndividu"].ToString(); } } reader.Dispose(); } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } } #endregion return(numIndividu); }
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); }
crlIndividu IntfDalIndividu.selectIndividu(string numIndividu) { #region declaration crlIndividu Individu = null; IntfDalVille serviceVille = new ImplDalVille(); #endregion #region implementation if (numIndividu != "") { this.strCommande = "SELECT * FROM `Individu` WHERE (`numIndividu`='" + numIndividu + "')"; 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()) { Individu = new crlIndividu(); Individu.NumIndividu = this.reader["numIndividu"].ToString(); Individu.CiviliteIndividu = this.reader["civiliteIndividu"].ToString(); Individu.NomIndividu = this.reader["nomIndividu"].ToString(); Individu.PrenomIndividu = this.reader["prenomIndividu"].ToString(); Individu.CinIndividu = this.reader["cinIndividu"].ToString(); Individu.Adresse = this.reader["adresse"].ToString(); Individu.Profession = this.reader["profession"].ToString(); Individu.TelephoneFixeIndividu = this.reader["telephoneFixeIndividu"].ToString(); Individu.TelephoneMobileIndividu = this.reader["telephoneMobileIndividu"].ToString(); try { Individu.DateNaissanceIndividu = Convert.ToDateTime(this.reader["dateNaissanceIndividu"].ToString()); } catch (Exception) { } Individu.LieuNaissanceIndividu = this.reader["lieuNaissanceIndividu"].ToString(); Individu.MailIndividu = this.reader["mailIndividu"].ToString(); Individu.NumQuartier = this.reader["numQuartier"].ToString(); try { Individu.IsCheque = int.Parse(this.reader["isCheque"].ToString()); } catch (Exception) { } try { Individu.IsBonCommande = int.Parse(this.reader["isBonCommande"].ToString()); } catch (Exception) { } } } this.reader.Dispose(); } while (this.serviceConnection.IsConnection) { this.serviceConnection.closeConnection(); } } } #endregion return(Individu); }
bool IntfDalIndividu.updateIndividu(crlIndividu Individu) { #region declaration bool isUpdate = false; int nbUpdate = 0; string dateNaissance = "NULL"; string numQuartier = "NULL"; #endregion #region implementation if (Individu != null) { if (Individu.NumQuartier != "") { numQuartier = "'" + Individu.NumQuartier + "'"; } if (Individu.DateNaissanceIndividu.Year > 1900) { dateNaissance = "'" + Individu.DateNaissanceIndividu.ToString("yyyy-MM-dd") + "'"; } this.strCommande = "UPDATE `Individu` SET `adresse`='" + Individu.Adresse + "',"; this.strCommande += " `cinIndividu`='" + Individu.CinIndividu + "',`civiliteIndividu`='" + Individu.CiviliteIndividu + "',"; this.strCommande += " `nomIndividu`='" + Individu.NomIndividu + "'"; if (Individu.PrenomIndividu != "") { this.strCommande += " ,`prenomIndividu`='" + Individu.PrenomIndividu + "'"; } if (Individu.Profession != "") { this.strCommande += " ,`profession`='" + Individu.Profession + "'"; } if (Individu.TelephoneFixeIndividu != "") { this.strCommande += " ,`telephoneFixeIndividu`='" + Individu.TelephoneFixeIndividu + "'"; } if (Individu.TelephoneMobileIndividu != "") { this.strCommande += " ,`telephoneMobileIndividu`='" + Individu.TelephoneMobileIndividu + "'"; } if (dateNaissance != "") { this.strCommande += " ,`dateNaissanceIndividu`=" + dateNaissance + ""; } if (Individu.LieuNaissanceIndividu != "") { this.strCommande += " ,`lieuNaissanceIndividu`='" + Individu.LieuNaissanceIndividu + "'"; } if (Individu.MailIndividu != "") { this.strCommande += " ,`mailIndividu`='" + Individu.MailIndividu + "'"; } this.strCommande += " ,`numQuartier`=" + numQuartier; if (Individu.IsCheque >= 0) { this.strCommande += " ,`isCheque`='" + Individu.IsCheque + "'"; } if (Individu.IsBonCommande >= 0) { this.strCommande += " ,`isBonCommande`='" + Individu.IsBonCommande + "'"; } this.strCommande += " WHERE `numIndividu`='" + Individu.NumIndividu + "'"; this.serviceConnection.openConnection(); nbUpdate = this.serviceConnection.requete(this.strCommande); if (nbUpdate == 1) { isUpdate = true; } this.serviceConnection.closeConnection(); } #endregion return(isUpdate); }
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); }