Exemple #1
0
        void IntfDalCooperative.insertToGridCooperative(GridView gridView, string param, string paramLike, string valueLike)
        {
            #region declaration
            IntfDalCooperative serviceCooperative = new ImplDalCooperative();
            #endregion

            #region implementation
            this.strCommande  = "SELECT cooperative.numCooperative, cooperative.nomCooperative,";
            this.strCommande += " cooperative.sigleCooperative,cooperative.adresseCooperative,";
            this.strCommande += " cooperative.zone, cooperative.prenomResponsable,";
            this.strCommande += " cooperative.nomResponsable FROM cooperative";
            this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
            this.strCommande += " ORDER BY " + param;

            gridView.DataSource = serviceCooperative.getDataTableCooperative(this.strCommande);
            gridView.DataBind();
            #endregion
        }
Exemple #2
0
        string IntfDalCooperative.insertCooperative(crlCooperative cooperative, string sigleAgence)
        {
            #region decalration
            string             numCooperative     = "";
            int                nombreInsert       = 0;
            IntfDalCooperative serviceCooperative = new ImplDalCooperative();
            #endregion

            #region implementation
            if (cooperative != null && sigleAgence != "")
            {
                cooperative.NumCooperative = serviceCooperative.getNumCooperative(sigleAgence);
                this.strCommande           = "INSERT INTO `cooperative` (`numCooperative`, `nomCooperative`,";
                this.strCommande          += " `sigleCooperative`,`adresseCooperative`, `zone`,`telephoneFixeCooperative`,";
                this.strCommande          += " `telephoneMobileCooperative`,`numVille`,`nomResponsable`,`prenomResponsable`,";
                this.strCommande          += " `cinResponsable`,`adressseResponsable`,`telephoneFixeResponsable`,";
                this.strCommande          += " `telephoneMobileResponsable`) VALUES";
                this.strCommande          += " ('" + cooperative.NumCooperative + "','" + cooperative.NomCooperative + "',";
                this.strCommande          += " '" + cooperative.SigleCooperative + "','" + cooperative.AdresseCooperative + "',";
                this.strCommande          += " '" + cooperative.Zone + "','" + cooperative.TelephoneFixeCooperative + "',";
                this.strCommande          += " '" + cooperative.TelephoneMobileCooperative + "','" + cooperative.NumVille + "',";
                this.strCommande          += " '" + cooperative.NomResponsable + "','" + cooperative.PrenomResponsable + "',";
                this.strCommande          += " '" + cooperative.CinResponsable + "','" + cooperative.AdressseResponsable + "',";
                this.strCommande          += " '" + cooperative.TelephoneFixeResponsable + "','" + cooperative.TelephoneMobileResponsable + "')";

                this.serviceConnection.openConnection();
                nombreInsert = this.serviceConnection.requete(this.strCommande);
                if (nombreInsert == 1)
                {
                    numCooperative = cooperative.NumCooperative;
                }
                this.serviceConnection.closeConnection();
            }
            #endregion

            return(numCooperative);
        }
Exemple #3
0
        crlLicence IntfDalLicence.selectLicence(string numLicence)
        {
            #region declaration
            IntfDalLicence serviceLicence = new ImplDalLicence();

            List <crlItineraire> Itineraires = null;
            crlLicence           Licence     = null;

            IntfDalCooperative serviceCooperative = new ImplDalCooperative();
            IntfDalZone        serviceZone        = new ImplDalZone();
            IntfDalVehicule    serviceVehicule    = new ImplDalVehicule();
            #endregion

            #region implementation
            if (numLicence != "")
            {
                Itineraires      = serviceLicence.selectItineraire(numLicence);
                this.strCommande = "SELECT * FROM licence WHERE (licence.numLicence = '" + numLicence + "')";

                this.serviceConnectBase.openConnection();
                reader = this.serviceConnectBase.select(this.strCommande);
                if (reader != null)
                {
                    if (reader.HasRows)
                    {
                        if (reader.Read())
                        {
                            Licence = new crlLicence();

                            Licence.NumLicence     = reader["numLicence"].ToString();
                            Licence.NumerosLicence = reader["numerosLicence"].ToString();
                            Licence.Zone           = reader["zone"].ToString();
                            Licence.NumCooperative = reader["numCooperative"].ToString();
                            Licence.NumVehicule    = reader["numVehicule"].ToString();
                            try
                            {
                                Licence.DatePremiereMiseCiculation = Convert.ToDateTime(reader["datePremiereMiseCiculation"].ToString());
                            }
                            catch (Exception) { }
                            try
                            {
                                Licence.DatePremiereExploitation = Convert.ToDateTime(reader["datePremiereExploitation"].ToString());
                            }
                            catch (Exception) { }

                            try
                            {
                                Licence.ValideAu = Convert.ToDateTime(reader["valideAu"].ToString());
                            }
                            catch (Exception)
                            {
                            }
                            try
                            {
                                Licence.ValideDu = Convert.ToDateTime(reader["valideDu"].ToString());
                            }
                            catch (Exception)
                            {
                            }
                            try
                            {
                                Licence.NombrePlacePayante = int.Parse(reader["nombrePlacePayante"].ToString());
                            }
                            catch (Exception)
                            {
                            }
                            try
                            {
                                Licence.IsProvisoire = int.Parse(reader["isProvisoire"].ToString());
                            }
                            catch (Exception)
                            {
                            }
                        }
                    }
                    reader.Dispose();
                }
                this.serviceConnectBase.closeConnection();
                if (Licence != null)
                {
                    if (Licence.Zone != "")
                    {
                        Licence.zoneObj = serviceZone.selectZone(Licence.Zone);
                    }
                    if (Licence.NumCooperative != "")
                    {
                        Licence.cooperative = serviceCooperative.selectCooperative(Licence.NumCooperative);
                    }
                    if (Licence.NumVehicule != "")
                    {
                        Licence.vehicule = serviceVehicule.selectVehicule(Licence.NumVehicule);
                    }
                    Licence.itineraires = serviceLicence.selectItineraire(Licence.NumLicence);
                }
            }
            #endregion

            return(Licence);
        }