private void Button1_Click(object sender, System.EventArgs e) { string addISBN; string addAuthor; double addPrice; string addTitle; string addDescription; int addCatId; string addPath; string resultAdd; addISBN = txtISBN.Text; addAuthor = txtAuthor.Text; addPrice = double.Parse(txtPrice.Text); addTitle = txtTitle.Text; addDescription = txtDesc.Text; addCatId = int.Parse(listCat.SelectedItem.Value); addPath = txtPath.Text; addNewBook = new WebReference1.sellerAdmin(); resultAdd = addNewBook.addItem(addISBN, addAuthor, addPrice, addTitle, addDescription, addPath, addCatId); if (resultAdd == "Success") { addBookLabel.Text = "Book added to database."; Server.Transfer("adminPage.aspx"); } else { addBookLabel.Text = "Error on insert." + resultAdd; } }
private void changeBooks_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string upISBN = e.Item.Cells[2].Text; string upAuthor = ((TextBox)e.Item.Cells[3].Controls[0]).Text; double upPrice = double.Parse(((TextBox)e.Item.Cells[4].Controls[0]).Text); string upTitle = ((TextBox)e.Item.Cells[5].Controls[0]).Text; string upDescription = ((TextBox)e.Item.Cells[6].Controls[0]).Text; int upCatId = int.Parse(e.Item.Cells[7].Text); string upImage = ((TextBox)e.Item.Cells[8].Controls[0]).Text; myView.RowFilter = "isbn='" + upISBN + "'"; if (myView.Count > 0) { myView.Delete(0); } myView.RowFilter = ""; DataRow dr = Dt.NewRow(); dr["isbn"] = upISBN; dr["author"] = upAuthor; dr["price"] = upPrice; dr["title"] = upTitle; dr["description"] = upDescription; dr["id"] = upCatId; dr["imgSrc"] = upImage; Dt.Rows.Add(dr); changeBooks.EditItemIndex = -1; changeBooks.DataSource = myView; changeBooks.DataBind(); // Now update the database with the new data WebReference1.sellerAdmin newData = new WebReference1.sellerAdmin(); string results; results = newData.updateItem(upISBN, upAuthor, upPrice, upTitle, upDescription, upImage, upCatId); if (results == "Success") { errorLabel.Text = "Book Updated to database!"; } else { errorLabel.Text = results; } }