protected void Btn_Submit_Click(object sender, EventArgs e) { using (BookSaleEntities Entities = new BookSaleEntities()) { /*check database whether the user already exists*/ if (Entities.Users.FirstOrDefault(u => u.username.ToLower() == TxtUserName.Text.ToLower()) != null) { pnlUserNameError.Visible = true; } else { User user = new User(); user.username = TxtUserName.Text; user.password = PasswordHash.CreateHash(TxtPassword.Text); user.email_id = TxtEmailId.Text; user.phone_number = TxtPhoneNumber.Text; Entities.Users.Add(user); Entities.SaveChanges(); Response.Redirect("index.aspx"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { pnlNegotiateCostHigher.Visible = false; pnlNegotiateCostLower.Visible = false; using (BookSaleEntities Entities = new BookSaleEntities()) { Book book = Entities.Books.Find(int.Parse(Request["bid"])); /*only one maximum negotiation amount will be shown to the owner of the book, * so check the amount entered by the user to be higher than the current negotiationcost*/ if (int.Parse(TxtNegotiateCost.Text) > book.NegotiatingCost) { if (int.Parse(TxtNegotiateCost.Text) > book.Cost) { book.NegotiatingCost = int.Parse(TxtNegotiateCost.Text); string username = Session["UserName"].ToString(); book.Negotiator = Entities.Users.First(u => u.username == username); Entities.SaveChanges(); Response.Redirect("buy.aspx"); } else { pnlNegotiateCostLower.Visible = true; } } else { pnlNegotiateCostHigher.Visible = true; lblNegotiate.Text = book.NegotiatingCost.ToString(); } } }
protected void grdYourBookSale_RowDeleting(object sender, GridViewDeleteEventArgs e) { /*delete the selected booksale row from the grid*/ using (BookSaleEntities Entities = new BookSaleEntities()) { int bookId = Convert.ToInt32(grdYourBookSale.DataKeys[e.RowIndex].Values["id"]); Book book = Entities.Books.FirstOrDefault(u => u.id == bookId); Entities.Books.Remove(book); Entities.SaveChanges(); } //refresh the grid Response.Redirect("sell.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { /*add the new book in the table*/ using (BookSaleEntities Entities = new BookSaleEntities()) { Book objBookSale = new Book(); string username = Session["UserName"].ToString(); objBookSale.Owner = Entities.Users.First(u => u.username == username); objBookSale.Department = Entities.Departments.Find(Int64.Parse(RadioListDepartment.SelectedValue)); objBookSale.BookName = TxtBookName.Text; objBookSale.Cost = int.Parse(TxtCost.Text); objBookSale.NegotiatingCost = 0; Entities.Books.Add(objBookSale); Entities.SaveChanges(); } //redirect to the updated suppliers list Response.Redirect("home.aspx"); }