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