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