using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Milestone_4
{
    public partial class login_parent : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Log_In_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Server=(localdb)\\MSSQLLocalDB; database= E");
            SqlCommand cmd = new SqlCommand("Select * from Parents where username= @username AND Password = @password", con);
            cmd.Parameters.AddWithValue("@username", TextBox1.Text);
            cmd.Parameters.AddWithValue("@password", TextBox2.Text);
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            bool words = false;
            while (dr.Read())
            {
                if (dr.HasRows == true)
                {
                    Response.Write("<script>alert('login successful');</script>");
                    words = true;
                    break;
                }
            }
            if(!words) Response.Write("<script>alert('wrong username/password');</script>");
        }

        protected void Back_Click(object sender, EventArgs e)
        {
            Response.Redirect("home.aspx");
        }

    }
}