Skip to content
Snippets Groups Projects
DatabaseController.java 2.63 KiB
Newer Older
Rhys Evans's avatar
Rhys Evans committed

//package Team5.SmartTowns.Data;
//
//import Team5.SmartTowns.users.User;
//import Team5.SmartTowns.users.UserRepository;
//import org.springframework.beans.factory.annotation.Autowired;
//import org.springframework.stereotype.Controller;
//import org.springframework.web.bind.annotation.GetMapping;
//import org.springframework.web.servlet.ModelAndView;
//
//import java.util.*;
//@Controller
//public class DatabaseController {
//
//
//    @Autowired
//    private LocationRepository LocationRepository;
//    @Autowired
//    private trailsRepository trailsRepository;
//
//
//    @GetMapping("/trailList")
//    public ModelAndView trailList() {
//        ModelAndView mav1 = new ModelAndView("towns/trailsData");
//        List<trail> trail = trailsRepository.getAllTrails();
//        mav1.addObject("trails", trail);
//        return mav1;
//    }
//    @GetMapping("locationList")
//    public ModelAndView locationList(){
//        ModelAndView mav2 = new ModelAndView("towns/locationData");
//        List<Location> Locations = LocationRepository.getAllLocation();
//        mav2.addObject("location", Locations);
//        return mav2;
//    }
//}
package Team5.SmartTowns.data;
Rhys Nute's avatar
Rhys Nute committed

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.servlet.ModelAndView;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
Rhys Nute's avatar
Rhys Nute committed
import java.util.*;
Gabriel Copat's avatar
Gabriel Copat committed

Rhys Nute's avatar
Rhys Nute committed
@Controller
public class DatabaseController {

Rhys Nute's avatar
Rhys Nute committed
    @Autowired
Gabriel Copat's avatar
Gabriel Copat committed
    private LocationRepository locationRepository;
Rhys Nute's avatar
Rhys Nute committed
    @Autowired
Gabriel Copat's avatar
Gabriel Copat committed
    private TrailsRepository trailsRepository;
Rhys Nute's avatar
Rhys Nute committed
    @GetMapping("/trailList")
    public ModelAndView trailList() {
        ModelAndView mav1 = new ModelAndView("towns/trailsData");
Gabriel Copat's avatar
Gabriel Copat committed
        List<Trail> trail = trailsRepository.getAllTrails();
Rhys Nute's avatar
Rhys Nute committed
        mav1.addObject("trails", trail);
        return mav1;
    }
Rhys Nute's avatar
Rhys Nute committed
    @GetMapping("locationList")
    public ModelAndView locationList(){
        ModelAndView mav2 = new ModelAndView("towns/locationData");
        List<Location> Locations = locationRepository.getAllLocation();
        mav2.addObject("location", Locations);
Rhys Nute's avatar
Rhys Nute committed
        return mav2;
    }
Rhys Evans's avatar
Rhys Evans committed
//    public List<Location> approvedLocations(){
//        List<Location> locations = locationRepository.getAllLocation();
//        List<Location> locationApprovalList;
////		for (int i=0;i<locations.size();i++){
////			location
//        for (Location loc :locations){
//            if (loc.isLocationApproved()) {
//                locationApprovalList.add(loc);
//            }
//        } return locationApprovalList;
//    }
Rhys Nute's avatar
Rhys Nute committed
}