using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net.Mail;
using System.Data.OleDb;
using System.Drawing;

public partial class SondageGPD : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnEnvoyer_Click(object sender, EventArgs e)
    {
        if (!DescTXT())
        {
            
        }
        else
        {


            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
                                    @"Data Source=|DataDirectory|\SondageGPD.mdb;" +
                                    @"Jet OLEDB:Database Password=;";
            try
            {
                conn.Open();

                string strSql = "INSERT INTO FormulaireGPD(CandNom, CandPrenom, CandAdresse, CandVille, CandProv, CandCodePostal, CandTel, CandCourriel, CandSiteWeb, PropNom, PropPrenom, PropAdresse, PropVille, PropProv, PorpCodePostal, PropTel, PropCourriel, PropSiteWeb, Explication, Catg1, Catg2, Catg3, Catg4, Catg5, Catg6, Catg7, Catg8, Catg9, Catg10, Catg11, Catg12, Catg13, Catg14, Catg15, Catg16, Catg17, Catg18, Catg19, Catg20) VALUES (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39)";

                OleDbCommand command = new OleDbCommand(strSql, conn);

                OleDbParameter p1 = command.Parameters.Add("@p1", OleDbType.VarChar);
                p1.Value = txtCandNom.Text;
                OleDbParameter p2 = command.Parameters.Add("@p2", OleDbType.VarChar);
                p2.Value = txtCandPrenom.Text;
                OleDbParameter p3 = command.Parameters.Add("@p3", OleDbType.VarChar);
                p3.Value = txtCandAdresse.Text;
                OleDbParameter p4 = command.Parameters.Add("@p4", OleDbType.VarChar);
                p4.Value = txtCandVille.Text;
                OleDbParameter p5 = command.Parameters.Add("@p5", OleDbType.VarChar);
                p5.Value = txtCandProv.Text;
                OleDbParameter p6 = command.Parameters.Add("@p6", OleDbType.VarChar);
                p6.Value = txtCandCodePostal.Text;
                OleDbParameter p7 = command.Parameters.Add("@p7", OleDbType.VarChar);
                p7.Value = txtCandTel.Text;
                OleDbParameter p8 = command.Parameters.Add("@p8", OleDbType.VarChar);
                p8.Value = txtCandCourriel.Text;
                OleDbParameter p9 = command.Parameters.Add("@p9", OleDbType.VarChar);
                p9.Value = txtCandSiteWeb.Text;
                OleDbParameter p10 = command.Parameters.Add("@p10", OleDbType.VarChar);
                p10.Value = txtPropNom.Text;
                OleDbParameter p11 = command.Parameters.Add("@p11", OleDbType.VarChar);
                p11.Value = txtPropPrenom.Text;
                OleDbParameter p12 = command.Parameters.Add("@p12", OleDbType.VarChar);
                p12.Value = txtPropAdresse.Text;
                OleDbParameter p13 = command.Parameters.Add("@p13", OleDbType.VarChar);
                p13.Value = txtPropVille.Text;
                OleDbParameter p14 = command.Parameters.Add("@p14", OleDbType.VarChar);
                p14.Value = txtPropProv.Text;
                OleDbParameter p15 = command.Parameters.Add("@p15", OleDbType.VarChar);
                p15.Value = txtPropCodePostal.Text;
                OleDbParameter p16 = command.Parameters.Add("@p16", OleDbType.VarChar);
                p16.Value = txtPropTel.Text;
                OleDbParameter p17 = command.Parameters.Add("@p17", OleDbType.VarChar);
                p17.Value = txtPropCourriel.Text;
                OleDbParameter p18 = command.Parameters.Add("@p18", OleDbType.VarChar);
                p18.Value = txtPropSiteWeb.Text;
                OleDbParameter p19 = command.Parameters.Add("@p19", OleDbType.VarChar);
                p19.Value = txtExplication.Text;
                OleDbParameter p20 = command.Parameters.Add("@p20", OleDbType.Boolean);
                p20.Value = lstcchCatg.Items[0].Selected;
                OleDbParameter p21 = command.Parameters.Add("@p21", OleDbType.Boolean);
                p21.Value = lstcchCatg.Items[1].Selected;
                OleDbParameter p22 = command.Parameters.Add("@p22", OleDbType.Boolean);
                p22.Value = lstcchCatg.Items[2].Selected;
                OleDbParameter p23 = command.Parameters.Add("@p23", OleDbType.Boolean);
                p23.Value = lstcchCatg.Items[3].Selected;
                OleDbParameter p24 = command.Parameters.Add("@p24", OleDbType.Boolean);
                p24.Value = lstcchCatg.Items[4].Selected.ToString();
                OleDbParameter p25 = command.Parameters.Add("@p25", OleDbType.Boolean);
                p25.Value = lstcchCatg.Items[5].Selected;
                OleDbParameter p26 = command.Parameters.Add("@p26", OleDbType.Boolean);
                p26.Value = lstcchCatg.Items[6].Selected;
                OleDbParameter p27 = command.Parameters.Add("@p27", OleDbType.Boolean);
                p27.Value = lstcchCatg.Items[7].Selected;
                OleDbParameter p28 = command.Parameters.Add("@p28", OleDbType.Boolean);
                p28.Value = lstcchCatg.Items[8].Selected;
                OleDbParameter p29 = command.Parameters.Add("@p29", OleDbType.Boolean);
                p29.Value = lstcchCatg.Items[9].Selected;
                OleDbParameter p30 = command.Parameters.Add("@p30", OleDbType.Boolean);
                p30.Value = lstcchCatg.Items[10].Selected;
                OleDbParameter p31 = command.Parameters.Add("@p31", OleDbType.Boolean);
                p31.Value = lstcchCatg.Items[11].Selected;
                OleDbParameter p32 = command.Parameters.Add("@p32", OleDbType.Boolean);
                p32.Value = lstcchCatg.Items[12].Selected;
                OleDbParameter p33 = command.Parameters.Add("@p33", OleDbType.Boolean);
                p33.Value = lstcchCatg.Items[13].Selected;
                OleDbParameter p34 = command.Parameters.Add("@p34", OleDbType.Boolean);
                p34.Value = lstcchCatg.Items[14].Selected;
                OleDbParameter p35 = command.Parameters.Add("@p35", OleDbType.Boolean);
                p35.Value = lstcchCatg.Items[15].Selected;
                OleDbParameter p36 = command.Parameters.Add("@p36", OleDbType.Boolean);
                p36.Value = lstcchCatg.Items[16].Selected;
                OleDbParameter p37 = command.Parameters.Add("@p37", OleDbType.Boolean);
                p37.Value = lstcchCatg.Items[17].Selected;
                OleDbParameter p38 = command.Parameters.Add("@p38", OleDbType.Boolean);
                p38.Value = lstcchCatg.Items[18].Selected;
                OleDbParameter p39 = command.Parameters.Add("@p39", OleDbType.Boolean);
                p39.Value = lstcchCatg.Items[19].Selected;

                command.ExecuteNonQuery();
            }
            finally
            {
                conn.Close();
            }

            MailMessage message = new MailMessage();


            message.From = new System.Net.Mail.MailAddress("grandsprixdesjardins@culturelanaudiere.qc.ca");
            message.To.Add("grandsprixdesjardins@culturelanaudiere.qc.ca");
            message.Subject = "Inscription - Grands Prix Desjardins";
            message.IsBodyHtml = true;

            message.Body = "<p><strong>Candidat</strong></p>";
            message.Body += "Nom : " + HTMLRestriction(txtCandNom.Text) + "<br/>";
            message.Body += "Pr&eacute;nom : " + HTMLRestriction(txtCandPrenom.Text) + "<br/>";
            message.Body += "Adresse : " + HTMLRestriction(txtCandAdresse.Text) + "<br/>";
            message.Body += "Ville : " + HTMLRestriction(txtCandVille.Text) + "<br/>";
            message.Body += "Province: " + HTMLRestriction(txtCandVille.Text) + "<br/>";
            message.Body += "Code postal : " + HTMLRestriction(txtCandCodePostal.Text) + "<br/>";
            message.Body += "T&eacute;l&eacute;phone : " + HTMLRestriction(txtCandTel.Text) + "<br/>";
            message.Body += "Courriel : " + HTMLRestriction(txtCandCourriel.Text) + "<br/>";
            message.Body += "Site Web : " + HTMLRestriction(txtCandSiteWeb.Text) + "<br/>";
            message.Body += "<br />";

            message.Body += "<p><strong>Proposeur</strong></p>";
            message.Body += "Nom : " + HTMLRestriction(txtPropNom.Text) + "<br/>";
            message.Body += "Pr&eacute;nom : " + HTMLRestriction(txtPropPrenom.Text) + "<br/>";
            message.Body += "Adresse : " + HTMLRestriction(txtPropAdresse.Text) + "<br/>";
            message.Body += "Ville : " + HTMLRestriction(txtPropVille.Text) + "<br/>";
            message.Body += "Province : " + HTMLRestriction(txtPropProv.Text) + "<br/>";
            message.Body += "Code postal : " + HTMLRestriction(txtPropCodePostal.Text) + "<br/>";
            message.Body += "T&eacute;l&eacute;phone : " + HTMLRestriction(txtPropTel.Text) + "<br/>";
            message.Body += "Courriel : " + HTMLRestriction(txtPropCourriel.Text) + "<br/>";
            message.Body += "Site Web : " + HTMLRestriction(txtPropSiteWeb.Text) + "<br/>";
            message.Body += "<br />";

            message.Body += "<p><strong>Explication : </strong></p>";
            message.Body += HTMLRestriction(txtExplication.Text);
            message.Body += "<br />";

            message.Body += "<p><strong>Cat&eacute;gories : </strong></p>";
            foreach (ListItem cch in lstcchCatg.Items)
            {
                if (cch.Selected)
                {
                    message.Body += cch.Text + "<br />";
                }
            }


            System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("mail.culturelanaudiere.qc.ca");
			
            smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;

            smtp.Send(message);

            Response.Redirect("http://www.culturelanaudiere.qc.ca/Services/SondageGPDmerci.aspx");
        }
    }

    protected bool DescTXT()
    {
        if (txtExplication.Text.Length > 1500)
        {
            return false;
        }
        else return true;
    }

    protected void txtExplication_TextChanged(object sender, EventArgs e)
    {
        if (txtExplication.Text.Length > 1500)
        {
            lblNB.Text = txtExplication.Text.Length.ToString();
            lblNB.ForeColor = Color.Red;
            Label1.Visible = true;
        }
        else
        {
            lblNB.Text = txtExplication.Text.Length.ToString();
            lblNB.ForeColor = Color.Black;
            Label1.Visible = false;
        }
    }
	
	private string HTMLRestriction(string texte)
	{
		texte = texte.Replace("é", "&eacute;");
		texte = texte.Replace("É", "&Eacute;");
		texte = texte.Replace("è", "&egrave;");
		texte = texte.Replace("È", "&Egrave;");
		texte = texte.Replace("ù", "&ugrave;");
		texte = texte.Replace("Ù", "&Ugrave;");
		texte = texte.Replace("û", "&ucirc;");
		texte = texte.Replace("Û", "&Ucirc;");
		texte = texte.Replace("à", "&agrave;");
		texte = texte.Replace("À", "&Agrave;");
		texte = texte.Replace("ç", "&ccedil;");
		texte = texte.Replace("Ç", "&Ccedil;");
		texte = texte.Replace("ê", "&ecirc;");
		texte = texte.Replace("Ê", "&Ecirc;");
		texte = texte.Replace("ë", "&euml;");
		texte = texte.Replace("Ë", "&Euml;");
		texte = texte.Replace("•", "&#9679;");

		return texte;
	}

}