/**
  * Loads the user for the given username.
  *
  * This method must return null if the user is not found.
  *
  * @param string $username The username
  *
  * @return UserInterface|null
  */
 public function loadUserByUsername($username)
 {
     $query = "select l.User_Id,l.Password,u.role from login l,user_role u where l.user_role=u.Id and l.User_Id=:username";
     $Db = new Database();
     $Con = $Db->getDbConnection();
     $stmt = $Con->prepare($query);
     $stmt->execute(array(':username' => $username));
     $table = $stmt->fetch();
     if ($table['User_Id'] === null) {
         $message = sprintf('Username or Password Incorrect');
         throw new UsernameNotFoundException($message);
     }
     $user = new Login();
     $user->setUserId($table['User_Id']);
     $user->setPassword($table['Password']);
     $user->setRole($table['role']);
     return $user;
 }
 public function addVehicleAction(Request $request)
 {
     // 1) build the form
     $user = new Vehicle();
     $vehicle = new Vehical();
     $resource = new Resource();
     $form = $this->createForm(VehicleType::class, $user);
     // 2) handle the submit (will only happen on POST)
     $form->handleRequest($request);
     if ($form->isSubmitted() && $form->isValid()) {
         $Db = new Database();
         $Con = $Db->getDbConnection();
         $sql = "INSERT INTO vehical (Vehical_Id,Vehical_Type,Capacity) VALUES (?,?,?)";
         $sql2 = "INSERT INTO resource (Resource_Id,Type) VALUES (?,?)";
         $stmt = $Con->prepare($sql2);
         $stmt->bindValue(1, $user->getVehical());
         $stmt->bindValue(2, "vehicle");
         $stmt->execute();
         $stmt2 = $Con->prepare($sql);
         $stmt2->bindValue(1, $user->getVehical());
         $stmt2->bindValue(2, $user->getVehicalType());
         $stmt2->bindValue(3, $user->getCapacity());
         $stmt2->execute();
         //
         //            $resource->setType("vehicle");
         //            $resource->setResourceId($user->getVehical());
         //
         //            $vehicle ->setVehical($resource);
         //            $vehicle ->setVehicalType($user ->getVehicalType());
         //            $vehicle ->setCapacity($user ->getCapacity());
         //
         //            $em = $this->getDoctrine()->getManager();
         //            $em->persist($resource);
         //            $em->persist($vehicle);
         //            $em->flush();
         // ... do any other work - like send them an email, etc
         // maybe set a "flash" success message for the user
         return $this->redirectToRoute('admin_addVehicle');
     }
     return $this->render('URMSAppBundle:Admin:addVehicle.html.twig', array('form' => $form->createView()));
 }
 public function getVehicleListAction(Request $request)
 {
     $Vrequest = new RequestVehicle();
     $form = $this->createForm(VehicleRequestType::class, $Vrequest);
     $form->handleRequest($request);
     if ($form->isSubmitted() && $form->isValid()) {
         $vehicleType = $Vrequest->getVehicleType();
         $query = "select * from vehical WHERE Vehical_Type = :vehicleType";
         $Db = new Database();
         $Con = $Db->getDbConnection();
         $stmt = $Con->prepare($query);
         $stmt->execute(array(':vehicleType' => $Vrequest->getVehicleType()));
         $new_Vehical = $stmt->fetchAll();
         return $this->render('URMSAppBundle:User:View_Vehical_List.html.twig', array('vehicles' => $new_Vehical));
     }
     return $this->render('URMSAppBundle:User:RequestVehicle.html.twig', array('form' => $form->createView()));
 }