public void Post([FromBody] Felszalla busesOnTheRoad)
{
using (trafficEntities db = new trafficEntities())
{
db.Felszallas.Add(busesOnTheRoad);
db.SaveChanges();
}
}
//uj VonalBuszSofor
public void Post([FromBody] VonalBuszSofor newBusLineDriver)
{
using (trafficEntities db = new trafficEntities())
{
db.VonalBuszSofors.Add(newBusLineDriver);
db.SaveChanges();
}
}
public void Post([FromBody] Uzenet newMessage)
{
using (trafficEntities db = new trafficEntities())
{
db.Uzenets.Add(newMessage);
db.SaveChanges();
}
}
public void Put(int id, [FromBody] Garaz bus)
{
using (trafficEntities dbContext = new trafficEntities())
{
var entity = dbContext.Garazs.FirstOrDefault(e => e.buszId == id);
entity.buszId = bus.buszId;
entity.buszAllapotId = bus.buszAllapotId.Value;
entity.datum = bus.datum.Value;
dbContext.SaveChanges();
}
}
public void Put(int id, [FromBody] Felszalla busesOnTheRoad)
{
using (trafficEntities dbContext = new trafficEntities())
{
var entity = dbContext.Felszallas.FirstOrDefault(e => e.buszId == id);
entity.buszId = busesOnTheRoad.buszId;
entity.vonalId = busesOnTheRoad.vonalId;
entity.lat = busesOnTheRoad.lat;
entity.lon = busesOnTheRoad.lon;
entity.datum = busesOnTheRoad.datum;
dbContext.SaveChanges();
}
}
public ActionResult addNewBusLineDriver(VonalBuszSofor newBusLineDriver)
{
using (trafficEntities db = new trafficEntities())
{
db.VonalBuszSofors.Add(newBusLineDriver);
db.SaveChanges();
}
ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
return(View("addNewBusLineDriver", new VonalBuszSofor()));
}
public IHttpActionResult Delete(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid busLineDriverId"));
}
using (var DB = new trafficEntities())
{
var student = DB.VonalBuszSofors
.Where(s => s.vonalbuszsoforId == id)
.FirstOrDefault();
DB.Entry(student).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
return(Ok());
}
//azok a soforok akik az adott datumon nem dolgoznak
public List <BusLineDriverModel> Get()
{
trafficEntities obj = new trafficEntities();
string year = DateTime.Today.Year.ToString();
string month = DateTime.Today.Month.ToString();
string day = DateTime.Today.Day.ToString();
var x = from b in obj.Sofors
join a in obj.VonalBuszSofors
on b.soforId equals a.soforId
where a.datum.Value.Year.ToString() != year ||
a.datum.Value.Month.ToString() != month ||
a.datum.Value.Day.ToString() != day
select new BusLineDriverModel
{
Id = b.soforId,
DriverName = b.soforNev
};
return(x.Distinct().ToList());
}
