public static PlaceRepository getInstanca() { if (instanca == null) { instanca = new PlaceRepository(); } return instanca; }
public static PlaceRepository getInstanca() { if (instanca == null) { instanca = new PlaceRepository(); } return(instanca); }
public void addRoute(Route route) { try { PlaceRepository pr = PlaceRepository.getInstanca(); db.Routes.InsertOnSubmit(RepositoryUtility.createDALRouteFromRoute(route)); pr.addPlace(route.StartingPoint, route); pr.addPlace(route.Destination, route); db.SubmitChanges(); } catch (Exception) { //TODO saznaj koje su iznimke //iznimka se generira ako se narusi bilo koje pravilo vezano uz primary key ili foreign key. Znači, iznimka se //generira ako se pokuša dodati osoba koja ima JMBAG koji koristi neka druga osoba, zatim ako se pod osoba.sifUloga //stavi neki broj kojeg nema u tablici Uloga, itd.. //return false; } //return true; }
public void updateRoute(Route route) { try { PlaceRepository pr = PlaceRepository.getInstanca(); ResourceRepository rer = ResourceRepository.getInstanca(); CarpoolingDAL.Route oldOne = db.Routes.Single(o => o.idRoute == route.Id); oldOne.name = route.Name; oldOne.path = route.Path.convertToBinary(); oldOne.routeType = route.Type.Id; pr.updatePlace(route.StartingPoint, route); pr.updatePlace(route.Destination, route); db.SubmitChanges(); } catch (Exception) { //return false; } //return true; }
public Route getRouteById(int idRoute) { PlaceRepository pr = PlaceRepository.getInstanca(); CarpoolingDAL.Route rt = new CarpoolingDAL.Route(); Route rrt = new Route(); try { var query = db.Routes.Where(o => o.idRoute == idRoute).First(); rt = query as CarpoolingDAL.Route; rrt.Id = rt.idRoute; rrt.Name = rt.name; rrt.Path.PathDim = rt.path.ToString(); rrt.Type.Id = rt.routeType; rrt.Type.Name = ((db.RouteTypes.Where(o => o.idRouteType == rt.routeType).First()) as CarpoolingDAL.RouteType).name; rrt.Destination = pr.getPlace(idRoute, Place.DESTINATION); rrt.StartingPoint = pr.getPlace(idRoute, Place.STARTING_POINT); } catch (Exception) { rrt = null; } return(rrt); }