private void TextBlock_MouseLeftButtonDown_1(object sender, MouseButtonEventArgs e)
        {
            LogWind main = new LogWind();

            main.Show();
            this.Close();
        }
示例#2
0
        private void back(object sender, MouseButtonEventArgs e)
        {
            LogWind logWind = new LogWind();

            logWind.Show();
            this.Close();
        }
示例#3
0
        private void registration(object sender, RoutedEventArgs e)
        {
            string pattern = @"^(?("")(""[^""]+?""@)|(([0-9a-z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-z])@))" +
                             @"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-z][-\w]*[0-9a-z]*\.)+[a-z0-9]{2,17}))$";
            SqlConnection con = new SqlConnection();

            con.ConnectionString = ConfigurationManager.ConnectionStrings["connList"].ConnectionString;
            con.Open();
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select * from Libing where Id = '" + Convert.ToInt32(Id.Text) + "'";
            cmd.Connection  = con;
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(cmd);
            DataTable      check          = new DataTable();

            sqlDataAdapter.Fill(check);
            if (check.Rows.Count == 1)
            {
                cmd.CommandText = "Select * from Students where Id = '" + Convert.ToInt32(Id.Text) + "'";
                cmd.Connection  = con;
                sqlDataAdapter  = new SqlDataAdapter(cmd);
                check           = new DataTable();
                sqlDataAdapter.Fill(check);
                if (check.Rows.Count == 0)
                {
                    cmd.CommandText = "Select * from Students where Login = '******'";
                    cmd.Connection  = con;
                    sqlDataAdapter  = new SqlDataAdapter(cmd);
                    check           = new DataTable();
                    sqlDataAdapter.Fill(check);
                    if (check.Rows.Count == 0)
                    {
                        if (Regex.IsMatch(Em.Text, pattern, RegexOptions.IgnoreCase))
                        {
                            try
                            {
                                cmd             = new SqlCommand();
                                cmd.CommandText = "Insert into Students (Login, Password, Id, Email) " +
                                                  "values ('" + Log.Text + "', '" + Convert.ToInt32(Pass.Password) + "', '" + Convert.ToInt32(Id.Text) + "', '" + Em.Text + "' )";
                                cmd.Connection = con;
                                SqlDataAdapter da = new SqlDataAdapter(cmd);
                                da.SelectCommand.ExecuteNonQuery();

                                MessageBox.Show("Учётная запись создана");
                                LogWind logWind = new LogWind();
                                logWind.Show();
                                this.Close();
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show(ex.Message);
                            }
                            finally
                            {
                                con.Close();
                            }
                        }
                        else
                        {
                            MessageBox.Show("Email введён некорректно.");
                        }
                    }
                    else
                    {
                        MessageBox.Show("Пользователь с таким логином уже сужествует.");
                    }
                }
                else
                {
                    MessageBox.Show("У Вас уже есть учётная запись.");
                }
            }
            else
            {
                MessageBox.Show("Студенческий введён некорректно.");
            }
        }