protected async void btnSumbit_Click(object sender, EventArgs e) { string text = (String)Session["bookID"]; var result = await service.Volumes.Get(text).ExecuteAsync(); DataModels.CreatePost cp = new DataModels.CreatePost(); cp.title = result.VolumeInfo.Title; cp.bookID = result.Id; cp.price = float.Parse(txtPrice.Text); cp.condition = DropDownCondition.Text; DataModels.Users tempUser = (DataModels.Users)Session["user"]; int id = tempUser.userID; DataTiers.postTier pt = new DataTiers.postTier(); try { pt.insertPost(cp, id); } catch (Exception ex) { Console.WriteLine(ex.Message); Response.Redirect("CreatePost3.aspx"); } Session.Remove("bookID"); if (!Response.IsRequestBeingRedirected) { Response.Redirect("Success.aspx"); } }
protected void btnSignIn_Click(object sender, EventArgs e) { DataTiers.passwordHash ph = new DataTiers.passwordHash(txtPassword.Text); DataTiers.userTier ut = new DataTiers.userTier(); DataModels.Users user = new DataModels.Users(); user.email = txtUserName.Text; user.username = txtUserName.Text; try { Tuple <string, string> temp = ut.login(user); if (ph.Verify(temp.Item1, temp.Item2, txtPassword.Text)) { user = ut.getInfo(user); Session["User"] = user; Session["ID"] = user.userID; Response.Redirect("MyAccount.aspx"); } else { Label1.Text = "Incorrect password or email"; } } catch (Exception ex) { Label1.Text = "Incorrect password or email"; Console.WriteLine(ex.Message); } }
protected void btnSumbit_Click(object sender, EventArgs e) { DataTiers.passwordHash ph = new DataTiers.passwordHash(txtPassword.Text); DataTiers.userTier ut = new DataTiers.userTier(); DataModels.Users user = new DataModels.Users(); user.email = txtEmail.Text; user.username = txtUsername.Text; user.salt = ph.Salt; user.hash = ph.Hash; user.major = txtMajor.Text; try { if (ut.userExist(user) == false) { ut.insertUser(user); Response.Redirect("Success.aspx"); } else { // lblError.Text = "<strong>Warning: </strong>The username or email already exists"; CustomValidator1.ErrorMessage = "<strong>Warning: </strong>The username or email already exists"; CustomValidator1.IsValid = false; } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private void GetData() { DataModels.Users tempUser = (DataModels.Users)Session["user"]; DataTable table = new DataTable(); // get the connection using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MyData"].ToString())) { // write the sql statement to execute string query = "SELECT posts.PostID, posts.Title, posts.Condition, posts.Price FROM posts where posts.userID = '" + tempUser.userID + "'"; // instantiate the command object to fire using (MySqlCommand cmd = new MySqlCommand(query, conn)) { // get the adapter object and attach the command object to it using (MySqlDataAdapter ad = new MySqlDataAdapter(cmd)) { // fire Fill method to fetch the data and fill into DataTable ad.Fill(table); } } } // specify the data source for the GridView GridView1.DataSource = table; // bind the data now GridView1.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { DataTiers.postTier pt = new DataTiers.postTier(); DataModels.CreatePost post = (DataModels.CreatePost)Session["thePost"]; DataModels.Users tempUser = (DataModels.Users)Session["user"]; int id = tempUser.userID; try { pt.insertPost(post, id); } catch (Exception ex) { Console.WriteLine(ex.Message); Response.Redirect("createPost.aspx"); } Session.Remove("thePost"); Response.Redirect("Success.aspx"); /* * string query = "INSERT INTO posts (title, author, course, department) " + * "VALUES ('" + lblTitle.Text + "','" + lblAuthor.Text + "','" + lblCoarse.Text + "','" + lblDepartment.Text + "');"; * * MySqlCommand cmd = new MySqlCommand(query,conn); * * conn.Open(); * cmd.ExecuteNonQuery(); * conn.Close(); */ }
protected void Page_Load(object sender, EventArgs e) { DataModels.Users tempUser = (DataModels.Users)Session["user"]; lblUsername.Text = tempUser.username; lblEmail.Text = tempUser.email; lblMajor.Text = tempUser.major; if (!IsPostBack) { GetData(); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { DataModels.Users tempUser = (DataModels.Users)Session["user"]; MySqlCommand cmd = new MySqlCommand("Update posts set posts.Condition = '" + e.NewValues[2] + "', Price = '" + float.Parse(e.NewValues[3].ToString()) + "' where posts.postID = '" + e.NewValues[0] + "'", conn); conn.Open(); cmd.ExecuteNonQuery(); GridView1.Rows[e.RowIndex].Cells[1].Visible = true; GridView1.EditIndex = -1; GetData(); conn.Close(); }