public void SaveScene(string sceneName) { SceneDescription = new SceneDescription { sceneName = sceneName }; SceneDescription scene = db.Table <SceneDescription>().Where(x => x.sceneName.Equals(sceneName)).FirstOrDefault(); if (scene != null) { DeleteScene(scene); } db.Insert(SceneDescription); foreach (var item in shapes) { item.sceneID = SceneDescription.sceneID; db.Insert(item, item.GetType()); } foreach (var item in lights) { item.sceneID = SceneDescription.sceneID; db.Insert(item, item.GetType()); } }
public void DeleteScene(SceneDescription scene) { if (scene != null) { db.Execute("DELETE FROM Light WHERE sceneID = ?", scene.sceneID); db.Execute("DELETE FROM Box WHERE sceneID = ?", scene.sceneID); db.Execute("DELETE FROM Sphere WHERE sceneID = ?", scene.sceneID); db.Execute("DELETE FROM Plane WHERE sceneID = ?", scene.sceneID); db.Execute("DELETE FROM Torus WHERE sceneID = ?", scene.sceneID); db.Execute("DELETE FROM SceneDescription WHERE sceneID = ?", scene.sceneID); } }
public void LoadScene(string sceneName) { SceneDescription scene = db.Table <SceneDescription>().Where(x => x.sceneName.Equals(sceneName)).FirstOrDefault(); List <Shape> dbshapes = new List <Shape>(); dbshapes.AddRange(db.Table <Sphere>().Where(x => x.sceneID.Equals(scene.sceneID)).ToList()); dbshapes.AddRange(db.Table <Box>().Where(x => x.sceneID.Equals(scene.sceneID)).ToList()); dbshapes.AddRange(db.Table <Torus>().Where(x => x.sceneID.Equals(scene.sceneID)).ToList()); dbshapes.AddRange(db.Table <Plane>().Where(x => x.sceneID.Equals(scene.sceneID)).ToList()); SetShapes(dbshapes); var dblights = db.Table <Light>().Where(x => x.sceneID.Equals(scene.sceneID)).ToList(); SetLights(dblights); }
public void DeleteScene(string sceneName) { SceneDescription scene = db.Table <SceneDescription>().Where(x => x.sceneName.Equals(sceneName)).FirstOrDefault(); DeleteScene(scene); }