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");
}
}
