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 AddButton_Click(object sender, RoutedEventArgs e)
{
if(StudentListBox.SelectedItem == null)
{
var sID = int.TryParse(StudentIDTB.Text, out int studentID);
if (sID == false)
{
MessageBox.Show("Invalid Entry. Please enter a valid number");
}
var sFirstName = FirstNameTB.Text;
var sLastName = LastNameTB.Text;
var age = int.TryParse(AgeTB.Text, out int sAge);
var allergies = AllergiesTB.Text;
var parentName = ParentNameTB.Text;
var parentContact = ParentContactNoTB.Text;
var parentEmail = ParentEmailTB.Text;
var classID = int.TryParse(ClassIDTB.Text, out int sClassID);
_crudManager.AddStudent(studentID, sFirstName, sLastName, sAge, allergies, parentName, parentContact, parentEmail, sClassID);
}
PopulateStudentListBox();
StudentIDTB.Clear();
FirstNameTB.Clear();
LastNameTB.Clear();
AgeTB.Clear();
AllergiesTB.Clear();
ParentNameTB.Clear();
ParentContactNoTB.Clear();
ParentEmailTB.Clear();
ClassIDTB.Clear();
}
public SignUpPage()
{
InitializeComponent();
LastNameTB.Focus();
Keyboard.Focus(LastNameTB);
DataContext = new SignUpViewModel(this);
}
public Customer_Login()
{
InitializeComponent();
//Initial hidden objects
label4.Hide();
label5.Hide();
FirstNameTB.Hide();
LastNameTB.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
newUser = true;
button1.Enabled = false;
label2.Text = "New Username:"******"New Password:";
label4.Show();
label5.Show();
FirstNameTB.Show();
LastNameTB.Show();
}
private void ResetBt_Click(object sender, RoutedEventArgs e)
{
StudentIDTB.Clear();
FirstNameTB.Clear();
LastNameTB.Clear();
AgeTB.Clear();
AllergiesTB.Clear();
ParentNameTB.Clear();
ParentContactNoTB.Clear();
ParentEmailTB.Clear();
ClassIDTB.Clear();
}
private void DeleteBt_Click(object sender, RoutedEventArgs e)
{
_crudManager.DeleteStudent(int.Parse(StudentIDTB.Text));
StudentIDTB.Clear();
FirstNameTB.Clear();
LastNameTB.Clear();
AgeTB.Clear();
AllergiesTB.Clear();
ParentNameTB.Clear();
ParentContactNoTB.Clear();
ParentEmailTB.Clear();
ClassIDTB.Clear();
StudentListBox.ItemsSource = null;
PopulateStudentListBox();
}
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 LastNameTBGotFocus(object sender, RoutedEventArgs e)
{
LastNameTB.Clear();
}
