public function addMissionAction(Request $request)
 {
     $em = $this->getDoctrine()->getEntityManager();
     $mission = new Mission();
     $etablissement = $this->getDoctrine()->getRepository('GenericBundle:Etablissement')->find($request->get('_idetab'));
     $mission->setEtablissement($etablissement);
     $mission->setDescriptif($request->get('_Descriptif'));
     $mission->setProfil($request->get('_Profil'));
     $mission->setTypecontrat($request->get('_TypeContrat'));
     $mission->setDomaine($request->get('_Domaine'));
     $date = new \DateTime();
     $mission->setDate($date);
     $mission->setRemuneration($request->get('_Remuneration'));
     $mission->setHoraire($request->get('_Horaire'));
     $mission->setDatedebut(date_create($request->get('_Datedebut')));
     $mission->setDatefin(date_create($request->get('_Datefin')));
     $mission->setNomcontact($request->get('_NomContact'));
     $mission->setPrenomContact($request->get('_PrenomContact'));
     $mission->setFonctionContact($request->get('_FonctionContact'));
     $mission->setTelContact($request->get('_TelContact'));
     $mission->setEmailContact($request->get('_EmailContact'));
     $mission->setIntitule($request->get('_Intitule'));
     $mission->setEmploi($request->get('_Emploi'));
     $em->persist($mission);
     $em->flush();
     $mission->genererCode();
     $em->flush();
     if ($request->get('formation')) {
         $diffuser = new Diffusion();
         $formation = $this->getDoctrine()->getRepository('GenericBundle:Formation')->find($request->get('formation'));
         $diffuser->setFormation($formation);
         $diffuser->setMission($mission);
         $diffuser->setStatut(5);
         $em->persist($diffuser);
         $em->flush();
     }
     return $this->redirect($this->generateUrl('affiche_etab', array('id' => $etablissement->getId())));
 }