1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
| protected void Button1_Click(object sender, EventArgs e)
{
// StringBuilder objets
StringBuilder str = new StringBuilder();
StringBuilder cdate = new StringBuilder();
StringBuilder cnom = new StringBuilder();
StringBuilder cdesc = new StringBuilder();
StringBuilder curgence = new StringBuilder();
// Selection du checkboxes de la GridView controle
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
bool isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
// Les Colonnes
cdate.Append(GridView1.Rows[i].Cells[0].Text);
cnom.Append(GridView1.Rows[i].Cells[1].Text);
curgence.Append(GridView1.Rows[i].Cells[2].Text);
cdesc.Append(GridView1.Rows[i].Cells[3].Text);
str.Append(GridView1.Rows[i].Cells[4].Text);
}
}
//******************************** L'envoi du Mail ********************************//
string mess = "Bonjour (Mr/Mm) (" + cnom.ToString() + ") , Nous avons reçu et traité votre demande avec succès. il s'agit de la demande daté "+ cdate.ToString()+" avec le niveau d'urgence (" + curgence.ToString() + ") ,et la description suivante (" + cdesc.ToString() + ") . ce message est généré automatiquent après l'intervention de L'Equipe Technique . Cordialement ";
MailMessage email = new MailMessage("admi.diff@gmail.com", str.ToString(), "DIFFAZUR Help Desk", mess );
email.IsBodyHtml = false;
NetworkCredential mailAuthentication = new NetworkCredential("admi.diff@gmail.com", "********");
SmtpClient smtpserver = new SmtpClient("smtp.gmail.com", 587);
smtpserver.EnableSsl = true;
smtpserver.UseDefaultCredentials = false;
smtpserver.Credentials = mailAuthentication;
smtpserver.Send(email);
//************************** L'ajout et la Suppression de la ligne séléctionnée *******************//
SqlConnection cn = new SqlConnection(@"Data Source=MOUAD-PC\SQLEXPRESS;Initial Catalog=form;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
SqlCommand cmd1 = new SqlCommand();
cmd.Connection = cn;
cmd1.Connection = cn;
cmd.CommandText = "insert into tdemandes (tdate,tname,turgence,tdescr,temail) values ('" +cdate.ToString()+ "','" + cnom.ToString() + "','" + curgence.ToString() + "','" + cdesc.ToString() + "','" + str.ToString() + "')";
cmd1.CommandText = "delete from siteform where date='"+cdate.ToString()+"'";
cn.Open();
try
{
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
}
catch (Exception )
{
}
cmd.Clone();
cmd1.Clone();
cn.Close();
Response.Redirect("html.htm"); |
Partager