private void SystemDefaultsForm_Load(object sender, EventArgs e) { SaveButton.Select(); int BoundsWidth = Screen.PrimaryScreen.Bounds.Width; int BoundsHeight = Screen.PrimaryScreen.Bounds.Height; int X_Coordinate = BoundsWidth - this.Width; int Y_Coordinate = BoundsHeight - this.Height; Location = new Point(X_Coordinate / 2, (Y_Coordinate / 2) + 10); //EXCEPTION 1 try { variables = new Variables(); opacityform = new OpacityForm(); cryptography = new Cryptography(); sqlconnectionconfig = new SQLConnectionConfig(); RegistryKey registrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname); string tempdata = registrykey.GetValue("SQLServerConnectionString").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); //INNER EXCEPTION 1 try { //DON'T MIND THIS ! Where_To_Check_Radio_Buttons(); //DISPLAY CURRENT SCHOOL YEAR Init_Current_SchoolYear(); //INITIALIZE SCHOOL YEAR DROPDOWN AND ID Retrieve_School_Year_List_And_ID(); //CHECK VALIDITY OF SECTIONS Enable_Or_Disable_2ndSaveButton(); //INITIALIZE SECTION ID DROPDOWN Retrieve_SectionID_List(); //POPULATE DATAGRIDVIES Load_Section_Records(); Load_School_Year_Records(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Other Settings Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Other Settings Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
//SAVE CURRENT SCHOOL YEAR private void SaveButton_Click(object sender, EventArgs e) { variables = new Variables(); opacityform = new OpacityForm(); //EXCEPTION 2 try { darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); string GetID = "SELECT [ENTRY ID] FROM [Tbl.SchoolYear] WHERE [SCHOOL YEAR] = '" + CurrentSchoolYearDropdown.selectedValue.ToString() + "'"; sqlcommand = new SqlCommand(GetID, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { EntryID = sqldatareader.GetString(0); } sqldatareader.Close(); string TempQuery = "SELECT COUNT(*) FROM [Tbl.CurrentSchoolYear]"; sqldataadapter = new SqlDataAdapter(TempQuery, sqlconnection); DataTable datatable = new DataTable(); sqldataadapter.Fill(datatable); if (int.Parse(datatable.Rows[0][0].ToString()) > 0) { string UpdateQuery0 = "UPDATE [Tbl.CurrentSchoolYear] SET [CURRENT SCHOOL YEAR] = @currentschoolyear, [SCHOOL YEAR ID] = @slyid"; sqlcommand = new SqlCommand(UpdateQuery0, sqlconnection); sqlcommand.Parameters.AddWithValue("@currentschoolyear", CurrentSchoolYearDropdown.selectedValue.ToString()); sqlcommand.Parameters.AddWithValue("@slyid", EntryID); sqlcommand.ExecuteNonQuery(); string UpdateQuery1 = "UPDATE [Tbl.SchoolYear] SET [WAS SET] = @ws WHERE [ENTRY ID] = '" + EntryID + "'"; sqlcommand = new SqlCommand(UpdateQuery1, sqlconnection); sqlcommand.Parameters.AddWithValue("@ws", "1"); sqlcommand.ExecuteNonQuery(); notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.check; notificationwindow.MessageText = "CURRENT SCHOOL YEAR WAS\nSET TO " + CurrentSchoolYearDropdown.selectedValue.ToString(); darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); //SYNC NEW CURRENT SECTION LABEL CurrentSchoolYearLabel.Text = "* CURRENT SCHOOL YEAR: " + CurrentSchoolYearDropdown.selectedValue.ToString(); //RESET CONTROL STATE CurrentSchoolYearDropdown.selectedIndex = 0; } else if (datatable.Rows[0][0].ToString() == "0") { string UpdateQuery0_0 = "INSERT INTO [Tbl.CurrentSchoolYear]([CURRENT SCHOOL YEAR], [SCHOOL YEAR ID]) VALUES(@currentschoolyear, @slyid)"; sqlcommand = new SqlCommand(UpdateQuery0_0, sqlconnection); sqlcommand.Parameters.AddWithValue("@currentschoolyear", CurrentSchoolYearDropdown.selectedValue.ToString()); sqlcommand.Parameters.AddWithValue("@slyid", EntryID); sqlcommand.ExecuteNonQuery(); string UpdateQuery1 = "UPDATE [Tbl.SchoolYear] SET [WAS SET] = @ws WHERE [ENTRY ID] = '" + EntryID + "'"; sqlcommand = new SqlCommand(UpdateQuery1, sqlconnection); sqlcommand.Parameters.AddWithValue("@ws", "1"); sqlcommand.ExecuteNonQuery(); notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.check; notificationwindow.MessageText = "CURRENT SCHOOL YEAR WAS\nSET TO " + CurrentSchoolYearDropdown.selectedValue.ToString(); darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); //SYNC NEW CURRENT SECTION LABEL CurrentSchoolYearLabel.Text = "* CURRENT SCHOOL YEAR: " + CurrentSchoolYearDropdown.selectedValue.ToString(); //RESET CONTROL STATE CurrentSchoolYearDropdown.selectedIndex = 0; } //UPDATE REGISTRY VALUES RegistryKey updateregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); updateregistrykey.SetValue("NofMaxSections", "0"); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Other Settings Form Exception 2", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }