protected void Page_Load(object sender, EventArgs e) { Usagers connecte = (Usagers)Session["usagerConnecte"]; using (MagasinJouetsEntities1 entityArticles = new MagasinJouetsEntities1()) { try { var tousLesSkis = from skis in entityArticles.Skis select skis; this.gridSkis.DataSource = tousLesSkis.ToList(); gridSkis.DataBind(); } catch (EntityDataSourceValidationException exc) { var msg = exc.Message; } } if (connecte.type.ToString() == "e") { } else { } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { using (MagasinJouetsEntities1 magasinSkiEntite = new MagasinJouetsEntities1()) { try { // string mdpEncrypt = EncrypterMdp(); var usagerRes = (from Usagers in magasinSkiEntite.Usagers where Usagers.pseudo.Equals(this.txtUsager.Text) & Usagers.motPasse.Equals(this.txtMdp.Text) select Usagers).FirstOrDefault(); if (usagerRes != null) { Session["usagerConnecte"] = (Usagers)usagerRes; } } catch (EntityDataSourceValidationException exc) { var msg = exc.Message; } } } if (this.SeSouvenir.Checked == true) { Response.Cookies["pseudoVagabones"].Value = this.txtUsager.Text; Response.Cookies["pseudoVagabones"].Expires = DateTime.Now.AddMonths(3); } Response.Redirect(Request.RawUrl); }
protected void btnModifier_Click(object sender, EventArgs e) { Usagers connecte = (Usagers)Session["usagerConnecte"]; try { MagasinJouetsEntities1 monEntite = new MagasinJouetsEntities1(); var usaConnecte = from Usagers in monEntite.Usagers where Usagers.nom == connecte.nom select Usagers; foreach (Usagers u in usaConnecte) { u.pseudo = this.txtPseudo.Text; u.motPasse = EncrypterMdp(this.TextBoxMotPasse.Text); u.nom = this.txtNom.Text; u.prenom = this.txtPrenom.Text; u.type = this.drdType.SelectedValue.ToString(); u.adresse = this.txtAdresse.Text; u.ville = this.txtVille.Text; u.codePostal = this.txtCodeP.Text; u.téléphone = this.txtTelephone.Text; } monEntite.SaveChanges(); } catch (Exception ex) { var message = ex.Message; } }
protected void ButtonEnvoyer_Click(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { //Ajout d'un usager dans la base de données //Entité LINQ MagasinJouetsEntities1 entityUsager = new MagasinJouetsEntities1(); Usagers usagerAjout = new Usagers { pseudo = this.txtPseudo.Text, motPasse = EncrypterMdp(this.TextBoxMotPasse.Text), nom = this.txtNom.Text, prenom = this.txtPrenom.Text, type = this.drdType.SelectedValue.ToString(), adresse = this.txtAdresse.Text, ville = this.txtVille.Text, codePostal = this.txtCodeP.Text, téléphone = this.txtTelephone.Text }; entityUsager.Usagers.Add(usagerAjout); entityUsager.SaveChanges(); this.messagePost.Text = "L'usager a bien été ajouté!"; } }