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
});
}
}
