public IList <Uzenet> GetMessages()
{
trafficEntities DB = new trafficEntities();
return(DB.Uzenets.ToList());
}
public List <Uzenet> GetAccidents()
{
trafficEntities DB = new trafficEntities();
return(DB.Uzenets.ToList());
}
public List <Vonal> GetAllLines()
{
trafficEntities DB = new trafficEntities();
return(DB.Vonals.ToList());
}
//osszes sofor lekerdezese
public List <Sofor> GetAllDrivers()
{
trafficEntities DB = new trafficEntities();
return(DB.Sofors.ToList());
}
//osszes VonalBusSofor lekerdezese
public List <VonalBuszSofor> GetAllLineBusDriver()
{
trafficEntities DB = new trafficEntities();
return(DB.VonalBuszSofors.ToList());
}
public IQueryable <Megallok> GetAllStation()
{
trafficEntities DB = new trafficEntities();
return(DB.Megalloks);
}
public List <Garaz> GetAllBusState()
{
trafficEntities DB = new trafficEntities();
return(DB.Garazs.ToList());
}
public List <VonalMegallok> GetLinesById(int id)
{
trafficEntities DB = new trafficEntities();
return(DB.VonalMegalloks.Where(s => s.vonalId.Equals(id)).ToList());
}
public IQueryable <Busz> GetAllBus()
{
trafficEntities DB = new trafficEntities();
return(DB.Buszs);
}
public IQueryable <Jelze> GetAllMessageType()
{
trafficEntities DB = new trafficEntities();
return(DB.Jelzes);
}
public List <Busz> GetBus()
{
trafficEntities DB = new trafficEntities();
return(DB.Buszs.ToList());
}
public List <Megallok> GetAllStation()
{
trafficEntities DB = new trafficEntities();
return(DB.Megalloks.ToList());
}
//buszok melyek a garazsban vannak
public IQueryable <Garaz> BusInGarage()
{
trafficEntities DB = new trafficEntities();
return(DB.Garazs.Where(g => g.BuszAllapot.buszAllapot1 == "garazsban"));
}
public IQueryable <Garaz> GetAllBusState(int id)
{
trafficEntities DB = new trafficEntities();
return(DB.Garazs.Where(c => c.garazsid == id).Select(e => e));
}
public List <VonalMegallok> GetAllLineStation()
{
trafficEntities DB = new trafficEntities();
return(DB.VonalMegalloks.ToList());
}
public IQueryable <Busz> GetAllBus(int id)
{
trafficEntities DB = new trafficEntities();
return(DB.Buszs.Where(c => c.buszId == id).Select(e => e));
}
public List <Felszalla> GetAllBusOnRoad()
{
trafficEntities DB = new trafficEntities();
return(DB.Felszallas.ToList());
}
public IQueryable <Busz> BusInGarage2()
{
trafficEntities DB = new trafficEntities();
return(DB.Buszs.Where(b => b.buszId == 123).Select(b => b));
}
public IQueryable <Megallok> GetAllStation(int id)
{
trafficEntities DB = new trafficEntities();
return(DB.Megalloks.Where(b => b.megalloId == id).Select(e => e));
}
public IQueryable <Uzenet> GetAllMessage()
{
trafficEntities DB = new trafficEntities();
return(DB.Uzenets);
}
