private void Button_Click(object sender, RoutedEventArgs e)
{
//добавление данных о пользователе в БД, если все данные введены верно
if (PasswordTB.Password == RepPasswordTB.Password)
{
DB dB = new DB(Properties.Settings.Default.CinemaDBConnectionString);
object login = dB.ExecuteScalarQuery($"SELECT Логин FROM Пользователь WHERE Логин = '{LoginTB.Text}'");
if (login == null)
{
int rows = dB.ExecuteQuery($"INSERT INTO [Пользователь] Values(N'{LoginTB.Text}', N'{PasswordTB.Password}', N'{EmailTB.Text}', N'{PhoneTB.Text}', 0, 0, N'{LastNameTB.Text}', N'{FirstNameTB.Text}', N'{MiddleNameTB.Text}')");
if (rows == 1)
{
MessageBox.Show("Регистрация прошла успешно!");
LastNameTB.Clear();
FirstNameTB.Clear();
MiddleNameTB.Clear();
EmailTB.Clear();
PhoneTB.Clear();
LoginTB.Clear();
PasswordTB.Clear();
RepPasswordTB.Clear();
AddText();
}
}
else
{
MessageBox.Show("Такой логин уже существует!");
}
}
else
{
MessageBox.Show("Пароли не совпадают!");
}
}
private void Login()
{
if (LoginTB.Text.Length >= 5)
{
string email = LoginTB.Text;
string password = PasswordTB.Password;
//httpPost validation
if (SessionHelper.SetActiveUserSession(new ApplicationUser {
UserName = email, Password = password
}))
{
ConnectToRoom connectToRoomForm = new ConnectToRoom();
connectToRoomForm.Show();
this.Close();
}
else
{
MessageBox.Show("Invalid login or password", "Sync Player");
}
}
else
{
LoginTB.Focus();
}
}
private async void SignInBTN_Click(object sender, EventArgs e)
{
if ((LoginTB.Text == "") || (PasswordTB.Text == ""))
{
MessageBox.Show("Все поля должны быть заполнены!", "Ошибка.");
return;
}
TeacherLogin = LoginTB.Text;
TeacherPassword = PasswordTB.Text;
string answer = null;
label5.Text = "Идет процесс авторизации. Пожалуйста, ожидайте...";
try
{
answer = await Server.GetResponseAsync("http://*****:*****@"Неверно указан логин и\или пароль.", "Ошибка.");
return;
}
LoginTB.Clear();
PasswordTB.Clear();
label1.Visible = false;
label2.Visible = false;
LoginTB.Visible = false;
PasswordTB.Visible = false;
SignInBTN.Visible = false;
DepartmentChB.Visible = true;
DepartmentChB.Enabled = false;
GroupChB.Visible = true;
GroupChB.Enabled = false;
AllDepChB.Visible = true;
AllDepChB.Enabled = false;
SendFacultyRB.Visible = true;
SendDepartmentRB.Visible = true;
SendGroupRB.Visible = true;
label3.Visible = true;
MessageRTB.Visible = true;
MessageRTB.Enabled = false;
SendBTN.Visible = true;
DepartmentCB.Visible = true;
DepartmentCB.Enabled = false;
ThemeTB.Visible = true;
ThemeTB.Enabled = false;
label4.Visible = true;
}
private void ClearFields()
{
LoginTB.Clear();
PasswordTB.Clear();
CPasswordTB.Clear();
SurnameTB.Clear();
NameTB.Clear();
PatronymicTB.Clear();
FacultyCB.Text = "";
DepartmentCB.Text = "";
DepartmentCB.Enabled = false;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (FirstNameTB.Text != "" || EmailTB.Text != "" || PhoneTB.Text != "" ||
LoginTB.Text != "" || PasswordTB.Password != "" || RepPasswordTB.Password != "")
{
if (PasswordTB.Password == RepPasswordTB.Password)
{
using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\OlineCinema\OlineCinema\CinemaDB.mdf;Integrated Security=True"))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Ошибка соединения с базой данных!");
return;
}
string query = $"INSERT INTO [Пользователь] Values('{LoginTB.Text}', '{PasswordTB.Password}', '{EmailTB.Text}', '{PhoneTB.Text}', 0, 0, '{LastNameTB.Text}', '{FirstNameTB.Text}', '{MiddleNameTB.Text}')";
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
MessageBox.Show("Регистрация прошла успешно!");
LastNameTB.Clear();
FirstNameTB.Clear();
MiddleNameTB.Clear();
EmailTB.Clear();
PhoneTB.Clear();
LoginTB.Clear();
PasswordTB.Clear();
RepPasswordTB.Clear();
}
}
else
{
MessageBox.Show("Пароли не свопадают!");
}
}
else
{
MessageBox.Show("Есть незаполненные поля!");
}
}
private void LoginButton_Click(object sender, RoutedEventArgs e)
{
int ret = SendAuthenticationGet(LoginTB.Text, PasswordTB.Password);
if (ret == 1)
{
RQSApp win = new RQSApp(LoginTB.Text);
Visibility = Visibility.Hidden;
win.ShowDialog();
Visibility = Visibility.Visible;
LoginTB.Clear();
PasswordTB.Clear();
LoginTB.Focus();
}
else if (ret == 0)
{
MessageBox.Show("Vérifiez d'avoir les bons identifiants ou inscrivez-vous !", "Mot de passe incorrect", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else
{
MessageBox.Show("Une problème est survenu !", "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public Login()
{
InitializeComponent();
LoginTB.Focus();
}
private void LoginTB_GotFocus(object sender, RoutedEventArgs e)
{
LoginTB.Clear();
}
