Beispiel #1
0
        string IntfDalUSArret.insertUSArret(crlUSArret arret, string sigleAgence)
        {
            #region declaration
            string         numArret       = "";
            IntfDalUSArret serviceUSArret = new ImplDalUSArret();
            int            nbInsert       = 0;
            #endregion

            #region implemenation
            if (arret != null && sigleAgence != "")
            {
                arret.NumArret    = serviceUSArret.getNumUSArret(sigleAgence);
                this.strCommande  = "INSERT INTO `usarret` (`numArret`,`numLieu`,`nomArret`,`descriptionArret`)";
                this.strCommande += " VALUES ('" + arret.NumArret + "','" + arret.NumLieu + "','" + arret.NomArret + "',";
                this.strCommande += " '" + arret.DescriptionArret + "')";

                this.serviceConnectBase.openConnection();
                nbInsert = this.serviceConnectBase.requete(this.strCommande);
                if (nbInsert == 1)
                {
                    numArret = arret.NomArret;
                }
                this.serviceConnectBase.closeConnection();
            }
            #endregion

            return(numArret);
        }
Beispiel #2
0
        bool IntfDalUSArret.updateUSArret(crlUSArret arret)
        {
            #region declaration
            bool isUpdate = false;
            int  nbUpdate = 0;
            #endregion

            #region implementation
            if (arret != null)
            {
                this.strCommande  = "UPDATE `usarret` SET `numLieu`='" + arret.NumLieu + "',";
                this.strCommande += " `nomArret`='" + arret.NomArret + "',";
                this.strCommande += " `descriptionArret`='" + arret.DescriptionArret + "' WHERE";
                this.strCommande += " `numArret`='" + arret.NumArret + "'";

                this.serviceConnectBase.openConnection();
                nbUpdate = this.serviceConnectBase.requete(this.strCommande);
                if (nbUpdate == 1)
                {
                    isUpdate = true;
                }
                this.serviceConnectBase.closeConnection();
            }
            #endregion

            return(isUpdate);
        }
Beispiel #3
0
        crlUSArret IntfDalUSArret.selectUSArret(string numArret)
        {
            #region declaration
            crlUSArret arret = null;

            #endregion

            #region implementation
            if (numArret != "")
            {
                this.strCommande = "SELECT * FROM `usarret` WHERE (`numArret`='" + numArret + "')";

                this.serviceConnectBase.openConnection();
                this.reader = this.serviceConnectBase.select(this.strCommande);
                if (this.reader != null)
                {
                    if (this.reader.HasRows)
                    {
                        if (this.reader.Read())
                        {
                            arret = new crlUSArret();
                            arret.DescriptionArret = this.reader["descriptionArret"].ToString();
                            arret.NomArret         = this.reader["nomArret"].ToString();
                            arret.NumLieu          = this.reader["numLieu"].ToString();
                            arret.NumArret         = this.reader["numArret"].ToString();
                        }
                    }
                    this.reader.Dispose();
                }
                this.serviceConnectBase.closeConnection();
            }
            #endregion

            return(arret);
        }
Beispiel #4
0
        string IntfDalUSArret.isUSArret(crlUSArret arret)
        {
            #region declaration
            string numArret = "";
            #endregion

            #region implementation
            if (arret != null)
            {
                this.strCommande  = "SELECT * FROM `usarret` WHERE";
                this.strCommande += " `nomArret`='" + arret.NomArret + "' AND";
                this.strCommande += " `numLieu`='" + arret.NumLieu + "' AND";
                this.strCommande += " `numArret`<>'" + arret.NumArret + "'";

                this.serviceConnectBase.openConnection();
                this.reader = this.serviceConnectBase.select(this.strCommande);
                if (this.reader != null)
                {
                    if (this.reader.HasRows)
                    {
                        if (this.reader.Read())
                        {
                            numArret = this.reader["numArret"].ToString();
                        }
                    }
                    this.reader.Dispose();
                }
                this.serviceConnectBase.closeConnection();
            }
            #endregion

            return(numArret);
        }
Beispiel #5
0
        public crlUSTrajet()
        {
            this.NumTrajet      = "";
            this.DistanceTrajet = 0;
            this.DureeTrajet    = "";
            this.NumArretD      = "";
            this.NumArretF      = "";

            this.arretD = null;
            this.arretF = null;
        }
Beispiel #6
0
        public crlUSLigne()
        {
            this.DescriptionLigne = "";
            this.NomLigne         = "";
            this.NumCooperative   = "";
            this.NumLigne         = "";
            this.NumArretD        = "";
            this.NumArretF        = "";
            this.Zone             = "";
            this.NumAxe           = "";

            this.arretD = null;
            this.arretF = null;
        }
Beispiel #7
0
        DataTable IntfDalUSLigne.getDataTableLigne(string strRqst)
        {
            #region declaration
            DataTable   dataTable = new DataTable();
            crlUSArret  arretD    = null;
            crlUSArret  arretF    = null;
            crlUSLieu   lieuD     = null;
            crlUSLieu   lieuF     = null;
            crlQuartier quartierD = null;
            crlQuartier quartierF = null;

            IntfDalUSArret  serviceUSArret  = new ImplDalUSArret();
            IntfDalUSLieu   serviceUSLieu   = new ImplDalUSLieu();
            IntfDalGeneral  serviceGeneral  = new ImplDalGeneral();
            IntfDalQuartier serviceQuartier = new ImplDalQuartier();
            #endregion

            #region implementation

            #region initialisation du dataTable
            dataTable = new DataTable();
            dataTable.Columns.Add("numLigne", typeof(string));
            dataTable.Columns.Add("nomLigne", typeof(string));
            dataTable.Columns.Add("nomCooperative", typeof(string));
            dataTable.Columns.Add("zone", typeof(string));
            dataTable.Columns.Add("trajet", 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["numLigne"]       = reader["numLigne"].ToString();
                        dr["nomLigne"]       = reader["nomLigne"].ToString();
                        dr["nomCooperative"] = reader["nomCooperative"].ToString();
                        dr["zone"]           = reader["zone"].ToString();

                        arretD = serviceUSArret.selectUSArret(this.reader["numArretD"].ToString());
                        arretF = serviceUSArret.selectUSArret(this.reader["numArretF"].ToString());

                        if (arretD != null && arretF != null)
                        {
                            lieuD = serviceUSLieu.selectUSLieu(arretD.NumLieu);
                            lieuF = serviceUSLieu.selectUSLieu(arretF.NumLieu);

                            if (lieuD != null && lieuF != null)
                            {
                                quartierD = serviceQuartier.selectQuartier(lieuD.NumQuartier);
                                quartierF = serviceQuartier.selectQuartier(lieuF.NumQuartier);

                                if (quartierF != null && quartierF != null)
                                {
                                    dr["trajet"] = quartierD.Quartier + "/" + arretD.NomArret + "-" + quartierF.Quartier + "/" + arretF.NomArret;
                                }
                                else
                                {
                                    dr["trajet"] = arretD.NomArret + "-" + arretF.NomArret;
                                }
                            }
                            else
                            {
                                dr["trajet"] = arretD.NomArret + "-" + arretF.NomArret;
                            }
                        }
                        else
                        {
                            dr["trajet"] = this.reader["numArretD"].ToString() + "-" + this.reader["numArretF"].ToString();
                        }


                        dataTable.Rows.Add(dr);
                    }
                }
                this.reader.Dispose();
            }
            this.serviceConnectBase.closeConnection();

            #endregion

            return(dataTable);
        }