private void Button1_Click(object sender, EventArgs e)
{
//Approve
if (cmbStatusID.SelectedIndex == 0)
{
int rowIndex = issueRequestGridView.CurrentCell.RowIndex;
DataGridViewRow row = issueRequestGridView.Rows[rowIndex];
int memberID = Convert.ToInt32(row.Cells[1].Value);
int bookID = Convert.ToInt32(row.Cells[3].Value);
int totalCurrentIssues = SelectQueries.CountCurrentIssuedBooks(memberID);
int allowedIssues = SelectQueries.CountMemberIssueLimit(memberID);
//MEMBER IS IN HIS ISSUE LIMIT
if (totalCurrentIssues < allowedIssues)
{
int bookIssueCount = SelectQueries.BookIssuedCount(memberID, bookID, "YES");
int bookIssueLimit = SelectQueries.BookReissueLimitCount(bookID, memberID);
//member is in limit of reissuing current book
if (bookIssueCount < bookIssueLimit)
{
string issueDate = DateTime.Now.Date.ToShortDateString();
string returnDate = issueReturnDate.Value.ToShortDateString();
if (SelectQueries.GetCopiesAvailable(bookID) > 0)
{
InsertQueries.IssueBook(bookID, memberID, issueDate, returnDate, "NO");
UpdateQueries.DecreaseBookQuantitiy(bookID);
UpdateQueries.FinishIssueRequest("APPROVED", Convert.ToInt32(cmbIssueRequestID.SelectedValue.ToString()));
MessageBox.Show("BOOK ISSUED SUCCESSFULLY", "RESULT", MessageBoxButtons.OK, MessageBoxIcon.Information);
ViewIssueRequests();
}
else
{
MessageBox.Show("NO COPIES AVAILABLE IN THE LIBRARY \n " +
"PLEASE WAIT TILL COPIES BECOME AVAILABLE", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else
{
MessageBox.Show("REISSUE LIMIT OF THIS PARTICULAR BOOK REACHED \n " +
"CAN NO MORE ISSUE THIS SAME BOOK", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else
{
MessageBox.Show("ISSUE LIMIT OF MEMBER REACHED \n " +
"CAN NO MORE ISSUE ANY BOOK", "REJECTED", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
//DECLINED
if (cmbStatusID.SelectedIndex == 1)
{
UpdateQueries.FinishIssueRequest("DECLINED", Convert.ToInt32(cmbIssueRequestID.SelectedValue.ToString()));
ViewIssueRequests();
MessageBox.Show("ISSUE REQUEST DECLINED\n ", "DECLINED", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}