public void SetFourMeasurmentMacIds(DeterminantMacIds fourMacIds) { using (var ctx = new WifiLocalizerContext()) { DatabaseHandler.AddElementToDataBase(ctx, ctx.DeterminantMacIds, fourMacIds); } }
public List <RoomInfo> GetPossibleRooms() { using (var ctx = new WifiLocalizerContext()) { List <RoomInfo> returnList = new List <RoomInfo>(); var selectResult = ctx.DeterminantMacIds.Select(x => new { RoomId = x.Id, RoomName = x.RoomName }); foreach (var item in selectResult) { returnList.Add(new RoomInfo { roomId = item.RoomId, roomName = item.RoomName }); } DatabaseHandler.PrintSuccesFetchingFromDatabase("possible room list"); return(returnList); } }
public void AddRSSIMeasurmentInXYPoint(RSSIMeasurmentPoint RSSIMeasurmentPoint) { using (var ctx = new WifiLocalizerContext()) { DeterminantMacIds determinantMacIds = ctx.DeterminantMacIds.Find(RSSIMeasurmentPoint.RoomId); RSSIMeasurmentPoint.DeterminantMacIds = determinantMacIds; DatabaseHandler.AddElementToDataBase(ctx, ctx.RSSIMeasurmentPoints, RSSIMeasurmentPoint); } }
public DeterminantMacIds GetFourDeterminantMacIds(string roomName) { using (var ctx = new WifiLocalizerContext()) { var result = ctx.DeterminantMacIds.Where(x => x.RoomName.Equals(roomName)).FirstOrDefault(); DatabaseHandler.PrintSuccesFetchingFromDatabase(result); return(result); } }
public Point GetNearestXYLocalizationPoint(int id, FourRSSISignals threeMacIds) { using (var ctx = new WifiLocalizerContext()) { var nearestRSSIPoint = ctx.RSSIMeasurmentPoints.Where(x => x.RoomId == id) .OrderBy(CalculteVectorsDiffExpression(threeMacIds)) .FirstOrDefault(); DatabaseHandler.PrintSuccesFetchingFromDatabase(nearestRSSIPoint); return(new Point { x = nearestRSSIPoint.X, y = nearestRSSIPoint.Y }); } }