protected void btnDelete_Click(object sender, EventArgs e)
{
lblEMsg.Visible = false;
Profile pro = new Profile();
try
{
if (lstbook.SelectedItem.ToString() == "")
{
lblEMsg.Text = "Please select Book No";
lblEMsg.Visible = true;
}
else
{
bool status;
status = pro.DeleteBook(lstbook.SelectedItem.ToString());
if (status == false)
{
lblEMsg.Visible = true;
lblEMsg.Text = "Book deletion Failed";
}
lblEMsg.Visible = true;
lblEMsg.Text = "Book deleted.";
lstbook.Items.Clear();
//Load all the Publisher First.
string sql = "SELECT Book_ID FROM Book_Master where Status = 'A'";
SqlDataReader sdr;
sdr = pro.ReturnMDetails(sql);
lstbook.Items.Add("");
while (sdr.Read())
{
lstbook.Items.Add(sdr["Book_ID"].ToString().Trim());
}
sdr.Close();
txtBTitle.Text = "";
LstAuthor.Text = "";
LstCategory.Text = "";
LstPublisher.Text = "";
LstSupplier.Text = "";
txtKey.Text = "";
txtIsbn.Text = "";
txtQuantity.Text = "";
txtPrice.Text = "";
chkStatus.Checked = false;
lblEMsg.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
