public static void ExportEachNumberOccurencesToMathematicaMatrix(SQLUtils.ConnectionString con, string Path, int Rows, int Columns)
{
StringBuilder sb = new StringBuilder();
int k = 1;
sb.Append("{");
for (int j = 0; j < Rows; j++) //rows
{
for (int i = 0; i < Columns; i++) //columns
{
if (i == 0)
{
sb.Append("{");
}
sb.Append(SQLQueries.procedure_CountEachNumberOccurencesOutput(con.ToString(), k++));
if (i != Columns - 1)
{
sb.Append(", ");
}
else
{
sb.Append("}");
}
}
if (j != Rows - 1)
{
sb.Append(",");
}
}
System.IO.StreamWriter file = new System.IO.StreamWriter(Path);
sb.Append("}");
file.WriteLine(sb.ToString());
file.Close();
}
public void Testprocedure_ValidateDatabaseRowNumbers()
{
Assert.IsTrue(SQLQueries.procedure_ValidateDatabaseRowNumbers(connectionString.ToString()));
}