public int checklogin(ParentPrjs ck)
{
SqlCommand cmd = new SqlCommand("select * from tbl_Parent where ParentName=@username and Password=@password", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@username", ck.parentname);
cmd.Parameters.AddWithValue("@password", ck.password);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
ParentPrjs prt = null;
int count = 0;
if (sdr.Read())
{
prt = new ParentPrjs
{
parentname = sdr[0].ToString(),
password = sdr[1].ToString(),
};
count++;
}
con.Close();
return(count);
}
public void AddUserName(ParentPrjs pdetails)
{
SqlCommand cmd = new SqlCommand("insert into tbl_Parent values(@parentname,@pwd)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@parentname", pdetails.parentname);
cmd.Parameters.AddWithValue("@pwd", pdetails.password);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid == true)
{
Adoconnected dal = new Adoconnected();
ParentPrjs pdetalis = new ParentPrjs()
{
parentname = txtUsername.Text,
password = txtPwd.Text
};
dal.AddUserName(pdetalis);
}
lblMsg.Text = "Registered Successfully";
}
protected void Button1_Click(object sender, EventArgs e)
{
ParentPrjs prt = new ParentPrjs
{
parentname = txtName.Text,
password = txtPwd.Text
};
Adoconnected dal = new Adoconnected();
int count = dal.checklogin(prt);
if (count > 0)
{
Response.Redirect("FourthPage.aspx");
}
else
{
labelMsg.Text = "Invalid Username/Password";
}
}
