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);
}
