I'm new on ASP.NET. i am developing one jobportal website using asp.net C#. In website user after find their job post when try to click on "Apply Now" , if session empty, page will redirect to "CandidateLogin.aspx". After login the page will redirect to last visited page, and then user can apply. If user open the website and open login page, or directly enter login page URL, after login it will redirect to Candidate Profile page. Any help would be appreciated.
protected void btnLogin_Click(object sender, EventArgs e)
{
string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["jobforu"].ToString();
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.Parameters.Clear();
SqlDataReader dr;
canname = "";
canpwd = "";
canemail = "";
session_canFirstName="";
cmd.CommandText = "select * from jobforu.dbo.can_master where can_email = @can_email and can_pwd = @can_pwd";
cmd.Parameters.AddWithValue("@can_email", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@can_pwd", txtPassword.Text.Trim());
dr = cmd.ExecuteReader();
while (dr.Read())
{
canname = dr["can_fname"].ToString() +" "+ dr["can_mname"].ToString() +" "+ dr["can_lname"].ToString();
canpwd = dr["can_pwd"].ToString();
canemail = dr["can_email"].ToString();
session_canFirstName = dr["can_fname"].ToString();
sessionCanCode = dr["can_code"].ToString();
}
dr.Close();
conn.Close();
cmd.Parameters.Clear();
if (canname.Length > 1)
{
Session["canname"] = canname;
Session["canpwd"] = canpwd;
Session["canemail"] = canemail;
Session["sessionCanCode"] = sessionCanCode;
Response.Redirect(ViewState["GoBackTo"].ToString());
}
else
{
//Response.Write("Invalid user name or password");
lblErrorMsg.Visible = true;
lblErrorMsg.Text = "Invalid user name or password!";
txtEmail.Text = "";
txtPassword.Text = "";
txtEmail.Focus();
}
}
Page Load:
protected void Page_Load(object sender, EventArgs e)
{
if (Session["sessionCanCode"] != null)
{
Response.Redirect("jobseekers/Default.aspx?ref=m_icon");
}
if (!Page.IsPostBack)
{
ViewState["GoBackTo"] = Request.UrlReferrer;
FillCapctha();
}
lblErrorMsg.Visible = false;
}