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