/// <summary> /// Shows the number table /// </summary> private void ShowNumberTable() { Task.Run(() => { CurrentDataTable = DatabaseControl.GetDataTable("SELECT * FROM NumberTable"); CurrentDataView = CurrentDataTable.DefaultView; }); }
/// <summary> /// Inserts the required data into the tables /// </summary> public static void InsertTables() { var dataTable = DatabaseControl.GetDataTable("SELECT * FROM MainTable"); NumberAnalysis numberAnalysis = new NumberAnalysis(); // Calculate and instert each row in draw table foreach (DataRow row in dataTable.Rows) { numberAnalysis.Update(row); DrawAnalysis drawAnalysis = new DrawAnalysis(row); drawAnalysis.Analyze(); DatabaseControl.InsertRow("DrawTable", drawAnalysis.DrawRow); } // Insert the number table for (int number = 1; number < 50; number++) { object[] temp = new object[6]; // Id and frequency for (int idx = 0; idx < 2; idx++) { temp[idx] = numberAnalysis.NumberRow[number, idx]; } // Frequency % temp[2] = 100 * (double)numberAnalysis.NumberRow[number, 1] / numberAnalysis.LastDraw; // Last delay temp[3] = numberAnalysis.NumberRow[number, 2]; // Max delays temp[4] = numberAnalysis.NumberRow[number, 3]; // Average delay temp[5] = (double)numberAnalysis.NumberRow[number, 4] / (double)numberAnalysis.NumberRow[number, 5]; DatabaseControl.InsertRow("NumberTable", temp); } }
/// <summary> /// Shows the draw table /// </summary> private void ShowDrawTable() { Task.Run(() => { CurrentDataTable = DatabaseControl.GetDataTable("SELECT * FROM DrawTable ORDER BY 'Draw Number' DESC"); DataTable cloned = CurrentDataTable.Clone(); cloned.Columns[1].DataType = typeof(string); foreach (DataRow row in CurrentDataTable.Rows) { cloned.ImportRow(row); } foreach (DataRow row in cloned.Rows) { row[1] = ((string)row[1]).Remove(((string)row[1]).IndexOf(' ')); } CurrentDataView = cloned.DefaultView; }); }