//DELETE SECTIONS private void DeleteFlatButton1_Click(object sender, EventArgs e) { variables = new Variables(); opacityform = new OpacityForm(); //DELETE SECTION EXCEPTION try { darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); string TempQuery = "SELECT COUNT(*) FROM [Tbl.Sections]" + " WHERE [SECTION ID] = '" + SectionIDDropdown.selectedValue.ToString() + "' AND [ENROLLED] = '0'"; sqldataadapter = new SqlDataAdapter(TempQuery, sqlconnection); DataTable datatable = new DataTable(); sqldataadapter.Fill(datatable); if (datatable.Rows[0][0].ToString() == "1") { RegistryKey registrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname); string CurrentSectionCount = registrykey.GetValue("NofMaxSections").ToString(); string DeleteQuery = "DELETE FROM [Tbl.Sections] WHERE [SECTION ID] = '" + SectionIDDropdown.selectedValue.ToString() + "'"; sqlcommand = new SqlCommand(DeleteQuery, sqlconnection); sqlcommand.ExecuteNonQuery(); //UPDATE SECTION COUNT RegistryKey updateregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); updateregistrykey.SetValue("NofMaxSections", (int.Parse(CurrentSectionCount) - 1).ToString()); //REFRESH SECTIONS GRIDVIEW Load_Section_Records(); //REMOVE DELETED ID SectionIDDropdown.Clear(); //RETRIEVE NEW VALUES Retrieve_SectionID_List(); } else if (datatable.Rows[0][0].ToString() == "0") { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.error; notificationwindow.MessageText = "THIS SECTION CAN'T BE DELETED,\nSOME STUDENTS ARE ENROLLED HERE !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Delete Section Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
//DELETE SCHOOL YEAR private void DeleteFlatButton2_Click(object sender, EventArgs e) { opacityform = new OpacityForm(); //DELETE SCHOOL YEAR EXCEPTION try { darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); string TempString = "SELECT COUNT(*) FROM [Tbl.SchoolYear] WHERE [ENTRY ID] = '" + SchoolYearIDDropdown.selectedValue.ToString() + "' AND [WAS SET] = '0'"; sqldataadapter = new SqlDataAdapter(TempString, sqlconnection); DataTable datatable = new DataTable(); sqldataadapter.Fill(datatable); if (datatable.Rows[0][0].ToString() == "1") { string DeleteQuery = "DELETE FROM [Tbl.SchoolYear] WHERE [ENTRY ID] = '" + SchoolYearIDDropdown.selectedValue.ToString() + "'"; sqlcommand = new SqlCommand(DeleteQuery, sqlconnection); sqlcommand.ExecuteNonQuery(); //REFRESH SCHOOL YEAR GRIDVIEW Load_School_Year_Records(); //REMOVE DELETED VALUES CurrentSchoolYearDropdown.Clear(); SectionIDDropdown.Clear(); SchoolYearDropdown.Clear(); SchoolYearIDDropdown.Clear(); //RETRIEVE NEW VALUES Retrieve_School_Year_List_And_ID(); Retrieve_SectionID_List(); } else if (datatable.Rows[0][0].ToString() == "0") { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.error; notificationwindow.MessageText = "THIS SCHOOL YEAR CAN'T BE DELETED,\nSOME STUDENTS ARE ENROLLED HERE !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Delete School Year Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }