private void Filldata() { string sql; DataTable dr; sql = "Select * From tbl_Member Where MemberId='" + Session["MemberId"].ToString() + "'"; dr = c1.SelectDT(sql); if (dr.Rows.Count > 0) { img_Member.Src = dr.Rows[0]["PhotoUrl"].ToString(); txt_ContactNo.Text = dr.Rows[0]["ContactNo"].ToString(); txt_Email.Text = dr.Rows[0]["EmailId"].ToString(); txt_Name.Text = dr.Rows[0]["MemberName"].ToString(); } c1.SetLoginDetails(txt_Email.Text); }
protected void btn_Submit_Login_Click(object sender, EventArgs e) { string sql = "", cnt, path; sql = " SELECT Count(*) FROM tbl_Member WHERE EmailId='" + c1.Clean(txt_EmailId_Login.Text) + "'"; sql = sql + " AND Password='******'"; sql = sql + " AND EnableStatus=1"; cnt = c1.SelectScalar(sql); if (Convert.ToInt32(cnt) == 1) { c1.SetLoginDetails(txt_EmailId_Login.Text); if (Session["RefUrl"] != null) { path = Session["RefUrl"].ToString(); if (Session["RefUrl"].ToString() == "TakeExam") { Session.Remove("RefUrl"); Response.Redirect("Test_Insturction.aspx"); //ScriptManager.RegisterStartupScript(this, typeof(string), "New_Window", "window.open( 'TakeExamI.aspx', null, 'resizable=no,height=800,width=1280,status=no,toolbar=no,menubar=no,location=no' );", true); } else { Session.Remove("RefUrl"); Response.Redirect(path); } } else { Response.Redirect("Default.aspx"); } //lbl_Msg.Text = "Success"; } else { lbl_Msg_Login.Text = "Either Email Id / Password is Wrong or Not Activated."; } }