private void tabSqlScripts_Click(object sender, EventArgs e)
{
pnlInsertControls.Controls.Clear();
chkListBoxColumns.Items.Clear();
txtoutput.BringToFront();
GridSelect.SendToBack();
txtoutput.Text = "";
}
//In this function we will check for the Select query type as user entered or user selected columns to display.
private void buildSelectScript()
{
DataTable dt = new DataTable();
Cursor.Current = Cursors.WaitCursor;
if (chkWriteSelectQuery.Checked == true)
{
if (txtSelectQuery.Text.Trim() == "")
{
MessageBox.Show("Enter Select Query");
txtSelectQuery.Focus();
return;
}
string sqlSelectQuery = txtSelectQuery.Text.ToLower().Trim();
if (sqlSelectQuery.Contains("select") == true)
{
if (!objSQL.sqlInjectionCheck(sqlSelectQuery))
{
return;
}
dt = objSQL.selectRecordsfromTableQuery(txtDBNAME.Text.Trim(), txtSelectQuery.Text.Trim());
}
}
else
{
if (cboTable.Items.Count <= 0)
{
MessageBox.Show("Select valid Table to select Column");
return;
}
if (cboTable.SelectedItem.ToString() == "")
{
MessageBox.Show("Select valid Table to select Column");
return;
}
bool isAllcolumn = false;
if (chkAllColumns.Checked == true)
{
isAllcolumn = true;
}
else
{
if (chkListBoxColumns.CheckedItems.Count <= 0)
{
MessageBox.Show("Select Columns ");
return;
}
}
GridSelect.DataSource = null;
dt = objSQL.selectRecordsfromTableQuery(isAllcolumn, chkListBoxColumns, txtDBNAME.Text.Trim(), cboTable.SelectedItem.ToString());
}
if (dt.Rows.Count > 0)
{
txtoutput.SendToBack();
GridSelect.BringToFront();
GridSelect.DataSource = dt;
}
else
{
txtoutput.BringToFront();
GridSelect.SendToBack();
txtoutput.ForeColor = Color.DarkRed;
txtoutput.Text = "Sorry No records to Display";
MessageBox.Show("Sorry No records to Display");
}
Cursor.Current = Cursors.Default;
}
private void OnGUI()
{
//scroll pos
scrollPos = EditorGUILayout.BeginScrollView(scrollPos, false, false);
//vertical space
GUILayout.Space(30);
#region display match data
GUILayout.FlexibleSpace();
GUILayout.Label("Print Match Data", EditorStyles.boldLabel);
EditorGUILayout.Space();
EditorGUILayout.HelpBox("Print specified match data (zero index) or all match data into the console. ", MessageType.Info);
EditorGUILayout.Space();
matchToLoad = EditorGUILayout.IntField("Enter a match number:", matchToLoad);
GUILayout.BeginHorizontal();
if (GUILayout.Button("Print Single Match Data", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
PrintMatchData(matchToLoad);
}
//column test
if (GUILayout.Button("Print All Matches", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
PrintAllMatches();
}
GUILayout.EndHorizontal();
#endregion
/**divider line for spacing**/
//vertical space
GUILayout.Space(15);
EditorGUILayout.LabelField("", GUI.skin.horizontalSlider);
GUILayout.FlexibleSpace();
/**end divider line **/
#region New Board Generation
/**Section for generating new board **/
EditorGUILayout.Space();
GUILayout.Label("Generate a New Board", EditorStyles.boldLabel);
EditorGUILayout.Space();
EditorGUILayout.HelpBox("Generate a new board. Functions similarly to starting a new game. " +
"Enter play mode, select settings, and press the button to generate a new board. Can generate at any time during the game but will end any match being played.", MessageType.Info);
EditorGUILayout.Space();
//Enter data
newGridSize = (GridSelect)EditorGUILayout.EnumPopup("New Board Dimensions: ", newGridSize);
PlayerOne = (IconSelect)EditorGUILayout.EnumPopup("Player 1 Icon: ", PlayerOne);
PlayerTwo = (IconSelect)EditorGUILayout.EnumPopup("Player 2 Icon: ", PlayerTwo);
playerToStart = (Player)EditorGUILayout.EnumPopup("Player to Start: ", playerToStart);
//Generate Button
if (GUILayout.Button("Generate New Board"))
{
//check if game manager exists
if (GameManager.instance == null)
{
Debug.LogError("Error: Game Manager not detected. Perhaps you need to start a game first?");
return;
}
//check if icons are different
if (PlayerOne == PlayerTwo)
{
Debug.LogError("Error: Cannot set both player icons to the same icon");
return;
}
else
{
BoardGenerator();
}
}
GUILayout.FlexibleSpace();
/**end section**/
#endregion
/**divider line for spacing**/
//vertical space
GUILayout.Space(15);
EditorGUILayout.LabelField("", GUI.skin.horizontalSlider);
GUILayout.FlexibleSpace();
/**end divider line **/
#region Board State testing
/**Section for testing board states **/
//vertical space
GUILayout.Space(15);
GUILayout.Label("Board State Tester", EditorStyles.boldLabel);
EditorGUILayout.Space();
EditorGUILayout.HelpBox("Test different board states. Select which player should win. Use the slider to select a specific row or column to test. Use the drop down to select which diagonal to check for. You can also set the speed between test moves" +
" Board must be generated before using. Will end any match currently being played or exit out of menu", MessageType.Info);
//Test Settings
playerToWin = (Player)EditorGUILayout.EnumPopup("Player to Win: ", playerToWin);
dimensionToSelect = EditorGUILayout.IntSlider("Row/Column to Test: ", dimensionToSelect, 0, BoardState.BoardDimension - 1);
SelectDiag = (DiagSelect)EditorGUILayout.EnumPopup("Diagonal: ", SelectDiag);
betweenMoves = EditorGUILayout.FloatField("Time Between Moves: ", betweenMoves);
EditorGUILayout.Space();
//row test
GUILayout.BeginHorizontal();
if (GUILayout.Button("Test Row", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestRows();
}
//column test
if (GUILayout.Button("Test Column", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestColumns();
}
GUILayout.EndHorizontal();
EditorGUILayout.Space();
GUILayout.BeginHorizontal();
//diagonal test
if (GUILayout.Button("Test Diagonal", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestDiagonal();
}
//draw test
if (GUILayout.Button("Test Draw", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestDraw();
}
GUILayout.EndHorizontal();
EditorGUILayout.Space(); EditorGUILayout.Space();
EditorGUILayout.HelpBox("Pressing any UI buttons, generating a map from the debug window , or starting a new test will immediately end any test. When testing all, just simply let it run through. Set the time between test either here or in the BoardStateTester inspector to set the speed between tests", MessageType.Warning);
betweenReset = EditorGUILayout.FloatField("Time between tests: ", betweenReset);
GUILayout.BeginHorizontal();
//test all rows
if (GUILayout.Button("Test All Rows", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestAllRows();
}
//test all columns
if (GUILayout.Button("Test All Columns", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestAllCols();
}
//all diag test
if (GUILayout.Button("Test ALL Diags", GUILayout.MaxWidth(150), GUILayout.MinHeight(40)))
{
TestAllDiags();
}
GUILayout.EndHorizontal();
if (GUILayout.Button("TEST ALL", GUILayout.MinHeight(40)))
{
TestAll();
}
//vertical space
GUILayout.Space(30);
EditorGUILayout.EndScrollView();
#endregion
}
