//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();
}
}
private void Retrieve_SectionID_List()
{
try
{
string sqlquery2 = "SELECT [SECTION ID] FROM [Tbl.Sections]";
sqlcommand = new SqlCommand(sqlquery2, sqlconnection);
SqlDataReader sqldatareader = sqlcommand.ExecuteReader();
while (sqldatareader.Read())
{
SectionIDDropdown.AddItem(sqldatareader.GetString(0));
}
sqldatareader.Close();
SectionIDDropdown.selectedIndex = 0;
}
catch (Exception)
{
//DO NOTHING SHIT !
}
}
