public Tokenrequest getAlldatavianame(string usernamee) { Tokenrequest tkreq = null; string addresss; string queryStr = "SELECT * FROM Tokenrequest WHERE username = @username"; SqlConnection conn = new SqlConnection(_connStr); SqlCommand cmd = new SqlCommand(queryStr, conn); cmd.Parameters.AddWithValue("@username", usernamee); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { addresss = dr["address"].ToString(); tkreq = new Tokenrequest(usernamee, addresss); } else { tkreq = null; } conn.Close(); dr.Close(); dr.Dispose(); return(tkreq); }
} //end Insert public List <Tokenrequest> getAllUserName() { List <Tokenrequest> dataa = new List <Tokenrequest>(); string queryStr = "SELECT * FROM Tokenrequest"; SqlConnection conn = new SqlConnection(_connStr); SqlCommand cmd = new SqlCommand(queryStr, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); //Continue to read the resultsets row by row if not the end while (dr.Read()) { string usernamee = dr["username"].ToString(); string addresss = dr["address"].ToString(); Tokenrequest daa = new Tokenrequest(usernamee, addresss); dataa.Add(daa); } conn.Close(); dr.Close(); dr.Dispose(); return(dataa); }
protected void Page_Load(object sender, EventArgs e) { Tokenrequest rw = new Tokenrequest(); Tokenrequest qw = new Tokenrequest(); qw = rw.getAlldatavianame((string)Session["usernameLogin"]); if (qw != null) { Button1.Enabled = false; Button1.CssClass = "btn btn-default"; Button1.Text = "Request sent!"; } }
protected void Button1_OnClick(object sender, EventArgs e) { Tokenrequest rw = new Tokenrequest(); Tokenrequest qw = new Tokenrequest(); qw = rw.getAlldatavianame((string)Session["usernameLogin"]); if (qw == null) { //do mtd string username = (string)Session["usernameLogin"]; string addressss = HiddenFieldtosendaddress.Value; Tokenrequest trq = new Tokenrequest(); trq.TokenInsert(username, addressss); Response.Redirect("requestofnewToekn.aspx"); } }