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;
}
}
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();
}
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();
}