protected void bt_Click(object sender, EventArgs e) { if (s != txtpassword.Text) { err.Visible = true; } else { if (txtnommg.Text != "" && txtnomre.Text != "" && txtpassn.Text != "" && txtpassword.Text != "" && txtemail.Text != "") { if (mail == txtemail.Text) { CRUD.Magasin m = new CRUD.Magasin(txtnommg.Text, txtnomre.Text, txtemail.Text, txtpassn.Text, 1); int x = CRUD.DAL.updateM(id, m); Session["username"] = txtnomre.Text; mg.Visible = true; } else { CRUD.Magasin m = new CRUD.Magasin(txtnommg.Text, txtnomre.Text, txtemail.Text, txtpassn.Text, 1); int x = CRUD.DAL.updateM(id, m); Session["username"] = txtnomre.Text; try { String meg = " <html> body><h3>Bienvenue " + txtnomre.Text + "</h3><div align='center'> <img src='https://www.turbopix.fr/i/csbktzjppc.png' width='200'><p>votre information a éte modifier avec succée </p> </div></body></html> "; MailMessage message = new MailMessage(); message.To.Add(new MailAddress(txtemail.Text)); message.From = new MailAddress("*****@*****.**"); message.Subject = "activation du compte"; message.IsBodyHtml = true; message.Body = meg; SmtpClient client = new SmtpClient("smtp.gmail.com", 587); client.EnableSsl = true; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "13432196"); client.Send(message); } catch (Exception ex) { } mg.Visible = true; } } else { err2.Visible = true; } } }
public static int updateM(int id, Magasin m) { SqlConnection cnn = Connection.GetConnection(); cnn.Open(); String ch = "UPDATE Magasin SET Nom = @Nom, NomResponsable =@EtatAnnonce, EmailResponsable=@TypeAnnonce, PWResponsable=@Quantite, text=@DateExpirationProduit where id=@id"; SqlCommand cmd = new SqlCommand(ch, cnn); cmd.Parameters.Add("@Nom", SqlDbType.NVarChar).Value = m.Nom; cmd.Parameters.Add("EtatAnnonce", SqlDbType.NVarChar).Value = m.NomResponsable; cmd.Parameters.Add("TypeAnnonce", SqlDbType.NVarChar).Value = m.EmailResponsable; cmd.Parameters.Add("Quantite", SqlDbType.NVarChar).Value = m.PWResponsable; cmd.Parameters.Add("DateExpirationProduit", SqlDbType.Int).Value = m.text; cmd.Parameters.Add("id", SqlDbType.Int).Value = id; int i = cmd.ExecuteNonQuery(); cnn.Close(); return(i); }