private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
Webmap_1AContext context = new Webmap_1AContext();
//Wrecker wreckerToUpdate = context.Wreckers.Where(b => b.WreckerId == sender.ObjectId);
WebmapHub.SendLocation(((Wrecker)sender).WreckerId, ((Wrecker)sender).CurrentLocation);
}
public JsonResult <Wrecker> GetWreckerById(int id)
{
Webmap_1AContext wreckersContext = new Webmap_1AContext();
Wrecker wrecker = wreckersContext.Wreckers.Find(id);
return(Json(wrecker));
}
public JsonResult <Order[]> GetOrders()
{
Webmap_1AContext ordersContext = new Webmap_1AContext();
var orders = ordersContext.Orders.ToArray(); //ToListAsync().Result.ToDataTable();
return(Json(orders)); //Json(DataTableToJSON(orders));//, JsonRequestBehavior.AllowGet);
}
public IEnumerable <Order> GetOrders()
{
using (var db = new Webmap_1AContext())
{
return(db.Orders.ToList());
}
}
public void AddOrder(Order order)
{
using (var db = new Webmap_1AContext())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
public void SetWreckerLocation(int id, [FromBody] Location loc)
{
Webmap_1AContext wreckersContext = new Webmap_1AContext();
Wrecker wreckerToChange = wreckersContext.Wreckers.Find(id);
wreckerToChange.CurrentLocation.Lat = loc.Lat;
wreckerToChange.CurrentLocation.Lng = loc.Lng;
WebmapHub.SendLocation(id, loc);
wreckersContext.SaveChanges();
}
public HttpResponseMessage PostStatus(int id, [FromBody] string status)
{
Webmap_1AContext ordersContext = new Webmap_1AContext();
Order orderToChange = (Order)ordersContext.Orders.Find(id);
if (orderToChange != null)
{
try
{
Enum.TryParse(status, out Order.OrderStatus st);
orderToChange.CurrentStatus = st;
ordersContext.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, orderToChange);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
return(message);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
return(null);
}
public JsonResult <List <Driver> > GetDrivers()
{
Webmap_1AContext driversContext = new Webmap_1AContext();
return(Json(driversContext.Drivers.ToList()));
}
public JsonResult <List <Wrecker> > GetWreckers()
{
Webmap_1AContext wreckersContext = new Webmap_1AContext();
return(Json(wreckersContext.Wreckers.ToList()));
}
public IEnumerable <Wrecker> GetWreckersCollection()
{
Webmap_1AContext wreckersContext = new Webmap_1AContext();
return(wreckersContext.Wreckers.ToList());
}
