private void retrn_Click(object sender, EventArgs e)
{
try
{
MySqlConnection mcon = new MySqlConnection("datasource=localhost;port=3306;username=root;password=;database=Lms");
MySqlDataAdapter msd = new MySqlDataAdapter("select count(*) from borrow_history where Book_Id='" + book_id.Text + "'", mcon);
mcon.Open();
// MySqlDataAdapter msd = new MySqlDataAdapter("delete from book_details where Book_Id='"+textBox1.Text+"'", mcon);
DataTable dt = new DataTable();
MySqlCommand cmd = mcon.CreateCommand();
cmd.CommandType = CommandType.Text;
msd.Fill(dt);
// if (mcon.State == ConnectionState.Open)
if (dt.Rows[0][0].ToString() == "1")
{
cmd.CommandText = "delete from borrow_history where Book_Id='" + book_id.Text + "'";
cmd.ExecuteNonQuery();
MessageBox.Show("Book Return Done....");
}
else
{
MessageBox.Show("Book_Id does not found for Return!!!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
book_id.Clear();
user_name.Clear();
Borrow_date.Clear();
return_date.Clear();
CDate.Clear();
fine.Clear();
}
