//SCHOOL YEAR ID public string GetSchoolYearPrefix() { 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(); sqlquery0 = "SELECT PREFIX FROM [Tbl.Defaults] WHERE [ENTRY NAME] = '" + "SCHOOL YEAR ID" + "'"; sqlcommand = new SqlCommand(sqlquery0, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { schoolyearid_prefix = sqldatareader.GetString(0); } sqldatareader.Close(); return(schoolyearid_prefix); }
private void ChangePasswordForm_Load(object sender, EventArgs e) { OldPasswordTextbox.ResetText(); ConfirmPasswordTextbox.ResetText(); NewPasswordTextbox.Focus(); //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(); currentuserid = registrykey.GetValue("User ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); //INNER EXCEPTION 1 try { sqlquery1 = "SELECT PASSWORD FROM [Tbl.Users] WHERE [USER ID] = '" + currentuserid + "'"; sqlcommand = new SqlCommand(sqlquery1, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { OldPasswordTextbox.Text = cryptography.Decrypt(sqldatareader.GetString(0)); } sqldatareader.Close(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Change Password Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Change Password Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void ImportForm_Load(object sender, EventArgs e) { 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) + 26); SaveButton.Enabled = false; GenerateidButton.Enabled = false; GenerateupButton.Enabled = false; SaveButton.Cursor = Cursors.No; GenerateidButton.Cursor = Cursors.No; GenerateupButton.Cursor = Cursors.No; //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 { GetCurrentSchoolYear(); Populate_Section_Gridview(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Import Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Import Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void StudentAverageForm_RON_Load(object sender, EventArgs e) { //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 { GetCurrentSchoolYear(); GetSchoolYearList(); Retrieve_Account_Picture(); Retrieve_StudentName_StudentID(); Retrive_StudentLRN_Section_GradeLevel(); Populate_DataGridView(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Average Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Average Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void AccountPermissionsForm_Load(object sender, EventArgs e) { //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 { //TODO: string Query1 = "SELECT * FROM [Tbl.Permissions]"; sqldataadapter = new SqlDataAdapter(Query1, sqlconnection); DataTable datatable = new DataTable(); sqldataadapter.Fill(datatable); ListofPermissionsGridview.AutoGenerateColumns = false; ListofPermissionsGridview.DataSource = datatable; } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Account Permission Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Account Permission Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void StudentSettingsForm_Load(object sender, EventArgs e) { 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(); StudentID = registrykey.GetValue("Student ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); try { GetCurrentSchoolYear(); Populate_Section_Gridview(); Get_Old_Student_Data(); Fill_New_SectionDropdown(); Determine_Student_GradeLevel_And_Set_For_Identifier(); ListofSections_GroupBox.Text = "LIST OF SECTIONS FOR THE SCHOOL YEAR: " + CurrentSchoolYear; Enable_Disable_Update_Button(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Settings Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Settings Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void AddSectionForm_Load(object sender, EventArgs e) { InsertButton.Select(); //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 { Init_NewSectionID(); RetriveSectionData(); RetrieveSchoolYearList(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Add Section Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.ToString(), "@Add Section Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void ManageTeachersForm_Load(object sender, EventArgs e) { //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 { Where_To_Check_CheckBoxes(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Manage Teacher Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Manage Teacher Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void ListOfSystemObjectsForm_Load(object sender, EventArgs e) { 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) + 26); //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(); UserID = registrykey.GetValue("User ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); DisplayStudentsListInHumanReadableFormat(); DisplayTeachersListInHumanReadableFormat(); DisplayUsersListInHumanReadableFormat(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@List Of System Objects Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
public string GetCurrentSchoolYearData() { //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(); sqlquery1 = "SELECT [CURRENT SCHOOL YEAR] FROM [Tbl.CurrentSchoolYear]"; sqlcommand = new SqlCommand(sqlquery1, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { SchoolYear = sqldatareader.GetString(0); } sqldatareader.Close(); return(SchoolYear); } catch (Exception exception) { MessageBox.Show(exception.Message.ToString(), "@GetCurrentSchoolYear Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); return(SchoolYear); } }
//PICTURE ID public string GetPictureIDPrefix() { 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(); sqlquery2 = "SELECT PREFIX FROM [Tbl.Defaults] WHERE [ENTRY NAME] = '" + "PICTURE ID" + "'"; sqlcommand = new SqlCommand(sqlquery2, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { pictureid_prefix = sqldatareader.GetString(0); } sqldatareader.Close(); return(pictureid_prefix); } catch (Exception exception) { MessageBox.Show(exception.Message.ToString(), "@GetSpecifiedPrefix Exception 2", MessageBoxButtons.OK, MessageBoxIcon.Error); return(pictureid_prefix); } }
private void AccountInformationForm_Load(object sender, EventArgs e) { 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)); //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(); TeacherID = registrykey.GetValue("Teacher ID").ToString(); UserID = registrykey.GetValue("User ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); //INNER EXCEPTION 1 try { RetrievePersonalInformation(); RetrieveAccountInformation(); LoadAccountImage(); GetCurrentSchoolYear(); Init_1(); RetrieveHandledSubjects(); Init_2(); RetrieveAssignedSections(); LoadSectionsList(); Where_to_Check_Checkboxes(); Enable_DisAble_Update_Buttons(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "Account Information Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "Account Information Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
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(); } }
private void StudentEditDetailsForm_Load(object sender, EventArgs e) { 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) + 26); //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(); StudentID = registrykey.GetValue("Student ID").ToString(); UserID = registrykey.GetValue("User ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); //INNER EXCEPTION 1 try { //LOAD ACCOUNT PICTURE Load_Account_Picture(); //LOAD PERSONAL INFO AS PLACEHOLDER Load_Personal_Info_AsPlaceholder(); //LOAD FAMILY BACKGROUND AS PLACEHOLDER Load_Family_Background_AsPlaceholder(); //LOAD ACCOUNT INFORMATION Load_Account_Information(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Edit Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Student Edit Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void OKButton_Click(object sender, EventArgs e) { opacityform = new OpacityForm(); darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); //EXCEPTION 2 try { //SHOW VISUAL REPRESENTATION FOR EMPTY TEXTBOXES Show_Hide_Visual_Representation_Labels(); if (ServerNameTextbox.Text.Length == 0 || DatabaseNameTextbox.Text.Length == 0 || SqlServerUsernameTextbox.Text.Length == 0 || SqlServerPasswordTextbox.Text.Length == 0) { notificationwindow.CaptionText = "CONNECTION REFUSED"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (ServerNameTextbox.Text.EndsWith(" ") || DatabaseNameTextbox.Text.EndsWith(" ") || SqlServerUsernameTextbox.Text.EndsWith(" ") || SqlServerPasswordTextbox.Text.EndsWith(" ")) { notificationwindow.CaptionText = "CONNECTION REFUSED"; notificationwindow.MsgImage.Image = Properties.Resources.error; notificationwindow.MessageText = "LOGIN FAILED !\nPLEASE REVIEW YOUR INFORMATION."; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (ServerNameTextbox.Text.Length != 0 && DatabaseNameTextbox.Text.Length != 0 && SqlServerUsernameTextbox.Text.Length != 0 && SqlServerPasswordTextbox.Text.Length != 0) { //INNER EXCEPTION 2 try { variables = new Variables(); cryptography = new Cryptography(); sqlconfig = new SQLConnectionConfig(); tempconnectionstring = "Data Source=" + ServerNameTextbox.Text + ";" + "Initial Catalog=" + DatabaseNameTextbox.Text + ";" + "Persist Security Info=True;" + "User ID=" + SqlServerUsernameTextbox.Text + ";" + "Password="******""; sqlconfig.SqlConnectionString = tempconnectionstring; sqlconnection = new SqlConnection(sqlconfig.SqlConnectionString); do { Cursor = Cursors.AppStarting; sqlconnection.Open(); if (sqlconnection.State == ConnectionState.Open) { //PLEASE CHANGE THIS CODE ! if (DatabaseNameTextbox.Text.Trim().Equals("BUKSU.SLS_DB")) { notificationwindow.CaptionText = "CONNECTION RESULTS"; notificationwindow.MsgImage.Image = Properties.Resources.check; notificationwindow.MessageText = "YOU'RE ALL SET ! CONNECTION\nWAS SUCCESSFULY ESTABLISHED."; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); variables.UserSqlConnectionString = tempconnectionstring; //INNER EXCEPTION 3 try { RegistryKey registrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); registrykey.SetValue("SQLServerConnectionString", cryptography.Encrypt(tempconnectionstring)); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Server Connection Inner Exception 3", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } Cursor = Cursors.Default; DialogResult = DialogResult.OK; break; } else { notificationwindow.CaptionText = "CONNECTION RESULTS"; notificationwindow.MsgImage.Image = Properties.Resources.error; notificationwindow.MessageText = "INVALID DATABASE - " + DatabaseNameTextbox.Text.Trim() + "\nDATABASE DOES NOT CONTAIN ALL\nTHE TABLES NEEDED TO RUN THE SYSTEM !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); Cursor = Cursors.Default; break; } } }while (sqlconnection.State == ConnectionState.Closed); sqlconnection.Close(); } catch (Exception exception) { Cursor = Cursors.Default; opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Server Connection Inner Exception 2", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Server Connection Exception 2", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void AddStudentForm_Load(object sender, EventArgs e) { 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) + 25); SubmitButton.Select(); BirthdayPicker.Value = DateTime.Now; //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); DataTable datatable = new DataTable(); sqlconnection.Open(); //INNER EXCEPTION 1 try { //INIT STUDENT ID AssignNewStudentID(); //INIT NEW USER ID AssignNewUserID(); //GET CURRENT SCHOOL YEAR GetCurrentSchoolYear(); //INIT SECTION DROPDOWN RetrieveSectionList(); } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.StackTrace.ToString(), "@Add Student Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.StackTrace.ToString(), "@Add Student Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
public void VerifyLoginCredentials(LoginForm Controls) { Controls.LoginErrorMessage.Text = ""; Controls.LoginErrorMessage.Visible = false; if (Controls.UsernameTextbox.Text.Length == 0) { System.Threading.Thread.Sleep(100); Controls.LoginErrorMessage.Text = "USERNAME REQUIRED !"; Controls.LoginErrorMessage.Location = new Point(141, 134); Controls.LoginErrorMessage.Visible = true; Controls.UsernameTextbox.Focus(); } else if (Controls.PasswordTextbox.Text.Length == 0) { System.Threading.Thread.Sleep(100); Controls.LoginErrorMessage.Text = "PASSWORD REQUIRED !"; Controls.LoginErrorMessage.Location = new Point(141, 134); Controls.LoginErrorMessage.Visible = true; Controls.PasswordTextbox.Focus(); } else if (Controls.PasswordTextbox.Text.Length != 0 && Controls.PasswordTextbox.Text.Length != 0) { if (Controls.UsernameTextbox.Text.EndsWith(" ") || Controls.PasswordTextbox.Text.EndsWith(" ")) { System.Threading.Thread.Sleep(100); Controls.LoginErrorMessage.Text = "SORRY, THAT DIDN'T WORK !"; Controls.LoginErrorMessage.Location = new Point(126, 134); Controls.LoginErrorMessage.Visible = true; IsVerified = false; } else { variables = new Variables(); opacityform = new OpacityForm(); cryptography = new Cryptography(); sqlconfig = new SQLConnectionConfig(); sqlmanualconn = new ServerManualConnectionForm(); DataTable datatable = new DataTable(); SqlDataAdapter sqldataadapter; SqlCommand sqlcommand; //EXCEPTION 1 try { RegistryKey getregistrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname); string tempdata = getregistrykey.GetValue("SQLServerConnectionString").ToString(); getregistrykey.Close(); //USER SQLSERVER CONNECTION SETTINGS sqlconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconfig.SqlConnectionString); sqlconnection.Open(); //CHECK ACCOUNT VALIDITY sqlquery1 = "SELECT COUNT(*) FROM [Tbl.Users] WHERE USERNAME = '******' AND PASSWORD = '******' AND [ACCOUNT STATUS] = 'Active' AND [SITUATION STATUS] = '0'"; sqldataadapter = new SqlDataAdapter(sqlquery1, sqlconnection); sqldataadapter.Fill(datatable); //ACCOUNT EXIST if (datatable.Rows[0][0].ToString() == "1") { if (isAdministrator(Controls.UsernameTextbox.Text) == true) { //UPDATE USER LOGIN HISTORY string LongDate, ShortTime; LongDate = DateTime.Now.ToLongDateString(); ShortTime = DateTime.Now.ToShortTimeString(); sqlquery2 = "UPDATE [Tbl.Users] SET [LAST LOGIN] = @lastlogin, [SITUATION STATUS] = @sitstat WHERE USERNAME = @username"; sqlcommand = new SqlCommand(sqlquery2, sqlconnection); sqlcommand.Parameters.AddWithValue("@username", cryptography.Encrypt(Controls.UsernameTextbox.Text.Trim())); sqlcommand.Parameters.AddWithValue("@lastlogin", LongDate + " - " + ShortTime); sqlcommand.Parameters.AddWithValue("@sitstat", "1"); sqlcommand.ExecuteNonQuery(); //SET REGISTRY SETTINGS string wildcardquery = "SELECT [USER ID] FROM [Tbl.Users] WHERE USERNAME = '******'"; sqlcommand = new SqlCommand(wildcardquery, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { Useridvirtualdata = sqldatareader.GetString(0); } sqldatareader.Close(); //SET REGISTRY SETTINGS string newwildcardquery = "SELECT [TEACHER ID] FROM [Tbl.Teachers] WHERE [USER ID] = '" + Useridvirtualdata + "'"; sqlcommand = new SqlCommand(newwildcardquery, sqlconnection); SqlDataReader sqldatareader2 = sqlcommand.ExecuteReader(); while (sqldatareader2.Read()) { TeacheridVirtualdata = sqldatareader2.GetString(0); } sqldatareader2.Close(); RegistryKey newregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); newregistrykey.SetValue("User ID", Useridvirtualdata); newregistrykey.SetValue("Teacher ID", TeacheridVirtualdata); IsVerified = true; IsAdmin = true; sqlconnection.Close(); } else if (isTeacher(Controls.UsernameTextbox.Text) == true) { //UPDATE USER LOGIN HISTORY string LongDate, ShortTime; LongDate = DateTime.Now.ToLongDateString(); ShortTime = DateTime.Now.ToShortTimeString(); sqlquery2 = "UPDATE [Tbl.Users] SET [LAST LOGIN] = @lastlogin, [SITUATION STATUS] = @sitstat WHERE USERNAME = @username"; sqlcommand = new SqlCommand(sqlquery2, sqlconnection); sqlcommand.Parameters.AddWithValue("@username", cryptography.Encrypt(Controls.UsernameTextbox.Text.Trim())); sqlcommand.Parameters.AddWithValue("@lastlogin", LongDate + " - " + ShortTime); sqlcommand.Parameters.AddWithValue("@sitstat", "1"); sqlcommand.ExecuteNonQuery(); //SET REGISTRY SETTINGS string wildcardquery = "SELECT [USER ID] FROM [Tbl.Users] WHERE USERNAME = '******'"; sqlcommand = new SqlCommand(wildcardquery, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { Useridvirtualdata = sqldatareader.GetString(0); } sqldatareader.Close(); //SET REGISTRY SETTINGS string newwildcardquery = "SELECT [TEACHER ID] FROM [Tbl.Teachers] WHERE [USER ID] = '" + Useridvirtualdata + "'"; sqlcommand = new SqlCommand(newwildcardquery, sqlconnection); SqlDataReader sqldatareader2 = sqlcommand.ExecuteReader(); while (sqldatareader2.Read()) { TeacheridVirtualdata = sqldatareader2.GetString(0); } sqldatareader2.Close(); RegistryKey newregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); newregistrykey.SetValue("User ID", Useridvirtualdata); newregistrykey.SetValue("Teacher ID", TeacheridVirtualdata); IsVerified = true; IsTeacher = true; sqlconnection.Close(); } else if (isStudent(Controls.UsernameTextbox.Text) == true) { //UPDATE USER LOGIN HISTORY string LongDate, ShortTime; LongDate = DateTime.Now.ToLongDateString(); ShortTime = DateTime.Now.ToShortTimeString(); sqlquery2 = "UPDATE [Tbl.Users] SET [LAST LOGIN] = @lastlogin, [SITUATION STATUS] = @sitstat WHERE USERNAME = @username"; sqlcommand = new SqlCommand(sqlquery2, sqlconnection); sqlcommand.Parameters.AddWithValue("@username", cryptography.Encrypt(Controls.UsernameTextbox.Text.Trim())); sqlcommand.Parameters.AddWithValue("@lastlogin", LongDate + " - " + ShortTime); sqlcommand.Parameters.AddWithValue("@sitstat", "1"); sqlcommand.ExecuteNonQuery(); //SET REGISTRY SETTINGS string wildcardquery = "SELECT [USER ID] FROM [Tbl.Users] WHERE USERNAME = '******'"; sqlcommand = new SqlCommand(wildcardquery, sqlconnection); SqlDataReader sqldatareader = sqlcommand.ExecuteReader(); while (sqldatareader.Read()) { Useridvirtualdata = sqldatareader.GetString(0); } sqldatareader.Close(); //SET REGISTRY SETTINGS string newwildcardquery = "SELECT [STUDENT ID] FROM [Tbl.Students] WHERE [USER ID] = '" + Useridvirtualdata + "'"; sqlcommand = new SqlCommand(newwildcardquery, sqlconnection); SqlDataReader sqldatareader2 = sqlcommand.ExecuteReader(); while (sqldatareader2.Read()) { StudentidVirtualdata = sqldatareader2.GetString(0); } sqldatareader2.Close(); RegistryKey newregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname); newregistrykey.SetValue("User ID", Useridvirtualdata); newregistrykey.SetValue("Student ID", StudentidVirtualdata); IsVerified = true; IsStudent = true; sqlconnection.Close(); } } //ACCOUNT NOT FOUND else if (datatable.Rows[0][0].ToString() == "0") { IsVerified = false; sqlconnection.Close(); Controls.LoginErrorMessage.Text = "SORRY, THAT DIDN'T WORK !"; Controls.LoginErrorMessage.Location = new Point(126, 134); Controls.LoginErrorMessage.Visible = true; } } catch (Exception exception) { opacityform = new OpacityForm(); opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Authentication Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } } }
private void TestConnectionButton_Click(object sender, EventArgs e) { opacityform = new OpacityForm(); darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); //EXCEPTION 1 try { //SHOW VISUAL REPRESENTATION FOR EMPTY TEXTBOXES Show_Hide_Visual_Representation_Labels(); if (ServerNameTextbox.Text.Length == 0 || DatabaseNameTextbox.Text.Length == 0 || SqlServerUsernameTextbox.Text.Length == 0 || SqlServerPasswordTextbox.Text.Length == 0) { notificationwindow.CaptionText = "CONNECTION REFUSED"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (ServerNameTextbox.Text.EndsWith(" ") || DatabaseNameTextbox.Text.EndsWith(" ") || SqlServerUsernameTextbox.Text.EndsWith(" ") || SqlServerPasswordTextbox.Text.EndsWith(" ")) { notificationwindow.CaptionText = "CONNECTION REFUSED"; notificationwindow.MsgImage.Image = Properties.Resources.error; notificationwindow.MessageText = "LOGIN FAILED !\nPLEASE REVIEW YOUR INFORMATION."; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (ServerNameTextbox.Text.Length != 0 && DatabaseNameTextbox.Text.Length != 0 && SqlServerUsernameTextbox.Text.Length != 0 && SqlServerPasswordTextbox.Text.Length != 0) { //INNER EXCEPTION 1 try { variables = new Variables(); sqlconfig = new SQLConnectionConfig(); tempconnectionstring = "Data Source=" + ServerNameTextbox.Text + ";" + "Initial Catalog=" + DatabaseNameTextbox.Text + ";" + "Persist Security Info=True;" + "User ID=" + SqlServerUsernameTextbox.Text + ";" + "Password="******""; sqlconfig.SqlConnectionString = tempconnectionstring; sqlconnection = new SqlConnection(sqlconfig.SqlConnectionString); do { Cursor = Cursors.AppStarting; sqlconnection.Open(); if (sqlconnection.State == ConnectionState.Open) { notificationwindow.CaptionText = "CONNECTION TESTING"; notificationwindow.MsgImage.Image = Properties.Resources.check; notificationwindow.MessageText = "TEST CONNECTION SUCCEEDED !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); Cursor = Cursors.Default; break; } }while (sqlconnection.State == ConnectionState.Closed); sqlconnection.Close(); } catch (Exception exception) { Cursor = Cursors.Default; opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Server Connection Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Server Connection Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }
private void ChangeButton_Click(object sender, EventArgs e) { //EXCEPTION 1 try { opacityform = new OpacityForm(); darkeropacityform = new DarkerOpacityForm(); notificationwindow = new NotificationWindow(); if (NewPasswordTextbox.Text.Trim().Length == 0 || ConfirmPasswordTextbox.Text.Trim().Length == 0) { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (!NewPasswordTextbox.Text.Trim().Equals(ConfirmPasswordTextbox.Text.Trim()) || !ConfirmPasswordTextbox.Text.Trim().Equals(NewPasswordTextbox.Text.Trim())) { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "PLEASE CONFIRM YOUR NEW PASSWORD !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else if (NewPasswordTextbox.Text.Trim().Length < 8 || ConfirmPasswordTextbox.Text.Trim().Length < 8) { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "YOUR PASSWORD IS TOO SHORT, MAKE IT\n8-CHARACTERS OR ABOVE LONG !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } else { //INNER EXCEPTION 1 try { variables = new Variables(); cryptography = new Cryptography(); sqlconnectionconfig = new SQLConnectionConfig(); RegistryKey registrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname); string tempdata = registrykey.GetValue("SQLServerConnectionString").ToString(); string currentuserid = registrykey.GetValue("User ID").ToString(); //USER SQLSERVER CONNECTION SETTINGS sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata); sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString); sqlconnection.Open(); //CHECK IF THE NEW USERNAME IS ALREADY TAKEN BY ANOTHER USER sqlquery1 = "SELECT COUNT(PASSWORD) FROM [Tbl.Users] WHERE [USER ID] = '" + currentuserid + "' AND PASSWORD = '******'"; DataTable datatable = new DataTable(); sqldataadapter = new SqlDataAdapter(sqlquery1, sqlconnection); sqldataadapter.Fill(datatable); //OPPS, PASSWORD IS THE SAME WITH THE OLD ONE ! if (datatable.Rows[0][0].ToString() == "1") { notificationwindow.CaptionText = "MESSAGE CONTENT"; notificationwindow.MsgImage.Image = Properties.Resources.warning; notificationwindow.MessageText = "YOUR NEW PASSWORD AND OLD ARE\nJUST THE SAME !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); } //F**K YAH,! IT'S NOT THE SAME ! else if (datatable.Rows[0][0].ToString() == "0") { //ERROR EXIST HERE. sqlquery2 = "UPDATE [Tbl.Users] SET PASSWORD = @password, [IS PWD CHANGED] = @ispwdchanged WHERE [USER ID] = '" + currentuserid + "'"; sqlcommand = new SqlCommand(sqlquery2, sqlconnection); sqlcommand.Parameters.AddWithValue("@password", cryptography.Encrypt(ConfirmPasswordTextbox.Text.Trim())); sqlcommand.Parameters.AddWithValue("@ispwdchanged", "True"); sqlcommand.ExecuteNonQuery(); notificationwindow.CaptionText = "SUCCESS !"; notificationwindow.MsgImage.Image = Properties.Resources.check; notificationwindow.MessageText = "SUCCESSFULLY UPDATED !"; darkeropacityform.Show(); notificationwindow.ShowDialog(); darkeropacityform.Hide(); sqlconnection.Close(); isClosed = true; DialogResult = DialogResult.OK; } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Change Password Required Form Inner Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } } } catch (Exception exception) { opacityform.Show(); MessageBox.Show(exception.Message.ToString(), "@Change Password Required Form Exception 1", MessageBoxButtons.OK, MessageBoxIcon.Error); opacityform.Hide(); } }