protected void Button1_Click(object sender, EventArgs e)
{
msg.Visible = true;
//try{
UserLogin ul = new UserLogin();
DataTable dt = ul.CheckUsers(username.Text, password.Text, role.Text);
if (dt.Rows.Count > 0)
{
foreach (DataRow rows in dt.Rows)
{
Session["username"] = username.Text;
Session["password"] = password.Text;
Session["role"] = role.Text;
if (role.SelectedItem.Value == "franchiser")
{
Response.Redirect("franchiser.aspx");
Session["id"] = db.dt.Rows[0];
Session["status"] = db.dt.Rows[12];
}
else if (role.SelectedItem.Value == "investor")
{
Response.Redirect("index.aspx");
}
}
}
else
{
msg.Text = "invalid username or password";
msg.ForeColor = Color.Red;
}
}