//1 degree latitude and longitude is 69 miles public IEnumerable <PositionCore> GetByQuadrant(PositionCore item) { return(_context.Positions.Where( x => x.Latitude2.Value > item.Latitude2.Value - (decimal).5 && x.Latitude2.Value < item.Latitude2.Value + (decimal).5 && x.Longitude2.Value > item.Longitude2.Value - (decimal).5 && x.Longitude2.Value < item.Longitude2.Value + (decimal).5 && x.IsActive == true).ToList().Select(x => x.ToCore())); }
public PositionCore Update(int id, PositionCore item) { if (item == null) { throw new ArgumentNullException("Core.Models.Position"); } var record = _context.Positions.FirstOrDefault(x => x.Id == id); if (record == null) { throw new ArgumentNullException("Cannot find position."); } record.Name = item.Name; record.Latitude1 = item.Latitude1; record.Longitude1 = item.Longitude1; record.Altitude1 = item.Altitude1; record.Speed1 = item.Speed1; record.Heading1 = item.Heading1; record.UtcTimeStamp1 = item.UtcTimeStamp1; record.Latitude2 = item.Latitude2; record.Longitude2 = item.Longitude2; record.Altitude2 = item.Altitude2; record.Speed2 = item.Speed2; record.Heading2 = item.Heading2; record.UtcTimeStamp2 = item.UtcTimeStamp2; record.Latitude3 = item.Latitude3; record.Longitude3 = item.Longitude3; record.Altitude3 = item.Altitude3; record.Speed3 = item.Speed3; record.Heading3 = item.Heading3; record.UtcTimeStamp3 = item.UtcTimeStamp3; record.Radius = item.Radius; record.X1 = item.X1; record.Y1 = item.Y1; record.Z1 = item.Z1; record.X2 = item.X2; record.Y2 = item.Y2; record.Z2 = item.Z2; record.X3 = item.X3; record.Y3 = item.Y3; record.Z3 = item.Z3; record.IsInFlight = item.IsInFlight; record.IsActive = item.IsActive; record.ModifiedAtUtcTimeStamp = DateTime.UtcNow; _context.SaveChanges(); _context.Entry(record).Reference(x => x.Aircraft).Load(); return(record.ToCore()); }
public PositionCore Create(PositionCore item) { if (item == null) { throw new ArgumentNullException("Core.Models.Position"); } var now = DateTime.UtcNow; var _item = new PositionEntity() { Name = item.Name, AircraftId = item.AircraftId, Latitude1 = item.Latitude1, Longitude1 = item.Longitude1, Altitude1 = item.Altitude1, Speed1 = item.Speed1, Heading1 = item.Heading1, UtcTimeStamp1 = item.UtcTimeStamp1, Latitude2 = item.Latitude2, Longitude2 = item.Longitude2, Altitude2 = item.Altitude2, Speed2 = item.Speed2, Heading2 = item.Heading2, UtcTimeStamp2 = item.UtcTimeStamp2, Latitude3 = item.Latitude3, Longitude3 = item.Longitude3, Altitude3 = item.Altitude3, Speed3 = item.Speed3, Heading3 = item.Heading3, UtcTimeStamp3 = item.UtcTimeStamp3, Radius = item.Radius, CreatedAtUtcTimeStamp = now, IsInFlight = item.IsInFlight, IsActive = item.IsActive }; _context.Positions.Add(_item); _context.SaveChanges(); //Load navigation property after a create. _context.Entry(_item).Reference(x => x.Aircraft).Load(); return(_item.ToCore()); }
public PositionCore Create(PositionCore item) { if (item == null) { throw new ArgumentNullException("Core.Models.Position"); } var now = DateTime.UtcNow; var _item = new PositionEntity() { Name = item.Name, AircraftId = item.AircraftId, Latitude1 = item.Latitude1, Longitude1 = item.Longitude1, Altitude1 = item.Altitude1, Speed1 = item.Speed1, Heading1 = item.Heading1, UtcTimeStamp1 = item.UtcTimeStamp1, Latitude2 = item.Latitude2, Longitude2 = item.Longitude2, Altitude2 = item.Altitude2, Speed2 = item.Speed2, Heading2 = item.Heading2, UtcTimeStamp2 = item.UtcTimeStamp2, Latitude3 = item.Latitude3, Longitude3 = item.Longitude3, Altitude3 = item.Altitude3, Speed3 = item.Speed3, Heading3 = item.Heading3, UtcTimeStamp3 = item.UtcTimeStamp3, Radius = item.Radius, CreatedAtUtcTimeStamp = now, IsInFlight = item.IsInFlight, IsActive = item.IsActive }; _context.Positions.Add(_item); _context.SaveChanges(); //Load navigation property after a create. _context.Entry(_item).Reference(x => x.Aircraft).Load(); return _item.ToCore(); }
//1 degree latitude and longitude is 69 miles public IEnumerable<PositionCore> GetByQuadrant(PositionCore item) { return _context.Positions.Where( x => x.Latitude2.Value > item.Latitude2.Value - (decimal).5 && x.Latitude2.Value < item.Latitude2.Value + (decimal).5 && x.Longitude2.Value > item.Longitude2.Value - (decimal).5 && x.Longitude2.Value < item.Longitude2.Value + (decimal).5 && x.IsActive == true).ToList().Select(x => x.ToCore()); }
public PositionCore Update(int id, PositionCore item) { if (item == null) { throw new ArgumentNullException("Core.Models.Position"); } var record = _context.Positions.FirstOrDefault(x => x.Id == id); if (record == null) { throw new ArgumentNullException("Cannot find position."); } record.Name = item.Name; record.Latitude1 = item.Latitude1; record.Longitude1 = item.Longitude1; record.Altitude1 = item.Altitude1; record.Speed1 = item.Speed1; record.Heading1 = item.Heading1; record.UtcTimeStamp1 = item.UtcTimeStamp1; record.Latitude2 = item.Latitude2; record.Longitude2 = item.Longitude2; record.Altitude2 = item.Altitude2; record.Speed2 = item.Speed2; record.Heading2 = item.Heading2; record.UtcTimeStamp2 = item.UtcTimeStamp2; record.Latitude3 = item.Latitude3; record.Longitude3 = item.Longitude3; record.Altitude3 = item.Altitude3; record.Speed3 = item.Speed3; record.Heading3 = item.Heading3; record.UtcTimeStamp3 = item.UtcTimeStamp3; record.Radius = item.Radius; record.X1 = item.X1; record.Y1 = item.Y1; record.Z1 = item.Z1; record.X2 = item.X2; record.Y2 = item.Y2; record.Z2 = item.Z2; record.X3 = item.X3; record.Y3 = item.Y3; record.Z3 = item.Z3; record.IsInFlight = item.IsInFlight; record.IsActive = item.IsActive; record.ModifiedAtUtcTimeStamp = DateTime.UtcNow; _context.SaveChanges(); _context.Entry(record).Reference(x => x.Aircraft).Load(); return record.ToCore(); }