private void buttonOK_Click(object sender, EventArgs e)
{
try
{
SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);
SqlCommand query = new SqlCommand("SELECT Логін, Пароль FROM [Акаунт клієнта] WHERE Логін = @data_0 AND Пароль = @data_1", sqlConnection);
SqlParameter uName = new SqlParameter("@data_0", SqlDbType.NVarChar);
SqlParameter uPassword = new SqlParameter("@data_1", SqlDbType.VarChar);
uName.Value = textBox7.Text;
uPassword.Value = textBox1.Text;
query.Parameters.Add(uName);
query.Parameters.Add(uPassword);
query.Connection.Open();
SqlDataReader myReader = query.ExecuteReader(CommandBehavior.CloseConnection);
if (myReader.Read() == true)
{
MessageBox.Show("Ви успішно увійшли до акаунту " + textBox7.Text);
this.Hide();
clientPage = new ClientPage(textBox7.Text);
clientPage.Show();
}
else
{
MessageBox.Show("Щось трапилось, перевірте дані", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox7.Clear();
textBox1.Clear();
textBox7.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public GroupFilter(ClientPage clientPage)
{
InitializeComponent();
this.clientPage = clientPage;
}
public SeasonTicketFilter(ClientPage clientPage)
{
InitializeComponent();
this.clientPage = clientPage;
}
public CoachScheduleFilter(ClientPage clientPage)
{
InitializeComponent();
this.clientPage = clientPage;
}
