internal BrickSet Find(BrickSet newData) { string sql = @" SELECT * FROM bricksets WHERE (brickId = @BrickId AND setId = @SetId)"; return(_db.QueryFirstOrDefault <BrickSet>(sql, newData)); }
internal void Create(BrickSet newData) { BrickSet exists = _repo.Find(newData); if (exists != null) { throw new Exception("Brick already part of set."); } _repo.Create(newData); }
internal string Delete(BrickSet bs) { BrickSet exists = _repo.Find(bs); if (bs == null) { throw new Exception("Invalid Id Combination"); } _repo.Delete(bs.Id); return("Successfully Deleted"); }
internal BrickSet Create(BrickSet newData) { string sql = @" INSERT INTO bricksets (brickId, setId) VALUES (@BrickId, @SetId); SELECT LAST_INSERT_ID();"; int id = _db.ExecuteScalar <int>(sql, newData); newData.Id = id; return(newData); }
public ActionResult <String> Edit([FromBody] BrickSet bs) { try { return(Ok(_bss.Delete(bs))); } catch (Exception e) { return(BadRequest(e.Message)); } }
public ActionResult <String> AddBrickToSet(int id, [FromBody] BrickSet brickSet) { try { brickSet.SetId = id; return(Ok(_sr.AddBrickToSet(brickSet))); } catch (Exception e) { return(BadRequest(e)); } }
public ActionResult <String> Create([FromBody] BrickSet newData) { try { _bss.Create(newData); return(Ok("Success")); } catch (Exception e) { return(BadRequest(e.Message)); } }
public string AddBrickToSet(BrickSet bs) { string query = @" INSERT INTO bricksets (setId, brickId) VALUES (@SetId, @BrickId);"; int changedRows = _db.Execute(query, bs); if (changedRows < 1) { throw new Exception("Invalid Ids"); } return("Successfully added Brick to Set"); }
private void OnGUI() { EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Set values:"); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Circle Radius (2-50)"); Calculations.radius = (int)EditorGUILayout.Slider(Calculations.radius, 2, 30, GUILayout.MaxWidth(265)); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("BOX Size (1-2)"); Calculations.boxSize = (int)EditorGUILayout.Slider(Calculations.boxSize, 1, 2, GUILayout.MaxWidth(150)); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Gaps Size"); Calculations.gapSize = (int)EditorGUILayout.Slider(Calculations.gapSize, 1, 10, GUILayout.MaxWidth(265)); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Box Color"); boxColor = EditorGUILayout.ColorField(boxColor); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Material"); matToUse = (Material)EditorGUILayout.ObjectField(matToUse, typeof(Material), false); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(10); if (GUILayout.Button("Create circle")) { _selectedObject = Selection.activeGameObject; shapeCreate = new BrickSet(_selectedObject, matToUse, boxColor); shapeCreate.SetBoxes(); } EditorGUILayout.Space(50); if (GUILayout.Button("Save data to scriptableObject (Assets/Editor)")) { SaveToScriptObject(); } EditorGUILayout.Space(10); EditorGUILayout.BeginHorizontal(); GUILayout.Label("Scriptable Object Data"); _circleScriptObj = (CircleScriptObject)EditorGUILayout.ObjectField(_circleScriptObj, typeof(ScriptableObject), false); EditorGUILayout.EndHorizontal(); EditorGUILayout.Space(10); if (GUILayout.Button("Create Circle from scriptableObject data")) { LoadCreateFromScriptObject(); } void SaveToScriptObject() { if (_circleScriptObj == null) { CircleScriptObject circScriptObj = CreateInstance <CircleScriptObject>(); circScriptObj.radius = Calculations.radius; circScriptObj.gapSize = Calculations.gapSize; circScriptObj.objectSize = Calculations.boxSize; circScriptObj.material = matToUse; circScriptObj.boxColor = boxColor; AssetDatabase.CreateAsset(circScriptObj, "Assets/Editor/CircleData.asset"); AssetDatabase.SaveAssets(); AssetDatabase.Refresh(); } else { _circleScriptObj.radius = Calculations.radius; _circleScriptObj.gapSize = Calculations.gapSize; _circleScriptObj.objectSize = Calculations.boxSize; if (_circleScriptObj.material != null) { _circleScriptObj.material = matToUse; } _circleScriptObj.boxColor = boxColor; } } void LoadCreateFromScriptObject() { if (_circleScriptObj != null) { _selectedObject = Selection.activeGameObject; Calculations.radius = _circleScriptObj.radius; Calculations.gapSize = _circleScriptObj.gapSize; Calculations.boxSize = _circleScriptObj.objectSize; if (_circleScriptObj.material != null) { matToUse = _circleScriptObj.material; } boxColor = _circleScriptObj.boxColor; shapeCreate = new BrickSet(_selectedObject, matToUse, boxColor); shapeCreate.SetBoxes(); } else { Debug.Log("No scriptableObject attached"); } } }