using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Data.SqlClient;
using System.Text;

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

    protected void NouvelIndivu_click(object sender, EventArgs e)
    {
        NouvelIndivu();
    }

    private void NouvelIndivu()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("NouvelleIndividu ", conn);
        command.CommandType = CommandType.StoredProcedure;
        DataTable membreTable = new DataTable();
        DataTable demandeTable = new DataTable();
        DataTable disciplineTable = new DataTable();
        DataTable documentTable = new DataTable();
        DataTable commentaireTable = new DataTable();
        DataTable subventionTable = new DataTable();
        SqlParameter[] parameters = new SqlParameter[24];
        DataSet ds = new DataSet();
        int IndiId = 0;
		int IdenId = 0;
		int InfoId = 0;
		DateTime value_date = DateTime.Now;
		try {
			value_date = Convert.ToDateTime(txtDate.Text,"en-US");
		}
		catch {}
		
        try
        {
            conn.Open();

            parameters[0] = new SqlParameter("Nom", txtNom.Text);

            parameters[1] = new SqlParameter("Prenom", txtPrenom.Text);

            parameters[2] = new SqlParameter("Nom_Artistique", txtNom_Artistique.Text);

            parameters[3] = new SqlParameter("ClassificationId", cmbClassification.SelectedValue);

            parameters[4] = new SqlParameter("Date_Inscription", Convert.ToDateTime(txtDate.Text));

            parameters[5] = new SqlParameter("Groupe", cmbGroupe.SelectedValue);

            parameters[6] = new SqlParameter("Collectif", cmbCollectif.SelectedValue);

            parameters[7] = new SqlParameter("Demarche_Art", txtDA.Text);

            parameters[8] = new SqlParameter("Cv", txtCV.Text);

            parameters[9] = new SqlParameter("Clientele_vise", txtClientele.Text);

            parameters[10] = new SqlParameter("Bourse", txtBudjet.Text);

            parameters[11] = new SqlParameter("Villeid", cmbVille.SelectedValue);

            parameters[12] = new SqlParameter("Adresse", txtAdresse.Text);

            parameters[13] = new SqlParameter("CodePostal", txtCodePostal.Text);

            parameters[14] = new SqlParameter("Telephone1", txtTelephone.Text);

            parameters[15] = new SqlParameter("Poste1", txtPoste1.Text);

            parameters[16] = new SqlParameter("Telephone2", txtTelephone2.Text);

            parameters[17] = new SqlParameter("Poste2", txtPoste2.Text);

            parameters[18] = new SqlParameter("Fax", txtFax.Text);

            parameters[19] = new SqlParameter("Courriel", txtCourriel.Text);

            parameters[20] = new SqlParameter("SiteWeb", txtSiteWeb.Text);

			parameters[21] = new SqlParameter("IndiId", IndiId);
            parameters[21].Direction = ParameterDirection.Output;
			
			parameters[22] = new SqlParameter("IdenId", IdenId);
            parameters[22].Direction = ParameterDirection.Output;
			
			parameters[23] = new SqlParameter("InfoId", InfoId);
            parameters[23].Direction = ParameterDirection.Output;
			
            command.Parameters.AddRange(parameters);

            command.ExecuteNonQuery();
            IndiId = (int)parameters[21].Value;
			IdenId = (int)parameters[22].Value;
			InfoId = (int)parameters[23].Value;
        }
        finally
        {
            conn.Close();
        }
		
		AjouterDiscipline(IndiId);

        AjouterMembre(IdenId);

		AjouterDemande(IndiId);

        AjoutSubventions(InfoId);

        AjoutCommentaire(IndiId);
			
        AjouterDocument(IndiId);

    }

    private void AjouterMembre(int IdenId)
    {
		SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertMembreInd", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[4];
		
		try
        {
            conn.Open();

			parameters[0] = new SqlParameter("IdenId", IdenId);
			
			parameters[1] = new SqlParameter("MembresId", cmbMembre.SelectedValue);

			parameters[2] = new SqlParameter("Nom", txtNomAutre.Text);

			parameters[3] = new SqlParameter("Annee", Convert.ToDateTime(txtAnnee.Text));
			
			command.Parameters.AddRange(parameters);

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

    }

    private void AjouterDocument(int IndiId)
    {
       /* DataClassesDataContext data = new DataClassesDataContext();
        string name = "";
        string content = "";
        Byte[] filebyte;
        System.Data.Linq.Binary buffer;

        if (FileUpload1.HasFile)
        {
            name = System.IO.Path.GetFileName(FileUpload1.FileName);
            content = System.IO.Path.GetExtension(name).ToLower();
            filebyte = FileUpload1.FileBytes;
            buffer = new System.Data.Linq.Binary(filebyte);

            data.InsertDocument(IndiId, name, content, buffer);
        }
        if (FileUpload2.HasFile)
        {
            name = System.IO.Path.GetFileName(FileUpload2.FileName);
            content = System.IO.Path.GetExtension(name).ToLower();
            filebyte = FileUpload2.FileBytes;
            buffer = new System.Data.Linq.Binary(filebyte);

            data.InsertDocument(IndiId, name, content, buffer);
        }
        if (FileUpload3.HasFile)
        {
            name = System.IO.Path.GetFileName(FileUpload3.FileName);
            content = System.IO.Path.GetExtension(name).ToLower();
            filebyte = FileUpload3.FileBytes;
            buffer = new System.Data.Linq.Binary(filebyte);

            data.InsertDocument(IndiId, name, content, buffer);
        }
        if (FileUpload4.HasFile)
        {
            name = System.IO.Path.GetFileName(FileUpload4.FileName);
            content = System.IO.Path.GetExtension(name).ToLower();
            filebyte = FileUpload4.FileBytes;
            buffer = new System.Data.Linq.Binary(filebyte);

            data.InsertDocument(IndiId, name, content, buffer);
        } */

	    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertDocument", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[4];
        string name = "";
        string content = "";
        Byte[] filebyte;
        try
        {
            conn.Open();

            if (FileUpload1.HasFile)
            {
                command.Parameters.Clear();

                name = System.IO.Path.GetFileName(FileUpload1.FileName);
                content = System.IO.Path.GetExtension(name).ToLower();
                filebyte = FileUpload1.FileBytes;
                
                parameters[0] = new SqlParameter("IndividuId", IndiId);
                parameters[1] = new SqlParameter("Name", name);
                parameters[2] = new SqlParameter("Extention", ReturnExtension(content));
                parameters[3] = new SqlParameter("Objects", filebyte);

                command.Parameters.AddRange(parameters);
                command.ExecuteNonQuery();
            }
            if (FileUpload2.HasFile)
            {
                command.Parameters.Clear();

                name = System.IO.Path.GetFileName(FileUpload2.FileName);
                content = System.IO.Path.GetExtension(name).ToLower();
                filebyte = FileUpload2.FileBytes;

                parameters[0] = new SqlParameter("IndividuId", IndiId);
                parameters[1] = new SqlParameter("Name", name);
                parameters[2] = new SqlParameter("Extention", ReturnExtension(content));
                parameters[3] = new SqlParameter("Objects", filebyte);

                command.Parameters.AddRange(parameters);
                command.ExecuteNonQuery();
            }
            if (FileUpload3.HasFile)
            {
                command.Parameters.Clear();

                name = System.IO.Path.GetFileName(FileUpload3.FileName);
                content = System.IO.Path.GetExtension(name).ToLower();
                filebyte = FileUpload3.FileBytes;

                parameters[0] = new SqlParameter("IndividuId", IndiId);
                parameters[1] = new SqlParameter("Name", name);
                parameters[2] = new SqlParameter("Extention", ReturnExtension(content));
                parameters[3] = new SqlParameter("Objects", filebyte);

                command.Parameters.AddRange(parameters);
                command.ExecuteNonQuery();
            }
            if (FileUpload4.HasFile)
            {
                command.Parameters.Clear();

                name = System.IO.Path.GetFileName(FileUpload4.FileName);
                content = System.IO.Path.GetExtension(name).ToLower();
                filebyte = FileUpload4.FileBytes;

                parameters[0] = new SqlParameter("IndividuId", IndiId);
                parameters[1] = new SqlParameter("Name", name);
                parameters[2] = new SqlParameter("Extention", ReturnExtension(content));
                parameters[3] = new SqlParameter("Objects", filebyte);

                command.Parameters.AddRange(parameters);
                command.ExecuteNonQuery();
            }
        }
        finally
        {
            conn.Close();
        }
    }

	
    private void AjouterDiscipline(int IndiId)
    {	
		SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertDisciplineInd", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[2];
		
		try
        {
            conn.Open();
			
			parameters[0] = new SqlParameter("IndividuId", IndiId);
			parameters[1] = new SqlParameter("DisciplineId", cmbMembre.SelectedValue);
			
			command.Parameters.AddRange(parameters);

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

    private void AjouterDemande(int IndiId)
    {
		SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertDemandeInd", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[5];
		
		try
        {
            conn.Open();
		
			command.Parameters.Clear();
			
			if(txtNature1.Text != "") 
			{
			
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Nature", txtNature1.Text);
				parameters[2] = new SqlParameter("Refere_par", txtRefere_par1.Text);
				parameters[3] = new SqlParameter("Refere_a", txtRefere_a1.Text);
				parameters[4] = new SqlParameter("Date_demande", Convert.ToDateTime(txtDateDemande1.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}
			
			if(txtNature2.Text != "") 
			{
				command.Parameters.Clear();
				
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Nature", txtNature2.Text);
				parameters[2] = new SqlParameter("Refere_par", txtRefere_par2.Text);
				parameters[3] = new SqlParameter("Refere_a", txtRefere_a2.Text);
				parameters[4] = new SqlParameter("Date_demande", Convert.ToDateTime(txtDateDemande2.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}
			
			if(txtNature3.Text != "") 
			{
				command.Parameters.Clear();
				
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Nature", txtNature3.Text);
				parameters[2] = new SqlParameter("Refere_par", txtRefere_par3.Text);
				parameters[3] = new SqlParameter("Refere_a", txtRefere_a3.Text);
				parameters[4] = new SqlParameter("Date_demande", Convert.ToDateTime(txtDateDemande3.Text));
				
				command.Parameters.AddRange(parameters);

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

    private void AjoutCommentaire(int IndiId)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertCommentaireInd", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[4];
		
		try
        {
            conn.Open();
			
			command.Parameters.Clear();
			
			if(txtTitre1.Text != "") 
			{
			
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Titre", txtTitre1.Text);
				parameters[2] = new SqlParameter("Contenu", txtContenu1.Text);
				parameters[3] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeCom1.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}
			
			if(txtTitre2.Text != "") 
			{
			
				command.Parameters.Clear();
				
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Titre", txtTitre2.Text);
				parameters[2] = new SqlParameter("Contenu", txtContenu2.Text);
				parameters[3] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeCom2.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}
			
			if(txtTitre3.Text != "") 
			{
			
				command.Parameters.Clear();
				
				parameters[0] = new SqlParameter("Id", IndiId);
				parameters[1] = new SqlParameter("Titre", txtTitre3.Text);
				parameters[2] = new SqlParameter("Contenu", txtContenu3.Text);
				parameters[3] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeCom3.Text));
				
				command.Parameters.AddRange(parameters);

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

    private void AjoutSubventions(int InfoId)
    {
        
		SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DosIndNoPro"].ConnectionString);
        SqlCommand command = new SqlCommand("InsertSubventionInd", conn);
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parameters = new SqlParameter[4];
		
		try
        {
            conn.Open();
			
			command.Parameters.Clear();
		
			
			if (txtMontant1.Text != "")
			{
				parameters[0] = new SqlParameter("Info_IndividusId", InfoId);
				parameters[1] = new SqlParameter("EntrepriseId", cmbEntreprise1.SelectedValue);
				parameters[2] = new SqlParameter("Accepter", cmbAccepter1.SelectedValue);
				parameters[3] = new SqlParameter("Montant", Convert.ToInt32(txtMontant1.Text));
				parameters[4] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeSub1.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}

			if (txtMontant2.Text != "")
			{
				command.Parameters.Clear();
			
				parameters[0] = new SqlParameter("Info_IndividusId", InfoId);
				parameters[1] = new SqlParameter("EntrepriseId", cmbEntreprise2.SelectedValue);
				parameters[2] = new SqlParameter("Accepter", cmbAccepter2.SelectedValue);
				parameters[3] = new SqlParameter("Montant", Convert.ToInt32(txtMontant2.Text));
				parameters[4] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeSub2.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}

			if (txtMontant3.Text != "")
			{
				command.Parameters.Clear();
			
				parameters[0] = new SqlParameter("Info_IndividusId", InfoId);
				parameters[1] = new SqlParameter("EntrepriseId", cmbEntreprise3.SelectedValue);
				parameters[2] = new SqlParameter("Accepter", cmbAccepter3.SelectedValue);
				parameters[3] = new SqlParameter("Montant", Convert.ToInt32(txtMontant3.Text));
				parameters[4] = new SqlParameter("Annee", Convert.ToDateTime(txtAnneeSub3.Text));
				
				command.Parameters.AddRange(parameters);

				command.ExecuteNonQuery();
			}

		}
		finally
        {
            conn.Close();
        }
    }

    private string ReturnExtension(string fileExtension)
    {
        switch (fileExtension)
        {
            case ".htm":
            case ".html":
            case ".log":
                return "text/HTML";
            case ".txt":
                return "text/plain";
            case ".doc":
                return "application/ms-word";
            case ".tiff":
            case ".tif":
                return "image/tiff";
            case ".asf":
                return "video/x-ms-asf";
            case ".avi":
                return "video/avi";
            case ".zip":
                return "application/zip";
            case ".xls":
            case ".csv":
                return "application/vnd.ms-excel";
            case ".gif":
                return "image/gif";
            case ".jpg":
            case "jpeg":
                return "image/jpeg";
            case ".bmp":
                return "image/bmp";
            case ".png":
                return "image/png";
            case ".wav":
                return "audio/wav";
            case ".mp3":
                return "audio/mpeg3";
            case ".mpg":
            case "mpeg":
                return "video/mpeg";
            case ".rtf":
                return "application/rtf";
            case ".asp":
                return "text/asp";
            case ".pdf":
                return "application/pdf";
            case ".fdf":
                return "application/vnd.fdf";
            case ".ppt":
                return "application/mspowerpoint";
            case ".dwg":
                return "image/vnd.dwg";
            case ".msg":
                return "application/msoutlook";
            case ".xml":
            case ".sdxl":
                return "application/xml";
            case ".xdp":
                return "application/vnd.adobe.xdp+xml";
            default:
                return "application/octet-stream";
        }
    }
}