public PathComponent get(int id)
{
EITDBEntities ctx = new EITDBEntities();
var entity = ctx.PathComponents.FirstOrDefault(x => x.Id == id);
if (entity == null)
{
return(null);
}
var citiesRepository = new CitiesRepository();
PathComponent obj = new PathComponent();
obj.Id = entity.Id;
obj.ArrivedAt = entity.ArrivedAt;
obj.City = citiesRepository.get(entity.City);
if (entity.NextDestination == null)
{
return(obj);
}
obj.NextDestination = get(entity.NextDestination.Value);
return(obj);
}
public City get(int id)
{
EITDBEntities ctx = new EITDBEntities();
var city = ctx.Cities.FirstOrDefault(x => x.Id == id);
if (city != null)
{
return(mapFromEntity(city));
}
return(null);
}
public City get(string name)
{
EITDBEntities ctx = new EITDBEntities();
var city = ctx.Cities.FirstOrDefault(x => x.Name.ToLower() == name.ToLower());
if (city != null)
{
return(mapFromEntity(city));
}
return(null);
}
public User get(string username, string password)
{
var ctx = new EITDBEntities();
var user = ctx.Users.FirstOrDefault(x => x.Username.ToLower() == username.ToLower() && x.Password == password);
if (user != null)
{
return(mapFromEntity(user));
}
return(null);
}
public User get(int id)
{
var ctx = new EITDBEntities();
var user = ctx.Users.FirstOrDefault(x => x.Id == id);
if (user != null)
{
return(mapFromEntity(user));
}
return(null);
}
public List <City> getAll()
{
List <City> cities = new List <City>();
EITDBEntities ctx = new EITDBEntities();
foreach (var entity in ctx.Cities)
{
cities.Add(
mapFromEntity(entity)
);
}
return(cities);
}
public List <ParcelType> getAll()
{
List <ParcelType> parcelTypes = new List <ParcelType>();
EITDBEntities ctx = new EITDBEntities();
foreach (var entity in ctx.ParcelTypes)
{
parcelTypes.Add(
mapFromEntity(entity)
);
}
return(parcelTypes);
}
public List <Edge> getAll()
{
List <Edge> edges = new List <Edge>();
EITDBEntities ctx = new EITDBEntities();
foreach (var entity in ctx.Edges)
{
edges.Add(
mapFromEntity(entity)
);
}
return(edges);
}
