Exemplo n.º 1
0
        public void PutUsagerSucess()
        {
            var controller = new UsagerController();

            int[]  completeSondageInit = { 0, 0 };
            Usager user = new Usager {
                Id = 0, UserName = "******", Mdp = "mdp1", CompleteSondageId = completeSondageInit
            };
            Usager result = controller.GetUsager(0) as Usager;

            Assert.AreEqual(user.Id, result.Id);
            Assert.AreEqual(user.Mdp, result.Mdp);
            Assert.AreEqual(user.CompleteSondageId[0], result.CompleteSondageId[0]);
            Assert.AreEqual(user.CompleteSondageId[1], result.CompleteSondageId[1]);
            Assert.AreEqual(user.UserName, result.UserName);

            user.CompleteSondageId[0] = 1;
            HttpResponseMessage reponse = new HttpResponseMessage(HttpStatusCode.Accepted);

            Assert.AreEqual(reponse.StatusCode, controller.PutUsager(user).StatusCode);

            result = controller.GetUsager(0) as Usager;

            Assert.AreEqual(user.Id, result.Id);
            Assert.AreEqual(user.Mdp, result.Mdp);
            Assert.AreEqual(user.CompleteSondageId[0], result.CompleteSondageId[0]);
            Assert.AreEqual(user.CompleteSondageId[1], result.CompleteSondageId[1]);
            Assert.AreEqual(user.UserName, result.UserName);
        }
Exemplo n.º 2
0
    protected void BTN_CONNECTER_Click(object sender, EventArgs e)
    {
        Usager u = new Usager();

        u.Id_usager = 0;
        u.email     = TXTB_LOGIN.Text.ToString();
        u.mdp       = TXTB_MDP.Text.ToString();

        int       user_verif = u.KnownUser(u.email, u.mdp);
        DataTable dt         = u.selectionProfil(u.email, u.mdp);

        DataRow[] result = dt.Select();
        Session["Usager"] = dt;
        if (user_verif == 0)
        {
            LB_MSG.Text = "Vous n'êtes pas reconnu par le système";
        }
        else
        {
            foreach (DataRow row in result)
            {
                acces = row["acces"].ToString();
            }
            int i_acces = Convert.ToInt32(acces);
            if (i_acces == 0)
            {
                Response.Redirect("Espace_Gestionnaire.aspx");
            }
            else
            {
                Response.Redirect("Espace_Usager.aspx");
            }
        }
    }
    protected void BT_VALIDER_Click(object sender, EventArgs e)
    {
        //est-ce qu'on peut récupérer id_Personne?

        DataTable dt = (DataTable)Session["Usager"];

        //on vérifie que la session existe toujours avant d'afficher la page profil
        if (dt == null)
        {
            Response.Redirect("session.aspx");
        }
        else
        {
            Usager u = new Usager();

            u.email = TXTB_MAIL.Text;
            u.mdp   = TXTB_MDP1.Text;

            Adresse a = new Adresse();
            a.adresse            = TXTB_ADRESSE.Text;
            a.adresse_complement = TXTB_ACOMPLEMENT.Text;
            a.code_postal        = TXTB_CP.Text.ToString();
            a.ville = TXTB_VILLE.Text;
            a.pays  = DDL_PAYS.SelectedItem.Text;

            u.ModifProfil(u, a);

            DataTable newdt = u.selectionProfil(u.email, u.mdp);
            Session["Usager"]   = newdt;
            Session["UserBack"] = newdt;
            Label1.Text         = "La modification a bien été effectuée...";
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        //récupérer Id_Usager
        Usager    u  = new Usager();
        DataTable dt = (DataTable)Session["Usager"];

        foreach (DataRow row in dt.Rows)
        {
            usager = row["Id_Usager"].ToString();
        }
        u.Id_usager = Convert.ToInt32(usager);

        //Emprunt
        PL_EMPRUNT.Visible = false;
        // u.ConsulterEmprunt(u.Id_usager, GV_EMPRUNT);

        //Profil Usager
        //Abonnement
        DataTable infoUsager = u.SelectionInfoUsager(u.Id_usager);

        DataRow[] Usager = infoUsager.Select();
        foreach (DataRow row in Usager)
        {
            TXTB_NOM.Text    = row["Nom"].ToString();
            TXTB_PRENOM.Text = row["Prenom"].ToString();
            TXTB_MAIL.Text   = row["Identifiant"].ToString();
            // TXTB_MDP.Text = row["mdp"].ToString();
            LB_DATEABONNEMENT.Text = row["Date_Abonnement"].ToString();
            LB_TARIF.Text          = row["Tarif"].ToString();
            LB_TYPE.Text           = row["Type"].ToString();
        }
    }
 protected void BTN_RESERVER_Click(object sender, EventArgs e)
 {
     try
     {
         DataTable dt = new DataTable();
         dt = (DataTable)Session["Usager"];
         Usager u        = new Usager();
         int    idUsager = 0;
         foreach (DataRow row in dt.Rows)
         {
             idUsager = int.Parse(row["Id_Usager"].ToString());
             //LB_NOMARTICLE.Text += "<br/> Id_usager : " + idUsager.ToString() + " ---- IdArticle :" + int.Parse(LB_IDARTICLE.Text) + "<br/>";
         }
         if (idUsager != 0)
         {
             string info = u.Reserver(idUsager, int.Parse(LB_IDARTICLE.Text));
             LB_NOMARTICLE.Text  += "<br/>" + info + "<br/>";
             BTN_RESERVER.Visible = false;
             GV_RESERVATION.DataBind();
             GV_ACCEUIL.DataBind();
         }
     }
     catch
     {
         LB_NOMARTICLE.Text += "ERREUR";
     }
 }
Exemplo n.º 6
0
    protected void DDL_GENRE_SelectedIndexChanged(object sender, EventArgs e)
    {
        Usager u = new Usager();

        id_format = Convert.ToInt32(DDL_FORMAT.SelectedValue);
        id_genre  = Convert.ToInt32(DDL_GENRE.SelectedValue);
        if (id_format == 1 && id_genre == 0)
        {
            u.RemplirGrid("SELECT * From [Article],[Format_article],[Genre] WHERE (Id_Article In (SELECT Id_Article From [Exemplaire] WHERE Id_Emprunt=0)) AND([Article].Id_Format=[Format_article].Id_Format) AND ([Article].Id_Genre=[Genre].Id_Genre);", GridView1);
        }
        else
        {
            if (id_format != 1 && id_genre != 0)
            {
                u.RemplirGridGenreFormat(id_genre, id_format, GridView1);
            }
            else if (id_genre == 0 && id_format != 1)
            {
                u.RemplirGrid(id_format, GridView1);
            }
            else
            {
                u.RemplirGridGenre(id_genre, GridView1);
            }
        }
    }
Exemplo n.º 7
0
 public HttpResponseMessage PutUsager(Usager item)
 {
     if (usagers.Update(item))
     {
         return(new HttpResponseMessage(HttpStatusCode.Accepted));
     }
     return(new HttpResponseMessage(HttpStatusCode.BadRequest));
 }
Exemplo n.º 8
0
 public MainViewModel()
 {
     Usager         = new Usager("");
     commandeAnimal = new BaseCommand(LoadAnimal, obj => true);
     selectControl  = this;
     selectMenu     = new Menu();
     UpdateCommand  = new ConnexionCommande(this);
 }
Exemplo n.º 9
0
        public MainViewModel()
        {
            usager = new Usager();

            connexionCommande = new BaseCommand(LoadAnimalViewModel, obj => true);
            selectedMenu      = new MenuViewModel();
            selectedControl   = this;
        }
Exemplo n.º 10
0
 public static void Delete(Usager usager)
 {
     if (ConnexionBD.Instance().EstConnecte())
     {
         ConnexionBD.Instance().ExecuterRequete(
             string.Format("DELETE FROM Usagers WHERE nomUtilisateur = '{0}'", usager.NomUtilisateur));
         DataModelEmploye.Delete(usager as Employe);
     }
 }
Exemplo n.º 11
0
        static Usager ConnexionUsager(HttpClient client, string usagerUrl)
        {
            Console.WriteLine("Entrez votre usager:");

            string username = Console.ReadLine();

            Console.WriteLine("Entrez votre mot de passe:");

            string mdp = Console.ReadLine();

            string login = Base64Encode(username) + ":" + Base64Encode(mdp);

            client.DefaultRequestHeaders.Add("Login", login);

            Usager user = new Usager {
                UserName = username, Mdp = mdp
            };

            string action = "login";

            HttpResponseMessage response = client.PostAsJsonAsync(new Uri(usagerUrl), action).Result;

            if (response.IsSuccessStatusCode)
            {
                Console.WriteLine("Connexion réussie");
            }
            else
            {
                while (response.IsSuccessStatusCode == false)
                {
                    Console.WriteLine("Mauvais identifiant ou mot de passe");

                    Console.WriteLine("Entrez votre usager:");

                    username = Console.ReadLine();

                    Console.WriteLine("Entrez votre mot de passe:");

                    mdp = Console.ReadLine();

                    user.UserName = username;
                    user.Mdp      = mdp;
                    login         = Base64Encode(username) + ":" + Base64Encode(mdp);
                    client.DefaultRequestHeaders.Remove("Login");
                    client.DefaultRequestHeaders.Add("Login", login);
                    response = client.PostAsJsonAsync(new Uri(usagerUrl), action).Result;
                }
                Console.WriteLine("Connexion réussie");
            }

            string responseBody = response.Content.ReadAsStringAsync().Result;

            Usager usager = JsonConvert.DeserializeObject <Usager>(responseBody);

            return(usager);
        }
Exemplo n.º 12
0
        public void TestBusAvancer()
        {
            //A remplir
            Bus target = new Bus(6, 7.5, "GE-BUS", "rouge", "SacDos", posX, posY);

            u = target;
            // Act
            target.Avancer(u);

            // Assert
            Assert.AreNotEqual(43.2, target.PosY);
        }
Exemplo n.º 13
0
        public void PutUsagerFailureBadIndex()
        {
            var controller = new UsagerController();

            int[]  completeSondageInit = { 0, 0 };
            Usager user = new Usager {
                Id = 3, UserName = "******", Mdp = "mdp1", CompleteSondageId = completeSondageInit
            };

            HttpResponseMessage reponse = new HttpResponseMessage(HttpStatusCode.BadRequest);

            Assert.AreEqual(reponse.StatusCode, controller.PutUsager(user).StatusCode);
        }
Exemplo n.º 14
0
 public UsagerDTO(Usager unUsager)
 {
     this.Prenom = unUsager.Prenom;
     this.Nom    = unUsager.Nom;
     //this.Telephone = unUsager.Telephone;
     //this.ListeCarte = unUsager.ListeCarte;
     //this.Courriel = unUsager.Courriel;
     this.Actif = unUsager.Actif;
     //this.Adresse = unUsager.Adresse;
     //this.IdDepartement = unUsager.IdDepartement;
     this.NomUsager  = unUsager.NomUsager;
     this.KeyPadCode = unUsager.KeyPadCode;
     this.Id         = unUsager.Id;
     this.MotDePasse = unUsager.MotDePasse;
 }
Exemplo n.º 15
0
        public static Usager GetUsager(int idUsager)
        {
            Usager usager = null;

            if (ConnexionBD.Instance().EstConnecte())
            {
                string requete = string.Format(
                    "SELECT u.nomUtilisateur, r.role, " +
                    "e.numEmploye, e.numPermis, e.NAS, " +
                    "c.prenom, c.nom, c.numAssuranceMaladie, c.dateNaissance, c.telephone, c.adresse, " +
                    "g.nom genre, p.nom poste " +
                    "FROM Usagers u " +
                    "JOIN Roles r ON u.idRole = r.idRole " +
                    "JOIN Employes e ON u.idEmploye = e.idEmploye " +
                    "JOIN Citoyens c ON e.idCitoyen = c.idCitoyen " +
                    "JOIN Genres g ON g.idGenre = c.idGenre " +
                    "JOIN Postes p ON e.idPoste = p.idPoste " +
                    "WHERE u.idUsager = {0} ",
                    idUsager
                    );

                ConnexionBD.Instance().ExecuterRequete(
                    requete, (MySqlDataReader lecteur) =>
                {
                    usager = new Usager()
                    {
                        NomUtilisateur = lecteur.GetString("nomUtilisateur"),
                        RoleUsager     = (Role)System.Enum.Parse(typeof(Role), lecteur.GetString("role")),

                        NumEmploye = lecteur.GetString("numEmploye"),
                        Poste      = lecteur.GetString("poste"),
                        NumPermis  = lecteur.GetString("numPermis"),
                        NAS        = lecteur.GetString("NAS"),

                        Nom           = lecteur.GetString("nom"),
                        Prenom        = lecteur.GetString("prenom"),
                        AssMaladie    = lecteur.GetString("numAssuranceMaladie"),
                        DateNaissance = (DateTime)lecteur.GetMySqlDateTime("dateNaissance"),
                        Adresse       = lecteur.GetString("adresse"),
                        NumTelephone  = lecteur.GetString("telephone"),
                        Genre         = (Genre)System.Enum.Parse(typeof(Genre), lecteur.GetString("genre"))
                    };
                }
                    );
            }

            return(usager);
        }
Exemplo n.º 16
0
    /* public string EnvoyerMSG()
     * {
     *
     *   try
     *   {
     *       MailMessage mail = new MailMessage("*****@*****.**", mailUser, "Confirmation d'inscription", "Félicitations, vous êtes bien insrit(e)");
     *       mail.IsBodyHtml = true;
     *       SmtpClient client = new SmtpClient("smtp.gmail.com");
     *       client.Send(mail);
     *       return "Merci pour votre inscription.<br/> Vos identifiants de connexion viennent d'être envoyés à votre adresse mail";
     *   }
     *   catch (Exception)
     *   {
     *       return "Une erreur est survenue lors de l'envoi de vos identifiants.<br/>Nous régularisons la situation au meilleur délai.<br/>Merci de votre compréhension.";
     *   }
     * }*/
    #endregion
    #region knownUser-vérifier login & mdp
    public int KnownUser(Usager u)
    {
        cnx = new SqlConnection(str);
        cnx.Open();
        string     sql0 = "SELECT count(*) FROM [Usager] WHERE email=@email";
        SqlCommand cmd0 = new SqlCommand(sql0, cnx);

        cmd0.CommandType = CommandType.Text;
        cmd0.Parameters.AddWithValue("@email", u.email);
        int userExistant = 0;

        userExistant = Convert.ToInt32(cmd0.ExecuteScalar());
        cnx.Close();

        return(userExistant);
    }
Exemplo n.º 17
0
        public void TestBusFreiner()
        {
            //A remplir
            Bus target = new Bus(6, 7.5, "GE-BUS", "rouge", "SacDos", posX, posY);

            u = target;
            // Act
            target.Avancer(u);
            if (target.PosY > 43.2)
            {
                target.Freiner(u);
            }

            // Assert
            Assert.AreEqual(44.2, target.PosY);
        }
Exemplo n.º 18
0
    protected void BTN_RESERVATION_Click(object sender, EventArgs e)
    {
        PL_RESERVATION.Visible = true;
        //récupérer Id_Usager
        Usager    u  = new Usager();
        DataTable dt = (DataTable)Session["Usager"];

        foreach (DataRow row in dt.Rows)
        {
            usager = row["Id_Usager"].ToString();
        }
        u.Id_usager = Convert.ToInt32(usager);
        string sql = @"SELECT* FROM[dbo].[Reservation] as R, [dbo].[Article] as A, [dbo].[Exemplaire] as X
WHERE R.Id_Exemplaire = X.Id_Exemplaire AND X.Id_Article = A.Id_Article And R.Id_Usager = " + u.Id_usager + " ;";

        SqlDataSource3.SelectCommand = sql;
    }
Exemplo n.º 19
0
    protected override void OnInitComplete(EventArgs e)
    {
        base.OnInitComplete(e);
        DataTable dt = (DataTable)Session["Usager"];
        Usager    u  = new Usager();

        DataRow[] result = dt.Select();
        foreach (DataRow row in result)
        {
            acces = row["acces"].ToString();
        }
        int_acces = Convert.ToInt32(acces);
        if (dt == null || int_acces != 0)
        {
            Response.Redirect("Connexion.aspx");
        }
    }
Exemplo n.º 20
0
        public static Usager GetUsager(string nom)
        {
            Usager usager = null;

            if (ConnexionBD.Instance().EstConnecte())
            {
                string requete = string.Format(
                    "SELECT u.nomUtilisateur, r.role, " +
                    "e.numEmploye, e.numPermis, e.NAS, " +
                    "c.prenom, c.nom, c.numAssuranceMaladie, c.dateNaissance, c.telephone, c.adresse " +
                    "FROM Usagers u " +
                    "JOIN Roles r ON u.idRole = r.idRole " +
                    "JOIN Employes e ON u.idEmploye = e.idEmploye " +
                    "JOIN Citoyens c ON e.idCitoyen = c.idCitoyen " +
                    "WHERE nomUtilisateur = '{0}'",
                    nom
                    );

                ConnexionBD.Instance().ExecuterRequete(
                    requete, (MySqlDataReader lecteur) =>
                {
                    usager = new Usager()
                    {
                        NomUtilisateur = lecteur.GetString("nomUtilisateur"),

                        // https://stackoverflow.com/questions/2290262/search-for-a-string-in-enum-and-return-the-enum
                        // Fonctionne, mais case sensitive
                        RoleUsager = (Role)System.Enum.Parse(typeof(Role), lecteur.GetString("role")),

                        NumEmploye    = lecteur.GetString("numEmploye"),
                        NumPermis     = lecteur.GetString("numPermis"),
                        NAS           = lecteur.GetString("NAS"),
                        Prenom        = lecteur.GetString("prenom"),
                        Nom           = lecteur.GetString("nom"),
                        AssMaladie    = lecteur.GetString("numAssuranceMaladie"),
                        DateNaissance = (DateTime)lecteur.GetMySqlDateTime("dateNaissance"),
                        NumTelephone  = lecteur.GetString("telephone"),
                        Adresse       = lecteur.GetString("adresse")
                    };
                }
                    );
            }

            return(usager);
        }
Exemplo n.º 21
0
        public void GetUsagerFailure()
        {
            var controller = new UsagerController();

            List <Usager> usagers = new List <Usager>();

            int[] completeSondageInit = { 0, 0 };
            usagers.Add(new Usager {
                Id = 0, UserName = "******", Mdp = "mdp1", CompleteSondageId = completeSondageInit
            });
            usagers.Add(new Usager {
                Id = 1, UserName = "******", Mdp = "mdp2", CompleteSondageId = completeSondageInit
            });

            Usager result = controller.GetUsager(2) as Usager;

            Assert.AreEqual(null, result);
        }
Exemplo n.º 22
0
        public void LoginUsagerSucess()
        {
            int[]  completeSondageInit = { 0, 0 };
            Usager expectedUser        = new Usager {
                Id = 0, UserName = "******", Mdp = "mdp1", CompleteSondageId = completeSondageInit
            };

            string login = Base64Encode("Jacob") + ":" + Base64Encode("mdp1");

            Mock <UsagerController> chk = new Mock <UsagerController>();

            chk.Setup(x => x.headerValue()).Returns(login);

            OkObjectResult expectedReponse = new OkObjectResult(expectedUser);
            OkObjectResult reponse         = chk.Object.Authenticate("login") as OkObjectResult;

            Assert.AreEqual(expectedReponse.StatusCode, reponse.StatusCode);
        }
Exemplo n.º 23
0
    protected void BTN_UPLOAD_Click(object sender, EventArgs e)
    {
        // Specify the path on the server to
        // save the uploaded file to.
        String savePath = @"C:\inetpub\wwwroot\images\";

        // Before attempting to perform operations
        // on the file, verify that the FileUpload
        // control contains a file.
        if (FileUpload1.HasFile)
        {
            // Get the name of the file to upload.
            fileName = FileUpload1.FileName;

            // Append the name of the file to upload to the path.
            savePath += fileName;

            // Call the SaveAs method to save the
            // uploaded file to the specified path.
            // This example does not perform all
            // the necessary error checking.
            // If a file with the same name
            // already exists in the specified path,
            // the uploaded file overwrites it.
            FileUpload1.SaveAs(savePath);

            // Notify the user of the name of the file
            // was saved under.
            //UploadStatusLabel.Text = "Your file was saved as " + fileName;
        }
        else
        {
            // Notify the user that a file was not uploaded.
            //UploadStatusLabel.Text = "You did not specify a file to upload.";
        }



        Usager u = new Usager();

        u.email = TXTB_MAIL.Text;
    }
Exemplo n.º 24
0
    public void ModifProfil(Usager u, Adresse a)
    {
        cnx = new SqlConnection(str);
        cnx.Open();
        string     sql0 = "SELECT Id_Personne FROM [dbo].[Usager] WHERE email='" + u.email + "'";
        SqlCommand cmd0 = new SqlCommand(sql0, cnx);

        cmd0.CommandType = CommandType.Text;
        int id_personne = Convert.ToInt32(cmd0.ExecuteScalar());

        cnx.Close();

        cnx.Open();
        string     sql3 = "UPDATE [dbo].[Adresse] SET adresse='" + a.adresse + "', adresse_complement='" + a.adresse_complement + "',code_postal='" + a.code_postal + "', ville='" + a.ville + "',pays='" + a.pays + "' WHERE Id_Personne=" + id_personne;
        SqlCommand cmd3 = new SqlCommand(sql3, cnx);

        cmd3.CommandType = CommandType.Text;
        cmd3.ExecuteNonQuery();
        cnx.Close();
    }
Exemplo n.º 25
0
 public static void Post(Usager usager, string motDePasseEncrypte)
 {
     if (ConnexionBD.Instance().EstConnecte())
     {
         DataModelEmploye.Post(usager as Employe);
         ConnexionBD.Instance().ExecuterRequete(
             string.Format(
                 "INSERT INTO Usagers (nomUtilisateur, motDePasse, idEmploye, idRole) " +
                 "VALUES ( " +
                 "   '{0}', " +
                 "   '{1}', " +
                 "   (SELECT idEmploye FROM Employes WHERE NumEmploye = '{2}'), " +
                 "   (SELECT idRole FROM Roles WHERE role = '{3}') " +
                 ")",
                 usager.NomUtilisateur, motDePasseEncrypte,
                 usager.NumEmploye, usager.RoleUsager
                 )
             );
     }
 }
Exemplo n.º 26
0
        public static void AddUsager(Usager usager, string motDePasseHash)
        {
            EtatAvecMessage retour = new EtatAvecMessage();

            if (ConnexionBD.Instance().EstConnecte())
            {
                string requete = string.Format("INSERT INTO Usagers " +
                                               "(idRole, idEmploye, nomUtilisateur, motDePasse) " +
                                               "VALUES (" +
                                               "(SELECT idEmploye FROM Employes WHERE numEmploye = '{0}'," +
                                               "(SELECT idRole FROM Roles WHERE role = '{1}'," +
                                               "'{2}'," +
                                               "'{3}'"
                                               , usager.NumEmploye, usager.RoleUsager.ToString(), usager.NomUtilisateur, motDePasseHash);

                DataModelEmploye.AddEmploye(usager);
                ConnexionBD.Instance().ExecuterRequete(requete);
                // TODO : Recevoir code erreur BD dans cas d'erreur (duplicata)
            }
        }
Exemplo n.º 27
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Usager u = new Usager();
            u.RemplirGrid("SELECT * From [Article],[Format_article],[Genre] WHERE (Id_Article In (SELECT Id_Article From [Exemplaire] WHERE Id_Emprunt=0)) AND([Article].Id_Format=[Format_article].Id_Format) AND ([Article].Id_Genre=[Genre].Id_Genre);", GridView1);

            //DataTable dt =
            u.RecupérerValeurs("SELECT Id_Format,Libelle_Format FROM [Format_article];", DDL_FORMAT);
            // DataRow[] resultUser = dt.Select();//on crée un tableau datarow où on met dt

            /*  foreach (DataRow row in resultUser)
             * {
             *    value = row["Id_Format"].ToString();
             *    libelle_format = row["Libelle_Format"].ToString();
             *    ListItem l = new ListItem(libelle_format,value);
             *    DDL_FORMAT.Items.Add(l);
             * }
             */
        }
    }
Exemplo n.º 28
0
        public static void Put(Usager ancienUsager, Usager nouvelUsager)
        {
            if (ConnexionBD.Instance().EstConnecte())
            {
                ConnexionBD.Instance().ExecuterRequete(
                    string.Format(
                        "UPDATE Usagers " +
                        "SET nomUtilisateur = '{0}', " +
                        "    idRole = (SELECT idRole FROM Roles WHERE role = '{1}') " +
                        "WHERE nomUtilisateur = '{2}' ",
                        nouvelUsager.NomUtilisateur, nouvelUsager.RoleUsager, ancienUsager.NomUtilisateur
                        )
                    );

                ConnexionBD.Instance().ExecuterRequete(
                    string.Format(
                        "UPDATE Employes " +
                        "SET numEmploye = '{0}', numPermis = '{1}', NAS = '{2}', " +
                        "    idPoste = (SELECT idPoste FROM Postes WHERE nom = '{3}') " +
                        "WHERE numEmploye = '{4}'",
                        nouvelUsager.NumEmploye, nouvelUsager.NumPermis,
                        nouvelUsager.NAS, nouvelUsager.Poste,
                        ancienUsager.NumEmploye
                        )
                    );

                ConnexionBD.Instance().ExecuterRequete(
                    string.Format(
                        "UPDATE Citoyens " +
                        "SET prenom = '{0}', nom = '{1}', numAssuranceMaladie = '{2}', dateNaissance = '{3}', telephone = '{4}', adresse = '{5}', " +
                        "    idGenre = (SELECT idGenre FROM Genres WHERE nom = '{6}') " +
                        "WHERE numAssuranceMaladie = '{7}'",
                        nouvelUsager.Prenom, nouvelUsager.Nom,
                        nouvelUsager.AssMaladie, nouvelUsager.DateNaissance,
                        nouvelUsager.NumTelephone, nouvelUsager.Adresse,
                        nouvelUsager.Genre, ancienUsager.AssMaladie
                        )
                    );
            }
        }
Exemplo n.º 29
0
    protected void BTN_VALIDERMDP_Click(object sender, EventArgs e)
    {
        DataTable dt = (DataTable)Session["Usager"];
        Usager    u  = new Usager();

        DataRow[] result = dt.Select();
        foreach (DataRow row in result)
        {
            usager = row["Id_Usager"].ToString();
        }
        u.Id_usager = Convert.ToInt32(usager);

        DataTable infoUsager = u.SelectionInfoUsager(u.Id_usager);

        DataRow[] result_info = infoUsager.Select();
        foreach (DataRow row in result_info)
        {
            mdp = row["mdp"].ToString();
        }

        if (TXTB_ANCIENMDP.Text.ToString() == mdp)
        {
            //enregistrement de nouveau mdp
            u.ModifierMDP(u.Id_usager, TXTB_NEWMDP1.Text.ToString());
            //récupéter la nouvelle session
            DataTable infoUsager1 = u.SelectionInfoUsager(u.Id_usager);
            DataRow[] Usager1     = infoUsager1.Select();
            foreach (DataRow row in Usager1)
            {
                usager = row["Id_Usager"].ToString();
                mdp1   = row["mdp"].ToString();
            }
            LB_MSG.Text = "Votre mot de passe a bien été modifié";
        }
        else
        {
            LB_MSG.Text = "Mot de passe incorrecte. Veuillez réessayer...";
        }
    }
Exemplo n.º 30
0
        public void GetUsagerSucess()
        {
            var controller = new UsagerController();

            List <Usager> usagers = new List <Usager>();

            int[] completeSondageInit = { 0, 0 };
            usagers.Add(new Usager {
                Id = 0, UserName = "******", Mdp = "mdp1", CompleteSondageId = completeSondageInit
            });
            usagers.Add(new Usager {
                Id = 1, UserName = "******", Mdp = "mdp2", CompleteSondageId = completeSondageInit
            });

            Usager result = controller.GetUsager(0) as Usager;

            Assert.AreEqual(usagers[0].Id, result.Id);
            Assert.AreEqual(usagers[0].Mdp, result.Mdp);
            Assert.AreEqual(usagers[0].CompleteSondageId[0], result.CompleteSondageId[0]);
            Assert.AreEqual(usagers[0].CompleteSondageId[1], result.CompleteSondageId[1]);
            Assert.AreEqual(usagers[0].UserName, result.UserName);
        }