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);
}
