protected void OnCreateLocationClicked(object sender, EventArgs e)
        {
            int clientSelect = clientBox.Active;
            int vehiculeSelect = modeleBox.Active;
            int termeSelect = termeBox.Active;

            ConnectionMySQL conn = new ConnectionMySQL ();
            try{
                if(montantMensuelEntry.Text.Trim(removeSpaces) != "" && kmDepartEntry.Text.Trim(removeSpaces) != "" && kmPermisEntry.Text.Trim(removeSpaces) != "" && surprimeKMEntry.Text.Trim(removeSpaces) != "")
                {
                    conn.InitializeDB(LoginWindow.Uid, LoginWindow.Password);
                    bool reussie = conn.FaireContratDeLocation(NIV[vehiculeSelect].ToString(), IDClient[clientSelect].ToString(),
                                                                kmDepartEntry.Text, kmPermisEntry.Text, surprimeKMEntry.Text,
                                                                montantMensuelEntry.Text, paiementLabel.Text, termesList[termeSelect].ToString());
                    if(reussie){
                        MessageDialog ms = new MessageDialog(this, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok,
                            "Contrat de location fait avec succès.");
                        ms.Run();
                        ms.Destroy();
                    }
                    else if(!reussie){
                        MessageDialog ms = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok,
                            "Il y a eu une erreur!");
                        ms.Run();
                        ms.Destroy();
                    }
                }
                else {
                    MessageDialog ms = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok,
                        "Il semble qu'il manque des informations");
                    ms.Run();
                    ms.Destroy();
                }
            }catch(Exception ex) {
                MessageDialog ms = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok,
                    ex.Message);
                ms.Run();
                ms.Destroy();
            }
        }