private void MW_F_Register(object sender, RoutedEventArgs e) { DB_Resolver dbinterface = new DB_Resolver(); dbinterface.DB_ConnectionOpener(); if (dbinterface.DB_ConnectionChecker()) { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Rejestracja")); if (existingWindow == null) { Window ChildWindow_Register = new ChildWindow_Register(); ChildWindow_Register.WindowStartupLocation = WindowStartupLocation.CenterScreen; ChildWindow_Register.Owner = this; ChildWindow_Register.Show(); } else { existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } } else { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Rejestracja")); if (existingWindow != null) { existingWindow.Close(); } MessageBox.Show("Błąd połączenia z bazą danych systemu. Napewno posiadasz połączenie z internetem?", "SRUW - Błąd Połączenia", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void CW_Status_F_Delete_User(object sender, RoutedEventArgs e) { MessageBoxResult Result = MessageBox.Show("Czy napewno chcesz usunąć wszystkie dane z systemu?", "SRUW - Usuwanie Użytkownika", MessageBoxButton.YesNo, MessageBoxImage.Information); if (Result == MessageBoxResult.Yes) { DB_Resolver connection = new DB_Resolver(); connection.DB_ConnectionOpener(); if (connection.DB_ConnectionChecker()) { connection.DB_Resolver_Status_User_Deletion(usedid); Close(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("System Rekrutacji Uczelni Wyższych")); existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } else { MessageBox.Show("Błąd połączenia z bazą danych systemu. Napewno posiadasz połączenie z internetem?", "SRUW - Błąd Połączenia", MessageBoxButton.OK, MessageBoxImage.Warning); } } else if (Result == MessageBoxResult.No) { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Status")); existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } }
private void CW_Login_F_Login_Attempt(object sender, RoutedEventArgs e) { String usedlogin = CW_Login_Pesel_Field.Text; String usedauthcode = CW_Login_AuthCode_Field.Password; String loginstatus = ""; String logintype = ""; int loginid = 0; DB_Resolver connection = new DB_Resolver(); connection.DB_ConnectionOpener(); if (connection.DB_ConnectionChecker()) { connection.DB_Resolver_Login_Queue(usedlogin, usedauthcode, out loginstatus, out logintype, out loginid); if (loginstatus == "OUT") { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Logowanie")); existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } else { if (logintype == "STANDARD") { Hide(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Status")); if (existingWindow == null) { Window ChildWindow_Status = new ChildWindow_Status(loginid); ChildWindow_Status.WindowStartupLocation = WindowStartupLocation.CenterScreen; ChildWindow_Status.Owner = this; ChildWindow_Status.Show(); } else { existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } } else { Hide(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Panel Administratora")); if (existingWindow == null) { Window ChildWindow_AdmCtr = new ChildWindow_AdmCtr(loginid); ChildWindow_AdmCtr.WindowStartupLocation = WindowStartupLocation.CenterScreen; ChildWindow_AdmCtr.Owner = this; ChildWindow_AdmCtr.Show(); } else { existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } } } } else { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Logowanie")); if (existingWindow != null) { existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } MessageBox.Show("Błąd połączenia z bazą danych systemu. Napewno posiadasz połączenie z internetem?", "SRUW - Błąd Połączenia", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void CW_Status_F_Modify_User_Locker(object sender, RoutedEventArgs e) { int peselcorrector = 0; int namecorrector = 0; int emailcorrector = 0; int address1corrector = 0; int address2corrector = 0; int polishcorrector = 0; int mathscorrector = 0; int englishcorrector = 0; int pol1addcorrector = 0; int mat2addcorrector = 0; int eng3addcorrector = 0; if (CW_Status_Pesel_Field.Text == "") { CW_Status_Pesel_Field.Text = ""; peselcorrector = 0; } else { try { String peselinput = CW_Status_Pesel_Field.Text; int length = peselinput.Length; if (length == 11) { double isanumber = Convert.ToDouble(peselinput); peselcorrector = 1; } else { CW_Status_Pesel_Field.Text = ""; peselcorrector = 0; } } catch (Exception exception) { CW_Status_Pesel_Field.Text = ""; peselcorrector = 0; }; } //napraw if (CW_Status_Name_Field.Text == "") { CW_Status_Name_Field.Text = ""; namecorrector = 0; } else { String nameinput = CW_Status_Name_Field.Text; int foundq = nameinput.IndexOf(" "); if (foundq == -1) { CW_Status_Name_Field.Text = ""; namecorrector = 0; } else { namecorrector = 1; } } if (CW_Status_Email_Field.Text == "") { CW_Status_Email_Field.Text = ""; emailcorrector = 0; } else { String emailinput = CW_Status_Email_Field.Text; int foundq = emailinput.IndexOf("@"); if (foundq == -1) { CW_Status_Email_Field.Text = ""; emailcorrector = 0; } else { emailcorrector = 1; } } if (CW_Status_Address1_Field.Text == "") { CW_Status_Address1_Field.Text = ""; address1corrector = 0; } else { address1corrector = 1; } if (CW_Status_Address2_Field.Text == "") { CW_Status_Address2_Field.Text = ""; address2corrector = 0; } else { address2corrector = 1; } String input = CW_Status_Polish_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_Polish_Field.Text = ""; polishcorrector = 0; } else if (inputvalue < 0) { CW_Status_Polish_Field.Text = ""; polishcorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_Polish_Field.Text = "0"; polishcorrector = 1; } else { polishcorrector = 1; } } catch (Exception exception) { CW_Status_Polish_Field.Text = ""; polishcorrector = 0; }; input = CW_Status_Maths_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_Maths_Field.Text = ""; mathscorrector = 0; } else if (inputvalue < 0) { CW_Status_Maths_Field.Text = ""; mathscorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_Maths_Field.Text = "0"; mathscorrector = 1; } else { mathscorrector = 1; } } catch (Exception exception) { CW_Status_Maths_Field.Text = ""; mathscorrector = 0; }; input = CW_Status_English_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_English_Field.Text = ""; englishcorrector = 0; } else if (inputvalue < 0) { CW_Status_English_Field.Text = ""; englishcorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_English_Field.Text = "0"; englishcorrector = 1; } else { englishcorrector = 1; } } catch (Exception exception) { CW_Status_English_Field.Text = ""; englishcorrector = 0; }; input = CW_Status_Pol1Add_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_Pol1Add_Field.Text = ""; pol1addcorrector = 0; } else if (inputvalue < 0) { CW_Status_Pol1Add_Field.Text = ""; pol1addcorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_Pol1Add_Field.Text = "0"; pol1addcorrector = 1; } else { pol1addcorrector = 1; } } catch (Exception exception) { CW_Status_Pol1Add_Field.Text = ""; pol1addcorrector = 0; }; input = CW_Status_Mat2Add_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_Mat2Add_Field.Text = ""; mat2addcorrector = 0; } else if (inputvalue < 0) { CW_Status_Mat2Add_Field.Text = ""; mat2addcorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_Mat2Add_Field.Text = "0"; mat2addcorrector = 1; } else { mat2addcorrector = 1; } } catch (Exception exception) { CW_Status_Mat2Add_Field.Text = ""; mat2addcorrector = 0; }; input = CW_Status_Eng3Add_Field.Text; try { int inputvalue = Convert.ToInt32(input); if (inputvalue > 100) { CW_Status_Eng3Add_Field.Text = ""; eng3addcorrector = 0; } else if (inputvalue < 0) { CW_Status_Eng3Add_Field.Text = ""; eng3addcorrector = 0; } else if (inputvalue == 000 || inputvalue == 00) { CW_Status_Eng3Add_Field.Text = "0"; eng3addcorrector = 1; } else { eng3addcorrector = 1; } } catch (Exception exception) { CW_Status_Eng3Add_Field.Text = ""; eng3addcorrector = 0; }; if (peselcorrector == 0 || namecorrector == 0 || emailcorrector == 0 || address1corrector == 0 || address2corrector == 0 || polishcorrector == 0 || mathscorrector == 0 || englishcorrector == 0 || address1corrector == 0 || pol1addcorrector == 0 || mat2addcorrector == 0 || eng3addcorrector == 0) { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Status")); existingWindow.Activate(); MessageBox.Show("Niektóre pola nie przeszły testów walidacyjnych i zostały wyczyszczone przez system bądź zostały pozostawione puste. Wypełnij je poprawnie.", "SRUW - Modyfikacja Profilu", MessageBoxButton.OK, MessageBoxImage.Information); } else { DB_Resolver updaterconnection = new DB_Resolver(); updaterconnection.DB_ConnectionOpener(); if (updaterconnection.DB_ConnectionChecker()) { CW_Status_Pesel_Field.IsReadOnly = true; CW_Status_Pesel_Field.BorderBrush = Brushes.Gray; CW_Status_Name_Field.IsReadOnly = true; CW_Status_Name_Field.BorderBrush = Brushes.Gray; CW_Status_Email_Field.IsReadOnly = true; CW_Status_Email_Field.BorderBrush = Brushes.Gray; CW_Status_Address1_Field.IsReadOnly = true; CW_Status_Address1_Field.BorderBrush = Brushes.Gray; CW_Status_Address2_Field.IsReadOnly = true; CW_Status_Address2_Field.BorderBrush = Brushes.Gray; CW_Status_Polish_Field.IsReadOnly = true; CW_Status_Polish_Field.BorderBrush = Brushes.Gray; CW_Status_Maths_Field.IsReadOnly = true; CW_Status_Maths_Field.BorderBrush = Brushes.Gray; CW_Status_English_Field.IsReadOnly = true; CW_Status_English_Field.BorderBrush = Brushes.Gray; CW_Status_Pol1Add_Field.IsReadOnly = true; CW_Status_Pol1Add_Field.BorderBrush = Brushes.Gray; CW_Status_Mat2Add_Field.IsReadOnly = true; CW_Status_Mat2Add_Field.BorderBrush = Brushes.Gray; CW_Status_Eng3Add_Field.IsReadOnly = true; CW_Status_Eng3Add_Field.BorderBrush = Brushes.Gray; CW_Status_Modify_Lock.Visibility = Visibility.Hidden; CW_Status_Modify_UnLock.Visibility = Visibility.Visible; updaterconnection.DB_Resolver_Status_Modify_Updater(CW_Status_Pesel_Field, CW_Status_Name_Field, CW_Status_Email_Field, CW_Status_Address1_Field, CW_Status_Address2_Field, CW_Status_Polish_Field, CW_Status_Maths_Field, CW_Status_English_Field, CW_Status_Pol1Add_Field, CW_Status_Mat2Add_Field, CW_Status_Eng3Add_Field, usedid); updaterconnection.DB_Resolver_Status_Queue(CW_Status_Pesel_Field, CW_Status_Name_Field, CW_Status_Email_Field, CW_Status_Address1_Field, CW_Status_Address2_Field, CW_Status_Polish_Field, CW_Status_Maths_Field, CW_Status_English_Field, CW_Status_Pol1Add_Field, CW_Status_Mat2Add_Field, CW_Status_Eng3Add_Field, CW_Status_Route_Field, CW_Status_Status_Field, CW_Status_Points_Field, usedid); } else { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Status")); if (existingWindow != null) { existingWindow.WindowState = WindowState.Normal; existingWindow.Activate(); } MessageBox.Show("Błąd połączenia z bazą danych systemu. Napewno posiadasz połączenie z internetem?", "SRUW - Błąd Połączenia", MessageBoxButton.OK, MessageBoxImage.Warning); } } }
private void CW_Register_F_RegisterInitializer(object sender, RoutedEventArgs e) { bool registerformstatus = CW_Register_FieldsChecker(); if (registerformstatus == true) { DB_Resolver connection = new DB_Resolver(); connection.DB_ConnectionOpener(); if (connection.DB_ConnectionChecker() == true) { MessageBoxResult Result = MessageBox.Show("Wszystko wygląda poprawnie. Kontynuować?", "SRUW - Akceptacja", MessageBoxButton.YesNo, MessageBoxImage.Information); if (Result == MessageBoxResult.Yes) { connection.DB_ConnectionInsert(CW_Register_polish_Field, CW_Register_maths_Field, CW_Register_english_Field, CW_Register_add1pol_Field, CW_Register_add2mat_Field, CW_Register_add3eng_Field, CW_Register_Name_Field, CW_Register_Pesel_Field, CW_Register_Email_Field, CW_Register_Address1_Field, CW_Register_Address2_Field, CW_Register_University_ComboBox, CW_Register_University_Available_ComboBox); MessageBoxResult Result2 = MessageBox.Show("Użytkownik został dodany do systemu." + System.Environment.NewLine + "Twoje dane do logowania to : " + System.Environment.NewLine + "Login : "******"Hasło : " + connection.generatedpassword + System.Environment.NewLine + "Skopiować dane do schowka systemowego?", "SRUW - Pomyślnie zarejestrowano", MessageBoxButton.YesNo, MessageBoxImage.Information); if (Result2 == MessageBoxResult.Yes) { String SRUWCLIPB1 = "==============================================" + System.Environment.NewLine; String SRUWCLIPB2 = "SRUW - WYGENEROWANE POŚWIADCZENIA" + System.Environment.NewLine; String SRUWCLIPB3 = "==============================================" + System.Environment.NewLine; String SRUWCLIPB4 = "LOGIN : "******"HASŁO : " + connection.generatedpassword + System.Environment.NewLine; String SRUWCLIPB6 = "==============================================" + System.Environment.NewLine; Clipboard.SetText(SRUWCLIPB1 + SRUWCLIPB2 + SRUWCLIPB3 + SRUWCLIPB4 + SRUWCLIPB5 + SRUWCLIPB6); MessageBox.Show("Pomyślnie skopiowano poświadczenia do schowka systemowego. Rejestracja Pomyślna.", "SRUW - Operacja pomyślna.", MessageBoxButton.OK, MessageBoxImage.Information); Close(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("System Rekrutacji Uczelni Wyższych")); existingWindow.Activate(); } else if (Result2 == MessageBoxResult.No) { MessageBox.Show("Rejestracja Pomyślna. Powracanie do okna głównego.", "SRUW - Operacja pomyślna.", MessageBoxButton.OK, MessageBoxImage.Information); Close(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("System Rekrutacji Uczelni Wyższych")); existingWindow.Activate(); } else { MessageBox.Show("Rejestracja Pomyślna. Powracanie do okna głównego.", "SRUW - Operacja pomyślna.", MessageBoxButton.OK, MessageBoxImage.Information); Close(); var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("System Rekrutacji Uczelni Wyższych")); existingWindow.Activate(); } } else if (Result == MessageBoxResult.No) { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Rejestracja")); existingWindow.Activate(); } } else { MessageBox.Show("Błąd połączenia z bazą danych systemu. Napewno posiadasz połączenie z internetem?", "SRUW - Błąd Połączenia", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { var existingWindow = Application.Current.Windows.Cast <Window>().SingleOrDefault(x => x.Title.Equals("SRUW - Rejestracja")); existingWindow.Activate(); MessageBox.Show("Nie wszystkie pola są zapełnione lub poprawnie wypełnione.", "SRUW - Błąd Rejestracji", MessageBoxButton.OK, MessageBoxImage.Information); } }