Esempio n. 1
0
        private void LChange_Click(object sender, RoutedEventArgs e)
        {
            switch (_a)
            {
            case 1:
                EX_QUERY($"UPDATE USERS SET Login = '******' WHERE ID = {Int32.Parse(identity)}");

                UC.List_Credentials    = EX_QUERY($"SELECT LOGIN FROM USERS WHERE ID = {Int32.Parse(identity)}");
                UC.LoginChange.Content = UC.List_Credentials[0];
                PopUp.Close();
                break;

            case 3:
                EX_QUERY($"UPDATE USERS SET E_MAIL = '{Box.Text}' WHERE ID = {Int32.Parse(identity)}");

                UC.List_Credentials    = EX_QUERY($"SELECT E_MAIL FROM USERS WHERE ID = {Int32.Parse(identity)}");
                UC.EmailChange.Content = UC.List_Credentials[0];
                PopUp.Close();
                break;

            case 4:
                EX_QUERY($"UPDATE USERS SET CITY = '{Box.Text}' WHERE ID = {Int32.Parse(identity)}");

                UC.List_Credentials   = EX_QUERY($"SELECT CITY FROM USERS WHERE ID = {Int32.Parse(identity)}");
                UC.CityChange.Content = UC.List_Credentials[0];
                PopUp.Close();
                break;

            default:
                MessageBox.Show("Błąd");
                break;
            }
        }
Esempio n. 2
0
        private void LChange_Click(object sender, RoutedEventArgs e)
        {
            EX_QUERY($"UPDATE USERS SET DOB_YEAR = '{comboYear.Text}', DOB_MONTH = '{comboMonth.Text}', DOB_DAY = '{comboDay.Text}' WHERE ID = {Int32.Parse(identity)}");

            UCDOB.List_Credentials  = EX_QUERY($"SELECT DOB_YEAR, DOB_MONTH, DOB_DAY FROM USERS WHERE ID = {Int32.Parse(identity)}");
            UCDOB.DOBChange.Content = UCDOB.List_Credentials[2] + "." + UCDOB.List_Credentials[1] + "." + UCDOB.List_Credentials[0];
            PopUp.Close();
        }
Esempio n. 3
0
        private void LChange_Click(object sender, RoutedEventArgs e)
        {
            EX_QUERY($"UPDATE USERS SET FIRST_NAME = '{FN_Box.Text}', LAST_NAME = '{LN_Box.Text}' WHERE ID = {Int32.Parse(identity)}");

            UCName.List_Credentials     = EX_QUERY($"SELECT FIRST_NAME, LAST_NAME FROM USERS WHERE ID = {Int32.Parse(identity)}");
            UCName.FN_man.Content       = UCName.List_Credentials[0];
            UCName.LN_man.Content       = UCName.List_Credentials[1];
            launch.username_lbl.Content = UCName.List_Credentials[0];
            PopUp.Close();
        }