protected void btnReturn_Click(object sender, EventArgs e) { lblEMsg.Visible = false; string[] iBook; try { SqlDataReader sdr; Profile pro = new Profile(); //Check if any book is issued for this member. string sql = "SELECT Count(1) FROM Book_Transaction WHERE Member_ID = '" + lstMember.SelectedItem.ToString() + "' And Book_ID = '" + LstBook.SelectedItem.Text + "' And Actual_Return_Date is Null"; sdr = pro.ReturnMDetails(sql); sdr.Read(); int iB = (int)sdr[0]; if (iB == 0) { lblEMsg.Visible = true; lblEMsg.Text = "No Book is issued for this member, please select the correct member"; return; } sdr.Close(); //Insert the data. iBook = new string[4]; iBook[0] = LstBook.SelectedItem.Text; iBook[1] = lstMember.SelectedItem.Text; iBook[2] = txtARDate.Text; iBook[3] = txtLFee.Text; bool status; status = pro.ReturnBook(iBook); if (status == false) { lblEMsg.Visible = true; lblEMsg.Text = "Book Returning Failed"; } lblEMsg.Visible = true; lblEMsg.Text = "Book Returned."; lstMember.Text = ""; LstBook.Text = ""; txtBTitle.Text = ""; txtAuthor.Text = ""; txtPub.Text = ""; txtCat.Text = ""; txtSup.Text = ""; txtRDate.Text = ""; txtIDate.Text = ""; lblName.Text = ""; txtLFee.Text = ""; return; } catch (Exception ex) { lblEMsg.Visible = true; lblEMsg.Text = ex.Message; } }