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