Exemplo n.º 1
0
        public ChildWindow_Status(int usedid)
        {
            InitializeComponent();
            this.usedid = usedid;
            DB_Resolver informationpreload = new DB_Resolver();

            informationpreload.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);
        }
Exemplo n.º 2
0
        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);
                }
            }
        }