protected void btnDelete_Click(object sender, EventArgs e) { //DataTable bookInformation = new DataTable(); //try //{ // conn = new SqlConnection(SQLConnectionString.getConnectionString()); // command = new SqlCommand(); // command.Connection = conn; // string storedProc = "spDeleteBook"; // command.CommandText = storedProc; // command.CommandType = CommandType.StoredProcedure; // command.Parameters.AddWithValue("@Title", ddlBooksList.SelectedItem.Text.ToString()); // conn.Open(); // command.ExecuteNonQuery(); //} //catch (SqlException sqlErr) //{ // Debug.Write(sqlErr.Message); // Debug.Write(sqlErr.StackTrace); //} //catch (Exception excpt) //{ // Debug.Write(excpt.Message); // Debug.Write(excpt.StackTrace); //} //finally //{ // conn.Close(); //} DatabaseProcedures db = new DatabaseProcedures(); db.Delete(ddlBooksList.SelectedItem.Text.ToString()); }
protected void btnEdit_Click(object sender, EventArgs e) { DatabaseProcedures db = new DatabaseProcedures(); db.Update(ddlBooksList.SelectedItem.Text.ToString(), txtBookAuthor.Text.ToString(), txtShortDescription.Text.ToString(), txtLongDescription.Text.ToString(), txtImageFile.Text.ToString(), Convert.ToInt32(txtCategoryID.Text), txtISBN.Text.ToString(), txtBookStatus.Text.ToString(), txtRating.Text.ToString(), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToDecimal(txtPreOrder.Text), Convert.ToInt32(txtDiscount.Text.ToString()), (txtPrintLength.Text.ToString()), Convert.ToInt32(txtQuantity.Text.ToString())); /* * conn = new SqlConnection(SQLConnectionString.getConnectionString()); * * string storedProcedureName = "spUpdateBookInformation"; * SqlCommand cmd = new SqlCommand(storedProcedureName, conn); * cmd.CommandType = CommandType.StoredProcedure; * //cmd.Parameters.AddWithValue("@Id", 2); * cmd.Parameters.AddWithValue("@Title", ddlBooksList.SelectedItem.Text.ToString()); * cmd.Parameters.AddWithValue("@Author", txtBookAuthor.Text.ToString()); * conn.Open(); * cmd.ExecuteNonQuery(); * conn.Close();*/ }
private void updateBookImagePanel() { try { SqlDataReader dataReader = (SqlDataReader)DatabaseProcedures.GetProductsByCategory((ddlBookName.SelectedItem.Text.ToString().Trim()), conn); while (dataReader.Read()) { lblBookTitle.Text = dataReader["Title"].ToString(); lblUnitPrice.Text = "$" + dataReader["UnitPrice"].ToString(); lblShortDescription.Text = dataReader["ShortDescription"].ToString(); lblLongDescription.Text = dataReader["LongDescription"].ToString(); lblBookAuthor.Text = dataReader["Author"].ToString(); lblBookRating.Text = dataReader["Rating"].ToString() + " stars"; imgBookImage.ImageUrl = "../images/books/computer_books/" + dataReader["ImageFile"].ToString().Trim(); lblDiscount.Text = dataReader["Discount"].ToString() + "%"; lblPreorder.Text = "$" + dataReader["PreOrderPrice"].ToString(); lblPrintLength.Text = dataReader["PrintLength"].ToString() + " pages"; } dataReader.Close(); conn.Close(); } catch (SqlException sqlErr) { //Response.Write(sqlErr); Debug.Write(sqlErr.Message); } catch (Exception excpt) { Debug.Write(excpt.StackTrace); } finally { conn.Close(); } }