/* * private void delete_btn_Click(object sender, EventArgs e) * { * DBConnection con = new DBConnection(); * string delQuery = $"DELETE FROM personal WHERE personal_id = '{id}'"; * try * { * DialogResult result = MessageBox.Show("Are you Sure LAN", "Important Question", MessageBoxButtons.YesNo); * if (result == DialogResult.Yes) * { * con.Delete(delQuery); * refresh(); * id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); * } * } * catch (Exception ex) * { * MessageBox.Show("Error :" + ex); * } * finally * { * search_txtbx.Text = ""; * by_combx.SelectedIndex = -1; * } * } */ private void delete_btn_Click(object sender, EventArgs e) { DBConnection con = new DBConnection(); string delQuery = "delete_student"; try { DialogResult result = MessageBox.Show("Are you Sure?", "Important Question", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { con.Delete(delQuery, id); refresh(); try { id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); } catch (Exception ex) { Start: DialogResult addNewStudent = MessageBox.Show("There is no Registered Students, Add a new student?", "Important Question", MessageBoxButtons.YesNo); if (addNewStudent == DialogResult.Yes) { student_mod myform = new student_mod("-1"); myform.ShowDialog(); refresh(); try { id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); } catch (Exception ex2) { goto Start; } } else { DialogResult Exit = MessageBox.Show("Close Application", "Important Question", MessageBoxButtons.YesNo); if (Exit == DialogResult.Yes) { Application.Exit(); } else { goto Start; } } } } } catch (Exception ex) { MessageBox.Show("Error :" + ex); } finally { search_txtbx.Text = ""; by_combx.SelectedIndex = -1; } }
private void edit_btn_Click(object sender, EventArgs e) { student_mod myform = new student_mod(id); myform.ShowDialog(); refresh(); id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); }
private void student_form_Load(object sender, EventArgs e) { refresh(); current_page = 1; if (current_page == last_page) { prev_btn.Enabled = true; next_btn.Enabled = false; } if (current_page == 1) { prev_btn.Enabled = false; } try { id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); } catch (Exception ex) { Start: DialogResult addNewStudent = MessageBox.Show("There is no Registered Students, Add a new student?", "Important Question", MessageBoxButtons.YesNo); if (addNewStudent == DialogResult.Yes) { student_mod myform = new student_mod("-1"); myform.ShowDialog(); refresh(); try { id = this.data_dgv.Rows[0].Cells[0].Value.ToString(); } catch (Exception ex2) { goto Start; } } else { DialogResult Exit = MessageBox.Show("Close Application", "Important Question", MessageBoxButtons.YesNo); if (Exit == DialogResult.Yes) { Application.Exit(); } else { goto Start; } } } }