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