public bool writeFile(BingoWordFile file)
{
if (file.filePath.EndsWith(".bwf") == false)
{
file.filePath += ".bwf";
} //Bingo word file
Cursor.Current = Cursors.WaitCursor;
try
{
using (DbConnection configdb = new SQLiteConnection("Data Source=" + file.filePath))
{
using (DbCommand cmd = configdb.CreateCommand())
{
//open the connection
configdb.Open();
try
{
cmd.CommandText = "DROP TABLE info";
cmd.ExecuteNonQuery();
}
catch
{
}
try
{
cmd.CommandText = "DROP TABLE wordlist";
cmd.ExecuteNonQuery();
}
catch
{
}
try
{
int freeSpacePrint = file.printFreeSpaceToInt();
int titlePrint = file.printTitleToInt();
cmd.CommandText = "CREATE TABLE info (cardtitletext TEXT, cardfreespacetext TEXT, cardrowsize TEXT, cardcolsize TEXT, numcardstoprint TEXT, numcardsperpage TEXT, printTitle TEXT, printFreeSpace TEXT)";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT into info VALUES ('" + file.cardTitleText + "','" + file.cardFreeSpaceText + "','" + file.cardRowSize.ToString() + "', '" + file.cardColSize.ToString() + "', '" + file.numCardsToPrint.ToString() + "', '" + file.numCardsPerPage.ToString() + "', '" + titlePrint.ToString() + "', '" + freeSpacePrint.ToString() + "')";
cmd.ExecuteNonQuery();
}
catch
{
}
try
{
cmd.CommandText = "CREATE TABLE wordlist (word TEXT)";
cmd.ExecuteNonQuery();
foreach (string item in file.wordList)
{
cmd.CommandText = "INSERT into wordlist VALUES ('" + item + "')";
cmd.ExecuteNonQuery();
}
}
catch
{
}
try
{
configdb.Close();
}
catch
{
}
}
}
}
catch
{
}
finally
{
Cursor.Current = Cursors.Default;
}
return (true);
}
public BingoWordFile openFile(string filePath)
{
BingoWordFile file = new BingoWordFile(filePath);
int printTitle = 0;
int printFreeSpace = 0;
Cursor.Current = Cursors.WaitCursor;
try
{
using (DbConnection configdb = new SQLiteConnection("Data Source=" + file.filePath))
{
using (DbCommand cmd = configdb.CreateCommand())
{
configdb.Open();
cmd.CommandText = "SELECT * FROM 'info'";
try
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
try
{
file.cardTitleText = reader["cardtitletext"].ToString();
}
catch
{
file.cardTitleText = "";
}
try
{
file.cardFreeSpaceText = reader["cardfreespacetext"].ToString();
}
catch
{
file.cardFreeSpaceText = "";
}
try
{
file.cardRowSize = int.Parse(reader["cardrowsize"].ToString());
}
catch
{
file.cardRowSize = 5;
}
try
{
file.cardColSize = int.Parse(reader["cardcolsize"].ToString());
}
catch
{
file.cardColSize = 5;
}
try
{
file.numCardsToPrint = int.Parse(reader["numcardstoprint"].ToString());
}
catch
{
file.numCardsToPrint = 1;
}
try
{
file.numCardsPerPage = int.Parse(reader["numcardsperpage"].ToString());
}
catch
{
file.numCardsPerPage = 1;
}
try
{
printTitle = int.Parse(reader["printTitle"].ToString());
}
catch
{
printTitle = 0;
}
if (printTitle >= 1)
{
file.printTitle = true;
}
else
{
file.printTitle = false;
}
try
{
printFreeSpace = int.Parse(reader["printFreeSpace"].ToString());
}
catch
{
printFreeSpace = 0;
}
if (printFreeSpace >= 1)
{
file.printFreeSpace = true;
}
else
{
file.printFreeSpace = false;
}
}
}
}
catch
{
file.cardColSize = file.cardRowSize = 5; //Set default values so we don't get divide by 0
}
cmd.CommandText = "SELECT * FROM 'wordlist'";
try
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
try
{
file.wordList.Add(reader["word"].ToString());
}
catch
{
}
}
}
}
catch
{
}
configdb.Close();
}
}
}
catch
{
}
finally
{
Cursor.Current = Cursors.Default;
}
return (file);
}
public BingoTable(string filePath)
{
BingoWordFile file = new BingoWordFile(filePath);
file = DB.openFile(filePath);
this.filePath = file.filePath;
this.items = new List<string>(file.wordList);
this.titleText = file.cardTitleText;
this.freeSpaceText = file.cardFreeSpaceText;
if (file.cardRowSize > 0)
{
this.rowSize = file.cardRowSize;
}
else
{
this.rowSize = 5;
}
if (file.cardColSize > 0)
{
this.colSize = file.cardColSize;
}
else
{
this.colSize = 5;
}
this.numCardsToPrint = file.numCardsToPrint;
this.numCardsPerPage = file.numCardsPerPage;
this.printTitle = file.printTitle;
this.printFreeSpace = file.printFreeSpace;
}
