protected void Page_Load(object sender, EventArgs e)
        {
            DBconnection dbg = new DBconnection();
            string       q   = "Select * from UserInfo where UserEmail='" + SignIn.ema + "'";
            DataTable    dt  = dbg.getData(q);

            ab            = Convert.ToInt32(dt.Rows[0]["UserID"]);
            lblName.Text  = dt.Rows[0]["UserName"].ToString();
            lblPhone.Text = dt.Rows[0]["UserPhone"].ToString();;
            lblEmail.Text = dt.Rows[0]["UserEmail"].ToString();;
            lblDOB.Text   = dt.Rows[0]["UserDob"].ToString();;
            DBconnection dba  = new DBconnection();
            string       ageq = "Select DATEDIFF(YY,UserDob,GETDATE()) From UserInfo where UserEmail='" + lblEmail.Text + "'";
            DataTable    dta  = dba.getData(ageq);

            lblAge.Text = dta.Rows[0][0].ToString();
        }
예제 #2
0
        protected void btnSignIn_Click(object sender, EventArgs e)
        {
            ema = tbEmail.Text;
            DBconnection dbcd  = new DBconnection();
            string       q     = "Exec sp_FindAccount @em='" + tbEmail.Text + "', @pa='" + tbPass1.Text + "'";
            bool         avlbl = dbcd.checkData(q);

            if (avlbl == true)
            {
                Response.Write("<script>alert('Login successful!')</script>");
                Response.Redirect("GetLoan.aspx");
            }
            else
            {
                Response.Write("<script>alert('Invalid credentials provided')</script>");
            }
        }
예제 #3
0
        protected void btnShow_Click(object sender, EventArgs e)
        {
            DBconnection dbv = new DBconnection();
            string       query;

            if (ddOptions.SelectedValue == "UserAccounts")
            {
                query = "Select UserID, UserName,UserEmail,UserDob,UserPhone from UserInfo";
            }
            else
            {
                query = "Select * from Loans";
            }
            DataTable dtr = dbv.getData(query);

            dgvRecords.DataSource = dtr;
            dgvRecords.DataBind();
        }