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 = "";
}
