public Form1() { InitializeComponent(); sort = Sort.ID; goal = 100; dbConnection = new SQLiteConnection("Data Source=GradeDatabase.db;Version=3;"); dbConnection.Open(); // Test for grades table try { string sql = "select * from grades"; SQLiteCommand command = new SQLiteCommand(sql, dbConnection); SQLiteDataReader reader = command.ExecuteReader(); } catch { string sql = GradeItem.MakeTableText(); SQLiteCommand command = new SQLiteCommand(sql, dbConnection); command.ExecuteNonQuery(); } label7.Text = ""; RefreshDisplay(); }
private void InsertClick(object sender, EventArgs e) { // read in and validate values, then add new item to database if (textBox1.Text == "") { MessageBox.Show("Please enter Class ID"); textBox1.Focus(); return; } if (textBox2.Text == "") { MessageBox.Show("Please enter Assignment"); textBox2.Focus(); return; } int count; int finished; int length; int priority; if (!numTextBox1.GetValue(out count)) { MessageBox.Show("Please enter number of items"); numTextBox1.Focus(); return; } if (!numTextBox2.GetValue(out finished)) { MessageBox.Show("Please enter number finished"); numTextBox2.Focus(); return; } if (!numTextBox3.GetValue(out length)) { MessageBox.Show("Please enter task length"); numTextBox3.Focus(); return; } if (!numTextBox4.GetValue(out priority)) { MessageBox.Show("Please enter task priority"); numTextBox4.Focus(); return; } string classId = textBox1.Text; string assignment = textBox2.Text; bool done = checkBox1.Checked ? true : false; Item = new GradeItem(classId, assignment, count, finished, length, priority); Item.Done = done; this.DialogResult = DialogResult.OK; }
private void AddItemClick(object sender, EventArgs e) { GradeItemDialog gid = new GradeItemDialog(); if (gid.ShowDialog() == DialogResult.OK) { GradeItem i = gid.Item; string sql = i.SQLiteInsert(); SQLiteCommand command = new SQLiteCommand(sql, dbConnection); command.ExecuteNonQuery(); RefreshDisplay(); } else { //MessageBox.Show("Task Add Canceled"); } }
private void NewDatabaseClick(object sender, EventArgs e) { if (MessageBox.Show("Would you like to drop all tables and rebuild the database?", "Drop Tables", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (MessageBox.Show("Are you REALLY sure you want to drop all tables and rebuild the database?", "Drop Tables", MessageBoxButtons.YesNo) == DialogResult.Yes) { string sql; SQLiteCommand command; sql = "DROP TABLE IF EXISTS grades"; command = new SQLiteCommand(sql, dbConnection); command.ExecuteNonQuery(); sql = GradeItem.MakeTableText(); richTextBox1.Text = sql; command = new SQLiteCommand(sql, dbConnection); command.ExecuteNonQuery(); MessageBox.Show("done."); } } }