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();
}
}
