Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int book_qty = 0;
- SqlCommand cmd2 = connection.CreateCommand();
- cmd2.CommandType = CommandType.Text;
- cmd2.CommandText = "SELECT * FROM Book_list WHERE BookName = '" + TextBoxBookName + "'";
- cmd2.ExecuteNonQuery();
- DataTable dt2 = new DataTable();
- SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
- da2.Fill(dt2);
- foreach (DataRow dr2 in dt2.Rows)
- {
- book_qty = Convert.ToInt32(dr2["book_qty"].ToString());
- }
- if (book_qty > 0)
- {
- SqlCommand cmd = connection.CreateCommand();
- cmd.CommandType = CommandType.Text;
- cmd.CommandText = "INSERT INTO Issue_book VALUES(" + TextBoxSearchMembers.Text + ",'" + TextBoxMemberName.Text + "','" + TextBoxMemberContact.Text + "','" + TextBoxMemberEmail.Text + "','" + TextBoxBookName.Text + "', '" + DateTimePicker1.Text + "')";
- cmd.ExecuteNonQuery();
- SqlCommand cmd1 = connection.CreateCommand();
- cmd1.CommandType = CommandType.Text;
- cmd1.CommandText = "UPDATE Book_list SET BookAvailability = BookAvailability-1 WHERE BookName ='" + TextBoxBookName.Text + "'";
- cmd1.ExecuteNonQuery();
- MessageBox.Show("successful issue");
- this.Close();
- else
- {
- MessageBox.Show("Book not available");
- }
Add Comment
Please, Sign In to add comment