private void button3_Click(object sender, EventArgs e) { if (selected_item_id == nonselected) { System.Windows.Forms.MessageBox.Show("Firstly, select a student id to delete."); } else { Student student = catalog.getByIndex(selected_item_id); if (MessageBox.Show("Are you sure you want to delete " + student.Name + " ? ", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { conn.Connect(); string selectQ = "DELETE FROM students WHERE id = :PR1"; query.setSQL(selectQ); query.addParam("id", ParameterType.ptInteger); query.setParamValueINT("id", student.Id); query.executeNonQuery(); catalog.deleteByIndex(selected_item_id); setListView(); selected_item_id = nonselected; } catch (Exception ex) { MessageBox.Show("Delete error:" + ex.ToString()); } finally { conn.Disconnect(); } } } }
private void updateOpp() { Student student = catalog.getByIndex(setting); student.Name = textBox2.Text; student.Surname = textBox3.Text; student.BirthDate = textBox4.Text; try { conn.Connect(); string selectQ = "update students set name=:PR1,surname=:PR2,birthdate=:PR3 where id=:PR4"; query.setSQL(selectQ); query.addParam("name", ParameterType.ptVarChar); query.setParamValueSTRING("name", student.Name); query.addParam("surname", ParameterType.ptVarChar); query.setParamValueSTRING("surname", student.Surname); query.addParam("birthdate", ParameterType.ptVarChar); query.setParamValueSTRING("birthdate", student.BirthDate); query.addParam("id", ParameterType.ptInteger); query.setParamValueINT("id", student.Id); query.executeNonQuery(); mainform.setListView(); MessageBox.Show("Student is updated"); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); } catch (Exception ex) { MessageBox.Show("Setup error:" + ex.ToString()); } finally { conn.Disconnect(); } }