protected void btnSAVE_Click(object sender, EventArgs e)
{
DivisionData division = new DivisionData();
division.Division_Code = txtDivisionCode.Text;
division.Division_Thai = txtDivisionNameThai.Text;
division.Division_Eng = txtDivisionNameEng.Text;
division.Division_ShortName = txtDivisionShortName.Text;
division.Division_OfficeCode = ddlOffice.SelectedValue;
division.Division_Status = ddlDivisionStatus.SelectedValue;
division.Division_CodeStudent = "00";
string result = "";
result = new Division().insertDivision(division);
//lblTest.Text = result;
if (result == "OK")
{
Response.Redirect("list_Division.aspx?OfficeId=" + division.Division_OfficeCode);
//divBody.Visible = false;
//divSuccess.Visible = true;
}
else
{
//divBody.Visible = false;
//divFail.Visible = true;
//lblTest.Text = result;
}
}
public TournamentData()
{
for (int i = 0; i < 4; ++i)
{
AllDivisions[i] = new DivisionData();
}
}
//Pongsarun 26/9/2015: use for config system
public string insertDivision(DivisionData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into DIVISION(DIVISION_CODE, DIVISION_THAINAME, DIVISION_ENGNAME, DIVISION_SHORTNAME, OFFICE_CODE, DIVISION_STATUS, DIVISION_CODE_STUDENTID) Values('" + dataInsert.Division_Code + "','" + dataInsert.Division_Thai + "','" + dataInsert.Division_Eng + "','" + dataInsert.Division_ShortName + "','" + dataInsert.Division_OfficeCode + "','" + dataInsert.Division_Status + "','" + dataInsert.Division_CodeStudent + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
public List <DivisionData> getDivisionCommand(string sqlCommand)
{
List <DivisionData> Division_data = new List <DivisionData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sqlCommand;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DivisionData Division = new DivisionData();
Division.Division_Code = rowData["DIVISION_CODE"].ToString();
Division.Division_Thai = rowData["DIVISION_THAINAME"].ToString();
Division.Division_Eng = rowData["DIVISION_ENGNAME"].ToString();
Division.Division_ShortName = rowData["DIVISION_SHORTNAME"].ToString();
Division.Division_OfficeCode = rowData["OFFICE_CODE"].ToString();
Division.Division_Status = rowData["DIVISION_STATUS"].ToString();
Division.Division_CodeStudent = rowData["DIVISION_CODE_STUDENTID"].ToString();
Division_data.Add(Division);
}
return(Division_data);
}
public static void Setup()
{
for (var index = 1; index <= GameData.Divisions; index++)
{
DivisionData.AddDivision(index);
}
}
public static void Initialise()
{
DivisionData.Setup();
FormationData.Setup();
TeamData.Setup();
PlayerData.Setup();
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
DivisionData divisionSave = new DivisionData();
divisionSave.Division_Code = txtDivisionCode.Text;
divisionSave.Division_Thai = txtDivisionNameThai.Text;
divisionSave.Division_Eng = txtDivisionNameEng.Text;
divisionSave.Division_ShortName = txtDivisionShortName.Text;
divisionSave.Division_OfficeCode = ddlOffice.SelectedValue;
divisionSave.Division_Status = ddlDivisionStatus.SelectedValue;
divisionSave.Division_CodeStudent = "00";
try
{
String result = new Division().updateDivision(divisionSave);
if (result.Equals("OK"))
{
Response.Redirect("list_Division.aspx?OfficeId=" + divisionSave.Division_OfficeCode);
//lblTest.Text = OfficeSave.Office_Thai;
}
}
catch
{
Response.Redirect("list_Division.aspx?OfficeId=" + divisionSave.Division_OfficeCode);
}
}
void CreateRoundData()
{
DivisionData DivData = Global.AllData.AllDivisions[DivisionCombo.GetSelectedItemIndex()];
DivData.Rounds[RoundCombo.GetSelectedItemIndex()].Pools = new List <PoolData>(AllPools.Count);
float.TryParse(RoutineMinutesString, out DivData.Rounds[RoundCombo.GetSelectedItemIndex()].RoutineLengthMinutes);
foreach (PoolDataDisplay pdd in AllPools)
{
DivData.Rounds[RoundCombo.GetSelectedItemIndex()].Pools.Add(new PoolData(pdd.Data));
}
Debug.Log(Global.AllData.Save());
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
OfficeCode = Request.QueryString["OfficId"];
DivisionCode = Request.QueryString["DivId"];
if (!Page.IsPostBack)
{
divisionData = divisionObj.getDivision(DivisionCode);
officeData = officeObj.getOffice();
foreach (OfficeData data in officeData)
{
ddlOffice.Items.Insert(ddlOffice.Items.Count, new ListItem(data.Office_Thai, data.Office_Code));
}
ddlOffice.Items.FindByValue(OfficeCode).Selected = true;
txtDivisionCode.Text = divisionData.Division_Code;
txtDivisionNameThai.Text = divisionData.Division_Thai;
txtDivisionNameEng.Text = divisionData.Division_Eng;
txtDivisionShortName.Text = divisionData.Division_ShortName;
ddlDivisionStatus.Items.FindByValue(divisionData.Division_Status).Selected = true;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public DivisionData getDivision(String Division_Code)
{
DivisionData Division = new DivisionData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From DIVISION Where DIVISION_CODE='" + Division_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Division.Division_Code = rowData["DIVISION_CODE"].ToString();
Division.Division_Thai = rowData["DIVISION_THAINAME"].ToString();
Division.Division_Eng = rowData["DIVISION_ENGNAME"].ToString();
Division.Division_ShortName = rowData["DIVISION_SHORTNAME"].ToString();
Division.Division_OfficeCode = rowData["OFFICE_CODE"].ToString();
Division.Division_Status = rowData["DIVISION_STATUS"].ToString();
Division.Division_CodeStudent = rowData["DIVISION_CODE_STUDENTID"].ToString();
}
return(Division);
}
public string updateDivision(DivisionData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "UPDATE DIVISION SET DIVISION_THAINAME = '" + updateData.Division_Thai + "', DIVISION_ENGNAME = '" + updateData.Division_Eng + "', DIVISION_SHORTNAME = '" + updateData.Division_ShortName + "', OFFICE_CODE = '" + updateData.Division_OfficeCode + "', DIVISION_STATUS = '" + updateData.Division_Status + "', DIVISION_CODE_STUDENTID ='" + updateData.Division_CodeStudent + "' WHERE DIVISION_CODE = '" + updateData.Division_Code + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
}
return(response);
}
public void DivideTheory(DivisionData point)
{
Assume.That(point.Second != 0); // Actually you probably want to keep this condition anyway. Second==0 would be a separate test
Assert.That(point.First / point.Second, Is.EqualTo(new BadMaths().Divide(point.First, point.Second)));
}
public IEnumerable <Division> GetAll()
{
return(DivisionData.GetDivisions());
}
public Division GetById(int id)
{
return(DivisionData.GetDivisionById(id));
}
void OnGUI()
{
if (!bIsEditing)
{
CatCombo.List(new Rect(20, Screen.height * .03f, Screen.width * .18f, Screen.height * .07f),
CatComboList[CatCombo.GetSelectedItemIndex()], CatComboList, CatComboStyle);
if (CatPickingFrameUpdate != Time.frameCount)
{
CatPickingFrameUpdate = Time.frameCount;
bCatPicking = CatCombo.IsPicking;
}
}
if (bInEditingMode && CatCombo.GetSelectedItemIndex() == 3)
{
bInEditingMode = false;
bIsEditing = false;
EditAIData = null;
EditExData = null;
EditDiffData = null;
bEditAddNewData = false;
}
if (!bIsEditing && GUI.Button(new Rect(Screen.width * .3f, Screen.height * .04f, Screen.width * .25f, Screen.height * .07f), "Export SCHEDULE to Excel"))
{
ExportScheduleToExcel();
}
if (!bIsEditing && GUI.Button(new Rect(Screen.width * .56f, Screen.height * .04f, Screen.width * .23f, Screen.height * .07f), "Export RESULTS to Excel"))
{
ExportResultsToExcel();
}
if (GUI.Button(new Rect(Screen.width * .83f, Screen.height * .04f, Screen.width * .17f - 20, Screen.height * .07f), "Send All Teams to Livestream"))
{
LiveStream.TeamList teamList = new LiveStream.TeamList();
EDivision division = EDivision.Open;
foreach (DivisionData dd in Global.AllData.AllDivisions)
{
ERound round = ERound.Finals;
foreach (RoundData rd in dd.Rounds)
{
EPool pool = EPool.A;
foreach (PoolData pd in rd.Pools)
{
int teamNumber = 0;
foreach (TeamDataDisplay td in pd.Teams)
{
LiveStream.Team team = new LiveStream.Team(
LiveStream.TeamStates.Inited,
division.ToString(),
round.ToString(),
pool.ToString(),
teamNumber
);
foreach (PlayerData playerData in td.Data.Players)
{
team.Players.Add(new LiveStream.Player(playerData));
}
teamList.Teams.Add(team);
++teamNumber;
}
++pool;
}
++round;
}
++division;
}
SendRestMessageAsync(teamList);
}
#region Round Buttons
GUIStyle RoundStyle = new GUIStyle("button");
string LongestRoundStr = "Women - Quarterfinals";
Rect RoundRect = new Rect(20, Screen.height * .15f, RoundStyle.CalcSize(new GUIContent(LongestRoundStr)).x + 40, Screen.height * .75f - 20);
if (!bIsEditing && !bCatPicking)
{
GUILayout.BeginArea(RoundRect);
RoundsScrollPos = GUILayout.BeginScrollView(RoundsScrollPos, GUILayout.MaxHeight(RoundRect.height / 2f));
GUIStyle RoundButtonStyle = new GUIStyle("button");
RoundButtonStyle.alignment = TextAnchor.MiddleLeft;
for (int DivIndex = 0; DivIndex < Global.AllData.AllDivisions.Length; ++DivIndex)
{
DivisionData DivData = Global.AllData.AllDivisions[DivIndex];
if (DivData.HasAnyPoolData())
{
for (int RoundIndex = 0; RoundIndex < DivData.Rounds.Length; ++RoundIndex)
{
RoundData RData = DivData.Rounds[RoundIndex];
if (RData.HasAnyPoolData())
{
GUIContent RoundContent = new GUIContent(((EDivision)DivIndex) + " - " + ((ERound)RoundIndex) + (RData.ContainsJudgeScores() ? " - Results" : ""));
Vector2 RoundTextSize = RoundButtonStyle.CalcSize(RoundContent);
if (GUILayout.Button(RoundContent, RoundButtonStyle, GUILayout.Width(RoundRect.width * .9f), GUILayout.Height(RoundTextSize.y)))
{
CurDivIndex = DivIndex;
CurRoundIndex = RoundIndex;
}
}
}
}
}
GUILayout.EndScrollView();
GUILayout.EndArea();
}
#endregion
if (CurDivIndex != -1 && CurRoundIndex != -1)
{
float StartX = RoundRect.x + RoundRect.width + 20;
Rect TeamRect = new Rect(StartX, RoundRect.y, Screen.width - StartX - 20, Screen.height - RoundRect.y - 20);
GUILayout.BeginArea(TeamRect);
GUILayout.BeginVertical();
TeamsScrollPos = GUILayout.BeginScrollView(TeamsScrollPos);
GUILayout.BeginVertical();
GUIStyle labelStyle = new GUIStyle("label");
labelStyle.normal.textColor = Color.black;
if (!bIsEditing)
{
List <PoolData> Pools = Global.AllData.AllDivisions[CurDivIndex].Rounds[CurRoundIndex].Pools;
int PoolIndex = 0;
foreach (PoolData pd in Pools)
{
GUILayout.Label("Pool " + pd.PoolName, labelStyle);
// This is a hack to get team result order
List <RoutineScoreData> sortedScores = new List <RoutineScoreData>();
foreach (TeamDataDisplay tdd in pd.Teams)
{
if (sortedScores.Count == 0)
{
sortedScores.Add(tdd.Data.RoutineScores);
}
else
{
int insertIndex = 0;
foreach (RoutineScoreData score in sortedScores)
{
if (tdd.Data.RoutineScores.GetTotalPoints() > score.GetTotalPoints())
{
sortedScores.Insert(insertIndex, tdd.Data.RoutineScores);
break;
}
++insertIndex;
}
if (insertIndex == sortedScores.Count)
{
sortedScores.Insert(insertIndex, tdd.Data.RoutineScores);
}
}
}
int TeamNum = 0;
foreach (TeamDataDisplay tdd in pd.Teams)
{
++TeamNum;
GUILayout.Label(TeamNum + ": " + tdd.Data.PlayerNames + ":", labelStyle);
for (int ScoresIndex = 0; ScoresIndex < (CurCat == ECategoryView.Overview ? 1 : 3); ++ScoresIndex)
{
GUIStyle EditStyle = new GUIStyle("button");
EditStyle.alignment = TextAnchor.MiddleLeft;
string ResultsStr = tdd.Data.RoutineScores.GetResultsString(ScoresIndex, CurCat, true, sortedScores);
if (ResultsStr.Length > 0)
{
if (bInEditingMode)
{
if (GUILayout.Button(" " + ResultsStr, EditStyle))
{
bIsEditing = true;
EditPoolIndex = PoolIndex;
EditTeamIndex = TeamNum - 1;
EditJudgeIndex = ScoresIndex;
}
}
else
{
GUILayout.Label(" " + ResultsStr, labelStyle);
}
}
else if (bInEditingMode && (ScoresIndex == 0 || tdd.Data.RoutineScores.GetResultsString(ScoresIndex - 1, CurCat, true).Length > 0))
{
if (GUILayout.Button(" Enter New Scores", EditStyle))
{
bIsEditing = true;
EditPoolIndex = PoolIndex;
EditTeamIndex = TeamNum - 1;
EditJudgeIndex = ScoresIndex;
}
}
}
}
++PoolIndex;
}
}
else
{
TeamData Data = Global.AllData.AllDivisions[CurDivIndex].Rounds[CurRoundIndex].Pools[EditPoolIndex].Teams[EditTeamIndex].Data;
if (CatCombo.GetSelectedItemIndex() == 0)
{
if (EditAIData == null)
{
AIData JData = null;
if (EditJudgeIndex >= Data.RoutineScores.AIResults.Count)
{
EditAIData = new AIData((EDivision)CurDivIndex, (ERound)CurRoundIndex, (EPool)EditPoolIndex, EditTeamIndex);
bEditAddNewData = true;
EditJudgeName = "Judge Name";
}
else
{
JData = Data.RoutineScores.AIResults[EditJudgeIndex];
EditAIData = new AIData(JData);
}
}
GUILayout.BeginHorizontal();
if (EditAIData.JudgeNameId == -1)
{
GUILayout.Label("Judge:", labelStyle);
EditJudgeName = GUILayout.TextField(EditJudgeName);
char[] Seperators = new char[] { ',', ' ' };
string[] Splits = EditJudgeName.Split(Seperators, System.StringSplitOptions.RemoveEmptyEntries);
NameData JudgeName = null;
if (Splits.Length == 2)
{
JudgeName = NameDatabase.FindInDatabase(Splits[0], Splits[1]);
if (JudgeName == null)
{
JudgeName = NameDatabase.FindInDatabase(Splits[1], Splits[0]);
}
}
if (JudgeName != null)
{
EditAIData.JudgeNameId = JudgeName.Id;
}
}
else
{
GUILayout.Label(NameDatabase.FindInDatabase(EditAIData.JudgeNameId).DisplayName + ": ", labelStyle);
}
GUILayout.Label("V: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.Variety.ToString()), out EditAIData.Variety);
GUILayout.Label("T: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.Teamwork.ToString()), out EditAIData.Teamwork);
GUILayout.Label("M: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.Music.ToString()), out EditAIData.Music);
GUILayout.Label("Fm: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.Form.ToString()), out EditAIData.Form);
GUILayout.Label("Fw: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.Flow.ToString()), out EditAIData.Flow);
GUILayout.Label("G: ", labelStyle);
float.TryParse(GUILayout.TextField(EditAIData.General.ToString()), out EditAIData.General);
GUILayout.Label("Total: " + EditAIData.GetTotalPoints().ToString(), labelStyle);
GUILayout.EndHorizontal();
}
else if (CatCombo.GetSelectedItemIndex() == 1)
{
if (EditExData == null)
{
ExData JData = null;
if (EditJudgeIndex >= Data.RoutineScores.ExResults.Count)
{
EditExData = new ExData((EDivision)CurDivIndex, (ERound)CurRoundIndex, (EPool)EditPoolIndex, EditTeamIndex);
bEditAddNewData = true;
EditJudgeName = "Judge Name";
}
else
{
JData = Data.RoutineScores.ExResults[EditJudgeIndex];
EditExData = new ExData(JData);
}
}
GUILayout.BeginHorizontal();
if (EditExData.JudgeNameId == -1)
{
GUILayout.Label("Judge:", labelStyle);
EditJudgeName = GUILayout.TextField(EditJudgeName);
char[] Seperators = new char[] { ',', ' ' };
string[] Splits = EditJudgeName.Split(Seperators, System.StringSplitOptions.RemoveEmptyEntries);
NameData JudgeName = null;
if (Splits.Length == 2)
{
JudgeName = NameDatabase.FindInDatabase(Splits[0], Splits[1]);
if (JudgeName == null)
{
JudgeName = NameDatabase.FindInDatabase(Splits[1], Splits[0]);
}
}
if (JudgeName != null)
{
EditExData.JudgeNameId = JudgeName.Id;
}
}
else
{
GUILayout.Label(NameDatabase.FindInDatabase(EditExData.JudgeNameId).DisplayName + ": ", labelStyle);
}
GUILayout.Label(".1: ", labelStyle);
int.TryParse(GUILayout.TextField(EditExData.Point1Count.ToString()), out EditExData.Point1Count);
GUILayout.Label(".2: ", labelStyle);
int.TryParse(GUILayout.TextField(EditExData.Point2Count.ToString()), out EditExData.Point2Count);
GUILayout.Label(".3: ", labelStyle);
int.TryParse(GUILayout.TextField(EditExData.Point3Count.ToString()), out EditExData.Point3Count);
GUILayout.Label(".5: ", labelStyle);
int.TryParse(GUILayout.TextField(EditExData.Point5Count.ToString()), out EditExData.Point5Count);
GUILayout.Label("Total: " + EditExData.GetTotalPoints().ToString(), labelStyle);
GUILayout.EndHorizontal();
}
else if (CatCombo.GetSelectedItemIndex() == 2)
{
if (EditDiffData == null)
{
DiffData JData = null;
if (EditJudgeIndex >= Data.RoutineScores.DiffResults.Count)
{
EditDiffData = new DiffData(20, (EDivision)CurDivIndex, (ERound)CurRoundIndex, (EPool)EditPoolIndex, EditTeamIndex);
bEditAddNewData = true;
EditJudgeName = "Judge Name";
}
else
{
JData = Data.RoutineScores.DiffResults[EditJudgeIndex];
EditDiffData = new DiffData(JData);
}
}
GUILayout.BeginVertical();
GUILayout.BeginHorizontal();
GUILayout.Label("Number of Scores: ", labelStyle);
int.TryParse(GUILayout.TextField(EditDiffData.NumScores.ToString()), out EditDiffData.NumScores);
EditDiffData.NumScores = Mathf.Clamp(EditDiffData.NumScores, 0, 20);
GUILayout.EndHorizontal();
GUILayout.BeginHorizontal();
if (EditDiffData.JudgeNameId == -1)
{
GUILayout.Label("Judge:", labelStyle);
EditJudgeName = GUILayout.TextField(EditJudgeName);
char[] Seperators = new char[] { ',', ' ' };
string[] Splits = EditJudgeName.Split(Seperators, System.StringSplitOptions.RemoveEmptyEntries);
NameData JudgeName = null;
if (Splits.Length == 2)
{
JudgeName = NameDatabase.FindInDatabase(Splits[0], Splits[1]);
if (JudgeName == null)
{
JudgeName = NameDatabase.FindInDatabase(Splits[1], Splits[0]);
}
}
if (JudgeName != null)
{
EditDiffData.JudgeNameId = JudgeName.Id;
}
}
else
{
GUILayout.Label(NameDatabase.FindInDatabase(EditDiffData.JudgeNameId).DisplayName + ": ", labelStyle);
}
for (int i = 0; i < EditDiffData.NumScores; ++i)
{
string DiffStr = GUILayout.TextField(EditDiffData.DiffScores[i].ToString() + EditDiffData.GetConsecString(i));
if (DiffStr.Contains("-"))
{
DiffStr = DiffStr.Replace("-", "");
EditDiffData.ConsecScores[i] = -1;
}
else if (DiffStr.Contains("+"))
{
DiffStr = DiffStr.Replace("+", "");
EditDiffData.ConsecScores[i] = 1;
}
else
{
EditDiffData.ConsecScores[i] = 0;
}
float.TryParse(DiffStr, out EditDiffData.DiffScores[i]);
}
GUILayout.EndHorizontal();
GUILayout.EndVertical();
}
}
GUILayout.EndVertical();
GUILayout.EndScrollView();
if (CatCombo.GetSelectedItemIndex() != 3)
{
if (!bInEditingMode && GUILayout.Button("Enter Edit Mode", GUILayout.Height(Screen.height * .1f)))
{
bInEditingMode = true;
}
else if (bInEditingMode)
{
if (bIsEditing)
{
GUILayout.BeginHorizontal();
if (GUILayout.Button("Delete Score", GUILayout.Height(Screen.height * .1f)))
{
TeamData Data = Global.AllData.AllDivisions[CurDivIndex].Rounds[CurRoundIndex].Pools[EditPoolIndex].Teams[EditTeamIndex].Data;
if (CatCombo.GetSelectedItemIndex() == 0)
{
if (!bEditAddNewData && EditJudgeIndex < Data.RoutineScores.AIResults.Count)
{
Data.RoutineScores.AIResults[EditJudgeIndex] = new AIData();
}
EditAIData = null;
}
else if (CatCombo.GetSelectedItemIndex() == 1)
{
if (!bEditAddNewData && EditJudgeIndex < Data.RoutineScores.ExResults.Count)
{
Data.RoutineScores.ExResults[EditJudgeIndex] = new ExData();
}
EditExData = null;
}
else if (CatCombo.GetSelectedItemIndex() == 2)
{
if (!bEditAddNewData && EditJudgeIndex < Data.RoutineScores.DiffResults.Count)
{
Data.RoutineScores.DiffResults[EditJudgeIndex] = new DiffData();
}
EditDiffData = null;
}
bIsEditing = false;
EditAIData = null;
EditExData = null;
EditDiffData = null;
bEditAddNewData = false;
Global.AllData.Save();
}
if (GUILayout.Button("Discard Changes", GUILayout.Height(Screen.height * .1f)))
{
bIsEditing = false;
EditAIData = null;
EditExData = null;
EditDiffData = null;
bEditAddNewData = false;
}
if (GUILayout.Button("Save Changes", GUILayout.Height(Screen.height * .1f)))
{
TeamData Data = Global.AllData.AllDivisions[CurDivIndex].Rounds[CurRoundIndex].Pools[EditPoolIndex].Teams[EditTeamIndex].Data;
if (CatCombo.GetSelectedItemIndex() == 0)
{
if (bEditAddNewData)
{
Data.RoutineScores.AIResults.Add(new AIData(EditAIData));
}
else
{
Data.RoutineScores.AIResults[EditJudgeIndex] = new AIData(EditAIData);
}
EditAIData = null;
}
else if (CatCombo.GetSelectedItemIndex() == 1)
{
if (bEditAddNewData)
{
Data.RoutineScores.ExResults.Add(new ExData(EditExData));
}
else
{
Data.RoutineScores.ExResults[EditJudgeIndex] = new ExData(EditExData);
}
EditExData = null;
}
else if (CatCombo.GetSelectedItemIndex() == 2)
{
if (bEditAddNewData)
{
Data.RoutineScores.DiffResults.Add(new DiffData(EditDiffData));
}
else
{
Data.RoutineScores.DiffResults[EditJudgeIndex] = new DiffData(EditDiffData);
}
EditDiffData = null;
}
bIsEditing = false;
bEditAddNewData = false;
Global.AllData.Save();
}
GUILayout.EndHorizontal();
}
else if (GUILayout.Button("Exit Edit Mode", GUILayout.Height(Screen.height * .1f)))
{
bInEditingMode = false;
}
}
}
GUILayout.EndVertical();
GUILayout.EndArea();
}
}
void DrawLeftPane()
{
Rect LeftRect = new Rect(20, 110, Screen.width / 2 - 40, Screen.height * .75f - 20);
GUILayout.BeginArea(LeftRect);
GUILayout.BeginVertical();
TeamsScrollPos = GUILayout.BeginScrollView(TeamsScrollPos, GUILayout.MaxHeight(LeftRect.height / 2f));
string NewInputTeamsText = GUILayout.TextArea(InputTeamsText, GUILayout.MinHeight(LeftRect.height / 2.2f));
InputTeamsEditor = (TextEditor)GUIUtility.GetStateObject(typeof(TextEditor), GUIUtility.keyboardControl);
UpdateInputTeamsText(NewInputTeamsText);
GUILayout.EndScrollView();
ErrorsScrollPos = GUILayout.BeginScrollView(ErrorsScrollPos, GUILayout.MaxHeight(LeftRect.height * .25f));
GUILayout.BeginVertical();
GUILayout.Label("Errors: " + ErrorList.Count);
foreach (ErrorLine el in ErrorList)
{
//GUIStyle ErrorStyle = new GUIStyle();
GUILayout.BeginHorizontal();
foreach (ErrorData ed in el.ErrorList)
{
if (ed.bIsError)
{
if (GUILayout.Button(ed.PlayerName))
{
bFixingNameError = true;
EditingErrorData = ed;
char[] Seperators = new char[] { ',', '-', ' ', '.' };
string[] ErrorNames = ed.PlayerName.Split(Seperators);
if (ed.PlayerName.Contains(","))
{
if (ErrorNames.Length > 0)
{
ErrorLastSearchStr = ErrorNames[0].Trim();
}
if (ErrorNames.Length > 1)
{
ErrorFirstSearchStr = ErrorNames[1].Trim();
}
}
else
{
if (ErrorNames.Length > 0)
{
ErrorFirstSearchStr = ErrorNames[0].Trim();
}
if (ErrorNames.Length > 1)
{
ErrorLastSearchStr = ErrorNames[1].Trim();
}
}
}
}
else
{
GUILayout.Label(ed.PlayerName + " - ");
}
}
GUILayout.EndHorizontal();
}
GUILayout.EndVertical();
GUILayout.EndScrollView();
RoundsScrollPos = GUILayout.BeginScrollView(RoundsScrollPos, GUILayout.MaxHeight(LeftRect.height / 2f));
GUIStyle RoundButtonStyle = new GUIStyle("button");
RoundButtonStyle.alignment = TextAnchor.MiddleLeft;
for (int DivIndex = 0; DivIndex < Global.AllData.AllDivisions.Length; ++DivIndex)
{
DivisionData DivData = Global.AllData.AllDivisions[DivIndex];
if (DivData.HasAnyPoolData())
{
for (int RoundIndex = 0; RoundIndex < DivData.Rounds.Length; ++RoundIndex)
{
RoundData RData = DivData.Rounds[RoundIndex];
if (RData.HasAnyPoolData())
{
GUIContent RoundContent = new GUIContent(((EDivision)DivIndex) + " - " + ((ERound)RoundIndex) + (RData.ContainsJudgeScores() ? " - Results" : ""));
Vector2 RoundTextSize = RoundButtonStyle.CalcSize(RoundContent);
if (GUILayout.Button(RoundContent, RoundButtonStyle, GUILayout.Width(LeftRect.width * .9f), GUILayout.Height(RoundTextSize.y)))
{
FillInputWithSavedRound(DivIndex, RoundIndex);
}
}
}
}
}
GUILayout.EndScrollView();
GUILayout.EndVertical();
GUILayout.EndArea();
}
public static void doIt(string sched)
{
Schedule schedule = new Schedule(sched);
// ***********PAUL CHANGE SQL STRING TO PARAMETERIZED COMMAND!!!*******
// https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.parameters?redirectedfrom=MSDN&view=netframework-4.7.2#System_Data_SqlClient_SqlCommand_Parameters
//---------------------------------------------------
// Insert the SCHEDULE into the DB
int scheduleID = ScheduleData.InsertSchedule(schedule);
int i = 0;
//---------------------------------------------------
//---------------------------------------------------
// Insert the list of GAMEs into the DB
// INCLUDES: Insert the TEAMs (insert the CONFERENCE, DIVISION, VENUE), VENUE, list of PERIODs, BOXSCOREs(insert the TEAMGAMESTATS(insert the PERSON/coach, list of PLAYERGAMESTATS), list of PERSON/officials), list of PLAYERs, list of GAMEEVENTs(insert TEAMs, list of PLAYERs), GAMECONTENT)
if (Convert.ToInt16(schedule.totalGames) > 0)
{
foreach (Game g in schedule.games)
{
i = GameData.InsertGame(g, scheduleID);
//---------------------------------------------------
// Insert the Home and Away TEAMs into the DB
// INCLUDES: Insert the VENUE, list of PERIODs, BOXSCOREs(insert the TEAMGAMESTATS(insert the PERSON/coach, list of PLAYERGAMESTATS), list of PERSON/officials), list of PLAYERs, list of GAMEEVENTs(insert TEAMs, list of PLAYERs), GAMECONTENT)
// Insert the Coach (PERSON) for each team
if (!(g.gameBoxScore.homeTeamStats.coach is null))
{
i = PersonData.InsertPerson(g.gameBoxScore.homeTeamStats.coach);
}
if (!(g.gameBoxScore.awayTeamStats.coach is null))
{
i = PersonData.InsertPerson(g.gameBoxScore.awayTeamStats.coach);
}
// Insert the game VENUE
if (!(g.gameVenue is null))
{
i = VenueData.InsertVenue(g.gameVenue);
}
// Insert the game Officials (PERSON)
if (!(g.gameBoxScore.officials is null))
{
foreach (Person p in g.gameBoxScore.officials)
{
i = PersonData.InsertPerson(p);
// Insert officials list to the cross reference table (tblGameOfficials)
i = PersonData.InsertGameOfficials(g.gameID, p.personId);
}
}
// Insert the Home Team:
i = TeamData.InsertTeam(g.homeTeam);
i = TeamData.InsertTeam(g.awayTeam);
// Insert the CONFERENCE of each team:
i = ConferenceData.InsertConference(g.homeTeam.teamConference);
i = ConferenceData.InsertConference(g.awayTeam.teamConference);
//Insert the DIVISION of each team:
if (!(g.homeTeam.teamDivision is null))
{
i = DivisionData.InsertDivision(g.homeTeam.teamDivision);
}
if (!(g.awayTeam.teamDivision is null))
{
i = DivisionData.InsertDivision(g.awayTeam.teamDivision);
}
//Insert the PERIODs of the Game
if (!(g.periodData is null))
{
foreach (Period p in g.periodData)
{
i = PeriodData.InsertPeriod(p);
}
}
// Insert the details and stats for each home PLAYER
if (!(g.gameBoxScore.homeTeamStats.teamPlayers is null))
{
foreach (PlayerGameStats homepgs in g.gameBoxScore.homeTeamStats.teamPlayers)
{
i = PlayerData.InsertPlayer(homepgs);
i = PlayerGameStatsData.InsertPlayerGameStats(homepgs, g.gameID);
}
}
// Insert the details and stats for each away PLAYER
if (!(g.gameBoxScore.awayTeamStats.teamPlayers is null))
{
foreach (PlayerGameStats awaypgs in g.gameBoxScore.awayTeamStats.teamPlayers)
{
i = PlayerData.InsertPlayer(awaypgs);
i = PlayerGameStatsData.InsertPlayerGameStats(awaypgs, g.gameID);
}
}
// Insert the GAMEEVENTS for the game
if (!(g.gameEvents is null))
{
foreach (GameEvent ge in g.gameEvents)
{
i = GameEventData.InsertGameEvent(ge, g.gameID);
}
}
//---------------------------------------------------
}
}
}
public void DivideTheory(DivisionData point)
{
Assume.That(point.Second != 0);
Assert.That(point.First / point.Second, Is.EqualTo(new ComplexCalcultor().Divide(point.First, point.Second)));
}
