protected void signupbtn_Click(object sender, EventArgs e)
{
System.Diagnostics.Debug.WriteLine("pressed");
SessionsTbl values = new SessionsTbl()
{
name = inputname.Text,
age = int.Parse(inputage.Text),
email = inputemail.Text,
password = inputpassword.Text
};
DBConnectivity connectivity = new DBConnectivity();
bool response = connectivity.insertRecord(values);
System.Diagnostics.Debug.WriteLine("added");
if (response)
{
Session["email"] = values.email;
Session["name"] = values.name;
Response.Redirect("~/Dashboard.aspx");
}
}
public SessionsTbl getOneRecord(string email)
{
SqlConnection conn = makeConnection();
conn.Open();
string query = "select * from sessions_tbl where email = '" + email + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
SessionsTbl valuesFromDb = new SessionsTbl();
if (reader.Read())
{
valuesFromDb.id = int.Parse(reader["id"].ToString());
valuesFromDb.name = reader["name"].ToString();
valuesFromDb.age = int.Parse(reader["age"].ToString());
valuesFromDb.email = reader["email"].ToString();
valuesFromDb.password = reader["password"].ToString();
}
conn.Close();
return(valuesFromDb);
}
protected void loginbtn_Click(object sender, EventArgs e)
{
string email = inputemail.Text;
string password = inputpassword.Text;
DBConnectivity connectivity = new DBConnectivity();
SessionsTbl valuesFromDb = connectivity.getOneRecord(email);
if (valuesFromDb.email.Equals(email) && valuesFromDb.password.Equals(password))
{
Session["email"] = valuesFromDb.email;
Session["name"] = valuesFromDb.name;
Response.Redirect("~/Dashboard.aspx");
}
}
public bool insertRecord(SessionsTbl values)
{
SqlConnection conn = makeConnection();
conn.Open();
string query = "insert into sessions_tbl(name, age, email, password) values('" + values.name + "', '" + values.age + "', '" + values.email + "', '" + values.password + "')";
SqlCommand cmd = new SqlCommand(query, conn);
int result = cmd.ExecuteNonQuery();
conn.Close();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}