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); }
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"; } }
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); } } }
public HttpResponseMessage PutUsager(Usager item) { if (usagers.Update(item)) { return(new HttpResponseMessage(HttpStatusCode.Accepted)); } return(new HttpResponseMessage(HttpStatusCode.BadRequest)); }
public MainViewModel() { Usager = new Usager(""); commandeAnimal = new BaseCommand(LoadAnimal, obj => true); selectControl = this; selectMenu = new Menu(); UpdateCommand = new ConnexionCommande(this); }
public MainViewModel() { usager = new Usager(); connexionCommande = new BaseCommand(LoadAnimalViewModel, obj => true); selectedMenu = new MenuViewModel(); selectedControl = this; }
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); } }
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); }
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); }
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); }
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; }
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); }
/* 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); }
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); }
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; }
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"); } }
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); }
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); }
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); }
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; }
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(); }
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 ) ); } }
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) } }
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); * } */ } }
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 ) ); } }
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..."; } }
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); }