using System;
using MySql.Data.MySqlClient;

namespace kadai03
{
    public partial class _Default : System.Web.UI.Page
    {
        private bool Login(string userID, string password)
        {
            string connectInfo = string.Format("server={0};user id={1};password={2};database={3};",
                "localhost", "root", "", "wp22");
            using (var connection = new MySqlConnection(connectInfo))
            {
                connection.Open();
                var command = new MySqlCommand("Select Count(*) From user Where id = ?ID And pass = ?PASS;", connection);
                command.Parameters.AddWithValue("?ID", userID);
                command.Parameters.AddWithValue("?PASS", password);
                if (Convert.ToInt32(command.ExecuteScalar()) != 0) return true;
            }
            return false;
        }

        protected void Page_Load(object sender, EventArgs e) { }

        protected void ButtonLogin_Click(object sender, EventArgs e)
        {
            bool isCorrectUser = Login(TextBoxID.Text, TextBoxPassword.Text);
            if (isCorrectUser) LabelResult.Text = "ログインに成功しました。";
            else LabelResult.Text = "ログインに失敗しました。";
        }
    }
}