protected void DetailsViewBook_ItemCommand(object sender, DetailsViewCommandEventArgs e)
{
string idValue = Request.QueryString["name"];
int id = Convert.ToInt32(idValue);
//int rowsAffected = 0;
SqlConnection connectObj = new SqlConnection();
connectObj = WebDbConnection.GetSqlConnection();
connectObj.Open();
string insertQuery = "insert into wms_cart(car_title,car_price,car_special) select boo_title,boo_price,boo_special from wms_books where boo_id=@Id";
SqlCommand cmdInsert = new SqlCommand(insertQuery, connectObj);
cmdInsert.Parameters.AddWithValue("@Id", id);
SqlDataAdapter adapt = new SqlDataAdapter(cmdInsert);
DataTable dt = new DataTable();
adapt.Fill(dt);
/*rowsAffected = cmdInsert.ExecuteNonQuery();
*
* connectObj.Close();
*
* if (rowsAffected > 0)
* {
* lblAddedMessage.Text = "Book Added To Cart";
* }
* else
* {
* lblAddedMessage.Text = "Book Not Added";
* }*/
/*bool result;
* string idValue = Request.QueryString["name"];
* int id = Convert.ToInt32(idValue);
*
* Web webObj = new Web();
* webObj.Id = id;
*
* result = webObj.InsertBook();
*
* if (result == true)
* {
* ScriptManager.RegisterStartupScript(this, GetType(),"ServerControlScript", "alert(\"Book Added To Cart\");", true);
* }
* else
* {
* ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", "alert(\"Book Not Added\");", true);
* } */
}
protected void AdminGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlConnection connectObj = new SqlConnection();
connectObj = WebDbConnection.GetSqlConnection();
connectObj.Open();
int id = Convert.ToInt32(AdminGridView.DataKeys[e.RowIndex].Values["boo_id"].ToString());
string deleteQuery = "delete from wms_books where boo_id=@id";
SqlCommand cmdDelete = new SqlCommand(deleteQuery, connectObj);
cmdDelete.Parameters.AddWithValue("@id", id);
SqlDataAdapter adapt = new SqlDataAdapter(cmdDelete);
DataTable dt = new DataTable();
adapt.Fill(dt);
AdminGridView.DataSource = dt;
AdminGridView.DataBind();
}
