private void button3_Click(object sender, EventArgs e) { searchbook_button.PerformClick(); if (Borrower != "") { MessageBox.Show("Book is already borrowed by some other Borrower with Borrower ID: \n" + Borrower); return; } SearchB_Button.PerformClick(); if ((Book1 != "") && (Book2 != "")) { MessageBox.Show("Borrower has already borrowed maximum number of books"); return; } cmd = new SqlCommand("Transaction_Update_Books", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@accNo", AccNoTextField.Text); cmd.Parameters.AddWithValue("@borrower", borrower_id.Text); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); try { if (Book1 == "") { cmd = new SqlCommand("Transaction_Update_Book1_SP", con); Book1_label.Text = AccNoTextField.Text; } else { cmd = new SqlCommand("Transaction_Update_Book2_SP", con); Book2_label.Text = AccNoTextField.Text; } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@accNo", AccNoTextField.Text); cmd.Parameters.AddWithValue("@brId", borrower_id.Text); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); MessageBox.Show("Successfully Issued"); Borrowedby_label.Text = borrower_id.Text; }
private void button1_Click(object sender, EventArgs e) { searchbook_button.PerformClick(); SearchB_Button.PerformClick(); if ((AccNoTextField.Text != Book1) && (AccNoTextField.Text != Book2)) { MessageBox.Show("THE INPUTED BOOK HAS NOT BORROWED THE BOOK \n"); return; } try { if (Book1 == AccNoTextField.Text) { cmd = new SqlCommand("Transaction_Update_Book1_SP", con); Book1_label.Text = ""; } else { cmd = new SqlCommand("Transaction_Update_Book2_SP", con); Book2_label.Text = ""; } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@accNo", (object)DBNull.Value); cmd.Parameters.AddWithValue("@brId", borrower_id.Text); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); cmd = new SqlCommand("Transaction_Update_Books", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@accNo", AccNoTextField.Text); cmd.Parameters.AddWithValue("@borrower", (object)DBNull.Value); con.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(" <<<<<<INVALID SQL OPERATION>>>" + ex); } con.Close(); MessageBox.Show("Successfully Returned"); Borrowedby_label.Text = ""; }