public void AddTrack(BeaconModel bm)
{
using (var connection = new SqlConnection(conS))
{
connection.Open();
var sql = "INSERT INTO Tracks(xPos, yPos, FloorID) VALUES(@xPos, @yPos, @FloorID)";
using (var cmd = new SqlCommand(sql, connection))
{
//TODO FloorID
cmd.Parameters.AddWithValue("@FloorID", bm.FloorID);
cmd.Parameters.AddWithValue("@xPos", bm.xPos);
cmd.Parameters.AddWithValue("@yPos", bm.yPos);
cmd.ExecuteNonQuery();
}
}
}
public void AddBeacon(BeaconModel beacon)
{
using (var connection = new SqlConnection(conS))
{
connection.Open();
var sql = "INSERT INTO Beacons(BeaconID, xPos, yPos, OfficeID) VALUES(@BeaconID, @xPos, @yPos, @OfficeID)";
using (var cmd = new SqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@BeaconID", beacon.beaconId);
cmd.Parameters.AddWithValue("@xPos", beacon.xPos);
cmd.Parameters.AddWithValue("@yPos", beacon.yPos);
cmd.Parameters.AddWithValue("@OfficeID", beacon.OfficeID);
cmd.ExecuteNonQuery();
}
}
}
