public ReadUnit(IConfiguration configuration)
{
var connectionString = configuration.GetConnectionString(CONNECTIONSTRING_KEY);
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException("Connection string missing");
}
_connectionString = connectionString;
_context = new DeliveryServiceDbContext(configuration);
}
public IEnumerable <PointDTO> ListAll()
{
IList <PointDTO> points = new List <PointDTO>();
using (var dbContext = new DeliveryServiceDbContext())
{
points = dbContext.Points.Select(p => new PointDTO()
{
Id = p.Id,
Name = p.Name
}).ToList <PointDTO>();
}
return(points);
}
public void Delete(int pointId)
{
using (var context = new DeliveryServiceDbContext())
{
Point pointEntity = context.Points.Find(pointId);
if (pointEntity != null)
{
context.Entry <Point>(pointEntity).State = EntityState.Deleted;
context.SaveChanges();
}
else
{
throw new ArgumentNullException("pointId", "The referenced point does not exist.");
}
}
}
public void Delete(int routeId)
{
using (var context = new DeliveryServiceDbContext())
{
Route routeEntity = context.Routes.Find(routeId);
if (routeEntity != null)
{
context.Entry <Route>(routeEntity).State = EntityState.Deleted;
context.SaveChanges();
}
else
{
throw new ArgumentNullException("routeId", "The referenced point does not exist.");
}
}
}
public PointDTO Get(int pointId)
{
PointDTO point = null;
using (var dbContext = new DeliveryServiceDbContext())
{
point = dbContext.Points
.Select(p => new PointDTO()
{
Id = p.Id,
Name = p.Name
})
.Where(p => p.Id.Equals(pointId))
.SingleOrDefault <PointDTO>();
}
return(point);
}
public RouteDTO Save(RouteDTO route)
{
RouteDTO savedRoute = null;
using (var context = new DeliveryServiceDbContext())
{
Point sourceEntity = context.Points.Find(route.OriginId);
Point destinationEntity = context.Points.Find(route.DestinationId);
if (sourceEntity == null)
{
throw new ApplicationException("Route source point does not exist.");
}
if (destinationEntity == null)
{
throw new ApplicationException("Route destination point does not exist.");
}
Route routeEntity = new Route()
{
Id = route.Id,
Origin = sourceEntity,
Destination = destinationEntity,
Cost = route.Cost,
Minutes = route.Minutes
};
if (routeEntity.Id == 0)
{
context.Entry(routeEntity).State = EntityState.Added;
}
else
{
context.Entry(routeEntity).State = EntityState.Modified;
}
context.SaveChanges();
savedRoute = typeMapper.Map <Route, RouteDTO>(routeEntity);
}
return(savedRoute);
}
public PointDTO Save(PointDTO point)
{
Point pointEntity = typeMapper.Map <PointDTO, Point>(point);
using (var context = new DeliveryServiceDbContext())
{
if (pointEntity.Id == 0)
{
context.Entry(pointEntity).State = EntityState.Added;
}
else
{
context.Entry(pointEntity).State = EntityState.Modified;
}
context.SaveChanges();
}
return(typeMapper.Map <Point, PointDTO>(pointEntity));
}
public IEnumerable <RouteDTO> ListAll()
{
IList <RouteDTO> routes = new List <RouteDTO>();
using (var dbContext = new DeliveryServiceDbContext())
{
routes = dbContext.Routes
.Select(r => new RouteDTO()
{
Id = r.Id,
Cost = r.Cost,
Minutes = r.Minutes,
OriginId = r.Origin.Id,
DestinationId = r.Destination.Id,
OriginName = r.Origin.Name,
DestinationName = r.Destination.Name
})
.ToList <RouteDTO>();
}
return(routes);
}
public RouteDTO Get(int routeId)
{
RouteDTO route = null;
using (var dbContext = new DeliveryServiceDbContext())
{
route = dbContext.Routes
.Select(r => new RouteDTO()
{
Id = r.Id,
Cost = r.Cost,
OriginId = r.Origin.Id,
DestinationId = r.Destination.Id,
OriginName = r.Origin.Name,
DestinationName = r.Destination.Name
})
.Where(p => p.Id.Equals(routeId))
.SingleOrDefault <RouteDTO>();
}
return(route);
}
public ReadRepository(DeliveryServiceDbContext context)
{
_context = context;
}
public WriteRepository(DeliveryServiceDbContext context)
{
_context = context;
}
